SUMMARY:

• Experienceof over 12 years predominantly in Informatica and various databases. Handled responsibilities as a Technical Lead, Project Lead and Developer across HR domain, Real Estate and Project Management and Sales Domains.
• Proficient in designing, developing, executing and managing InformaticaPower Center, Sybase, Oracle, DB2, SQL Server, Business Objects,Unix/Linux and Autosysby encompassing all aspects of a project‘s life cycle.

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Responsibilities:

• Working in Compliance surveillance Data warehouse in developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter 9.X. Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area using Informatica mappings, workflows and session objects.
• Worked on various look up caches like Static Cache, Dynamic Cache, Persistent Cache, and Shared Cache.
• Worked on tuning performance at all levels of the Data warehouse. Implemented performance tuning by using lookup caches, gathering stats, dropped indexes and re-created them after loading data to targets and increased the commit interval.
• Used SFTP, FTP services to retrieve Flat Files from the external sources.
• Increased Code Reusability using Shortcuts, Mapplets, Reusable Transformations and Reusable Sessions to reduce redundancy in code.
• Knowledge in Big Data Ecosystem - Hadoop, MapReduce, HDFS, Hive and Pig
• Worked on Hive queries for analyzing emails by creating Managed and External Hive tables.

Environment: ETL, Informatica Power Center 8.x, 9.x, Oracle 11g, PL/SQL, UNIX, HP - Quality Centre,Autosys

Confidential

Technical Lead

Responsibilities:

• Worked on 2 projects Human Resources Information Technology and Project and Portfolio Management
• Technical Lead for the all the Inbound and Outbound feeds in HR Warehouse includingLegal and Compliance, Talent Management Finance and Payrole system.
• Played a key role as a core developer and feeds lead in a HR data migration project ARORA from PeopleSoft application to Workday application
• Responsible for gathering User requirement for the Project
• Worked in the governance process for the creating the feeds.
• Worked on creating the estimation for the Feeds development
• Involved inInformatica ETL technical design discussions and prepared ETL high level technical design document
• Responsible for analyzing of source to target mapping provided by data analysts and prepared function and technical design documents
• Created the guidance document for the feeds developers.
• Created reasonability Unit Test cases for testing the Feeds and executed unit test scripts successfully
• Extensively worked on performance tuning of Informatica code using standard Informatica tuning steps
• Created mapping for loading the Projects, Program/Portfolio and Product and services attributes into the Legacy Warehouse System.
• Handling Downstream feeds which sends the Receiving Cost Center Allocation details to the respective teams used for Budget/Manpower calculations.
• CreatedInformatica mapping forconnecting Web services (WSDL/XSLT/XML) to read data from web servers.
• Created Informatica mapping using HTTP Transformation to connect to Web Service application for Get Workers in Workday.
• Performed Informatica upgrade from V8.6.1 to 9.0.1
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments using Repository manager and Infats commands.(EBIS)
• Created Informatica Folders, Groups, roles, privileges and assigned them to each user group via admin console.
• Worked in modifying the Budget and Forecast Q1, Q2, Q3 and Q4 calculations for the Project Management and Process Reporting feed
• Handled the performance tuning of SQL/PLSQL scripts based on explain plan
• Extensively worked on creating procedures and functions for Infomatica mappings.
• Worked on breaking down and grouping the mappings with respect to subject are using mapplets, worklets, sessions and workflow.
• Created Autosys job using JIL files for scheduling the workflow.
• Monitored the Informatica jobs using the Autosys Job Interface and BatchMon Applications.
• Wrote generalized Unix script for running the workflows using pmcmd command
• Wrote UNIX shell scripts for file transfer/archiving./Email notifications and sending files via comet
• Involved in code Reviews with the team as per ETL/Informatica standards and best practices
• Worked as a L3 support for resolving production issues on Feeds.

Environment: Informatica 8.6/9.1, Sybase, Oracle 10g, PL/SQL, DB2, SQL Server 2008, DB Artisan, Business Objects, Unix/Linux, Autosys and comet

Confidential

Senior Developer

Responsibilities:

• Worked on Mutual Fund Serviceswarehousing project
• Worked with the users to gather and study the user requirements on the project.
• Created Technical specification document based on the Businessspecifications document, which includes the database objects/changesneeded and the clear approach includes pseudo code to meet the project requirements.
• Developed mappings and mapplets extensively using Informatica Designer tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer
• Created Facts and dimension tables and also worked with the Slowly Changing Dimension Tables.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Filter, Router, Rank, Union, Sequence Generator, Update Strategy, and Joiner
• Using Autosys, created the job which runs a UNIX script. The script in turn runs the pmcmd command to run a workflow.
• Handled responsibilities as a PL/SQL Developer and as a Data Analyst.
• Created database objects like tables, views, synonyms, procedures,functions and data base triggers to meet the business requirements using Oracle and SQL Server.
• Designed, implemented and tuned batch jobs using PL/SQL.
• Analyzed the execution plan and the statistics of the optimizer andpassed the hints and placed indexes wherever necessary.
• Created numerous views and materialized views based on the business requirement.
• Did bug fixing for several stored procedures.
• Responsible for creating user profiles and setting up privileges.
• Documented all PL/SQL procedures and user guide for different processes followed
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user
• Responsible for the Performance tuning of the queries using Explain Plan.
• Involved in the continuous enhancements and fixing of production problems.

Environment: Informatica 8.1.1, Crystal Reports XI R2, Oracle 9i, PL/SQL, SQL Server 2005, Sybase, TOAD, Unix, Autosys

Confidential

Senior Developer

Responsibilities:

• Worked on Partner Sales Support project
• Remodeling the DB for the enhancement of the project.
• Prepared the Scope Documents for the Change Requests and Reports
• As a Data Analyst reviewed unmatched data for any Selling Advantage Accounts and submit matching.
• Developed Stored Procedures, Triggers, Functions and SSIS Packages for ETL activity.
• Interface with PIM and other partners to manage overall data health status communications to team and key partners
• Hierarchy Maintenance - Analyzing and maintaining the Accounts roll up to their appropriate parent using SSIS
• Create and execute ad hoc reporting as business requires using Reporting Services.
• Developing recurring reports, updating on a weekly and monthly basis, analyzing and distributing information to key decision makers.
• Data entry, cleaning, aggregation, merging and summarization. Alarm PSS TEAM on data inconsistencies, if any and then cleans the data to make it consistent across data sources by merging data from different formats or by contacting the right SPOC /DEPT in having it accomplished
• Ensure that the collateral, internal and external documents that are used in the PSS-TEAM are standardized
• Documenting End- To - End process for future reference and for audit purposes.
• Sending Bravo Rule - This rule is set to reduce the flow of unmatched data
• Reconcile Finance Data warehousing (FDW) and SAP data by Purchase Order (PO) using SSIS.

Environment: SQL Server 2005, SSIS, SSRS, Business Objects

Confidential

Developer/Team Lead

Responsibilities:

• Worked on Real Estate Assets and Portfolio Manager (REAP-CS) Project
• Handled responsibilities as a Data Warehousing and PL/SQL Developer for the company’s flagship product REAP - Real Estate Assets and Portfolio Manager
• Installed, configured and administered QA, DEV, PROD servers at clients Place and at Profit Center locations.
• Created several scripts for data loading on Oracle 9i Databases.
• Responsible for creating user profiles and setting up privileges in Client’s environments.
• Involved in Extraction, Transformation and Loading of data from source to target using Informatica
• Created Facts and dimension tables and also worked with the Slowly Changing Dimension Tables
• Developed mappings and mapplets extensively using Informatica Designer tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer
• Developed various Mappings using Aggregator, Joiners, Lookups, Filters, Router, XML and Update strategy Transformations.
• Monitoring the identified ETL processes, restarting the ETL processes that aborted and Monitored workflows to collect performance data to maximize the session performance.
• Extensively worked withBusiness Objects XI from gathering requirements, Installation, Designing Universes, creating BO reports, testing, implementation and finally training the users.
• Extensively worked in creating Universe, import - export Universes and creating User groups and also developed critical reports like drill down, Slice and Dice, master/detail for analysis
• Extensively worked in development of database, tables, triggers, and stored procedures to clean and validate the data per company specifications.
• Responsible for creating Functional and technical Design documents, and hold the reviews with business team and IT team.
• Designed and scheduled materialized views to take advantage of the Optimizer’s query rewrite capabilities.
• Responsible for making adjustments to existing dataflow mappings and schema changes from time to time to suit evolving interface systems, database and application upgrades.
• Performed daily tasks including backup and restore and run DBCC commands.
• Performed basic DBA Level activities at Clients environment.
• Responsible for the conversion of data from Site seer Application to Reap-CS Application
• Automated the backend of the application using DTS, VB and SQL Stored Procedures
• Performed data modeling using Visio and Erwin
• Created Numerous Reports including Drill Down, Drill Through, Sub Report on regular and adhoc basis using both Reporting Services and Crystal Reports.
• Create Unit Test Script and define Test Data.

Environment: SQL Server 2000, 2005, Oracle 9i, PL/SQL, MS Access, SSRS, Informatica 7.1, Delphi, R-Builder, XML, Crystal Reports XI, Business Objects XI, DTS, FoxPro.