Manager Data

Adityanadh Chalamalasetti 561-***-****

**********@*****.***

EXPERIENCE SUMMARY:

•Over 10 years of Industry Experience as a Data Warehousing Expert and ETL Developer in design, development, analysis and testing of business applications.

•Experience in ETL tool (Informatica) and Database (Oracle, Teradata, MS SQL Server databases) and scheduling tool (DAC, Control M, Autosys).

•Have clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.

•Experience in Data Warehouse development working with Data Migration, Data Conversion, and Extraction/Transformation/Loading using Informatica Power Center with Teradata, Oracle, SQL Server.

•Worked with various Power Center components like Informatica Server and Client tools like Designer, Workflow Manager, and Repository Manager & Workflow Monitor.

•Data integration with SFDC and Microsoft Dynamics CRM using Informatica cloud.

•Worked on Restful and SOAP API services. Processed SIF file to Informatica.

•Experience in using power center features n-way source partitioning, Recovery for concurrent sessions, version controlling of the ETL process.

•Experience in integration of various data sources like Oracle, SQL Server and Flat Files into the Staging Area.

•Worked with Oracle Stored Procedures, triggers, SQL queries, PL/SQL packages and loading data into Data Warehouse/Data Marts using Informatica.

•Strong experience with star and snowflake schema, dimensional data modeling, Fact and dimensional tables, slowly changing dimensions.

•Expertise in Informatica Performance tuning of the ETL process and SQL tuning.

•Extensive experience in designing the architecture for Extract, Transform, Load environment and development of mappings and process using Informatica Power Center.

•Experience in technical architecture, data modeling, proof of concept, requirement study, system analysis, testing and development of decision support systems.

•Used Command Line Utility like PMREP, PMCMD and PMLIC.

•Excellent communication skills, Good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.

Certification:

Power Center Data Integration 9.x: Developer, Specialist Certification.

Oracle Certified Associate (OCA) in Oracle11i.

Education:

B.Tech (Information Technology), JNTU University. (May 08).

Technical Skill Set:

ETL Tools

Informatica Power Center 8.1.x/8.6.x/9.0x,10.2, ODI 10.1.3.5

Databases

Teradata,Oracle 10g,11g SQL Server 2012, DB2 and MS-Access

Data Modeling Tools

ERWIN 4.1, VISIO.

Languages

C/C++, SQL, PL/SQL.

Scripting Languages

UNIX shell scripting, Power Shell.

Operating Systems

Windows,Sun Solaris, HP-UX,AIX,Linux

Methodologies

Data Modeling – Logical Physical / Dimensional, Star / Snowflake, Complete Software Development Life Cycle

Reporting Tools

OBIEE, MicroStrategy

PROFESIONAL EXPERIENCE:

Employer: Unify Solutions Inc Aug 2018 – Till Date

Designation: Sr. Software Engineer

IPC FL, USA

Project Description:

IPC is an independent Subway® franchisee-owned and operated purchasing cooperative. Subway works with Franchise World Headquarters LLC (FWH) to negotiate the lowest costs for purchased goods and services. The Datalake project at IPC is to extract the data from flat files, teradata and load into Teradata and SQL Server database.

Responsibilities:

•Interacted with the Business Analyst in collecting the technical and business requirements for the projects.

•Understandig the datamodel in designing and modeling of the database tables.

•Designed and developed ETL processes with Informatica Power Center and Teradata

•Wrote SQL, case and decode statements for implementing business rules and transformations.

•Worked with MDM to send the products information using SOAP request and get the response to process the data into teradata and validating the data in database after the products got mapped by data stewards.

•Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.

•Provide support for all the applications that were running daily into Production environment.

•Involved in performance tuning of the ETL process.

•Extensively involved in Fine-tuning the Informatica Code (mappings and Sessions), SQL to obtain optimal performance and throughput.

•Responsible for using the capabilities of Power Center, pmcmd, pmrep, Target override, Connected and Unconnected lookup, Persistence lookup, Dynamic & Static lookup in implementing in various user requirements.

•Expertise in using the mapping parameters and variables.

•Executed Pre and Post session commands on Source and Target database using SQL and Scripting.

•Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.

•Worked with Various transformations like Source Qualifier, Filter, Router, Update strategy, Sequence Generator, Stored Procedure and more.

•Worked with various tasks like Command, Email, Timer, Session and Decision tasks.

•Used mapping parameters, session parameters, and workflow variables.

•Preparing various documents like Technical design documents, Migration document, and Explain Plan and Unit Test plan.

•Responsible for migration of code from Dev-->QA--> Production instances using Git hub, Bamboo and Octopus.

•Creating deployment and backup scripts for the ETL deployments.

Monitoring the Incremental loading performs on Stryker business days and sending the notification emails to the users for data validation.

Environment: Informatica Power center 10.2, Teradata, MDM, SQL Server, Powershell scripting, Microsoft Azure, Microstrategy.

