SUMMARY

• A professional with 9 years of experience in IT Industry in the field of Data Warehousing, Business Intelligence and Analytics in the areas like Retail, Finance and Banking sector
• Experience in Business Analysis, Data analysis, Design, Development, Testing and implementation and Maintenance in Business Intelligence BI / Data warehousing.
• Expertise in the development and design of Data warehousing applications and Data modelling, Data Mapping on both ETL & OLAP
• Extensively worked on Tableau 7.x/8.x/9.x (Desktop, Server and Public), Cognos, SSRS and Cube reports
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile
• Posses' strong knowledge of database management in writing complex SQL queries, Stored procedures, query optimization and resolving key performance issues and maintaining Business Glossary
• Expertise in creating and running various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization using Tableau and Cognos
• End to end experience in designing and deploy rich Graphic visualizations to the cloud services
• Worked on Migration project from 7.5 V to 8.7 Version of datastage and Big Data POC project for implementing EDW SAS parity into Bigdata with Hadoop clustering, Hive, Tableau and Azure
• Highly knowledgeable in concepts related to Data Warehouses schemas, Star Schema modeling, and Snowflake modeling and processes.
• Served as the liaison between the business and the technical team and actively participated in all phases of the Development and Testing including post production validation
• Facilitated GAP analysis to define the As - Is and To-Be processes and experience in developing functional specs through JAD sessions, Client Interviews and workshops.
• Profound expertise to create BRD (Business Requirement Document), FRD (Functional Requirement Document), USD (Use Case Specification Document), SRS (System Requirement Specification) and UML Diagrams such as Use Case, Activity, Class and Sequence Diagrams and flow charts.
• Worked effectively with the QA (Quality Assurance) team for designing and evaluating Use Case Scenarios, Test Plan, Test System, Test Data and Test Cases for the application.
• Experience in conducting manual testing, unit, system, functional, integration, regression and User Acceptance Testing (UAT) of systems. Hands on experience with Rational Suite, MS Office, MS Visio, MS Project.
• Experience in UNIX environment to work with scripts and running the jobs using commands.
• Excellent communication skills and analytical skills and exhibiting leadership qualities in a Team and working with onsite offshore model with people including cross-cultural backgrounds.

TECHNICAL SKILLS:

ETL: DataStage, Informatica

BI: Cognos 10.1/8.0, Tableau 9x, 8x, SSRS, OBIEE, Cube, SAS, Roambie, Hadoop HortonWorks

Cloud Services: Google Analytics, MS Azure

Language: SQL, PL/SQL, UNIX, HTML, Java Script, Python

Database: Oracle 11g/10g, DB2, SQL Server 2008, Teradata, Hive

Dimensional Modeling: MS Visio, Erwin 4.1/3.0/7.2/7.3

Others: Jira, Quality center, MS Office, MS project, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

Business Data Analyst

Responsibilities:

• Involving in gathering business requirements from the LOB and creating and updating BRD documents
• Creating of SQL scripts to run on daily basis to validate and Monitor the health checks on the Finance reports
• Creating of DQ checks to validate the date flow from source system Triton to Farm database
• Generating OBIEE reports and performing analysis on daily basis to identify the variance between the V1 and v2 reports
• Participating in Weekly and Daily meeting with the LOB and Data Ops teams to discuss any issues and progress on work

Environment: Informatica, OBIEE, Oracle 10g,11g,Toad, Jira,, Microsoft Office, QC,Sharepoint

Confidential, San Francisco, CA

Senior Business Data Analyst

