We provide IT Staff Augmentation Services!

Sr. Data Analyst/technical Lead Resume

Santa Ana, CA

PROFESSIONAL SUMMARY:

  • 8 plus years of experience as Sr.Business System Analyst/Technical (Data/Big Data) Analyst with specialties in Requirements Gathering, Requirements Documentation, Scope & Vision Documentations, Testing and Data Analysis/Mapping/Modeling
  • Extensively used SDLC methodologies. Specific methodologies include Water Fall, Agile Scrum technique and Rational Unified Process (RUP) for managing iterative style of software development
  • 6 plus years of experience in data analysis/project management/business analysis experience in Enterprise Data Warehousing (EDW/BI) Projects
  • Extensive experience and understanding of Web Technology, ERP systems Finance, Investment, Property& Casualty Insurance, E - commerce, Service-Oriented Architecture (SOA)
  • Proficient in analyzing Data Quality Issues - Data Redundancy, Data Consistency, Data Completeness, Metadata Analysis, and Data Schema Study
  • Prepared Data Mapping Document comprising of Source Input Definition, Target/Output Details, Business Transformation Rules, and Data Quality Requirements
  • Proficient in executing SQL queries for data analysis and preparing Data Profile Report
  • Performed Data Mining in order to determine Data Mappings between various systems
  • Ability to interpret/build Data Models - Logical Data Model, Relational (Normalization) Model and Dimensional (Star and Snow-Flakes) Model, Meta Data Schema, Data Validation
  • Strong understanding of OLTP, OLAP, ETL, Data Integration, Data Migration, Data Conversion and Distribution, Data Flux Kimball & Inmon DW Models, Data Acquisition
  • Proficient in analyzing data by Data Mining, Statistical Analysis of data, Forecasting, Quality Control in Manufacturing and Production by applying Statistical Analysis (Control Charts), SPC, SIX SIGMA, ITIL, Lean Manufacturing, Logistics, Transportation, Simulations, DMAIC, DOE, ISO standards, Business Optimization, Process Flow, FEMA, TQM, DFM, and 5s­­­­
  • Broad Knowledge in reviewing Test Procedures, creating Test plans, Test scenarios, and defining Test cases for both System & Integration Testing
  • User Acceptance Testing (UAT) with Test Plan, Assigning Team, Execution, Documentation and Defect Report
  • Worked closely with QA team in planning Unit Test, Regression Test, Performance Test and System Integration Test
  • Expert in using Load Runner for load testing, Quality Center/Test Directory for test management and QTP for regression testing and functional testing

TECHNICAL SKILLS:

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

Testing Tools: Confidential 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 PointProject Portfolio Management, Service Now

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

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

Statistical Analysis Tools: (Statistical Analysis), Minitab, SPSS, SAS, R

Data Mining (Predictive Analysis): 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

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

Referential Data/ Revenue Allocation: Referential Data Interface/ART Rules

Servers: FTP, SFTP, EFT, windows, Linux

ETL Tools: Informatica Power Center, Tivoli, SSIS

BIG Data Stacks: Apache Hadoop 2, Flume, Sqoop, HDFS, MapReduce (Java), PIG Latin, HiveQL, HbaseSpark, Scala, Oozie, YARN, Apache Pheonix, CentOS, Shell, LinuxJava API

PROFESSIONAL EXPERIENCE:

Confidential, Santa Ana, CA

Sr. Data Analyst/Technical Lead

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, reference data analysis, key analysis
  • Interacted with business user to get data requirements such as list of tables, attributes, reference 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 reporting requirements which are utilized by Duck Creek Data Insights platforms
  • Gathered requirements for Duck Creek UI implementation for Policy & Claim Modules
  • Worked closely with executives to discuss about Duck Creek Insights implementation strategies
  • 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, Map2Code, Extract Mapper Excel, MS-Access, ViewPoint, SSRS, and SSIS

Confidential, Brea, CA

Sr.Systems Analyst/Technical Analyst/BI Data Analyst

Responsibilities:

  • Worked on incident tickets on daily basis to support the Confidential 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

Confidential

Involved in Enhancement & Maintenance

Responsibilities:

  • 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 LOBs
  • Catastrophe Report, No Financial Activity Report, PIP Report, Medicare Report, BME 992 Report to productivity counts by group and branch, Vendor Payment Summary Reports and Material Damage Reports, Cars Reports (Vendor Body shop),Legal Tracking Reports and many other claim center reports
  • Extensively worked on KPI (performance indicator) and Dashboard Design for Claim transactions by productivity tracking
  • Policy Uptiering during renewal conversions from Duck Creek as well as Guidewire systems
  • Involved in Informatica data mapping, work flow monitoring and Tivoli job monitoring, updating the run books and /XML/XSD/HTML/FLAT files mapping
  • 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 by using integration tools like Informatica
  • Involved with Testing team in reviewing Test plan, Test Cases, Unit and System Integration test plans, UAT
  • Managed and track the requirements by developing Requirement Traceability Matrix (RTM) and performed 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, Apache Phoenix, 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 streaming and 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

Sr.Technical Analyst/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
  • Responsible for creating UML models, Use cases,, Process Flows by using MS Visio
  • Analyzed and modeled the system using Data flow Diagrams, and Data Models (Logical and Physical) and created Process Flow Diagrams, Integrate process flow diagrams to show one end-to-end business model
  • Involved with Testing team in writing Test plan, Test Cases, Unit and System Integration, Test plans in Test Director ( HP Quality Center)
  • Managed requirements by developing Requirement Traceability Matrix (RTM) and performed Sanity 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 Center

Confidential, Brea, CA

Business Systems Analyst /DW 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
  • Managed requirements by developing Requirement Traceability Matrix (RTM) and performed Sanity Test
  • Performed process and problem management by using incident ticketing system
  • Performed User Acceptance Testing to verify the end results
  • Extensively used Informatica, 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

Business Systems Analyst/ DW/BI 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
  • Extensively used RDI (Referential Data Interface) and ART rules for manual data load and for revenue allocations

Confidential, Bellevue, WA

Data Analyst/Business System 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
  • Assisted in creating Data Sample that included specific size of data from the database reflecting different data field elements’ values. Data Sample would then be compared with Source Application Systems to test the accuracy of data field elements values
  • Extensively used, MS-SQL, era Data, Clarity PPM, .net, HTML, XML, Java, J2EE, .net, Web services, MS-Project, MS-Visio, MS-Office, TOAD, SQL Assistant

Confidential

Business Data Analyst

Responsibilities:

  • Conducted user interviews and Work Sessions (JAD) by using Agile (scrum) methodology to get understanding of client business process
  • Gathered data requirements for the system by interacting with the users and data administrators
  • Responsible for creating the Business Requirement Document (BRD)and the Functional Requirement Document (FRD), and developed Use Cases, BPM, UML diagrams
  • Involved in data querying using SQL to do the data analysis and validate the data. Prepared Data Profile Report for documenting Data Quality issues
  • Carried out Data Quality Assessment - subjective and objective in order to categorize quality issues across various data quality dimensions using various quality metrics and devised rules to resolve data quality issues
  • Involved in Data modeling (Logical Modeling and Physical Modeling), Data Mapping, Data Conversion, Data Validation, Data Profiling, Data Migration, and Schema Design for Enterprise Data Warehousing
  • Performed in Data Quality Assurance by using SQL, Excel VLook up, and Excel Macros
  • Set up definitions and process for test phases including Sanity test, Integration test, System test and User Acceptance Test (UAT) by using Clear Quest, QTP and HP Quality Center

Hire Now