shruti nayyar Email:  HYPERLINK "mailto:shruti.nayyar85@gmail.com" shruti.nayyar85@gmail.com
Mobile: +1 (949) 701 9163  

PROFESSIONAL SUMMARY
Having 8+ years of experience in IT Industry as a Data warehousing/
Data Architect, and Data Analyst. 
Expertise in Informatica, Informatica B2B, IBM Cognos Report Studio, Development, Implementation and Testing of Database and Data Warehouse applications.
Business Analysis experience throughout the SDLC lifecycle, ranging from requirements elicitation, architecting solutions and implementation, with an alignment to business outcomes.
Data Architect role to design an architecture and data modelling solution to meet the needs of the customer.
Extensive experience in creating database solutions, evaluating requirements, and preparing design reports.
Extensive core experience in Data Integration and Data Migration using Informatica Power Centre and ETL tools. 
Experience in Data Warehouse Development Life Cycle.
Contextual application in domains like Retail, Telecom and Insurance systems.
Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedures.
Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions.
Hands on experience in optimizing SQL scripts and improving performance and loading into warehouse.
Deployed workflows as an application to run them and tuned the mappings for better performance. 
Usage of Informatica mapping variables/parameters and session variables where ever necessary.
Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
Experience in both Agile and Waterfall methodologies.
Working exposure to Informatica Power Center 8.x, 9.1,9.6, Informatica Data Quality 10.1, Data Modelling, Data Warehousing Concepts, Oracle11g,PL/SQL, SQL Server, UNIX, Shell Scripting.
Vast experience in Informatica Mapping design, workflow design, development and scheduling.
Good experience in writing Oracle PL/SQL Stored procedures.
Detail-oriented and result-focused with total commitment to team success, and quality assurance.
Flexible & versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
Proactive team player with capability of handling responsibilities independently as well.
An intelligent and responsible software developer, quick learner, good technical abilities and skills developed by a strong work ethic and self-learning.

TECHNICAL SKILLS
Platforms/ToolsInformatica PowerCenter10.x/9.x/8.x, Informatica Data Quality, Power ExchangeRDBMSOracle 11g/10g/9i, SQL Server 2000/2005/2008Operating System Windows ,LinuxVersion ControlCVSLanguagesSQL, PL/SQL, Unix Shell Scripting, JavaScriptDatabase frontend tools Oracle, PLSQL Developer, SQL Assistant, Oracle TOAD.




WORK EXPERIENCE
Infosys Limited 

Client Name: Horizon Blue Cross Blue Shield
Horizon Blue Cross Blue Shield is a tax paying ,not for profit health service corporation, providing a wide array of healthcare services and offers health information management solutions to millions of its members who are enrolled to their program. 
Project:  Horizon Blue Cross Blue Shield  
The project involves development of new features in their Enterprise Data Warehouse, support and maintenance and enhance their existing features in Enterprise Data Warehouse.
Technologies Used: Informatica Power Center 9.5, IBM Cognos, Oracle 11g, , PL/SQL,  UNIX (Shell Scripting), ILM Tool
Team Size: 15 Members
Roles and Responsibilities:
Requirement gathering & Analysis: Understand the client and project requirement (both functional and non- functional) by studying the existing documentation. Draft and maintain business requirements and align them with functional and technical requirements. Facilitate monthly meetings with clients to document requirements and explore potential solutions.
Translate stakeholder requirements into various different deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
Design: Conduct impact analysis, create design specifications as per the high-level design. Create unit test plans in order to develop/validate/ maintain the application as per the requirements. Design applications based on identified architecture and support implementation of design by resolving complex technical issues faced by the IT project team during development, deployment and support
Team co-ordination and Management Mentor the team on technical competencies , provide performance feedback of individual team member to project manager in order to manage performance
Identify and reconcile errors in client data to ensure accurate business requirements.
Designing and developing multiple complex ETL mappings and workflows.
Develop multiple PL/SQL stored procedures which are then called through Informatica mappings for better performance.
Estimation of time for Coding and Unit Testing.
Performance Tuning the Client?s existing code to reduce the batch execution time.
Performance Tuning for Cognos reports using standard tuning techniques. 
Creating Self-Service capabilities for building Ad-hoc reports.
Building Interactive Executive Dashboards with basic forecasting capabilities.
Defects resolution in any existing jobs and creating of jobs to correct the historical data
Offshore Onshore coordination for the assignment of tasks and getting updates
Supporting downstream data mart application for any data related issues.
Version Control using CVS.


Client Name: Anthem Blue Cross and Blue Shield 
Anthem BCBS. is one of United states leading health benefit companies, serving the need of more than 73 million people through its affiliated companies, including nearly 40 million enrolled in its family of health plans. An independent licensee of the Blue Cross and Blue Shield Association, Anthem is well positioned to deliver what customer want: innovation, choice-based products, distinctive services, simplified transactions and better access to information for quality care.

Project: Claim Application 

The project involves development of Claim application to handle all of Anthem?s claims in various states. It involves migration of claim data from legacy source systems to new Oracle based centralized claim application. Moreover, project involves profiling of data using Informatica Data Quality before the data is migrated to Target Oracle systems. 
Technologies Used: Informatica Data Quality 10.1, Informatica Power Center 10.1, Oracle 11g, UNIX (Shell Scripting), JIRA, PL/SQL.
Team Size: 20 Members

Roles and Responsibilities:
Designing and developing complex ETL mappings and workflows.
Collecting and understanding the business requirements from Client BA.
Analysing requirements and understanding the current system.
Preparing and executing Unit test cases.
Regular interaction with client for status updates
Estimation of time for Coding and Unit Testing.
Performance Tuning the Client?s existing code for business value addition.


Project: WGS Provider Application

The project involves development of Provider application to handle all of Anthem?s providers in various states. It involves migration of provider data from legacy source systems to new Oracle based centralized Provider application. Moreover, project involves profiling of data using Informatica Data Quality before the data is migrated to Target Oracle systems. 
Technologies Used: Informatica Data Quality 10.1, Informatica Power Center 10.1, Oracle 11g, UNIX (Shell Scripting), JIRA, & SMP.
Team Size: 30 Members
Roles and Responsibilities:
Leading multiple agile teams for Informatica Data Quality and Informatica Powercenter.
Reviewing overall Design and Architecture of the ETL Layer.
Following industry standards for code quality and performance metrics.
Ensuring proper code versioning and deployment process is followed.  
Perform Technical design review and code review.
Performing unit testing, support system testing, user testing and performance testing 
Implementing the developed components and supporting post release warranty.
Participating in group sessions to understand complex information on requirements clarification, design sessions, code reviews and troubleshooting issues.


ACHIEVEMENTS AND STRENGTHS
Rewarded with SPOT/Champ awards in Rewards and Recognition Program in Infosys for my contributions in the various Projects during my 8 years tenure.
Received many appreciations from the client for the excellent work in the project.
Organising training sessions on Informatica and ILM Tool for new joiners/freshers.
Actively participated in ARPAN (Social Activity Performed by Infosys).
Published various Artifacts and Reusable component on tools like Finacle within Infosys
Strong analytical skills, working on various data related and reporting issues  as part of Data Warehousing/Business Intelligence
Good communication and team-building skills.

QUALIFICATION DETAILS
Education detailsInstituteYear of passingB.Tech (Electronics And Communication)Institute Of Engineering And Technology ,Bhaddal, Ropar(Punjab)2008