Data Project

SAYYED MOHAMAD

Mail: ******.***@*****.*** Mobile: 806-***-****

Executive Summary:

Over 10 years of hands-on experience in data analysis and delivering quality Business Intelligence, Data Warehouse and ETL solutions built using: Informatica, Oracle BI Apps, Tableau, OBIEE, Microsoft Data Transformation Services and Microsoft SSIS

Extensively worked with various data stores such as Oracle EBS, MDM, Demantra, Salesforce.com, various Databases, Flat Files, Cobol VSAM files and many more

Experience in delivering Out of the Box and customized OBIA Modules of Supply Chain and Order Management, Procurement & Spend Analytics with Oracle EBS as source

Expertise in data analysis, requirements analysis and managing entire testing life cycle

Extensively worked on Supply Chain, Order Management Analytics, Offers & Contracts and Insurance projects

Expertise in analyzing hierarchical data, Storyboards, Dashboards, KPIs and rich graphic vizzes

Experience in analyzing Time series objects, snapshot objects, hierarchies, calculated measures, charts, maps, trends, integration testing using web services and so on

Validated Storyboards, Dashboards, Reports with different Analytical views, blended vizzes and KPI’s using Real-time and historical data

Strong domain knowledge of Insurance, Retail and Salesforce CRM

Well versed with SDLC, STLC, ITIL and Unified Process; Waterfall model, Agile methodology (Scrum deliverables); Knowledge of Scaled Agile Framework (SAFe)

Good experience in Data Analysis, Data Collection, Requirements gathering/analysis; Actively participated in Joint Application Design (JAD), User sessions and Scrum meetings

Good understanding of Business Intelligence and Data warehousing concepts with emphasis on ETL and Reporting functionality

Hands-on experience in planning overall testing activities and executing the plan; Identifying risks to schedule/quality/cost, prepare mitigation plans to ensure on time and high quality deliverables

Good understanding of relational and dimensional data models; ETL and Reporting architectures

Knowledge of Amazon Web Services (AWS), DevOps, BIRST BI, Power BI

Ability to work on multiple projects in parallel; Customer focused and self-motivated

Skill Set:

ETL/ELT Tools : Oracle BI Apps 7.9.6.x, Informatica, DAC, Microsoft DTS / SSIS, ODI (trained)

Reporting Tools : OBIEE 11g, Tableau

Languages : SQL, PL/SQL, Unix commands, Shell scripting, Visual Basic, Core Java, HTML

Databases : MS SQL Server, IBM DB2, Oracle, PostgreSQL, DynamoDB

Operating System: Unix / Linux, Windows

Other Tools/Apps : Informatica TDM, Oracle E-Business Suite, Demantra, Control-M, Putty, Core FTP, File Zilla, AQT, TOAD, SQL Developer, HP ALM, HP QC, Microsoft TFS, Elementool, BMC Remedy, ClearQuest, Peregrine, UnITy, PlanIT, ManageIT

Certifications/Achievements:

ISTQB Foundation Level, Certified by UKTB

Property and Liability Insurance Principles (INS 21), Certified by AICPCU

Oracle Database SQL (1Z0-071)

Oracle Business Intelligence Applications 7 for ERP Certified Specialist (1Z0-525)

MCTS: Implementation and Maintenance of Microsoft SQL Server 2005 (70-431)

Education:

Pursued Master Computer Applications (MCA) in 2007, from Andhra University, India

Pursued Bachelor of Science (Computer Science) in 2004 from Andhra University, India

Professional Experience:

Currently employed with TechPillars Inc.

Working at TEKsystems Global Services from October 2014 to October 2017

Worked at Computer Sciences Corporation (CSC) from June 2007 to October 2014

Projects Profile:

Project: BI - Campaign 2 Cash Role: BI Test Lead

Client: Canon TEKsystems, Jun ’16 - Oct ‘17

Key Responsibilities:

Understand third-party PearlChain source systems (Configure Price Quote, Contract Management) and get familiarity with functional flows

Working with Analysts, Architects and SMEs to understand requirements, design, interfaces and dependencies in detail and identify gaps, if any

Responsible for Test efforts estimation, Test Planning, Test design, Test environment setup and test data arrangement for historical & incremental data loads and to fulfill adhoc needs

Coordination with third party vendors, customer and other stakeholders

Validation of security implemented at Object, Data and Column levels; Regression of existing ones

Validation of Dashboards, Side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps, calculated measures etc in detail against the given prototypes and business logic

