PARAMESH KOLLISETTI Mob: 630-***-****

Location: Herndon, VA

Summary

Innovative, experienced, and technically inclined IT Professional with extensive experience of 12+ years in Informatica development/Production support and emerging ETL technologies primarily with Informatica. Highly analytical in providing comprehensive system analysis, detail design, as well as development and integration of operating policies. Equipped with system development aptitude that includes requirement definition/evaluation, architecture, testing, and support. Exceptional abilities to coordinate and direct all phases of project-based efforts motivating and guiding teams.

Informatica Lead/Developer/production support with over 12 years of IT System Architecture, Design, Development, Production support, Testing and Implementation of Data warehousing solutions and applications.

Strong background in Data Warehousing and Database development with 10+ years of experience in providing Business Intelligence solutions in Data Warehousing and Decision Support Systems.

Ability to create process frameworks, design and implementation of large scale data migration and data processing using massively parallel processing programming techniques

Involved in Process change/improvement and Quality Risk Analysis, scalability, reusability, security and maintainability

Experienced in complete Software Development Life Cycle which includes Software Requirements gathering, Systems Analysis and Design, Code Generation, Testing, implementation and Maintenance of various large scale enterprise applications.

Proven expertise in production support (24*7) for several critical applications that have level 1 SLA’s.

Sound Knowledge and experience in Dimensional Data Modeling (Star Schema, Snow-Flake Schema, FACT and Dimension tables), Conceptual, Physical and Logical data modeling.

Expertise in Inmon and Kimball Data Warehouse Methodologies.

Extensive experience using Informatica Power Center, PowerExchange for CDC, Data Quality, Master Data Management, Data stage, SNAPLOGIC ETL.

Extensive work experience in Relational Database Systems like Oracle11g, 12c, DB2, SQL Server2005/08/12/14, NETEZZA and MS Access.

Expertise in developing SQL and PL/SQL code objects including Stored Procedures, Functions, Triggers, Packages and Views.

Skills Summary

O/S:

UNIX, WINDOWS XP/2K, WINDOWS 95, WINDOWS 98, MVS/ESA, MS-DOS, SUN SOLARIS 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 5.3

DATA

WAREHOUSING: INFORMATICA POWERCENTER 9.1.0/8.6/8.1.1/8.0/7.1.2/7.1.1, INFORMATICA POWEREXCHANGE 8.X, POWEREXCHANGE FOR CDC, Informatica Multidomain MDM 9.5.0 INFORMATICA DATA ANALYZER 8.6, INFORMATICA METADATA MANAGER 8.5/.6, INFORMATICA DESIGNER, WORKFLOW MANAGER, WORK FLOW MONITOR, DATA MART, OLAP, OLTP, AUTOSYS, CONTROL M, MAESTRO, 7.0/2000/5.5, SQL*PLUS, SQL*LOADER, Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) 2005/08/12.

DIMENSIONAL DATA

MODELING: DIMENSIONAL DATA MODELING, DATA MODELING, STAR JOIN SCHEMA MODELING, SNOWFLAKE MODELING, FACT AND DIMENSIONS TABLES, PHYSICAL AND LOGICAL DATA MODELING, ERWIN 4.5/4.0/3.5/3.2, ORACLE DESIGNER, VISIO.

BI TOOLS: INFORMATICA DATA ANALYZER 8.6, COGNOS Frame work Manager, BUSINESS OBJECTS XI R1/R2, Tableau, Micro Strategy 9.4

LANGUAGES: MF COBOL, CORE JAVA, JCL, C, C++, JAVA, HTML, SQL, XML, PL/SQL, EASYTRIEVE, AND UNIX SHELL SCRIPT

DATABASES: MS SQL SERVER 2000/2005/08/12, DB2/UDB, VSAM, ORACLE 8/9I/10G/11/12c, MS ACCESS, Netezza/Aginitiy Work Bench

DESIGN/DEVELOPMENT

TOOLS: RATIONAL ARCHITECT, RATIONAL ROSE, RATIONAL CLEAR CASE, RATIONAL CLEAR QUEST, ANT, UML

EXPERIENCE:

Magellan 12/16 – Present

Columbia, MD

Sr. ETL Consultant

Responsibilities:

Provide ETL Architecture solution for major streams like Data Conversion, Historical, Synchronization, Data Retention/Archival, Data Quality, and Reconciliation.

Designed and modeled Facts, Dimensions for multiple data marts using star schema including Fact less Facts, Aggregate and Summary facts.

Designed and deployed numerous Informatica mappings.

Performed Source Data Profiling and developed cleanse mapping using Informatica Data Quality.

Create Conceptual Data Model, Physical Data Model, Data Profiling Plan, Lineage document, Source to Target document, Mapping Specs, Test Strategy, Test Coverage Matrix, Integration, System and UAT Test Plans and Deployment Plan documents.

Created numerous Autosys jobs

Designed Exceptions handling, Error handling and checkout procedures as part of the validation process

