SUMMARY:

• Highly accomplished IT professional with 10+ years of experience in Insurance industry in Business Systems Analysis, Data Analysis, Data Profiling, Application Design, Development, Production support and Client Relationship Management
• Skills in gathering requirements and creating Business Requirements Document (BRD) and Functional Requirement Documents (FRD), facilitating Joint Application Development (JAD) sessions, rapid application development (RAD sessions, developing Use Cases, Test Approach, User Acceptance Testing (UAT), Requirements Traceability Matrix (RTM) and other client specific documents
• Experience in Data Profiling to identify data issues and recommend ideas for resolution
• Strong knowledge on Insurance Industry P&C - Business and Personal Insurance and experience working with various insurance Line Of Business, Third party data, Risk Management etc.
• Strong experience in working with various database environments like Oracle, GreenPlum, Teradata, IBM DB2, SQL Server 2010 and MS Access databases
• Excellent team player with experience in working large size project team / Strategic initiatives that includes Business stakeholders, Architects, Project Manager, ETL Developers, Quality Assurance team
• Proficient in eliciting requirements and assisting the ETL/ Quality assurance team for business intelligence / data warehousing environments including technologies and processes across data sourcing, validation, reconciliation, and reporting
• Strong experience of directing the cross-function teams across complex strategic initiatives in a matrix company environment
• Expertise in performing complex GAP Analysis and Impact Analysis on various large sized projects
• Awareness to various ETL and Business Intelligence tools that includes Ab Initio, Informatica, Business Object Crystal Reports, Cognos etc.
• Awareness of major SDLC methodologies & models - Staff Augmentation, Co-Sourcing, Managed Service, Fixed Prices, Waterfall, Agile in both onsite-offshore model
• Leadership & Management Skills: Focused on integrating business customers, business process and technology to deliver business value. Expertise in various management activities includes resource management, on boarding, knowledge transition, supervision and performance appraisals
• Excellent in implementing theoretically and practically sound solutions with end users in mind
• Ability to adapt to change, balance multiple priorities and meet deadlines
• Highly motivated, strives for excellence in deliver with strong communication skills, fosters relationships and active participant in process improvement
• Extensive collaboration with the Quality Assurance in providing inputs to create Test Strategy, Test Plans, and Test cases
• Strong analytical and organizational skills with acute attention to detail
• Experience with statistical filing, regulatory and management level report content and fulfilling these requests
• Strong knowledge of MS-Office products, Mercury tools, JIRA, TFS and Remedy

TECHNICAL SKILLS:

Business modeling: Microsoft Visio

Requirement Management: Microsoft Office (Word & Excel), TFS

Front end tools: Microsoft Front page, Microsoft Project, Microsoft Office, .Net

Defect Tracking: HP Quality Center, JIRA, TFS

Query and Programming: SQL, XML, COBOL, VB Script, Java Script, VBA, HTML

Databases: Oracle, GreenPlum, Teradata 13.0, DB2, MS Access, SQL Server 2010

Document Management: VSS, SharePoint

Methodologies: Waterfall, Agile, Iterative

Tools: WinSQL, SAS, Business Objects, IDQ, Meta Center, GW Policy Center, TOAD, HP MIS, SCM/ISCMS, Rally, AQT, Rational Rose, Ab Initio Web EME, Business Object Universe, Informatica, GuardIEn

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Senior Business Data Analyst

• Requirements gathering to support data and reporting initiatives, data profiling and user acceptance testing strategy development and execution

• Worked with all divisions across the enterprise to capture business requirements related to data and reporting solutions to support corporate strategies, goals and objectives
• Provided leadership involving conceptualization, initiation, specification and testing of the data and reporting solutions
• Identified drivers of business results and recognize appropriate measures, and translate that information to business analytics
• Worked closely with I/S to identify technology opportunities, share the business vision and strategy, and to ensure alignment of solutions to business needs.
• Provided day to day support for data users to foster adoption and identify additional enhancements.
• Developed data management and reporting requirements and managed data quality in collaboration with business systems and data department
• Identified sources of information for a wide variety of problems and needs
• Developed effective methods to improve the quality of information gathering, resulting in improved content and value
• Coordinated with domain experts to develop and refine data management best practices, policies, and procedures
• Produced various functional, data load and validation specifications, workflow and process documentation
• Created documentation, extracted and analyzed data, managed requirement changes, performed UAT
• Handled multiple projects and assignments with changing priorities while still meeting deadlines
• Studied complex data models and process flows, their inter-dependencies and relationship to Credit Risk
• Served as a liaison between technology, operations, product management and the Data Analytics team

Confidential, Hartford, CT

Senior Business Data Analyst

Responsibilities:

• Created System Requirement Document (SRS), Detailed Requirements Document (DRD), Source to Target mapping document (STTM) and Traceability matrix

• Involved in different levels of data profiling, data mining activities
• Participated in Joint application requirement sessions to gather requirements and documentation
• Actively participated in program planning and project planning for the year 2013/2014
• Served as a liaison between the business specialists and the technical team
• Contributed to the definition of scope, preparation of work plans and definition of business requirements.
• Assisted ETL development done using Informatica and universe development using business objects
• Performed the reverse engineering in Informatica to understand the ETL logic
• Participated in the review of Test Strategy and Test plan documents
• Assisted the function lead in creating of estimate and defining the roles/responsibilities in the project
• Documented business process flow charts; business requirements; data sources and attributes; dimensions, facts, metrics, filters, etc.,

Confidential, Hartford, CT

Business Data Analyst

Responsibilities:

• Create DA work package that included Analysis Tree, SQL Vision and SQL Results

• Responsible for data analysis and data mapping for MS SQL Server and Teradata
• Mentored team members and provided adequate training to new DA’s in the project
• Served as a liaison between the business specialists and the technical team
• Contributed to the definition of scope, preparation of work plans and definition of business requirements.
• Facilitated and managed meeting sessions with committee of Subject Matter Expert from various business areas
• Responsible for gathering user requirements that are specific to our scope of work
• Participated in JAD sessions for requirements gathering
• Performed Risk Analysis of the requirements to identify the project critical success factors and prioritize functional requirement
• Created Functional Requirement, reviewed with stakeholders and received sign-offs
• Created Requirements Traceability Matrix document reviewed with stakeholders and received sign-offs
• Participated in Required Data Elements sessions and identifying the sources
• Participated in creating test strategies, test plan for QA testing. Also involved in identifying the test scenarios for UAT

Confidential, Hartford, CT

Business Data Analyst

Responsibilities:

• Involved in Data Profiling, writing scrub rules, providing input to data modelers that include Data type and length

• Dealt with more than 5000+ data attributes, data mapping and modeling
• Involve in the data profiling activities for the column assessment and natural key study
• Assisted the project manager in setting up the direction for business analysis team
• Allocate the work to DA team members and oversee their daily work and perform quality check
• Forward to the PM any other matters requiring substantive or time-consuming issue resolution (i.e. resource response time, communications, project workflow, etc.
• Schedule and facilitate the daily stand meetings, weekly touch point meeting with Dev and QA team
• Scheduled, Facilitated and managed meeting sessions with business team members from various business areas
• Responsible for gathering user requirements that are specific to our scope of work
• Closely worked with Data Modelers with support and clarification on the requirements
• Responsible for data analysis and data mapping via MS SQL Server
• Performed Risk Analysis of the requirements to identify the project critical success factors and prioritize functional requirement
• Developed the Functional Requirement documents, reviewed with stakeholders and received sign-offs.
• Created Requirements Traceability Matrix document reviewed with stakeholders and received sign-offs.
• Participated in Required Data Elements sessions and identifying the sources
• Participated in creating test strategies, test plan for Quality Assurance testing and involved in identifying the test scenarios for UAT

Confidential, Hartford, CT

Business Data Analyst / Onsite Coordinator

Responsibilities:

• Documented business process flows; business requirements; data sources and attributes; dimensions, facts, metrics, filters, etc., Inventory Control Reporting

• Worked with data modeler to design table structure(s) for DW
• Worked with IT to populate table structure(s) and perform UAT of data
• Developed Micro Strategy report(s) and/or dashboard per documented business document
• Provided weekly status report of progress and hours worked
• Worked with SQL, Micro Strategy Platform - Web Professional v9.4.1, Query Building tool
• Knowledgeable in data discovery and data profiling
• Documented business reports and/or dashboards in Micro Strategy
• Prepared operational BI Reporting
• Presented dimensional models and BI concepts like attributes, facts, and metrics.
• Documented business process flows
• Prepared UML diagrams to develop a pictorial representation of the requirements
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping
• Collected information about different entities and attributes identified primary keys and foreign keys for the entities. Mapped surrogate key tables to the required dimensions

Confidential, Hartford, CT

Tech Lead, Onsite Coordinator

Responsibilities:

• Ensure compliance with Travelers Architecture standards

• Assess impact of project requirements on application architecture
• Review architectural changes and provide optimum cost-effective solutions
• Provide estimates for projects in demand queue
• Provide technical guidance to the team
• Responsible of design documents
• Participate in request prioritization activities
• Participate in status review meeting
• Approve Endevor packages
• Partner with DevOps and Release Manager to Ensure Deployment

Confidential, Hartford, CT

Offshore Team Lead

Responsibilities:

• Point of contact for test environment set up and maintenance

• DB2 database maintenance and DBA activities
• Provide off hour Support to the applications
• Automated regular activities
• Communicate with offshore to give technical updates, review offshore activities and resolve technical queries
• Development of Quality Procedures related to the project and Metrics Collection
• Maintenance of Knowledge Repository

Confidential, Houston, TX

Mainframe Programmer

Responsibilities:

• Responsible for enhancements to the existing system based on the business and technical and requirement specifications

• Involved coding, testing, and debugging both online and batch programs
• Preparing Test Strategies, Unit and Integration Test Plans, troubleshooting and supporting the developed code on mainframes
• Support for batch schedule and resolving the abends
• 24 x 7 On-call support for the V-System application
• Preparation of delivery documents and checklists
• Work Allocation and monitoring
• Getting reviews done as per schedule
• Ensuring timely and defect free delivery