PROFESSIONAL SUMMARY:

• 10 plus years of experience as Quality Lead, Manager, Sr.Data Analytics Lead/Technical (Data/Big Data) Lead/ Sr. BI Business System Analyst for Business Intelligence & Data Science projects with specialties in Requirements Gathering, Requirements Documentation, Scope & Vision Documentations, Testing and Data Analysis/Mapping/Modeling
• 6 plus years of experience in data analysis/project management/business analysis experience in Enterprise Data Warehousing (EDW/BI) Projects

TECHNICAL SKILL:

Methodologies: RUP, Waterfall, Agile (Scrum, XP)

Testing Tools: Mercury Test Director, HP Quality Center, JIRA

Data Modeling Tools: MS Visio, Erwin, ER Studio

Business Modeling Tools: Power Designer, MS - Visio

Project/Contents Management: MS Project, MS Excel, MS Share PointProject Portfolio Management, Service Now, Jira, Confluence

Defect Management Tool: Rational Clear Quest, QTP, Mercury Test Director

Databases: Netezza, Oracle, MS Access, MS SQL Server, DB2,Teradata, PL/SQL

Statistical Analysis Tools: Minitab, SPSS, SAS, R, PythonData Mining WEKA, Rapid Miner, Tracies, iDA, SAS

Risk Management Tools: Monte Carlo Simulations, Crystal Ball, What-if Analysis, and Sensitivity Analysis, OPTQEST

File type: .xls, .xlsx, Flat File, XML, X12 (EDI format), JSON, JAR

Operating Systems: Windows 2000/XP/Vista, MS Dos, Mainframe, Linux, ios

General: MS Office, MS Project, Lotus Notes, Excel Macro, VBA,HTML, PDFAdobe Photoshop, Excel - Pivot Table, Pivot Chart, Macro, V-look Up, H-look Up

Reporting Tools: Oracle Business Intelligence, Tableau, MicroStrategy, SSRS, BOPower BI, Cognos Referential Data/ Revenue Allocation Referential Data Interface/ART Rules

Servers: FTP, SFTP, EFT, windows, Linux, Unix

ETL Tools: Informatica Power Center, Tivoli, SSIS, Map2Code, ExtractMapperTalend, SAP Data Services BIG Data Stacks, AWS

Apache Hadoop 2: Flume, Sqoop, HDFS, MapReduce (Java), PIG Latin, HiveQL, HbaseSpark, Scala, Oozie, YARN, Apache Pheonix, CentOS, Shell, LinuxJava API, GITHub, Redshift, AWS Glue, EC2, DynamoDB,S3, Elastic cache, Snowflake, Harmony, Impala

PROFESSIONAL EXPERIENCE:

Confidential, Santa Monica, CA

Sr. Data Quality Engineer Lead

Responsibilities:

• Defined data management requirements for Talend studio set up for data profiling for data quality (DQ) and data goverance.
• Defined testing plan for cost metric dashboard & KPI testing.
• Managed projects for Data Analytics as well as QA engineering efforts.
• Written & executed test cases for cost metrics testing for SVOD, VOD, MVPD and other playback asset types.
• Performed data analysis for cost metrics dashboard.
• Tested harmony dashboard API by using JMeter, Postman, and SoapUI..
• Interacted with user and dev.team for requirements gathering for data lake to reporting model.
• Worked with dev. Team to define to data pipeline.
• Conducted daily stand up .
• Executed SQL in Hive, snowflake, and presto.
• Worked on Metadata, MDM projects
• Applied SEC and SOX compliance rules to manage data governance and data quality for cost metrics.
• Extensively used Bigdata Snowflake, Hive, Presto, Python, Fireworks, Hiveql, Hue editor, Jira, confluence (wiki), Talend for data profiling, Harmony Jobs, other open source systems.

Confidential, Costa Mesa, CA

Manager (Testing)

Responsibilities:

• Coordinated with Team Lead, PM and business to gather the requirements for data integration
• Performed data analysis and design for Huon - Datahub integration
• Performed source to target analysis for tableau design
• Developed Mapping in Informatica Mapping Designer
• Developed Workflow in Informatica Workflow Designer
• Designed ETL process flow in Informatica
• Created Source to target mapping for integration as well as dashboard design
• Managed onsite and offshore work load and resources
• Worked as QA engineering manger to drive test delivery management
• Executed test cases, test cripts, test plan, and test strategies
• Worked on data profiling for data quality management in Talend studio
• Extensively used, Informatica, SQL, Mainframe Bluezone, Teradata, DB2, IBM Data Studio, SPUFI, Guidewire, Guidewire Info Center, SAP Data Services, Cognos, Tableau, Jira, and Business Object.

