Thrivikram Reddy

Email: ac8sqi@r.postjobfree.com PH: +1-512-***-****

Professional Summary

Around 6+ experience in IT Software Development Life cycle involved in Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing applications in Manufacturing, Travel and Insurance domains.

Experience in Analysis, Design, Development and Maintenance of various Business Intelligence Tools like Tableau Server, Tableau Desktop.

Extensive experience in writing SQL, Stored procedures, Functions, Packages, Database triggers, Shell-Scripts and SQL Loader scripts.

Extensively Used Data Blending to Join Multiple Data Sources and Rendering the data into visualization in Tableau

Proficient in SQL using Stored Procedure, Dynamic SQL, joins, Views, Indexes, Triggers, Cursors, CTE, DML, DDL and etc.

Very strong in SQL Query Tuning, Indexes and Stored Procedures, Review and optimize daily batch jobs.

Expertise in conducting requirements gathering sessions, feasibility studies, Impact Analysis, Risk analysis & management and base lining the acceptance criteria.

Provided strategic thinking and solutions while driving Architectural Recommendations specific to data warehouse applications and business intelligence tools focusing on ETL functions.

Provided project level design, data analysis and application performance analysis.

Expertise in managing several projects simultaneously for the whole project life cycle.

Extensive experience in the development, implementation, deployment & integration strategies within a team oriented environment, utilizing quantitative & qualitative analytical skills.

Strong Knowledge of SDLC and Agile (Scrum) methodology.

Experience in using Informatica Power Center, an ETL tool to integrate data from various source systems includes flat files, XML, Relational and COBOL on UNIX and Windows platform.

Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.

Experience in several facts of MDM implementations including Data Profiling, Data extraction, Data validation, Data Cleansing, Data Match,Data Load,Data Migration, Trust Score validation.

Good understanding of ETL, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts.

Experience in using Informatica Power Exchange to extract the data from and load the data into the salesforce application using Bulk API and Soap API concepts in Salesforce.

Experience in integration of various Operational Data Source (ODS) s with Multiple Relational databases like Oracle, Teradata, SQL Server and Worked on integrating data from flat files of fixed width and delimited.

Hands on expertise with SQL Server, Oracle, Teradata and DB2 Databases.

Writing batch scripts to process source files, target files, automate the email notifications, archive the files, copy, ftp and cleanse the files to process in ETL.

Expert level understanding of Oracle Database Capabilities and DW best practices including appropriate use of Index, Partitions, Materialized Views etc.

Excellent in project management, communication, documentation, interpersonal and analytical skills. Strong ability to perform as part of a team.

TECHNICAL SKILLS

Business Intelligence: Informatica 10.1/9.x/8.x, Cognos

Source/Target Systems: Oracle, DB2, SQL Server, Teradata, Salesforce, SAP

Languages: SQL, PL/SQL, Shell Scripting, PostgreSQL, C, Java

Tools: SQL Developer, TOAD, Control M, Subversion

EIM tools Informatica MDM Multi-domain 9.5.1/9.7.1, IDD, SIF.

OS/Environment: Windows 9X, DOS, UNIX

PROFESSIONAL EXPERIENCE:

Blue Cross Blue Shield Michigan Mar 2017 –Till Date

Role: Informatica Developer

Responsibilities:

Requirements gathering and requirements analysis through coordination with business analysts and define business and functional specifications.

Experience in Analysis, Design, Development and Maintenance of various Business Intelligence Tools like Tableau Server, Tableau Desktop.

Extensively Used Data Blending to Join Multiple Data Sources and Rendering the data into visualization in Tableau.

Provided documentation of ETL design and technical specifications, high level and low-level design specifications.

Worked on MDM Hub configurations - Data modeling & Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director (IDD).

MDM development includes creating Base object tables, staging tables and landing tables as per requirement in LLD.

Well acquainted with deploying multiple Application Servers such as Jboss, Weblogic and Web sphere.

