Data Insurance

RAGHAVENDRA VERNEKAR

Business Systems Analyst

Phone: 617-***-****

E-mail: *******************@*****.***

PROFESSIONAL SUMMARY:

Over 11 years of solid experience leading and carrying out all phases of full SDLC lifecycle, planning, analyzing, designing, building, and testing applications, maintaining and modernizing legacy applications

In-depth knowledge of Information Management, end-to-end Data Warehousing, Business Intelligence, Data Integration & Data Migration. Developing Data Warehouse roadmap, Data Analysis and Data Mappings, strategy and architecture, data modeling, dimensional data marts for end-user reports

Experience in diverse domains such as Insurance, Retail, Telecommunication and Banking Industries as a Business Systems Analyst

Hands-on knowledge of Data warehousing ETL tools viz. Informatica Power Center, Solution architecture, Technical architecture, Data Profiling, Data cleansing technologies, testing strategies and on RDBMS technologies SQL, Teradata, and Oracle

Knowledge of Data warehousing fundamentals, Database Design, Entity-Relationship Modeling, Dimension Modeling, Star Schema & Snowflake with Kimball methodologies

Advanced user of Microsoft Office applications including MS word, Outlook, PowerPoint, Visio, Excel and SharePoint

Interacted with Senior Architects, SME’s, Business users and Technical Administrators at client site for solution implementation in both Agile and Waterfall methodologies

Experience in documenting Business Requirements, High Level Design, Process Flow diagram, mapping and technical specification documents BI applications

Proven ability to lead and implement complex systems that are flexible, easy to maintain, reuse code and business rules, and that align to business objectives

Driving team communication to improve transparency and sharing information to ensure that personal, team and organizational goals are aligned

KEY SKILLS:

Proven strategic thinking skills

Excellent analytical, problem-solving, and decision-making skills

Excellent verbal, oral, written communication and presentation skills

Exceptional interpersonal skills with ability to gain the confidence and respect of senior executives as well as subordinates

Proven ability to work with all levels of management, and the most senior of Subject Matter Experts

Be a team player while being a team leader by sharing all available information with the entire team to strengthen the team integrity

Proficient in Agile (Scrum) and waterfall project methodologies

Ability to work independently and organize workload with minimal direct supervision

Strong management and leadership skills

Knack for finding ways to improve business processes and speed up time to market

TECHNICAL SKILLS

Primary Technology

Informatica PowerCenter 9x, Informatica Analyst, Datastage

Office Tools

Advanced MS Office Suite(Word, Excel, PowerPoint, Visio)

Databases

Oracle,Teradata, SQL Server, DB2

Modeling Tools

MS Project, MS Visio

Operating systems

UNIX, Windows

Supporting & Tracking

Merant Dimensions (Source Code Control), Mercury Quality Center, Control M scheduler, Autosys, MS SharePoint, Tortoise SVN( version control)

Development Methodologies

Agile(Scrum) and Waterfall

PROFESSIONAL EXPERIENCE

Saama Technologies Phoenix, AZ

Business Systems Analyst Dec 2013- Present

Current Project Synopsis:

CSAA (California State Automobile Association) Insurance Group provides Automobile, Home Owners and Umbrella insurance. My current project deals with analyzing the efficiency of the underwriting process by measuring varied metrics such as number of home inspections, number of rules overridden for a policy bind, number of policy renewals, turn-around time for a quote bind, etc. to determine the potential areas of improvement to bring down the expenses and increase the efficiency of the underwriters and related processes.

We as a team, gather and aggregate data and build reports on these metrics to determine the key areas of improvement.

Previously, I was involved in a very interesting engagement of Marketing (Customer 360) for this insurance provider where the goal was to identify the potential new customers (cross-sell) and service the existing customers to ensure customer retention and repeat business. The first release of this program was hugely successful in attracting new and existing customers to buy the insurance products from CSAA.

Engage with the client to gather business requirements and business rules and document the same in Business requirements document (BRD) and systems requirement document(SRD)

Apply different requirement gathering techniques like JAD sessions, prototyping, interviews and meetings to develop and agree upon a system that focuses on the business requirements

Create independent, small and testable user stories for each item in the product backlog and groom it periodically

Coordinate with the team to create the sprint backlog for each sprint

Channel and identify business users’ needs by asking relevant questions and replaying the requirement with a real world scenario

Prioritize requirements, changes and issues to handle multiple tasks in a seamless and cost effective manner

