SRIKANTH MAMIDI

Email: ac80jr@r.postjobfree.com

(M): 860-***-****

PROFESSIONAL SUMMARY:

Over 13 years of professional experience in analysis, design, development and implementation of software applications mainly in the field of Data warehouse and Client / Server Web Applications in UNIX and Windows environment.

Over 8 years of experience in Informatica ETL tool (Informatica Power Center 5.X/6.X/7.1/8.6.1 (Source Analyzer, Warehouse Designers, Repository Manager, Server manager, Mapping/Mapplet/Transformations, Repository Server, and Workflow Manager) with overall 5 years of Data warehousing and Data Mart experience in a high-volume environment.

Over 5 years of experience working in SSIS /SSRS & SSAS.

Well versed with various Informatica transformations and implemented number of complex mappings

Good experience in Object-Oriented, multi-threaded, software development experience using C/C++ for both PC and embedded environments.

Experienced in using UNIX shell scripts.

Strong programming skills in SQL, PL/SQL.

Data Modeling knowledge using Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.

Has strong development skills including the ability to work through the entire development cycle (SDLC) from gathering requirements through implementation and maintenance.

Excellent communication skills, problem solving skills, Leadership qualities and an attitude to learn the new cutting edge technologies.

TECHNICAL SKILLS

Programming Languages : C, C++, Java2, VB, SQL, PL/SQL. Perl, HTML

Database Tools : MS-Access, Oracle-9i/10g, DB2, SQL Server 2000/2005/2008 R2

ETL Tools : Informatica (Power Center 5.x/6.x/8.6.1, PowerMart 5.x

SSIS /SSRS/SSAS

CAD Tools : AutoCAD 2000, Pro/E, CATIA-V5 part modeling

Operating Systems : MS-DOS, Windows NT, XP, UNIX, Linux, Sun Solaris

Others : MS-Word, Excel, PowerPoint, Outlook, Exchange

WORK EXPERIENCE

Client: Aspen Insurance, RockyHill CT Mar 14 – Present

Role: Sr. ETL Developer

Project: USDatahub Financial Reporting & Controls/ Claim Center Guidewire (Processing US Claims and LM Messages through Single Instance)

The US DataHub is the US Data Warehouse and sole integration point for all strategic systems for US operations.

These systems include Duck Creek, ClaimCenter, iAutomate (Surety Policy Admin), Instec (Commercial Auto Policy Admin), Programs Data Repository (PDR), CODA, ProCede and the US Insurance Reporting Cubes.

Responsibilities:

Work closely with Business Analysts to gather requirements.

Write Technical Specifications based on the requirements provided by the Business.

Create Source to Target mapping documents.

Design, develop, and unit test integration steps.

Generate data extracts for different Business Units and Import it into an Access Data base.

Develop processes to identify data lineage for existing data warehouse data.

Develop staging, dimension and fact loads for disparate sources.

Develop transformation process using SSIS/SSRS, SQL Server 2008 R2 and Autosys.

Develop data Mappings between source systems and warehouse components.

Responsible for Planning and Implementation of process into QA and Production..

Environment: SSIS 2008, SSRS/SSAS, SQL Server 2008 R2, SQL Developer, Erwin, PL/SQL, SQL plus, Autosys, TFS, BIDS.

Client: VMWARE Aug 13 –Mar 14

Hyderabad, India

Role: Informatica Analyst

Project: EBILLING

LexisNexis’ CounselLink solution - is a SaaS (Software as a Service) solution for in-house counsel and their outside law firms to manage legal billing processes.

As part of this project, created a few interfaces/integrations to and from Oracle EBS to LexisNexis eBilling system.

The objective of this project is to create legal vendor invoices in the ebilling application and to interface the same to Oracle EBS.

VMware currently manages Vendor setup, Matter Management, Law Firm billing process manually through email exchange with the Outside Counsel/Law Firms.

With this project, Legal wants to implement a SaaS based eBilling solution for basic matter management and automate law firm billing process – from submission of electronic invoices through review, transfers to Oracle and payment tracking.

Responsibilities:

Work closely with Business Analysts to gather requirements.

Write Technical Specifications based on the requirements provided by the Business.

Create Source to Target mapping documents.

Design, develop, and unit test integration steps.

Prepared Unix shell scripts for Inbound and Outbound file transfer and included secure handling of encrypted file transfers.

Develop transformation process using Informatica PowerCenter 8.6.1, SQL Server 2005 and Autosys.

Develop data Mappings between source systems and Integration components.

Worked on the Integration testing along with other teams

Environment: Power Center 8.6.1, Oracle 10g, SQL Developer, Erwin, PL/SQL, SQL plus, Autosys, Unix.

XL Insurance, Hartford, CT Jan 11 – Jun 13

Role: Sr.Informatica Analyst

Project: Solvency II (S2 FDM & QRT)

Solvency II is a new risk based regulatory requirement for insurance and reinsurance organizations that operate in the European Union. It deals with the adequacy of capital allocation and risk management to protect policyholders.

The new system is intended to offer insurance organizations incentives to better measure and manage their risk situation – i.e. lower capital requirements, lower pricing etc.

The Purpose of this project is to build a Solvency II Data layer for Quarterly/Annual reporting purposes. Different types of financial reports are generated out of this layer.

Responsibilities:

Work closely with Business Analysts to gather requirements.

Write Technical Specifications based on the requirements provided by the Business.

Create Source to Target mapping documents.

Design, develop, and unit test integration steps.

Generate data extracts for different Business Units and Import it into an Access Data base.

Develop processes to identify data lineage for existing data warehouse data.

Develop staging, dimension and fact loads for disparate sources.

Develop transformation process using Informatica PowerCenter 8.6.1, SQL Server 2005 and Autosys.

Develop data Mappings between source systems and warehouse components.

Work with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager.

Use transformations like source qualifier, Normalizer, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.

Responsible for Planning and Implementation of process into QA and Production..

Environment: Power Center 8.6.1, SQL Server 2008, Oracle 10g, SQL Developer, Erwin, PL/SQL, SQL plus, Autosys, Windows XP/NT.

XL Insurance, Hartford, CT Mar 10 – Dec 10

Role: Sr.Informatica Analyst

Project: Reinsurance Data Mart Project

XL Capital Ltd (XL) is a provider of insurance and reinsurance coverage to industrial, commercial and professional service firms, insurance companies and other enterprises on a worldwide basis. The Company operates through four business segments: Insurance, Reinsurance, Life Operations and Other Financial Lines.

Worked as a developer on this Project to acquire Reinsurance data from 4 different source systems and produce a data mart for Reporting needs. All the billing and cash information was provided based on which an overall balance is generated.

Responsibilities:

Worked closely with Business Analysts to understand requirements.

Designed, developed, and unit tested integration steps.

Developed processes to identify data lineage for existing data warehouse data

Developed staging, dimension and fact loads for disparate sources.

Developed transformation process using Informatica PowerCenter 8.6.1, SQL Server 2005 and Autosys.

Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.

Developed data Mappings between source systems and warehouse components.

Environment: Power Center 8.6.1, SQL Server 2005, Oracle 10g, SQL Developer, Erwin, PL/SQL, SQL plus, Autosys, Windows XP/NT.

XL Insurance,Hartford, CT Mar 09 – Feb 10

Role: Informatica Analyst

Project: Insurance Finance Data Mart Project

Worked as a developer on a project to acquire data from Insurance Financial Reporting and Controls database and produce a data mart for Financial Reporting needs. This was successfully implemented on time, meeting all deliverables within a very tight timeframe.

Roles:

Worked closely with Business Analysts to understand requirements.

Designed, developed, and unit tested integration steps.

Developed processes to identify data lineage for existing data warehouse data

Developed staging, dimension and fact loads for disparate sources.

Developed transformation process using Informatica PowerCenter 8.6.1, SQL Server 2005 and Autosys.

Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.

Developed data Mappings between source systems and warehouse components.

Responsible for implementation into Production and Post "Go-Live" planned maintenance releases through QA and Production.

Environment: Power Center 8.6.1, SQL Server 2005, Oracle 10g, SQL Developer, Erwin, PL/SQL, SQL plus, Autosys, Windows XP/NT.

XL Insurance, Hartford, CT Jun 07 – Feb 09

Role: Informatica Analyst

Project :Financial Reporting & Controls

XL Capital Ltd (XL) is a provider of insurance and reinsurance coverage to industrial, commercial and professional service firms, insurance companies and other enterprises on a worldwide basis. The Company operates through four business segments: Insurance, Reinsurance, Life Operations and Other Financial Lines.

The objective of the Swiss Genius Strategic (SGS) project is to replace the four existing Swiss Genius Contingency interfaces with a new single interface that sources all required financial information directly from the Swiss Genius system tables. The SGS interface will create balanced journal files for all in scope Swiss Genius units that will be posted to PeopleSoft. These journal files will consist of Income Statement (IS) and Balance Sheet (BS) ledger entries and represent monthly financial movements.

Responsibilities:

Extensively used Informatica to load data from Flat Files, AS400 sources, Oracle and SQL Server Databases.

Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager.

Extensively used Stored Procedures, Functions and PL/ SQL Programming.

Used transformations such as the source qualifier, normalizer, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.

Checked and tuned the performance of application.

Developed data Mappings between source systems and warehouse components.

Created and defined DDL’s for the tables at staging area.

Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.

Analyzed systems, met with end users and business units, in order to define and meet the requirements.

Automated mappings to run using UNIX shell scripts, which included Pre and Post-session jobs.

Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.

Installed and configured Informatica Tools on client machine on Windows NT environment.

Environment: Power Mart/ Power Center 7.1.2, SQL Server 2000/2005, SQL Developer, Erwin, PL/SQL, SQL plus, Autosys,Windows XP/NT.

Hartford Insurance, Hartford, CT Apr 06 – May 07

Role: Informatica Developer

Project : Claims Data Warehouse

The Hartford is a leading provider of investment products, life insurance and group and employee benefits; automobile and homeowners products; and business insurance. The Hartford serves customers through independent agents and brokers, financial institutions, affinity groups and via the Internet. The Claims Data warehouse project was designed for the development of customer services. Data from different vendors used to be extracted on a daily basis and loaded into the data warehouse. Reports are developed using Business objects from the data warehouse.

Responsibilities:

Extensively used Informatica to load data from Flat Files, COBOL sources, XML and Oracle.

Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager.

Extensively used Stored Procedures, Functions and PL/ SQL Programming.

Extensively used Normalizer transformation while loading the data from the COBOL copy books to the staging area.

Used transformations such as the source qualifier, normalizer, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.

Checked and tuned the performance of application.

Developed data Mappings between source systems and warehouse components.

Created and defined DDL’s for the tables at staging area.

Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.

Analyzed systems, met with end users and business units, in order to define and meet the requirements.

Automated mappings to run using UNIX shell scripts, which included Pre and Post-session jobs.

Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.

Installed and configured Informatica Tools on client machine on Windows NT environment.

Used to carry pager 24 * 7 on a weekly basis.

Environment: Power Mart/ Power Center 7.1.2, Oracle 10g, Toad 8.1, Erwin, PL/SQL, SQL plus, Autosys,Windows XP/NT, UNIX.

Circuit city, Richmond, VA Oct 05-Mar06

Role: Informatica Developer

Project: Merchandise System Transformation

Circuit City Merchandise System Transformation is aimed at designing and building a “top down’’ planning solution utilizing Oracle Retail’s “Fast Track” design and methodology as the foundation.

By utilizing the “Fast Track” foundation, Circuit city expects to deliver industry best practice capabilities while minimizing implementation time and expense. MST program is a program to implement new merchandising planning, forecasting and management systems within Circuit City. Apart of reaping key business benefits this program was also expected to significantly reduce the custom application footprint at Circuit City.

Responsibilities:

Responsible for studying the existing data warehouse and also working on PL/SQL packages, stored procedures, triggers and functions.

Worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer..

Extracted data from different databases like DB2, INFORMIX, ORACLE and Flat files.

Developed various Informatica mappings and mapplets using complex transformations like Aggregators, lookups, Filters, Sequence Generator, Normalizer, Update strategy and stored procedure transformations.

Handled operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.

Created parameter files and declared values to parameters and variables used in workflow, worklet or session.

Designed and developed complex mappings to load historical and Weekly data from the legacy systems to the Retek application.

Involved in Performance tuning and elimination of bottlenecks for better performance.

Responsible for Creating workflows and worklets. Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.

Involved in writing the design document for the initial load extracts.

Involved in writing Unit Test cases and validating the data based on the test cases.

Created Data Flow Diagrams using Microsoft visio to depict the flow of the Mappings.

Scheduled and monitored the Sessions which populate the data to the target Data Warehouse at off-peak times.

Used Autosys scheduler to schedule jobs for weekly and history data loads.

Used PVCS Version Manager to Promote Informatica Objects from Development to Test and then to the Production environment.

Used WinSql to query on different databases like AS 400 DB2, Oracle and Informix.

Environment: Informatica Power Center 7.1.2, Cognos 8, Korn Shell (ksh), Oracle 9.2, AS/400 DB2 8.1, PL/SQL, Erwin 4.0, Microsoft visio 2003, UNIX-AIX, Windows NT, SQL*Plus, SQL*Loader, FileZilla 2.2.1,WinSql 4.7,Autosys

Wipro, Platts Mc GrawHill Companies, NY Apr 05 – Aug 05

System Analyst

Platts is the world’s largest and most Authoritative source of energy industry information and services. Platts has helped to enable ever-changing global energy markets enhance their performance through such offerings as independent industry news and price benchmarks. Main aim of the project is to build a data warehouse and using informatica tool extracted data from various external sources and loaded into oracle target database.

Responsibilities:

Worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.

Responsible for studying the existing data warehouse and also working on PL/SQL packages, stored procedures, triggers and functions.

Used Extraction Transformation and Loading to transfer the data to the target Database.

Wrote the shell scripts to process the PL/SQL procedures and wrote the PL/SQL program units for data extracting, transforming and loading.

Developed transformation logic to cleanse the source data of inconsistencies during the source to stage loading.

Developed various Informatica mappings and mapplets using complex transformations like Aggregators, lookups, Filters, Sequence Generator, Normalizer, Update strategy and stored procedure transformations.

Worked with different types of partition techniques like key range, pass through, Round Robin and Hash partitioning.

Created parameter files and declared values to parameters and variables used in workflow, worklet or session.

Wrote Pre-session and Post-session shell scripts for dropping, creating indexes for tables, Email tasks and various other applications.

Involved in Unit, System integration, User Acceptance Testing of ETL Process.

Created and Monitored Sessions and Batches using workflow Manager to load the data into the Target Database.

Documentation and preparation of user manual for end users.

Involved in the production support and solved the issues.

Environment: Oracle 9i, Informatica power center 7.1.2, Windows NT, Toad, Sql* plus, SQL*Loader, Shell Scripting, JavaScript, HTML, HP-UNIX, Linux, Windows 2003.

Contact this candidate