SUMMARY:

• 10+ years of top flight experience as a Quality Assurance / Data Analyst with Expertise in Data Analysis, Data modeling, Database/Data Warehousing, Data modeling for data staging & Data Mart, Extraction , Transformation , Loading (ETL) , Indexing , Quality Assurance , Data updating plan , Data presentation to business users, Auditing, Backup and recovery.
• Experienced hands - on analytics professional adept at evangelizing & driving adoption of innovative solutions in the areas of data mining , analytics , data science and visualization .
• Strong experience in Data Analysis , Data Profiling , Data Migration , Data Integration and Metadata Management Services .
• Experience in dealing with different data sources ranging from Flat files, SQL server, Oracle, My SQL , MS Access and Excel and UNIX.
• Experienced in working with DB2, Teradata, SAS
• Strong background in Data Warehousing systems , proficient on designing and implementing SQL queries for QA testing and report / data validation using Oracle , SQL Server and DB2.
• Extensively worked on Data Profiling concepts to maintain the data quality and data reliability.
• Expertise in creating databases , users , tables , triggers , macros , views , stored procedures , functions, Packages and joins in Teradata database.
• Strong knowledge o f SQL , data analysis and data validation using SQL.
• Design and build SQL queries using Business Objects Intelligence tools and facilitated in data extraction and reporting. Have a strong knowledge of writing SQL scripts.
• Good experience with advanced Excel with a demonstrated model experience using Pivot tables, V-Lookup, H-Lookup and macros.
• Expertise in full life cycle business intelligence project management , understanding of all aspects of end to end life cycle design, development, implementation, testing and documentation of business applications.
• Tracked defects using Bug tracking tool ALM and Jira.
• Proficient in writing test cases , creating test data, verification and validation of data.
• Involved in development and execution of detailed system and user acceptance test plans, test cases and test scripts for manual and automated testing .
• Experience in Test Management tools like ALM , Quality Center, and Test Director
• Assisted in the creation of Test plan and Test Cases in HP QC.
• Expertise in integrating Cognos for advanced reporting and Cubes Validation.
• Strong in designing and automation of weekly/monthly interactive reports and dashboards in Tableau .
• Excellent in building pr edictive modeling like regression, clustering, sequential analytics and forecasting using SAS.
• Experience in conducting User Acceptance Testing .
• Excellent Communication , Presentation and Interpersonal skills, Self-starter, Team player with Project Management and Leadership skills

TECHNICAL SKILLS:

Project Methodology: Agile, Scrum, Waterfall

Test Management Tools: Rally, ALM 11, JIRA, qTest, Quality Center, Test Director 8.0

ETL Tool: Data Stage, Informatica Power Center 9.1/9.5, Abinitio

Query Tool: Teradata, Oracle 9i and 11g. Toad, DB2, SQL Server 2008/2012, Tivoli Work Scheduler(TWS)

Languages: SQL, PL/SQL

Operating System: Windows 10, Windows 7 9x/2000/XP, UNIX

BI Tools: Cognos, Cubes

Version Control Systems: SVN

Other Tools: SAS, Ultra Edit

PROFESSIONAL EXPERIENCE:

Confidential, WASHINGTON, DC

DATA ANALYST

Responsibilities:

