SUMMARY:

• Four Years and Half (4.6) of Total IT Experience in Analysis, Design, Development, Implementation, Testing and maintenance of Business Intelligence solutions using Data Warehousing/Data mart design, ETL, OLAP,OLTP client /server applications.
• Strong Data warehousing and ETL experience using Informatica Power Center and IDQ 9.5/9.1.x/9.0.x/8.6.x Meta data Manager, IDQ Developer/Analyst 9.5.1, Warehouse Designer, Source Analyzer, mapping Designer, Transformation Developer, Mapplet Designer, Mapping Designer,Shell Scripts creations.
• Good knowledge upon RDBMS, OLAP, OLTP, Data Marts, ODS Systems.
• Create Mappings, workflows in both Power Center and IDQ.
• Anal yze the data by query db tables and schemas.
• Create stage tables and identify the discrepancies by profiling, Score Cards generations.
• Standardize the data by applying the DQ Rules.
• Work closely with software developers/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle
• Develop Test strategy, test plan/design, execute test cases and defect management for the ETL & BI systems
• Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation
• Analyze and understand the ETL work flows developed
• Quality Management - Knowledge of quality management methods, tools and techniques
• Create UNIX shell scripts to access and move data from production to development environment
• Communicate- and manage expectations of the senior management team and affected stakeholders during the planning and roll out of project releases.
• Good working knowledge on Agile and Waterfall models.
• Determine the correctness by looking at different dimensions.
• Support the Dev and test teams for smooth project migrations.
• Mapping experiences with SCD TYPES, Master, Transactional Subject areas & other dimensional models with respect to ETL Data warehouses.
• Maintained warehouse meta data, naming standards and warehouse standards for future application development.
• Performing Profiles, Standardization, Identifying Anomalies, creating/Applying rules and created mappings/mapplets.
• Performed gap analysis between the current state and future data warehouse environment identifying data gaps and quality issues plus recommending potential solutions.
• Used MDM/IDQ effectivel y to identif y the golden records.
• Data modeling experience using Star Schema/Snowflake modeling, FACT & Dimensions tables, Relational & Dimensional tables in perspective of Master and Transactional data.
• Good knowledge upon databases using Oracle 11g/10g/9.x/8.x/7.x, MS SQL Server 2000/2005, SQL, PL/SQL, SQL * Plus, SQL*Loader, Toad 8.x . 0/ 9.1/ 10.3.3.0/ 11.5 , Teradata mload.
• Good hands on Cyber Ark.

TECHNICAL SUMMARY

Data Warehousing: Informatica PowerCenter 9.5/9.1.x/9.0.x/8.6.x/8.1.x(Repository Manager, Source Analyzer, IDQ Developer/Analyst 9.5.1,Designer, Server manager, Work Flow Monitor, Warehouse Designer, Mapplet Designer, Mapping Designer, Work Flow Manager), Metadata Manager 8.x, OLAP, OLTP, IDQ/IDE,SQL * Plus, SQL * Loader, Informatica Data Quality, Informatica Data Profiler

BI & Reporting: Business Objects 6.5/6.0/5.1/5.0 , SQL Server Reporting 2005, Siebel Analytics 7.8, OBIEE 10.x/11.x,Cognos 8.1/8.2/8.3/8.4

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, ER Diagrams, ERWIN, ERStudio 7.1/6.1

Other Tools: HP Service Manager, IBM Rational Clear Quest 7.1.1.3.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , Oracle SQL Developer 3.0.04, SQL*Loader,IBM Data Studio 2.2.1.0,EDW DB2,Teradata (14.0 & 16.2)

Programming: SQL, UNIX

Job Scheduling: IBM Tivoli Manager 5.0, Crontab.

Environment: UNIX , RedHat Linux 5.x/4.x/3.x, Linux 2.6.32 Solaris, Windows 2008/2003/2000/ XP

Other Tools: TOAD, RapidSQL, SQL Plus, CYGWIN (X-Windows Server), Winscp, Core FTP LE 2.2, Putty, AIX Servers,SONAS,EDGE Servers.