Analyzing BI results against Contacts, Leads, Opportunities flowing from Salesforce; Configurations, Price, Quotes, Workflows, Contracts, Billing, Invoices, Accruals created in PearlChain

Validation of web services; historical data and daily incremental data

End-to-End testing of Data warehouse and BI systems with upstream and downstream systems: Salesforce, PearlChain CPQ, PearlChain Contract Management, Oracle EBS R12

Manage project execution, resources and report progress in daily stand up meets

Responsible for coordination and SIT triages with Customer and onshore/offshore team, Internal and external stakeholders

Played UAT Test Coordinator role and coordinated with UAT testers, Business and project teams

Defect Management and Analysis; Timely escalations of longing defects and open items

Trained users on new BI solution and captured new requirements, change in requirements for upcoming sprints

Participation in project management meetings, preparing Project KPIs and closure documents

Identifying project risks, timely escalations and planning for mitigation

Attending JAD sessions, Sprint Planning meets, Daily Scrum meetings, Sprint reviews, retrospective meetings; Preparing Quality KPIs and Closure docs

Environment: Oracle BI Apps 7.9.6.4, Tableau 10.0, OBIEE 11g, SQL, PL/SQL, Oracle 10g/11g, PearlChain CPQ / CM, Salesforce, Siebel, Oracle EBS R12, Oracle DAC, REST API, GitHub, HP ALM

Project: BI Insights, Supply Chain Management Role: BI Test Lead

Client: Canon TEKsystems, Oct ’14 - May ‘16

Key Responsibilities:

Requirements understanding, Gap analysis; Reprioritization and Rescoping of Requirements

Confer with Product owners, Analysts, Architects; Understand functional specs and identify gaps if any, interfaces and dependencies involved

Implemented Procure to Pay (P2P), Order to Cash (O2C) flows

Responsible for Test estimation and planning, Test design, Test environment and test data setup

Coordination with vendors, customer and other stakeholders; Tasks distribution and Sprint reviews

Validated Tableau Vizzes to evaluate year over year, quarter over quarter, YTD, QTD and MTD’s to analyze allocation and actuals of budget, forecast and thus analyze sales performance

Validation of complex BI dashboards, BI publisher Reports, Analyzed Engineer Performance

Thorough validation of Object level security and Data level security

Validation of web services, historical and incremental data; Reviewing test results captured by peers

Validated OBIEE Integration with Oracle EBS, Oracle Discoverer Reports, Demantra, SteelWedge, Siebel and various other flat file systems

Validation Report performance, non-OOTB issues and followed up with Oracle on OOTB issues/service requests

End to end validation of Supply Chain, Order Management, Procurement and Spend flows

Validated BI Integration with various sources: Oracle EBS – R11 & R12, Oracle Discoverer Reports, Demantra, SteelWedge, Siebel and various other flat file systems

Validated BI dashboard reports, BI Publisher Reports, reporting quantities in multiple UOM's

Manage test execution, QA resources and report daily test progress to Project Management

Defects logging, follow up with various stakeholders on the issues and dependencies, for the closure of the defects and report defects status to internal and external Management

Report work progress in Scrum meetings; Identify project risks and prepare mitigation plan

Participating in JAD, Sprint reviews and Retrospective meets; Preparing KPIs, Closure docs

Plan and conduct SIT defect triages and participate in project management, UAT Defect triages

Quality closure, preparing and justifying quality KPIs

Environment: Oracle BI Apps 7.9.6.4, OBIEE 11g, Oracle 10g/11g, Oracle Demantra, Oracle EBS R11, Informatica TDM, Oracle EBS R12, SOAP API, HP ALM

Project #4: CSC Workstation Role: Salesforce CRM Analyst

Client: Unum Corporation CSC, Dec ’13 - Oct ‘14

Key Responsibilities:

Confer with Business Analysts, SMEs, Technical Leads at Unum Client office and acquire knowledge on Unum Insurance business, applications and their processes

Assess interface applications such as I3, CMS, CME, the current system and the proposed one

Participate in Salesforce CoE and Joint Application Design (JAD) meetings, Understand functional and non-functional requirements for sprints in Phase-1 & 2 initiatives

Analyze system requirements, assisting on use case diagrams and preparing designs; Setting up resources and access required for project team members

Analyze system requirements, assisting on use case diagrams and preparing designs; Setting up resources and access required for project team members

Agile testing SFDC CSC Workstation integration with I3 Telephony system (Phone call to Case) and Unum Help Desk (Email to Case)

Ensuring user stories of Salesforce Marketing, Sales, Service cloud process are well-handled

Preparing Test Plan and authoring Test Objectives, Test scenarios with respect to User Stories

