Profile Summary:

• Extensively worked in SSIS Transformations like Lookup, Aggregate, Cache, character Map, Conditional Split, SCD, Data Conversion, Derived column, script component, pivot.
• An expert in creating, configuring and fine-tuning ETL workflows designed in SQL Server Integration Services.
• Experience in Database Maintenance, taking Database Backup/ Restore, Trim Log Files.
• Experience in writing T-SQL queries, Rank functions, CTE and derived table.
• Extensive experience in creating Tables, Views, Indexes, writing Stored Procedures, Triggers using T-SQL DML and DDL as well as analyzing and debugging existing complex stored procedures.
• Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Extensively used tools like SQL Profiler, Database Engine Tuning Advisor, Activity Monitor and Windows
• Expertise in SQL Server 2005/2008/2012, Business intelligence tools like Integration Services, Analysis Services and Reporting Services.
• Over 7 years of extensive work experience as an ETL Developer and in depth proficient experience in OLTP, Dimension Modeling, Data warehouse, T-SQL, OLAP and Database technologies.
• Extensive experience in creating ETL solutions with different data sources like RDBMS, Flat file, XML, Excel.
• Experience in creating master and child packages, package configurations, logging and Error handling.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages using SQL Server Job Agent and Windows Scheduled task.
• Experience in command line execution of SSIS Package.
• Expertise in SSIS Package deployment using Package configuration in Production.
• Expertise in developing SSAS Cube for business requirement.
• Created and Configured Data Source Data Source Views, Dimensions, Cubes, Calculated Measures, Hierarchy, Partitions and KPI's using SQL Server 2005/2008 Analysis Services.
• Experience in analyzing data and creating Facts and Dimension tables.
• Expertise in Dimension Modelling.
• Experience in Creating MDX query for Calculated member, KPI's, SSRS reports.
• Experience in taking cube backup and restore.
• Experience in generating drill down reports, parameterized reports, matrix, charts in SSRS 2005/2008.
• Experience in Log Shipping and Database Mirroring.
• Experience in creating Transformations using the Pentaho data integration tool.
• Experience in creating job using the Pentaho data integration tool.
• Extensively Worked in Pentaho Transformation tasks like Mongo DB Input, Json Input, Table output, Modified Java Script etc.
• Good Exposure to MongoDB database.
• Good Exposure to Reporting tool like OBIEE and Cognos.
• Coordinated in requirements gathering effort to assure that client's business needs are understood.
• Good team player, strong interpersonal combined with self-motivation, initiative and the ability to think outside the box.
• Ability and open to learn new technology in a short time and work in it.

Skill Summary:

Professional Experience:

Confidential

Role: Sr. BI developer

Responsibilities:

• Designed ETL processes using Pentaho Kettle to extract the data from Mongo DB and to load the data into the target SQL database.
• The Transformation includes extracting Mongo DB data in to JSON and the using Modified Java Script task applied the business rules and loaded in SQL table.
• Created Job from multiple Kettle transformations.
• Created scheduled job in Windows Task scheduler.
• Implementation of the application on Production Server.
• Monitoring the ETL on daily basis.
• Involved in fixing issue when the scheduled job fails.
• Provide production support to this project by solving data issues raised by the users

Environment: Pentaho Data Integration, T-SQL, Ubuntu, MongoDB.

Confidential

Role: Sr. BI developer

Responsibilities:

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts to gather the requirements.
• Designed Dimension model, Facts and Dimension tables using Star schema.
• Created Entity Relation ER diagram.
• Implemented a complex logic to download the files from SFTP using script task in C and the script used in Execute process task in SSIS.
• Optimized complex T-SQL queries for better performance.
• Implemented a fully automated complex alert mailing system in SSIS as per the business requirement.
• Created SSIS package to Consolidate flat files from different sources and encrypted using GnuPG.
• Implemented Error handling and Custom Logging to keep track of Package flow and Package Execution status.
• Deployed SSIS package using XML Package configuration in Production.
• Created command line execution of the package in a bat file and scheduled it in a Windows Scheduled task.
• Interacted with developers, Business Management Teams and End Users.

Environment: SQL server 2008, T-SQL, SSIS, Windows Server 2008.

Confidential

Role: Sr. BI developer

Responsibilities:

• Involved in Requirement gathering and designing data model.
• Created Entity Relation ER diagram.
• Implemented a logic in C code to download and parse JSON files through web API in SSIS.
• Created SSIS task to archive the flat files and move to the archive folder.
• Created complex T-SQL using Rank function and CTE.
• Created constraints and validated database integrity.
• Deployed SSIS package using XML Package configuration in Production.
• Created command line execution of the package in a bat file and scheduled it in a Windows Scheduled task.
• Designed Dimension model, Facts and Dimension tables using Star schema.
• Review and Testing the Packages.
• Involved in fixing issues when the scheduled job fails.
• Interacted with developers, Business Management Teams and End Users.
• Participated in regular project status meetings.

