Professional Summary

• 7+ years of total IT experience and technical proficiency in data warehouse teamed with business requirement, analysis, application design, development, testing and documentation.
• Worked extensively in data warehouse using Informatica PowerCenter 8.6.1/8.1.1/7x/6x/5.1.2/1.7, PowerMart 5.1.1/5.0/4.7.2, Siebel Analytics 7.7.1, Cognos 6.1/5.x
• Informatica software upgrade includes complete analysis, installation, and configuration to current available version in development, test and production environments.
• Development of ETLs based on business logic, source data changes and any new customer requests.
• Various windows scripts are also developed for handling pre and post ETL jobs.
• As part of being team player, working closely with teams providing source data, reporting and R&T teams.
• Extensive documentation is done for technical detail designs, unit test, maintenance of trackers or work tickets, analysis documents and any other production supporting documents.
• DW production support on development releases, upgrades, unit tests, system tests, IT server moves, system outages, weekend or holiday support and any other trouble shooting.
• Worked on CMMI level-3I and CMMI level-2 environments (CMS and CDC projects).
• Demonstrated capacities in Data Warehousing OLAP, OLTP, Star Schema, Snowflake Schema, and UNIX Shell Scripting.
• Good knowledge in Oracle 8i/9i/10g/11g databases and SQL Server 7/2000
• Teachable, Highly Skilled, Committed, Enthusiastic, Ambitious, Creative and a good Team member with good communication skills.

Data Warehousing:

ETL - Informatica PowerCenter 8.6.1/8.1.1,7.1.4/6.1/6.2.2/5.1.2/1.7(Source Analyzer, Data Warehouse designer, Transformation Developer, Mapplet Designer, Mapping Designer, Worklets, Workflow Manager, Workflow Monitor, Repository Manager, Repository console, Informatica scheduler), Informatica PowerMart 5.1.1/5.0/4.7.2, Datamart, OLAP, OLTP, Star Schema, Snowflake Schema. Getting trained in SAP BI/BW.

Databases:

Oracle 9i/8i/8.0/7.0, Toad v6.0/v8.0 (Oracle Query Tool), SQL Navigator (Oracle Query Tool), Teradata, MS SQL Server 2000 - Query Analyzer and Enterprise Manager, Netezza, Siebel 6x/7x, MS Access 7.0/97/2000, DB2

Reporting Tools:

Siebel Analytics 7.7.1, Cognos 7.1/6.1, MicroStrategy 8, Developer 2000, MS Access Reports

Programming:

SQL, PL/SQL 7x, SQL*Plus 3.3/8.0, SQL Loader, Visual Basic 6.0/5.0, HTML, C, C++, windows scripting, Unix Shell Scripting

Environment:

Sun Solaris 2.6/2.7, HP-Unix, AIX, Win 3.x/95/98, Windows 2000 server, Win NT 4.0, MS DOS 6.22, Siebel CRM Desktop Application, Erwin 3.5.2 (Data Modeling),WS_FTP Pro, PVCS (version manger)and Putty

• MS in Computer Science and BS, in Chemistry .
• Oracle PL/SQL certification 8 and 8i & Brain bench Data warehousing concepts certified
• BO training .
• OBIEE 11g and ODI 11g Oracle training

Confidential, Sep’11 to Present
Project: Data Management Module (DMM) – OBIEE Dashboard
Senior Consultant – Data warehouse Developer
BEP is a federal government agency who design and manufacturing of various security documents and currency.
The project was based on the integration of various databases, facilities and data elements to create one unified view of the business. In further stages of the project, the integrated data will be used to create a enterprise data warehouse on which business intelligence reporting could be performed.
Responsibilities:

• Involved in Business and Technical Requirements gathering
• Designed, developed logical & physical & presentation data models in OBIEE administration layers.
• Developed reports using Answers tool to incorporate into Dashboards.
• Performed UAT for the various reports and dashboards
• Using Oracle DB populates source data into fact and dimension tables.

Environment: Oracle DB, Oracle Business Intelligence Enterprise Edition, Web Services, Oracle WebLogic, Apache AXIS

