SUMMARY:

• 7+ years of IT experience in Analysis, Design, Development and Implementation of Data Warehouse, Data modeling and Data Integration Solutions and Business Intelligence (BI)
• Expert in Data Extraction, Transforming and Loading (ETL) usingBusiness Objects Data Services (BODS), SSIS and Informatica Power Center
• Extensively worked on developing and debugging ETL mappings, mapplets, sessions, workflows and re - usable objects
• 4+ years of experience in working directly with Business stakeholders to gather requirements, following up with project status and maintaining relations with customer
• Over 4+ years of professional experience working on Tableau Server and Tableau Desktop
• Strong knowledge of OLAP and OLTP systems and Experience in using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling for high performance and highly scalable Data warehousing
• Highly skilled in Tableau Desktop for data visualization, using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, Heat Map and Density Chart.
• Expertise in dealing with Relational Database Management Systems Including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Worked extensively on multiple data connections using Data Blending and Data Joining, worked on Data Extracts and managing queries.
• Experience in writing, testing and implementation of the SQL Queries,PL/SQL triggers, stored procedures, functions, packages, partitioning and database performance tuning
• Great knowledge on Software development life cycle (SDLC) process, technology platforms and environments
• Passionate to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and Listening + verbal Communication skills
• Awarded with Bravo and Outstanding Performer for always meeting deadlines with qualitative delivery and articulate work

SKILLS:

Informatica 9.0/9.5

SAP BODS 4.0/4.2

SQL SERVER

Oracle 11g

ERWIN

TABLEAU 10,9

WORK EXPERIENCE:

Confidential

Business System Analyst (BSA)

Responsibilities:

• Gathered requirements by understanding the state of the project in terms of Data Governance, the end state that the client wants and what is realistically achievable
• Developed the end to end process of conducting the lineage of BI reports to identify the output elements of the reports and their respective sources
• Learned Basis concepts and keywords of SAS tool and COBOL files to understand existing report and their outputs
• Modified Stored procedures written in MS SQL Server to perform various tasks in one-line command
• Engagedin Data Modelling for moving data from EDPP to BB Common
• Created reusable queries for investigating errors in lineage
• Worked with the BI reporting team to identify which report produces the intermediate source, and to clarify inconsistencies between the process documents and the code used in the report
• Collaborated with the data modelling team to capture the metadata recorded in the lineage into a SQL Server database for future analysis
• Reverse engineered these reports produced in SAS, SQL, MS Access, and MS Excel

Product Analyst

Confidential

Responsibilities:

• Interacted with the business community and database administrators to identify the business requirements and performed Gap fit analysis
• Extensively worked on designing ETL processes from beginning to END for SCD type 1, 2 and 3
• Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Tableau.
• Creating value prompts, Date & time prompts, Text box prompts, cascading prompts
• Blended data from multiple databases into one report
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Created interactive dashboards by combining views and reports in Tableau Desktop that were presented to Business Users, Program Managers, and End Users

Product Analyst

Confidential

Responsibilities:

• Developed mapping to load the data in Slow changing dimension(SCD), Rapidly changing dimension(RCD), early arriving fact/late arriving dimension
• ImplementedChange Data Capture(CDC)by tracking the changes in critical fields required by the user
• Worked with Variables and Parameters in the mappings to pass the values between sessions
• Created Reports and Dashboards with Quick filters, Parameters and sets to handle views.
• Experienced the latest version of Tableau Developer 10.1, 9 & below.
• Developed Public Objects like filters, prompts, metrics, templates, consolidations, etc.
• Experienced in using Schema Objects to create reports.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality

System Engineer

Confidential

Responsibilities:

• Developed Informatica objects - Mappings, sessions, workflows based on the prepared low-level design documents
• Worked with heterogeneous source to Extracted data from Oracle database, XML and flat files and loaded to a relational Oracle warehouse
• Exclusively worked on the transformations likeAggregator,Connected & unconnected lookups and usedSQL overrideto filter the data, Router andSequence Generator
• Prepared Technical Document and High-level documentation to support Development