Krishnapriya Kuchelan

Email : adliy3@r.postjobfree.com Mobile : +1-336-***-****

SUMMARY:

10+ years of IT experience in Analysis, Design, Development, Testing, Maintenance and Implementation of Complex data warehousing applications using Informatica Power center and Data Quality (IDQ).

Proficiency in developing SQL and PL/SQL with various relational databases like Oracle, SQL Server, Netezza

Knowledge in Full Life Cycle development of Data Warehousing.

Experience in configuring Informatica Power exchange CDC to achieve near real time data.

Ability to perform complex troubleshooting, root-cause analysis and solution development.

Experience in Data Quality Analysis, Data Profiling, Data cleansing and Master data management

Good domain understanding in healthcare, insurance and Banking.

Capability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

Involved in estimating the ETL developer’s effort based on the complexity of the mappings.

Coordinated with Project managers in laying down the project plan and tracking them to closure.

Proven ability to work efficiently in both independent collaborative environments with Excellent interpersonal and communication skills.

Excellent analysis, debugging and trouble-shooting skills, and persistence in problem solving.

Proficiency in understanding business process/requirements and translate them into technical requirement document.

Experience integrating OLTP source data and OLAP architecture

Strong experience in coding SQL queries to obtain maximum performance and tuning database parameters like indexes to improve performance.

Experienced agile team player implementing project using agile methodologies

Worked in different roles as Data analyst, Technical lead developer and Onsite / Offshore project lead in various business verticals including Banking, Insurance and Retail domains.

Experience in designing Test Plans, Test Cases, Test Scenarios, Test Scripts and Test reports of

Created various profiles using Informatica IDQ, from existing sources and shared those profiles with business analysts for their analysis on defining business strategies in terms of activities such as assigning matching scores for different criteria etc.

Implemented the various process controls for management change.

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables.

Committed team player with multitasking capabilities, excellent interpersonal and human relations skills.

CERTIFICATION:

AWS Certified Developer, Associate

TECHNICAL EXPERTISE

DW Tools:

Informatica Power Center 10.1, Data Quality(IDQ), Power Exchange

Databases:

Microsoft SQL Server 2005, Netezza, DB2,Oracle

Programming:

Phyton, Shell Scripting,Unix

AWS:

EC2, IAM, S3, VPC, RDS, Lambda, ELB,EBS,Route53,CloudWatch

Methodologies:

Star Schema, Snowflake Schema

Defect tracking:

HP QC (ALM 11.0), JIRA

Scheduling :

Autosys, Control-M

Languages:

SQL, PL/SQL, Stored Procedure

PROFESSIONAL EXPERIENCE

1.Fannie mae- Multi-Family Target State, Herndon VA

Role – ETL Informatica Lead (Sep 2018 to Present)

Project Description: Design and implementation of Data warehouse and Data mart for Multifamily target state to integrate all source systems(Credit Enhancement Servicing, Strategy Asset Servicing System, Committing and Delivery system, Structured facility management system, Negotiated transactions, Delegated Underwriting servicing and gateway, etc..) into warehouse. Build data mart for specific customers and vend out the appropriate data as XML format to consumers.

Responsibilities:

Participated in gathering and analysis of business requirements.

Conducted impact analysis for existing business processes.

Involved in the ETL technical design discussions and prepared ETL high level technical design document.

Involved in DW ETL development (Extraction Transformation and Loading) process that match the business requirements.

Creates data mart tables from data warehouse table.

Responsible for creating business rules at the target level using informatica data quality (IDQ).

Process XML files using Informatica B2B.

Extensively used Informatica Informatica Data Quality (IDQ) profiling capabilities to profile various sources, create and validate rules and provided data for business analysts for creating the rules.

Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.

Migrate the jobs using Jenkin tool. Creates AutoSys jobs using JIL program and schedule the informatica jobs using AutoSys scheduler.

Perform root cause analysis, defect fixing and documentation for any issues.

Use mapping Variables, Parameters, Workflow variables & parameter files to support change data capture (CDC) and automate workflow execution process to provide 24x7 available data processing units via Informatica power exchange tool.

Used informatica data quality (IDQ) for executing the business rules in the stage and target DW tables which are extracted for that period.

Provided assistance during UAT and implementation reviews.

Generate the PDF reports using python language with Report Lab library .

Create Autosys JIL files and Schedule Informatica workflows/sessions using Autosys.

Involved in Customer Data Integration (CDI)

Developing new Unix shell scripts for high level automation of data loading processes and archiving files

Developed Oracle PL/SQL Stored Procedures.

Environment: Informatica Power Center 10.1, Python, Power Exchange, IDQ, Oracle, Autosys,SQL Server, Jenkin, PL/SQL, Stored Procedure, Shell Scripting

2.BB&T-Customer Due Diligence Regulation Beneficial Ownership, Winston Salem, NC

ETL Informatica Lead (Jan 2017 to Sep2018)

Project Description: This project is to ensure that BB&T complies with a new Financial Crimes Enforcement Network (FinCEN) regulation, published on July 11, 2016, by May 11, 2018. A required 5th pillar is being added to the BSA/AML Program to clarify and strengthen Client Due Diligence requirements

1. Identify and verify the identity of the controlling person (CP) by performing Customer Identification Program (CIP) requirements: (i.e. collect Name, Address, Date of Birth, Taxpayer ID (SSN), NAICS, and verification of identity of CP)

