SUMMARY:

• Over 15+ years of IT experience in analysis, design and development and Integration of various Datawarehousing and Client Server Business Applications.
• 12+ years of professional work experience in analyzing and development of Data warehouse/Data Mart applications.
• Extract, Transform and Load of Business Information using ETL tools Informatica, OWB, SSIS, and Datastage with Strong Industrial experience includes Manufacturing, Power Utility, Financial and Telecommunications.
• 3+ years of experience in OLAP/ROLAP reporting tools OBIEE 11g/10g / Confidential Analytics 7.8.4/7.7.1/7.5.3, BO, Microstrategy 7i/6.0.
• Worked with clients/users, business analysts and technical staff to design, develop and enhance data warehouse models, Business Intelligence solutions, procedures and metadata for relational databases.
• Good Experience in creating Data marts / data warehouse (Star Schema / Snow - Flakes) and dimensional Modeling (Kimball Methodology) for OLTP Systems.
• Strong Knowledge in SQL and PL/SQL.
• Knowledge in developing the UNIX Shell Scripts (Bourne and Korn).
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, Teradata, SAP 3.1H, Ms Access, Flat files into a staging area.
• Knowledge in HTML, XML, JavaScript, VBScript.
• Ability to work effectively while working as a team member as well as individually.
• Interacted with Business users to analyze the Business process and made changes to the schema objects according to their report requirements.

TECHNICAL SKILLS:

Methodologies: SDLC, Ralph Kimball and Data Warehouse Methodology.

ETL Tools: Informatica PowerCenter 5.x - 10.x, Informatica BDQ 10.2 Informatica Data Quality 8.6.1 - 10.x (IDQ), Informatica EDC 10.2Informatica MDM 10.x, Informatica DVO 9.x, MS-SSISOWB, MS-SAS,TOAD, SQL*Loader, Oracle Datamart Suite.

Data Modeling Tools: Erwin, SilverRun, Designer 2000 and MS-Visio.

Languages: SQL, PL/SQL, T-SQL, SQL*Plus, VBA, COBOL, JCL, C.

ERP & CRM: Oracle Financials 11i, People soft 8.0/7.5, SAP and Confidential .

Databases: Oracle 9i/ 8i/ 8.0/ 7.x, MS-SQL Server 7.0/6.5/2000/2005, MS- Access, Sybase, Teradata, Netezza, DB2, VSAM and Flat Files.

BigData: Cloudera Hadoop 5.12, Horton Works 2.6

Hardware: Confidential PC Compatibilities, SUN/HP Workstations.

Operating Systems: Ms-DOS, HP-UNIX, Sun Solaris, SCO-Unix, MVS/ESA, Windows

Reporting Tools: OBIEE 10g/11g, Confidential Analytics 7.x, Microstrategy 7i, BO, Cognos.

Other Tools: Developer 2000, VB, TOAD and MS-Office Suite

WORK EXPERIENCE:

Sr. Informatica Administrator / Infrastructure services Engineer

Confidential

Environment: Informatica PowerCenter 10.2 / 9.6, Informatica Data Quality, Data Validation Option(DVO), Informatica Metadata Manager, Informatica MDM 10.1, Oracle 11i, RHELinux, VMWare ESXI 4.1, Windows

Responsibilities:

• Installed and configured Informatica 9.6 in a multi-node environment with web layer components exposed to end users from the separate node other than PowerCenter on RHEL 6.7(64-bit) on VM Ware ESX4.1 in Prod and Sub-PROD environment .
• Done pre-installation checks and spotted the issues with the O/S, various database clients that Informatica communicates with and O/S privileges etc.
• Installed and configured Data Validation Option (DVO) in Sub-Prod environment servers.
• Installed Infomatica MDM 10.2 and Websphere server 8.5.5.1 in both Sub-Prod and PROD.
• Created and configured different services like model repository, Content Management, Data Director, Data Integration, Analyst(previously known as RTM), Data Quality Content etc.
• Responsible for the repository upgrades from previous version 9.6 to 10.5 and also migrations from DEV to TEST, UAT and then to PROD.
• Configured LDAP services to give users access to Informatica services thru network credentials. Also created fewer native users inside Informatica.
• Installed and configured Informatica B2B DataExchange service.
• Did troubleshooting with the relational connections inside Informatica workflow Manager created by other users. Resolved connectivity issues.
• Also created technical document for different installations like Informatica Client, Server, Services, DVO and its Client.
• Worked with address validation licenses and address doctor databases for IDQ Mappings.