• Developed SAS programs using Macros, Procedures for the business users.
• Worked in Agile framework across the board.
• Performed Data Validation with Data profiling .
• Developed complex SQL queries and REST API scripts that dynamically retrieve reviews, app usage and net promoter score data for both App Store and Google Play to gain valuable customer insights
• Involved in backend testing for the front end of the application using SQL Queries in Teradata database .
• Maintained metadata (data definitions of table structures) and version controlling for the data model.
• Used Excel advanced techniques like Pivot Table, V-Lookup & H-Lookup for mining data and perform analysis on different sources.
• Developed SQL stored procedures to load data into the Data Warehouse to create a Business Intelligence environment for generating analytical reports from multiple disparate sources.
• Logical Data modeling , created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Created User Stories into Product Backlog Items (PBIs) and lead PBI grooming sessions for Prioritization and Sprint planning .
• Held the Daily Stand-up Meeting , documented and updated the Burn-Down Chart.
• Involved in various Walk-through sessions with developers and gave presentations to help them understand the end user needs.
• Actively worked with the Scrum Master & Product Manager to monitor and prioritize product backlog on an ongoing basis to meet release timelines and value to the business.
• Worked towards continuous improvement of Agile and scrum practices.
• Managed bugs using Defect Tracking Tool JIRA , reviewed each defect and assigned development team to resolve problems.
• Executing the ETL Test Cases manually with the help of SQL scripts and UNIX Scripts .
• Raised defects in ALM and share initial cause for defect for development team for doing RCA .
• Look into DataStage jobs for the data flow and logic to validate requirements.
• Developed various reports for user verification like Cross Tab Reports and Sub Reports , various charts and graphs like Bar chart, line graphs, and Pie charts into formats like PDF, HTML, Excel, Word .
• Created functional specification documents that includes the data mapping & data analysis from different sources and coordinated with the development team for data conversion.
• Understanding and querying the master data tables to develop the KPI’s to measure the actual data quality to increase the efficiency of customer and vendor master data.
• Used ETL to load data in the data warehouse from various Source Systems.
• Responsible for Tracing Functional Requirements to Technical Specification in ALM
• Extensively used ETL to load data from Excel spreadsheet, flat files into the target databases.
• Extensively involved in Data Governance that involved data definition, data quality, rule definition , privacy and regulatory policies , auditing and access control.
• Involved in Business Intelligence (BI) and Data Visualization , analyzed the Transaction Processing Data (TPS) using advanced MS Excel/Macros.
• Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the source legacy system.
• Document data flows and assisted in development of the Master Data Management (MDM) data models (both conceptual and logical) and design and conduct data profiling.
• Expertise in using Data Modeling Tools for creating Logical and Physical Data Models.
• Present data profiling and subject matters to users of data.
• Worked with SQL queries, responsible for data mapping and data cleansing .

Confidential, Minnetonka, MN

DATA ANALYST

Responsibilities:

• Utilized agile software development methodology to manage and control software and product development.
• Extracted Data using SSIS from DB2 , XML , Oracle and flat files , Excel perform transformations and populate the data warehouse.
• Formulating various post production data quality and error handling SQL scripts .
• Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle .
• Created exceptions report using Congo’s which were then submitted to project lead and stakeholders on a regular basis.
• Automated the report generation process by using macros to develop the monthly KPI report that reduced the report.
• Used V-Lookup, Pivot Table, H-Lookup with advanced excel functions IF, COUNT with sort & filter to look at various proportions of data to build charts & graphs.
• Defined what data should be in the data mapping and the metadata information associated to customer data (including the documentation of business data definitions and rules).
• Perform data integration checks , reports anomalies and communicates with Data Architect for resolution.
• Performed data profiling and analysis applied various data cleansing rules designed data standards and architecture / designed the relational models.
• Performed Data Analysis of existing data through SQL and MS Access .
• Proven skill of Business Intelligence (COGNOS) and data visualization tools ( Excel ).
• Used SQL , Toad , Data Warehousing and Data Cleansing for the arrangement of customer data.
• Used SQL to run ad-hoc queries on Oracle / SQL Server and prepare reports to the management, written & validated T-SQL scripts and Stored Procedures for application development.
• Performed data analysis for testing that included supporting the ETL systems that interact with both OLTP & Data Warehouse System.
• Reported bugs and tracked defects using Quality center and ALM
• Conducted functionality tests with the team and end users to track defects using HP QC
• Performed and evaluated the benefits of the new system and generated workflows.
• Actively worked on large databases from different source systems that includes activities such as data modeling, mapping, development, integration, analysis and coordinating with testing team for defects .
• Extensively used SQL queries to first verify the data at file level and then at database level.
• Designed and implemented SQL queries for QA testing and report / data validation .
• Logged defects, monitored their status and tracked them using JIRA.
• Identified and analyzed the data requirements for the various site teams and made sure that the required data is available in the testing environment.
• Closely worked with Users and Technical team in managing and handling User requested Changes and User Conflicts.
• Developed documentation templates , specifications and schedules for technical writing deliverables.
• Analyzed and interpreted the technical information in order to compose User Manuals.

Confidential, NEWPORT BEACH, CA