Employer: Unify Solutions Inc Mar 2016 – Sep 2018

Designation: Computer System Analyst

Stryker CA, USA

Project Description:

Stryker Endo is a global leader in medical technology and their business is operated form San Jose that involves purchasing, Manufacturing, Shipping, Complete E Business Suite. The Datawarehouse project at Stryker is to pull data from Stryker pulse to a centralized Datawarehouse. The Source system is Oracle Apps and data warehouse is Oracle 12g. Informatica powercentre 9.6 used to extract, transform and load the data in to the warehouse.

Responsibilities:

•Interacted with the Business Analyst in collecting the technical and business requirements for the project.

•Assisted the Data Architect in designing and modeling of the database.

•Designed and developed ETL processes with Informatica Power Center and Oracle.

•Wrote SQL, PL/SQL, Stored Procedures, Triggers and Cursors for implementing business rules and transformations.

•Worked on Informatica Data Quality (IDQ) toolkit, Analysis, Data Cleansing, Data matching, Data Conversion, exception handling, reporting and monitoring capabilities of IDQ.

•Extracted the raw data from Sales force to staging tables using Informatica Cloud.

•Created Filewatcher jobs to setup the dependency between Cloud and PowerCenter jobs.

•Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.

•Provide support for 250 Informatica workflows/mappings (developed using Informatica 9.1 and Informatica 9.5.1) which are running daily into Production environment.

•Created Mappings for loading the data into Oracle, flat files, DB2 and SQL server data received from various divisions in to the Data warehouse on daily and Monthly basis.

•Involved in analysis of data in various modules of the project.

•Involved in performance tuning of the ETL process.

•Extensively involved in Fine-tuning the Informatica Code (mappings and Sessions), SQL to obtain optimal performance and throughput.

•Responsible for using the capabilities of Power Center List files, pmcmd, pmrep, Target override, Connected and Unconnected lookup, Persistence lookup, Dynamic & Static lookup in implementing in various user requirements.

•Expertise in using the mapping parameters and variables.

•Executed Pre and Post session commands on Source and Target database using Shell scripting.

•Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.

•Worked with Various transformations like Source Qualifier, Filter, Router, Update strategy, Sequence Generator, Stored Procedure and more.

•Worked with various tasks like Command, Email, Timer, Session and Decision tasks.

•Used mapping parameters, session parameters, and workflow variables.

•Preparing various documents like Technical specification design documents, Technical design documents, Migration document, and Explain Plan and Unit Test plan.

•Responsible for migration of code from Dev-->QA--> Production instances.

•Taking backups, the contents of Informatica repositories and DAC Metadata and restoring the backup contents into the various instances like DEV and QA instances.

•Monitoring the Incremental loading performs on Stryker business days and sending the notification emails to the users for data validation.

Environment: Informatica Power center 9.6.1, Informatica Cloud, Oracle 11g, Oracle EBS R12.0.0, Server2012, DB2 on iSeries, DAC (7.9.5 Version), Winscp, CVS (Sub version), Service now, AIX (6.1) and OBIEE.

Employer: M3bi Nov 2014 – Feb 2016

Designation: Senior Software Engineer

American Express Basal (DWH) Phoenix, USA

Project Description:

The Amex is an multinational financial service corporation headquartered in Manhattan’s Three World Financial Center in Newyork City, United States. The company is best known for its credit card, charge card and traveler’s cheque businesses. The Datawarehouse project at Amex is to pull data from Amex pulse to a centralized Datawarehouse. The Source system is Oracle Apps and Datawarehouse is Oracle 11g . Informatica powercentre 9.1.0 used to extract, transform and load the data in to the warehouse.

Responsibilities:

.

•Interacted with the Business Analyst in collecting the technical and business requirements for the project.

•Assisted the Data Architect in designing and modeling of the database.

•Designed and developed ETL processes with Informatica Power Center and Oracle.

•Wrote SQL, PL/SQL, Stored Procedures, Triggers and Cursors for implementing business rules and transformations.

•Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.

•Created Mappings for loading the data into Oracle, flat files, DB2 and SQL server data received from various divisions in to the Data warehouse on daily and Monthly basis.

•Involved in analysis of data in various modules of the project.

•Involved in performance tuning of the ETL process.

•Extensively involved in Fine tuning the Informatica Code (mappings and Sessions), SQL to obtain optimal performance and throughput.

•Responsible for using the capabilities of Power Center List files, pmcmd, pmrep, Target override, Connected and Unconnected look up, Persistence lookup, Dynamic & Static lookup in implementing in various user requirements.

•Expertise in using the mapping parameters and variables.

•Executed Pre and Post session commands on Source and Target database using Shell scripting.

•Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.

•Worked with Various transformations like Source Qualifier, Filter, Router, Update strategy, Sequence Generator, Stored Procedure and more.

•Worked with various tasks like Command, Email, Timer, Session and Decision tasks.

•Used mapping parameters and session parameters and workflow variables.

