Summary

• 7 plus years of IT experience and 6+ years of experience in Data Warehousing including Requirement Analysis, Data Analysis, Application design and development and Data modeling in client/serverenvironment.
• Certified in N - PowerCenter 7 Mapping Designer and INS21 (Property and Liability Insurance Principles).
• Vast experience in Insurance and Banking Industry.
• Strong Domain Knowledge of Card Services, Surety Bonds, Property and Liability Insurance.
• Trained in Informatica, DB2, Oracle 9i, MS SQL, MS Project, C#, ASP.NET, C, C++, Quality Centre and QTP 9.0.
• Good experience in ETL tool Informatica PowerCenter/ Power Mart 6.1, 7.1 and 8.6.
• Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star and Snow-Flake Schemas.
• Worked on Slowly Changing Dimensions Type 1, Type 2 and Type 3.
• Experience in Performance tuning of sources, mapping and sessions.
• Working knowledge in creating Partition Points in mappings and Partitions in a session.
• Experience in Extracting data from Flat files, Oracle 10g/9i/8i, MS SQL server 2005.
• Extensively used SQL/PLSQL to create Stored Procedures, Functions, Triggers and Packages.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Knowledge of Hyperion SQR and Crystal Reporting tool.
• Working knowledge in UNIX Shell Scripts.
• Experience in providing Post-Implementation Production / Maintenance.
• Possess sound knowledge of Project processes in tune with CMM Level 5 and internal Quality Audits.
• Effective in executing multiple tasks and assignments with aggressive and demanding project schedule and team environment.
• Strong communication and interpersonal skills with very good analytical and problem solving skills.
• Ability to work individually and in a team environment.

TECHNICAL PROFILE

Tools: Informatica Power Center 8.x/7.x/6.x, Control-M, AutoSys: For Development Quality Center, QTP 8.0: For Testing  TOAD, SQL* Plus, SQL Loader: For database
Clearcase, VSS, Perforce and Serena Version Manager:For configuration management  ClearQuest, Quality Center, MKS:For defect tracking  Erwin: For modeling Class/Sequence/Entity Relationship Diagram STAT: Assign/Resolution of tickets
Programming Languages: C, C++, PL/SQL, .Net 
Databases: DB2, Oracle 10g/9i/8i, SQL server 2005 and MS Access 
Operating Systems: Windows NT/95/98/2000/XP, MS-DOS, UNIX and Linux
Modeling: UML
Scripting: UNIX Shell and VB scripting

CERTIFICATIONS

Certified in N - PowerCenter 7 Mapping Designerand INS21 (Property and Liability Insurance Principle).

EDUCATION

Bachelor of Engineering (B.E in Electronics and Communication)

Work Experience

Informatica Consultant – PDR– (Confidential, New York, NY) Mar 2010 – Present

Project Phoenix data Repository Application:
PDR (Phoenix Data Repository) supports all Confidential’s management information and provide greater transparency into Firm’s financial reporting. PDR workstream provides consistent data to downstream subscribers. The data workstream used a business point of view as organizing principle for modeling.

Responsibilities:

• Involved in break-up meetings to gather requirements and suggest solutions for business challenges.
• Have participated in meetings for field-level mapping for 3rd party systems and PDR systems.
• In order to meet higher volume of business data and reduce the overall processing time, the job was designed to run concurrently.
• Designed logical and physical data models using ERWIN.
• Working as data analyst understand Current usage of data within the pre-existing Data warehouse environment, and determines appropriate structure (DDL) and load Strategy for the new target Data Warehouse , based on data requirements and data profiling.
• Designed mappings for slowly changing dimensions Type 2, used Stored Procedure, lookup (Connected,
• Unconnected), update strategy, filter transformation for historical data.
• Worked with UNIX shell scripts for job automation and to invoke Informatica Workflows and Sessions.
• Made the restartability very easier as the jobs involved clean-up process & optimization was made to the clean-up process.
• Have designed the AutoSys Batch Job to load data from NFS system to ETL Source folder.
• Sending Email Notifications for sessions failures and rejected data in error logs to PDR support Team & downstream subscribers.
• Deploy ETL & DB code to QA, UAT & PROD environment using INFATS & DB2 turnover system.
• Developed pre-session, post-session routines for batch restartability.
• Created various tasks, arranging related tasks in different worklets, arranged different worklets in workflow depending upon their interdependencies in workflow manager.
• Coordinate with DBA to setup Extract & Extract details to downstream subscribers in UAT and production environments.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Provide solutions to problem tickets of the users within SLA.
• Provide 24/7 on call support.

Technical Environment: Informatica Power Center 8.6.5, DB2, AutoSys, DB2Artisan, Perforce, UNIX, INFATS(proprietary tool).

Application Developer – Edge– (Confidential, Salem, NH) Apr 2009 – Feb 2010

