Informatica Developer

Anuja Bhaskar

Email: ***********@*****.***

Phone # +1-425-***-****

Profile Summary:

●10 years of IT experience in Analysis, Design, Development, Testing and Implementation of business application in Data warehousing for Healthcare, Retailer, IME, HR and Insurance domain.

●Possess Domain expertise in Insurance.

●Possess technical expertise in Business Requirement Analysis, Business Intelligence, BI Development and Testing.

●Possess technical expertise in aspects of all phases of Agile and Software Development Life Cycle (SDLC).

●Handled large End-to-End projects, to meet their project deadlines, with high level of quality without / with minimal guidance to deliver the project and creating artifacts as needed for the project.

●Have good exposure in requirement gathering and also involved in creation of data models.

●Knowledge of different Schemas (Star and Snowflake) to fit reporting.

●Strong Technical knowledge in ETL tool Informatica on various kinds of development projects and experience in designing ETL applications.

●Experience in other database technologies like Teradata, Oracle, DB2 and SQL Server.

●Experience on Teradata tools and utilities BTEQ, Fast load, Multi Load, Fast Export and TPUMP.

●Experienced in UNIX Shell scripting as part of file manipulation and text processing.

●Knowledge on IICS.

●Knowledge on Bigdata & Hadoop concepts.

●knowledge on AWS, Azure Sql, Azure Data lake,Azure Data Factory.

●Proven track record as a knowledgeable professional with the ability to proactively identify problem areas, develop and implement solutions to meet business needs and goals.

●Self-starter, highly motivated, technically sound, training and mentoring skills in driving development teams to successful resolution.

●A good team player, problem solver and quick learner. Ability to perform at a high level, meet deadlines, adaptable to changing priorities.

●Excellent communication and interpersonal skills.

Technical Proficiency:

DBMS

Teradata, Oracle 10g/11g, DB2, Sql Server

Development Tools

Informatica 8.x, 9.x, MSBI SSAS, HP Service Manager

Cloud Services

IICS

Certification

Teradata 12 Basics (TE0-121)

Teradata 12 SQL (TE0-122).

Academics:

Bachelor of Engineering (Computer Science) from Anna University, Chennai.

Work Summary:

●Cognizant Technology Solutions (June 2014 – Oct 2019)

●HP Global Soft Pvt Ltd (November 2009 – June 2014)

Professional Experience:

Company: Cognizant Technology Solutions

Client: Chubb Personal Insurance, USA March 2017 – Oct 2019

Project: Claims Predictive Modelling

Project Profile:

One of the world’s largest publicly traded P&C insurance companies and the largest commercial insurer in the U.S. With operations in 54 countries, provides commercial and personal property and casualty insurance, personal accident and supplemental health insurance, reinsurance and life insurance to a diverse group of clients.

Role: Team Lead

Technology: Informatica 9.x, IICS, oracle, DB2, Sql server.

Roles & Responsibilities:

●Involved in business requirement analysis and prepared functional requirement documents.

●Involved in the ETL technical design discussions and prepared ETL high level technical design document.

●Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.

●Involved in Preparation of code and development of mapping and workflow.

●Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like SQL Developer.

●Created indexes on the tables for faster retrieval of the data to enhance database performance.

●Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements

●Extensively Implemented Error Handling Concepts, Testing, Debugging skills and Performance tuning of targets, sources, transformation logics.

●Expertise in doing the RCA (Root Cause Analysis) and resolving performance bottlenecks and enhance for optimization of the mappings, sessions and workflows.

●Also worked on creating mappings in IICS cloud data Integration and executed the same.

●Performed Unit testing and validated the data.

●Migrated the code into a higher Environment.

●Resource capacity planning & Work breakdown structure preparation for the team.

●Allocating tasks to offshore team members and tracking status.

●To Perform Technical Review and prepare Review checklist.

●To Ensure Overall quality of the deliverables.

●Planning intermediate milestones for each track.

●Bringing up issues/risks on the week deliverables in the beginning of the week.