Confidential, Aug’10 to Sep’11
Project Immigration and Customs Enforcement (ICE) – OBIEE Dashboard
Senior Consultant – Data warehouse Developer
DHS-ICE, The Office of the Chief Financial Officer (OCFO) provides effective and efficient management of all ICE financial resources through the implementation of best business practices and by linking strategic planning, budgeting and performance reporting.
Responsibilities:

• Involved in Business and Technical Requirements gathering
• Installed and Configured OBIEE 10.1.3.4.1 on Windows XP
• Using Oracle10g DB created scripts to populate source data into fact and dimension tables.
• Designed, developed logical & physical & presentation data models in OBIEE administration layers.
• Developed reports using Answers tool to incorporate into private and public Dashboards.
• Performed UAT for the various reports and dashboards
• Created the mapping documents for technical development.
• Installing, Upgrade and Configured OBIEE 11g

Environment: OBIEE 10.1.3.4.1 (Answers, Dashboards, Administration), Oracle 10g, Win XP

Confidential, Oct’09 to Mar’10
Project: Integrated GTN/P3I (IGC)
ETL Developer
Responsibilities:

• Developed complex mappings with 100 - 200 transformations by following business rules in Source to Target Mappings(STTM)
• Used unstructured transformation to convert source data files to XML files and EDI files;
• Mapped data to flat files, Oracle and imported into Teradata by using TPT’s.
• Created unit test cases, unit test plans based on input from LM standards, Subject Matter Experts(SME), Data Analysts and testers

Environment: Informatica, UNIX, Oracle 10g, Business Objects, Oracle, Teradata, Mercury Quality Center

Confidential,GA Feb’08 to Oct’09
Project: Certified Pre-Owned Reporting (CPOR),
BI support multiple projects
Data Warehousing Developer
AutoTrader.com being one of the sub companies under COX enterprises umbrella is ultimate online solution for buying and selling new, certified and used cars. ATC site is designed to give more control of the buying process and make finding a vehicle easier than ever before. Data warehouse is a user-friendly, flexible Web tool which empowers business users to create custom tailored reports to meet the needs of all the Certified Program Partners.
Responsibilities:

• Develop new or maintain existing Informatica mappings and workflows based on specifications.
• Develop, implement and maintain unit tests for applications. Participating in functional test planning and testing for the assigned applications, functional areas and projects.
• Leading the design of new or changing mappings and workflows and producing requisite specifications.
• Participate in problem solving and troubleshooting for the applications implemented with Informatica.
• Participate in support and ownership of the Informatica platform, including rotating after-hours support.
• Sharing knowledge and Mentor less experienced Engineers.
• Work with the team to ensure the quality of coordinated business functions.
• Respond quickly and effectively to production issues and taking responsibility for seeing those issues thru resolution.
• Participate in requirements gathering, project planning design and maintenance of enterprise data warehouse architecture.

Environment: Informatica Power Center v8.1.1, Sun Solaris, 7.1.5, Oracle 10g, MicroStrategy 8, Web server, SAS, and Java

Confidential,GA Oct’05 to Jan’08
Project: Center for Disease Control (CDC)
Data Warehousing Developer
CDC is one of the key organizations tasked to supports Health and Human Services. Pearson Government Solutions - CDC Data Warehouse project deals with 1800 CDC-INFO line which consists of various subject areas with data from Siebel CRM desktop application, Content data (like Publication, Organization, and Prepared Responses), Performance of Customer Service Representatives supporting customer enquiries, Geography data like state, city and zip codes and Telephony data like IVR by MCI/Verizon, AVAYA. Data warehouse contain data about all contacts made to CDC-INFO contact center via phone calls, emails or faxes, which includes profile of the customers, time factors related to calls (call wait, call handled time) and nature of the calls (i.e. enquiries, requesting information or needed help and escalation of calls to healthcare professionals like doctors and nurses) which are handled by Customer service representatives
Responsibilities:

