SUMMARY

• Over 9 years of experience in Analysis, Design and Development of large Data Warehousing & Business Intelligence solutions and products.
• Have end to end experience of product development from the requirements specification stage till acceptance testing and go - live.
• Involved in designing Extract, Transform and Load mapping sheets, also prepared technical design documents.
• Very good understanding on Kimball’s and Inmon’s theories.
• Very good understanding on OLTP & OLAP systems.
• Extracted, transformed and loaded data using SSIS and Informatica.
• Good experience on creating SSIS package design, construction and deployment.
• Developed SSIS Packages using SCD, Merge, Look-up, Derived Column, Data Conversion Transformation, Conditional Split Transformation etc.
• Have experience in developing various kinds of SSRS reports like Matrix, Drilldown, Drill-through, Linked, Parameterized Sub-reports and Dashboards reports.
• Extensively worked on Microsoft SQL Server using T-SQL Queries Stored Procedures, Functions Indexes, Triggers, Dynamic SQL, Functions, and Views.
• Proficient in identifying the performance bottlenecks in Stored Procedure and SSISpackages as well as to troubleshoot a data/logical bug.
• Have experience in supporting Build related Database activities, like generating T-SQL patches for Staging to UAT and Production.
• Also have experience in preparing and reviewing the deployment notes for the database and ETL deployments.
• Experience in Package Logging, Error Logging & Event Handling to redirect the error & fix the errors in SSIS.
• Experienced in Developing, Deploying and Scheduling the ETL packages in the Production & UAT environments.
• Experience in working in On-site & off-shore model.
• Good experience on leading & mentoring teams and adhering to SDLC, PDLC and Agile processes.
• Having excellent Communication, Analytical and Problem solving skills.
• Ability to work in a team environment as well as independently.

TECHNICAL SKILLS

Languages: SQL, T-SQL

RDBMS: SQL Server 2000/ 2005/2008/2012, Oracle

ETL: MS-SSIS 2005/2008/2012, Clover ETL, Pentaho, Informatica PC/PM

Software Engineering: E-R Diagrams

Web Technology: HTML, XML

Configuration Management: Visual source safe and SVN.

Operating Systems: Windows-2003, Windows-XP, Windows-Vista, Windows-7, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Dublin, CA

Technical Lead

Responsibilities:

• Involved in designing of complex ETL solution based on the Customer need which involves various stages of the data flow from Flat File
• SQL server source to staging area, cleansing the data, loading to the fact tables and then aggregating the data for reporting purpose.
• These ETL involve various transformations like SCD, Merge, Look-up, derived column, data conversion, multicast, union all transformations etc.
• Re-engineering the legacy ETL code to improve the performance of the code and also for easy maintenance. Also written ETL packages using SSIS.
• Design and unit test the reports using SSRS.
• Also re-engineered the legacy ETL process by designing the enhancements to include; bad data management & email notification (failure & success), effective logging, improving the performance.
• Review the code written by team and making recommendations with respect to performance and standards.
• Attending the regular meetings with clients to understand the requirements.
• Responsible for the quality deliverables.
• Provide technical support for the team.
• Work breakdown and assigning the work to the team.
• Preparing the design document based on the requirements.
• Implementing and enforcing the process to the project.

Environment: MS-SQL Server 2012 (SSIS, SSRS), TSQL, Visual Studio 2010.

Confidential, Sacramento, CA

Sr. DB & MSBI Developer

Responsibilities:

• Requirements analysis and documenting the Technical specifications.
• Prepared the Design & Process Flow Documentation for development of ETL Process to get source data from various sources.
• Responsible for implementing the ETL solutions using SQL Server Integration Services
• Participating actively on Clients Calls, meetings with Project Manager to discuss and produce alternatives of problems.
• Taking the responsibilities of the overall tasks and guided the team to have very good understanding on project’s requirement and Business for delivering the work as committed.
• Involved in scheduling the ETL process, Error Handling and email notifications
• Involved in Unit Test case & integration test case preparation and guided the team to do unit testing after initial development with prepared test cases.
• Provided the support to on-site coordinator in US time zones to reach the time lines.
• Responsible for writing T-SQL queries, Stored Procedures, User-define-Functions and creating views, Indexes and Dynamic Queries.
• Improving the performance in database side to display the Geometric data on Maps, Reports & Graphs in application quickly.
• Discussions with Services Team & Application Team to create and update database Objects for the new requirements.