Environment: Windows XP, Linux, Oracle 10g/12c, My SQL, PL/SQL, T-SQL, SSIS, SSRS Informatica PowerCenter 9.1.0/8.6, Data Quality, AutoSys, Unix Shell Scripting, Cobol, DB2, Netezza

Hilton World Wide

McLean, VA

Senior Data Warehouse Consultant 08/13 - Dec-2016

Key Project accomplishments in Hilton

Global bookings Report (Hadoop)

Global Stay report (Informatica/Tableau/Micro Strategy/Talend MDM)

People soft finance 89 to 91 conversion

Planning, Forecast & Budget

HR NET archive solution for HR data

FXRates (Informatica/ web services )

Responsibilities:

Prepare Architecture/Strategy Design Documents, Gap Strategy, data acquisition strategy, program specifications and flow diagrams.

Work with Project Manager/Scrum Master during Sprint planning to define PBI’s and estimate the tasks.

Coordinate and work closely with Enterprise architects, DBA’s, operations and business units to design, build and deploy Real Time Solutions.

Designed and implemented Real Time synchronization process between the old and new systems.

Provide ETL Architecture solution for major streams like Data Conversion, Historical, Synchronization, Data Retention/Archival, Data Quality, and Reconciliation.

Designed and modeled Facts, Dimensions for multiple data marts using star schema including Fact less Facts, Aggregate and Summary facts.

Designed and deployed Informatica Web Services.

Performed Source Data Profiling and developed cleanse mapping using Informatica Data Quality.

Performed System data quality assurance and stress testing, ensuring that software and systems perform to specification.

Create Conceptual Data Model, Physical Data Model, Data Profiling Plan, Lineage document, Source to Target document, Mapping Specs, Test Strategy, Test Coverage Matrix, Integration, System and UAT Test Plans and Deployment Plan documents.

Participate in quality assurance activities like reviews, walkthroughs etc.

Designed and implemented the ABC process for the Real Time processes.

Designed Exceptions handling, Error handling and checkout procedures as part of the validation process.

Core member of the ETL standards and best practices and code review governance board

Worked on several POC’s to implement Hadoop based Data Lake and analytic capabilities.

Environment: Windows XP, Linux, Oracle 12C, Informatica Power Center 9.6.1/9.5/, Talend MDM AutoSys, Unix Shell Scripting, Informatica Metadata Manager, Talend MDM, Micro strategy, Tableau, BIG data - HDFS, Map reduce, Sqoop,Spark,Scala, Cloud, Flume, AWS, PIG, HIVE, HBase

Magellan Health Services 12/11 – 07/13

Columbia, MD

Sr. DataWarehouse Consultant

Responsibilities:

Environment: Windows XP, Linux, Oracle 10g, My SQL, PL/SQL, T-SQL, SSIS, SSRS Informatica PowerCenter 9.1.0/8.6, AutoSys, Unix Shell Scripting, Cobol, DB2, Netezza

T. Rowe Price 08/10 –12/11

Owings Mills, MD

Sr. Informatica Consultant

Responsibilities:

Environment: Informatica Power Center 9.0.1, Informatica Power Exchange 9.0.1, DB2, Oracle 10g, XML, Java, Flat files, Visio, JCL, AutoSys.

DelMonte Foods 03/10 – 08/10

Pittsburgh, PA

Sr.Informatica/MetaData Manager Consultant

Environment: Windows XP, HP UNIX, Oracle 10G, Informatica PowerCenter 8.6, PowerExchange for DB2,Informatica MetaData Manager 8.6,Custom configurator, Oracle PL/SQL, TOAD 9.7.2, Informatica Data Explorer

Dell 08/09 – 02/10

Round Rocks, TX

Sr. Informatica/MetaData Manager Developer

Environment: Windows XP, Informatica 8.6, Informatica Meta Data Manager 8.6, Data Analyzer, Oracle 10g, Troux architect 8.0, Informatica Custom Configuration, Erwin Data Modeler.

Mutual of Omaha 11/06 – 08/08

Omaha, NE

Datawarehouse consultant

Environment: AIX Version 5.3, Windows XP, Informatica 8.1.1/8.6, DB2/UDB, Unix Shell scripting (Ksh), Rapid SQL 7.5.5, Oracle, Business Objects, Erwin Data modeler, Control M, JAVA

Selective Insurance Company of America 12/05 – 11/06

New Jersey

Informatica/Cognos Consultant

Environment: Windows XP, Informatica POWERCENTER 8.1.1 Microsoft SQL Server 2000/2005, SSIS/SSRS, Oracle 9i/10g, PL/SQL, Cognos 8 (Framework Manager, Report Studio, Analysis Studio), DB2, Zena, Altova -XML spy, Visio, Zena scheduling tool

EDUCATION:

Masters in Computer Applications, (2005)

Bachelor’s Degree in Computer Sciences, (2002)

Contact this candidate