SUMMARY:

• 12 years of experience in BI, Transactional applications, Design and Development of ETL and data models in Data Warehouse/Data Mart environments, Requirement Gathering and Data Modelling using OBIEE, SSIS and Informatica ETL Powercenter tools.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas.
• Very strong in PL/SQL Procedures, Packages, Functions and Triggers.
• Experience in Installation, Configuration, and Administration of OBIEE, Informatica Power Center 9.x/8.1.1 and SSIS.
• Excellent data analysis skills.
• Analyzed existing transactional database schemas and designed Star/Snowflake Schema models to support the business reporting needs and requirements.
• Extensive SQL development in Oracle and SQL Server environments.
• Extensive experience in analyzing functional data mart and data warehouse requirements for BI and designing star and snow - flaked schemas.
• Experience in developing end-to-end ETL process for full lifecycle implementations for BI.
• Created ETL mappings using Informatica Power center to move Data from multiple sources like Flat files, XML, Oracle, Sybase, SQL Server into a common target area such as Data Marts and Data Warehouse.
• Extensively worked on various transformations such as Expression, Filter, Aggregator, Lookup, Router, Update Strategy, Union, Normalizer, Sequence Generator etc.
• Experience in migrating SSIS code across various environments.
• Proficient in Informatica Power Center 9x/8x security, general administration and performance tuning.
• Proven ability to collaborate with other analysts and developers in a BI team environment.
• Extensive use of Oracle SQL, Sybase T-SQL and SQL Server for data retrieval.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, UML, XML

Reporting Tools: OBIEE 11.1.1.6/11.1.1.5/11.1.1.3, Siebel Analytics 7.7/7.5

ETL Tools: SSIS, Informatica Power Center 9.x/8.x,SQL Server Integration Services (SSIS) 2000/2005

Methodologies: Star/Snowflake Schema, Physical, Logical and Relational Modeling, DimensionTables, OLAP, Dimensional Modeling.

Databases: Oracle 9i/11i/10g, SQL Server 2005/2008/2012, Sybase 12.0, MySQL

Operating Systems: Windows 7/8, UNIX (Solaris, HP, Linux)

Job Scheduling Tools: Control-M, SQL Agent, Windows, UNIX

Other software: CVS, PVCS, SQL Developer, Toad, Weblogic Server 10.3, BIScheduler, ODS, Oracle10GR2, SQL Plus, Oracle 9i, DAC 10g

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr. ETL Developer

Responsibilities:

• Created weather data ETL to provide previous day hourly and half-hourly report linking weather toridership data.
• Created ETL from stored procedures for HelpDesk analysis. This improved the turn-around time forad-hoc reporting.
• Converted ETL from PL/SQL to SSIS. This involved extensively debugging SQL code andconverting it into various transformations in SSIS.
• Provided ETL for Rail Operations Planning to improve reporting on rail car info and platformdetails. This improved the analysis in determining how long trains were stopping at each platform inthe entire system.
• Debugged ETL and provided analysis for First call resolution rate.
• Participated in meeting ranging from requirement gathering to moving to production andcollaborated with Business Analysts, SMEs and Report Developers on full cycle BI Projects for WMATA.
• Designed datamart using Star and snowflake schemas to enhance reporting data.
• Implemented changes to existing reports and created data for ad-hoc reporting.
• Suggested improvements to current reporting processes, formats and designs for Operations.
• Designed and created data mart for MetroAccess. This included integrating several transactional database components like Fares, Compliants, Trips and Runs and creating a datawarehouseSystem.
• Participated and collaborated with business analysts on client requirements and changes to theexisting system.
• Provided regular feedback and status reports to the project stakeholders on the progress and projectstakeholders.
• Created ETL using SSIS for reporting on SafeTrack data to enable WMATA better reporting on theprogress of the repair tasks.
• ETL was designed and created using SSIS using several LookUp, Filter, Aggregators, Data Conversion, Expression and Merge transformations.

Environment: PL/SQL, SSIS 2008,MicrosoftVisualStudio 2010, Sql Server 2012, Oracle 11g, SQL Developer 3.2.20.10, Cognos.

ETL Consultant

Responsibilities:

