SUMMARY

• Over 7 years of IT experience in Analysis, Design, Development and Deployment of technical solutions to business requirements.
• Strong Data Warehousing ETL experience using Informatica Power Center 9.6/9.5/9.1/8.6/8.1 (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Informatica Server, Repository Manager)
• Hands on experience in SSRS, SSIS.
• Experience in all the phases of ETL such as Extraction, Cleaning, Transformation and Loading using Informatica.
• Expertise in OLTP/OLAP System Study.
• Experience working with various source systems/files like RDBMS (Oracle, SQL Server, Netezza) Flat Files, XML Files etc.
• Proficient in databases including Oracle 11g, MS SQL Server.
• Expert in SQL Server tools like SQL Server Reporting Services, SQL Server Integration services.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Strong experience in developing complex mappings using various transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker Joiner, Stored Procedure, Update Strategy etc and Re - usable transformations.
• Strong experience in developing Workflows, Worklets, sessions and tasks to effectively manage the Load.
• Extensively involved in performance tuning of Informatica mapping and sessions by reducing Data Flow, Eliminating I/O & bottlenecks, optimize resources, optimize common ETL processes and data parallelism.
• Extensive experience in error handling and problem fixing in Informatica
• Strong Knowledge of Star and Snow Flake Schemas.
• Slow Changing Dimensions (type1, type2) were developed.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Good knowledge of UNIX Shell Scripting.

TECHNICAL SKILLS

Operating System: UNIX, Windows 2007/2008/XP.

ETL Tools: Informatica (Power Center) 8.6, 9.1, 9.5.1,9.6.1, SSIS

RDBMS: SQL Server 2012,2008, 2005 Oracle 10g/11g, Netezza

Languages: UNIX, SQL, T-SQL and PL/SQL.

Web Technologies: XML, HTML, Javascript, CSS.

Software Tools: TOAD, SQL Trace, SQL server Management studio (SSMS), SQL Developer, Excel and PowerPoint, MS ACCESS, SQL LOADER, SQL*LOADER, SQL*Plus.

Data Modeling Tool: Dimensional Modeling.

Star Schema.: Snow flake Schema.

Reporting Tools: SSRS 2012, 2008

PROFESSIONAL EXPERIENCE

Confidential - Winston Salem, NC

ETL Developer

Responsibilities:

• Analyzed Business/ functional Specifications and worked with Business Analyst team and identified the source data and transformation logic needs and review of final mapping documents. Also, participated in the review meetings/ project check in and user requirement gathering meetings.
• Participated in developing logical and physical data models that capture current state/future state data elements and data flows.
• Created complex reusable transformations and Mapplets in Transformation Developer, and Mapplet Designer, respectively.
• Worked extensively on different types of transformations like normalizer, lookup, rank, expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator and joiner.
• Designed and developed Complex mappings like Slowly Changing Dimensions Type 2 (Time Stamping) to maintain full history of transactions.
• Performed Performance tuning and also have used debugger to troubleshoot errors.
• Loaded data to and from Flat files and databases like Oracle, SQL Server, Netezza.
• Developed PL/SQL stored procedures/functions and Unix Shell Scripts as a part of the project.
• Performed Developer testing, Functional testing, and Unit testing for the Informatica mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Responsible for designing and developing of mappings, mapplets, sessions and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
• Performed Informatica Admin role by creating new repositories, users and maintaining TEST and PROD environments.
• Involved in ETL process from development to testing and production environments.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Analyze the requirement and design the report templates using SSRS 2012.
• Design and develop various customized reports like sub-reports, drill-down reports, parameterized reports for different users.
• Create stored procedures to generate required datasets based on individual report specifications.
• Analyze and design report templates using SSRS 2012 based on client requirement.
• Develop SQL Scriptsto dynamically manipulate data and generate well-formatted reports based on user requirements.
• Create info-graphs to represent various statistics based on geographical regions.
• Provide consultation on effective and efficient reporting strategies for end users.
• Test, modify and/or debug internally developed reports and stored-procedures.
• Provide on-going support for the enterprise reports from various user.

Environment: Informatica Power Center 9.6/9.1/8.6, Workflow Manager, Windows 2007, Oracle 11g/10g, SQL server, Netezza, XML, Unix Shell Scripts, Flat Files, SQL Server 2008/2012, MS Visual Studio 2008/2012, SSRS 2008/2012.

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Understand the Requirements and Functionality of the application from specs
• Involved in the development of Informatica mappings and tuned existing mappings for better Performance.
• Develop required Unix shell scripts to automate ETL processes.
• Responsible for testing the mappings and ensure that the mappings do the transformation as proposed.
• Developed Mapplets and Worklets for reusability.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, data masking and Sequence Generator etc.
• Involved in Unit Testing, create test cases to check whether the data loads into target.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Scheduling daily, weekly and monthly loads for the managers according to the business specs.
• Develop workflows, sessions used command task in workflow manager.
• Involved in The ETL process is handled by defining and deploying mappings. OWB gives the user a highly graphical and easy-to-use interface.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Responsible for developing various data extracts and loading routine using Informatica, Oracle stored procedure (pl/sql), packages, triggers, UNIX.
• Created detailed process flow designs and drafts high-level Standard Operation Procedures.
• Performed tuning for PL/SQL procedures, Views, and Informatica objects.
• Monitored data warehouse month-end loads to ensure successful completion.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Tuned mappings and SQL queries for better performance and efficiency.
• Created and ran the Workflows using Workflow manager in Informatica Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Gap analysis by mapping the functional requirements to the Business Requirements worked on the report design to create User Interface mock-ups.

Environment: Informatica Power Center 9.5.1, Oracle 11g, TSQL, PL/SQL, TOAD, SQL*Loader, UNIX, Windows 2007, MS Access, MS Excel, MS Word, PDF

Confidential

SQL BI Developer

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Helped in integration of the front end with the SQL Server backend.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results..
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)
• Wrote T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Also Created derived columns from the present columns for the given requirements.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Provided via the phone, application support. Developed and tested Windows command files and SQL Server queries for Production database monitoring in 24/7 support.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.

Environment: Microsoft Office, Windows 2007, T-SQL, DTS, SQL Server 2008, HTML, SSIS, SSRS, XML.