Perform periodic “As-is” and “To-be” state for gap analysis

Provide periodic scrum notes, sprint reviews reports and regular status of project velocity and budget consumption during continuous deployment phases

Liaise between the business and technical teams to translate the requirements(HLD), challenges and updates on the progress of the implementation

Interact with the data modelers and provide inputs to design the target data storage

Data profiling to find anomalies and data patterns (such as valid data availability, NULL percentage, etc.) using medium to complex SQL queries

Work closely with the testing team to define scope and lock test plans

Validate the target data and its integrity post the development deliverables using SQL Queries and advanced MS Excel functionalities(pivot tables)

Conduct UAT with the cross-functional business teams to ensure the solution is in alignment with the requirement from the business teams.

Providing post-implementation, enhancement and maintenance support to client for application

Clients worked for: AAA Insurance

Environment: Informatica PowerCenter 9.1, TOAD, UNIX, Oracle, DB2, Informatica Analyst

Wipro Technologies Los Angeles, CA

Data Analyst/Team Lead Mar 2011- Nov 2013

Lead a team of 15 comprising of senior and junior developers, quality analysts and sustenance members

Facilitate and coordinate extensive user interviews and conference calls to gather and analyze requirements from a globally distributed team.

Conduct agile retrospectives, upcoming iteration planning and daily standups.

Present the target state architecture and translate the user requirements into a high level technical document for the development team consumption.

Enable the development teams to simplify large and complex user stories for better execution and tracking

Implement change control process to manage the changes in project scope, identify potential crises, and devise contingency plans.

Profile and analyze the source data using complex SQL queries and document the findings to record the data quality and integrity

Create data mappings to map the identified sources to the final target data requirements

Interact periodically with the users to ensure that the solution being implemented is in line with the requirements by providing sample data for verification

Gather and analyze metrics to determine areas of potential improvement and implement changes as necessary

Facilitate UAT for accuracy and compliance to user stories to ensure acceptance and validation of the designed solution

Provide support to ensure data accuracy in the user reports

Clients worked for: Farmers Insurance, State Street Corporation, Fifth Third Bank

Environment: Informatica PowerCenter 8.5, Informatica Analyst, Datastage, TOAD, UNIX, Oracle, DB2

Infosys Technologies San Francisco, CA

Programmer Analyst/Technical Lead Dec 2007 - Feb 2011

Hold meetings with the enterprise architects and SMEs to understand the significance of the modules and the bigger picture to self-educate and educate the team on the ground

Discuss the technical requirements by having meetings and calls with the business analyst and the project manager

Create the technical design document and provide a walkthrough to the development team

Perform code review and data review and provide feedback for any corrections

Document testing checklists and best design standards and help team implement them

Hold discussions with the data modelers to fine tune the data and the solution to be able to adhere to the agreed SLAs

Provide pointers and feedback on performance tuning and ensure the best standard compliance

Provide support for the deliverables under shadow and primary support

Provide the delivery status and discuss the roadblocks with the program managers and other stake holders via conference calls and meetings

Clients worked for: GAP Inc, AT&T, Limited Brands

Environment: Informatica PowerCenter 7, Datastage, TOAD, UNIX, Oracle, Teradata

Infosys Technologies Pune/Bangalore, India

Software Engineer Aug 2005 – Nov 2007

Develop the ETL(Extract Transform Load) code in Informatica PowerCenter as per the technical and functional designs

Create the unit test case documents and record the results

Discuss and implement standard design procedures

Fix bugs at System testing, Integration testing and Performance testing levels

Tune the code components to adhere to challenging SLAs

Maintain a questionnaire with a list of queries and track them to closure

Prepare release notes for the sustenance team to take over post deployment

Provide daily status to leads and managers and raise flags when necessary

Help other team members with their deliverables to ensure that the delivery dates are met

Learn new technologies and platforms along with gaining domain knowledge

Clients worked for: GAP Inc, Bank of America

Environment: Informatica PowerCenter 7, Datastage, TOAD, UNIX, Oracle, Teradata

EDUCATION & PROFESSIONAL AFFILIATION:

Bachelor of Engineering: Major: Electronics and Communication

Bapuji Institute of Engineering and Technology, Visveswaraiah University, India.

CERTIFICATIONS AND AWARDS:

Exam N: Power Center 7 Mapping Design

Saama Pat on the Back award for a seamless project execution in the first project

Contact this candidate