SUMMARY

• Over 7+ years of IT experience in Design, Analysis, Development and Documentation on client/server environment using Development of Datawarehouse, Business Intelligence and Data Platforms.
• Wide experience in various phases of Software Development Life Cycle (SDLC) including Systems Analysis & Design, Development, integrated testing, implementing, User acceptance testing.
• Expertise working in Agile methodology.
• Participated in daily Scrum sessions to discuss the project status and finish the tasks assigned for each sprint.
• Extensive experience with business analysis techniques such as Elicitation to gather Business Requirements and model them using Flowchart, Use Cases, Data Flow Diagrams, Activity Diagrams and Entity Relationship Diagram to verify and validate those requirements.
• Experience in creating functional & technical specification and mapping documents
• Good Hands - on in Analysis, Design, Implementation of Business Intelligence systems, Reporting tools and OLAP environments along with strong analytical skills.
• Good knowledge of Datawarehouse and ETL concepts.
• Excellent understanding of Data modeling (Dimensional; Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables.
• Extensive knowledge in writing SQL queries using MS SQL Server Management Studio Teradata and Oracle for exploratory analysis.
• Expertise in creating test plan, test cases and test scenarios.
• Experience in BI suite using integration services (SSIS) for ETL (Extraction, Transformation & Loading), reporting services (SSRS) for creating different types of reports and analysis services (SSAS).
• Good understanding and experience with developing Schemas using Entity Relationships, Data Modeling, Normalization, Creating Tables, Views, Indexes, Sequences and Coding.
• Experience working on data quality and data cardinality issues; Conducting sanity checks to analyze the quality of data.
• Analytical and problem-solving skills with experience in drawing insights and analysis from large data sets.
• Extensive experience with technical problem solving, testing, debugging and troubleshooting.
• Good Knowledge of Informatica, SSIS, Teradata, Oracle, MySQL and NoSQL
• Extensive experience working in Windows, UNIX, LINUX environments.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Database Technologies/Tools: MS-SQL Server 2012, 2008 R2, 2005, Oracle, SQL T-SQL, SSIS, OLAP, TOAD, Informatica Power center 9.1.x,9.6.x, SQL Developer, Cassandra, MySQL, Teradata

Reporting Tools: Microsoft SQL Server Reporting Services (SSRS), Tableau.

Operating Systems: UNIX, Windows XP, Windows Server 2003/2008.

Programming Languages: JAVA, SQL, Python, UNIX shell scripting, PLSQL, T-SQL, Perl

Technologies/Tools: UML, MS Visio, Erwin, Eclipse, SPLUNK, Quality Center, Tidal, Control-M, CA Data maker, JIRA, Confluence, HP Quality Center, Rally

PROFESSIONAL EXPERIENCE

Confidential - Bellevue, Washington

Senior consultant /BI Analyst

Responsibilities:

• Worked in an Agile - Scrum environment with experience using tools like Rally.
• Understanding and participating in requirement gathering sessions with stakeholders and providing inputs to Business in terms of modification of functional and technical specification.
• Responsible for developing Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Requirement Traceability Matrix (RTM) and testing documents.
• Facilitating and clarifying business needs and translating them into application and operational requirements that can be executed by the development team.
• Conducting walkthrough sessions of all the design related documents with offshore development and testing teams
• Utilizing Unified Modeling Language (UML) methodology to prepared Use-Case Models, Data Flow Diagrams and ER diagrams using MS-Visio.
• Created ETL mapping document with analysis of data from various source systems and mapping the columns of source to target with the transformation involved.
• Responsible for Data Profiling and reviewing datamappings in different stages of data transformation to ensure Data reconciliation
• Responsible for writing complex SQL in Teradata for exploratory analysis and developing Ad-hoc reports as per the requirements of the stakeholders.
• Developing and maintaining test specifications, test cases, test scripts and test plan; implementing test practices, and processes to troubleshoot test issues.
• Assisting Stakeholder in providing support for their UAT testing for developing user acceptance testing documentation and test plans; Conducting the sanity testing on data to ensure the data quality.
• Maintaining issue or defect tracking, test cases and test plans using the HP ALM Quality center tool.
• Monitoring and resolving issues relating to Customer subscriber reporting (CSR) jobs; responsible for delivery of these reports (daily, monthly, quarterly) to stakeholder within SLA
• Supporting existing reporting infrastructure by validating BO report results; working with the team to investigate any data inconsistencies; performing analysis of data and troubleshooting data integrity problems.
• Determining and validating potential data sources, and performing gap analysis related to the new business requirement
• Analyzing data gathered from Prod environment for ensuring that the existing data confirms to business rules defined and understanding the source system changes and impact on the data quality.
• Understanding of Importing, transforming validating, and loading data using informatica into Confidential Financial data warehouse for analysis and for the purpose of understanding and drawing conclusions from data.

Environment: Informatica 9.5.x/9.6.x, Tableau 9.x/10.x, Teradata, Oracle, SAP HANA, GitHub, Microsoft Excel 2016, Rally, SQL, scripting, Confluence, UML, MS Visio, HP ALM Quality center, BO reporting

Confidential

Responsibilities:

• Facilitated JAD sessions with different business stakeholders, Business Intelligence architects, product owners tounderstand business requirements.
• Created source to target mapping documents and developed transformation for pulling the data from sources.
• Perform SQL Server system impact analyses including upstream and downstream impacts, by running SQL queries on Microsoft SQL server Management Studio and worked closely with the solution architects, developers and testers in an onshore/offshore model to finalize and maintain source to target mappings which involved writing complex logics that captured and defined the data flow between various facts and dimension tables in a STAR schema data warehouse.
• Designed complex SSIS Packages to transfer datafrom public data sources to populate the staging tables.
• Extensively used SSIS transformations such as Lookup, Derived column,Dataconversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Worked with business partners to understand their reporting needs and have BI reports driven sessions which included reviewing and finalizing reporting design documents and defining business metrics from enterprise data warehouse
• Created tableau dashboards built on top of views of aggregated slots and marketing data. Captured and presented business metrics and KPI’s as percasino client’srequirements
• Worked on creating dashboards for monthly, quarterly and yearly reports on tableau desktop and publishing it on tableau server.
• Worked on creating multiple dashboards around the client’s slot data which helped the business users in analyzing different aspects of their slot business e.g. Manufacturer Performance, Coin in by game type, Top 10 games, demon performance, top 20 slots, Theo slot performance etc. and make critical decisions based on the performance of the slots which account for more than 60% of the client’s revenue.
• Extensive knowledge in varioustableauobjects like Hierarchies, Calculated fields, Filters, Sets, Groups, Parameters etc. inTableau.
• Good experience in working with Parameters, Actions, Filters, Legends, Measures, Dimensions, Functions, quick table calculation and Calculated Fields withTableau.
• Extracted data from multiple data sources and created data extract files (TDE) for fast query execution in Tableau
• Worked on combining views and reports into interactive dashboards inTableauDesktop that are presented to Business Users, Program Managers, and End Users
• Worked on analyzingdataquality anddatacardinality issues and helpeddatastewards propose a fix for the issues.
• Installed, configured and set up Team foundation server (TFS) which is a version control tool to ensure seamless development flow between onshore and offshore team.
• Conducted walkthrough sessions of all the design related documents with offshore development and testing teams

Environment: s: Microsoft SQL Server, Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), Oracle, SQL, T-SQL, VB.NET, Flat Files, Excel Sheets, TFS

