SUMMARY

• 12+ Years of IT experience in Data Warehouse Development
• Certified on Informatica VELOCITY Methodology and Informatica certified Designer and Administrator, Implemented Velocity Methodology.
• Extensive experience on Informatica Power center 5.x/6.x/7.x/8.x, Power Center Client tools, ERWIN and Business Objects.
• Have fantastic experience with slowly changing dimensions, Type1, Typ2, Type3, Type4 and Type 6.
• Experience in OLTP/OLAP/ODS models, System Study, Analysis, and Data Model Schemas like Star schema, Snowflake schema and multidimensional modeling.
• Worked on Multiple complex issues and done Performance tuning in multiple ways.
• Worked on brand new development, Integration, Migration, enhancements and Production Support projects using Informatica, Data Stage, Clover ETL and ODI or OWB.
• Good understanding of Business Intelligence Concepts end to end (Data Modeling, ETL and Reporting).
• Handled Multiple DWH projects end to end (Design, ETL, Universe and Reports)
• Highly motivated, pro active and result oriented professional with excellent communication, interpersonal skills, self motivated fast learner and good listener.
• Data has been loaded into MDM tables and Interested to lean new technologies like MDM Rules, Hadoop and BIG data.
• Able to develop database environment statistics for DEV, TEST and PROD
• Good programming knowledge in SQL Server, Oracle, SQL, PL/SQL and UNIX shell scripting and familiar with ODBC/JDBC connection strings
• Having excellent knowledge on requirements gather, data analysis, data flow diagrams, design and development. Worked with technical teams and architects,
• Familiar with ETL/ELT loads and ETL/ELT methodologies for Supporting Data extraction, Transformation and loading process using ETL tools like informatica.
• Good exposure to Software development lifecycle methodologies and excellent skills to analyze business needs.
• Handled responsibilities of design, creation and maintenance of databases for Data Warehouse projects.
• Having extensive experience on load Utilities like FASTLOAD, TPUMP, MLOAD, FAST Export, TPT (Teradata Parallel Transporter) and PDO (Push down Optimization) and used BTEQ scripts.
• Extensively worked on agile and Kanban methodologies
• Familiar with Server installation for BO 5.1, 6.5, BOXI R2/R3 and for Informatica 5.x/6.x/7.x/8.x
• Knowledge on AWS architecture and explored details on AWS tools. expertise on AWS products (EC2, ECS, Elastic Beanstalk, Lambda, S3,Glacier, GIT, DataPipe, Glue, DynomoDB, and RedShift)
• Expertise on HDFS (Hadoop), Map reduce, Hive, HBase and Sqoop.
• Having excellent knowledge on spark and spark streaming.
• Configured SQL database to store Hive metadata.
• Very good understanding with noSQL modelling and JSON files.
• Familiar with Informatica and Business Objects Administration.
• Excellent analytical, problem solving with ability to interact with individuals at all levels.

TECHNICAL SKILLS

Operating System: MS - DOS, Windows 95/NT/XP/2000, UNIX.

Languages & Tools: shell scripting, C, C++, and COBOL, Html, Java, XML, MS-office, Visual Basic, Informatica 5x, 6x, 7x and 9.X, IDQ, Data stage 6x/7x, OWB/ODI, Talend, Clover ETL, IDQ, Business Objects 5x/6x/XI R2, Cognos, Crystal reports, Erwin, Toad, PL/SQL Developer, AUTOSYS, ClearCase, T-SQL

RDBMS: Oracle 10g, Teradata, MS Access, DB2, SQL Server, Netezza

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MD

Sr Data warehouse Developer (Data Modeler / ETL Developer /BIG Data developer)

Responsibilities:

• Document the data & systems requirements
• Created data warehouse model involves translating the logical model into a physical model (Design, creating tables) and adding the appropriate physical objects needed to create the database
• Exported xls spread sheet design document directly from Power designer after Data model finalized.
• Bill Inmon’s enterprise data warehouse(edw) approach (the top-down design), a normalized data model is designed.
• Worked on EDW data modeling for different projects and different source systems.
• Involved and worked on 2 companies (Scottrade and TDA) EDW integration along with source to target document.
• Working on prod enhancements along with other DWH development project and implemented Parallelism and Partitioning to improve performance.
• Extracted data from SQL Server and integrated to target system.
• Prepared ETL technical detail design documents for staging and Data ware house.
• Conducted meetings with business users and other project teams for collaboration.
• Created lot of mappings to staging and to Data warehouse with SCD (Slowly changing Dimensions) logic like Type1, Type 2 and Type 3.
• Experience in working on Agile Scrum and Kanban teams.
• Extensive experience in designing data model, Data Analysis for OLTP and OLAP systems.
• Knowledge on AWS architecture and explored details on AWS tools. expertise on AWS products (EC2, S3, DynamoDB, and RedShift)
• Expertise on BIG data HDFS (Hadoop), Map reduce, Hive, HBase and Sqoop.
• Having excellent knowledge on spark and spark streaming.
• Configured SQL database to store Hive metastore.
• Very good understanding with noSQL modelling and JSON files.
• Worked with Business Users to analyze data, business process and made necessary changes to schema objects.
• Review with App Dev leads and socialize with the developers and architects
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created facts and dimensions to meet business requirements, all physical objects generated in the database schema.
• Source system analysis and Source to target mapping
• Create Logical & Physical Data model per EDW standards.
• Initiated ETL script migration from dev to SIT, then from SIT to production.
• Co-ordinate with SIT (System Integrated testing) team to fix the issues.
• Review tables/views structure with developers, create Replication DDLs & review with system DBAs
• Provide final DDL to release management team to apply in production upon sign off
• Production deployment validation and provide post production support in regards to the tables/views created