Environment: SSIS, SQL Server 2012

Confidential, Sacramento, CA

DB & MSBI Developer

Responsibilities:

• Effectively participated in client calls for requirements gathering.
• Discussed with business stake holders in confirming the design approaches and the ETL strategies.
• Involved in design changes to the existing Dimension Model.
• Defined ETL strategies and updated the mapping specifications as per the design changes.
• Developed the ETL packages using MS SSIS for different dimension, fact and aggregate table loads.
• Reviewed the ETL packages and produced the review records.
• Designed the approaches for report generation using MS SSRS.
• Provided technical solutions to the team and mentored in completion of the SSIS packages and SSRS reports.
• Applied performance tuning techniques to the SSIS packages.
• Prepared the integration test case documents.
• Executed the test cases and documented and interpreted the test results.
• Involved in preparing the design and deployment documents.
• Closely worked with the deployment teams in providing walk through during releases.
• Prepared the release artifacts and participated the release review presentations.

Environment: MS-SQL Server 2008, DB2, MS-SSIS, Windows Server 2003, MS-SSRS

Confidential, Sacramento, CA

ETL Developer

Responsibilities:

• Gathered and analyzed the requirements from various business stake holders.
• Designed and developed the logical data model using Visio.
• Created the physical data model on MS SQL Server database.
• Designed and developed the data load process for different entities of this mini dimension model using MS SSIS.
• Defined the ETL strategies, approach and load process.
• Prepared the ETL mapping specifications documents.
• Participated in writing T-SQL programming and building ETL packages using Ms SSIS.
• Performed performance tuning of SSIS packages and applied SQL query tuning.
• Involved in preparing Test cases, and Test scripts.
• Prepared design, test and deployment artifacts.
• Involved in execution of Test cases and documenting and interpreting the test results.
• Prepared the release artifacts and participated the release review presentations.

Environment: MS SQL Server 2005, MS-SSIS, Windows Server 2003

Confidential, Iselin, NJ

SQL Server Developer

Responsibilities:

• Actively involved in different stages of Project Life Cycle.
• Documented the data flow and the relationships between various entities.
• Actively participated in gathering of user requirement and system specification.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2008.
• Created Clustered and Non-Clustered Indexes for improving performance.
• Designing and building data load procedures, using MS SQL Server SSIS
• Created Tables, Views and Indexes on the Database, Roles and maintained Database Users.
• Followed and maintained standards and best practices in database development.
• SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, ExecuteSQLTask
• Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Provided assistance to development teams on Tuning Data, Indexes and Queries.
• Implemented Backup and Recovery of the databases.
• Actively participated in User Acceptance Testing, and Debugging of the system.

Environment: SQL Server 2008, T-SQL, MS-SSIS, MS-SSRS, HTML, Windows 7

Confidential, Jersey City, NJ

Informatica Developer

Responsibilities:

• Developed Informatica mappings to extract the data from the GIW (Global Information Warehouse).
• Analyzed the business requirements and suggested changes to the design accordingly.
• Created Informatica Mappings with different transformations including Source Qualifier, Lookup, Filter, Expression, Aggregator, Look up Transformations and more.
• Involved in the regression testing before migrating the code from UAT to Production.
• Developed Mapplets, mappings and configured sessions.
• Created reusable transformations and Mapplets to use in multiple mappings.
• Automated the NDM process.
• Worked Efficiently with Designer tools including Source Analyzer, Warehouse designer, Mapping and Mapplets Designer, Transformations.
• Scheduled the workflows in SIT and migrated the same to UAT and Production.
• Developed UNIX scripts to automate the Data Transmission processes to Mantas system.
• Created MDD for future understanding of the code.
• Created PL/SQL Functions and Stored Procedures for the processing of data from Warehouse to Mart.
• Involved in the UAT processing support.
• Moved the code to production and monitored the day to day production activities until the system was stabilized.
• Extracted the data for specific branches and automated the process.
• Tested the Informatica Sessions in the Workflow Manager.
• Generated various sample feeds and included various iterations to the feeds.
• Prepared various data patches for various abrupt changes required before the code going live.
• Prepared the Test Plan and Test Cases.
• Involved in the creation of workflow and planning the schedule for this workflow.

Environment: Informatica 8.1.1/7.1.3, Oracle 9i, PL/SQL, Business Objects 6.1, Toad, UNIX (Solaris)