Uploaded File
add photo
Rajesh Kumar
rajesh86smile@gmail.com
201-744-0155
New York City, NY 10002
Senior Lead Informatica Developer
12 years experience C2C
1
Recommendation
Average rating
130
Profile views
Summary

  • Over 8 years of extensive IT experience in Capital markets, Investment Banking, Insurance, Retail and healthcare domains which helped me to groom as a Data warehouse specialist, by performing SDLC process right from requirement gathering, analysis, design, development, testing, deployment, and Maintenance for various software applications.
  • Hands on experience in ETL design, development of SQL Scripts, Stored Procedures, Functions, Packages, Triggers and maintenance using Oracle PL/SQL, DB2 SQL, Informatica Power Center 9.x/8.x/7.x on UNIX and Windows platforms.
  • Expertise in Data Analysis, Data Requirement Analysis, Data Mapping, Data Warehousing, Data Migration, Data Integration for ETL processes using Business Intelligence (BI) tools such as Informatica Power Center, Power Exchange Change Data Capture, B2B Data Transformation, Informatica Data Quality, Informatica Data Explorer, MDM etc.,
  • Extensive knowledge of various Performance Tuning Techniques on various source systems such as Relational Sources, Flat files, XML, Mainframe COBOL and VSAM files, SAP Sources/Targets, web based applications in Java using Servlets, JSPs and Web Services etc.., Informatica Mappings, Sessions, and Data Base Tuning.
  • Proficient in defining and documenting ETL Process Flow, Job Execution Sequence, Job Scheduling and Alerting Mechanisms using command line utilities, integration mappings including dynamic cache lookup, shared, and persistent cache for mappings of Type I, Type II, and Type III Slowly Changing Dimensions and implementing update strategies, incremental loads, and change data capture.
  • Strong knowledge of various Data Modeling techniques such as E-R modeling, and Dimensional modeling (Star/SnowflakeSchema) and in implementing Error Handling, Auditing and Reconciliation and Balancing Mechanisms in ETL process.
  • Committed individual with excellent interpersonal, analytical and communication skills.
  • Ability to work simultaneously on multiple projects, work independently as well as a team member.

Experience
Senior Lead Informatica Developer
Information Technology
Aug 2016 - present
  • The Visiting Nurse Service of New York is the largest not-for-profit home and community-based healthcare organization in the United States, serving the five boroughs of New York City, as well as Nassau, Suffolk, and Westchester Counties. Data Architecture Services(DAS) in VNSNY is mainly responsible of storing and maintaining the history data of the entire organization and serves as a data mart for the ops community.
  • This DAS application has SAS, mainframe to communicate with all the upstream systems, Informatica Power Center 9.5 to process the feeds and host data mart and Analytical platform for Business Intelligence.
  • Responsibilities:
  • Lead the project CHOICE Analytical Data mart for building the data mart for the members of CHOICE and their enrolment and eligibility and delivered them without any defects in a very short time span.
  • Overall responsibility in Research, evaluate and synthesize technical information to develop application and build services for the CHOICE business.
  • Interacting with operation users, various application teams and Business analysts to find a better approach for proposed solutions and preparing data modelling and design data dictionary, Entity Relation Diagrams, High Level & Low Level design documents in MS Visio and to evaluate the performance and reliability of designs.
  • Analyse and create mapping documents to map the processed feed to table columns.
  • Design all the Meta data required for processing the feeds. Develop jobs to process the feeds, create the load ready files and develop the scheduling frame work to automate the load using CONTROL-M
  • Track and consolidate the business requirements from customers using BRD for eliciting better quality requirements.
  • Tracking the schedule of BRD, FRD and Technical design documents using Blueprint tool for defining governance structure and planning and budgetary estimates, to minimize the risk of failure and improve the business value.
  • Perform code review in regular basis to ensure team is following coding guidelines and tracking them. It provides application insight & quality measurements to various stake holders.
  • Attend user queries, issues and batch failures using On call weekly batch support.
  • Perform root cause analysis and Defect Prevention activities for P1/P2, Sev-1,2 bugs raised in UAT/SIT stage
