SUMMARY

• Over 13+ years of experience in Data warehouse environment in various tools like, Extraction, Transformation and Loading data using Data Modeling tool Erwin 7.1.5.
• 9+ years of experience on Informatica Power Center 9.0.1,8.6.1, 8.5,8.1.1,7.1.3/6.1,6.2/5.1.2 (Designer, Workflow Manager, Workflow Monitor), and Power Connect, Power Exchange, Data Quality, Data Explorer,
• 2+years of Experience on Oracle Warehouse Builder 10g R2,11g R1.
• 6 + years of experience on BI tool migrations from existing to new microstrategy servers.
• 3 + years of experience in Oracle Business Intelligence Enterprise Edition modules (Administration, Answers,hyu5 Dashboards) for complex queries that are necessary for structured and ad - hoc reporting.
• Experienced in Performance of Mapping Optimizations in Informatica.
• Experienced In Powercenter Change Data Capture (CDC) to perform database changes and forward to power center.
• Experienced in the Analysis, Design, Development, Testing, and Implementation of business application systems for Pharmaceutical, Financial, Insurance, Telecommunication and Manufacturing Sectors.
• Used various sources like Oracle11g, SQL Server2008, DB2 UDB, Sybase, Flat files, and XML in creating reports.
• Experienced in using the Oracle SQL* Loader feature for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Automated and scheduled the Informatica jobs using UNIX shell scripting (CRONTAB) and AutoSys,Tidal and Tivoli.
• Extensive experience in error handling and problem fixing in Informatica
• Involved in Relational database design and development of data warehouse data feeds.
• Very strong in Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying.
• Involved in full life cycle development of Data Warehousing
• Good knowledge in developing reports using Business Objects.
• Experience in writing stored procedures (PL/SQL) and triggers using Oracle.
• Worked on developing reports using Crystal Reports,Oracle Suite 10g.
• Extensive experience in developing logical and physical models and implementing them in Erwin.
• Excellent skills in retrieving the data by writing simple/ complex SQL Queries
• Outstanding experience in using SQL, PL/SQL, TSQL, Indexes, Functions, Procedures, Triggers and Cursors.
• Good Work Experience with Data Transformation Studio.
• Understanding in writing Test plans, Test cases, Unit testing, System testing, Integration testing and Functional testing.
• Experience on OWB, Brio, Abinitio,OBIEE.

TECHNICAL SKILLS

Data Modeling Tool: Erwin 7.1.5/6.0/4.0 , ER/Studio, Data Architect 9.0

Data Warehouse/ETL Tool: Informatica Power Center/Mart 9.0.1,8.6.1,8.5, 8.1.1,7.x/6.x/5.x, Power Exchange 8.6.1Informatica Power Connect, Informatica DT Studio 8.6.2,Data Quality,DataProfile, Datavalidation(DVO),Data stage7.x, Data Profiling,SSIS, Teradata 13.0, OBIEE 10.1.3.4/4.1.

Databases: Oracle 10g,9i/8i/7.x,IBM DB2, MS SQL Server 2008, MS Access.

BI Tools: Cognos Impromptu, Power Play Transformer, Power Play for Windows,ReportNet1.1,Business objects XIR2, SSRS 6.0/5.1,Brio,OLAP,OLTP,Oracle Dev Suite 10g

Languages: PL/SQL, C, C++

Web Tools: HTML, DHTML, XML, Java Scripting, VB Scripting

Tools: Tivoli, MS Project 2003, Matlab 9, AutoSys, TOAD,Pl/sql Developer

Operating Systems: Microsoft 95/98/2000/XP/NT, UNIX AIX, Sun Solaris 10.

Version Control: MS Visual SourceSafe, Remedy Picasso

PROFESSIONAL EXPERIENCE

Confidential

ETL/BI Configuration Lead/Data Modeler

Responsibilities:

• Involving into Prepare the Data warehouse Architectural Proposal Template and discussed with the team.
• Identifying the relations based on the existing OLTP Data models.
• Identify the Measures/Metrics to create the Fact Qualifier Matrix. Attended the DARRTS Overview and understanding the DARRTS Application.
• Involed into migrating the existing cognos and Business object reports to Microstrategy and also creating the dashbords for new reports.
• Identify the report requirements from clients.
• Involved into Upgrade the Informatica (ETL) servers from 8.6.1 to big data 9.5.1 and also configure the Power connect to convert the unstructured data and Java applications.
• Working on Sample FQM to get the FACTS and Qualifiers list Based on the Existing Physical model.
• Involved into design the logical data model from the technical design documents and translating to a physical data model using ERWIN.
• Develop ODS logical and physical data models.
• Participate in the business analysis sessions to obtain requirements for the data model. Interact with data modeling, data support teams to get the enterprise data for High level specs.
• Involved into gathering the attributes from different existing models, and write high level specifications for every data requirement.
• Involed into BI tool evaluation meetings with govt. people and identify the BI tool.
• Involved in identifying, analyzing and translating business requirements into conceptual, logical and physical, Conceptual data models in complex, multi-application environments.
• Involved into creating the procedures, functions using SQL Developer.
• Involved into gathering the attributes from different existing models,and write high level specifications for every data requirement,And also identifying, analyzing and translating business requirements into conceptual,logical and physical, Conceptual data models in complex, multi-application environments.
• Diagnose, resolve, or escalate identified problems related to Informatica Power Center v.9, and Oracle, running in either a Windows or Unix environment Solve a variety of production issues related to Informatica Power Center v.9.1.1
• Document End-of-Shift Status (accomplishments or completions, and outstanding or pending jobs or issues) for in-coming staff.
• Utilize Informatica Power Center v.9.1.1 (Workflow Monitor, Workflow Manager, Workflow Designer, Repository Manager, and Repository Server Administration Console) to schedule and control workflows, import/update mappings and tasks, and security.
• Involved into Creating the PL/SQL code to migrate the date from Universe to ODS.

Environment: ERWIN 7.1.5, Power Center 9.5.1, 9.0.1,Power Exchange 9.0.1,DataQuality,MetadataManager 8.1.1,DataProfiling, Microstrategy9.0,Teradata TTU 13.0,Oracle 11g,PL/SQL Developer,Mainframe DB2, Unix,Putty,SAP Business Objects XIR2.

Confidential

ITSSC/ODPMI Warehouse

Responsibilities:

• Involved into design the logical data model from the technical design documents and translating to a physical data model using Data Architect 9.0.
• Develop ODS logical and physical data models.
• Participate in the business analysis sessions to obtain requirements for the data model.
• Involved in identifying, analyzing and translating business requirements into conceptual, logical and physical, Conceptual data models in complex, multi-application environments.
• Expertise in Dimensional modeling techniques such as Star and Snowflake schemas using ERWIN 7.1.3.
• Created error log table to capture the error messages, session load time.
• Involved into creating, reviewing and presenting Source Systems Analysis and Source To Confidential mapping across Staging, Integration and Presentation layers.
• Develop data model deliverables/documentation.
• Worked as an onsite project coordinator once the design of the database was finalized in order to implement the data warehouse according to the implementation standards.
• Worked with client and off shore team to make sure that the reports and dashboards are delivered on time.
• Participated in UAT sessions to educate the business users about the reports, dashboards and the BI System. Worked with the test team to provide insights into the data scenarios and test cases.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Preparing the Fact qualifier matrix according to Business requirements and analysis the Social Security FD-15 and SAOR reports for FQM.
• Extract the data from ASP.net applications, transform the data using the ETL process, and load the data into appropriate tables.
• Designing the logical data model from the technical design documents and translating to a physical data model using ERWIN.
• Involving into requirements meeting and walk through the use cases and find the appropriate lookup tables.
• Participate in the business analysis sessions to obtain requirements for the data model.
• Involved into gathering the attributes from different existing models, and write high level specifications for every data requirement, And also identifying, analyzing and translating business requirements into conceptual, logical and physical, Conceptual data models in complex, multi-application environments.
• Analyze data and create detailed reports utilizing proprietary tools and third party technologies to identify and resolve data quality issues to ensure quality assurance and drive data quality initiatives.
• Perform analysis profiling on existing data and identify root causes for data inaccuracies Table Lineage and Impact Analysis and recommendation of Data Quality Internal and External Audits.
• Understand and translate business needs into technical requirements.
• Attended the daily scrum meetings at 9 am in the morning to discuss about the status.
• Attended the Meetings to Clients at Confidential to gather the requirements and also for work sheet Requirements.

