Software Engineer Data

UMA M, DODDI

Hartford, CT

*****.***@*****.*** Mobile: 860-***-****

Objective:

To obtain a consultant position that promotes growth in an environment that I can contribute my safety management and leadership skills and continue to develop experience in a professional community.

Technical Skills

ETL Tools : Informatica Power center, Informatica Data Quality (IDQ)

Databases : Oracle, Microsoft SQL Server

Operating System : Windows, UNIX/LINUX

Products/Tools : TOAD, Appworx. Batch Remediation, Serena Change Manager (PVCS),

SQL Developer, Team Foundation Server (TFS), GitHub

Summary of Qualifications:-

Around 10 years of professional IT experience in Development, Migration, Enhancement, Testing and, Production Support Projects of Data warehousing projects.

Experience in Financial Services, Banking, Manufacturing and Pharmaceutical industry business processes.

7+ years of experience in Informatica Power Center (9.x) in creating complex mappings, sessions, workflows, reusable components in Designer, Workflow Manager using various transformations like Source Qualifier, Unconnected and Connected Lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.,

3+ years of experience in Informatica Data Quality 9.6/9.1 Data Profiling standards and best practices on Process Sequence, Data Quality Lifecycles, Naming Convention and Version Control.

Involved in the full development lifecycle from requirements gathering, low level design, requirements analysis, coding and/or testing through development and production support.

Resolving cross-functional issues at project level and managing project scope and change control and escalating issues wherever necessary.

Extensive experience in Production support which does not limit only to monitoring the Batch jobs, tracking and resolving the incidents and provided solutions on time to the application users but also quick turnaround fixes.

Monitoring the performance of production data loads and initiating action plans to tune the long running data loads.

Provided knowledge transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica.

Coordination between different teams like DBA, Informatica Admin, FTP teams during Load Failures and fixed the issues within timeline.

Improved the performance related to long running jobs.

Achievements:

Got 3 times Spot Award for playing efficient role in the project in Mphasis Limited.

Got Value Appreciation Card for living and displaying the Honoring Commitments in the Project in Mphasis Limited.

Professional Experience:

Mass Mutual Financial Services OSPRO SYSTEMS Springfield, Massachusetts

Technology Lead October 2017 to present

Collect requirements to define project scope, major deliverables, assumptions and constraints. Assisting the technical leads in preparation of project scope statement.

Creation of Work Breakdown Structure (WBS) by visualization of the entire project work, broken down into individual pieces of work, including identifying, control information, detailed information of work attributes, requirements and assumptions.

Work closely with IT professionals throughout the implementation and testing phases, to set up test environments and test data for timely and exhaustive project testing.

Provide overview of application in scope and ensure peer reviews of software work products.

Involved in implementation and delivery projects with high quality.

VERITAS OSPRO SYSTEMS Mountain View, California

Informatica Data Quality Lead May 2017 to October 2017

Requirements Analysis, Design, Development and Testing.

Participating in the project report meetings and provide Functional and Technical support.

Prepare high- and low-level design documents before starting the development phase.

Designing, developing and unit testing.

Involved in Data analysis, data cleansing using various transformations like Standardizer, Labeller, Keygen, Parser transformations etc., data matching, data conversion, address standardization using Address Doctor Transformation, exception handling, reporting and monitoring capabilities of IDQ.

Participating in the Release management, deployment checklist review and Defect management of each release.

First Republic Bank Mphasis Limited EON Kharadi, Pune

Senior Software Engineer April 2015 to April 2017

Requirements Analysis, Design, Development and Testing.

Participating in the project report meetings and provide feedback to the Technical coordinator for further decisions.

Functional and Technical support.

Prepare high and low level design documents before starting the development phase.

Participating in the Peer review related to Design, Code and Unit test cases and monitoring the performance.

Performance tuning for long running queries.

Symantec Corporation Mphasis Limited EON Kharadi, Pune

Senior Software Engineer Oct 2011 to March 2015

Doing Impact Analysis and preparing High Level and Low-Level design documents based on the Business Requirement documents and providing proper estimates for the whole life cycle of the Data Warehousing project.

Reviewing the Code and resolving any technical issues of project.

Ensuring all the Performance Optimization techniques were incorporated while developing the Mappings.

Expertise in performing optimization analysis. Improved the performance of long running jobs by tuning the SQL queries and creating necessary indexes.

Ensuring that all deliverables will be done with high quality on time by following all the processes/standards set by the customer and providing weekly status to the customer.

Mentored/Trained team members in creating different Design documents and other required documentation.

Symantec Corporation Mphasis Limited EON Kharadi, Pune

Software Engineer Oct 2010 to Oct 2011

Designing and developing Informatica mappings to achieve the desired functionality.

Creating mappings according to business needs

Preparing Test cases and test data for Unit testing.

Initiate/Participate in Peer reviews.

Conduct QA Reviews.

Perform QA/UAT migrations and support PROD migration.

Monitoring the Appworx Scheduled jobs and Informatica Workflow monitor to monitor the Production Support jobs.

Handling communication with the business in the event of load failure/system unavailability.

Contact this candidate