Deplo yment Tools: Jenkins, GITHUB

PROFESSIONAL EXPERIENCE:

Confidential, Wood Bridge, NJ

Responsibilities:

• Work closely with software developers/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle
• Develop Test strategy, test plan/design, execute test cases and defect management for the ETL & BI systems
• Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation
• Analyze and understand the ETL work flows developed, Also Developed workflows/Mappings.
• Quality Management - Knowledge of quality management methods, tools and techniques
• Create UNIX shell scripts to access and move data from production to development environment
• Communicate- and manage expectations of the senior management team and affected stakeholders during the planning and roll out of project releases

Environment: Informatica PowerCenter 9.6. 1/10.1 (Repository Manager, PowerCenter Designer, Workflow Manager, Workflow Monitor), IDQ 9.5.1, Informatica Data Analyst,IDQ,Oracle 11g/10g,Flat files, Unix, Linux, Window 10, Autos y s, Bitbucket, Mongo DB, SQL Developer 3.0,QC, TQM.

Confidential, Franklin Lakes, NJ

Informatica Consultant(Tester/Developer)

Responsibilities:

• End to end support have provided from a project stand point.
• Provided the solutions to the data design team for modelling.
• Worked effectively with the DBA’s for the table creations
• Prepared the DBCR’s
• Worked on Jira for creating the User stories and providing necessary updates on the work assigned for the assessment of higher management.
• Worked on Jenkins deployment of codes across environments.
• Good working knowledge on GITHUB.
• Comfortable working on the shell scripts.
• As a normal work activity comfortable on working with Informatica and other related job activities.
• Good hands on Cyber Ark.
• Worked on service now request and Incident Management tickets.
• Worked on mango data files testing and also QA Support activities.

Environment: Informatica PowerCenter 9.6. 1/10.1 (Repository Manager, PowerCenter Designer, Workflow Manager, Workflow Monitor), IDQ 9.5.1, Informatica Data Analyst,IDQ,Oracle 11g/10g,Flat files, Unix, Linux, Window 10, Crontab, Tivoli, SQL Developer 3.0, Teradata 16.20, Cyber Ark.

Confidential, Manhattan,New Y ork and EnglewoodCliffs, NJ

Informatica IDQ Consultant

Responsibilities:

• R equirements gathering and Business Analysis in support of the business team.
• Performed profiling and identified the anomalies within the different data sets on IDQ and Informatica Anal y sts.
• P erformed production support activities.
• Providing to the users.
• Preparing the meta data glossar y .
• Identif y ing the dirt y data with IDQ developer transformations like match transformation, Bad record exception, Association transformations, Merge Transformation etc to name a few.
• Moving the data across different environments and managing the data loads.

Environment: Informatica PowerCenter 9.5/9.1 (Repository Manager, PowerCenter Designer, Workflow Manager, Workflow Monitor), IDQ 9.5.1, Informatica Data Analyst,IDQ,Oracle 11g/10g,Flat files, Unix, Window 7/XP, Autosys, SQL Developer 3.0, SQL, PL/SQL, Microsoft tools, Putty, Winscp, VSS, Metadata Reporter, and Cygwin.

Confidential, NJ

Informatica IDQ Consultant

Responsibilities:

