Resume

Sign in

Data Developer

Location:
Troy, Michigan, United States
Posted:
November 05, 2018

Contact this candidate

Resume:

Ponni Ranganathan

Contact:586-***-****

City: Troy MI

Email:ac7l1v@r.postjobfree.com

●Over 13+ years of professional experience in Data Warehousing working as a Data Warehouse Architect, ETL Developer and Technical Lead.

●Extensive experience in Data Modeling techniques to develop Dimensional Data models, Star Schema/Snow flake schemas, FACT & Dimensions tables for realization into Conceptual/logical & Physical data models

●Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.

●Highly experienced in Business Requirement Analysis, Application Design, Dimensional Data Modeling, Development, Coding, and Testing.

●Experienced in implementation of business applications with Oracle/DB2/Teradata, Data Warehouse/Data Mart ETL/MDM using Informatica Power Center 10.2/9.6/9.5/8.6/7.1.3 (Workflow Manager, Workflow Monitor, Warehouse Designer, Source analyzer, Repository Manager, Target Analyzer, Mapplet Designer, Mapping Designer). Data Stage 8.6 and SAP Info Business Object

●Domain experience includes Banking, Healthcare & Automotive.

●Experienced in designing and building a DataLake using Hadoop and its ecosystem components.

●In depth understanding/knowledge of Hadoop Architecture and its components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and MapReduce.

●Big data Architect trained by VW.com

●Business Analysis for conceptual models

●Requirement/design analysis for building logical/physical data models

●Root cause analysis for problem resolution during application testing and in production

●Overall architectural analysis

●Code Review

●Create BSR and get business approval to start the codingExperience in administering Informatica server activities (creating folder, user, scheduling, and managing sessions).

●Experienced in modeling VLDB (Very large databases)

●Expertise in Query Analysis and performance tuning of Informatica mappings and testing.

●Extensive programming experience using PL/SQL & SQL in Oracle/DB2.

●Worked extensively on Optimization and Tuning to increase Query and Database performance by reviewing the projects as belong to AMS Team.

●Experience in coding UNIX shell scripts to support and automate ETL processes.

●Working on MDM technology as SME, ETL, BO Architect and Senior Developer

●Good Data Stage and Business Intelligence process.

●Working on Data Lake Method in data lake project.

●Solid Understanding of Ralph Kimball Data Warehouse methodologies

●Good Knowledge in Hadoop and Big data

●Worked in DIH ( Data Integration Hub)

●Excellent team player and works efficiently in cross-disciplinary projects.

●Excellent written and verbal communication skills

●Worked on DIH (Data Integration Hup)

Education:

Master of Computer Science Madras University, Chennai, India

Bachelors of Business Administration – Madras University,Chennai, India

Technical Certification:

Certified Informatica 7.1 Designer

Certified Informatica 7.1 Administrator

Professional Experience:

BCBSM(Through interpro),Detroit, MI (Contract) November 2017 – Sep 2018

ETL Architect,SME & Sr.Developer

SME for multiple projects in DWH and reporting side.

Expertise in Data issue resolution, debugging and application performance tuning

Defined extract - translate-load (ETL) and extract-load-translate (ELT) processes for the Data Lake.

Design and developed shell scripting to automate the job

Environment:

MDM and DWH environment used informatica, Java, Business Object, Oracle, Unix

Volkswagen Group of America – Auburn Hills, MI (Contract) December 2012 – March 2017

ETL Architect,SME & Sr.Developer

●Involved in the Data model design while gathering the requirements.

●Performed high level data model design and modifications.

●Participated in ETL and SAP Info Business Object Design and reviewed the design document for approval.

●Reviewed code and suggested review comments to be fixed by the development team.

●Involved in the meetings with managers and architects for upcoming new projects.

●One week a month performed on call support, during on call time whatever job fails need to be taken care of and fixed immediately. (DWH and MDM projects)

●Involved in informatica, Business object, Java and PERL script code reviews.

●Created new projects and permission to new user’s tasks that must be performed. (for informatica, business object and Unix directory creation in prod and QA)

●Onsite-offshore co-ordination, helped developers complete the task technically on time.

●Participated as Technical lead and ETL, BO Architect in many projects

● SME for multiple projects in DWH and BO.

Environment:

MDM and DWH environment used informatica, Java, Business Object, Oracle, Unix

CITI Group, New Jersey (Contract) September 2012 to December 2012

Data Warehouse Architect

●SME for the applications in Ecif (Enterprise Citi finance) project.

●Worked with Business Analyst and other project staff, plan for delivery of requirements for the module.