2. Determine the beneficial Owner(s) (BO) of legal entity customer/clients by Performing CIP requirements and Collect the percentage of ownership for each BO

3. Capture a "certification" that the information provided is true and accurate from the individual who provides the information on CP and BO(s) - this will be a form filled out by the client

4. All data collected must be stored and maintained (includes paper certification documents)

Responsibilities:

Requirement gathering and Design ETL (Extraction Transformation and Loading) process that match the complex business requirements

Assisted in resolution of various Informatica issues and problems

Assisted major incident management with technical support as needed.

Reusable transformations and Mapplets are built wherever redundancy is needed

String search / String separation logic for dynamic changing values were implemented as reusable transformation.

Work with peers from various functional areas to define IT wide processes like code reviews, unit test documentation and knowledge sharing sessions.

As part of process improvements and Value Adds, Developed a dynamic mapping templates that can be used against multiple sources and targets during runtime. Have done the SQL-to-Mapping using Informatica developer that allows you to convert hidden hand-coded SQL queries to Informatica Mapping, making them maintainable, reusable, and transparent.

Extensively used Informatica Informatica Data Quality (IDQ) profiling capabilities to profile various sources and provided data for business analysts for creating the rules.

Expertise using IDQ Address Validator, Parser, Key Generator, Match Standardizer, Expression transformation .

Environment: Informatica Power Center 10.1, Netezza, IDQ,PL/SQL,CA workstation and UNIX, Mainframe

3. BB&T – Genesys, Winston Salem, NC

Role: ETL Developer (Dec 2016 to Jan 2017)

Project Description: Genesys Storing contact center data. Special Assets Business units rely upon reporting from Genesys call related data to measure the efficiency of BB&T associates involved in the collections process and to measure several other metrics such as bank card activation call durations. Fact Tables represent Business measures like, how long customers waited in a queue, how long and how often agents put customers on hold, or how long agents talked to Customers. Dimension tables describe the attributes of the associated fact table.

Responsibilities:

Worked with business analysts and data analysts to support their data warehousing and data analysis needs.

Involved in developing end to end. Datawarehousing application .x`

Worked as a single resource and developed 140+ Informatica mapping within 3 months without any defect.

One year History Data load for Genesys application is completed in 10 days. Have received appreciation from client and managers for the same.

Created complex Informatica mappings which include the dynamic string search parsing logic and determine previous day download data for the group and individual based on the dynamic calling list names.

Integrated Informatica workflows via scheduling tools.

Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput

Environment: Informatica Power Center 9.5.1, Netezza, CA workstation and UNIX, SQL Server

4BB&T – Special Assets, Winston, NC

Role: Informatica Developer (March 2015 to Dec2016)

Project Description: The focus of Special Assets LOB is to reduce losses resulting from the bank's lending programs and to control the expenses of BB&T operation. Losses will be reduced by the specialized and proactive involvement of Special Assets' departments and will help internal customers (BB&T branches and loan product managers) do their job better.

Responsibilities:

As a single offshore Associate coordinated with on-site team in gathering the requirements.

Created Mapping Documents based on the Design and Business needs.

Understand the business needs and design ETL process that match the complex business requirements with very few & minor overall bugs.

Validated design standards and optimized Mappings, Sessions & Workflows to improve the performance. Actively participated during the environment preparedness for production

Implementation and migration. Involved in scheduling jobs using ESP scheduler tool and defined dependencies for effective load processing.

Successfully deployed code in production without bugs.

Environment: Informatica Power Center 9.5.1, IBM DB2, ESP Scheduler and UNIX

5BB& T – Managed Service,Chennai, India

Role - Informatica Developer (Aug 2014 to March 2015)

Project Description: The objective of this project is to support 26 banking applications in production (Daily & Monthly). The major marts are FMER (Financial management external reporting), Decathlon and Special Assets (SPA).

Responsibilities:

ETL (Extraction Transformation and Loading) designing, coding, and unit testing for new change requests and enhancements.

Troubleshoot coding issues and provide resolution for failures.

Fixing defects/bugs raised by client. Monitoring production jobs daily and fix the failures.

Performing root cause analysis, defect fixing and documentation for production issues.

Prepared deployment documentation and checklists that sufficiently assist operations team to deploy the code in production. Contribute to process improvements and Value Adds.

Environment: Informatica Power Center 9.x, IBM DB2, ESP Scheduler and UNIX

6Chartis, Chennai, India

Role: Junior Informatica Developer (Dec 2010 to Aug 2014)

Project Description: Chartis is one of the world leading property-casualty and general insurance organization. chartis came up with a special program called GIFT FSL in order to provide Insurance solution worldwide. Release 3 was involved in the implementation of migrating data from various chartis applications into SAP FS – CD module for reporting.

Responsibilities:

Understand the Insurance domain.

Develop jobs related to different subject areas for Premiums and Claims.

Analyze the code and implemented Change Request (CR).

Monitoring the data loads in data stage. Resolving and debugging the issues, which arise during execution of the jobs.

Perform code migration activities to test and production environments

Environment: IBM Information Server Data Stage 8.1, Sybase, UNIX, PVCS.

EDUCATION

Bachelor of Engineering (2006-2010) – Electronics and Instrumentation Engineering Sathyabama University, Chennai, India

Contact this candidate