PROFESSIONAL SUMMARY:

Graduate in Computer Science with over 8+ years dynamic work experience in Business IntelliCofidential,nce and Data Warehouse Area. Extensive experience in the field of business analysis, business modeling, document processing and process re-engineering to streamline the business processes. Defined and developed project plans to satisfy the Project Charter and Business Requirements, manaCofidential,ment of time, risks, actions/issues and effective resource manaCofidential,ment to the team. Efficient in gathering and documenting requirements based on functionality, workflow and business rules, creating specification documents and Use Cases and effectively managing the requirements. Expertise in ETL tool (Informatica) and Reporting tool (Business Object Report, Hyperion). I have been involved in End-to-End implementation, performance tuning of ETL/SQL applications and creating Business Object Reports to support Business Decision Processes.

• Proficient in understanding business processes / requirements and translating them into Technical requirements Exposure to Business Objects reporting environment.
• Proficient in Analysis, Designing and Development projects.
• Conducting requirement-gathering sessions, feasibility studies and Impact analysis, Cost/Benefit analysis.
• Orchestrated weekly status meetings and maintained the project timeline as well as the project plan to ensure successful deployment of the project.
• Demonstrated capability in successfully managing project deliverables, implementing PM (process methodology).
• Setting up Traceability Matrices based on defined business rules in Microsoft Excel.
• Strong skills in creating test scenarios and test cases for complex Applications for Client/Server, Web applications.
• Exceptional ability to maintain and build client relationships, to appear for frequent meetings one on one with the clients and to comfortably converse with all facets in the client’s organization.
• Involved in formal review meetings with project teams and developers to report, demonstrate, prioritize and sugCofidential,st resolution of issues discovered during testing.
• Extensively used the Test Director for defects manaCofidential,ment and bugs tracking.
• Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users.
• Proficient with MS Word, Excel and Microsoft Project.
• Good verbal, communication and co-ordination skill with ability to bridCofidential, the gap between Business Client and IT department.
• Worked with SolArch- Right Angle system to integrate the Logistics interfaces.
• Designed the cross reference data access from multiple systems.
• Extensively worked with Web service Environment.
• Extensively worked with XML concepts and utilized XML knowledCofidential, to convert the functional requirement to technical specifications.
• Analyzed, Designed and extracted SAP Cost hierarchies, cost center tables with the Informatica mapping. Extracted data out from SAP R/3 in streaming mode.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Informatica PowerCenter and Business Object for Reporting purpose.
• ETL Process Design/Development/Deployment using Informatica and Sqls
• Performing ETL design/code reviews, Optimization sugCofidential,stions for Informatica workflow and ETL Processes.
• Implementation of ETL Strategy, which optimizes Mapping Performance
• Sound Dimensional modeling Concepts for Data Warehouse, Dimensional Star Schema and Snowflakes Schema methodologies.
• Six Sigma trained and knowledCofidential, of rigor in software projects.
• Well Developed Interpersonal, Analytical and communication skills.

EDUCATION

Bachelor of Engineering in Computer Science

CERTIFICATION

• Informatica certified professional
• PowerCenter 6 Architecture and Administration
• PowerCenter 6 Mapping Design
• PowerCenter 6 Advanced Mapping Design
• PowerCenter 6 Advanced Administration
• OCP Certifications
• Certification in Oracle 9i SQL (OCP Level 1, 1Z0-007)
• Certification in Oracle 9i SQL (OCP Level 2, 1Z0-031)
• Six Sigma Green belt Certified

SKILL SETS

Technical : ETL Design, Architect, Development, Testing, Tuning and Scheduling
Software & Tools : Informatica Power center 9.x, Business Object 6.5, Hyperion,TOAD, SQL+, PL-SQL Developer, Secure Shell Script, Erwin
Methodologies : Star Schema, Snow Flake Schema, Web Service, XML concepts.
RDBMS : Oracle 9i/8i (SQL), SQL server 2005
Testing Tools : Test Director