Confidential

Test data management

Responsibilities:

• Collaborating with tester to understand test scenarios for the different projects for pulling data from production related to the specific test scenarios.
• Involved in data discovery of the tables from various sources/application related to test scenarios to identify the transaction, referential and the configuration tables.
• Identifying PII and PCI attributes from source which needs to masked and writing rules to mask the data in the test data warehouse before pushing data to the target.
• Created data model, data flows and data mappings for all the transaction tables using CA TDM subset tool for all the major application required to satisfy Confidential key business scenarios.
• Generated the Oracle SQLloader and data pump scripts using the tool to pull the data from production into our test environment.
• Created Subset scripts for certain application which required additional logic and manipulation for pulling data from the production environment.
• Understanding of API built for test data provisioning for the key business scenarios for client’s legacy and universe 2.0 systems.
• Provided User interface or self-service tool to pull the production data from our test data warehouse for the key test scenarios.
• Developing solutions that can be implemented efficiently using available technology stack in Confidential to support provisioning of test data for the various efforts across the Confidential IT organization.
• Understanding the technical issues and defects raised related to the test data provisioning and ensure timely resolution.

Environment: CA TDM tool, Fast data Maker, CA data Subset Tool, Oracle, Microsoft SQL server, Cassandra, MySQL GitHub, Rally, Confluence

