Anurima Sandhu **** Barlby Drive, Indianapolis, IN

Cell: 317-***-****

Email: acvu5s@r.postjobfree.com

Profile

IT professional with more than 7 years of exceptional work experience in ETL Development, Data warehouse designing, Data Quality, Business Intelligence, Business Analytics and Team Management of Pharmaceutical domain.

Technical Skills

ETL & DQ

Database

Languages

Reporting

Other

Informatica Powercenter Designer, Workflow Manager and Workflow Monitor 8.x, 9.x,

Informatica Data Quality 9.x,

Informatica Metadata Manager

Oracle 9i, 10g, 11g,

SQL Server

SQL,PL/SQL, Unix Shell scripting, PERL scripting

Tableau,

MS Office products

SQL Developer, Toad, Service Now, Remedy

Executive Summary

Results-oriented professional with over 7 years of visible achievements in both customer-driven and technical roles; facilitated development of Business Intelligence/Data Warehouse systems; provided BI expertise, designed and developed data models by translating user requirements into data flows and data mappings.

Experienced with the lifecycle of Data Warehousing right from requirement gathering, business analysis, writing technical design/architecture, creating technical specifications, development, writing test cases, migration, performing unit / system / integration / load / performance testing and deployment to production.

Successfully implemented ETL projects using Informatica Powercenter 8.x,9.x.

Informatica Data Quality expert with sound experience in enforcing the data quality practices, profiling of the data sources, identifying data quality issues and using data quality transformations to cleanse the data.

Experience in performance tuning Informatica Powercenter ETL programs, and evaluating bottlenecks at the database and Informatica code level.

Good experience in PL/SQL development and SQL tuning.

Proficient in UNIX Shell and PERL Scripting.

Participated in many in-house projects (POCs) to evaluate client requirements and establish best practices for the organizations’ Data Warehousing / BI systems.

Strong understanding of ETL Data flow, Data patterns and Data governance.

Extensive experience in performing Unit Testing, System Integration Testing, UAT and Production Support activities.

Thorough knowledge of Dimensional Data Modeling Concepts – (Star and Snowflake schema) and Data warehousing methodologies.

Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

Experience in leading and mentoring teams from one location / across geographies.

Domain expertise in Pharmaceutical and Workforce area.

Project Details

Working as architect for providing BI solutions for the distribution of the master data across various departments in the organization through data subscriptions using the latest BI tools.

Meeting with the business users and stakeholders to gather requirements and translating these business requirements into technical specifications and design documents for ETL code development.

Interacting with upstream system architects, developers and program managers to resolve data issues and drive capture of data needed by business customers.

Conceptualized and implemented consolidation of more than 100,000 Configuration Items, significantly enhancing client’s service management capabilities and improving quality of data.

Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.

Providing guidance on Data Quality principles and methodologies and delivering solutions around the same to ensure better quality of data.

Using Informatica Data Quality tool to perform Data Quality Checks and cleanse the incoming data feeds.

Profiling the source systems data as per the business rules using Informatica Data Quality tool to identify the anomalies and current state of the source data on data quality parameters.

Extensively used Informatica PowerCenter tools like Source Analyzer, Transformation Developer, Mapping Designer and Mapplet Designer and a variety of Informatica PowerCenter transformations such as expression, joiners, filter, lookup, router, aggregator, normalizer, union etc in Informatica mappings.

Extensive experience in debugging Informatica mappings using Session Logs, Reject Files, and Session Logs from Workflow Monitor and Informatica’s metadata repository.

Developed reusable code snippets - Mapplets and Transformations in Informatica.

Designing various mappings and mapplets using different data quality transformations such as address validator, key generator, matching, labeler, standardizer, parser and lookup.

Providing technical leadership, mentoring throughout the project life-cycle, developing vision, strategy, architecture and overall design for assigned domain and for solutions

Ensured periodic analysis of production support issues and the RCA.

Leading the project with overall leadership responsibility for project architecture and design.

Assist the offshore team in the development, configuration and modification of integrated business and enterprise solutions for data distribution across the organization using ETL tools such as Informatica.

Education

Graduate Certificate in Business Analytics, Indiana University, Bloomington, IN [ Mar’14-Jul’15]

Introduction to Business Analytics, Data mining for Business Intelligence, Simulation & Optimization for Business Analytics, Data Warehousing and Visualization, Developing Value Through Business Analytics Applications

Bachelor of Tech in Computer Science and Engineering, GGSIP (Delhi State) University, Delhi, India [Aug’04 – May’08]

First Class with Distinction; Scored 80.2% overall.

Certifications and Achievements

April 2016 PowerCenter Data Integration 9.x:Developer Specialist – Informatica

Oct 2011 ITIL version 3 certification- ITIL certification management board, India

Feb 2010 PL/SQL training – TCS Noida, India

2 ‘Star-of-the-Month’ and three ‘On-the-Spot’ awards in TCS for distinguished performance

Member of Toastmasters Club International from 2011-2013.

Active member of ‘Maitree’ – corporate social responsibility group at Tata Consultancy Services

Aug 2009 conducted Informatica boot camp- TCS Noida facility in India

Personal Details

Date of Birth July 30, 1986

Nationality Indian

Visa H1B visa stamping expiring Feb 28, 2017 (Can be extended up to Feb 28, 2019)

Contact this candidate