• Involved in gathering business requirements, Creating mapping document by working with Upstream teams, Architects and Product teams
• Converting business and technical requirements into various User Stories, facilitated Sprint planning meetings to estimate and prioritize various tasks and sub-tasks associated with each user stories.
• Conduct ed interviews with a broad audience to define data requirements. Translate conceptual requirements into technical requirements in a clear manner that is comprehensible to developers/project team
• Responsible for creating UML Diagrams like Use Case, Activity and data flow diagrams using Rational Rose and MS-Visio
• Coordinated with the Clients, SMEs and Developers and successfully resolved Action Items
• Performing Data analysis by validating the data between source and target systems by writing SQL queries and test cases in MS SQL and Oracle
• Generating Tableau and Cognos reports to run on weekly and monthly to show the trends of sales and user profiles and make it available for business and executives in email or tableau Online for the Analytical analysis
• Validating the transformations written in ETL datastage code and Cognos Reports as per the Business requirements
• Maintaining the data dictionary for all the new calculations and the existing columns in the database as a repository
• Conducting UAT and Business validating testing with the Product teams to ensure the requirements are met and acts as a liaison
• Run the ETL, Cognos, SAS and Cube Reports to ensure the data is populating as expected and to perform data checks as null handling, formatting and abnormal edge cases
• Analysis of the Key KPI’s by looking at the Order Merge sales and user profiles with the help of historical data in to EDW
• Involved in the POC for Big data by creating the SAS parity in EDW by using Hadoop, Tableau and Hive on Azure and there after developing dashboards to Product team for Analytical Analysis
• Validating the code fixes as part of the enhancements in the ongoing projects and deployed projects to production
• Assisting QA teams during the Functional, Regression and Sanity tests by running the ETL sequencers and automated reports and logged defects thru Jira tracker
• Work closely with the internal and externals vendors to resolve with the data issues as per their data eligibility
• Active participation in weekly project meetings to track the progress of work and discuss the mile stones and Onsite and Offshore Coordination along with the proactive Production Support.

Environment: IBM Datastage, Tableau 8.1 Oracle 10g,11g, SQL Server, Jira, AIX, Windows XP, Rational rose, Microsoft Office Suite ( Project, Word, PowerPoint, Excel),Agile,, Confluence, Hadoop Horton works, Hive, Azure

Confidential, Prussia, PA

BI Business Data Analyst

• Interacted closely with the Business users and Senior stakeholders to gather high level and detailed requirements and analyzed the functionalities to be incorporated as part of the Securitization and Migration project
• Utilized several requirements gathering technique including but not limited to requirements sessions, UML diagrams, functional decompositions, analyzed the Requirements, documented BRD, Use Cases, etc. and managed change requirements by implementing change management methodology
• Coordinated and led collaborated sessions with architects and developers to convert business and functional requirements into system/technical requirements
• Performed reconciliation between source and target systems to identify inconsistencies and remediation process
• Collaborated with diverse teams/stakeholders (offshore/onshore) in Data Migration project regards to Data structure, Data Reconciliation and report generation
• Created Mapping documents (Interface Specifications), documenting Data Points between legacy and future state systems. Identification, definition and maintenance of key data elements business and technical definitions.
• Collaborated with various levels of stakeholders (including product owners) in establishing project and business scope, risks, requirements, approval and sign-off.
• Created and Performed Data Analysis - using SQL and Excel skills, to profile data to identify data quality issues analyze for accuracy, to extract specific information, Data Testing and Data flows
• Created tableau dashboard and reports to track performance for marketing channels, campaigns and vendors to analyze impact of profitability
• Lead and promptly escalated quality and/ or integrity issues and risks and logged the defects
• Created QA and UAT Test plans/test scripts. Participated in UAT along with the development & testing teams.
• Worked closely with team members, developers, testers and a variety of end users to ensure technical compatibility and user satisfaction
• Conducted Sprint Release planning, maintain product backlog according to production release and provided production support
• Created weekly and monthly dashboard reports to senior management on the status of work

Environment: IBM Infosphere Information server, Tableau 8.1 Oracle 10g,11g, SQL Server, Control - M, AIX, Windows XP, ERWIN, Microsoft Office Suite ( Project, Word, PowerPoint, Excel),Agile, Quality Centre, SharePoint

Confidential, Cincinnati, OH

BI ETL Consultant

Responsibilities:

• Performed requirements gathering, Source data analysis and identified business rules
• Prepared the technical design documents (TDD) and source to target mappings in order to meet the requirements.
• Organized Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level.
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data rules.
• Reviewed test cases written by team and made modification for better execution of test cases.
• Made recommendations to improve the current application performance depending on time limitations and capacity constraints with the aid of SCR’s (Scope Change Requests).
• Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using datastage
• Performed data query, reporting and analysis and also built calculations, filtered reports, and added subtotals and modified report contents from the windows and web interface.
• Participated in ETL Functional Specifications Document (FSD) reviews and responded to questions related to the mappings, modeling and processing logic flows. Supported ETL with the development process.
• Developed a set of SQL queries for data validation and boarder cases and involved in basic Sanity Testing of the Application.
• Practiced Agile/Scrum Development methodology for automation development
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• Designed and developed Quality Assurance standard and processes to all levels of project team.
• Implemented an integrated RUP solution with complete line of traceability for all the artifacts of web development projects
• Worked closely with the PMO group in defining timelines & schedules for the project.
• Develop the ability to utilize User data, transactional level, and Market Basket data to better understand business trends and help develop plans to meet changing business rules.
• Responsible for providing primary leadership in designing, leading, and directing all aspects of UAT Testing Reviewed success of functional, regression and end-to-end testing done by the team.

