SUMMARY

**+ years of experience in IT in the areas of analysis, design, development and testing in client server environment with focus on Data warehousing applications using ETL/OLAP tools like Informatica, Business Objects with Oracle, SQL Server databases.

Involved in complete software development life cycle (SDLC) of project with experience in domains like Retail, Healthcare Insurance and Automobile.

Experience in business requirements gathering, define and capture metadata for business rules, system analysis, design, development, production support, testing, user training, and strategic decision making, problem solving associated with the ETL processes by working closely with BI team.

Experience in developing Enterprise level Data warehouse, Data marts and Operational databases.

Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 10.2/10.1/9.5/9.1/8.6/7.x

Experience in source systems analysis and data extraction from various sources like Flat files, Oracle 12c/11g/10g/9i/8

Experience in Performance Tuning. Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.

Worked with heterogeneous data sources like Oracle, SQL Server 2008/2005, flat files, XML files, DB2 UDB, Main Frames and COBOL files.

Perform error handling as part of production support on Informatica as well as Unix.

Experience in performance tuning of sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions and batches

Expertise in using GUI tolls like Erwin, Toad, SQL Developer, SQL Navigator and SQL *Loader.

Excellent communication skills, team player, ability to work individually and meet tight deadlines.

Experience in Installation, Configuration, and Administration of Informatica Power Center 9.x/8.x/7.x/6.x, power exchange8.1 and Power Mart 5.x/6.x Client, Server.

Experience in Validating ETL Tools like Informatica Power Center.

Knowledge on postgreSQL and knowledge in System Testing / Integration Testing and Regression testing

Extensive experience in writing SQL scripts to validate the database systems and for backend database testing.

Expertise in defining Test Strategies, writing detailed Test Plan and Test Cases, Defect Tracking and Defect Reporting using Mercury Quality Center.

Adaptable and proficient in the design and programming of systems in a wide variety of areas including Real Time Systems.

Strong Team Player with communication and relationship management skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.2/10.1/9.1/8.6/7.x/6.x Informatica Power Exchange 5.1/4.7/1.7, Power Analyzer 3.5, Informatica Power Connect.

Databases: Oracle 12c/11g/10g/9i/8i/8.0/7.x, MS SQL Server 7.0/2000/2005/2008

Operating Systems: UNIX (Sun-Solaris, HP-UX), Windows NT/XP/Vista, MSDOS

Programming SQL, SQL-Plus, PL/SQL, UNIX Shell Scripting

Reporting Tools: Business ObjectsXIR2/6.5/5.0/5.1, Cognos Impromptu 7.0/6.0/5.0, Informatica Analytics Delivery Platform, Micro Strategy.

Other Tools: SQL Navigator, Quest Toad for Oracle, SQL Developer 1.5.1, Autosys, Telnet, MS SharePoint, Mercury Quality center, Team Track.

Methodologies: Ralph Kimball.

EXPERIENCE

Republic National Distribution Company Jun’19 - Present

Republic National Distributing Company, LLC (RNDC) is the second largest beverage alcohol distributor of premium wine and spirits in the U.S. with wholly owned operations in Alabama, Colorado, District of Columbia, Florida, Louisiana, Maryland, Mississippi, Nebraska, North Carolina, North Dakota, South Dakota, Texas, Virginia, and West Virginia. RNDC operates in Arizona, Indiana, Kentucky, Ohio, Oklahoma, and South Carolina through venture partnerships. In total, RNDC employs more than 9,000 individuals nationwide.

Responsible for ETL development for assigned projects.

Responsible for timely project deliverables.

Responsible for writing ETL design documents.

Collaborates with development teams, business units to identify, define, develop and implement new data source feeds.

Monitors usage of the Data Warehouse to identify potential capacity overloads and bottlenecks.

Assists with tuning of ETL processes and database performance.

Provides support for technical issues and ensuring system availability.

Remains current on Enterprise Data Warehousing technologies, testing industry trends and best practices

Provides guidance to more junior staff

Well versed with project management methodology for SDLC.

IBM Watson Health, Smyrna GA Jan’19 – Jun’19

Sr ETL Developer

