SUMMARY:

• Over 8 years of total experience in Planning, Analysis, Development and Implementation of Business Intelligence(Reporting & Analytics)/Data warehousing(DW) methodology for supporting data transformations as per the Business requirement.
• Worked as Project Manager, Senor Business Analyst, Data Analyst, Subject Matter Expert(SME), Data warehousing Consultant and Business Intelligence Expert with different companies in variety of Domains (Manufacturing, Telecom, Healthcare & Insurance and Finance)
• Experience in mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.
• Experience with Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager.
• Experience with all components of mapping designer such as Source Analyzer, Warehouse Designer, Transformation Developer, Maplet designer.
• Experience in Performance Tuning of Sources, Mappings, targets and sessions.
• Strong skills in development of mappings, documentation, implementation and enhancement of ETL strategies.
• Experience in designing and developing complex mappings applying various transformations such as Source Qualifier, Expressions, Sorter, Router, Filter, Aggregator, Joiner, Connected and Unconnected Lookups, Sequence Generator, Rank, Update Strategy and Stored Procedure.
• Experience in Databases like Oracle 11g/10g/9i/8i and MS SQL Server 2008/2005/2000 .
• Familiar with Ralph Kimball and/or Bill Inmon methodologies and Automation of ETL Processes with scheduling tools and exception - handling procedures.
• Used pmcmd, mailx command to executed jobs from UNIX platform.
• Involved in design of Dimension Models, Star Schemas and Snowflake schemas.
• Programming skills using PL/SQL and Shell Scripts. Creation of scripts for collection of statistics, reorganization of tables and indexes and creation of indexes for enhancing performance for data access.
• Experience with the design and development of Tableau visualization solutions.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Design and Development of Dashboards using Tableau for various organizational metrics and indicators using industry standards and best practices.
• Collaborate with the business on identifying the best way to present the data.
• Maintain Tableau reports & analysis and work on enhancements to existing reports or creating new reports based on business needs.
• Support team and end-users as a Subject Matter Expert (SME) through troubleshooting, recommendation solutions and identifying opportunities to solve business problems through BI.
• Coordinated with business users and team members to resolve data quality related issues.
• Production support and fix the problem by understanding its priority.
• Experience of application study, systems analysis, design, development, testing, implementation, maintenance and business analysis.
• Clear understanding of Business Intelligence and Data Warehousing Concepts.
• Experience in Performance Tuning of sources, mapping, targets, sessions, and database. Ability to understand the available technology, tools and existing designs, and work on complex problems.
• Experience in Enterprisedata modeling.
• Extensive experience in leading teams on all phases of software development life cycle including gathering, managing and documenting requirements, supporting development, and testing teams using Waterfall, Rational Unified Process (RUP) and Agile methodologies. StrongProjectManagement skills. Proficient with Microsoft (MS)Project, and in managing schedules, milestones, and resources. Proven track record of team coordination. Proficient in creating Unified Modeling Language (UML) diagrams such as Use Cases, Activity,
• State Chart, Sequence, Collaboration, Deployment,DataFlow (DFDs), ER and screen mock - ups
• (Wireframes) using MS Visio and Rational Rose. Efficient in communicating with the business units and technical groups. Managing and translating information into business requirement and functional specification documents. In-depth experience in leading QA & UA functional testing activities including development of
• Test Plans & Test Cases. Sound knowledge of SQL Server and MS technologies. Participated in process improvement, change management, and process reengineering activities. Ability to work independently and in a cross-functional and multi-vendor team environment and/or interface with business users, developers, production support groups,projectmanagers, and senior management(SVPs & VPs) located at multiple locations. Resourceful, fast learner with a proven ability to inspire, and lead teams. Dynamic self-starter, creative, enjoy challenges and with effective presentation skills.

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 9.0/8.x/7.x, Informatica Data Quality "IDQ" & Data Transformation Studio (DTS), SSIS, MDM

Informatica Analsyt & Informatica Address Doctor.

Database: Oracle 11g, 10g/9i/8i, MS SQL Server 2008/2005/2000 , MS Access, Teradata, SAP, HAdoop.

Database Tools: SQL Developer, SQL Navigator, Toad 8.0/9.1

Operating Systems: UNIX, Windows 95/98/NT/2000/XP.

Reporting tools: IBM Cognos 8(Report Studio, Query Studio & Analysis Studio), Crystal Reports, Tableau 8.2, SAS Enterprise Guide.

Schedulers: TIDAL.

Programming Languages: T-SQL, XML, SQL, HTML

Email Client: Microsoft Outlook, Lotus Notes 8.5.

PROFESSIONAL EXPERIENCE:

Confidential, Mc Clean, Virginia

Senior Data Governance & Data Management Consultant

Responsibilities:

