Requests
3
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Network Power<100 people
Roles
💸100%
Marketing
✔️100%
IT
📝100%
Influencer or Blogger
Geos
🇷🇴100%
Romania
Work Background
easyJetData Engineer
Feb. 2015Luton, United Kingdom• Responsible for the delivery of data ingestion pipelines for loading data into the enterprise data lake stored in HDFS from various sources like SQL Server, AWS S3 buckets and FTP Servers.
• Responsible for the delivery of a metadata driven framework to load data into the enterprise data lake stored in HDFS and parse the raw data based on various input file patterns and persist a refined version of the data set with using performance optimization techniques to be consumed by downstream systems and business users
• Developed Spark Programs in Python to perform data transformation, creating data frames and running Spark SQL. Worked on creation of batch and real-time data for data ingestion and data products.
• Responsible for surfacing the data stored on HDFS in Hive using both internal and external tables with applying performance optimization techniques like partitioning and parquet compression for end user consumption.And upload the metadata information into Cloudera Navigator using API’s and Scala.
• Creation of oozie Xml’s and executing workflows and coordinators on the Cloudera platform.
• Developed a generic data ingestion framework of loading data into a temporary landing area of the data lake stored in HDFS from Amazon S3 Buckets. By creating generic but modularized bash scripts, data ingestion pipelines remained flexible.
• Responsible for the delivery of Oozie workflows and coordinators to schedule and execute end to end ingestions of data pipelines with features like email notification in case of failure and parallel action execution for performance improvements.
• Responsible for the delivery of knowledge transfer sessions on structural and technical aspects of the end to end data ingestion and deployment process to other members of the delivery team and also using on CI/CD environment using Jenkins and GIT Reprository for Code merging • Creation of Single property file to remove the duplication of multiple config files across all the environments.
easyJetBI Developer
Feb. 2015 - Jan. 2018• Responsible for the delivery of ETL solutions in order to load data from either an integration layer or files stored locally into the enterprise data warehouse, creation of new databases to load data from new sources and write reporting views as well as canned reports in order to meet end user requirements and enable business consumption of the data.
• Responsible for the delivery of standard BI change request such as changes to existing ETL packages, tables, stored procedures, triggers and follow them through the full development life-cycle and deployment process.
• Developed good relationships with key business owners and other teams, notably development, testing, architecture and service delivery.
• Worked closely with the relevant architectural teams to ensure technical governance and standards are applied across all development work.
• Tuned SSIS packages for better performance by using fast loading and buffer space techniques.
• Master Data Services Design, Development, Unit-Testing, Deployment and Documentation. And Master Data Services migration. MDS Model creations and give permissions to the users.
• Designed and developed Cubes for data analysis (SSAS), building hierarchies and attribute relationships for optimal MDX query performance of Hierarchies and Fact dimensions.
• Designed Perspectives, KPI’s, Calculations, Partitions and Tuning aggregations in SSAS development and training operational users for browsing.
• Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.
• Designed, Created and deployed 100 SSRS reports at the end-user requests by using Web-interface in SQL Server Reporting Services (SSRS).
• Performed maintenance tasks rebuilding / reorganising indexes, update statistics and performed database health checks in regular intervals.
• Responsible for following version control practices, strict enterprise deployment processes and working with off-shore and on-shore developers in a collaborative manner.
BITE Consulting Group Ltd.SQL DBA / BI DEVELOPER Freelance
Jan. 2015 - Mar. 2015London, United Kingdom
Four ace limitedSQL DBA\BI DEVELOPER
May. 2013 - Nov. 2014UK• Install and configure MS SQL Server 2008&R2/ 2012 with BI stack (SSIS, SSAS & SSRS).
• Developing and deploying ETL SSIS Packages for data integration and data loaded in to different SQL Server instances and scheduled a job with SQL server agent for regular updates. • Designed SSIS package event handler to get notification on package execution process. Provided Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
• Designing and Implementing OLTP, building hierarchies and attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions. Reporting and Data Warehouse databases.
• Developed Data Source view (DSV), Identified fact tables and database dimensions with analysis services project template in BIDS environment.
• Developed datasets by gathering required report fields, writing performance based T-SQL queries in OLTP and OLAP (MDX queries) environment. • Developed Perspectives, KPI’s, and Calculations in SSAS development and training operational users for browsing. Partitions, tuning aggregations and Usage Based Optimization (UBO) mechanisms for OLAP databases. • Developed roles for users on individual SSIS package level security. Upgraded SSIS packages from SQL Server 2005, SQL Server 2008 to SQL Server 2012. Performed tuning operations on SSIS packages for better performance. • Worked on Installation, Configuration and of SQL Server reporting services (SSRS). Extensively worked on data sets, Parameters, Filters, expressions in report development.
• Created parameters to filter data, vary appearance and connect to related reports.
• Developed Dashboards, Ad-hoc reports, Drilldown reports, drill through reports, with various report tools (like table, matric, chart, bar, pie chart and gauge) in SSRS. • Provided reports security by creating roles for users/groups • Performed cache and snapshot tuning techniques to improve report performance in SSRS.
carhosis limitedSQL BI/DBA DEVELOPER
Apr. 2012 - Apr. 2013London, United Kingdom• Designing and Implementing OLTP, reporting and Data Warehouse databases.
• Developing and deploying ETL SSIS Packages for data migration.
• Developing and deploying ETL SSIS Packages for data integration and data loaded in to different SQL Server instances. • Deployed package in to SSIS and scheduled a job with SQL server agent for regular updates. • Designed SSIS package event handler to get notification on package execution process.
• Developed roles for users on individual SSIS package level security.
• Studied existing OLAP system(s) and identified fact tables/measure groups, dimensions and star schema representation for data warehouse systems in SSAS.
• Develop MDX query for cube browsing as per business requirement.
• Partitions, tuning aggregations and Usage Based Optimization (UBO) mechanisms for OLAP databases.
• Deployed SSAS packages using different deployment procedures.
• Involved in up-gradation from SQL Server 2005 to SQL Server 2008/2008R2, dealing with patches (hot- fix’s) and service pack updates
• Worked on Installation, Configuration and of SQL Server reporting services (SSRS).
• Developed gauge reports in BIDS environment to analyze trend of business.
• Created alerts, schedule and monitor jobs, also creating maintenance plan for databases.
• Implementing and maintaining Transactional and Merge Replication.
• Extensively worked on data sets, Parameters, Filters, expressions in report development.
• Report fields linked from different data sets and provided dynamic actions in SQL server reporting services (SSRS). • Writing Stored procedures, Functions, Views and T-sql queries for the business needs.
• Performed health checks with DBCC commands, organizing shrink operations to release empty buffer space at regular intervals.
• Analyze long running queries and tune the same to optimize application and system performance. Proactively monitoring and maintaining SQL Servers.
Intch is a Professional Networking App for the Future of WorkSee more people like Satish on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
445112 people
16
SHEQ & Training Coordinator @ M Group Telecom
16
Project Manager @ Vodafone
15
Wellness and Health Specialist
133324 people
15
Wellness and Health Specialist
22
HR Specialist
16
Brand ambassador