●Prepare Discussion notes for the day meeting with onsite counterparts and share the notes to the team.

●Every Friday, Preparing Weekly WSR and sharing it with the Onsite and Manager.

●To Update Project Milestone Dashboard every month.

●Attended audits for all the Tracks & Sub Tracks.

●Manage issues/concerns within the team.

Company: Cognizant Technology Solutions

Client: Liberty Mutual Insurance, USA Sep 2016 – Feb 2017

Project: Commercial Insurance Daily Operational Reporting (CIDOR)

Project Profile:

CIDOR (Commercial Insurance Daily Operational Reporting) is an expansion of the existing BIDOR (Business Insurance Daily Operational Reporting). The BIDOR effort gathers and presents business insurance market pre-issuance and policy data for reporting. With the CIDOR expansion effort, national insurance data will be added to the mix to present a complete view of Commercial Insurance for reporting of pre-issuance and policy activity.

Role: Senior Developer

Technology: Informatica 9.x, Teradata, oracle.

Roles & Responsibilities:

●Involved in preparation of AADD document based on the requirement document.

●Application development that enables data to be moved from legacy systems and external data sources into a staging area for the transformation effort to final data load into the Enterprise data warehouse, the tools extensively used were Multiload, Fastload and BTEQ.

●Involved in Preparation of code and development of mapping and workflow.

●Worked extensively on different types of transformations like Update Strategy, Look Up, Filter and Router Transformations.

●Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations.

●Developed Mapping to load data in Slowly Changing Dimensions.

●Explored ways to optimize existing ETL processes and enhance their performance.

●Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.

●Performed Unit testing and validated the data

●Migrated the code into QA & Production.

●Participated in onsite team meetings and maintained project trackers.

Company: Cognizant Technology Solutions

Client: Disney, USA June 2014 – August 2016

Project: Consumer Products

Project Profile:

An American diversified multinational mass media corporation Burbank, California. Delivers innovative and engaging product experiences across thousands of categories from toys and apparel to books and fine art.

Role: Senior Developer

Technology: Informatica 9.x, Teradata, oracle.

Roles & Responsibilities:

●Involved in preparation of AADD document based on the requirement document.

●Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

●Strong hands on experience using Teradata utilities SQL, B-TEQ, Fast Load, Multiload and Unix Shell scripting.

● Involved in Preparation of code and development of mapping and workflow.

●Developed several reusable transformations and mapplets that were used in other mappings.

●Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.

●Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.

●Extensively using Transformations like Router Transformation, Aggregator Transformation, Source Qualifier Transformation, Joiner Transformation, Expression Transformation and Sequence generator Transformations.

●Extensively used workflow variables, mapping parameters and mapping variables.

●Modified existing mappings for enhancements of new business requirements.

●Performed Unit testing and validated the data

●Conducted code reviews developed by my teammates before moving the code into QA.

●Prepared migration document to move the mappings from development to testing and then to production repositories.

●Migrated the code into QA (Testing) and supported QA team and UAT (User).

●Participated in internal and onsite team meetings and maintained project trackers.

Company: HP Global Soft Pvt Ltd, Chennai

Client: Procter & Gamble, USA April 2013 – May 2014

Project: IZOOM Store

Project Profile:

An American multinational consumer goods company headquartered in downtown Cincinnati, Ohio, United States. Its products include pet foods, cleaning agents, and personal care products.

Role: Developer

Technology: Informatica 9.x, oracle.

Roles & Responsibilities:

●Responsible for all activities related to the development, testing and support of ETL processes for large scale data warehouses using Informatica Power Center.

●Analyzed the business requirements and functional specifications.

●Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.

●Performed Unit testing and validated the data.

●Prepared migration document to move the mappings from development to testing and then to production repositories.

●Played Tester role in QAT Phase.

●Creation of test plan, test strategy and test approach.

●Participated in the Integration testing and Unit Testing.

●Performed Manual and automated E2E testing.

●Extensively used SQL scripts/queries for data verification at the backend.

