PROFESSIONAL OUTLINE:

Over 10+ years of experience in IT with more than 7 years of strong Data warehousing experience in Development, Administration, designing and implementing Data warehouse applications using Informatica Power Center, Business Object Data Integrator and Data Stage and, SAP Business Objects Reporting.

SUMMARY:

• To join a highly technical team and build a career as Informatica/Datastage developer/Administrator or Business Objects Reports Developer/Administrator where my skills and expertise in Informatica and Datastage 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 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) like Informatica/Datastage/BO Data Integrator .
• Supported Qlikview Dashboards.
• Backup and Recovery oracle databases on Unix using Sunsolaris and Windows using Ghost. •Strong experience in development and administration of mappings and processes using Informatica power center, Business objects Reports, Data Integrator and Data Stage.
• 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 9.6.1, Business Objects R3.1, Qlikview, Tidal, Business Objects Data Integrator, DataStage 9.1, SQL * Loader

Databases: Oracle 7.x/8.i/9i, 11g, 12g, Teradata, Vertica, SQL Server 9.0/2005, MS-Access97/2000Data 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

Responsibilities:

• Develop controls to the files sent by source systems.
• Modify Informatica mappings to apply some controls.
• Develop Linux shell scripts.
• Involved in the server migration activities like DTS server configuration.

Env: Informatica 10.1, Linux, Oracle 12g

Confidential

Responsibilities:

• Currently working on coding Informatica mapping to match to the Confidential compensation System.
• Fully responsible for the complete project from end to end.
• Performed Source to Target analysis.
• Designed and developed Informatica ETL mappings with complex transformations that Sales team can drill down to Line items level calculations.

Confidential

Responsibilities:

• Performed Source to Target analysis of each Datastage mapping.
• Converted Data stage mappings to Informatica using transformations like Aggregator, Expression, Filter, Lookups, XML Generator, Joiner, Update Strategy, Sql and many other transformations
• Created Source to Target mapping Documents.

ENV: Informatica 9.1, DataStage 9.1, Oracle 12g, Unix.

Confidential

Responsibilities:

• Fully responsible for the complete project from end to end.
• Performed Source to Target analysis of all the financial systems Oracle Store Procedures.
• Designed the end to end flow of the system.
• Created about 90 Informatica mappings with transformations like Aggregator, Expression, Filter, Lookups, XML Generator, Joiner, Update Strategy, Sql and many other transformations
• Created Source to target mapping documents.

ENV: Informatica 9.1, Oracle 12g, Unix.

Confidential

Sales Representatives

Responsibilities:

• Analyzed the existing commissioning system.
• Performed Source to Target analysis.
• Designed and developed Informatica ETL mappings with complex transformations that Sales team can drill down to Line items level calculations.
• Created Source to target mapping documents.

ENV: Informatica 9.1, Oracle 12g, Unix.

Confidential

Responsibilities:

• Lead developer and Administrator 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 Critical Customer issues relating to data mismatch.
• Enhance the ETL mappings based on requirement.
• Telephony is one of the Source to CRDW ETLs. Created ETL that extracts from the Telephony system to CRDW.
• Created ETLs that extract the data from over 70 OVR servers which are the target SQL Server 2008 database servers in each region of Americas, Europe and Asia Pacific regions.
• Aggregator, Expression, Filter, Lookups, XML Generator, Joiner, Update Strategy, Sql and many other transformations
• Mentoring junior developers.
• Complete setup of Informatica, Business Objects, and crystal reports from scratch for Confidential and UKPS Client as an individual stack of Staging and Production.
• Implemented Informatica, Business Objects, Crystal reports for UKPS client in Scotland.
• 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.

ENV: Teradata- Bteq, Fastload, Mload, Informatica- Power center, Oracle, Unix.

Confidential

Lead developer and Administrator

Responsibilities:

• Installed and set up Informatica env. Migrated ETL mappings and work flows to test environment from development environment using deployment groups.
• Scheduled Workflows and monitor tasks.
• Created several complex ETL mappings using Informatica Power center. Fixing the bugs in the ETL mappings.
• Data Profiled source files using Data Explorer.
• Involved in the design of ETL
• Created Design documents for the ETLs.

ENV: Teradata, Informatica Powercenter 8.6.1, Data Explorer, Data Quality.

Confidential

Responsibilities:

• 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 Confidential 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.
• Used 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.

Environment: s: Informatica Power Center 8.6.1, Oracle 10g

Confidential

Responsibilities:

• Involved in complete SDLC of Data warehouse.
• Developed ETL scripts using Business Objects Data Integrator in major releases.
• Developed complex ETL jobs for populating many dimension tables and fact tables using transforms like Query Transform, Sql transform, Case Transform, Map operation, Table comparison, Data Transfer and many more.
• Created Developed complex mappings from source to target.
• Loaded Data from Excel spread sheet into Target tables making use of Data Transfer Transform.
• Developed DTS Packages to FTP the source files from servers to DMZ servers.
• Developed several SQL queries, Stored Procedures, functions in a MS SQL Server Data Warehouse.
• Actively involved in the maintenance of the EDW.
• Tuned the ETL scripts to improve the performance of the ETL jobs.
• Actively worked with other Business Objects developers to ensure target data warehouse integrates with BOBJ universe/ reports.
• Migrated ETL files from Development environment to Test and Production servers.
• Actively involved in the development of Universes and BOBJ Reports.
• Worked with BOBJ Technical support to resolve performance issues.

Confidential

Network Administrator

Responsibilities:

• Created and maintained Unix shell scripts to take the backup of oracle databases.
• Created and maintained Unix shell scripts to take the backup of entire server.
• Configuration of Sun StoreEdge Enterprise Net backup.
• Transferred database and server backups from Sun Solaris Unix servers to backup servers.
• Performing Tape rotation and Vaulting using Network Administrator tool.
• Took backups of Windows HP servers using Ghost tool.
• Recover backups from Tapes to backup servers.
• Recover backups from backup server to validation server installing Sun Solaris.

Technical Support

Responsibilities:

• Involved in the complete cycle of the project from Analysis, Designing, Mapping fields, Coding and Testing (end - to-end).
• Designed an RMT tool that loads the data from number of Excel spreadsheets to database tables on the SQL Server.
• Developed RMT File Generation Tool that generates Excel reports and pre-populates the data from the SQL Server database.
• Extensively used macros and SQL queries to interact with databases.
• Also used DTS Packages to load immense data from Access files to database tables.