• Created the Enterprise Information Group encompassing Business Intelligence Center of Excellence, Data Governance Working Group, Enterprise Data Warehousing and Master Data Management. Provided strategic vision and direction with operational and business leaders for enterprise information initiatives enabling Executives to make information-based decisions.
• Built Enterprise Data Warehouse hybrid team including System Integration vendor, other vendor contractors and employees, which followed the Kimball methodology, composed of Business and Data Analysis, Data Acquisition, Dimensional Architecture, ETL Development, Quality Assurance (including a Verification and Validation plan) and User Acceptance.
• Formed Business Intelligence Center of Excellence to ensure cohesive dashboard, analytical reporting and ad hoc reporting development, and maintained capacity and performance requirements. Furnished Business Intelligence Super Users with Knowledge Accelerator, a web-based and support product, in conjunction with class room and a sandbox environment.
• Provided tactical and practical direction to manage data as a critical asset including recommendations regarding data architecture, structure, governance, and quality.
• Oversight of data working groups within LOBs, as well as aligning schedules between working groups and other Project Lifecycle Management (PLM) efforts with Microsoft Project. Monitored, tracked, assimilated and communicated project information, status, and discrepancies.
• Data Profiling - Extensive data profiling with data quality rules check like for example Accuracy, Consistency & Completeness.
• Tableau dashboard - Executive summary created using Tableau, defining various aspect and measurement of data quality rules.

Technical Environment: Windows 7, Teradata, Informatica Data Quality (IDQ), SAS Enterprise Guide, Tableau, Big Data (Hadoop).

Confidential, New Providence, NJ

Business Intelligence/ DW Consultant

Responsibilities:

• Interacted with technical teams comprised of employees, contractors, vendors and Businesss executives in addition to business sponsors.
• Drive action and execute projects efficiently in a timely manner while working in a consensus focused organization.
• Set direction and drove the team to objectives, leading by example, and teamwork.
• Analyzed the sources, Targets, Transformed the data and Mapped the data and loading the data into Targets using Informatica.
• Provided daily production support of batches and system processes.
• Used Informatica Data Quality (IDQ) for -
• Extensively used IDQ to develop rule mapplets and mappings.
• Built Physical data objects.
• Built Profiles of various objects and analyzed the results in real time.
• Benefits of using IDQ .
• Leverages in Enterprise discovery, discovery search, and data profiling
• Performed Data quality rule builder for business analysts
• Helps in Role-based capabilities for developers and business analysts
• Helps in Data standardization, validation, enrichment, de-duplication, and consolidation
• Used Informatica Powercenter for -
• Built complicated mappings with Rule mapplets.
• Prepared Workflows to run batch processes.
• Did some UNIX scripting to add new features to the workflow using command tasks.

Technical Environment: Windows 7, Oracle 10g, Informatica Data Quality (IDQ), Informatica Power Center 9x, SAP, Informatica Address Doctor, SQL Developer, MS SQL.

Confidential, Virginia Beach, VA

Data Warehouse Consultant / Project Manager

Responsibilities:

• Interacted with technical teams comprised of employees, contractors, vendors and IT executives in addition to business sponsors.
• Successfully driven large, complex projects in a multi-department portfolio, knowing when to escalate and seek guidance.
• Drive action and execute projects efficiently in a timely manner while working in a consensus focused organization.
• Set direction and drove the team to objectives, leading by example, and teamwork.
• Analyzed the sources, Targets, Transformed the data and Mapped the data and loading the data into Targets using Informatica.
• Developed various mappings to load data from various sources using different transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Expression and Sequence Generator to store the data in target table.
• Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center.
• Extensively used DTS(Data transformation studio) to extract data from PDF files.
• Developed rule mapplets in IDQ (Informatica data quality) and exported them to powercenter.
• Successfully took ownership of projects and critical issues and to drive those to successful resolution.
• Provided daily production support of batches and system processes.
• Provided recommendations on improving the availability of reports and the stability of the production environments.

Technical Environment: Windows XP, SQL Server 2008, Toad 10.6, Oracle 10g, IDQ, DTS Informatica Power Center 9.0.1, Teradata.

Confidential, Columbia, MD

Informatica Expert / Subject Matter Expert

Responsibilities:

• Involved in data analysis and development.
• Prepared mapping specifications documents, unit testing documents for developed Informatica mappings.
• Prepared mapping documents for loading the data from legacy system, flat files to staging area.
• Prepared mapping documents for loading the data from staging area to ODS.
• Defined Target Load Order Plan for loading data into different Target Tables.
• Worked on Informatica PowerCenter Tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
• Extensively used Router, Lookup, Aggregator, Expression and Update Strategy transformation.
• Implemented incremental loads and historical loads
• Involved in the design and development of mappings from legacy system to target data base.
• Involved in performance tuning of the mappings by doing necessary modification to reduce throughput.
• Defined test cases and prepared test plan for testing ODS jobs.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Used Informatica debugger for data fixes.
• Coordinating with offshore team to resolve mapping and functional related issues
• Provided recommendations on improving the availability of reports and the stability of the production environments.

