Informatica consultant

VIKAS REDDY

+1-916-***-****, *********.***@*****.***

ACADEMICS:

MS in Computer Information Systems, Florida Institute of Technology, Melbourne, Florida Bachelor of Technology in Computer Science, JNT University, Hyderabad, INDIA SUMMARY: With over 7 years of experience in building ETL Informatica & Data Warehousing solutions, I have worked on numerous projects from inception, design to delivery and maintenance. I have donned multiple hats over the years, working as Business/Data Analyst, Data Architect, ETL Developer and also lead development teams for successful project delivery. Good knowledge of business/process dataflow in organizations and proficient in data modeling using ERWIN. I have good analytical and problem-solving skills and worked over multiple domains such as Retail, Banking, Healthcare etc. PROFESSIONAL EXPERIENCE:

Client: UCare, Minneapolis MN Apr 2018 – Current

Role: Informatica Consultant

• Defined and designed flow and standards for Informatica framework.

• Work with Business Analyst and Business Users to understand the requirement and translate the requirement into technical specification.

• Use Agile methodology for SDLC and utilize scrum meetings for creative and productive work.

• Design, develop, and test Informatica mappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.

• Identifying bottlenecks/issues and fine tuning them for optimal performance.

• Conducting code walkthroughs and review peer code and documentation.

• Playing role in design of scalable, reusable, and low maintenance ETL templates.

• Tested and tuned the SQL queries for better performance. Identified the bottlenecks in mapping logic and resolved performance issues.

• Moving the mappings and workflows from Dev to QA and QA to Production environment and unit testing the process at every level.

• Documented detailed steps for migrating the code. Environment: Informatica Power Center 10.1/10.2, Informatica Data Quality, Oracle 10g, SQL Server 2012/2016, Right Data, Atomic UC4, PL/SQL, batch scripting. Client: US Bank, Minneapolis MN Sep 2017 – Apr 2018 Role: Informatica Consultant

• Design, code, analyze, and configure, unit test, debug, documentation and maintenance of informatica applications.

• Development of complex ETL mappings which includes modifying existing mappings and building others from scratch involving strategies such as Extract, Transform and Loading mechanism using informatica 9.X version.

• Responsible with doing source systems analysis and data extraction from various sources such as flat files, SQL Server, Oracle, and other heterogeneous data sources.

• Involved in building the ETL architecture and Source to Target mapping to load data into landing zone.

• Applied the concept of Change Data Capture (CDC) and imported the source from Legacy systems using Informatica Power Exchange (PWX).

• Ability to analyze technical information, evaluate products, services and vendors and makes recommendations.

• Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files.

• Built new informatica interfaces by pulling data from SQL server, oracle databases and loaded in consolidated data store which is also known as landing zone.

• Fine-tuned the audit, batch processing reusability sessions to perform optimally and be used globally across the board.

• Involved in debugging Informatica mappings, testing of Stored Procedures, Performance and Unit testing of Informatica Sessions, Batches and Target Data. Environment: Informatica Power Center 9.6, Oracle, AS 400 Mainframe, SQL Server, IBM DB2, Autosys, TOAD, Informatica Power Exchange (PWX)

Client: Valspar, Minneapolis MN Jan 2017 – Sep 2017 Role: Sr. ETL/Data Integration Developer

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.

• Performed source system analysis and designed change data capture CDC / incremental loading technical specifications.

• Extensively used Slowly Changing Dimension, SCD1 to handle the Incremental Loading.

• Cleanse and Scrub the Data in uniform data type and format applying MDM Informatica and IDQ tools.

• Understanding of how the match/merge rules work and also have a working knowledge of how Informatica Data Director (IDD) data governance tool works.

• Prepared standard design documents, Technical Specification, ETL Specifications and Migration documents.

• Maintained daily Tech Tracker/Issue logs for the updates and issues related to objects and progress.

• Performed various performances tuning activities at database level (source, target, Lookup), Informatica level (workflows, mapping and session).