• R equirements gathering and Business Analysis in support of the business team.
• Performed profiling and identified the anomalies within the different data sets on IDQ.
• P erformed production support activities.
• Performed enhancements in power center pertaining to the project needs.
• Generated the XML for transmitting files over to the CMS through the EDGE Servers via SONAS.
• Process automation performed creating parameter files.
• Catered to client requirements pulling data from sources which include IDS( Internal Data Store), MDM, Confidential Data Hub, ICOE (Internal Center of Excellence and EDW (Enterprise Data warehouse) and generating extracts from same.
• Used the MDM Siperion for identif ying the golden records b y the Match/Merge process.
• Created Mappings, Sessions, Work flows and deployed them on various regions.
• Performed profiling and identified the anomalies within the different data sets.
• Worked upon Cleansing, Standardization, Matching, Consolidations, and Associations of the data sets on IDQ.
• Performed the deployments and migrations through different environments.
• Performed data integration's, testing/validations.

Environment: Informatica PowerCenter 9.5.1, Informatica Developer IDQ 9.5/9.1,Informatica Analyst 9.5.1,Oracle SQL Developer 3.0.04, HP Service Manager, IBM Data Studio 2.2.1.0, EDW DB2, Flat files, UNIX AIX Servers, Window 7, MDM, IBM Tivoli Manager 5.0, Putty, Microsoft tools, XML, CORE FTP LE 2.2,SONAS, EDGE Server,IBM, TOAD For DB2 5.0.

Confidential, NJ

Informatica IDQ Consultant

Responsibilities:

• Requirements gathering and Business Analysis in support of IDQ data quality.
• Performed profiling and identified the anomalies within the different datasets.
• Worked upon Cleansing, Standardization, Matching, Consolidations, and Associations of the datasets on Confidential Campaign Files.
• Identifying the low Quality data by applying the DQ rules.
• Created many mappings in accordance with the DQ Processes so as to enrich the data sets/records in the particular Campaign Files.
• Used various transformations on the DQ to enhance the dirty data and to pass through records to the Acxiom in accordance and compliance with Confidential policies.
• Performed the Installations, Configurations and setting up of the Netezza Database on the IDQ systems.
• The Data Integration was performed to handle both DEV and POC Environments on IDQ.
• Created many Physical and Logical Data Objects on IDQ.
• Created many Mappings, Mapplets or Rules in IDQ which were reusable in the project.
• Created content sets in the MRS for and compiling the Content Sets for it to be used by different transformations.
• Handled Managed, Unmanaged tables/files and used it in many profiling objects.
• Performed Score Carding for analysis the Quality of Data.
• Performed Data Mining and done a deep dive on the Analysis/ root cause of the DQ datasets
• Used key transformations in DQ like Match, Key Generator, Association, Consolidation, Labeler, Parser, Address Validator, Classifier, Decision, Standardizer, Expression, Case Converter and Merge etc.
• Created Workflows, Applications and deployed them on various servers.
• Worked upon the Linux systems for importing the files on Informatica Analyst and Developer.

Environment: Informatica PowerCenter 9.5.1, Informatica Developer IDQ 9.5/9.1,IDQ 8.6,Informatica Analyst 9.5.1,Netezza 6.0.6, MDM, Flat files, Linux 2.6.32, Window 7/XP, Maestro Scheduler, SQL Developer 3.0, SQL, PL/SQL, Microsoft tools, Putty, Winscp, IPSWITCH, Qlikview 11.

Confidential, Clifton Park, NY

Informatica /OBIEE consultant

Responsibilities:

• Develop and deploy dashboards, analytics and reports properly
• Design and develop data modeling concepts using various data modeling tools like star schema and dimensional modeling
• Interacted with Procurement and Operation / Maintenance business representatives for gathering the OBIEE Reports / Dashboards requirements and to define business and functional specifications.
• Analyzed and used various data sources - DB, XML, Excel, and OLAP.

Environment: Informatica PowerCenter 8.6.1 (Repository Manager, PowerCenter Designer, Workflow Manager, Workflow Monitor), Informatica IDQ/IDE, Informatica Metadata Manager, Oracle 10g, OBIEE, SQL SERVER 2008, MS-Access, Unix, Window 7, SQL, PL/SQL, MS-Visio, Microsoft tools, Putty.

Confidential

Oracle Developer

Responsibilities:

• Written SQL queries.
• Written PL/SQL stored Procedures and Functions for Stored Procedure Transformation.
• Written Shell scripts to create parameter files rename and compress files.
• Creating Tables, indexes constraints and improved database performance.
• Creation of different kinds of reports about Tables, Views, Synonyms etc from the Oracle Database.

Environment: ORACLE d2k, SQL*Plus, PL/SQL, XML, Oracle 9 i, Windows NT