Environment: Data Architect 9.0,Mainframe DB2,JMS,VSAM,COBOL,MQ Series, Oracle 11g,Business Objects XI R2,MicroStrategy 9.0,SSIS Packages,Informatica 9.0.1/8.6.1 , Power exchange 9.0.1,Power Connect,J2EE,Data Quality, B2B, Data validation, Data Analyzer.

Confidential, Baltimore,MD

ETL Admin/Data Modeler

Responsibilities:

• Involved into Monitor the execution of Data Transport job streams in Informatica. Recognize abnormal performance or completion events.
• Involved into design the logical data model from the technical design documents and translating to a physical data model using ERWIN .
• Develop ODS logical and physical data models.
• Participate in the business analysis sessions to obtain requirements for the data model.
• Interact with datamodeling, datasupport teams to get the enterprise data for High level specs.
• Involved into gathering the attributes from different existing models, and write high level specifications for every data requirement.
• Involved in identifying, analyzing and translating business requirements into conceptual, logical and physical, Conceptual data models in complex, multi-application environments.
• Experienced to Use Power connect to connect and import the sources from external systems like Mainframe DB2, XML,MQ series.
• Created error log table to capture the error messages, session load time.
• Involved into creating, reviewing and presenting Source Systems Analysis and Source To Confidential mapping across Staging, Integration and Presentation layers.
• Develop data model deliverables/documentation.
• Complete the ODS physical data model implementation by working with the DBA.
• Experience with application integration architecture with package, interface development and webfront-end (asp.net)
• Utilize Informatica Power Center v.8.6.1 (Workflow Monitor, Workflow Manager, Workflow Designer, Repository Manager, and Repository Server Administration Console) to schedule and control workflows, import/update mappings and tasks, and security.
• Designed the ETL processes using Informatica to load data from DB2, Oracle, SQL Server, Flat Files, XML Files and Excel files to Confidential Oracle Data Warehouse database.
• Creating and managing Informatica Local and Global Repository.
• Identifying and loading sources and targets metadata into repository.
• Created, launched & scheduled sessions. Configured email notification. Setting up Batches and sessions to schedule the loads at required frequency using Power Center Server manager.
• Using Meta data manger to find out the relations and load diffetent tools like Informatica, Cognos, Microstrategy, DB2, Oracle.
• Written SQL overrides in source qualifier according to the business requirements.
• Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.
• Created and used different tasks like Decision, Event Wait, Event Raise, Timer and E-mail etc.
• Used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.
• Created database Triggers, Stored Procedures, Exceptions and used Cursors to perform calculations when retrieving data from the database.

Environment: Erwin 7.1.5,ER/Studio,Data Architect9.0,PowerCenter 8.6.1,PowerExchange 8.6.1,Power Connect, Metadata Manager 8.1.1,DataQuality,B2B,DataProfiling,DataValidation(DVO),Solaris10,Teradata TTU 13.0,Oracle 11g,MainFrame DB2,Microstrategy,cognos,XML,Remedy Picasso.

Confidential, Charlotte,NC

Informatica Developer / Admin

Responsibilities:

• Perform ETL Informatica (8.5/8.6.1) Administration functions such as user access accounts, roles, and setting standards.
• Involved into Informatica code migrations and monitoring according to our client's standards.
• Install / Upgrade / Configure/Maintain Power Center 7.x/8.x instances on UNIX and Linux servers.
• Interact with UNIX and Database Administrators to create and maintain each Power Center instance.
• Configure Database and ODBC connectivity to various source/ Confidential databases.
• Install / Configure Power Connect for JMS /Web Services and others as required.
• Independently perform complex troubleshooting, root-cause analysis, solution development.
• Manage and administer system performance including on-going optimization and tuning of Informatica environment.
• Create and manage users, groups and folders. Ensure appropriate privileges are assigned to the different users.
• Interact with end users to resolve issues with Informatica Power Center
• Coordinate with Informatica support for patches and bug fixes.
• Interface with the Database Administration Group to ensure proper configuration of database objects in support of ETL code.
• Performance tuning covering the areas of: session, source, Confidential mappings.
• Migrated the MSRS Reports using change man to all Environments.( Dev to Test,stg and PROD).
• Support installation and maintenance of the Metadata Reporter and Power Connect.
• Support installation and maintenance of new Power Center features.
• Perform project code deployment between environments using the Automated SCM Deploy toolset.
• Implemented and reviewed the transformation logic in the ETL mappings according to the pre-defined ETL standards.
• Used Workflow monitor to see the work flows running and get the session properties and session log.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Wrote PL/SQL stored procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Involved in processing of Policy, Claims data in dev.
• Involved into schedule the informatica jobs Using the third party scheduling tool UC4.
• Involved in troubleshooting the loading failure cases, including database problems.
• Extensively used Xml source qualifier, Mid-stream XML parser transformation, Mid-stream XML generator transformations, as our main source type was XML Files.
• Extensively used Dynamic Lookup transformation and Update Strategy transformation to update slowly changing dimensions.