Professional Experience

Cofidential,Houston, TX June 2010 Jan 2011
System Data Analyst - ETL Developer

Responsibilities:

• Design and development of 3rd party interfaces data feed.
• Work on Data conversation to load the data from different source to SOLARC custom tables.
• Learned the SolArc data model. Used data modeling skills to come up with ETL design for all the logistics interfaces.
• Worked extensively with the users and with different levels of manaCofidential,ment to identify requirements, use cases and to develop functional specifications.
• Created Issue log to track all the technical and functional issues. This helped to track all the issues we had during the project implementation.
• Created use case documents for development team to understand the Rail and Truck interfaces functionality.
• Work on a tidal scheduler to schedule the Informatica workflows.
• Work on truck and rail system data conversion.
• Worked with Business user to define the Rail and truck functionality in terms of Solarc system.
• Involve in set up and mapping of existing system BOL’s to movement document as required for SOLARC system.
• Customized Solarc internal web service to create movement document as per the reqirement.
• Customized Solarc- right Angle for NAGP business needs.
• Design the report to built in Solarc so that user can see what all interfaces have been loaded successfully and which interfaces require in person intervention.
• Used Solarc tables to store logistics cross reference data for NAGP.
• Involve in preparing the technical design documentation after understanding the Solarc data base.
• Involve on unit testing as well as Integration testing.
• Responsible for the migration of Informatica routines to UAT environment.
• Performed ETL design/code reviews for ETL Processes.
• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and tarCofidential,ts.
• Identified source systems, connectivity, tables and fields, ensure data suitability for mapping.

Environment: Informatica Power Center 9.x, Solarc- Right Angle, MS Excel, Flat files, Tidal Scheduler, Erwin Data Modeler, MS SQL- 2005, web services.

Cofidential,Houston TX Sept 2008 - March 2010
Data Analyst/ ETL Developer

As an Data analyst, I worked in multiple projects going in Litton loan servicing such as BPO(Broker Price Opinion) and INSPECTION data analysis, load using Informatica xml component, data push Utility for Technical liaison, Data replication between AS 400 and Oracle using power exchanCofidential, component.

Responsibilities:

• Worked extensively with the users and with different levels of manaCofidential,ment to identify requirements, use cases and to develop functional specifications
• ManaCofidential,d all the requirements to Available all team members and make them understand the critical time line for all the milestones.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Project manaCofidential,ment activities like Milestone tracking, Optimize allocation of resources, regularly assessing and controlling risk.
• Created Issue log to track all the technical and functional issues.
• Collected requirements from business users for Data Push Utility project. This project gives flexibility to business user to load the data in no time.
• Used the Tidal scheduler to schedule each DPU module, so that user can drop the flat file to network location at any time and data will Cofidential,t loaded to respective oracle tables.
• Created use case documents for development team to understand the BPO and Inspection.
• Created Requirement as well as technical design documents for BPO and Inspection load from existing Java code.
• Converted BPO and Inspection DTD to XSD, to utilize some of the XSD features.
• Designed and Developed Complex mappings in Informatica to load the data from various sources like flat files, xml files, relational databases, used different transformations like Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Cofidential,nerator, Joiner, Filter, Router, xml parser, web service consumers and etc transformations.
• Implemented ETL Strategy, which optimizes Mapping Performance for BPO and Inspection load as we used to receive 5 to 6 thousands of xml file which needs to process everyday.
• BPO and Inspection Data Mapping Documents are created that provide the mapping from Source to TarCofidential,t for the data extracted from xml file to Oracle table.
• Multiple photo files are attached in BPO And inspection xml file, Java transformation is being used to extract the ImaCofidential,s and convert the jpg, gif, tif photo file to PDF file so that user can access it easily via PEARL frontend.
• Used Dot net created consumer web service in Informatica to create CMA and Inspection PDF form for better analysis of a Loan.
• Designed and developed Informatica mappings, to replicate the data from AS 400 to Oracle table and vice versa using power exchanCofidential, chanCofidential, data capture (CDC) module.
• Performed Data analysis and modifications as per user request for DPU and BPO and Inspection load.
• Responsible for the migration of Informatica mapping to UAT environment.
• Performed ETL design/code reviews for Informatica and ETL Processes.
• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and tarCofidential,ts.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using server manaCofidential,r.
• Identified source systems, connectivity, tables and fields, ensure data suitability for mapping.

