SUMMARY

• 15+ years of professional experience in information technology with progressive experience in database Applications development and implementation client and web application.
• Experience in providing information management consulting services on Master Data Management, Data Integration and Business Intelligence Applications.
• Experience in all stages of Project Development Life Cycle including design, development, testing, implementation and product support.
• Highly Skilled in MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, Customizing/Configuring Informatica Business Data Director.
• Developing the Mappings to load the Data from Landing to Staging by using various cleanse functions.
• Defining the Match and Merge Rules in the MDM Hub by creating Path components, Columns and rules.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes
• Expert level skills in developing Strategies for Extraction, Transformation and Loading (ETL) Mechanism using Informatica Power Center 9.x.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Hands on experience with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer
• Excel at loading data from FLAT files and other databases, responsible for data loading using SQL *Loader for the clients in UNIX environment.
• Experience in writing Shell Scripts in UNIX environment for data loading and sending alert email after the data load is completed.
• Efficient in DWH concepts and Designing Data Models.
• Proficient in developing Multi-Tier Enterprise Applications using PL/SQL, SQL, Oracle.
• Developed PL/SQL Code for efficient retrieval and manipulation of complex data sets using PL/SQL package, procedures, functions, and triggers.
• Experience in Performance Tuning and Optimization of SQL statements using Explain Plan.
• Expertise in Production Support, Test Plans, Test Schedules and UAT support.
• Experience level skills developing Projects in OLAP tool Microstrategy.
• Experience in VLDB settings and report tuning techniques
• Experience in object manager to migrate the Microstrategy project from development to production environment.
• Experience in Creating Objects using Business Objects XI 3.1 Universe.
• Experience in creating and scheduling jobs using Control M Job Scheduler.
• Experience in testing the Business Objects reports using the WEB-I.
• Experienced in migrating different projects objects from development to test and to Production environment using Object Manager.
• Ability to build internal commitment and external credibility, through effective negotiation and suitable influencing styles, based on a clear understanding of organizational decision-making dynamic.
• Strong communication, interpersonal & analytical skills, proactive in nature, willing to accept challenges, desires to learn, flexible and committed.
• Versatile team player as well as independent contributor with good problem solving and interpersonal skills.

TECHNICAL SKILLS

Languages: Oracle, SQL, Pl/SQL, Java

J2EE Technologies: Servlets, JSP, JDBC, EJB

Application Server: OC4J

Web Servers: Apache Tomcat 5.0.26

Web Technologies: HTML, JavaScript, Active Widgets 2.0.1.

Tools: PUTTY, SQL Tool, SVN, Jdeveloper 10.1.3, VPN, Erwin, Oracle SQL Developer 1.0, PL/SQL Developer 5.1.3. And TOAD 9.7.2,9.6.1

Master Data Management: Informatica MDM 9.x

ETL Tools: Informatica Power Center 8.x,9.x

OLAP Tools: Micro strategy Business Objects XI 3.1

Databases: Oracle 9i/10g, HP Vertica

Operating Systems: Windows 9X/2k/XP and Linux.

Job Scheduler tools: Control-M, Autosys.

PROFESSIONAL EXPERIENCE

Confidential, Austin TX

Sr Informatica Consultant

Responsibilities:

• Understand Business Requirements, Functional Requirements and Design Specifications.
• Work with stakeholders, and translate requirements to design and build a solution that will meet Business needs and integrate seamlessly
• Work on Designing and configuring environments and creates ETL deliverables. Ensures configurations, environments and deliverables meet standards and technical specifications; performs technical analysis and component delivery.
• Analyzed the source system data for integrity issues resided in various source systems
• Performed Data profiling of reference data for large data sets using Different Data Analyst tool.
• Analyzed the Source system Data and Performed Data Quality Checks and Data Modeling
• Work on Informatica Power Center client tools like Source Designer, Target Designer, Mapping Designer, Mapplet Designer, Workflow Manager and Repository Manager
• Develop Mappings, sessions and workflows to execute the Data Load Process for customer data Set using Informatica ETL Tool.
• Worked on moving the files from one server to different servers using FTP.
• Daily Client interaction on the requirement and updating the status of the requirements through Agile Methodology.
• Maintained documentation of the procedures and performed unit testing to make sure the desired result is achieved.
• Work on GITHUB tool to maintain the version control of the application code for every release.
• Work on creating the Runbook, implementation Plan, Backup and Recovery Plan documents for Production Implementation
• Work on incidents and do the in-depth analysis of the issue and send a report to the manager about the root cause for the issue and provide effective solutions to make sure the issue is not raised in future.