Metadata Informatica Business Analysis Business Requirements Data Marts Informatica Powercenter Data Architecture Informatica Developer Data Modeling Business Intelligence BRD Data Dictionary FRD
Remove Skill
Senior Data warehouse Developer
Information Technology
Aug 2014 - Aug 2016

  • PWM brokerage data mart is a business intelligence platform which integrates with different source systems to host the brokerage business data of different line of businesses and generating feeds to various business line Analytics, Finance, Compliance, Subledger and Legal group etc. and downstream system’s based on their need. In addition to this, it also hosts business objects based analytical platform for all the analytical needs of PWM user community.
  • This application has mainframe components to communicate with all the upstream systems, Ab-Initio to process the feeds and host the data mart and Analytical platform for Business Intelligence.
  • Responsibilities:
  • Lead the project technically at Onshore which comprises a team of members (3 programmer analyst, 4 software developers, 4 QA and 3 trainees)
  • Overall responsibility in Research, evaluate and synthesize technical information to develop application and build services for the private wealth management – Brokerage services and accounting subledger services.
  • Interacting with operation users, various application teams and Business analysts to find a better approach for proposed solutions and preparing data modelling and design data dictionary, Entity Relation Diagrams, High Level & Low Level design documents in MS Visio and to evaluate the performance and reliability of designs.
  • Analyse and create mapping documents to map the processed feed to table columns.
  • Design all the Meta data required for processing the feeds. Develop jobs to process the feeds, create the load ready files and develop the scheduling frame work to automate the load.
  • Analysing and verification of the large complex software, programs, batch jobs to increase the robustness, reliability and correctness of the application
  • Track and consolidate the business requirements from customers using BRD for eliciting better quality requirements.
  • Capture and document Trades Processing and General Ledger functional requirements for legacy applications through reverse engineering. The tools helps to abstract business functionality, understand functional behaviour, create data-flow rules, analyse the application source code, and extract application structure and program flow.
  • Preparing the effort estimations for development tasks for the new enhancements and migration related activities
  • Tracking the schedule of BRD, FRD and Technical design documents using Blueprint tool for defining governance structure and planning and budgetary estimates, to minimize the risk of failure and improve the business value.
  • Perform code review in regular basis to ensure team is following coding guidelines and tracking them. It provides application insight & quality measurements to various stake holders.
  • Attend user queries, issues and batch failures using CCM – Customer Call Management.
  • Reviews Traceability matrix, SIT Test Plan, Test Cases for each release and shares the Test Progress Report with all the stake holders
  • Performing root cause analysis and Defect Prevention activities for P1/P2, Sev-1,2 bugs raised in UAT/SIT stage
  • Groom new junior associates and trainees in the team by conducting knowledge sharing sessions
  • Environment: Ab-initio, SQL, PL/SQL, SQL Server 2008/2014, Windows NT/2003, DB2, Autosys, Oracle 11g.
SQL Metadata Business Objects Business Analysis Business Requirements Data Marts Data Modeling Data Warehousing DB2 SQL Server Oracle PL/SQL Business Intelligence BRD Compliance Data Dictionary FRD Windows
Remove Skill
References
Average Rating

