SUMMARY:

• Over 8 years of experience in facilitating development of Business Intelligence/Data Warehouse systems, providing BI expertise, designing data models by translating business requirements into data flows and data mapping, planning and executing ETL/BI testing, STLC Activities, Test Plan development and Test Execution.
• An assertive analyst with diversified experience in Data Analysis, Design & ETL/BI testing.
• Strong in analyzing requirements & develop comprehensive Logical and Physical Data Models.
• Extensive experience in designing/testing ETL jobs/objects, Stored Procedures, SQL Triggers, User Defined Functions for large data warehouse project with complete life cycle
• Around 2 years of experience working with Big Data and Hadoop ecosystem with expertise in tools like Hadoop - HDFS & MapReduce, HIVE, Spark, HBase, SQOOP, Zookeeper, Storm, Cassandra & MongoDB
• Hands on experience in using various Hadoop distributions (Apache, Cloudera, Hortonworks - Both MapReduce and Spark processing framework )
• Exceptional knowledge in SQL and worked with Netezza, Oracle, Teradata, Microsoft SQL Server platforms
• Working knowledge of Informatica Power Center & Workflow Monitor and Microsoft SSIS.
• Working knowledge of OLAP Reporting Tools like Cognos, Microstrategy, Crystal Report and Java based visualization tool like D3.
• Top-notch, motivated professional with strong analytical, quantitative, statistical and problem solving skills. Ability to follow through the project from inception till completion.
• Lead overall ETL processes and architecture, performed build, tested and deployed activities related to BI and data warehouse implementations
• Demonstrated ability to conceptualize and to propose insightful test solutions and to execute projects with superior quality on time
• Experience in using IDEs like Eclipse Maven
• Experienced in Hadoop data testing, HDFS and HIVE data testing and validation.
• Worked closely and interacted directly with business, technology and product stakeholders to define and document business intelligence solution requirements
• Extensive experience in analyzing different sources and prepares data mapping from Source to Target along with multiple transformations.
• In depth knowledge and working experience in key Data Warehousing concepts and modeling concepts such as slowly changing dimensional modeling, star schema, snowflake schema, fact less dimensions, normalized and de-normalized data modeling .
• Experience in creating/working with Automated Data Validation Tool like Platinum and Cross Report Submission Tools in VB.net.
• Experience in the areas of Web based and Business Intelligence Research Framework Technologies
• Extensive domain knowledge in Technology, Retail, Life Sciences and HR Systems
• Experience working in both traditional Waterfall and sprinted Agile Methodologies.
• Experience in visualize the business requirements and define exceptional test strategy to conduct ETL/BI Testing.
• Experience in manual testing, automated testing, regression testing, UAT, smoke testing, functional testing, data validation.
• Day to day activities includes working with both Transactional (Real Time Data Integration) databases and Data Warehouse systems.
• Exceptional knowledge in Data Reconciliation, tracking the data to the source, identifying the root cause of defects, designing code fixes without affecting day to day activities.
• Knowledge on DA/QA processes and Business process, Customer Service and experience in coordinating with Project team and Operations team

TECHNICAL SKILLS:

Tools: Aginity Workbench, PL/SQL Developer, Toad, Squirrel Client, XML Spy, Microsoft Visual Studio, Microsoft SQL Server 2005/2008, Informatica 9.51, SQL Server Integration Service

BigData Technologies: Hadoop, HDFS, MapReduce, Hive, Spark, Hbase, Yarn, Spark, Storm

Database: Netezza, Oracle, Teradata, Microsoft SQL Server, Informix, MS Access

Query Language: SQL, HiveQL, SparkQL

Data Modeling Tools: Sybase Power Designer 16.1, Erwin

Reporting Tools: Microstrategy, D3, Cognos, Document Explorer

OS: UNIX, LINUX, Windows 7/Vista/XP, Windows Server2003 and 2008 R2, 2012

WORK EXPERIENCE:

Confidential

Sr. Data Analyst

Environment: Oracle, Informatica, HP Quality Center

Responsibilities:

• Responsible for analyzing ‘Data Process Documents’ proved by SoR (System of Record) SMEs.
• Responsible for developing Integrated Layer Mapping Document (ILMD) for Developers and Quality Assurance teams which portrays Source to Target mappings.
• Understanding the specifications of Profit View and interacting with the data architects and the end users for informational requirements
• Understanding each different sources and their internal structures and suggesting data model changes to accommodate different SoRs in the Integrated Layer.
• Responsible for creating and maintaining Data for re-usability of data.
• Responsible for loading Deposit and Deposit Services System to the Integrated Hub.
• Analyzing different streams of data and gathering technical and performance stats for Reporting Requirements.
• Developed complex SQL queries to analyze, validate and manipulate data to fulfill business requirement specifications and reporting requirements including identifying the tables and columns from where data is extracted
• Writing queries with complex joins, analytical functions, windowing functions, nested sub queries, common table expressions with levels, regular expressions to validate ETL processes and Micro Strategy reports.
• Performed Manual, Regression, Smoke and Integration Testing, including Data Integrity, validation for ETL data transformations.
• Extensively worked with developing test scenarios using complex queries for data integrity checking.
• Handling multiple projects in Monthly and Quarterly releases
• Coordination with IT, PMO and Business teams
• Performing Integration Testing and taking part in User Acceptance Testing in ensuring a successful deployment.