Environment: Informatica 8.6.1,Power Connect,Cobol files,Netezza,Ms Office,J2ee,SqlServer 2005,MSRS,SSIS,MQ Series,Sharepoint,VisualSourcesafe,sunsolaris10.

Confidential, Baltimore MD

Informatica Developer/Analyst

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework
• Done Installation & Configure the Informatica Version 8.5,Migrate the Informatica jobs from Older version to new Version Using Pushdown Option.
• Worked with CDC option is captures database changes, forwarding them to power center for further processing.
• Done Security & User Management in Informatica environment. Managed multiple Informatica environments which involved mantainining users with specific roles and privileges on appropriate Folder permissions.
• Configure the Pushdown Option,Cleansing option using Informatica 8.1.1 Version and Improve the system performance.
• Participate in the design, development and deployment of the ETL and data management processes .
• Extensively used Xml source qualifier, Mid-stream XML parser transformation, Mid-stream XML generator transformations, as our main source type was XML Files.
• Extensively used Dynamic Lookup transformation and Update Strategy transformation to update slowly changing dimensions.
• Sources Like DTS Packages (connections, tasks, and workflows) that can be used to access, transform and manipulate rom a wide range of sources including text files and relational databases.
• Worked on Version Control in Informatica to maintain multiple versions of an object, control development on the object and track changes.
• Extensively utilized the Debugger utility to test the mappings.
• Extensively worked on Performance Bottlenecks to improve the performance of the sessions and workflows.
• Written SQL overrides in source qualifier according to the business requirements.
• Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.
• Created and used different tasks like Decision, Event Wait, Event Raise, Timer and E-mail etc.
• Used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.
• Created database Triggers, Stored Procedures, Exceptions and used Cursors to perform calculations when retrieving data from the database.

Environment: Informatica Power Center 8.5,8.1.1,DT Studio,CDE,ASP.Net,Oracle 10g, Autosys, SQL Server 2005,T-SQL, JMS,PL/SQL,DTS packages, IDQ,SQL*Loader,SQL Analysis, XML, B2B Exchange,DB2UDB, OracleDesigner,Cognos 8.0,Unix Solaris.

Confidential, Minneapolis, MN

Programmer Analyst

Responsibilities:

• Used IBM’S METHOD BLUE to create design documents for informatica mappings.
• Worked with Business Analyst to gather business requirements and Involved in weekly team meetings
• Reviewed the business requirements and created internal and external design for informatica jobs.
• Involved in transfer of data to Connect3’s Promotion Manager.
• Worked with Connect3 support team to maintain the informatica jobs.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, Sybase, DB2 and loading to Oracle, Sybase, and Tera Data Confidential database.
• A Load Ready File (Flat File) is created from source file(delimited file) after a series of transformations and error handling, this serves as a staging area for cleansing the data. The error file is captured in delimited file.
• The Load Ready File is loaded into Teradata Table using Teradata’s ODBC/Fast load connection. The Load Date and Load Time are also captured in the teradata table
• Extensively used various types of transformations such as Expression, Normalizer, Joiner, Update strategy, Lookup (Connected and Unconnected) to load the data
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Devised extensive PL/SQL Stored Procedures and Triggers to populate the base tables on daily basis and implementing business rules and transformations
• Performed Mapping Optimizations to ensure maximum Efficiency
• Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of session and Scheduled Workflows using Autosys.
• Implemented complex mapping such as Slowly Changing Dimensions (Type II) using Flag.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers.
• Defined the Business Objects Classes and Objects, Created complex Universes and Reports.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice,Drill Down,Master Detail and Formula’s etc.
• Performance tuning of Business Objects Reports which take more execution time