Confidential, Santa Ana, CA

Data Analytics, Testing Lead

Responsibilities:

• Performed source systems data analysis such as SIS ERD, Data profiling, and business data requirements
• Documented ERD, source to target mapping document (technical specifications), business requirements document, test cases, testing plan
• Conducted sessions for Duck Creek Data Insight out of the box (OOB) for requirements gathering
• Gathered SSRS/Power BI reporting requirements which are utilized by Duck Creek Data Insights platforms, Data Warehouse, DataMart, and Tabular Model
• Gathered requirements for Duck Creek UI implementation for Policy & Claim Modules
• Worked closely with executives to discuss about Duck Creek Insights implementation strategies
• Analyzed and tested system integrations such as policy to Lexis Nexis, Verisk, Clue through SOAP web services API.
• Closely worked with on site and offshore development, QA team and business user for UAT
• Reviewed test cases, testing plan and test strategies.
• Performed ETL activity by using Map2Code utility in Duck Creek systems
• Extensively used Duck Creek UI, Data Insights, SQL server, Visio, SharePoint, TFS, ERwrin, ERstudio, Map2Code, Extract Mapper Excel, MS-Access, ViewPoint, SSRS, Power BI, DAX and SSIS, Hadoop, Python, R, XML, XSLT, manuscripts etc.
• The SOX and SEC compliance rules are applied as part of data goverance for account as well as finance reporting
• Extensively used DQ in Map2Code console to find data anomalies, duplicates, data quality
• Managed offshore and onsite resources
• Involved as delivery manager to deliver all the deliverables on timeline
• Worked on budgets and infrastructures of the projects
• Worked as product owner, and conducted daily scrum meeting to get the status update from entire team

Confidential, Brea, CA

Sr. BI Systems Analyst/Test Lead/Asst.TDM

Responsibilities:

• Worked on incident tickets on daily basis to support the Mercury Daily Business
• Interacted with business Director, SMEs, underwriting team, claim center team and CR on daily basis to resolve the production issues
• Scrum Meeting (Agile Methodology),Product Ownership, status update from the team members, Incident tickets Analysis, Trouble shooting the issue as per SLA, Defect Analysis/Enhancement Analysis, Open a Defect in Quality Center
• Requirement Documentations (BRD, FRD, SMT),Production Support, Data Analytics
• Manage development cycles with remote and onsite team members, Defining scope of the issues and managing/tracking them, Documentations of Change requests
• Monitoring: Outbound Process and Inbound Process for all the integrations and reporting on daily basis and coordinating with cross functional departments for process improvements
• Monitoring SOX compliance rules in inbound and outbound processes for accouting transactional data set.

Confidential, LA, CA

Sr.Technical Data Analyst

Responsibilities:

• Traced data elements required to meet Business Requirements(Business Rule) for user interface (UI screen) and reports
• Gathered and defined business requirements and translated requirements for Logical MiSiS (UI-Screen) UI module design and reports design
• Extensively involved in the following MiSiS UI & Reports design for Master Scheduling module.
• Course Master, Individual Request/Mass Request Editor, Change Course Assignment, Section Types/Request Generator, Manage Group/School Staff, School Period and Instructional Space etc.
• School Courses/District Courses, Student Request Scheduled/ Student Request not Scheduled
• Course Request Not Scheduled/Teacher Section Assignment, Student Course Request Summary/Class Enrollment Report etc.
• Worked with executive team for project planning, resource allocations, and scheduling of the project
• Extensively used T-SQL queries for Data Modeling, Data Validation, Data Manipulation, Data Integration, and Data Profiling, Data Analysis, and Data Quality
• Responsible for creating UML models, Use cases, Process Flows by using MS Visio
• Involved with Testing team in writing Test plan, Test Cases, Unit and System Integration, Test plans in Test Director ( HP Quality Center)
• Extensively used MS-SQL server, .net, HTML, SSRS, MiSiS modules, Sharepoint, Team Foundation Server, Excel, Excel Macros, MS Access, MS-Project, MS-Visio, MS-Word, and Quality Center

Confidential, Brea, CA