Informatica Administrator / ETL Architect

Confidential, FL

Environment: Informatica PowerCenter 9.5 / 8.6.1, Informatica Data Quality, Informatica PowerExchange 9.x, Data Validation Option(DVO), Informatica Metadata Manager, Informatica MDM, Oracle 10g/11i, Teradata 13.10, SQL Server, Netezza, RHELinux, VMWare ESXI 4.1, Windows 7

Responsibilities:

• Created the Technical Architecture and specifications document for the installation of Informatica 9.5 in a grid environment.
• Installed and configured Informatica 9.5 in a Grid environment across two locations (Alpharetta, GA and Chicago, IL) on RHEL 5.6(64-bit) on VM Ware ESX4.1 in Stage environment and on single node in Development environment.
• Done pre-installation checks and spotted the issues with the O/S, various database clients that Informatica communicates with and O/S privileges etc.
• Installed and configured Data Validation Option (DVO) in Development and Stage environment servers.
• Created and configured different services like model repository, Content Management, Data Director, Data Integration, Analyst(previously known as RTM), Data Quality Content etc.
• Responsible for the repository upgrades from previous version 8.6 to 9.5 and also migrations from DEV to STAGE and then to PROD.
• Configured LDAP services to give users access to Informatica services thru network credentials. Also created fewer native users inside Informatica.
• Installed Informatica on cloud based servers for Salesforce application.
• Did troubleshooting with the relational connections inside Informatica workflow Manager created by other users. Resolved connectivity issues.
• Also created technical document for different installations like Informatica Client, Server, Services, DVO and its Client.
• Worked with DVO to run the table pairs validation checks.

DWH Architect / Team Lead / BI Consultant

Confidentia

Environment: OBIEE 10g/11i, Admin Tool, Analytics Web (Answers, Dashboards), DAC, Informatica PowerCenter 9.0.1/8.6.1, Oracle 10g/11i, Unix, Windows XP etc.

Responsibilities:

• Developed meta data repository in physical layer, business model and mapping layer and presentation layer of OBIEE administration tool.
• Analyzed technical requirements and used metadata design principles to design repository and followed best practices and Installed and configured OBIEE Server components.
• Extensively worked with variable manager to create session and repository variables.
• Worked with join manager to create physical and logical joins in OBIEE administration tool.
• Created Homepage dashboard and it contains logos to the several hidden dashboards. By clicking the logos, user can easily navigate to the respective dashboard.
• Created several reports including table view, pivot table view and chart view and dashboard prompts and filters in OBIEE answers
• Created several dashboards like scorecard dashboard, top 10 customers, top 10 wins etc.
• Created global filters in the dashboards to avoid excessive data showing up in the dashboards
• Created several dashboards like campaign tracking and advisor dashboard, dashboard pages and links to the reports in dashboard pages.
• Worked on ETL mappings design, development and deployment and server administration.

ETL Informatica Administrator / Team Lead /Architect

Confidential, TX

Environment: OBIEE 10g, Admin Tool, Analytics Web (Answers, Dashboards), Informatica PowerCenter 9.0.1/8.6.1, Oracle 10g/11i, SQL server, Sybase, Unix, Windows XP, MS-Visio, Control-M, Toad, Golden Gate etc.

Responsibilities:

• Installed and configured OBIEE Server components
• Analyzed technical requirements and used metadata design principles to design repository and followed best practices
• Created several reports including table view, pivot table view and chart view in OBIEE answers
• Created several dashboards like scorecard dashboard, top 10 customers, top 10 wins etc.
• Created several dashboards, dashboard pages and links to the reports in dashboard page
• Created global filters in the dashboards to avoid excessive data showing up in the dashboards
• Customized all the dashboards and reports to look and feel as per the business requirements
• Tested and validated reports and dashboards.

Principal DWH Consultant / Team Lead

Confidential

Environment: Informatica PowerCenter 8.6.1, Teradata, Oracle, OBIEE, Confidential, Sybase, Unix, Windows XP, MS-Visio, XML, Appworx, Toad, Golden Gate etc.

Responsibilities:

• Developed meta data repository in physical layer, business model and mapping layer and presentation layer of OBIEE administration tool.
• Extensively worked with variable manager to create session and repository variables.
• Worked with join manager to create physical and logical joins in OBIEE administration tool.
• Created Homepage dashboard and it contains logos to the several hidden dashboards. By clicking the logos, user can easily navigate to the respective dashboard.
• Created dashboard prompts and filters in OBIEE answers.
• Extended Analyzed technical requirements and used metadata design principles to design repository and followed best practices.
• Created and developed several business models in business model and mapping layer in the form of star schema.
• Created several reports including table view, pivot table view and chart view in OBIEE answers.
• Created several dashboards like campaign tracking and advisor dashboard, dashboard pages and links to the reports in dashboard pages.
• Customized all the dashboards, reports to look and feel as per the business requirements.
• Created groups and users in OBIEE repository and administered visibility to the presentation catalogs.
• Administered both data level and object level security based on business requirements.
• Tested and validated the repository, reports and dashboards.
• Created design specifications for the creation of mappings and converted business specifications into transformation logic to generate XML files with 2000 records in each.
• Involved in trouble shooting the query performance, mappings, sessions etc.
• Planned informatica workflow scheduling with Shell scripting during development and testing and production.
• Monitored the loads thru

DWH Architect / Datawarehousing Consultant / Team Lead

Confidential, TX

Environment: Informatica PowerCenter 8.6.1, Informatica Data Quality (IDQ) 8.6.1 MS-SQL Server 2005, Oracle 9i, SSIS, SSAS, Peoplesoft, OBIEE, Oracle DAC, Mainframe, Teradata, NDM, ERWin, Sun Solaris, Windows XP, Appworx, Toad etc.

Responsibilities:

• Analyze the source systems data and defined metrics and dimensions for the datamart project.
• Developed data model diagrams for the datamart in Starschema and snowflake using dimensions and Facts with ERWin tool.
• Extensively worked with Business clients to understand the business requirements and to gather the business specifications and also to convert them into tech specification.
• Worked with Project Manager in getting the approval for the test results and also for sign off
• Assign work to the offshore resources and help them in developing the ETL routines with the given tech specifications.
• Documented the Technical specifications for the development and coding efforts.
• Created Data Quality Plans using the workbench of the Informatica Data Quality (IDQ) to standardize the Confidential ’s serviceable addresses and get the open for sale metrics.
• Designed the datamart in Starschema and snowflake using confirmed and local dimensions as well with ERWin and created tables in Oracle Database.
• Worked with Business in getting the approval for the test results and also for sign off
• Created design specifications for the creation of mappings and converted business specifications into transformation logic.
• Involved in trouble shooting the query performance, mappings, sessions etc.
• Planned informatica workflow scheduling with Scheduler during development and testing and thru Appworx in production.

Sr ETL Informatica Consultant

Confidential, NYC, NY

• Environment: Informatica Powercenter 7.1.2, Sybase ASE 12.5.3, Linux - Intel, Windows XP, DB-Artisan, flatfiles, Perforce.
• Worked on the Modelware lite Datamart which has the external companies financial data supplied by the vendor.
• The data is sent by the vendors on a regular basis in flatfiles. The data is loaded into the Sybase ASE DB and is used for reporting thru the front-end.

Datawarehouse Consultant (Informatica)

Confidential

Environment: Informatica 7.1.2, Oracle 10g, Autosys, HP-Unix, Windows XP, Toad, PVCS.

Sr. Informatica Developer

Confidential, Northbrook, IL

Environment: Informatica 7.1, Oracle 9i, PeopleSoft, Oracle Financials 11i, Autosys, Metify, Sun Solaris, Windows XP, Toad, Cognos

Technical Manager

Confidential, Chicago, IL

Environment: ERWin, Oracle Warehousebuilder(OWB) 10g, Oracle 10g, TOAD, Sun Solaris, Windows 2000, Microstrategy 8, Infinium.

ETL Informatica Consultant

Confidential, Sanfrancisco, CA

Environment: Informatica Powercenter 6.1/7.1, Oracle 8i/9i, TOAD, SQL*Plus, Autosys, Sun Solaris, Citrix Metaframe XP and Windows XP/2003.

ETL Informatica Consultant

Confidential, Boston, MA

Environment: Informatica Power Mart 6.1, Oracle 8.1.7, Oracle 9i, TOAD, SQL*Plus, People Soft 8.4, People Tools 8.4, SQR, Peoplesoft EPM 8.8, Control-M, Microstrategy 7.2.2, Citrix Metaframe XP, Windows 2000

Data Analyst

Confidential

Environment: Oracle 8.1.7, Informatica*Power center v 5.1, Confidential 7.5.3, Confidential Analytics, Windows 2000, Snow Flake schema, First logic, Unix, Visio, SQL, PL/SQL, PVCS, Toad and MS-Office