SUMMARY

• 10 years of experience in the IT industry wif skills in analysis, design, development and implementation of various Data warehousing projects using Object Oriented Analysis, Design and Methodologies.
• Expertise in Informatica Power Center 9.x and implementing ETL concepts like Data Cleansing, Parsing, Consolidating, Incremental Loading, MD5 Logic, Match and merge, etc.
• Worked wif Informatica Power Exchange 8.0 to extract data from different Sources. Having experience in working wif Informatica Administration Console.
• Expertise in ORACLE 11g RDBMS and MS SQL Server
• Experience in Dimensional Data Modeling using Star Schema, Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling using ERWIN.
• Knowledge of data warehousing techniques, Star / Snowflake schema employing Ralph Kimball methodologies, ODS, EDW and Metadata repository.
• Excellent approach and experience in Source System Analysis. Profiling the data and checking the sanctity of the data.
• Experience in Implementation of slowly changing dimensions methodology to keep track of historical data. Experience in implementing complex business rules by creating optimized and efficient mappings wif appropriate transformations.
• Experience in resolving on - going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Knowledge in Data Analyzer tools like Informatica Data Quality (IDQ)
• Knowledge in informatica multi domain data Integration tool Master Data Management (MDM).
• Experience in ETL implementation and Production Support.
• Experience in different Data Sources like Oracle, SQL Server, SAP, Xml and Flat Files.
• Strong in Writing the SQL Queries and Optimizing SQL Queries. Knowledge in UNIX shell scripting.
• Proficient at SQL, PL/SQL. Strong programming experience in creating stored procedures, functions, packages, triggers.
• Knowledge in Business Intelligence tool Business Objects
• Knowledge on Data Quality tool IDQ and Master Data Management MDM.
• Strong Experience in Data Warehouse requirements gathering, analysis, design, conversion of business requirements into high level functional specifications, design of Star and Snowflake Schema, File Management Process, Data Loading Process and Business Intelligence Process
• Excellent Client handling ability wif good presentation skills.
• Worked in Onsite/Offshore coordination model.
• Excellent working ethics to meet deadlines in fast-paced environment and function under high-pressures wif extremely short deadlines. Collaborate on multi-disciplinary (e.g. business and technical) teams.
• Solid Organizational skill and ability to work wifout supervision to achieve project goals.

TECHNICAL SKILLS

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Data Warehousing: Informatica Power Center 8.6/8.5/8.1.1/7.1.3/7.1.1/7.0/6.2/ 5.1.1/4.7, Power Mart 6.2/5.1.1/5.0/4.7.2, Informatica Designer, Workflow Manager, Work flow Monitor, ETL, Datamart, OLAP, OLTP, BO,COGNOS.

Databases: Oracle10g/9i, SQL Server and MS Access

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration, and team building

Environment: Windows 200/XP/98, Unix.

Others: Java, C, XML, Business Objects R2, Cognos 8.0, Visual Basic 6.0, C, Unix Shell Scripting, PL/SQL, SQL,T-SQL

PROFESSIONAL EXPERIENCE

Confidential, Tampa, Florida

Technical Lead

Responsibilities:

• Created SAP connector to connect to the SAP Source.
• Generate/Install SAP code for mappings as part of extracting data from SAP source.
• Developed mappings and workflows to extract data from SAP sources and load into target.
• Used different transformations to implement the business logic as per business requirements.
• Developed mappings to implement SCD dimensions.
• Used connected, unconnected look-up and sequence generator transformations.
• Used Parameter files for connections to avoid redundancy and to be easy for any future changes to connection details.
• Unix Scripts to invoke the workflow and archive processed files.
• Involved in requirement analysis
• Involved in data model discussions
• Responsible for the effort estimation.
• Responsible for bug fixes during UAT testing.
• Prepare HLD and TDD
• Prepare the deployment plan for the Informatica and Database objects.
• Work wif ODT, Informatica Admin and DBA team aspart of the release management process.
• Provide Knowledge transfer to the Support Team.
• Prepare Run-Book for Production Support team.

Environment: Informatica 9.1, SQL, PL/SQL, TOAD, Oracle 12.1, SQL Server,UNIX Shell Scripting, Windows XP, TWS.

Confidential, Newyork

Module Lead

Responsibilities:

• Involved in requirement analysis and effort estimation.
• Developed mappings and mapplets as part of different Sprints.
• Used different transformations to implement the business logic as per business requirements.
• Developed PL/SQL packages and procedures and used in informatica mappings.
• Scheduled jobs using the UC4 scheduling tool.
• Implemented Pre and post session commands to complete the tasks after the successful completion of the workflow.
• Developed mappings to implement the deletion logic for the data in case of any issues reported from business.
• Used connected, unconnected look-up and sequence generator transformations.
• Used Parameter files for connections and source system names to avoid redundancy and to be easy for any future changes to connection details.
• Implemented emails notifications to business per the requirements.
• Knowledge on business objects reports.
• As part of production support, provided impact analysis and quick work around on highly business critical issues.
• Provide the effort analysis and estimated timelines for the business issues.
• Working closely wif Business user’s to provide the best solution to the user, to minimize impact on the data processing.
• Maintain Run-Book and updating of any new issues in the run-book.

Environment: Informatica 9.1, SQL, PL/SQL, TOAD, Oracle 12.1, Business Objects, UNIX Shell Scripting, Windows XP, UC4.

Confidential, San Jose

Program Analyst

Responsibilities:

• Lead the offshore team and work closely wif the offshore team to solve any challenges faced by the team.
• Adhere to the Cisco Change Management process and provide production support for the entire Data warehouse platform.
• As the Production support team lead, responsible in providing effort estimation for production issues and provide solution wif in the given SLA.
• Involvement in the production support of ETL processes for Cisco M-ODS using Power Center and Power Exchange.
• Daily Batch failure recovery, Informatica Workflow recovery wifin the specified business SLA. Develop automated shell scripts for the daily processes.
• Raise Production tickets or Change Requests(CR) based on the type of issue.
• Weekly meeting wif DEV team and Business team to discuss regarding the upcoming developments and discuss the PS Team’s responsibilities.
• Will be responsible for complete shutdown of MODS during major releases.
• Responsible in providing communication to Business people in case of any delay in the data processing due to huge data loads.
• Work wif peripheral teams like SMS, CM, MRM, PEER, CME, MDUT, MA, CT, SMCC and also from flat files of EIMS and EIMR, to resolve integration issues wif any upstream/downstream systems.
• Participate in war room discussions wif the MODS DEV team for any new project releases or any enhancement releases.
• Work closely wif the DEV team during the release phase and stabilization phase to has smooth hand shake.
• Provide the effort analysis and estimated timelines for the business issues.
• Responsible for the noledge transfer of M-ODS to the other project members.
• Impact analysis and quick work around on highly business critical issues.
• Working closely wif Business user’s to provide the best solution to the user, to minimize impact on the data processing.

Environment: Informatica 8.6, SQL, PL/SQL, TOAD, Oracle 10g, Cognos, UNIX Shell Scripting, Windows XP, Dollar Universe, Tibco

Confidential, Wellesley Hills, Massachusetts

Senior Developer

Responsibilities:

• Design, development and maintenance of Insurance policies and claims transactions Data Mart using Informatica Power Center.
• Involved in Designing and developing Star Schema and creating Fact Tables and Dimension Tables for the Warehouse using Erwin Tool.
• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards.
• As team lead involved in the requirement analysis and effort estimation.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Marketable Security & Derivative Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Created ER Diagram representation including existing source systems by using Ervin Tool.
• Developed mappings using various transformations like update strategy, lookup, Source Qualifier, Router, Filter, sequence generator, joiner, aggregator, expression, SQL transformation, Transaction Control transformation.
• Worked wif different sources such as Oracle, flat files and XML sources.
• Used shortcuts to reuse objects wifout creating multiple objects in the repository and inherit changes made to the source automatically.
• Implemented Incremental data loading using the Session Parameter file and mapping variables
• Tuned performance of Informatica session for large data files by increasing block size, data cache size.
• Created, launched & scheduled tasks/sessions. Configured email notification. Setting up tasks to schedule the loads.
• Optimized query, session performance.
• Created Session tasks, workflows and Worklets to execute mappings
• Developed several reusable transformations and mapplets that were used in other mappings.
• Mappings were designed to the utmost performance by optimizing transformations logic.
• Writing documentation to describe program development, logic, coding, testing and changes.
• Optimizing the mappings by changing the logic to reduce run time.

Environment: Informatica 8.1((Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation developer), SQL, PL/SQL, SQL Server, TSQL TOAD, Oracle 10g, UNIX Shell Scripting, Windows XP.

Confidential

Team member

Responsibilities:

• Created Functional, Technical Design and Data mapping documents by Interacting wif Customers subject matter expert (SME). In Addition participating in requirement gathering, Analyzed the requirements.
• Involved in Informatica server and Server Administration such as Installing, Creating and configuring Repository, Folders, Users and User Groups and ODBC in Informatica Power Center 8.6.
• Outage Handling(Escalation Procedure, Running metadata queries and procedures, checking database, creating outage log)
• Performed migration of mappings and session from Dev to Test repository, taking backup and restoring of Informatica Repository, upgrades and security issues.
• Involved in migration of Informatica objects in all phases (DEV, INT and PRD) of project and trained developers to maintain system when in production.
• Regular monitoring of the informatica server environment on AIX UNIX Server.
• Experience in Applying Informatica Latest Hot fixes/Patches.
• Developed IDQ work bench’s by using Data sources, Operational Components and Data Sinks.
• Developed the IDQ Plans for Profile Demo data, Pre-Standardization Scorecard, Standardize Generic Data and Standardize Name, Address Data.
• Developed mappings using various transformations like Update strategy, Lookup, Stored Procedure, Router, Filter, Sequence Generator, Joiner, Aggregator, Expression, SQL transformation.

Environment: Informatica Power Center 8.1, PL/SQL, Oracle 10g.

Confidential

Team member

Responsibilities:

• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center Designer.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Sales and Marketing Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Developed Mappings for the Category, Specification, Code, Type areas.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data
• Involved in the development and testing of programs, Informatica mappings and update processes.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Developed schedules to automate the update processes and Informatica Sessions/Batches.

Environment: Informatica Power Center 8.1, Oracle 9i, TOAD, SQL, PL/SQL

Confidential 

Team member

Responsibilities:

• As a team member was involved in coding, design and maintenance for this project.
• Responsible for coding Servlets and JSP’s.
• Testing of the Servlets and JSP connectivity and JSP calls to the Servlets.
• Knowledge transfer at client site on the deployment of the application.
• Responsible in developing queries.

Environment: Servlets, JSP, JDBC 2.0, Struts, Tomcat, Windows 2000/XP