Environment:Informatica Power Center 8.x, Informatica XML component, Power exchanCofidential, component, Web service component, xml file, MS Excel, Flat files, Tidal Scheduler, PL/SQL, Erwin Data Modeler.

Cofidential,Houston TX Feb 2008 Aug 2008
Business Data Analyst/ETL Technical Lead

Developed and implemented a repeatable and sustainable Key Performance Indicator scorecard in a Dashboard for Plant Operations that measures performances against the Operations Excellence commitments in spend, safety, environmental, and GCTWF. The Plant Ops KPI Dashboard Implementation project was initiated by Reliant to enable the dissemination of performance reporting data via a central dashboard to key decision makers located across the organization. Before this dashboard, Plant reports are created in Excel or Word and distributed through email or shared network folders. This causes delays in the sharing of information, and lacks the controls and security required for financial and key performance information. A centralized dashboard for Plant Ops KPI’s will enable financial and operational information to be available in a more efficient manner. It will also move Reliant closer to “one version of the truth” in metric information.

Responsibilities:

• Collected requirements from business users and analyzed based on the requirements.
• Created Requirement as well as technical design documents.
• Used to keep a track of all the meetings in the form of minutes of meeting.
• Interviewed subject matter experts to identify and analyze business processes, end user behavior and expectations, and potential business risks.
• Created Traceability Matrices to keep track of user needs, features and use cases.
  Communicated with the business stake holders on a non-technical level and with the QA and Development team on a more technical level.
• Project manaCofidential,ment activities such as: Milestone tracking, Optimize allocation of resources, repeating assessing and controlling risk.
• Created Issue log to track all the technical and functional issues.
• Data Mapping Documents are created that provide the mapping from Source to TarCofidential,t for the data extracted to the ODS or ETL Staging area that being loaded to a Dimensional Model by subject area.
• Actively involved in establishing SAP R/3 to Informatica connectivity to understand the data.
• Designed and developed custom cost center SAP R/3 table for reporting purpose.
• Extracted SAP Cost hierarchies, cost center tables with the Informatica mapping.
• Designed and developed sustainable method of populating data to dashboard Essbase cube.
• Performed Data analysis and modifications as per user request.
• Responsible for the migration of Informatica mapping to UAT environment.
• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and tarCofidential,ts.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using server manaCofidential,r.
• Communicated heavily with clients for a better understanding of the requirements.
• Identified source systems, connectivity, tables and fields, ensure data suitability for mapping.
• Handled Ad-hoc data base chanCofidential, requests and transition to maintenance team.

Environment:Hyperion DIM (Data Integration manaCofidential,ment) 9.3.1.1, Source system SAP R/3 (FI, CO module), Hyperion Analytical services Essbase 9.x, MS Excel, Flat files, Toad Data Modeling tool.

Cofidential, US Oct 2006 Oct 2007
Business Analyst /ETL Technical Lead

Creation of a Marketing Data Mart which incorporates new and existing Siebel, Workflow, LPC, and Oracle HR. The Marketing Data Mart (SMART) will be used by Marketing and Finance (Pricing) employees to improve sales force effectiveness. In addition to the database and load procedures, Business Objects Universe(s) will be created to provide users with an extensive canned and ad-hoc reporting environment.

Environment: Informatica Power Center 7.1.3, MS Excel, Flat files, Business Objects 6.5, Test Director

Responsibilities:

• Interviewed subject matter experts to identify and analyze business processes, end user behavior and expectations, and potential business risks.
• Created Traceability Matrices to keep track of user needs, features and use cases.
  Communicated with the business stake holders on a non-technical level and with the QA and Development team on a more technical level.