Environment: IBM Infosphere Information server 8.1, DB2 ZOS, UDB, Windows Server 2008, UNIX shell scripting, AIX, Tivoli, Tableau 7x, MS VISIO, Microsoft Office Suite, Rational Rose, SSRS

Confidential, Washington, D.C

BI (Datastage/Cognos) Consultant

Responsibilities:

• Worked with the end business users to comprehend their requirements in order to design and develop interactive jobs and reports that meet business expectations.
• Actively participated in Team meetings Status meetings to gather the business requirements and developing the Specification documents, Onsite and Offshore Coordination as a lead from onsite.
• Involved in mapping multiple data sources to a single target database by analyzing the business requirements that are specified in the functional documents.
• Designed the Target Schema definition and Extraction, Transformation and Loading (ETL) using DataStage.
• Extract data from source files such as Sequential files, XML files, Flat files, CSV files etc., transformed and loaded data into data marts.
• Developed Parallel jobs using Parallel stages such as Merge, Join, Lookup, Aggregator, Switch, Column Export, Column import, Modify, Row generator, Column generator, Flat file, Dataset, Funnel, Remove duplicates, Sort, Transformer, Oracle Enterprise Stage.
• Involved in creating entity relational and dimensional data models, logical and physical data models using Data modeling tool ERwin.
• Building the SQL queries for Oracle to fetch the data from the Database as per the business requirements and use the SQL queries in the DataStage for further processing.
• Worked with Quality stage to improve quality of incoming data as data is coming from different sources there will be duplicates.
• Designed and developed PL/SQL Procedures, functions, and packages to create Summary tables.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Developed Shell Scripts to automate file manipulation and data loading procedures.
• Worked with Metadata workbench and Business Glossary to create categories and terms, define custom attributes and values, search the glossary, and assign a steward to assets. Manage operational, technical and business metadata.
• Used Cognos to generate reports and create dashboards to see the progress of jobs on daily basis by the project manager and other stake holders

Environment: IBM Infosphere DataStage 8.1,Quality Stage 8.1, Kalido DIW 8.5, Oracle 11 g, SQL Server, Cognos 10.1, UNIX Shell Scripting, AIX 5.2(Server), Windows Vista(Client), Metadata workbench and Business Glossary

Confidential, Denver, CO

ETL Developer

Responsibilities:

• Performed requirements gathering, analysis and source data analysis and identified business rules for data migration and for developing data warehouse data marts.
• Received the master data and populated the Dimension Tables, Fact Tables, generated Surrogate keys.
• Designed various mappings (Source-to-Target) using DataStage to link between different source systems and data warehouse for loading data into warehouse.
• Developed & implemented complex migration strategy and scripts.
• Used DataStage Designer for developing various jobs for Extracting, Cleansing, Transforming, Integrating and Loading data into Data Warehouse.
• Designed Parallel jobs using various stages like (Join, Remove Duplicates, FTP stage, Filter, Dataset, Lookup, file set, Modify, Transformer and Funnel stages).
• Developed incremental and full load data jobs using CDC (change data capture stage), which were scheduled to run on daily, weekly or monthly basis.
• Used SCD (Slowing Changing Dimension) Type1 & Type 2 to handling the historical data.
• Extracted data from text files, using FTP Stage and loaded into different databases.
• Used Complex Flat File Stage to extract data from Mainframes & Extensively used the XML stage in loading the XML files into DataStage.
• Performed tests on FDR systems to ensure efficient functionality and update on financial data using SYS parameter
• Used Qualitystage stages such as Investigate, Standardize, Match and Survive for data quality and data profiling issues monitoring with information analyser
• Used Autosys to schedule the DataStage ETL batch jobs on a daily, weekly and monthly basis.
• Created Test plans, Test cases and performed Unit Testing, Integration Testing & System Testing.
• Worked on Performance Tuning, Troubleshooting & debugging of various ETL Jobs.
• Data loaded into target table is used to generate reports using Cognos.

Environment: IBM Infosphere Information server 8.1(Datastage, Qualitystage), Erwin 4.1, Oracle10g,SQL server 2005,Teradata V2R6, Flat Files, Windows Server 2008, UNIX Shell Scripting, Control M, COGNOS 8.0, TOAD.