Project Platform Balancing Application:
Platform Balancing is a systematic method to operationally balance the Salem Platform and associate financial events with identified balancing accounts that support financial inventories. Platform Balancing is deposit based detail reconciliation. Deposit transactions sent by Third Party will be reconciled against the funding file transactions received in funding advice file also sent by Third Party.

Responsibilities:

• Involved in getting the business requirements based on user specifications and transforming into ETL design document, which includes operational information, development guidelines, data migration and scheduling.
• Created a series of Business processes to balance the platform which support the working and correction of exception events and activities which require manual intervention.
• Improved quality of the data by incorporating multiple quality check prior to loading the data. By implementing data validation checks reduced the time in diagnosing data related issues.
• Made the restartability very easier as the jobs involved clean-up process.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Recovering and Restarting of PowerMart Jobs on scheduled stops and failures.
• Monitoring of Power Center sessions for failures and rejected data in error logs.
• Re-develop Informatica mappings as part of code changes according to changed business and regulatory requirements.
• Involved in the development of the control process to handle the incremental loads and improve the performance.
• Coordinate with DBA’s for Performance issues to reduce runtime of SQL queries.
• Provide solutions to problem tickets of the users within SLA.
• Provide 24/7 on call support.
• Developed Process Oriented document for PowerMart Jobs.
• Developed complex mappings using Lookups connected and unconnected, Sorter, Joiner, Aggregator, Filter, Router transformations to transform the data per the target requirements.
• As a member of the Warehouse implementation Team which interacted with business clients and Database Administrators to identify the data realities.
• Wrote complex SQL queries involving multi table joins and outer joins using Toad (Quest).
• Coordinated with the Business Intelligence team in developing web reports.
• Used FTP as source of the flat files for loading daily/monthly loads on to the Major clients Data Mart.
• Created various tasks like commands task, email task, decision task, arranging related tasks in different worklets, arranged different worklets in workflow depending upon the interdependencies in workflow manager.
• Created workflow variables, mapping variables and parameters for better performance.

Technical Environment: Informatica Power Center 8.6.5, Oracle 10g/9i, Toad, MKS, Version Manager, Control-M, Windows 2003 Server, Linux.

Application Developer – Edge– (Confidential, Salem, NH) Dec 2008 – Mar 2009

Project Edge Application:
Project Edge is a large integration project done to bring disparate paymentech platforms together. The project involved extensive Informatica coding to receive, translate data to and fro between the two (retail and online) paymentech platforms. It also involves reconciliation of settled data with transaction files received.

Responsibilities:

• Involved in break out sessions with users, business to understand business requirements and implementation plan Designed and coded master slave process to assign, consume and process and load customer information files sent in XML format.
• Extensive use of XML queries and midstream XML transformation like XML generator and XML parser.
• Developed code to continuously scan load process and provide feedback to source system with data errors during load process and status.
• Designed a flexible control table based file creation method to easily create multiple small files of settled data that are easily manageable at target side for loading.
• Reduced coding by creating reusable mappings that are shared among all the file creation process irrespective of the data that is being moved.
• Used parameter files to leverage reusable code and run multiple process for different types of settled data like fees, fund information, transaction etc.
• Involved in 24x7 UAT testing, issue tracking and resolution.
• Developed several mappings for extraction/Transformation, data cleansing and loading of data into staging areas.
• Created Process Orientation document for Production Support.
• Optimized session performance by creating partition points and partitions in the mappings and sessions respectively.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.
• Participate in issue research and resolution for production when appropriate.
• Supporting the Production environment for nightly basis runs which includes different subject areas of Streams.
• Studying Root cause analysis and implementing preventative measures.

Technical Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, MKS, Version Manager, Control-M, Windows 2003 Server, Sun Solaris

Informatica Consultant– Revenue Master– (Confidential, Hoboken, NJ) Dec 2007 – Aug 2008

Project Revenue Master Application:
Revenue Master helps to consolidate Revenue Data in Phoenix Database. It aims at providing a single version truth for all revenue based reporting for applications like Annual Disclosure, profitability and Forecasting. The system will enable retiring various legacy reporting structures. This Project involved maintenance of customer data that flows from legacy systems to customer management application. As a part of maintenance, it also involved code changes according to changed business and regulatory requirements.

Responsibilities:

• Involved in getting the business requirements based on user specifications and transforming into ETL design document.
• Involved in resolving various Remedy Tickets resolution for the Development team.
• Developed several mappings for Extraction/Transformation, data cleansing and loading of data into staging areas and data marts also documented the same into Release Manuals.
• Analyzed performance bottlenecks, tuned various mappings and created reusable transformations.
• Worked on defect analysis to implement new enhancements as per the specifications and user requirements.
• Maintain Version Control using ClearCase.
• Developed pre-session, post-session routines to drop indexes and to reassign them.
• Created various tasks, arranging related tasks in different worklets, arranged different worklets in workflow depending upon their interdependencies in workflow manager.
• Developed parameter file templates and used parameters, variables to make mappings more flexible.
• Performed unit testing and system testing of the mappings developed and documented with various scenarios.