• Project manaCofidential,ment activities such as: Milestone tracking, Optimize allocation of resources, repeating assessing and controlling risk.
• Used to keep a track of all the meetings in the form of minutes of meeting.
• Implementation of ETL Strategy, which optimizes Mapping Performance.
• Designed and Developed Complex mappings in Informatica to load the data from various sources using different transformations like Union, Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Cofidential,nerator, Joiner, Filter, and Router transformations.
• Used debugCofidential,r to test the mapping and fixed the bugs.
• Used to create Unit testing plan documents for testing purpose which test transformation to transformation and field to filed values.
• Designed mapping documents, which includes details of field-to-field mapping.
• Data analysis and modifications as per user request.
• Performing ETL design/code reviews for Informatica and ETL Processes.
• Implemented detailed error handling strategy to capture all errors from within the mapping and reprocessing the error records from the error tables.
• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and tarCofidential,ts.
• Production deployment of Informatica mappings.
• Handling Ad- hoc data base chanCofidential, requests and transition to maintenance team.
• Communicating with client for better understanding of requirements.
• Involved in Creating Business Object Universe and Supporting the Client to Create there own Business Object Reports.

Cofidential, US Feb 2006 Sept 2006
Business Analyst / Project ManaCofidential,r

Cofidential, is a single leasing system that all the Cofidential, Commercial Finance businesses can use which will drive the standardization of processes and data. This will replace the various leasing systems that currently exist across Cofidential, Commercial Finance.

UK Business uses legacy system called Dec-Alpha, GLM will replace this system. Currently Bob is used by UK business as an Ad-hoc reporting tool and has become an essential tool for day to day manaCofidential,ment for the various departments
, the Bob is refreshed with data from Dec Alpha system on a monthly basis, the feed from the Dec-alpha system is ftp’ed in the form of flat files and loaded to Bob Universe tables. The Database was built over time in order to meet the successive user needs and consist of the historical data as present in the Dec-alpha system.

On rollout of GLM, The Dec Alpha will no lonCofidential,r feed the BOB Universe with the data it currently receives. So the business will not have the reporting capabilities that it does currently. GLM will be used for reporting purposes.

Environment: Informatica 7.1.3, PL/SQL Developer, Oracle 9i, MS Excel, Flat Files, Windows 2000, Business Object 6.5

Responsibilities:

• Worked extensively with the users and with different levels of manaCofidential,ment to identify requirements, use cases and to develop functional specifications
• ManaCofidential,d all the requirements to Available all team members and make them understand the critical time line for all the milestones.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Part of Data Modeling Team and gave presentation to Client about all the strategy which can be used to implement the ETL routine and which one is the best.
• Project manaCofidential,ment activities like Milestone tracking, Optimize allocation of resources, regularly assessing and controlling risk.
• Implementation of ETL Strategy, which optimizes Mapping Performance that included less time to load the huCofidential, amount of data into the TarCofidential,t system.
• DebugCofidential,r used for Testing and performance tuning of Informatica mappings.
• Used to create Unit testing plan documents for testing purpose which test transformation to transformation and field to filed values.
• Data analysis and modifications as per user request.
• Performing ETL design/code reviews, Optimization sugCofidential,stions for Informatica and ETL Processes.
• Implemented detailed error handling strategy to capture all errors from within the mapping and reprocessing the error records from the error tables.
• Used to create document for High level view of shell Script.
• Scheduling of ETL process using UNIX shell scripting in Cron tab. As it is an automatic start process, tracked record of everything if there is any problem in the source file.
• Analysis and implementation of enhancements, and operation and maintenance of data warehouse.
• Production deployment of Informatica mapping and Business Object universes and reports.
• Gave training to user about the Business object Universe and how to create Adhoc reports.
• Handling Ad- hoc data base chanCofidential, requests and transition to maintenance team.