Environment: Informatica Power Center, 7.1.3 (Informatica Server, Informatica Repository Server, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), XMLFiles, ERwin 4.0/3.5, Oracle 10g/9i,DB2, Tera data,PL/SQL,Businessobjects,Tivoli,TOAD,SybaseIQ,ASEUNIX AIX.

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

• Worked on Oracle warehouse builder tools-Source analyzer, Warehouse Designer, Mapping Designer and Transformation developer
• Created necessary Repositories to handle the metadata in the ETL process
• Created the Source and Confidential Definitions in Informatica Power Center-Designer
• Designed and developed Informatica Mapping for data load and data cleansing
• Extracted, transformed data from various sources such as Flat files, MS SQL Server and transferred data to the Confidential data warehouse Oracle9i,Sybase database and Flat files
• The Load Ready File is loaded into Teradata Table using Teradata’s ODBC/Fast,Multi load connection. The Load Date and Load Time are also captured in the teradata table
• Created Stored Procedure, Functions and Triggers as per the business requirements
• Used update strategy and Lookup transformation to insert, delete, update or reject the records based on business requirements
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL tool
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Weekly, Monthly and Yearly Loading of Data
• Utilized the Aggregate, Join, Router, Look up and Update transformations to model various standardized business processes
• Developed the ETL scripts in order to populate the Global repository from the local repository
• Worked with Scheduler to run the Informatica session on daily basis and to send an email after the completion of loading
• Conducted Unit testing and Integration testing
• Analyzed the reliability, hypothesis and restriction in documentation of the Functional, Technical and Architecture which are confidential

Environment: Informatica7.1.3,6.x, Tera Data,CICS,COBOL,MQ Series, Erwin 3.5, Oracle 9i, SQL,PL/SQL,Flat files, Java2.0, Business objects, Windows 2000 server.

Confidential

Software Engineer

Responsibilities:

• Understanding source system
• Developed mappings as per Business Requirement Data
• Creating of data mart and extracted data from Oracle, using Informatica Power Centre
• Developed and implemented ETL mappings
• The Load Ready File is loaded into Teradata Table using Teradata utilities like Fast load Multiload,Bteq,Tpump connections. The Load Date and Load Time are also captured in the teradata table
• Implementation of Production Stage and Loadings weekly basis.
• Created Transformations and Mappings using Designer Tools set of Informatica
• Designing the lookup table
• Modified existing SAS frame objects and SAS/SCL code files to expedite the addition of new reports to the application’s menu system.
• Preparing the ETL script for extraction, transformation & loading
• Extraction and Loading monthly data
• Involved in preparing the high level & low level design document for ETL
• Developed UNIX scripts for scheduling the jobs
• Designed and developed UNIX shell scripts as part of the ETL process.
• Involved in preparing the test plans

Environment: Informatica Power Center 5.1/6.2, SAS,Siebel,Teradata, Oracle 8i, Tivoli, Business Objects, Erwin,UNIX,Windows 2000

Confidential

Responsibilities:

• Translation of Business Processes into Informatica mappings for building Data Marts.
• Designed database, logical and physical (relationships, referential integrities, keys capacity planning, object creation) as per business requirements.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets, and Transformations.
• Implemented Aggregate, Filter, Join, Expression, Lookup, Update Strategy, and Stored Procedure Transformations.
• Building design specifications to convert the load of the data marts from PowerBuilder and/or stored procedures to Informatica.
• Understanding source system
• Designing the lookup table
• Preparing the ETL script for extraction, transformation & loading
• Involved in creation of Mappings.
• Extensively used Server Manager to create Sessions & Batches.
• Involved in preparing the high level & low level design document for ETL
• Involved in preparing the test plans

Environment: Windows, Oracle 8i, Informatica 5.1,Business Objects5,Cobol Source, Power Builder

Confidential

Responsibilities:

• Gathering the requirements
• Analysis of the specifications provided by the clients
• Designing the actual flow of the module
• Design and Development
• Coding
• Writing test cases, unit testing and Integrity testing.

Environment: Oracle 7.3, VB, Windows NT