DW-BI Analyst

Responsibilities:

• Interacted with business users to capture the reporting requirements
• Design dimension (Policy Module) for KPI and Dashboard for MicroStrategy reporting model
• Created report in MicroStrategy as per the business requirements and Created defect for existing reports in quality center
• Executed T-SQL queries to perform data validation, data reconciliation, and data quality
• Involved in Data Integration from legacy systems application SQL server to Netezza
• Involved in Data Model to modify existing Data Model (Schema)
• Involved in creating source target mapping (Data Mapping) document as per the design needs
• Assisted testing team in writing test plan, test cases for Unit and System Integration test in Test Director (Quality Center)
• Performed data analysis, data profiling, data mapping for Data Warehouse - BI reporting model, data quality
• Extensively used Informatica, Informatica Developer (IDQ) and Informatica Analyst Erwin, ODI, Netezza, Oracle, DB2, Kanban Rally, DBVisualizer, MicroStrategy, Quality Center, GuideWire, and NextGen applications, Service Now
• Extensively worked on Policy, Claims and Billing center for source systems for NextGen, GuideWire, and PhxEast/PhxWest in external application system and internal Database

Confidential, Boston, MA

Sr. Data Designer

Responsibilities:

• Interacted with the project team to define system objectives and scope, feasibility study report and ­­identify constraints and the measures of success for the system being developed
• Conducted work sessions with Business Users and Data Standards Lead to get clear understanding about business requirements
• Followed Agile(scrum)methodology under SDLC to develop systems
• Responsible for designing Data Warehouse, and creating Data Movement Specification as per Business Requirement Document (BRD), and developed Use Cases, and UML diagrams
• Involved in data querying using MS SQL to do the Data analysis Prepared Data Analysis, Data Profile Report for documenting Data Quality issues
• Involved in Data Mapping for Data Integration from AXIS, FBSI, FPRS, INVESTONE (IOTA) and FA systems
• Involved in creating Data Model e.g. High Level Conceptual Model, Logical Model, and Physical Model and relate Data from external feed to Assets and Flows (FACT connection)
• Extensively used, ERP, IBM Netezza (Aginity Workbench), SQL Developer Oracle, Oracle Data Integrator(ODI), ERwing, ERstudio, Oracle Business Intelligence, HMTL, XML, Informatica Power Center, Tableau, Micro-Strategy Reporting, Crystal Reports, TOAD, and Rally Kanban Board

Confidential, Bellevue, WA

Data Systems Analyst

Responsibilities:

• Worked as a Data Analyst/ Business System Analyst and assisted the project manager in defining the Scope, Schedule, Business Change Management, Develop Feasibility Study Report for Preliminary Study of the Project, and Budget of the Project
• Participated with individual and JAD/RAD sessions (Work Sessions) with the stakeholders (Offer Management) and the technical units (Amdocs) for business requirement gathering followed by (Agile Scrum) approach
• Assisted the team members with documentations like Business Requirement Document and Use Case Specification Document by using DOORs
• Assisted in Data Analysis by Data Mapping among Enterprise Product Catalog, Web Product Catalog, SANSON (Billing System) and SAP (Inventory) then worked with the design team in the designing of the Databases with extensive use of ERDs for Data Validation, Reference Data Analysis, and Data Conversion
• Created a Decision Support System via Dimensional Modeling by ensuring appropriate FACTS tables, DIMENSIONS tables, attributes, and entities in order to generate MEASURES as required in Data Warehousing (EDW) and Data Migration by business users
• Extensively used, MS-SQL, Tera Data, Clarity PPM, .net, HTML, XML, Java, J2EE, .net, Web services, MS-Project, MS-Visio, MS-Office, TOAD, SQL Assistant

Confidential

Graduate Research Assistant

• Worked as teaching assistant in Department of Engineering
• Performed grading for engineering grad as well as undergrad students
• Performed Research on following:
• Business Analysis, Data Quality, Data Analysis, Data Warehouse, Predictive Modelling, Big Data Analysis, Data Mining, Data Integration and Data Extraction, Loading and Transformation

Confidential

Sr. Engineer- Data Analysis

Responsibilities:

• Teaching multiple classes as a lecturer in Confidential
• Performed data analysis for Confidential IT management
• Performed data analysis for ecommerce portal
• Gathered requirements for ecommerce portal design
• Involved in QA testing, UAT and post production support