Software Used: Netezza, Informatica 10.x, Windows XP, Sun Solaris, SQL, PL/SQL Stored procedures, TOAD, Power Designer (ERWIN), Microsoft SQL Server SSIS, UNIX, JIRA

Confidential, Reston, VA

Data Modeler / Sr Data warehouse Developer (Including production support)

Responsibilities:

• Involved in gathering requirements and Data Modeling for multiple Data ware house Projects.
• Merged multiple BANK credit card flat files into one table to do financial calculations.
• Loaded financial data into SAP FICO using Informatica BAPI transformation.
• Extensively worked on Oracle PL/SQL stored procedures for integration projects using temp tables.
• Created all requirement documents (ETL Mapping Document, Design Document) for DWH project.
• Created lot of stored procedures (PL/SQL) for TS4RRR and IFSRRR projects to calculate all cash and credit card transactions and well maintained in the production environment.
• Wrote lot of stored procedures to calculate and resolved financial issues using indexes and partitioned.
• Resolved lot of issues on BAPI transformation while loading data into SAP and well maintained in prod.
• Worked on lot of complex and unique requirements on Integration projects (TS4RRR and IFSRRR).
• Worked on production support for transaction and Data ware house projects.
• Monitoring daily production jobs and resolving failed job issues and captured error records into Error tables and send email to users on daily basis.
• Created facts and dimensions to meet business requirements, all physical objects generated in the database schema.
• Synchronized models to ensure that database structures match models and tested all DDL before deployment.
• Done data analysis in Development and Production and found root causes and fixed them.
• Extensively worked on the performance tuning for existing and new mappings.
• Used Informatica designer to develop mappings which includes various transformations like Source Qualifier, Expression Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence Generator, Joiner, and Union transformations Trouble shooting production issues and finding the root cause and resolved issues on time.
• Worked on AWS cloud services familiar with AWS concepts and Amazon Redshift database.
• Simplified complex logic based on expression transformation previous record store in variables logic.
• Migrated ETL code from development to production system without issue.
• Supported to UAT (User acceptance testing), Post production support for ETL process.
• Co-ordinate with SIT (System Integrated testing) team to fix the issues.

Software Used: ORACLE 11G, Informatica 9.x, IDQ, Windows XP, Sun Solaris, SQL, PL/SQL Stored procedures, TOAD, SAP FICO, ERWIN, BUSINESS OBJECTS, Autosys, Micro Strategy Sql Server, PostgreSQL, UNIX, AWS Cloud

Confidential, Ashburn, VA

Lead Informatica\ Sr Data Warehouse Developer

Responsibilities:

• Involved in gathering requirements for Data ware house.
• Worked on lot of complex and unique requirement informatica mappings.
• Simplified complex expressions based on Store values from prior rows
• Prepared ETL technical details design documents for staging and Data ware house through ERWIN
• Used Informatica POST session MLOAD and TPUMP script loads data to Teradata) used Teradata TPT connection and PDO (Push Down Optimization)
• Created data warehouse dim and fact tables in TERADATA along with indexes.
• Worked on different loads like Fast Load, Fast export, Multi load and familiar with Tpump.
• Created lot of mappings to staging and to Data warehouse with complex SCD (Slowly changing Dimensions) logic like Type1, Type 2 and Type 3.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to create reporting needs.
• Worked on MDM process to load data into file.
• Done data analysis in Development and Production and found root causes and fixed them.
• Worked on DRMS deduplication report and lot of data issues have been fixed in HRIS project.
• Worked on Multiple complex issues and done Performance tuning in multiple ways.
• Extensively worked on the performance tuning for existing and new mappings.
• Working on production support for DRMS (Donor relationship management system) Inbound and outbound daily jobs, where the jobs run on Informatica
• SIEBEL Custom Unix scripts with hand shaking mechanism and Currently working on enhancements and production support one project.
• Used Informatica designer to develop mappings which includes various transformations like Source Qualifier
• Expression Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence Generator, Joiner, and Union Trouble shooting production issues, finding the root cause and resolved issues on time.
• Initiated ETL script migration from dev to SIT, then from SIT to production.
• Supported to UAT (User acceptance testing), Post production support for ETL process and BO.
• Done Scheduling for Production jobs through CRON tab.
• Prepared source to target design documents and detailed design document.
• Used BTEQ Commands to export and Import data.
• Created different types of reports such as master/detail, cross tab, chart (for trend analysis), Trend reports using Business Objects (Thick Client) and Web intelligence as per Company Standards.
• Implemented major functionalities like Drilldown, Drill Thru, @Functions, Alerts, Sorting, Ranking, Formatting, Breaks, Filters, for creating DESKI and WEBI reports.
• Created links in WEBI to link summary and detail reports using open document function.
• Modifying and Performance tuning of the Existing Reports and Implemented formulas, parameters and conditions depending upon selection criteria.
• Published Reports to CMC (Central Management Console) and exporting the reports in different Formats.
• Demo sessions with Business Users to go over report templates and the training on how to use the tool
• Created and worked on Row level security, Object level security and various predefined security settings depending upon users and group needs using CMC.
• Migrated universe from development to production.

Software Used: Teradata 13, ORACLE 11g, Oracle ERP, Informatica 8.6.1/9.x, Informatica PDO, Business Objects XIR2/ XIR3, Windows XP, Sun Solaris, SQL, PL/SQL Stored procedures, UNIX, TOAD, SIEBEL, ERWIN, Biztalk

Confidential, Silver Spring, MD

Sr ETL Developer / Jr Data Modeler

Responsibilities:

• Involved in gathering requirements for MIE Reports.
• Defined loading strategy process for staging and Data ware house from SSIS.
• Analyzed the source data structure and performed the Logical mappings.
• Developed ETL Mappings to load staging and DW.
• Done regression testing for various staging and DW SCD (Slowly changing Dimensions) mappings.
• Trouble shooting the issues and finding the root cause for them and resolving them.
• Wrote shell script to extract daily feeds and load to ETL source location
• Initiated ETL script migration from dev to SIT, then from SIT to production.
• Co-ordinate with SIT (System Integrated testing) team to fix the issues. Supported to UAT (User acceptance testing),
• Production support for ETL jobs on daily basis.
• Used Informatica designer for developing mappings, transformations, which includes Aggregation, Update strategy, lookup, Joiner, Sequence Generator, Expression, Stored Procedure, Filter and Router
• Currently working on enhancements and production support.

Environment: MSQL Server with SSIS package, ORACLE 10g, ODI, Clover ETL, Internal Query Builder, Windows 7, Sun Solaris, SQL, PL/SQL Stored procedures, UNIX, SHELL Scripting

Confidential, Malvern, PA

Sr Data Warehouse Developer

Responsibilities:

• Analyzed Business Intelligence requirements
• Analyzed Universe and report requirements, prepared report technical design document.
• Created Universe then developed WEBI reports for business users on payment annuitants and lump sum; Created ad-hoc reports for different clients as per business user’s request.
• Created global level reports and client level reports
• Deployed the reports to CMC for the users to able to see the reports in Info View and run, schedule and view the reports in different formats (PDF, Excel)
• Migrated reports from BO 6.x to XI R2 and preparation of report unit test cases.
• Initiate develop reports from dev to SIT and
• Co-ordinate with SIT testing team to fix report and Universe issues then Support to UAT.
• Supported to business users to create ad-hoc reports using Universe.
• Post production support for production reports.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to create reporting needs.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to create reporting needs.
• Since this is Migration project lot of mockup data has been created based on each client requirements for VPAS.
• Done data analysis in Development and Production and found root causes and fixed them.
• Prepared ETL technical details design document then defined loading strategy process.
• Developed ETL Mappings to load ETL buffers and ODS.
• Created test data for testing purpose as per Business intelligence requirements.
• Initiated ETL script migration from dev to SIT.
• Co-ordinate with SIT testing team to fix the issues then Supported to UAT.
• Initiated ETL scripts Migration from SIT to production then Post production support for ETL process.

Environment: DB2, Oracle, Informatica 7.x, 8.x, Business Objects XI2, Windows NT, Sun Solaris, SQL, PL/SQL Stored procedures, COBOL Files, UNIX, Shell Scripting, TERADATA

Confidential, Columbus OH

SR. ETL DEVELOPER

Responsibilities:

