Project Experience: Project #1:  SSC Foundation, SSC Campus, Navigate & Higher ED-Spend

 Organization: Education Advisory Board

Role:  Lead ETL Developer

Duration: Jan 2017 – Till Date

Description:

           The Student Success Management System(SSMS) is an enterprise-level technology that links administrators, advisors, deans, faculty, other staff and students in a coordinated care network designed to help schools proactively manage student success and deliver a return on education for 450+ colleges and universities across United States. We create a customized, predictive model so you can identify at-risk students and isolate systemic barriers to degree completion. With a cross-campus referral system and real-time student engagement data, EAB's student success management system, Campus, enables personalized care pathways and closed-loop support recommendations.

Activities:

Project Management :

·         Monitoring project progress as per scheduled deadlines for various tasks and taking necessary steps to ensure completion within time, cost and effort parameters.

·         Delivering products /services /solutions within constraints (schedule, features / functionality, and budget) & ensuring quality execution in the delivery of a product/service/solution to drive satisfaction.

·         Managing the project taking into account integration across all areas & engaging with stakeholders, developing Project Plan, Direct project resources as well as monitoring and managing project schedules, budgets and risk.

·         Defining Operational goals for the team and setting individual goals.

Role:  Senior ETL Developer

Duration: May 2015 – Dec 2016

Implementation and Support :

·         Involved in design, development and implementation of ETL Jobs. Also provided post production support activities.

·         Worked with users within EAB including application development teams, business analysts, and others for timely delivery of solutions.

·         Provided suggestions for process changes to make adoption and roll-out of features more rapidly

·         Managed pipeline of tickets and ensure on time delivery

·         Respond to system generated alerts/escalations relating to any failures on application platform.

·         Perform root cause analysis and identify and suggest corrective and preventive measures.

Role:  ETL Developer

Duration: Aug 2013 – Apr 2015

Project #2 : Special Assets Data Mart (SPA)

Client:  Branch Bank and Trusting(BB&T)

Organization:  Cognizant Technology Solutions, Chennai

·         Effectively manage multiple, competing priorities

·         Preparing documentation and training materials, present training to Tier 1 and Tier 2 support teams and to business analysts as may be required to ensure adoption of the capabilities.

·         Be available on call (on rotation) in a support role

Description:

       The main Objective of Special Assets Data Mart (SPA) project is to provide insight into operational efficiency of the Special Assets groups and provide decision support system to streamline the collections and recovery activities by reporting and analysis of data. To support the business needs the mart has been built with different source system entities and to calculate metrics and trends using the predefined reporting templates. Reporting tools also needs to be designed in such a manner to support ADHOC query request and analysis the executive dashboards and parameterized reports.

Roles and Responsibilities:

·         Examining the Requirements provided by the Clients and Preparing the Design Documents

·         Creating Mappings/Mapplets, Sessions, Workflows/Worklets and UNIX scripts for the corresponding mappings/workflows.

·         Optimizing the Mappings, Sessions, and Workflows to improve the load performance.

·         Preparing Unit Test Plan Document, Unit Testing Document, SIT Plan Document, System Integration Testing and confirming all requirements within a narrow deadline.

·         Review Informatica code developed by team and validate design standards and performance issues before send it for Client review.

·         Preparation of Migration checklist, ESP document and ESP testing.

·         Developing multiple process improvements and implementing them successfully.

Role: ETL Developer

Duration: July 2012 – Aug 2013

Project # 3: Data Hub Implementation

Client:  Branch Bank and Trusting(BB&T)

Organization:  Cognizant Technology Solutions, Chennai

Description:

           The HUB provides an efficient, cost-effective and flexible capability for building and operating data acquisition and integration applications.  The HUB architecture involves two major stages of data processing and management:

• Data Acquisition, which gathers data from multiple sources and makes it available at a single point—the Persistent Staging Area, or PSA
• Data Integration, which moves and transform data from the HUB to one or more highly integrated target database environments such as Banking Data Warehouse (BDW).

             The key objective of the HUB is to separate generic processing responsibilities from source-specific processing responsibilities for each HUB application. These generic processing responsibilities are made available for reuse by HUB application developers via the HUB platform, thus reducing the time and effort required to build new applications, and maximizing commonality between them.

Roles and Responsibilities:

• Examining the Requirements provided by the Clients and Preparing the Design Documents
• Creating Mappings/Mapplets, Sessions, Workflows/Worklets and UNIX scripts for the corresponding mappings/workflows.
• Optimizing the Mappings, Sessions, and Workflows to improve the load performance.
• Preparing Unit Test Plan Document, Unit Testing Document, SIT Plan Document, System Integration Testing and confirming all requirements within a narrow deadline.
• Review Informatica code developed by team and validate design standards and performance issues before send it for Client review.
• Preparation of Migration checklist, ESP document and ESP testing.
• Developing multiple process improvements and implementing them successfully.

Role: ETL Developer

Duration: Oct 2011 – June 2012

Project # 4: S&P Reporting ODC

Client:  Standard & Poor’s

Organization:  Cognizant Technology Solutions, Chennai

Role: Associate ETL Developer

Duration: Nov 2010 – Sep 2011

Description:    

Standard & Poor’s is one of the USA’s largest financial – market intelligence companies. Credit Rating suite of applications are used to monitor the status of various securities in the markets, analyze market information, assign credit ratings/outlooks and disseminate this information to S&P’s end users.

Roles and Responsibilities:

• Understanding the Client requirements
• Creating Mappings/Mapplets, Sessions, Workflows/Worklets and UNIX scripts for the corresponding mappings/workflows.
• Optimizing the Mappings, Sessions, and Workflows to improve the load performance.
• Preparing Unit Test Plan Document, Unit Testing Document, SIT Plan Document, System Integration Testing and confirming all requirements within a narrow deadline.
• Creating reports using BO tool and Enhancement of the existing report.
• Testing the reports

Strengths

Ø  Fast learner

Ø  Team player

Spoken Languages

ü  English (fluent)

ü  Tamil (native language)

Lead Informatica Developer

Skills

ü  Informatica

ü  Oracle 9i/10g/11g

ü  UNIX shell scripting

ü  Performance Tuning

ü  Automation

ü  Dimensional Modeling

ü  DB2

ü  ESP Scheduler

ü  Business Object XIR2

ü  Apache Hadoop

ü  HDFS, Hive

ü  MS Excel Chart & Pivots

ü  Project Management

ü  Requirement Analysis

Certifications

ü  S – Power Center 8 Mapping Design

ü  Level 0 : Banking & Financial Services – Cognizant Certified Professional

ü  Oracle 8i – SQL & PL/SQL – Cognizant Certified Professional

Awards – “Chennai Services Excellence Award 2016” for excellence in Leadership

Professional Summary:

7+ years of Informatica and Oracle experience in delivering ETL solutions for datawarehouse projects.

Skilled in planning, designing, developing and scheduling of ETL jobs. Performing UT, SIT, RCA & production support activities.

Experience in Banking & Financial, Healthcare and US Education Domains.

Having 1.5 years of Experience in Project Management and Team Leading.

Educational Qualification:

• 2010 – Bachelor of Engineering in Computer science,  Sri Ram Engineering College/Anna University,   Chennai , India 

Technical Expertise:

• Experience in Informatica 7x/8x/9x/10x.
• Experience in Oracle 9i/10g/11g and DB2.
• Working knowledge on UNIX shell scripting.
• Working knowledge of ESP Scheduling.
• Extensively worked in performance tuning of informatica sessions and SQL Queries by identifying and eliminating bottlenecks.
• Experience in working on Business Objects and IBM Cognos.
• Exposure to cutting-edge technologies such as Apache Hadoop, HDFS, Hive.

Non – Technical Expertise:

• Experience in Team Leading, Project and Supply Chain Management.
• Knowledge on Baldrige Excellence Framework.