• Designed new and modified existing dimensions and fact mappings for REACH (Registration, Evaluation, Authorization, and Restriction of Chemicals) compliance reporting with building 11i lockouts and sending alerts using Informatica.

• Supporting multiple projects with bug fixes, enhancements and maintaining. Environment: Informatica Power Center 9.6/8.6, Oracle EBS 11i, Oracle 11g, JIRA, OBIEE DAC, Autosys, MDM 9.7.1, IDQ 9.7.1, TOAD 11.5

Client: UCare, Minneapolis MN Sep 2016 – Dec 2016

Role: Informatica/TDM Consultant

• Lead Test Data Management (TDM) activities and build an iterative, repeatable process to create maintain and protect data in non-production environments and helped end to end testing of key business processes.

• Involved in efforts to establish a Test Data Management strategy and roadmap.

• Well versed with Test Data Management activities like Data Provisioning, masking, subsetting, data refresh, data validation, data integrity checks.

• Created and implemented data subset/masking solutions including scope, discovery methods, subset entities, rules and policies, implementation approach.

• Involved in installing and configuring Informatica Power Center 9.6.1 and Informatica Test Data Manager 9.7.1 on Windows environment.

• Responsible for interacting with and business analysts, SMEs, technical architects wherever there is a need for the redesign of the existing ETLs and process improvements.

• Expertise in analyzing the thread statistics such as run time, idle time, busy time in order to tackle performance bottlenecks.

• Responsible for understanding the legacy code written in COBOL and interpret the stored procedures and come up with a plan\architecture to rewrite all of the surround code using Informatica Power Center.

Environment: Informatica Power Center 9.6.1, ILM Data Masking with TDM 9.7.1, TOAD, SQL, PL/SQL, COBOL, Windows Server R2 2012, SQL Server 2012, UC4 scheduler. Client: Valspar, Minneapolis MN July 2014 – July 2016 Role: Sr. Informatica Developer

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production and support for production environment.

• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.

• Created High Level Design and Detailed Design documents.

• Used Informatica PowerCenter 9.6 for extraction, loading and transformation (ETL) of data in the data warehouse.

• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.

• Extracted data from different sources like Oracle, flat files; XML and SQL Server loaded into Enterprise Data Warehouse (DWH).

• Involved in Migration process of moving all the informatica objects from Informatica 8.6 to Informatica 9.6 and in this process building an entirely new enterprise data warehouse (BIW).

• Designed and developed a few stand alone PL/SQL stored procedures for performing various calculations related to fact measures.

• Extensively worked on Data Warehouse Administration Console (DAC) to Configure, Monitor and Schedule ETL routines of Full and Incremental ETL loads.

• Extensive working knowledge with designing columnar databases PADB to support ETL and reporting.

• Cross-functional team member with extensive background working with Supporting QA testing, Integration testing, User Acceptance testing and Production GO-LIVE.

• Used TOAD to execute SQL queries and perform any query tuning etc. UNIX shell scripts to write wrapper scripts to call ETL Jobs, FTP and File-watcher Automation, PMCMD Automation etc. Environment: Informatica Power Center 9.6/8.6, Oracle EBS 11i, ParAccel 4.0, Vendavo PA, Oracle 11g, OBIEE DAC, IBM DB2, Windows server 2003, TOAD

Client: Wells Fargo, Minneapolis MN Sep 2013 – June 2014 Role: Tech Lead/Informatica Developer

• Involved in the Analysis of Physical Data Model for ETL mapping and the process flow diagrams

• Extensively worked on Informatica to extract data from Flat files, Oracle, and SQL Server database to load the data into the target database (SQL Server)

• Created and maintained metadata and ETL documentation that supported business rules and detailed source to target data mappings

• Used Informatica transformations such as the Source Qualifier, Expression, Filter, Aggregators, and Connected & Unconnected lookups, Sequence Generator and Stored Proc. Etc

• Extensively worked on performance tuning of the created mappings, to identify bottlenecks at target, Source, Mapping, Session and System levels and its Optimization