●Performed negative testing to test the application for invalid data, verified and validated.

●Monitor the testing project in the Quality Center and ensure defects are being entered, tested, and closed.

●Analyzed, documented and maintained Test Results

Company: HP Global Soft Pvt Ltd

Client: CVS Caremark,USA May 2011 – March 2013

Project Profile:

Fully integrated pharmacy health care company in the United States. Their offerings across the entire spectrum of pharmacy care allow them to provide greater convenience and choice for patients, improve health outcomes, and lower overall health care costs for plan sponsors and participants. As one of the country’s largest pharmacy benefit managers (PBMs), they provide plan sponsors and participants access to a network of approximately 60,000 pharmacies including more than 7,000 pharmacy stores.

Role: Developer

Technology: Informatica 9.x, Teradata,oracle.

Roles & Responsibilities:

●Analyzed Source Systems, business requirements and identified business rules for building the data warehouse.

●Involved in preparation of AADD document based on the requirement document.

●Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

●Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create mappings in the Informatica Power Center Designer

●Developed several reusable transformations and mapplets that were used in other mappings.

●Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.

●Extensively used workflow variables, mapping parameters and mapping variables.

●Involved in Analyzing/building EDW using Teradata ETL utilities and Informatica.

●Strong hands on experience using Teradata utilities SQL, B-TEQ, Fast Load, MultiLoad, FastExport and Unix Shell scripting.

●Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.

●Responsible for Collect Stats on FACT tables.

●Modified existing mappings for enhancements of new business requirements.

●Performed Unit testing and validated the data.

●Conducted code reviews developed by my teammates before moving the code into QA.

●Prepared migration document to move the mappings from development to testing and then to production repositories.

●Migrated the code into QA (Testing) and supported QA team and UAT (User).

●Played Tester role in QAT Phase.

●Creating Test plan/ Test Strategy for the projects.

●Performed DW Testing by Analyzing the Source and Target data using data validation, Constraint testing, Record count, Field to field testing.

●Developing Test Conditions based on technical documents, business rules, etc.

●Testing the data warehouse for initial and incremental load.

●Validating the data after transformations.

●Defect Reporting & Retesting and performed Regression Testing using Quality center.

●Creation of Review records and Documentation.

●Scheduled the jobs using an auto sys scheduler.

●Monitor all production issues and inquiries and provide efficient resolution for the same.

Company: HP Global Soft Pvt Ltd

Client: HP Global Soft May 2010 – April 2011

Project: HR Analytics

Project Profile:

HR Analytics was developed and maintained for PSG (Personal Systems Group), IPG (Imaging and Printing Group) & ESS (Enterprise Sales Services). The Project is used for making strategic decisions

Role: Developer

Technology:Microsoft Sql Server

Roles & Responsibilities:

●Involved in Requirement Gathering and Participation in Client Discussions.

●Understanding the Application Functionality and Business Requirements.

●Analyze the existing Business Process and Identify the GAP.

●Involved in monthly data loading for PSG, IPG and ESS.

●Responsible for the creation and maintenance of Analysis Service objects such as Cube, Dimensions.

●Created a report model on SSAS cubes.

●Understanding the client expectation and providing reporting solutions.

●Participation in weekly conference calls with clients to track ongoing issues.

●Providing tool usage reports on a weekly and monthly basis.

●Preparation of various Plans and Quality Reports for the Project.

●Guiding Newly Joined Team Member

●Allocating, tracking work for the team member, handling issues and queries.

Company: HP Global Soft Pvt Ltd

Client: Patni Computer Systems February 2010 – April 2010

Role: Technology consultant

Roles & Responsibilities:

●Responsibilities include understanding of Client Requirement.

●Involved in conducting a workshop on Service Manager 7.11 to effectively use ITIL Process in customer’s environment.

●Responsible for Installation and Configuration of Service manager 7.11

●Focus on configuration of application components:

●Interaction Management

●Incident Management

●Problem management

●Involve in project documentation.

Contact this candidate