Confidential

Sr. Data Analyst

Environment: Netezza, Oracle, Informatica, Micro Strategy, D3, HP Quality Center

Responsibilities:

• Responsible for building scalable distributed data solutions using Hadoop to process approximately 50 billion records to provide Best Match algorithm.
• Responsible for gathering and documents requirements from Business Users.
• Responsible for developing Functional Requirements Document to ensure the delivery of quality software applications, reporting results to the project team.
• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data architects and the end users for informational requirements
• Written multiple Map Reduce programs for data extraction, transformation and aggregation from multiple file formats including XML, CSV & other compressed file formats
• Responsible for analyzing different sources and preparing Source to Target data mapping documents for ETL developers.
• Created POC using Spark Sql
• Analyzing different streams of data and gathering technical stats of accuracy and choosing the source based on accuracy
• Developed complex SQL queries to extract, validate and manipulate date to fulfill business requirement specifications and reporting requirements including identifying the tables and columns from where data is extracted
• Writing queries with complex joins, analytical functions, windowing functions, nested sub queries, common table expressions with levels, regular expressions to validate ETL processes and Micro Strategy reports.
• Created Visualization reports using D3 to showcase the dealers/customer integration and mindsets.
• Performed Manual, Regression, Smoke and Integration Testing, including Data Integrity, validation for ETL data transformations.
• Validated Micro Strategy reports against databases by writing comparison queries.
• Extensively worked with developing test scenarios using complex queries for data cubes
• Handling multiple projects in Monthly and Quarterly releases
• Coordination with IT, PMO and Business teams
• Performing Integration Testing and taking part in User Acceptance Testing in ensuring a successful deployment.
• Validating end user business reports and dashboards created by using Micro Strategy.

Confidential

Data Analyst

Environment: SQL Server Management Studio, Informatica, Cognos, HP Quality Center.

Responsibilities:

• Responsible for preparing Technical design documents to develop comprehensive data warehouse for the business to analyze their Service Request and Incident Management system
• Responsible for creating functional requirements to develop Cognos cubes to utilize the data from the new data warehouse
• Creating and Testing Cognos Cubes by via drill up/down using different Dimensions and facts.
• Creating Ad-Hoc reports based on business scenarios and demonstrating to the end users
• Writing queries with complex joins, analytical functions, windowing functions, nested sub queries, common table expressions with levels, regular expressions to validate ETL processes
• Coordinating with the QA team to draw up the Test Strategy to test both ETL and Reporting processes.
• Helped the QA team by creating ad-hoc test cases from a business point of view and adding extra test cases based on learning’s from defects
• Validated prompts, filters, data, fonts, alignments, spell checks on the Cognos cubes.
• Validation of requirements document against Package and performing data validation on the packages
• Verification of layout and design Requirements of the cube against the User Functional Report Requirement Specification
• Submitted weekly bug or issue report updates to the Project Manager.
• Preparing and supporting the QA and UAT test environments
• Worked in agile methodology and attended daily SCRUM meetings.

Confidential

QA/Data Analyst

Environment: Microsoft SQL Server, Teradata, UNIX, LINUX Informix, DSS, Excel, HP Quality Center

Responsibilities:

• Prepared comprehensive test plan to validate the migration of decision support system from UNIX platform to LINUX platforms
• Identified report templates based on customer usage, traffic and prepared test cases based on metrics
• Data validation of the migrated environment by testing the dynamic multi-dimensional reports and checking the quality of the data with respective to the existing environment.
• Responsible for the requirements: ETL Analysis, ETL Testing and designing of the flow and logic for the Data warehouse project
• Created automated tool with VB.net to automate report submission to various environments and given users the ability to execute the same reports multiple times with different user ids and cross submitting them in different platforms
• Created and executed SQL queries to perform Data Integrity testing on an Microsoft SQL Server Database to validate the data for based on user criteria.
• Writing SQL queries and executing against the database (Teradata) and compare the raw output with that of the migrated report.
• Identifying the data validation scenarios and prepare the scripts and validate the data using automated utilities and tools.
• Identifying defects in the data during the testing, performing defect analysis,
• Preparing the status reports and also coordinates with the onsite and bridge the gap between onsite and offshore

Confidential

Consultant

Environment: Microsoft SQL Server, Microsoft Visual Studio, JavaScript, ASP, HR. net

Responsibilities:

• Analyzing the client’s requirement and the mapping document of migrating data from Source to Target.
• Developing proof of concepts based on client’s requirements and showcasing them for approval.
• Creating/Modifying tables/columns based on the requirements
• Developing triggers and workflows to achieve client’s requirement
• Developing reports using document explorer and creating complex SQL views to be mapped in the reporting architecture.
• Testing the SSIS package basing the mapping document.
• Performing Data Validation by analyzing data in both Source and Destination using SQL Queries.
• Coordinating with the onsite Team regarding clarifications in the Requirement.
• Defect Tracking, Reporting and Documenting.
• Test Status reporting on a daily/weekly basis.