• Designed and developed the sessions for the relevant mapping(s) or Informatica jobs and organized as sequential / concurrent batches.

• Update the status and plan the releases through the scrum meetings.

• Worked with business analysts to identify the appropriate data elements for required capabilities

• Ability to coordinate the flow of development initiatives and Experience in Requirement Analysis, Design, Development, all the phases of Testing like Unit testing, Integration Testing, regression testing, Performance, Acceptance testing.

• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.

• Designed and developed common modules for error checking (e.g. to check if the reject records output file is empty and to check if there are duplicate natural keys in a given table.)

• Performed the tuning at source, Target and informatica mappings using Indexes, Hints and partitioning in DB2, SQL Server and Informatica.

• Scheduled Sessions and Batch Process based on demand, run on time, run only once using informatica Server Manager

Environment: Informatica Power Center 9.5, SQL Server 2008, IDQ 9.5.1, Db2, TOAD, and UNIX Shell scripting

Client: Bank of America, Charlotte NC May 2013 – Aug 2014 Role: Informatica Developer

• Collaborated with Business analysts for requirements gathering, business analysis and designing of the Enterprise Data warehouse.

• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.

• Designed and developed complex aggregate, join, lookup transformation rules (business rules) to generate consolidated (fact summary) data identified by dimensions using Informatica ETL tool.

• Created test cases to cover all possible scenarios in developing ETL code.

• Researched business impact in changing or modifying already existing ETL code.

• Implemented various loads like Daily Loads and Monthly loads using Incremental Loading Strategy.

• Developed Autosys JIL file to automate the task of executing the different workflows and sessions associated with the mappings on the development server.

• Get the code tested and cross validated from testing team and be ready for Production release a week before an RFC complete date.

Environment: Informatica Power Center 8.6, SQL Server 2008, Oracle 11g, Autosys, Windows server 2003, TOAD.

Client: CtrlS, Hyderabad, India July 2010 – July 2011 Role: Informatica Developer

• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds.

• Gather all business requirements by frequently arranging meetings with BA, Source system team and Data Analyst.

• Imported and created source definitions from Oracle and flat files.

• Created Informatica mappings using various transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.

• Involved in designing of testing plan (Unit testing and System testing).

• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.

• Used workflow manager for session management, database connection management and scheduling of jobs.

• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.

Environment: Informatica Power Center 8.6, SQL Server 2008, Oracle 11g, TOAD. ACADEMIC PROJECTS:

CIS Capstone Project Aug 2012 - Dec 2012

• Developed a web application for School Information Management System to help students and faculty enroll in class.

• Successfully retrieved student's information with various parameters

• Created separate modules for different user groups containing their respective functionalities

• Followed the agile methodology and also developed a detailed design document Tools Used: ASP.Net, Microsoft Visual Studio, C#, Microsoft SQL Server 2005 Media Library application Jan 2012 - May 2012

• Developed a UI that connects to a database and allows users to share music and movies by using arrays and sort function.

• The users can also check-in or checkout the media Tools Used: Microsoft SQL server, Eclipse IDE, JAVA Database Management Aug 2011 - Dec 2011

• Developed a relational database for an organization to reduce the health care expenditure on the employees using the Visio.

• Contributed to the entity relationship modeling of the data and implemented user interface navigation forms and SQL query reports in MS Access such that they are sophisticated enough to support the actual use of the database.

Tools Used: MS Access, MS Visio

TECHNICAL PROFICIENCY:

• Programming Languages - JAVA, C#, ASP.NET

• Database/RDBMS – Microsoft SQL Server, MySQL, Oracle 10g, 11i, PL/SQL, UNIX scripting, TOAD

• ETL Tool - Informatica PowerCenter 8.6, 9.6, Informatica TDM, IDQ

• Scheduling Tools: Autosys, Oracle DAC.

• Web Technologies - HTML, XML, XSLT, CSS.

LEADERSHIP ROLES AND PROFESSIONAL ASSOCIATIONS:

• Member of International Student Service Organization.

Contact this candidate