Environment: SQL server 2008, T-SQL, SSIS, Windows Server 2008.

Confidential

Role: ETL BI developer

Responsibilities:

• Understand requirements as stated in the Business Requirement document.
• Analyze the data for the business requirement.
• Designed ETL processes using SSIS to extract the data from flat file and to load the data into SQL server.
• Analyzed the data and created Fact and Dimension tables.
• Designed and created OLAP cubes.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services SSAS .
• Designed the dimensions and relationship between dimensions and measure groups
• Created user Hierarchy and given attribute relationships in dimensions.
• Created calculated members in the cube using MDX.
• Created partitions and Aggregations.
• Interacted with developers, Business Management Teams and End Users.
• Participated in regular project status meetings.

Environment: SQL server 2008, T-SQL, SSAS, SSIS, Windows Server 2008.

Confidential

Role: ETL BI developer

Responsibilities:

• Involved in Requirement gathering and designing data model.
• Created Entity Relation ER diagram.
• Designed ETL processes using SSIS to download flat files from SFTP and extracts the data from flat files, and to load the data into the target database.
• Created SSIS task to archive the flat files and move to the archive folder.
• Implemented Error handling and Logging to keep track of Package flow and Package Execution status.
• Created complex Stored Procedures and Functions.
• Created complex T-SQL using Rank function and CTE.
• Created constraints and validated database integrity.
• Designed rich text Email report format using C in Script task and send Execution Status and Execution Summary including Rows Inserted and Rows Updated
• Deployed SSIS package using XML Package configuration in Production.
• Created command line execution of the package in a bat file and scheduled it in a Windows Scheduled task.
• Designed Dimension model, Facts and Dimension tables using Star schema.
• Review and Testing the Packages.
• Involved in fixing issues when the scheduled job fails.
• Interacted with developers, Business Management Teams and End Users.
• Participated in regular project status meetings.

Environment: SQL server 2008, T-SQL, SSIS, Windows Server 2008.

Confidential

Role: ETL BI developer

Responsibilities:

• Involved in Requirement gathering and designing data model.
• Created Entity Relation ER diagram.
• Designed ETL processes using SSIS to download flat files from SFTP and extracts the data from flat files, and to load the data into the target database.
• Created SSIS task to archive the flat files and move to the archive folder.
• Created complex Stored Procedures and Functions.
• Created complex T-SQL using Rank function and CTE.
• Created constraints and validated database integrity.
• Deployed SSIS package using XML Package configuration in Production.
• Created command line execution of the package in a bat file and scheduled it in a Windows Scheduled task.
• Designed Dimension model, Facts and Dimension tables using Star schema.
• Review and Testing the Packages.
• Involved in fixing issues when the scheduled job fails.
• Interacted with developers, Business Management Teams and End Users.
• Participated in regular project status meetings.

Environment: SQL server 2008, T-SQL, SSIS, Windows Server 2008.

Confidential

Role: ETL BI developer

Responsibilities:

• Understand requirements as stated in the Business Requirement document.
• Analyze the data for the business requirement.
• Designed ETL processes using SSIS to extract the data from Oracle Source and to load the data into SQL server.
• Analyzed the data and created Fact and Dimension tables.
• Designed and created OLAP cubes
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services SSAS .
• Designed the dimensions and relationship between dimensions and measure groups
• Created user Hierarchy and given attribute relationships in dimensions.
• Created calculated members in the cube using MDX.
• Created partitions and Aggregations.
• Setup http access in IIS to import the SSAS cube into OBIEE for reporting.
• Processing the cube in weekly basis.
• Taking cube backup on a regular basis for maintenance.
• Interacted with developers, Business Management Teams and End Users.
• Participated in regular project status meetings.

Environment: SQL server 2008, T-SQL, SSAS, SSIS, Windows Server 2008.

Confidential

Role: ETL Developer

Responsibilities:

• Requirement gathering, analysis and data modeling.
• Created SSIS packages to copy the different source files from FTP site and load into SQL Server 2008.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
• Implemented Error handling techniques.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Created the SSIS packages using different transformations Data conversion derived Column, Lookup union All, Slowly Changing Dimension.
• Developed Multidimensional Objects Cubes, Dimensions using SQL Server Analysis Services SSAS .
• Designed Dimensional Modeling using SSAS packages for End-User.
• Created Hierarchies in Dimensional Modeling.
• Developed Aggregations, partitions and calculated members for cube as per business requirements
• Wrote SQL queries and stored procedures to generate data for reports
• Created Non-Clustered indexes to improve query performance and query optimization.
• Interacted with developers, Business Management Teams and End Users.
• Participated in regular project status meetings.

Environment: SQL server 2005, T-SQL, SSIS, Windows Server 2003.