Used Informatica Power Center 9.6 for extraction, transformation and load (ETL) of data into the data warehouse.

Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Lookup, Sequence generator, Router and Joiner.

Worked on Informatica Advanced concepts & also Implementation of Informatica PushDown Optimization and Partitioning.

Created mapplets and reusable transformations to leverage the coding efforts and to help code maintenance.

Used Type 2 SCD logic in Informatica to load Slowly Changing Dimension tables.

Created complex stored procedures, functions, triggers, and tables and materialized views. Developed complex SQL code to read data from source system and in lookup transformations.

Worked with testing team to define a robust test plan and support them during the functional testing of the application.

Identifying & removing the bottlenecks, tuning the mappings and sessions to improve performance.

Precise Documentation was done for all mappings and workflows.

Developed Shell scripts to automate file manipulation and data loading procedures.

Review and deploy the code.

Prepare and use test data/cases to verify accuracy and completeness of ETL process.

Environment: Informatica Multi domain MDM 9.5.0, JBoss 5.1, Oracle 11g, Address Doctor 5, IDD, SIF, Informatica Data Quality (IDQ) 9.5.0,Teradata R6, Informatica Power Center 9.1.0,ToadInformatica Power Center 9.6, SQL Server, Oracle, UNIX, SAP, Control M

Cigna, Hartford, CT Aug2015 – Feb2017

Role: Informatica Developer

Responsibilities:

Involved in Requirement gathering and analyzing the requirements. Created mapping documents to outline data flow from sources to targets.

Extracted the data from the flat files and Oracle into staging area and populated onto Data warehouse. Worked on Flat Files and Oracle as sources.

Provide documentation of ETL design and technical specifications, high level and low-level design specifications.

Create test cases for Unit testing, Integration testing and User acceptance testing.

Create mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and update strategy etc.

Create mappings, sessions, workflows and run those using workflow manger and monitor jobs using workflow monitor.

Involved in upgrading Informatica from 9.6 to 10.1

Connecting and loading data from SAP and AZURE source systems.

Made use of Post-Session success and Post-Session failure batch scripts in the Session task to execute scripts needed for cleanup and update purposes.

Assist with task identification and effort estimates for ETL development as per Agile Development methodology.

Documented the test plans and executed for UNIT testing and also supported for system testing, volume testing and USER testing. Also provided production support by monitoring the processes running daily.

Created email notifications. Scheduled the loads at required frequency using Control M, generated completion messages and status reports using Workflow Manager.

Using debugger to test the data flow and fix the mappings.

Prepare and use test data/cases to verify accuracy and completeness of ETL process.

Involve in Production Support and troubleshooting data quality and integrity issues.

Environment: Informatica Power Center 10.1/9.6.1, AZURE, SQL Server, Oracle, Windows, Control M

SunTrust Bank, India Jun2012 – April 2015

Role: Informatica Developer

Responsibilities:

Design ETL Best Practice Methodology for the Creation of an Enterprise Data Warehouse (EDW) for Associated Bank.

Build and promote the use of repeatable EDW processes, templates, and tools.

Involved in Requirement gathering and analyzing the requirements.

Responsible for holding meetings with the functional Analyst to understand the business requirements.

Maintain account lineage.

Reconcile the month end loan balances in Associated Bank’s general ledger (GL) to the month-end loan balances in the credit risk data mart.

Provide vintage analysis (vintage delinquency, payoff trend, charge-off curves) and HELOC (home equity line-of-credit).

Provide probability of default (PD), loss given default (LGD), exposure at default (EAD) and dynamic cohort reporting.

Created email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.

Join business discussions to attribute the business and functional requirements and qualify and quantify data requirements and project planning.

Provide documentation of ETL design and technical specifications, high level and low-level design specifications.

Design and build reconciliation process.

Police code maintenance and code deployments.

Environment: Informatica PowerCenter 9.5.0, Oracle 11g, SQL Server, Windows

Contact this candidate