• Involved in Data Model design or enhancements of Data Marts based on the ETL project requirements.
• Used PL/SQL extensively in creating and troubleshooting ETL processes. Most of the ETL was converted from PL/SQL to SSIS.
• Created ETL design and process flow documents from Design Mapping Specification (DMS).
• Led the group in analyzing DB requirements for BI Reporting. Worked collaboratively with technical staff and business experts to develop solutions to business requirements and client problems.
• Worked in a system with two different databases Oracle and Sql Server for legacy and current applications.
• Worked with source system users and monitored existing production ETL processes on a daily basis.
• Created Mapplets and Re-usable Transformations to prevent redundancy of transformation usage and maintainability.
• Worked as a PL/SQL developer to debug stored procedures to extract to get more data into the system.
• Designed and developed ETL data models in data warehouse and data mart environments.
• Created Mapping parameters, Session parameters, Mapping Variables and Session Variables for easy automation, maintenance and CDC implementation.
• Developed mappings to load Slowly Changing Dimensions Type-1 and Type-2, Fact tables.
• Worked on Performance Tuning for dataflows. This included identifying data-quality issues and suggesting methods for their resolution.
• Troubleshot various report issues including connection problems and data errors.
• Improved Report performance by designing and loading multiple aggregate tables from transaction detail table using SSIS.
• Created data transformations from transactional systems in Sql Server and text files to Oracle for data warehouse system.
• Worked on developing data designs and processing flows to support customer support service functions.
• Used SSIS to do transformations on XML data and integrate better with existing data. This included customer reviews and support call info from third-party vendors.
• Analyzed the data warehousing requirements with the Business Analyst team, Data Base team to configure the Data marts and Development environments.
• Worked collaboratively with technical staff and business experts to develop solutions to business requirements and client problems.
• Analyzed the Reporting requirements with the Business Analyst team, Data Base Team to configure the Data marts and Development environments.

Environment: Oracle 11g, OBIEE 11, Toad 12.1,SQL Server 2012, SSIS, Unix, Clear Quest, Clear Case, Mercury RFC Tool.

Informatica Developer

Responsibilities:

• Involved in the detailed design of the reports/dashboards, data mart and data model.
• Conducted meetings with business stakeholders and other technical team members to Gather and analyze application requirements.
• Involved in the development of Logical and Physical data models that capture current state Developed and tested all the Informatica Data mappings, sessions and workflows - involving several Tasks.
• Developed ETL for XML sources as a datasource and improved Data Analysis by providing more source data.
• Managed the communication between project managers and technical staff and provided regular feedback to analysts, QA team and developers.
• Developed end-to-end ETL processes for Trade Management Data Mart Using Informatica.
• Worked on source analyzer, Target Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor.
• Created application retirement validation to compare data in the archive against retired applications and perform full table/row or selective table/column validations.
• Created simple data masking validation to compare masked values against original data to guarantee that all sensitive values are different, and to confirm that all substituted values come from a data dictionary.
• Created mappings for initial load in Power Center Designer using the transformations Expression, Router and Source Qualifier.
• Designed Cisco Networking data mart for customized BI reporting. This involved designing of ETL scripts to move data into repositories.
• Used Sql Developer to do PL/SQL development for Stored Procedures, Functions and Triggers.
• Extensively used transformations like Lookup, Filter Aggregator, Expression, Merge and DataFlow to enhance and manage the data.
• Created complex mappings for full load into target in Power Center Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, Union etc.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.
• Created various tasks to give various conditions in the workflows and created and scheduled the sessions.
• Created and implemented data mart for Network engineers for each product family by working on all SDLC activities.
• Worked on PL/SQL tasks like Stored procedures, Functions and Triggers.
• Created Re-usable Transformations and Mapplets to standardized Business logic.
• Created Mappings, Mapplets and Sessions for data loads and data cleansing. Improved the existing mappings and changes were made to the existing mappings using Informatica Power center.
• Worked in extracting the data from Oracle and Flat files. Developed and implemented various improvements to the application in the form of Production and new production rollouts.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Analyzed transactional db schemas to design Star and Snowflake data models for BI Reporting Requirements.
• Created confirmed Dimensions for the purpose of incremental loading of the target database.
• Worked on Fast Load, MultiLoad, Tpump and FastExport loading techniques through Informatica into Teradata from Multi-DB environment (Oracle and Sql Server) using Star and SnowFlake Schemas.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance.
• Worked on Performance Tuning for dataflows.
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Worklets and Workflows.
• Created parameters and variables for the reusable sessions.
• Analyzed the various bottlenecks at source, target, mapping and session level.
• Designed the ETL processes using SSIS to load data from DB2, SQL Server and Flat files to the Target Database.

Environment: Informatica Power Center 9.1/Power Exchange/Informatica Cloud, IDQ 8.6.1, Tivoli, Teradata, Oracle 11g, SSIS, PLSQL, DB2, XML, MS SQL Server 2005, SQL* PLUS, MS Excel, UNIX(AIX), UNIX Shell.

ETL Developer

Responsibilities:

• Worked on the functional requirements and performed GAP analysis of the Data mart instance and provided alternative solutions including changes to database.
• Created user id and folder for each new account for the developers along with the necessary privileges.
• Developed UNIX shell scripts as part of the ETL process to schedule tasks/sessions.
• Migrated data mappings to production and monitored and restarted the batch process using SSIS.

Environment: SSIS, Oracle 8i, PL/SQL, XML, SQL, Windows NT, MS Access.

Siebel Analytics Consultant

Responsibilities:

• Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Siebel Analytics Repository using Siebel Analytics Administration Tool.
• Created Security settings in Siebel analytics Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in Siebel Answers.
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain daily and weekly reports.

Environment: Siebel Analytics 7.x, Informatica Power Center 6.x / 7.x, Oracle 9i, HP.