Environment:, SQL Developer, Informatica MDM 9.x, Informatica Power Center 9.x,10.4, Oracle 10g,11g,, Toad, Visio, Windows XP, WinSCP for UNIX Servers, VPN, PUTTY.

Confidential, CA

Senior MDM Consultant

Responsibilities:

• Understand Business Requirements, Functional Requirements and Design Specifications.
• Configured Source Systems ERP, SFDC, DNB, Avention etc. and Configured MDM tables in the following sequence: Base Objects, Relationships Base Objects, Defined and developed the ETL process to load the data into the landing tables during the land process
• Configured the Foreign Key Relationships among the Base Objects and define the lookups for the staging tables
• Performed mappings & ran sessions and workflows to execute the Land Process of loading the customer data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
• Create MDM mappings using best practices to capture the errors and have a clean load.
• Worked on data cleansing and standardization using cleanse functions, cleanse lists and creating custom cleanse functions (Attribute functions and Object functions) in Informatica MDM
• Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules
• Configured match rules and rule sets property by enabling search by rules in MDM according to Business Rules
• Managing the User Access Levels and roles for the MDM Application through Security Access Manager.

Environment:, SQL Developer, Teradata SQL Assistant, Informatica MDM 9.x, Informatica Power Center 9.x, Oracle 10g,11g,, Toad, Visio, Windows XP, WinSCP for UNIX Servers, VPN, PUTTY.

Confidential, CA

Senior MDM Consultant

Responsibilities:

• Understand Business Requirements, Functional Requirements and Design Specifications.
• Configured Source Systems of HP, Configured MDM tables in the following sequence: Base Objects, Relationships Base Objects, Defined and developed the ETL process to load the data into the landing tables during the land process
• Configured the Foreign Key Relationships among the Base Objects and define the lookups for the staging tables
• Performed mappings & ran sessions and workflows to execute the Land Process of loading the customer data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
• Create MDM mappings using best practices to capture the errors and have a clean load.
• Worked on data cleansing and standardization using cleanse functions, cleanse lists and creating custom cleanse functions (Attribute functions and Object functions) in Informatica MDM
• Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules
• Configured match rules and rule sets property by enabling search by rules in MDM according to Business Rules
• Managing the User Access Levels and roles for the MDM Application through Security Access Manager.
• Maintained documentation of the procedures and performed unit testing to make sure the desired result is achieved
• Worked on incidents and do the in-depth analysis of the issue and send a report to the manager about the root cause for the issue and provide effective solutions to make sure the issue is not raised in future.

Environment: Toad Data Point, DB Visualizer, Informatica MDM 9.x, Oracle 10g,11g,, ToadVisio, Windows XP, ALM, WinSCP for UNIX Servers, VPN, PUTTY.

Confidential, CA

Data Quality Analyst/ Developer

Responsibilities:

• Understand Business Requirements, Functional Requirements and Design Specifications.
• Analyzed the source system data for integrity issues resided in various source systems
• Performed Data profiling of reference data for large data sets using Different Data Analyst tool.
• Analyzed the Source system Data and Performed Data Quality Checks and Data Modeling
• Work with the Data base team to make sure all the daily loads are completed without issues.
• Monitor the Load jobs and improve the performance of the system
• Daily Client interaction on the requirement and updating the status of the requirements.
• Maintained documentation of the procedures and performed unit testing to make sure the desired result is achieved
• Work with Qlik View Reporting team and provide data Mapping Documents for Reporting
• Design The ER Model based on the data Analysis results.
• Worked on incidents and do the in-depth analysis of the issue and send a report to the manager about the root cause for the issue and provide effective solutions to make sure the issue is not raised in future.

Environment: Toad Data Point, DB Visualizer, HP Vertica Database, Visio, Windows XP, ALM, WinSCP for UNIX Servers, Qlik View, VPN, PUTTY.

Confidential, Minneapolis MN

Data Quality Analyst/ Developer

Responsibilities:

• Interacted with the Business Users & Enterprise Data Architects in the analysis & design of Conceptual and logical data model that is required for solid MDM implementation & ensuring that it meets the business requirements and also supports the products capabilities.
• Analyzed the source system for integrity issues to the data resided in various source systems
• Performed Data profiling of reference data for large data sets using Informatica Data Analyst tool.
• Defined the HUB Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Performed mappings & ran sessions and workflows to execute the Land Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
• Create MDM mappings using best practices to capture the errors and have a clean load.
• Worked on data cleansing and standardization using cleanse functions, cleanse lists and creating custom cleanse functions (Attribute functions and Object functions) in Informatica MDM
• Defined the HUB Base objects, Staging tables, foreign key relationships, static lookups, and dynamic lookups, queries, packages and query groups.
• Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules.
• Configured match rules and rule sets property by enabling search by rules in MDM according to Business Rules
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.
• Involved with ETL team in getting the data loaded into the landing tables.
• As a senior MDM developer, I have mentored junior developers to understand the requirements, technical documents and further on testing.

Environment: Informatica MDM 9.x, Oracle 10g,11g, SQL/PLSQL, Toad, SQL Developer, Oracle SQL Developer, Visio, Windows XP, Change Management, UNIX Shell Scripting, Informatics, Business Objects, VPN, PUTTY, SVN.

Confidential, New York - NY

Application Developer

Responsibilities:

• Understand Business Requirements, Functional Requirements and Design Specifications.
• Performed Application patch upgrade to meet the firm’s SWIFT Standard.
• Worked on Informatica Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Worked on moving the files from one server to different servers using FTP.
• Wrote Procedures and packages to implement the Business Rules.
• Worked on creating Informatica Workflow calling a oracle Procedure and Functions.
• Maintained documentation of the procedures and performed unit testing to make sure the desired result is achieved.
• Extensively worked on setting up a new UNIX environment when migrating the project from Development to QA and from QA to Production server.
• Monitor scheduled batch cycles via Control-M and Resolve Incidents using Quality Center software tool.
• Worked on incidents and do the in-depth analysis of the issue and send a report to the manager about the root cause for the issue and provide effective solutions to make sure the issue is not raised in future.
• Daily Client interaction on the requirement and updating the status of the requirements.
• Maintained documentation of the procedures and performed unit testing to make sure the desired result is achieved.
• Testing the BO Reports through BO Universe WEB-I after the data load is completed.
• Created new objects in the BO reports using the BO Universe.

Environment: Oracle 10g,11g, SQL/PLSQL, Toad, SQL Developer, Oracle SQL Developer, Visio, Windows XP, ITSM Change Management, Control M, UNIX Shell Scripting, Informatics, Business Objects, VPN, PUTTY, SVN. ERWIN

Confidential, New York - NY

Application Developer

Responsibilities:

• Understand Business Requirements, Functional Requirements and Design Specifications.
• Wrote Procedures and packages to implement the Business Rules.
• Worked on Informatica Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Worked on moving the files from one server to different servers using FTP.
• Wrote Procedures and packages to implement the Business Rules.
• Worked on creating Informatica Workflow calling a oracle Procedure and Functions.
• Involved Extensively in Data modeling and Dimensional modeling.
• Maintained documentation of the procedures and performed unit testing to make sure the desired result is achieved.
• Wrote UNIX shell scripts to run the multiple control files .
• Monitor scheduled batch cycles via Control-M and Resolve Incidents using Quality Center software tool.
• Worked on incidents and do the in-depth analysis of the issue and send a report to the manager about the root cause for the issue and provide effective solutions to make sure the issue is not raised in future.
• Daily Client interaction on the requirement and updating the status of the requirements.
• Maintained documentation of the procedures and performed unit testing to make sure the desired result is achieved.
• Testing the Jasper Reports through Jasper Admin consol after the data load is completed.
• Created new objects in the Jasper reports using the IReports.

Environment: Oracle 10g SQL/PLSQL, Toad, Oracle SQL Developer, Visio, Windows XP, Remedy Change Management, Control M, UNIX Shell Scripting, Informatics, Business Objects, VPN, PUTTY, SVN. ERWIN

Confidential, Chicago - IL

Oracle PLSQL Developer/ ETL Developer

Responsibilities:

