BINDHU MADHAVI CHIDELLA

Email: ad0u90@r.postjobfree.com

Mobile: 980-***-****

PROFESSIONAL SUMMARY:

Around 6+ years of experience in designing, developing and maintaining large business applications such as data migration, integration, data warehouse and Testing.

Strong Experience in Informatica 9.6.1. with the transformations like lookup, update strategy, filter, router etc.

Experience in data warehousing and application development using Abinitio 3.3.4. & Informatica.

Created Mappings using Informatica tool.

Excessively used complex transformations like aggregator, Lookup. Change capture, joiner, Router, Filter, SQL.

Specified the partitioning methods as per the stages wherever required.

Experience on Teradata. Autosys JOB scheduling tool.

Linux/Unix and the ability to write moderately complex shell scripts (using ksh, perl, php, etc.)

Worked as Data Analyst in some of the banking projects.

Expertise in working with relational databases such as Teradata, DB2, Oracle.

Worked on SAS Scripting support.

Professional understanding of Software Development Life Cycle (SDLC).

Experience in integration of various data sources like Flat files, Oracle, SQL Server, XML,

Experience in handling informatica transformations.

Experience with Type 1, Type2, Type3 Slowly Changing Dimensions

Expert in troubleshooting and debugging at different stages.

Exposure to multiple industry domains like Government, P&C Insurance and Financial Services

Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support

Development experience in Informatica giving flexibility for technology changes in organization

Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products

Team player with excellent communication and problem-solving skills

Comprehensive knowledge and experience in Data Extraction, Data Cleansing, Data Manipulation

Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting

Experience in using Automation Scheduling tools like Autosys JIL jobs, Main frames scheduler.

Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.

Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, and Oracle PL/SQL.

Experience in resolving on-going maintenance issues and bug fixes; monitoring ETL jobs as well as performance tuning

Strong leader with experience training developers and advising technical groups on ETL best practices

Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

Experience in Implementing Round Robin, Hash, Key Range and Pass-through Partitioning at the Informatica level for the tables being loaded with huge amount of data

TECHNICAL SKILLS:

Data warehousing

Informatica PowerCenter 9.6/9.1/8.6/8.5/8.1/7.1, Abinitio 3.3.4, OLAP, OLTP, Star & Snowflake Schema, FACT & Dimension Tables, Physical & Logical Data Modeling, Erwin r9.7

Databases

Teradata, Oracle 11g/10g/9i, SQL Developer, SQL Server 2008/2005, My SQL, MS-Access, DB2 8.0/7.0

Languages

SAS Scripting, SQL, PL/SQL, T-SQL, UNIX + Scripting, HTML, XHTML,

Operating System

HP-UX, Sun Solaris, LINUX, Windows XP.

Scheduling Tools

Autosys, Control M, Remedy, Clear Case, Clear Quest, HP Quality Center.

DB Programming &Tools:

RDBMS, Joins, Indexes, Views, Functions, Triggers, Procedures, SQL*Plus,

Reporting Tools

Tableau, Micro Strategy

PROFESSIONAL EXPERIENCE:

Project 1: Fraud Squad – Data Supply Chain

KeyBank

Role: Abinitio ETL Developer

Duration: May 2022 – Till Now

Remote – Charlotte NC

Responsibilities:

●Developed ETL programs in Fraud Mart tables using Abinitio to implement the business requirements.

●Created graphs, psets, plan using Abinitio tool.

●Extensively worked with the Ab Initio Enterprise Meta Environment EME to obtain the initial setup variables and maintaining version control during the development effort.

●Worked on Google Cloud to load the data as a target

●Extracted data from various sources google cloud.

●Working on parameterized generic graphs

●Working on XLR to package the code and Mainframes as an Scheduling tool to schedule the Jobs in ETL.

●Responsible for the detailed design and documentation. Coordinated efforts with different teams and stakeholders

Project 2: ERA

Wells Fargo

Role: Abinitio ETL Developer.

Duration: Sep 2021 – May 2022

Charlotte NC

Responsibilities:

●Developed ETL programs using Abinitio to implement the business requirements.

●Created graphs, psets, plan using Abinitio tool.

●Analyzed business needs and documented functional and technical specifications based upon user requirements with extensive interactions with business users

●Extensively worked with the Ab Initio Enterprise Meta Environment EME to obtain the initial setup variables and maintaining version control during the development effort.

●Worked with data modeler to create Logical and Physical data model

●Extracted data from various sources like databases Teradata, Oracle, delimited flat files.

●Designed and developed parameterized generic graphs

●Designed Ab Initio graphs that would harness Teradata capabilities ELT and balance resources between database and Ab Initio

●Responsible for the detailed design and documentation. Coordinated efforts with different teams and stakeholders

●Developed, tested and reviewed complex Ab Initio graphs, sub-graphs, DML, Psets, XFR, deployed scripts, DBC files for connectivity, create Package and exports.

●Worked on Functional design document and other different documentation for creating the Net New tables for the project purpose.

Project 3: NON-CD1 CAR

TRUIST - Infosys