1 recommendation
Sr. Informatica Developer
Information Technology
Apr 2013 - Jul 2014
  • LTC (Long term care) Inforce team in Transamerica, deals with the policies issued for Long term life care products. These are the health policies that helps the customer by providing living assistant during their old age. It covers the expense for both Home assistant and nursing home assistant. It is responsible for capturing the changes from the various source systems and update the plans, benefits, products, calculates premium based on a pre-defined mapping.
  • Responsibilities:
  • Gathered requirements from Business users and created a Low level technical design documents using high level design document.
  • Participated in the Design Meetings, and prepared technical and mapping documentation.
  • Designed, Developed and Supported Extraction Transformation and Load (ETL) Processes using Informatica Power Center 9.5 for data migration from source systems into Data warehouse.
  • Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
  • Worked on configuring the Java class path in the session properties while using third-party Java packages, built-in Java packages, and custom Java packages in a Java transformation and also in Java SDK Custom transformation.
  • Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
  • Used Analyst and Developer tool to create and rules, profiles and mapplets for profiling standardizing source data.
  • Debugged mappings to gain troubleshooting information about data and error conditions using Informatica Debugger
  • Performance tuned the Mappings, Tasks, Sessions, SQL and Scripts to optimize Data-Load performance.
  • Worked in highly structured division across Infra developers/Data Architects (data modelling team)/DBAs/ Change Management etc.
  • Conformed to project standards for Unit test/UAT testing. Carried out end – to end testing and supported UAT effort with immediate requirement document change/fixes/resolution for all changes/defects.
  • Environment: Informatica Power Center 9.5, Informatica Analyst, IDE, Java, Oracle 11g, MS SQL Server 2008/2012, Windows 7, Java .
SQL Informatica SQL Server Oracle Informatica Powercenter Data Migration Data Architecture Informatica Developer Java Data Warehousing Windows
Remove Skill
Data Warehouse Developer
Information Technology
Jan 2012 - Jan 2013
  • Target technology services (TTS) implement smart technology for a better guest experience. Develop systems and applications for Target Stores, Point of Service (POS), Target Financial Services (TFS), and Development and Marketing Technologies. Target data repository team is responsible for retrieving merchandise and inventory files from various sources like mainframe system, UNIX, creating procedures and updating Oracle tables.
  • Responsibilities:
  • Interacted with business people for Need Analysis and to define Business and Functional Specifications.
  • Worked on all phases of the development lifecycle supporting data integration and enterprise data warehouse efforts.
  • Participated in the Design team and user requirement gathering meetings, and prepared technical and mapping documentation.
  • Design, implementation and maintenance of data integration, ad-hoc SQL Server based reporting and BI solutions used to provide key metrics to business leaders in a fast-paced market.
  • Worked on Power Center client tools like Source Analyser, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
  • Imported data from various Sources transformed and loaded into Data Warehouse Targets using Informatica.
  • Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
  • Optimizing Query Performance, Session Performance.
  • Expertise in developing SCD mappings using Power Exchange change data capture.
  • Worked on IDQ tool which is used to identify data duplication, understand the quality of data and report generation and IDE tool for data profiling used for Data Analysis for Data migration.
  • Analysed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.
  • Environment: Informatica Power Center 8.5, Informatica Power Exchange Change Data Capture, Oracle 10g, SQL, PL/SQL, TOAD, SQL Server 2005, Windows NT/2003, UNIX, Autosys.
SQL Informatica TOAD Data Analysis Data Warehousing SQL Server Oracle Informatica Powercenter PL/SQL Data Integration Requirements Gathering Data Profiling IDQ UNIX Data Migration Windows
Remove Skill
Informatica (ETL) Developer
Information Technology
Jul 2011 - Mar 2012
  • The project VII (Vanguard Intelligent Investors) is to integrate client’s account/assets information from heterogeneous source systems and loading it into centralized data warehouse. The role demands working with Data Quality team to maintain their enterprise standards and also implemented Data Marts consisting of client stock options and shares information.
  • Responsibilities:
  • Interacted with the Functional Analysts to understand the process flow and the business.
  • Involved in gathering the business requirements from Business Analyst.
  • Analysing Source to Target mapping Excel document.
  • Coordinating the team and assigning dependencies tasks to team.
  • Created Data Flow Mappings to extract data from source system and Loading to staging area.
  • Analysed the AR data and developed the code to extract the data for the AR module and implemented in the Informatica.
  • Extensively worked on Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
  • Worked on various tasks like Session, E-Mail task and Command task.
  • Used Mapplet, parameters and variables in mappings as per the requirement.
  • Used Informatica Data Quality for data quality, integration and profiling.
  • Worked on Informatica Scheduler for scheduling the delta loads and master loads.
  • Involved in performance tuning of the process at mapping, session, source level and at target level.
  • Involved in testing by using Informatica workflow manager and monitor, etc. and extensive testing on log files to detect errors.
  • Tested different data load databases by comparing source and target table counts and tested Informatica data loads from database to database.
  • Environment: Informatica Power Center 8.1, Oracle 11g, SQL Server 2005/2008,
  • IBM DB2, Teradata, PL/SQL, SQL Developer, Windows XP, Sybase, Java