• Understand Business Requirements, Functional Requirements and Design Specifications.
• Wrote Procedures and packages to implement the Business Rules.
• Worked on Informatica Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Worked on moving the files from one server to different servers using FTP.
• Wrote Procedures and packages to implement the Business Rules.
• Worked on creating Informatica Workflow calling a oracle Procedure and Functions.
• Used Informatica Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Involved Extensively in Data modeling and Dimensional modeling.
• Maintained documentation of the procedures and performed unit testing to make sure the desired result is achieved.
• Extensively worked on setting up a new UNIX environment when migrating the project from Development to QA and from QA to Production server.
• Wrote UNIX shell scripts to run the multiple control files written in SQL* Loader and .sql scripts.
• Monitor scheduled batch cycles via Control-M and Resolve Incidents using Quality Center software tool.
• Worked on incidents and do the in-depth analysis of the issue and send a report to the manager about the root cause for the issue and provide effective solutions to make sure the issue is not raised in future.
• Daily Client interaction on the requirement and updating the status of the requirements.
• Maintained documentation of the procedures and performed unit testing to make sure the desired result is achieved.
• Testing the BO Reports through BO Universe WEB-I after the data load is completed.
• Created new objects in the BO reports using the BO Universe.

Environment: Oracle 10g SQL/PLSQL, Toad, Oracle SQL Developer, Visio, Windows XP, Remedy Change Management, Control M, UNIX Shell Scripting, Informatics, Business ObjectsVPN, PUTTY, SVN. ERWIN

Confidential, NY

Oracle PLSQL Developer/ ETL Developer

Responsibilities:

• Understand Business Requirements, Functional Requirements and Design Specifications.
• Leading the project from Onsite and handling a team at offshore.
• Developed the complete ETL Process using PL/SQL, ORACLE 10g.
• Wrote Procedures and functions required in the system to load the data from staging tables to Dimension tables and from dimension or stage tables to fact tables.
• Wrote Procedures and packages to implement the Business Rules.
• Wrote the procedures and functions required in the system to update the Summary tables for the Reports.
• Worked on Informatica Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected & unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner, and Update Strategy.
• Used Informatica Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Involved Extensively in Data modeling and Dimensional modeling.
• Developed the logical and physical data models, created data definition language statements and worked with database administrators to transition these models to database administrators for successful physical implementation
• Involved Extensively in Designing Logical and Physical Models using ERWIN.
• Extensively worked on setting up a new UNIX environment when migrating the project from Development to QA and from QA to Production server.
• Extensively worked on migrating the project from oracle 10g database to Oracle 11g database.
• Worked on moving the files from one server to different servers using FTP.
• Extensively worked on tuning and optimizing the SQL and PLSQL Procedures and achieved in reducing the process completion time from 5 hours to 2 hours.
• Wrote control files in SQL* Loader to load the data from files into the database tables.
• Wrote UNIX shell scripts to run the multiple control files written in SQL* Loader.
• Maintained documentation of the procedures and performed unit testing to make sure the desired result is achieved.
• Created and managed database connections to various data store
• Created and managed users in Microstrategy.
• Responsible for creating, altering users and user groups using Command Manager.
• Created project plans for development of MicroStrategy projects.
• Involved in System maintenance, functionality addition and improvement.
• Daily Client interaction on the requirement and updating the status of the requirements.
• Monitor scheduled batch cycles via AutoSys and Resolve Incidents using REMEDY software.
• Worked on incidents and do the in-depth analysis of the issue and send a report to the manager about the root cause for the issue and provide effective solutions to make sure the issue is not raised in future.

Environment: Oracle 10g SQL/PLSQL, Toad, SQL Loader, Visio, Windows XP, Remedy Change Management, Autosys, UNIX Shell Scripting, Informatica, MicrostrategyVPN, PUTTY, SVN. ERWIN

Confidential, NY

PL/SQL Developer

Responsibilities:

• Understand Business Requirements, Functional Requirements and Design Specifications.
• Involved in development of the module for Transactions.
• Wrote Procedures and packages to implement the Business Rules.
• Maintained documentation of the procedures and performed unit testing to make sure the desired result is achieved.
• Designed the Transaction form using JSP and HTML.
• Involved in the testing of the screens and prepared test case reports for the forms.
• Wrote the JAVA code to interact the Form with the database using prepared statements.
• System maintenance, functionality addition and improvement.
• Client interaction on the requirement and provide the update’s on the requirement.
• Writing packages, functions and procedures.
• Resolving the tickets raised by the user.
• Providing L2 Support for the application.

Environment: Oracle 10g SQL/PLSQL, Toad, SQL Loader, Visio, Windows XP, UNIX Shell Scripting, HTML, Java, JSP, Servlets, EJB, Jdeveloper 10g, Linux, VPN, SVN PUTT