Role: Lead Informatica BDM developer

Duration: Mar 2021 – Sep 2021

charlotte, NC

●Working on BDM products on Hive as a target and working on multiple source systems to map into the target.

●Excessively used complex transformations like aggregator, Lookup. Change capture, joiner, Router, Filter, SQL.

●Specified the partitioning methods as per the stages wherever required.

●Communicated with business customers to discuss about the requirements, issues.

●Worked on Functional design document and other different documentation for creating the Net New tables for the project purpose.

●Implemented the SCD type 2 scenario based on the business requirement.

●Effectively worked on Onsite and Offshore work model.

●Worked on scheduling Autosys tool. created JIL jobs and created the child jobs to address the project run as per schedule.

●Worked on lookup, router, update strategy transformations,

●Performed unit testing at various levels of the ETL and actively involved in team code reviews.

●Identified problems in existing production data and deployed them to address on time.

Project 4: Marketing Capital Risk Management (MCRM)

Wells Fargo - Infosys

Role: Lead ETL Developer.

Duration: Dec 2019 – Mar 2021

Charlotte NC

Responsibilities:

●Developed ETL programs using Abinitio to implement the business requirements.

●Created graphs, psets, plan using Abinitio tool.

●Analyzed business needs and documented functional and technical specifications based upon user requirements with extensive interactions with business users

●Extensively worked with the Ab Initio Enterprise Meta Environment EME to obtain the initial setup variables and maintaining version control during the development effort.

●Worked with data modeler to create Logical and Physical data model

●Extracted data from various sources like databases Teradata, Oracle, delimited flat files.

●Designed and developed parameterized generic graphs

●Designed Ab Initio graphs that would harness Teradata capabilities ELT and balance resources between database and Ab Initio

●Responsible for the detailed design and documentation. Coordinated efforts with different teams and stakeholders

●Developed, tested and reviewed complex Ab Initio graphs, sub-graphs, DML, Psets, XFR, deployed scripts, DBC files for connectivity, create Package and exports.

●Worked on Functional design document and other different documentation for creating the Net New tables for the project purpose.

●Implemented the SCD type 2 scenario based on the business requirement.

●Worked on the work order and ATANA scripts for the CR purpose.

●Worked on the ksh scripting to perform different checks for file arrival.

●Effectively worked on Onsite and Offshore work model.

●Worked on scheduling Autosys tool. created JIL jobs and created the child jobs to address the project run as per schedule.

●Worked on lookup, router, update strategy transformations,

●Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Project 5: Default Activity Reporting (DAR).

Wells Fargo - Infosys

Role: Informatica ETL Developer.

Duration: May 2018- Dec 2019

Charlotte NC

Responsibilities:

●Developed ETL programs using Informatica to implement the business requirements.

●Created graphs in Abinitio

●Excessively used complex transformations like aggregator, Lookup. Change capture, joiner, Router, Filter, SQL.

●Specified the partitioning methods as per the stages wherever required.

●Communicated with business customers to discuss about the requirements, issues.

●Worked on Functional design document and other different documentation for creating the Net New tables for the project purpose.

●Implemented the SCD type 2 scenario based on the business requirement.

●Worked on the work order and ATANA scripts for the CR purpose.

●Worked on the ksh scripting to perform different checks for file arrival.

●Effectively worked on Onsite and Offshore work model.

●Worked on scheduling Autosys tool. created JIL jobs and created the child jobs to address the project run as per schedule.

●Worked on lookup, router, update strategy transformations,

●Performed unit testing at various levels of the ETL and actively involved in team code reviews.

●Identified problems in existing production data and deployed them to address on time.

Project 6: Cornerstone

Wells Fargo - Infosys

Role: Informatica ETL Analyst.

Duration: Jan 2018- Apr 2018

Charlotte Nc

Responsibilities:

●Developed ETL programs using Informatica to implement the business requirements.

●Communicated with business customers to discuss about the requirements, issues.

●Worked on Functional design document and other different documentation for creating the Net New DDL’s for the project purpose.

●Implemented the SCD type 2 scenario based on the business requirement.

●Worked on the workorder and ATANA scripts for the CR purpose.

●Worked on the ksh scripting to perform different checks for file arrival.

●Effectively worked on Onsite and Offshore work model.

●Worked on scheduling Autosys tool. created JIL jobs and created the child jobs to address the project run as per schedule.

●Worked on lookup, router, update strategy transformations,

●Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Identified problems in existing production data and deployed them to address on time.

Project 7: QA OPS

SunTrust - Infosys

Role: ETL Analyst

Duration: Sep 2017 - Dec 2017

Atlanta GA

Responsibilities:

Engage client to gather software requirements/business rules, and ensure alignment with development teams

Translate stakeholder requirements into over 10 different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.

Developing MDL document, Mapping document, SRS

Identify and reconcile errors in client data to ensure accurate business requirements.

Draft and maintain business requirements and align them with functional and technical requirements.

Facilitate monthly meetings with clients to document requirements and explore potential solutions.

Contact this candidate