SQL Informatica Business Requirements Data Marts Data Warehousing DB2 SQL Server Oracle Informatica Powercenter PL/SQL SQL Developer Teradata Java Project Management Business Analysis Windows
Remove Skill
Developer
Information Technology
Jan 2009 - Jun 2011
  • Citigroup Inc. or Citi is an American multinational investment banking and financial services corporation headquartered in Manhattan, New York City. Citi Branded Cards is one of the world's largest credit card issuers. Automated Collection System (ACS) team is responsible for maintaining data of delinquent customer accounts in their data warehouse. Offers arrangements for eligible delinquent accounts on a timely basis and address needs of the customers. Collections team handles the Delinquent customers. The system queues the accounts to dialler team (collectors) to follow up with them and collect the money back and also it maintains the special offer (arrangement) eligibility and its details, and Recovery management system and payment and interest details. It act as the core database for delinquent customers.
  • Responsibilities:
  • Analysis and Feasibility Study of User Requirements and discussing with end users to understand their business scenarios
  • Preparing functional requirements and converting them to BRD/SRS and discussing the software solution prototype to clients
  • Tracking and coordinating with different business teams for identifying and closing the gaps on the process front
  • Identifying and Verifying whether the proposed solution meets the customer requirements
  • Development of software UI and business logic components and computer programs in mainframe without impacting the existing functionalities
  • Development activities for user requested console components, macros, Batch Jobs, NDM Scripts for file transfer to other application within and outside CITI.
  • UAT and Production Support. Given immediate solutions/workarounds for continuity of business.
  • Performed root cause analysis for the bugs raised in Production environment, updating the same to my immediate supervisor and taken necessary corrective action to minimize them in future
  • Performing the sanity and functionality testing prior to moving the release to UAT
  • Prepare reports, manuals and other documentation on the status, operation and maintenance of software
  • Maintained the Base line code, document control and release control in share point for easy check-in check-out process
  • Environment: CHANGEMAN, Z/OS, MVS, Unix, IBM DB2, COBOL, JCL, REXX, VSAM Cobol sources, Oracle 10g , Sql Server 2005, Windows xp
SQL DB2 SQL Server Oracle UI UNIX Data Warehousing MS SharePoint Windows
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Electrical
Anna University, 2004 - 2008
Minor: Computer science
Skills
Windows
2016
7
Data Warehousing
2016
6
Oracle
2016
6
SQL
2016
6
SQL Server
2016
6
BRD
2021
5
Data Dictionary
2021
5
FRD
2021
5
Business Intelligence
2021
4
DB2
2016
4
Business Analysis
2021
3
Business Requirements
2021
3
Data Marts
2021
3
Data Modeling
2021
3
Informatica
2021
3
Informatica Powercenter
2021
3
PL/SQL
2016
3
UNIX
2013
3
Compliance
2016
2
Data Architecture
2021
2
Data Migration
2014
2
Informatica Developer
2021
2
Java
2014
2
Metadata
2021
2
MS SharePoint
2011
2
UI
2011
2
Business Objects
2016
1
Data Analysis
2013
1
Data Integration
2013
1
Data Profiling
2013
1
IDQ
2013
1
Project Management
2012
1
Requirements Gathering
2013
1
Teradata
2012
1
TOAD
2013
1
Auditing
0
1
Data Mapping
0
1
ETL
0
1
Java Servlet
0
1
Requirement Analysis
0
1
SAP
0
1
SDLC
0
1
SQL Developer
2012
1
Stored Procedure
0
1
Triggers
0
1
WebServices
0
1
XML
0
1
Languages
English, Fluent/Bilingual