Technical Environment: Windows XP, SQL Server 2005, Toad 10.6, Oracle 10g, T-SQL, Informatica Power Center 8.6.1

Confidential, Minneapolis, MN

Data Management Consultant

Responsibilities:

• Requirement gathering and requirement Analysis (Analyzed source Systems and determined needed data).
• Involved in Technical feasibility discussions, Peer reviews and in unit testing
• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
• Developed complex Informatica mappings, re-usable transformations, Mapplets for accomplishing complex business requirements.
• Developed UNIX scripts to schedule workflows in the batch process.
• Used mapping parameters and variables along with parameter files.
• Created mappings/Workflows to extract data from SQL server, Sybase, XML sources and Flat File sources and load into data warehouse and the data mart.
• Created complex SQL, PL/SQL, stored procedures, triggers and functions.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.
• Designed and developed complex aggregation, and calculation to implement complex business rules to generate consolidated summary tables using Informatica ETL (Power Center) tool.
• Involved in execution of Unit test plans & prepare the Unit logs and in migrating the Mappings, Sessions, Workflows from Test environment to Production environment. Monitoring the ETL jobs and fixing the Bugs.
• Worked on analyzing the performance data to suggest changes to improve performance of Informatica load.
• Was involved in migrating Informatica objects from Development and Test to PROD using deployment groups.
• Own the creation and ongoing maintenance of test documentation and test plans.
• Responsible for the ETL (Informatica) build validation process on an ongoing basis
• Developed and reviewed test cases source to target mappings
• Write and execute SQL queries to validate actual test results and match expected results.

Technical Environment: Informatica PowerCenter 9.1.0, Oracle 10g, MS SQL Server 2008, PL/SQL, SQL*Loader, UNIX Shell Script.

Confidential, Cincinnati, OH

Data Management & Data Warehouse Consultant

Responsibilities:

• Responsible for designing and developing of mappings, mapplets, sessions and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
• Performed Informatica Admin role by creating new repositories, users and maintaining TEST and PROD environments.
• Involved in ETL process from development to testing and production environments.
• Extracted date from various sources like Flat files, Oracle and loaded it into Target systems using Informatica.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Tuned mappings and SQL queries for better performance and efficiency.
• Performed Unit testing and validated the data.
• Created & Ran shell scripts in UNIX environment.
• Created and ran the Workflows using Workflow manager in Informatica Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Created tables and partitions in database Oracle.
• Writtenstored procedures in Oracle.

Technical Environment: Informatica Power Center 8.6, Oracle 10g, SQL, PL/SQL, UNIX Shell Scripting, TOAD, Erwin.

Confidential

Data Management Consultant

Responsibilities:

• Legacy application analysis of existing system.
• To map existing functionality with to be functionality.
• To understand attribute definitions for migration.
• Involved in design and development of business requirements in liaison to business users and technical teams by gathering requirement specification documents and identifying data sources and targets.
• Defined data validation process and data analysis patterns and documents
• Coordinated between users and technical architect to fulfill the business requirements.
• Translated business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the data into the Target Star Schema on Oracle 8i Instance.
• Involved in development of mappings to update the Records on both daily basis and monthly basis.
• Extensively worked in the performance tuning of the mappings, ETL procedures and processes.
• Defined Target Load Order Plan for loading data into different Target Tables
• Optimized Query Performance, Session Performance and Reliability.
• Performed extensive unit testing on the developed mappings by developing various test scenarios and also involved in the documentation of test plans.
• Supported QA testing and production testing by identifying the bugs and also helped to resolve various data issues, load Issues.
• Setup the data mart on Oracle database by running the SQL scripts from Erwin designer.
• Involved in the migration process from development, test and production environments.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Wrote stored procedures and triggers in Oracle 8i for managing consistency and referential integrity across data mart.
• Scheduled and Ran Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.

Technical Environment: Informatica PowerCenter 8.1.1, Oracle 10g/9i, SQL, PL/SQL, TOAD, SQL*Plus, Autosys, Windows, UNIX

Confidential

Data Management & Database Specialist

Responsibilities:

• Worked in the staging area so as to removed the inconsistencies in the data coming from the Mainframe Source systems
• Created mappings using Informatica PowerCenter that extracted the data from sources and loaded the data into Targets using various transformations like Normalizer(for Cobol sources)Update Strategy, Lookup, Filter, Router, Union, Aggregator
• Implemented stored procedures and functions, as per requirements in PL/SQL.
• Involved in unit and integration testing of mappings in ETL Test environments.
• Used Informatica debugger for bug fixes.
• Performed Debugging procedures and Performance Tuning on bottlenecks encountered.

Technical Environment: Informatica Power center 8.1.1, Informatica Power Exchange 8.1.1, Oracle 10g, AIX Version 5, Windows XP, and Toad.