• Installed, configured and upgraded Informatica from v6.2.2 to v7.1.4
• Worked with multiple sources such as SQL server relational tables, commas delimited flat files, and populate data warehouse tables or generate XML file extracts based on business logic.
• Provided data warehouse production support including error handling, missing source/target files, invalid source/target data and production outages. Email notification is sent to team as part of ETL support.
• Modified Window scripts used in pre or post sessions to pull source data from FTP and place the data in appropriate locations.
• Responsible for Upgrade Informatica from v6.2.2 to v7.1.4
• Installed tools like Informatica, SQL server and Siebel Analytics on workstations and help new members and QA team to a quick start.
• Worked with QA team by giving guidance on testing strategies, transferring knowledge on data sources.
• CMMI level-3I process is followed to capture changes and enhancements;
• Worked on various documents like detail designs, production support document, unit test cases with test plans and Informatica coding & standard documents for future application development; which are checking into version control tool PVCS.
• Reports are generated by using Siebel Analytics for generating standard reports on daily, weekly and monthly basis delivered via dashboards or e-mails to given distribution list. Event based or/and Ad Hoc Reporting generated for any new outbreaks.
• Customized Dashboards production support dashboards are created using Siebel Analytics with Informatica metadata to check session and workflow logs, source data errors, failed records, dimension and fact counts on daily basis.

Environment: Informatica Power Center v6.2.2 and v7.1.4 on Windows, SQL Server 2000- Query Analyzer and Enterprise Manager, Siebel CRM Desktop Application, Siebel Analytics v7.7.1 and OBI v10.3.1.2, Java and PVCS

Confidential,IA Aug’04 to Oct’05
Project: Confidential,
Data Warehousing Developer
Pearson Government Solutions serves the U.S. Federal, state, local, international governments, higher education institutions, student financial aid entities and worldwide telecommunications industries with CMMI level-2 implementation. The CMS Data Warehouse deals with various subject areas like Disenrollment, Fulfillment, WebItems, Genesys, MCI, Benesat, ACD and NGD. Budgeting and forecasting decisions are based on the reports produced using this data warehouse.
Responsibilities:

• Designed the ETL process with balance control procedures, which are the most crucial procedure to get the data from various sources.
• Designed the master workflow to serve the business requirements with dependency hierarchy.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Responsible for Upgradation of Informatica mappings, sessions, worklets, workflows from v5.1 to v7.1. NGD application ETLs are upgraded from v5.1 to v6.1.
• Installed client tools on QA team systems and gave guidance on the new features of Informatica v7.1.
• Worked extensively on Source Qualifier, Expression, Router, Aggregator, Update Strategy, Lookup, Stored Procedure, Sequence Generator and Joiner transformations using Informatica v7.1 for created mappings, sessions, workflows and worklets.
• Created reusable transformations and mapplets and used them in complex mappings.
• Tuned Informatica Mappings and Sessions for optimum performance.
• Worked on Detail design, monitoring instructions, support documents, technical document, and Informatica coding & standards, test cases and test plans and checking in PVCS to reflect the changes and enhancements of changes along with production support for error handling.
• Worked with multiple sources such as Relational tables, flat files, and XML files for source extractions.
• Developed various slowly changing dimensional mappings according to the data mart schemas.
• Developed UNIX scripts to use in pre and post sessions to pull and place the data in appropriate locations.

Environment: Informatica Power Center 7.1/5.1 on Sun Solaris-Unix, Oracle 9i, Windows 2000 server, Cognos 7.1,6.1, Toad v6.0/v8.0 (Oracle Query Tool), WS_FTP Pro, PVCS and Putty

Confidential, Apl’04 to Jul’04
Data Warehouse Developer / production support
Responsibilities:

• Worked on Informatica Power Center 6.1 tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations. Mapplets and Reusable transformations were extensively used wherever required.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent batches and Sessions and scheduling them to run at specified time.
• Executed all the mappings and sessions in Development, Test, QA and Production Repositories using workflow Manager.
• Design mapping document, which is a guideline to ETL Coding and Parsing high-level design spec to simple ETL coding.
• Used Shell Scripts and PMCMD to interact with Informatica Server from 4d-jobs (UNIX) tool with Tivoli notifications.
• Benchmark testing of Hardware vs. Process Speeds for Informatica mappings to calculate the lead times for batch processing (before storm seasons).
• Develop data conversion, integration, loading and verification specifications and design of a mapping specification and creating multidimensional models.
• Setting of Error Logic for streamlining while automating the data loads for cleansing, trapping incorrect data on staging servers and then loading it to the data warehouse.