Confidential

Senior System Engineer

Responsibilities:

• Involved in gathering and understanding requirement for migrating data from multiple source to the master data management. (MDM).
• Accessing the impact of the downstream and upstream systems and closely working with the architects for the better understanding of design
• Involved in data mapping and design of the project.
• Developed PLSQL packages, triggers and stored procedure to migrate data to the master database (MDM) from legacy databases by extracting the portfolio data and other subject areas from payload.
• Responsible for optimizing the SQL stored procedure, functions using explain plan and SQL profiler
• Performed unit testing, system testing and UAT testing.
• Involved in onsite-offshore team engagement and client coordination.

Environment: Informatica, Oracle, PLSQL, XML files, flat files, Oracle, SQL, Excel Sheets, GitHub

Confidential

Responsibilities:

• Involved in requirement gathering, analyzing, documenting business requirement, functional requirement and data specifications; Creating source to target mapping document.
• Designed complex SSIS Packages to transfer data from multiple datasources to populate the data into the data warehouse
• Extensively used SSIS transformations such as Lookup, Derived column,Dataconversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc. as per the business requirements.
• Responsible for writing complex T-SQL queries, stored procedures, database triggers, exception handlers, SSIS Export and Import
• Working on the optimizing the performance of T-SQL statements by analyzing the run time and used Query execution plan.
• Reviewed and tested SSIS packages.
• Worked with business partners to understand their reporting needs and involved in sessions which included reviewing and finalizing reporting design documents and defining business metrics for enterprise data warehouse
• Working knowledge of creating various reports such as drill down and drill through reports, parameterized reports, matrix reports, sub reports.
• Tested & deployed the reports & also involved in change management procedure
• Installed, configured and set up Team foundation server (TFS) which is a version control tool to ensure seamless development flow between onshore and offshore team

Environment: s: Microsoft SQL Server, Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), Oracle, SQL, T-SQL, VB.NET, Flat Files, Excel Sheets, TFS

Confidential

Responsibilities:

• Liaised extensively with clients and internal team during requirement gathering, analysis and design phase.
• Modified the existing design documents (HLD, LLD) based on the new change requests.
• Developed automated shell scripts for customer order management, adding value to the business.
• Created shell scripts to run the batch jobs to extract the sales data and optimized critical batch jobs to improve performance of jobs by 80%.
• Scheduled the batch job on Control-M to extract the sales data from the flat files and loading into our databases.
• Responsible for enhancement and maintaining of web applications and resolving any issues related to the application within SLA.
• Created Packages to perform operations to maintain track of inventory, sales and customer data management.
• Responsible for developing and maintaining of stored procedures, triggers, tables, views and other objects based on the changing the business requirements
• Responsible for fixing the defects found during testing phases. Supported the production deployment activities.
• Assisted clients in conducting user acceptance testing in order to maintain quality control check.

Environment: Oracle 10g, Shell Scripting, Microsoft SQL Server, Eclipse, JAVA, Microsoft Excel, Control-M, HP ALM Quality center, SQL, PERL