IBM Watson Health is developing an Enterprise Data Solution (EDS) for Georgia Department of Community Health. The EDS will provide reporting, analytic and predictive capabilities for Medicaid services provided by the state of Georgia. EDS will collect data from 80 plus data sources from multiple data vendors. The EDS architecture stores data coming from different sources into the Staging layer where data structure and data of the tables are similar to the structure of the source data files. From the staging layer data is loaded to Integrated Data Repository (IDR) which is actually an enterprise data warehouse using relational data model and further data marts will be loaded from IDR according to the subject area.

Responsibilities:

Involved in preparing end to end ETL frame work design process.

Build Control framework code which handles the historical and delta load.

Built and documented audit framework for all the ETL workflows.

Worked on recovery strategy model for workflows and documented the process.

Built the optum pharmacy claims data code (Standard & Compound) using informatica power center.

Built the mechanism which handles provider information from DXC source.

Explored and performed Proof of concepts on Informatica Developer(IDQ) tool and Data Processor transformation which handles unstructured data(basic).

Involved in RAS sessions with business and scrum masters to identify the user stories.

Analyzed sample EDI X12(EDI 837D,837I,837P), NCPDP claims extracts which are available from CMO’s.

Created data base triggers to capture the control table entries in the history table.

Environment: Informatica Power Center 10.1/9.5 (Repository Manager, Designer, Workflow Manager, Workflow Monitor) Oracle 11g, Toad, Linux, Technology Development Platform (TDP).

AT&T, Alpharetta GA

Device Life Cycle (DLC), Order Track (OT) is the two major business process which processes the orders & records the AT&T service usage by the customer.

Device Lifecycle. This project provisions, creates accounts, sets up billing plans, and activates prepaid phones as a single step after the purchase by a consumer from a retailer. This allows AT&T’s prepaid initiative to function as a single integrated entity as opposed to multiple systems.

Primarily Order Track project is designed to consolidate / track the order data / order status from various systems, also provides flexible user interface to the customer to inquire about the current status of the order & track it history. The customer is also provided with an option to sign-up / Sign in for order status notifications via Email / SMS.

ETL Solution Architect /Sr Informatica developer Sep’14-Dec’19

Analyze business requirements,

Preparing system requirements documents

Preparing High level Design documents for multiple applications.

Work on Application Interface documents

Prepare test cases to meet the HLD (High Level Design)

Test all the HLD’s after development handover developed code

Participate in system integration testing

Help production support team in resolving production issues and help business in case of any issues related to data.

Design data warehouse tables for the project and ETL.

Also Worked extensively on Mappings, Mapplets, Sessions and Workflows.

Worked on error handling mechanism.

Created views (Materialized) and altered some of the dimensional tables to satisfy reporting needs.

Prepared Shell scripts to trigger workflows and archiving the source extracts or files once the load is completed.

I have also contributed significantly to enhance the ware house management system with in at&t for faster and safer Delivery of the Iphone’s using the 3PL third party logistic like FEDEX, UPS, USPS and many more

Environment: Informatica Power Center 10.1/9.5 (Repository Manager, Designer, Workflow Manager, Workflow Monitor) Oracle 11g, Toad, Linux, Technology Development Platform (TDP).

Ahold USA, Quincy, MA Oct ’11-Aug’14

RDF (Retail Demand Forecast) is the tool which was developed to forecast the sales of all the items in Giant and Stop & shop stores across USA. Informatica tool is used in this environment to load the daily and weekly data into Datamart and Microstrategy is the reporting tool. Objective of this project is to generate the MAPE (Mean Absolute Percentage Error) accuracy of each and every Item which is in Stop&Shop and Giant stores.

ETL Developer (BI Project)

Responsibilities:

Participated in all phases including requirement gathering, analysis, design and development.

Interacted with IT management, SMEs, Architects, Project Manager and Customers to understand the business requirements and to translate them into corresponding technical documents.

Managed data warehouse enhancements and related projects, defined requirements and ensured that work is completed accurately and on-time.

Prepared Technical Design Document for the requirements including key project assumptions,

technical flow, process flow, ETL Logical design, logics and Error handling

Worked extensively on Mappings, Mapplets, Sessions and Workflows.

Being a part of ETL team worked extensively and used bulk load mechanism to load the huge amount of data into the Datamart (Aprrox 5 billion /week)