• Analyzed ETL (Extraction Transform Loading) business requirements.
• Prepared ETL source to target mapping documents and Prepared ETL technical detail design document.
• Defined loading and scheduled strategy process.
• Developed FTP script to extract data from 3 operating systems (windows, Mainframe and UNIX) into UNIX operating system.
• Scheduled all FTP UNIX scripts through informatica workflows.
• Implemented SCD type 2 process and loaded data into centralized database along with history and rejected records.
• Used Informatica designer for developing mappings, transformations, which includes Aggregation, Update strategy, lookup, Joiner, Sequence Generator, Expression, Stored Procedure, Filter and Router.
• Implemented error handling to collect rejected records and maintained history data into history table.
• Created Tasks, Workflows and Worklets using Workflow Manager.
• Used parameter file for all connections to move into production.
• Created shell script to track failed and successfully loaded records from Informatica session log.
• Prepared unit test cases to test ETL process flow from UNIX system to ODS Database.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Exported and imported all mappings and workflows from DEV to SIT.
• Coordinated to SIT team to fix issues for mappings, Supported to UAT
• Monitored informatica production sessions weekly.

Environment: Oracle 10g, UNIX, Perl, KSH, Informatica, Business Objects XI, COBOL, Mainframe, Windows NT, Sun Solaris, SQL, PL/SQL Stored procedures, Shell Scripting, SQL Server

Confidential, Jersey City, NJ

SR. ETL DEVELOPER

Responsibilities:

• Analyzed business requirements and existing UNIX scripts.
• Prepared technical design document which gives in and out process.
• Loading data from .dat file to Sybase database using iSQL and BCP from ksh script.
• Called stored procedures using scripts and Created new stored procedure and modifying existing stored procedure.
• Calling scripts from KSH to PERL script and PERL script to KSH.
• Created HASHKEY values from .dat and Matching Hash key values from .dat with database table values.
• Scripts have been re-written to be table driven.
• Done Unit Testing and debugging existing scripts.
• Developed scripts based on database reference values.
• The results will be displayed to the user through the front end.
• Extracted data using perl script and loaded using KSH script.

Environment: Sybase, VMWare, UNIX, Perl, KSH, Windows NT, Sun Solaris, SQL, PL/SQL Stored procedures.

Confidential, NewYork, NY

Data warehouse / Sr. Data ware Developer

Responsibilities:

• Written SQL queries have been used on the Universe and created as Derived Tables.
• Created Web Intelligence Ad-hoc and canned reports.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Web intelligence reports in Advanced and Interactive mode using all the functionalities
• Developed Business Views on top of universes
• Created complex reports in Deski, using multiple Data providers.
• Converted Deski Reports to Webi using Report conversion tool for enhancements
• Analyzed the systems, met with end users and business units in order to define the requirements.
• Responsible for the development and production support of a data warehouse by using Informatica.
• Responsible to technical design documents for new request and enhancements.
• Used Informatica designer for developing mappings, transformations, which includes Aggregation, Update strategy, lookup, Joiner, Sequence Generator, Expression, Stored Procedure, Filter and Router
• Developed slowly changed dimensions Type 2.
• Monitoring of Workflows and Worklets using Workflow Monitor.
• Maintain test cases in Test Directory.
• Worked extensively on XML source and Targets, loaded data into XML and extracted.
• Resolved lot of problems on XML source and Targets.
• Monitor informatica mapping daily, weekly and quarterly.
• Maintain session logs and records count in excel sheet for monitor jobs.
• Used workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Extensive record filtering and field-level evaluation
• Create, collate and convert many file types, Sorts and join to separate data into distinct groups.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Creating user defined functions and packages for better optimization

Environment: Informatica Power Center 6X, Oracle, DB2, Toad, SQL, PL/SQL Stored procedures, Window 2000, UNIX, Business Objects, sun Solaris

Confidential

DATAWAREHOUSE / BO DEVELOPER

Responsibilities:

• Created universes and also tuning them for better performance.
• Developed few WEBI reports Using JAVA and HTML Report panels.
• Using BCA, Scheduled few corporate documents and Involved in data reports using Business objects 6.5.1.
• Resolved loops based on requirement using alias, contexts and short cut joins.
• Based on requirement given privileges for user on row level and table level.
• Created Hierarchies, Classes and changed the qualification of object.
• Created corporate document reports using web intelligence
• Used OWB to load data into Oracle Database
• Creation of Universe in the Designer and making connection with the Oracle Database.
• Working with joins and resolved joins problems in the universe.
• Create Aliases, Import and Export universes, defining classes and objects, testing universe.
• Layout design for various Reports in Business Objects

Environment: Business Objects 5X, Oracle 9i, SQL Server, Oracle, Toad, SQL, PL/SQL Stored procedures, Power Connect, Window 2000, UNIX, JAVA, OWB (ETL) or ODI (Oracle Data Integrator)