PROFESSIONAL SUMMARY:

• 10 plus years of experience as 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 SKILLS:

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, Requisite Pro, MS Excel, MS Share Point,Project 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: (Statistical Analysis) Minitab, SPSS, SAS, R, Python, Data Mining (Predictive Analysis) WEKA, Rapid Miner, Tracies, iDA, SAS

Risk Management Tools/(Mathematical Modeling Tools): Monte Carlo Simulations, Crystal Ball, What-if Analysis, andSensitivity Analysis, OPTQESTFile type.xls, .xlsx, Flat File, XML, X12 (EDI format), JSON, JAR

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

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

Reporting Tools: Oracle Business Intelligence, Tableau, MicroStrategy, SSRS

Servers: FTP, SFTP, EFT, windows, Linux

ETL Tools: Informatica Power Center, Tivoli, SSIS, Map2Code, ExtractMapperBIG Data Stacks, AWSApache Hadoop 2:Flume, Sqoop, HDFS, MapReduce (Java), PIG Latin, HiveQL, Hbase,Spark, Scala, Oozie, YARN, Apache Pheonix, CentOS, Shell, Linux,Java API, GITHub, Redshift, AWS Glue, EC2, DynamoDB,,S3, Elastic cache, Snowflake, Github

PROFESSIONAL EXPERIENCE:

Confidential, Santa Monica, CA

Sr. Data Quality Engineer, Lead

Responsibilities:

• Defined requirements for Talend studio set up for data profiling for data quality (DQ).
• Defined testing plan for cost metric testing.
• Managed projects for QA engineering efforts.
• Written & executed test cases for cost metrics testing.
• Peformed analysis for cost metrics.
• 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.
• 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

Consultant Manager

Responsibilities:

• Coordinated with Team Lead, PM and business to gather the requirements for data integration
• Performed data analysis and design for Huon - Datahub integration
• Designed tableau dashboard for auto club data
• 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
• 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 Lead\Product Owner\Asst

Responsibilities:

• Performed source systems data analysis such as SIS ERD, Data profiling, and business data requirements
• Performed target systems data analysis such as Duck Creek Data Insights schema analysis, referential integrity analysis, data analysis, key analysis
• Interacted with business user to get data requirements such as list of tables, attributes, tables
• Documented ERD, source to target mapping document (technical specifications), business requirements document
• 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
• Worked on 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
• 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 etc.
• 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/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 issuesDaily Activities:
• 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 improvementsOwnership of Data Integration - Guidewire Policy Center, and Claim Center with External VendorsPolicy Center Data feeds (Transaction: Property& Casualty- LOBs personal, commercial, homeowner)Involved in Enhancement & Maintenance
• E-submits Data feed (Inforce Policies as well as other transactions) in 13 different states on daily/Monthly basis
• Hartford Steam Boiler (Reinsurance) data feed, all states and LOB ‘Home Owner’
• Current Carrier Lexis Nexis for Personal Auto data feed, all states and LOBs
• Choice Point Elienholder for BA and HO data feed, all states and LOBs
• Agero ( Roadside Assistance) data feed, all states and LOBs, EARS ( Explore) data feed, all states and LOBsClaim Center Data feeds (Transaction: Property& Casualty)Involved in defining Objects/Attributes, mapping for Micro-Strategy Reporting
• Extensively used SQL queries for Data Validation, Data Quality), Data Manipulation, Data Integration, Data Governance, Data Dictionary, Data Segmentation and Data Conversion from legacy system to guidewire, data profiling for EDW, ER-Studio, Erwin, Data Cleaning and Micro Strategy Reporting
• Involved in creating data transformation logics to load the data into Staging & Data Warehouse byusing integration tools like Informatica
• Worked on DQ through Informatica Developer (IDQ) and data profiling through InformaticaAnalyst
• Involved with Testing team in reviewing Test plan, Test Cases, Unit and System Integration testplans, UAT
• Managed and track the requirements by developing Requirement Traceability Matrix (RTM) andperformed Sanity Testing
• Extensively used Guidewire Policy/Claim/Billing Centers, MS-SQL Server, Oracle, PL-SQL, Netezza, Teradata, Informatica, ERwing, ERstudio, Micro-Strategy Reporting, XML, Webservices, Sharepoint, WINSCP (FTP, and SFTP), Linux, Unix, SQL Assistant, Quality Center, JIRA, Clarity PPM (Project Portfolio Management), MS-Project, Service Now, Kanban Rally, MS-Excel, MS Access, Tableau, Liquid XML, MS-Visio and MS-Word
• Extensively used BIG DATA stacks such as PIG Latin, HiveQL, HBase, MapReduce, ApachePhoenix, My SQL, No SQL, for analyzing the data
• Good understanding about Spark, Scala, PostgreSQL, MongoDB
• Extensively used Flume, Sqoop, HDFS, YARN, Hadoop Clusters, Oozie for BIG DATA streamingand storing and performed Big Data CRUD operations in Apache Phoenix on HBase
• Performed Big Data Analytics by using ‘R’, ‘R-Studio’ for data visualization

Confidential, Los Angeles, LA

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.Screens:
• Course Master, Individual Request/Mass Request Editor, Change Course Assignment, Section Types/Request Generator, Manage Group/School Staff, School Period and Instructional Space etc.SSRS Reports:
• 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 theproject
• Extensively used T-SQL queries for Data Modeling, Data Validation, Data Manipulation, DataIntegration, 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, Testplans in Test Director ( HP Quality Center)
• Managed requirements by developing Requirement Traceability Matrix (RTM) and performedSanity Test to validate change after development
• 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

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
• Performed process and problem management by using incident ticketing system
• 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
• Performed extensive analysis for Fraud, Risk Management and Transaction Loss
• 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, 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

Responsibilities:

• 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 ACEM
• Performed data analysis for ACEM IT management
• Performed data analysis for ecommerce portal http://kathmandu.im/saleways/
• Gathered requirements for ecommerce portal design
• Involved in QA testing, UAT and post production support