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.
• Has 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 noledge 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 noledgeable 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 SKILLS

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

Development Tools: Informatica 8.x, 9.x, MSBI SSAS, HP Service Manager

Cloud Services: IICS

PROFESSIONAL EXPERIENCE

Confidential

Team Lead

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 liketables, views, materialized views, procedures and packagesusing oracle tools likeSQL Developer.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Created and modified severalUNIX 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.

Confidential

Senior Developer Technology

Responsibilities:

• Involved in preparation of AADD document based on the requirement document.
• Application development dat 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.

Confidential

Senior Developer Technology

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 dat 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.

Confidential

Developer Technology

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

Confidential

Developer Technology

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 dat 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.

Confidential

Developer Technology

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.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.