Prepared Scripts to set the environments to run the Informatica workflows in an UNIX server to synchronize the source systems.

Designed and Created ETL Design Documents and Process Flow Diagrams.

Developed ETL Objects – Mappings, Sessions, Workflows, Scheduling, Deployment planningetc for Common Data Storage Warehouse and Marts.

Responsible for Migration and Deployment of Code to Test/UAT and PROD Environments and Scheduling the Jobs.

Support Daily Operations and Fix Production Issues (HOT Fixes).

Performing the basic Informatica Administrator activities.

Prepared JIL code (Job information language) to schedule the jobs in Autosys.

Worked closely with reporting team and resolved the performance issues.

Extensively used ETL to load data using Power Center from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle. Analyzed the existing systems and made a Feasibility Study.

Worked on ticketing system called BMC Remedy user to receive the tickets for job failures.

Prepared complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.

Did Performance Tuning - Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.

Used existing procedures (Helper Package) in coding to build the indexes and gather statistics at the table level which is a part of pre load and post load utility.

Reviewed test cases written by team members.

Handled production support issues and resolved issues during Project deployment.

Worked on JOB dependencies across multiple source systems and predecessors to optimize the performance as well as time constraint.

Worked on error handling mechanism.

Created views (Materialized) and altered some of the dimensional tables to satisfy reporting needs.

Prepared Shell scripts to trigger workflows and Archiving the source extracts or files once the load is completed.

Validated test cases for Source to Target mappings (STM).

Environment: Informatica Power Center 9.1/9.5 (Repository Manager, Designer, Workflow Manager, Workflow Monitor) Oracle 11g, SQL Developer, Flat Files, Autosys, AIX, Exadata, SQL Server 2008 Windows NT, Shell Scripting, BMC Remedy user, Micro Strategy.

Blue Cross Blue Shield of Michigan, Detroit, MI Nov ‘10 – Sep ‘11

Sr. Application Developer / ETL Analyst (Business Intelligence Center-BIC)

Responsibilities

Completed the BCBS Industrial Certifications.

Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.

Data modeling and design of data warehouse and data marts in star schema methodology with confirmed dimensions and FACT tables.

Prepared Oracle DDL scripts on the database for creating the table definitions, creating index and for alter as well.

Coordinated and worked closely with legal, clients, third-party vendors, architects, DBA’s, operations and business units to build and deploy.

Automated the processes from existing Manual processes.

Prepared technical specification to load data into various tables in Data Marts.

Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.

Worked extensively on Mappings, Mapplets, Sessions and Workflows.

Scheduled and monitored the jobs using Tivoli Systems.

Involved in PROD support for various SQL Server DTS jobs to load the SQL tables from one server to another.

Worked on production tickets to resolve the issues in a timely manner.

Prepared Unit Test Plan, System Integration Test and UAT to check the system and data quality based on Test case and Use cases.

Prepared Test Strategy and Test Plans for Unit, SIT, UAT and Performance testing.

Coordinated and lead the end-to-end system testing effort – includes setting up the environment, code migration, running the test cycles and resolving the issues.

Tested the ETL mappings and other ETL Standard Processes.

Tracked and Documented defects identified during testing.

Extensively worked on tuning Informatica mappings to increase performance.

Worked with different Source Systems to perform transformations and load to different Target Tables, Flat Files.

Environment: Informatica Power Center 8.6.1/8.1.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Power Exchange Navigator 8.6.1/8.1.1, Oracle 10g, TOAD, SQL Server 2000/2005, Flat Files, Tivoli, Shell Scripting.

Volkswagen of America, Auburn Hills, MI Jan 10 – Oct 10

Senior Data Warehouse Developer / Data Analyst

Responsibilities:

Worked with business team and architects to translate business requirement into tech design.

Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.

Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Normalizer for XML file.

Involved in Performance tuning for better performance.

Participated in weekly end-user meetings to discuss data quality, performance issues and ways to improve data accuracy and new requirements, etc.

Participated in Test Case walkthroughs, inspection meetings, Interacted and worked with the Development and Data warehouse team to solve the problems encountered in test execution.

Participated in review meetings with Dev team to meet the testing targets, Participated in daily status meetings to report any bugs, issues and risks.

