SUMMARY:

• Over 7+ years of experience in IT with more than 5 years of strong Data warehousing experience in Development, Administration, designing and implementing Data warehouse applications using Informatica Power Center, Business Object Data Integrator and DataStage and, SAP Business Objects Reporting.
• To join a highly technical team and build a career as Informatica developer/Administrator or Business Objects Reports Developer/Administrator where my skills and expertise in Informatica with oracle, Vertica and Teradata database with Unix/Linux/windows environments and will be fully maximized to achieve the company's goals and objectives.
• Involved in the full System Development Life Cycle of a data warehouse and responsible for designing, coding, testing, implementing and supporting the Applications with Informatica as the ETL tool and Business Objects as the Reporting tool and processes for data warehouse solutions and related data marts.
• Strong experience in support of Business Objects Crystal reports and Webi Reports.
• Supported Qlikview Dashboards.
• Backup and Recovery oracle databases on Unix using Sunsolaris and Windows using Ghost.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing and Administration of Data Warehousing using Oracle, Vertica and Teradata databases in Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL) .
• Strong experience in support, development and administration of mappings and processes using Informatica power center, Business objects Data Integrator and DataStage.
• Extensive experience in Data Modeling (3NF) and data/process design experience specifically leveraging STAR schema and knowledge of SNOWFLAKE schema.
• Strong experience in PL/SQL stored procedures, triggers, packages and functions.
• Team player, Excellent Interpersonal Skills and self - starter, capable of working independently
• Have the ability to set and achieve project goals, emphasizing a team approach to produce results.
• Good experience with knowledge and excellent scripting experience in UNIX shell scripting.
• Good experience in Perl, awk and Sed Scripting.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 7.1, Business Objects Data Integrator, DataStage 7.0.1, SQL * Loader

Databases: TeraData, Oracle 7.x/8.i/9i, 11g, SQL Server 9.0/2005, MS-Access97/2000

Data Modeling Tools: UML, Rational Rose, Microsoft Visio 2002/2003

DB Analysis Tools: PL/SQL Developer, Oracle,Enterprise Manager, SQL Server Enterprise Manager, TOAD

Languages: SQL, PL/SQL, Visual Basic

Office Automation: MS Office 2000/2003/2007 (Access, Excel, PowerPoint, Word)

Operating Systems: Windows95/98/2000/NT, HP-UX

Unix skills: Shell Scripts, Perl, Awk, Sed.

PROFESSIONAL EXPERIENCE:

Confidential

Datawarehouse Developer

Responsibilities:

• One of the Main support of CRDW application from end to end tasks and processes related to Informatica, Business Objects, Qlikview and Tidal.
• Customer issues with reporting are logged in HPSM (HP Service manager application). Address and resolve any Customer issues relating to data mismatch.
• Being the main support role of CRDW, addressed many Priority tickets to resolution.
• Complete setup of Informatica, Business Objects, and crystal reports from scratch for Confidential Client as an individual stack of Staging and Production.
• Migration of reports from stage to production environments.
• Adhoc Data loads where needed to address issues.
• Provide user accesses with proper permissions.
• Support of Qlikview dashboards to address Qlikview services issues and jobs.

Confidential

Responsibilities:

• Created Bteq scripts, FastLoad scripts and Mload scripts.
• Created Informatica mappings and Workflows.
• Analyzed the data and fix the issues in the Bteq scripts.
• Performance tuned the skewed scripts by making sure data is distributed in proper amps.
• Created Packages that has several functions that gets the data from several tables and is sent to the front end application.

Confidential

• Worked on three major interfaces Fast CSA, Fast 99M and Postal Wizard using Informatica as the ETL Tool.
• Gathered requirements and designed the ETL mappings.
• Set up and installed Informatica client and configured to connect to various database instances.
• Created several Source definitions to retrieve data from flat files, xml files and database tables.
• Extracted data from xml using xml source qualifier to target database.
• Extracted data from different source tables using complex joins and passed the data through XML generator to JMS.
• Used MQ client to view the data being extracted into JMS.
• Editix 2009, XML Spy to validate the data being extracted to JMS and main XML file.
• Used XML Generator, Aggregator, Expression, Filter, Lookups, Joiner, Update Strategy, Sql and many other transformations.

Environments: Informatica Power Center 8.6.1, Oracle 10g

Confidential

SureWave Mobile Server developer

• Designed and developed tables and other required database objects.
• Designed and developed web interface using JSP.
• Involved in setting up Weblogic application server and configuring it as per the requirements.
• Involved in analyzing the user requirements.
• Developed business logic to read data from database using JDBC and present them on web interface.
• Involved in testing the application functionality of each feature using Win Runner on the desktop.
• Performed stress testing using Load Runner. Identified defects, anomalies and potential product improvements.
• Reported the defects using Test Director.
• Provided recommendation for defect solution to Engineering Team.
• Developed test plans and test cases for current and future application releases.