Technical Environment: Informatica Power Center 8.1.1(sp 4), Oracle, MS SQL Server 2005, ClearCase, ClearQuest, Windows 2003 Server, UNIX.

Informatica Developer –MarshConnect– (Confidential, Hoboken, NJ) Aug 2006 – Nov 2007 
The companies of MMC are among the world’s leading global advice and solutions providers in risk, strategy and human capital. This Data warehouse is designed for risk managers desktop access to their organization’s insurance, risk and industry analysis information. This project involved extracting data from different systems like FACTS and RPA.

Responsibilities:

• Involved in getting the business requirements based on user specifications and transforming into ETL design document.
• Created users and groups and assigned necessary privileges and permissions.
• Used Mapping Parameters and Variables in the mappings.
• Created Decision, Control, Command and Email tasks in workflows.
• Developed Functions and Procedures using PL / SQL.
• Participated and performed Peer Reviews and Code Reviews.
• Tuned the mappings to get better performance and optimization.
• Used TOAD to develop oracle PL/SQL Stored Procedures.
• Analyzed the Informatica mappings and made enhancements and corrections.
• Documented the mappings used in ETL processes.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Provided Post-Implementation Production Support / Maintenance.

Technical Environment: Informatica Power Center 7.1.3, TOAD for Oracle 8.1, UNIX

Informatica Developer –Programming Analytics– (Confidential, Hartford, CT) Mar 2005 – Jul 2006 
The programming analytics application aims to provide maximum insight in the programming assets of the company and critically analyze and review there performance against different parameters. ETL jobs are designed & developed to populate data in ODS, Staging & Data Mart. ETL jobs extract the data from the various source systems like relational database, flat files, excel sheets in rows and columns format, transform the data as per database needs and aggregate/consolidate the data for reporting purposes.

Responsibilities:

• Extracted data from Oracle sources, flat files and loaded into Oracle targets.
• Used Mapping Parameters and Variables in the mappings.
• Designed mappings for slowly changing dimensions Type 2, used lookup (Connected, Unconnected), update strategy, and filter transformation for historical data.
• Extensively worked with sorter in combination with Aggregator for improving the performance of aggregations.
• Performed incremental aggregation to load incremental data into Aggregate tables.
• Created SQL scripts for unit testing.
• Tuning the Informatica mappings for optimal load performance.
• Created sessions and workflows using Workflow Manager for data loads at specific intervals and on demand into the warehouse.
• Maintained technical documentation.

Technical Environment: Informatica Power Center 7.1.3, Oracle 9i, PL/SQL, UNIX

Informatica Developer – APCS – (Confidential, Hartford, CT)
May 2004 – Feb 2005 
The Agri Business unit of ST. Paul Travelers offers competitively priced programs for farms, ranches and large commercial growers of agricultural products. The application supports various transactions like New Business (Issue and Quote), Change, Renewal, Cancellation & Rewrite and Replace, Agribusiness is a mainframe based application. The project was to build a Data Mart, which leverages data from an existing Data Store apart from other sources. Data from different sources was brought into Oracle database designed dimensionally using Informatica ETL and used for reporting using Business Objects tool.

Responsibilities:

• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.
• Involved in writing SQL Stored procedures to access data from Oracle, MS SQL Server 7.0.
• Worked with mapping parameters and variables.
• Used debugger to test the data flow and fix the mappings.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Developed Mapplets for the varying requirements for code reusability.
• Performed regression tests prior to Informatica code being placed in production environment

Technical Environment: Informatica Power Center 6.1, Oracle 8i, PL/SQL and UNIX

.Net Developer/ Quality lead and Configuration Librarian – Janus – (Confidential)
Jun 2003 - Apr 2004 
The Janus is web application in .Net platform for Home Office Measurement requirements of Confidential. JANUS intend to respond the needs of complex projects (split in several phases, involving several Engineering Centers, including “Partner” external to the Technip-Coflexip Group) as well as simple ones. Progress will be measured at the level of “Deliverables” which are elementary tasks, each deliverable being split into set of milestones.

Responsibilities

• Played Key role in giving quick and efficient solution to challenge posed during the execution of Business Process.
• Always gone to the root-cause of the problem or bug and gave solutions, this catered to the Business Need.
• Designed and developed the User Interface using HTML/DHTML.
• Developed Business Logic using C#.
• Developed Web Service for separating Application from Reporting services for High Performance.
• Developed Reusable User Controls.
• Created Stored Procedures, Views and Functions.
• Performance tuning on Stored Procedures.
• Testing and extensive user interaction.
• Quality Assurance
• Performed load testing using the .Net tool Application Centre Test(ACT).

Environment

ASP.NET, C#, ADO.NET, COM+ Java Script, XML, Web Services, Oracle 9i,Business Objects, Crystal Report, Sybase.