Manager Data
Resume:
YASODA AYYANKALA
Hartford, CT
******.***@*****.*** Mobile: +1-925-***-****
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.
Summary of Qualifications:
14+ years of industry experience, strong expertise in enterprise architecture, design & development of multiple solutions in distributed technologies using Informatica.
Having IT experience in Analysis, Design, Development, Testing and implementation of various Data Analytics, Data Integration/Migration, Data Warehouse, Data Architecture/Modelling, Near Real Time Data Integration and Data Quality Projects.
Experience in Banking, Insurance, Manufacturing, Pensions and Automotive domain projects.
Worked on Data Integration and Data Warehousing projects, Informatica Upgrade (from version 8.6 to 9.5.1) from end to end starting from accepting Business requirements, Data Analysis, preparing Data Model, created Functional and Technical Design documents, estimation, development and review.
9+ 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 SQL Transform, Source Qualifier, Unconnected and Connected Lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Normalizer, Java, XML, Stored Procedure etc.,
3+ years of experience as an Informatica MDM developer in MDM Hub Configuration, creation of landing tables, staging tables, base objects.
Configuring Trust and Validation Rules, Match and Merge setup, Data Manager, Merge Manager, hierarchies, foreign-key relationships, lookups, queries and packages, IDD Configuration.
3+ years of experience in Informatica Data Quality, IDQ 9.6/9.1 Data Profiling standards and best practices on Process Sequence, Data Quality Lifecycles, Naming Convention and Version Control.
Experienced in creating complex quality rules, designed, developed and implemented patterns with cleanse, parse, standardization, validation with ETL and creating reference tables.
Experienced in creating Cleanse functions, Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
Experienced in coding SQL Queries (Analytic Functions, SQL joins, Nested Queries, Unions, Multi-table joins), PL/SQL, Procedures and Functions
Experienced writing UNIX shell scripts/commands and modifying the shell scripts as per the business requirements.
Exposure to Informatica Power Exchange for CDC, SAP NetWeaver and other connectors.
Worked on Dimensional modelling in creating Star and Snowflake Schemas and created slowly changing (SCD) Type I/II/III dimension mappings.
Strong knowledge in Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, COBOL files, VSAM files, XML Files, CSV Files, Oracle, Siebel, DB2 and SQL SERVER.
Expensive experience in Production support process in loading data, monitoring the Batch jobs, tracking and resolving the incidents and provided solutions on time to the application users.
Experienced in finding the root cause for Batch Job failures, reviewing Logs, Health Checks, raising the incidents, resolving the issues by coordinating with the respective teams.
Experience in scheduling the batch jobs using Workflow Monitor, Control M and Approx. third party tools.
Experienced in working Agile Methodology.
Good experience in performing/supporting Unit testing, System Integration Testing (SIT), UAT testing for all the Power Center and Developer objects.
Hands on experience in identifying bottlenecks in various levels like Sources, mappings and sessions and tuning them. Hands on experience in optimizing SQL scripts and improving performance of databases.
3+ years of experience in designing, coding Mainframes COBOL, JCL programs in reading and writing data to the VSAM files to IBM DB2 tables and vice versa.
Experience in preparation of various project related Documentation (high-level & low-level Functional/Technical design documents, Unit Test plans, Migration Documents, Rollback Plan documents, System Performance strategy plans etc.,)
Collaborated with onsite teams and managed various offshore teams.
Well experienced in coordinating different functional groups (DBAs, System Admins, Business teams, QA and Support teams) in providing the solutions for the issues/tickets raised on time.
Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
Professional Experience:
Mass Mutual Insurance and Financial Services Infosys Limited Springfield, Massachusetts
Technical Lead January 2016 to present
Project: SPARC DRC ReWrite
Description: Mass Mutual is a financial company which sells Investment Products and other financial products. It has different Line of Business (LOB) Loads the data coming from different Feeds into Enterprise Warehouse and then creates Data Marts and then creates reports out of it. The work in this project is related to modernization of legacy mainframe platform Enterprise data warehouse and SIERA data mart.
Roles & Responsibilities:-
oUnderstanding requirement for new business growth and new datacenter infrastructure.
oAnalyzing and recommending the changes required in the current systems.
oTranslation of business requirements into High Level and detailed level design.
oEvaluating and identifying various technologies available to meet the requirement.
oPreparing System Architecture and detailed design.
oUnderstanding the Source Feeds data and creating mapping documents to load the data into Warehouse.
oCreating the Data marts from the Warehouse and populate the mart data onto Dashboards and further use them for reporting purpose.
oSending the Warehouse data to different down streams like Broadridge etc.,
oWorking on creating mapping documents, Coding, Unit Testing, review of the data loaded to warehouse.
oCreating all the required Power Center objects, bteq scripts, DDL scripts in all the DEV, QA environments.
oCreated deployment groups for production migration (mappings, workflows, parameter files, SQL scripts and UNIX scripts and supported post-production support.
oDoing end to end testing in all the 3(DEV, QA, PROD) environments to ensure that code is working properly in all the environments.
oCreating Migration documents, Roll back Plans, Release plan and Production support documents.
oParticipated in code and design reviews and also used check style tool for code quality improvements.
oImplementing the full-fledged Agile methodology with Sprint Releases every month
oDaily updates to the Customer on the deliverables of the project and documenting everything.
oCoordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project
oCoordinate with Offshore Team.
AVIVA Wipro Technologies Hinjewadi, Pune
Technical Lead March 2014 to December 2015
Project: TARDIS Integration Application
Description: AVIVA is an Insurance project, in which Wipro deals with Life Insurance part. TARDIS (Transparent Actuarial Database Insight System) holds the AVIVA Life Insurance Actuarial Data. AVIVA has different source feeds like P1L70, Administrator BPA, Admin DC, Paymaster and Unisure. These feeds will be loaded first into Staging, PAD (Persistent Actuarial Data store – Data Warehouse) and then loaded to MPF files, Prophet Results and then finally into FSA and ASPPFM data marts.
Roles & Responsibilities:-
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.
Involved in Designing, Developing, Unit testing and System Integration testing of Mappings, Workflows, Sessions to achieve the desired functionality and involved in monitoring and administration of all the components for a Data warehousing project.
Profiling the Data Sources and creating Score cards using IDQ Developer and Analyst Tool.
Involved in Data analysis, data cleansing, data matching, data conversion, address standardization, exception handling, reporting and monitoring capabilities of IDQ.
Designing, developing and unit testing of Power Centre Workflows, Sessions, Mappings, IDQ mappings and running the Sessions to achieve the Data Integration for near Real Time.
Experienced in creating tasks in the workflow manager and exported the IDQ mappings to the Power Center.
Experience in creation and maintenance of Customer and Product Domain solutions using Informatica MDM.
Experienced in Hub Configuration and creating Mappings for Stage Jobs in MDM Hub Console.
Configuring Landing Tables, Staging Tables, Base Objects, Lookup.
Setting up Trust and Validation Rules, Match and Merge Setup, IDD configuration, Data Manager, Merge Manager, setting hierarchies, relationships.
Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.
Identified and eliminated duplicates in Source Feeds using MDM base objects.
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 set by the customer and providing weekly status to the customer.
Mentored/Trained team members in creating different Design documents and other required documentation.
MAZDA Wipro Technologies Hinjewadi, Pune
Technical Lead August 2013 to March 2014
Project: Data Migration / Data Integration for Mazda
Description: MAZDA is an Automobile manufacturing company. MAZDA USA Siebel currently using Epiphany system to provide Customer Support for all its customers. Now MAZDA wants to use Siebel Database to provide customer support. So whatever data currently the Epiphany system is holding need to be migrated to Siebel Database and also ensure that future data also loaded to Siebel Data base..
Roles & Responsibilities:-
Analyzing the requirements, preparing Physical solution design document based on Logical solution design document and technical specs based on the functional specs.
Responsible to ensure that the goals of the business with regards to Data Migration and Data Integration are met.
Profiling the Data Sources and creating Score cards using Developer and Analyst Tool.
Involved in Data analysis, data cleansing, data matching, data conversion, address standardization, exception handling, reporting and monitoring capabilities of IDQ.
Designing, developing and unit testing of Power Centre Workflows, Sessions, Mappings, IDQ mappings and running the Sessions to achieve the Data Integration for near Real Time.
Experienced in creating tasks in the workflow manager and exported the IDQ mappings and executed them using the scheduling tool, Control-M
Analysis, development, QA implementation, monitoring and administration of the ELT process.
Preparing test cases and test data for Unit testing based on the technical specs.
Migration of code to various environments of SIT, UAT and Production.
Expertise in performing optimization analysis. Improved the performance of long running jobs by tuning the SQL queries and creating necessary indexes.
Symantec Corporation Mphasis Limited EON Kharadi, Pune
Module Lead July 2009 to August 2013
Project: Data Migration / Data Integration for Mazda
Description: Symantec helps consumers and organizations secure and manage their information-driven world and get it provides security, storage and systems management solutions to help customers secure and manage their information-driven world against more risks at more points, more efficiently than any other company..
Roles & Responsibilities:-
Analysing the requirements, preparing Physical solution design document based on Logical solution design document and technical specs based on the functional specs.
Designing, developing and unit testing of Informatica mappings, mapplets, sessions, workflows and worklets to achieve the desired functionality using Power Center.
Involved in Data Profiling, Data analysis, data cleansing, data matching, data conversion, address standardization, exception handling, reporting and monitoring capabilities of IDQ.
Designing, developing and unit testing of Power Center Workflows, Sessions, Mappings, IDQ mappings and running the Sessions to achieve the desired functionality.
Experienced in creating tasks in the workflow manager and exported the IDQ mappings to Power Center and executed them using the Workflows.
Extract CDC data using Informatica Power Center.
Experienced in Hub Configuration and creating Mappings for Stage Jobs in MDM Hub Console.
Configuring Landing Tables, Staging Tables, Base Objects, Lookup.
Setting up Trust and Validation Rules, Match and Merge Setup, IDD configuration, Data Manager, Merge Manager, setting hierarchies, relationships.
Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.
Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings.
Improved the performance of long running jobs by tuning the SQL queries and creating necessary indexes.
Department of Work and Pensions (DWP) Mphasis Limited Magarpatta City, Pune
Senior Software Engineer July 2007 to July 2009
Project: Social Fund and Computer Systems (SFCS)
Description: Department for Work and Pensions (DWP) is a UK Government Project. It deals with various Fund systems like SFCS, JSAPS - ESA, CA, DLA, ISCS, etc.The Social Fund Computer System (SFCS) supports the processing and payment of Social Fund awards. SFCS exists to facilitate the payment of the discretionary awards BL, CL, CCG, and the regulatory awards MP and FP facilitate the recovery of BL’s, CL’s and FP’s. The scope of SFCS is to bestow awareness in the reader of all functions within SFCS and allowing impact analysis at a high level for any amendments or new functionality.
Roles & Responsibilities:-
Understanding SFCS application and mapping requirements to the Functional and Technical changes for the Application.
Designing Functional and Technical documents and involved in all phases of the SDLC cycle.
Estimating, Distribution of Work among the team, doing reviews and coordinating with Onsite and the customer identifying the requirements and resolving the issues.
Setting up the Weekly Status calls, updating the status of the work and completing the work on time.
Overseeing the Quality procedures related to the project and performed quality audits to ensure standards, procedures and methodologies are being followed.
To coordinate with System testing team to identify testing requirements and identifying the environmental setup required and executing the Cases.
Coding and performing Link testing in EIT services.
Review of Best Shore design and code.
American Express Syntel Limited Nigdi, Pune
Software Engineer Sept 2005 to May 2007
Project: Amex Pay Store Rev Engineering S3P2 Environment
Description: American Express is one of the world's largest travel agencies, and is as well-known for its famous charge Cards and revolving credit cards. This is a Reverse Engineering Process in which firstly it was developed in AS400, Cool:Plex. Now they want to change it to Java- Mainframe Technology.
Roles & Responsibilities:-
Understanding the requirements and mapping requirements to Functional and Technical changes in the Application. Coding as per the design documents.
Understanding the requirements, preparing Flow charts as per the AS400 code and prepare the Design documents and reviewing.
Created flow charts in MS Visio.
Preparing Test Cases, executing the cases and logging the defects using Quality Centre tool, Test Director.
Overseeing the Quality procedures related to the project and performed quality audits to ensure standards, procedures and methodologies are being followed.
Performed System and Integration testing and review of the Test cases and its execution.
Academic Qualification
Jawaharlal Nehru Technical University, India Bachelor of Technology (ECE) 2003
Certifications / Professional Awards:
Got Best Key Player Award for 2 times, for the best performance in making Deliveries efficiently in Infosys Limited in the month of November 2019 and August 2020.
Received STAR TEAM AWARD in Aug 2015, for the best performance in making Deliveries efficiently in Wipro Technologies.
Got Spot Award for 2 times for playing efficient role in the project in the months May ’09 and December ’12 in Mphasis.
Received Key Employee Reward Plan for the best performance in the Team in September ’09 in Mphasis
Date of Birth: 07-04-1982
Contact this candidate