•Preparing various documents like Technical specification design documents, Technical design documents, Migration document, Explain Plan and Unit Test plan.

•Involved in Unit testing as part of ETL Designing process.

•Worked on Control M tool in Scheduling the jobs.

•Monitoring the EPR runs on Amex business days and sending the notification emails to the users for data validation.

Environment: Informatica 9.1.0, Oracle 11g, Oracle EBS, SQL Server2005, DB2, Control M, Winscp, CVS(Sub version), ServiceNow, AIX(6.1) and MicroStrategy.

Employer: Global Logic Technologies May 2010 – Nov 2014

Designation: Software Development Engineer

Stryker Endoscopy (DWH) CA, USA

Project Description:

Stryker Endo is a global leader in medical technology and their business is operated form San Jose which involves purchasing, Manufacturing, Shipping, Complete E Business Suite. The Datawarehouse project at Stryker is to pull data from Stryker pulse to a centralized Datawarehouse. The Source system is Oracle Apps and datawarehouse is Oracle 10g . Informatica powercentre 8.6 used to extract, transform and load the data in to the warehouse.

Responsibilities:

.

•Interacted with the Business Analyst in collecting the technical and business requirements for the project.

•Assisted the Data Architect in designing and modeling of the database.

•Designed and developed ETL processes with Informatica Power Center and Oracle.

•Wrote SQL, PL/SQL, Stored Procedures, Triggers and Cursors for implementing business rules and transformations.

•Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.

•Created Mappings for loading the data into Oracle, flat files, DB2 and SQL server data received from various divisions in to the Data warehouse on daily and Monthly basis.

•Involved in analysis of data in various modules of the project.

•Involved in performance tuning of the ETL process.

•Extensively involved in Fine tuning the Informatica Code (mappings and Sessions), SQL to obtain optimal performance and throughput.

•Responsible for using the capabilities of Power Center List files, pmcmd, pmrep, Target override, Connected and Unconnected look up, Persistence lookup, Dynamic & Static lookup in implementing in various user requirements.

•Expertise in using the mapping parameters and variables.

•Executed Pre and Post session commands on Source and Target database using Shell scripting.

•Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.

•Worked with Various transformations like Source Qualifier, Filter, Router, Update strategy, Sequence Generator, Stored Procedure and more.

•Worked with various tasks like Command, Email, Timer, Session and Decision tasks.

•Used mapping parameters and session parameters and workflow variables.

•Preparing various documents like Technical specification design documents, Technical design documents, Migration document, Explain Plan and Unit Test plan.

•Involved in Unit testing as part of ETL Designing process.

•Monitoring the Incremental loading performs on Stryker business days and sending the notification emails to the users for data validation.

Environment: Informatica 8.6(Hotfix4)., Oracle 10g, Oracle EBS, Server2005, DB2, DAC(7.9.5 Version), Winscp, CVS(Sub version), ITSM,AIX(6.1) and OBIEE.

Employer: Greenko Energies Pvt. Ltd. Aug 2009 – Feb 2010

Designation: Informatica Developer

Greenko Energies (DWH) Hyderabad, INDIA

Project Description:

The Greenko Energies is the power production firm located in Hyderabad, India. The Data warehouse project at Greenko is to pull data from different divisions of Greenko to a centralized Data warehouse. The Source system is SQL server 2005, Flat file and data warehouse is Oracle 10g on Windows NT. Informatica power centre 7.1.4 SP4 used to extract, transform and load the data in to the warehouse.

Responsibilities:

•Interacted with the users in collecting the business requirements.

•Worked on Informatica Client tools Source Power Center designer, Workflow Manager, Monitor and Repository Manager.

•Created Mappings for loading the data into Oracle, flat files, DB2 and SQL server data received from various divisions in to the Data warehouse on daily and Monthly basis.

•Involved in analysis of data in various modules of the project.

•Involved in performance tuning of the ETL process

•Extensively involved in Fine tuning the Informatica Code (mappings and Sessions), SQL to obtain optimal performance and throughput.

•Worked with Various transformations like Source Qualifier, Filter, Router, Update strategy, Sequence Generator, Stored Procedure and more.

•Worked with various tasks like Command, Email, Timer, Session and Decision tasks.

•Used mapping parameters and session parameters and workflow variables.

•Involved in ETL design and development using the Informatica Best Practices

•Responsible for migration of code from Dev-->QA-->Prod

•Responsible for UNIT, System and Integration testing. Developed Test scripts, Test plan and Test Data. Participated in UAT (User Acceptance Testing).

•Preparing various documents like Technical specification design documents, Technical design documents, Migration document, Explain Plan and Unit Test plan.

•Involved in Unit testing as part of ETL Designing process.

•Monitoring the Incremental loading performs on Greenko business days and sending the notification emails to the users for data validation.

Environment: Informatica Power Center 7.1.4, Business Objects 5.1, Erwin 4.1, Oracle 10g, DB2 Maestro, and UNIX

References: Furnished upon request.

Contact this candidate