Informatica with Salesforce

***** **** ******* ***** *** ***, Lonetree, CO - *0124 C: +1-678-***-**** *******@*****.***

Summary

Skills

Experience

Technology Analyst with 9.3 years of work experience leading cross-functional teams and completing projects on-time. Seamlessly manages workload to meet deadlines.

Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, training, implementation and post-implementation review.

Worked in different cycle of testing starting from UNIT testing, System Integration tests, User acceptance testing, Implementation Completeness tests and Regression Testing.

Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental loads using Informatica.

Worked on various versions of Teradata, Oracle and Informatica power center for a period of 9.3 years.

Experienced in doing analysis based on the User data having functional domain knowledge of Banking Systems.

Worked Closely with Business Clients and Business Analysts in Preparing Business Documents.

Worked in Waterfall and Agile Methodologies.

Extensively worked with large Databases in Production environments.

Proficient in understanding business processes / requirements and translating them into technical documents.

Experienced in doing analysis on data and prepare Business requirement documents.

Has very good communication skills and is a good team player. Agile Environment, Performance Management, Quality, Risk Assessment, Data Warehouse, DBMS, Designing, DOS, Windows 2000, Windows XP, Windows 7, ETL, Informatica Power Center 9.x/10.x, PL/SQL, ORACLE, Teradata, Unix Shell scripting, ESP Scheduling, PRODUCTION Support, Technical Business Analyst.

Technology Analyst

Infosys Technologies Ltd - Denver, CO

Project Details

Data Migration from Siebel to Salesforce.

Client: Top National Brokerage and Bank, CO

Environment: Informatica, Oracle, UNIX

Role: Individual Contributor

Apr 2016

Responsibilities in this project involved in analyzing and designing the end-to- end process flow.

Involved in the huge data migration from Siebel to Salesforce. Decommissioned a twenty yearlong legacy system by doing this data migration to the cloud based application system. Has a very rich knowledge about the whole scope of this migration.

Key player for this migration of data for many Salesforce objects.

Responsibilities also included preparation of design document, team management, maintaining trackers, development, and review process, preparation of Defect Analysis & Release Manual documents, Onsite-Offshore coordination, and Client interaction and implementation support.

Technology involved were Informatica, Oracle and UNIX Responsible for Developing, Migrating, Enhancing, Maintaining and Fixing the Code in PRODUCTION Environment on Brokerage/Bank Enterprise Data Warehouse on Oracle Environment.

Performed Module Lead Role of Managing 5 people and Code Reviews.

Performing data loads which are available in multiple Forms in multiple sources to Oracle Warehouse system which is a part of a centralized database.

Analyze data loads, Perform Report Generation with Load Summary.

Report back to Clients on data Changes, Data Quality and Integrity between Multiple Source Systems.

Performing Automated Review Checklists to ensure Bank's Data is valid and available for Down Stream Applications.

Has a thorough knowledge of extraction of huge sets of data from Salesforce using the PK Chunking approach.

Information Layer Portfolio

Client: Top National Bank, Denver, CO Aug 2014

Environment: Informatica, Teradata and UNIX

Responsibility in this project involved in Designing, Managing and Reviewing the end-to- end process flow.

Responsibilities also included Business and Architecture Design document, team management, maintaining trackers, review process, preparation of Defect Analysis & Release Manual documents, Onsite-Offshore coordination, Client interaction and implementation support.

Technology involved in this project includes Informatica, Teradata, UNIX and ESP.

Performed as a Team Lead Role and Managed 10 People and Reviewed Process of the Project in Agile Methodologies.

Actively involved in SPRINT Planning, Story Creation and Grooming with Business and Technical Business Analyst.

Project Overview: Worked on Information Layer ETL project, which is Accounts and Transactions project. This project involved in collaborating and transforming the data which is available in multiple forms in multiple sources to Teradata system.

This Project Database in TERADATA that will be used as Single point of data access for the entire Bank reviewing by Project and HR Managers, thus avoiding redundant/multiple third party tools used inside the bank.

Performing Monthly, Quarterly and Yearly Loads in PRODUCTION Environment and acting as BAU Lead too.

Accomplishments

Education

1. Certification on Retail Banking Basics (Consumer Lending) 2. Certification on Introduction to Retailing.

3. Certification on Sustainable Development: Inculcating Citizen Behavior 4. Completed all the Behavior trainings by Harvard Manage Mentor. Master of Business Administration, Engineering Management 2014 M.B.A University/Institute: - Coventry University / Coventry, KA, INDIA Bachelor of Engineering, Computer Science 2008

B.E University/Institute: - Vijayanagar Engineering College / Visvesvaraya Technological University, BELGAUM, KA, INDIA

Additional Information

1. Awarded with 'INSTA AWARD' during the tenure with Banking Projects. 2. Awarded with Excellence Award and Rating during the Year of 2014-2015. 3. Awarded with Excellence Rating during the Year 2016-2017. 4. Received many accolades and kudos from the clients for the splendid work performance in the work tenure.

5. Conducted many educational drives for school children to ignite the spark in them at the right stage of their life.

6. Organized sanitation and health awareness drives in rural parts of India.

Contact this candidate