Presenting regular walkthroughs to Business stake holders, Scrum team

Attending scrum meeting, sprint review meetings, retrospective meetings etc

Environment: Salesforce.com, Apex, SOQL, SOAP API, Quality Center

Project: BI for IT Role: ETL Tester

Client: EMC CSC, Jan ’13 – Nov ’13

Key Responsibilities:

Analyze functionality of the applications and the requirement specifications

Develop, document and maintain functional tests and other test artifacts such as test data, data validation, harness test scripts etc

Designed and executed SIT tests; Authored tests for Regression testing, Performance testing

Status reporting, project tracking, documentation and reporting

Data validation of Incidents & Requests, Activities, Tasks, Calendars, Users, Actual efforts, Time sheets, Contacts, SLAs, IT Metrics, Feedback, Projects, Resources etc) between Source and Targets

Used pgAdmin for Greenplum, Oracle and SQL Server for SQL querying to validate ETL process

Used SFTP; and Shell scripts to cleanse junk data and move/archive data from SFTP to Infa server

Execution of Control-M jobs and Informatica Workflows based on need

Log issues detected; Support Change Requests such as RFC, eRFC, Monthly Cycles etc

Sanity test of Informatica 9.5.1 upgraded jobs to ensure workflows/Control-M jobs are as expected

Reporting issues to Admins, Project Management; Preparation of test summary report

Environment: Informatica 9.1, HP QC, Greenplum, pgAdmin, SQL Server, Oracle, Toad, Flat Files, Unix, Shell scripting, Control-M, File Zilla

Project: Optiload Decommission, Ultraflex Reporting Role: ETL Developer

Client: Zurich North America CSC, Dec ’10 – Dec ’12

Key Responsibilities:

Review functional and design specifications to ensure full understanding of individual deliverables

Interact with source team in understanding existing third party system – Optiload. Interact with Onshore coordinators and analyze Business specifications

Preparing High Level Design and Low Level Design documents as per proposed approach

Extraction, Transformation, and Loading Development using Informatica

Developed File-to-Table and Table-to-Table (both Full refresh, and Incremental) mappings

Developed mappings, mapplets, session tasks, command tasks, workflows for loading data from source flat files & tables into target tables

Extensively worked on SQLs to validate data transfer from source to target

Implementation of error handling, balancing logic. Peer reviews of the mappings/programs. Bug fixing. Preparation of Unit test cases. Perform Unit Testing

Support to testing teams and Users during SIT testing and User Acceptance testing

Reporting work status to Project Manager and Clients in Status meetings

Preparing necessary Quality documents according to the SDLC phases, check in/check out documents into TFS, sign up for client reviews etc

Environment: Informatica 8.6.1, COBOL VSAM files, Mainframes, IBM DB2, MS SQL Server, Unix, Shell scripting, Flat files

Project: BIW and Zurich Municipal LRP Release 5 Role: Quality Analyst

Client: Zurich CSC, Jun ’07 – Dec ’10

Key Responsibilities:

Authoring Test Plan, Test Strategy, Test scripts based on the requirement specifications and mapped test coverage to requirements in Requirement Traceability Matrix (RTM)

Worked on executing Functional, Integration, Regression, and System (end to end), ETL testing

Extensively used Microsoft Data Transformation Services and SSIS to run the DTS jobs to pull data from Real-time database to Overnight database

Analyzed and thoroughly validated source and target data

Used Microsoft TFS as Test management and defect management tool

Follow up with Developers on Defects until the test case is passed

Used DB2 and SQL Server for creating & executing SQL queries for testing ETL process

Creation of test data and validation of Full/Incremental loads and ensure Inserts & Updates as part of data loads is happening correctly

Authoring Functional Test scenarios, and detailed Test cases as per design document

Authoring ETL Test cases for the migration of existing DTS packages to SSIS packages

Analyzing application documents and preparing Integration Test cases for the Mainframe, MQ & File Net based interface systems

Bringing up requirements/concerns related to access, Test data, environments, data sensitivity, set up users/user roles and valid user data/documents to Client’s consideration

Used SQL Server 2000/2005/2012 for creating and executing SQL queries for validating merged databases and ETL jobs. Validated web services and business intelligence reports

Reporting status and concerns to Clients, Test Management and Project Management

Environment: Microsoft SSIS Microsoft DTS, MS SQL Server 2000/2005, Crystal Reports XI, MS TFS, .Net 1.1/2.0/4.0 and SQL Server 2000/2005/2012, WCF/Web services, MCMS, Sharepoint, HP ALM

Contact this candidate