Involved in Unit, System integration, User Acceptance Testing of Mappings. Prepared complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.

Responsible for the developing ETL process/Programs with Informatica power center to extract data from client’s operational databases Transform and filter the data and load it into target data base.

Responsible for Creating workflows and worklets. Created Session, Event, Command, and Control Decision and Email tasks in Workflow Manager.

Provided application support to the data warehouse. Especially to the portion of the data warehouse which I am responsible for.

Created Perl scripts to generate Email Notifications and to load data from different Source systems like flat files and Oracle databases (ETL) and to schedule workflows.

Created high-level Technical Design Document and Unit Test Plans.

Documented Informatica mappings, design and validation rules.

Environment: Informatica Power Center 8.6/7.1.4, Oracle 10g/9i, Business Objects XIR2, SQL, PL/SQL, TOAD, Perl, UNIX, Clearcase, XML, Tivoli workload scheduler and Erwin 4/3.5.2

BlueCross BlueShield, Buffalo, NY May 09 – Dec 09

Informatica Developer

Responsibilities:

Involved in Analysis, Requirement Gathering with business users and Design process.

Extracted data from flat files, VSAM, XML and RDBMS systems like Oracle, Netezza, SQL server and DB2 systems.

Developed number of complex Informatica mappings and mapplets to implement business logic.

Developed Informatica mappings by usage of Aggregator, SQL Overrides in Lookups, filter in Source Qualifier, and data flow management into multiple targets using Router transformations.

Provided Production support for the production issues by troubleshooting the session logs, bad files, tables and mappings.

Developed the Informatica scripts in order to populate the Global repository from the local repository Worked with Scheduler to run the Informatica session on daily basis and to send an email after the completion of loading Conducted Unit testing and Integration testing Analyzed the reliability, hypothesis and restriction in documentation of the Functional, Technical and Architecture which are confidential.

Environment: Informatica Power Center 8.6/8.1, Informatica Power Exchange, Oracle 10g/9i, SQL Server 2005, PL/SQL, Netezza, TOAD, SQL Developer, DB2, Flat Files, Microsoft Access, Perl, HP/UNIX, Mercury Quality Center, Share Point and TeamTrack.

Hitachi Data Systems, Santa Clara, CA Jul 07 – Apr 09

Data warehouse Analyst

Responsibilities:

Coordinating with the Business team to gather user/system requirements and convert them to Technical Specifications.

Coordinated and perform lead duties with offshore team.

Developing Business System Requirements (BSR), High Level Design documents (HLD), Low Level Design documents (LLD) for each Application.

Create Logical and Physical data models in staging database using Erwin tool.

Used Informatica Power Exchange to connect to IBM Mainframe systems (JCL, Cobol Files), JMS (Java Messaging Services) to access data in various formats such as VSAM, IMS and IDMS.

Performed data cleansing to support data conversion activity from source to targets.

Used metadata and meta model asset inventory reports to locate data and integration process assets to aid data discovery and audit reporting for regulatory compliance and data governance.

Designed/developed Stored Procedures for data mappings to implement complex business logics and called from Informatica Stored Procedure Transformations.

Created PL/SQL scripts, Cursors, Triggers, Functions, Packages and involved in Performance tuning of the databases.

Developed complex mappings to load data from Source System (RDBMS), XML files and flat files.

Created Reusable transformations, Mapplets and Informatica Worklets for use in multiple mappings and workflows using Informatica Power Center Designer and Workflow Manager.

Created Connected, Unconnected and Dynamic Lookup transformations for better performance

Developed Perl scripts to schedule workflows and run ETL jobs. Generate Email Notifications and to load data from different Source systems like flat files and Oracle databases.

Made changes to the existing Informatica Mappings/Objects using Informatica Versioning.

Involved in Unit testing, System testing and capturing the test results.

Developed Pre-SQL and Post-SQL scripts in Informatica sessions for complex logics.

Environment: Informatica Power Center 8.1, Informatica Power Exchange, Oracle 10g/9i, SQL Server 2008, PL/SQL Procedures, TOAD, SQL*Loader, UNIX, Autosys, Rational Clearcase, MS Visio and Erwin 7.

Contact this candidate