●Monitored issues and task tracking system and responded to the need of additional information and worked on fixing issues by modifying code when my expertise was required.

●Attended weekly meeting for module with Clients - Prepares for meetings by reviewing documents in advance and creating lists of issues and comments to contributed to the meeting.

Development:

●Gathered the requirement by preparing the ‘Business requirement Document’ and get approval for the same.

●Created a schedule for the project life cycle.

●Provided estimations.

●Designed and implemented the Database.

●Involved to get the Design document, review the same and sign off.

●Reviewed the code

●System testing and IT Acceptance

●Performed data analysis and loaded data for test

●Scheduled UAT Plans to business Users, get UAT and Sign off.

General SME Roles:

●Worked with Business Analyst and other project staff, planned for delivery of requirements for the module.

●Monitored issue and task tracking system and responded to the need of additional information.

●Attended weekly meeting for module with Clients - Prepares for meetings by reviewing documents in advance and creating lists of issues and comments to contribute to the meeting.

Support Activities:

●Monitored Tickets Created in TTTS

●Involved with the support team and resolved the ticket

●Discussed with Business users (QEC Specialist, Business Users and Application Users) and identified the issues and closing the ticket.

Business Suggestions:

●Suggested the business team for better improvement in application

●A single Point of Contact for all the Ecif

Maternity Leave August 2010 – July 2012

Caremark Dallas, TX May 2008 – July 2010

Technical Leader

Caremark is a one of top most leading pharmacy company. Caremark provides health insurance in low cost by providing the best solution through the Caremark sites. People can find a best drug in the low cost through Caremark site and Caremark provides the health insurance for the people.

●Involved with the business partners and offshore for developing the System.

●Responsible for Migration

●Responsible for IT /UAT Testing

●Analyzed and prepared the functional design document and the Technical design document

●Guided the offshore team to prepare the technical manual

●Guided the team to create mapping and workflow.

●Performed Unit testing, Integration and System Testing

●Created error reports

●Helped offshore team to create tables in the local database for the staging area and create the staging table in the database.

●Installed and ran the objects in UAT environment

●Checked the adapter and server statuses on the Unix environment

●Checked the validation object and validate all the mapping and session through shell script.

●Optimized Mapping

Environment: Informatica 8.6, Cognos, Unix

GE HealthCare Milwaukee, WI (Contract) September 2005 – April 2008

Data Architect

●Responsible for understanding and review the requirements from on-site architects and end-users

●Created the High Level and the Low-Level Design Documents (HLD and LLD). Tasks included:

oPrepared cronacle documents to run the job in redwood monitoring tool

oPrepared Traceability Matrix

oPrepared Teradata capacity plan for the project

oCreated a System Specification Requirement document and System Requirement Development Specification document.

oCreated the ETL specification, to help with the mapping with the logic.

●Created the Unit Test case script.

●Developed ETL mapping, session, Workflow and Bteq Script to fulfill the requirement from the ETL Specification to help understand and complete the ETL specifications.

●Created the cronacle job chain for the entire project to execute the project in UAT and Prod.

●Created all the necessary documentation and request for appropriate approvals for the production migration.

HCL Technologies (DSL Software) August 04 – September 05

(Client - Dauche Bank, USA, UK, Frankfurt, Singapore, and Australia)

Project: DBFeeds

●Analyzed the functional design document and prepare the Technical Design document

●Prepared the technical manual for E+, IDMS, ADP, IDTS, Pershing and Collector interface

●Created mapping and workflow for collector interface

●Performed Unit testing, Integration and System Testing

●Created error reports.

●Created tables in the local database for the stage environment

●Production support for E+, IDMS interfaces

●Checked the adapter status on the Unix environment

●Checked the server status on the Unix environment

●Checked the validation object and validate all the mapping and session through shell script.

●Optimized Mapping

●Wrote shell script to schedule, run, resume workflow through PMCMD utility

Softech December 02 – July 04

(Client - ASM – Bangalore India)

Project: GMROI

Database Developer

●Performed requirements analysis and prepared Design Document

●Developed Construction after the design review

●Used Parameter File to change Customer Type easily via end-user request

●Involved in optimizing mappings

●Monitored Production system

●Modified Source Definition to reflect data warehouse and Sales data mart

●Created Sessions

●Performed Incremental, and Full Refresh load

●Loaded data from production to development to Generate Test Data

●Written Unit Test cases

●Defect Fixing for Development Issues

●Wrote Implementation Plan to deploy mapping into production

Environment: Informatica 6.1, Cognos, UNIX, Unix Shell Scripting, PL/SQL, DB2



Contact this candidate