DATA ANALYST

Responsibilities:

• Gathered and articulated System Requirements from User Interviews and Synthesis those requirements into technical specifications- Waterfall Methodology.
• Support daily/weekly/monthly as well as Ad-hoc reports (in Excel & UNIX scripts) requested by management and business users.
• Coded complex Teradata SQLs leveraging OLAP functions like RANK, QUALIFY, CSUM, SAMPLE and RANDOM, aggregator, string, date and join functionalities.
• Performing Data Analysis , creating GAP Analysis Document, and performing Data Quality Checking.
• Completed business process design and development project, included logical data flow diagramming , research and definition of data aggregation , validation of credit risk calculations & report format designs.
• Leveraged data visualization techniques for delivering reporting results in both a graphical and textual formats.
• Developed documentation templates , specifications and schedules for technical writing deliverables.
• Provided support for ETL processes that extract data from multiple sources residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses .
• Performed data mapping from Operational data store to the Enterprise Data Warehouse .
• Assisted business analysts in doing conceptual models/data profiling , data governance preparations.
• Provide Data Analysis, report, track and create KPI Metrics for the Business.
• Performed Data Analysis and data manipulation of source data from SQL Server and other data structures to support the business organization.
• Extensively involved in Data Governance that involved data definition, data quality, rule definition , privacy and regulatory policies , auditing and access control.
• Used advanced MS Excel with V-Look up and Pivot table functions to identify the issues in the data and helped in further modifications to build new versions.
• Developed complex Stored Procedures to efficiently retrieve/manipulate data as per requirement.
• Involved in Data Mapping to track all data elements used in the application from the user interface through different interfaces to the target databases in which they are stored.
• Followed best practices involving the business functional & non-functional needs to enhance the effectiveness of approach to time bound activities such as data extraction, loading & cleanup.
• Written SQL scripts to run ad-hoc queries, PL/SQL scripts, Stored Procedures & Triggers and prepare reports to the management.
• Assisted developers in writing SQL queries for validating data.
• Created and maintained Test Cases in Quality Center, and prepared dashboard reports using SQL statements in HP Quality Center (QC) .
• Designed and developed the Test plan and Test case documents.
• Closely worked with Users and Technical team in managing and handling User requested Changes and User Conflicts.

Confidential, INDIANAPOLIS, IN

BUSINESS DATA ANALYST

Responsibilities:

• Extensively used agile methodology and utilized Software Development Life Cycle (SDLC) to configure and develop process, standards procedures.
• Documented business functionality requirements in User Stories .
• Unix Shell Scripting was utilized and Korn Shell was used for automating logs, checking daily logs for automating backup procedures.
• Prepared process flow/activity diagram for existing system using MS Visio and re-engineer the design based on business requirements.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, using UML and Business Process Modeling.
• Created AS-IS and TO-BE business process flow diagrams , Integrate process flow diagrams to show end-to-end business model and business process mapping exercise including swim lanes.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Involved in massive data cleansing prior to data staging.
• Validated XML schema for system data documentation including the data requirement document.
• Understanding and querying the master data tables to develop the KPI’s to measure the actual data quality to increase the efficiency of customer and vendor master data.
• Used ETL to load data in the data warehouse from various Source Systems.
• Extensively used ETL to load data from Excel spreadsheet, flat files into the target databases.
• Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the source legacy system.
• Document data flows and assisted in development of the Master Data Management (MDM) data models (both conceptual and logical) and design and conduct data profiling.
• Expertise in using Data Modeling Tools for creating Logical and Physical Data Models.
• Present data profiling and subject matters to users of data.
• Worked with SQL queries, responsible for data mapping and data cleansing .
• Perform data validation, data integration and Backend testing.
• Retrieved Data using SQL queries and did Data Mapping and Data analysis.
• Worked on ETL and target mapping documents for business object migration to enterprise data warehouse.
• Identified Test Harnesses , which assisted QA effort in reducing the redundancy of Automation Scripts and made them more reusable.
• Analyzed Business Requirements from Black Box testing perspective; reviewed Test Strategy, Traceability Matrices and Test Plans to ensure that test cases reflect user needs for the functional, performance, usability and security requirements.