Profile

6+ years of experience as Systems Engineer & Agile IT Business Analyst with in-depth knowledge of business operations in the Insurance industry, particularly in Claims Management across multiple lines of businesses (Property and Casualty, Worker’s Comp). Extensively experienced in Data Warehousing and ETL; possess a thorough understanding of Agile Software Development with solid background in the Scrum framework. Highly recognized for consistent delivery, excellent team coordination & outstanding customer satisfaction record.

I rely on my strong technical and analytical abilities during requirements engineering to produce powerful solutions that assist in enabling Business. Possess excellent communication and interpersonal skills and adept at building strong rapport with the clientele. Currently seeking IT Business Analyst roles where I can capitalize on my strong business acumen, agile development experience and technical expertise to accelerate efficient execution of the company’s strategic objectives.

Experience

IT Business Analyst, Tata Consultancy Services- The Hartford | (May 2014 to Present)

1.       Functioned as the lead Claims Data Warehouse BA for ‘The Hartford’ client. Worked with 40+ claim management applications during this period. Currently working on building an integrated analytical data mart for the Hartford's Claims Data Warehouse, using Agile software development methodology.

2.       Subject matter expert in IT systems/ applications and data pertaining to Insurance Claim management.

3.       Expert in facilitating requirements and solutioning for actor/ location based Business Intelligence and complex analytics of Claims data using master data management, thereby providing different lenses to the conventional event-centric model of the client’s existing Claims Data Warehouse.

4.       Experienced at interviewing various business stakeholders, recording use cases and framing/ documenting user stories in Rally. Assist the Product Owner in stocking, maintaining and prioritizing the product backlog as part of backlog refinement and in setting the roadmap for the Claims Data Mart project.

5.       Act as business coach for the agile development team during each iteration by facilitating collaboration and sharing knowledge.

6.       Responsible for building and executing test cases as part of internal User Acceptance Testing to evaluate the product increment.

7.       Responsible for presenting each product increment to the user community as part of Sprint Review. Skillful at facilitating end-user adoption of the developed asset by demonstrating its functional capabilities.

8.       Proactively organized/ conducted daily scrum calls and agile ceremonies including sprint planning, review and retrospective in the absence of project scrum master.

9.       Skilled at writing SQL queries using the developed product to solve complex business cases. Example of one such success story- combined technical skills and business domain knowledge to automate Large loss recognition reports in July 2017 for consumption by Senior Executives, including the CEO.

10.    Experienced in communicating client’s business requirements by constructing clear, concise and easy-to-understand artifacts. Experienced in using Analytix Mapping Manager (AMM) tool to create, track and maintain process mappings.

11.    Acted as Data Steward for the Claims Data Mart project at The Hartford. Added value by building elaborate business metadata (data dictionaries, quality rules, data mappings) for Enterprise level certification. Certified Business terms and definitions enabled the Business community in achieving better understanding of data.

Senior Developer, Tata Consultancy Services- The Hartford | (Oct 2013 to Apr 2014)

1.       Developed sophisticated Data-Warehousing ETL application that significantly improved reporting capabilities on medical bill data for the Hartford's first party auto medical claims, using complex PL/ SQL programming and Informatica mappings.

2.       Managed assignments for team of developers to achieve project goals; trained them extensively in PL/SQL, Informatica and Claims business functionalities.

3.       Slashed cost of rework by proactively identifying and correcting data quality issues in converted legacy data during early phase of development.

4.       Built a high functioning ETL framework architecture to enable daily processing of large data sets consisting of auto medical data.

5.       Optimized ETL performance to implement efficient automated processes with quickest response time.

Developer, Tata Consultancy Services- The Hartford | (Feb 2012 to Sep 2013)

1.       Maintained and enhanced business delivery layers of a broad spectrum of Claims data from different front-end processing systems. Managed self-service query environment for production Data Warehouse.

2.       Proactively analyzed and solved several complex production issues and performance bottlenecks in short spans of time to meet customer SLA.

3.       Designed and implemented Data Warehouse and Data Mart: tables, indexes, procedures, PL/ SQL packages, Autosys jobs and UNIX configuration to enhance existing Claims applications.

4.       Developed reusable routines in Informatica to perform daily/ weekly/ monthly ETL processes.

Assistant Project Manager Intern- KRDS India | (May 2011 – June 2011)

1.       Participated in a Marketing Internship program at KRDS Software Development India Pvt. Ltd.

2.       Successfully managed a national level Hackathon campaign that aimed at promoting the company's brand name and at recruiting top web developers in India.

3.       Designed creative and attractive web mailers/ digital posters for marketing the campaign on social media.

Additional Projects/ Initiatives-

1.       Acted as consultant in various digital initiatives by TCS- 1) Contributed inputs as part of project proposal to build a mobile insurance app for the client’s business. 2) Contributed inputs as part of project proposal which aimed at building a chatbot for automation of insurance customer service.

2.       Designed infographic using Adobe Photoshop & Illustrator for depicting Big Data research and development programs in TCS.

3.       As part of Undergrad education program, designed and developed a mock JavaScript/HTML/CSS based web portal called ‘E-Cops’ portraying the possibilities of computerizing Police department services in India.

4.       As part of Undergrad education program, designed and developed a PHP based web application for managing and backing Windows contact cards.

Education

1.       Bachelor’s Degree in Information Technology, Anna University, India – 2007 to 2011.

2.       Higher Secondary Education from JGVV Matriculation, India – 2005 to 2007.

Skills/ Tools

1.       Requirements analysis and gathering

2.       Agile Software Development

3.       Customer Engagement

4.       Claims Processing

5.       Guidewire (Claims Center)

6.       Data Warehousing

7.       Oracle

8.       SQL and PL/ SQL

9.       Data Analysis

10.    Data Mapping

11.    Business Intelligence

12.    Informatica

13.    Unix

14.    Autosys

15.    Adobe Photoshop & Illustrator

16.    Microsoft Office

17.    Analytix Mapping Manager

18.    HP Quality Center

Certifications

Associate in General Insurance (AINS)- The Institutes, April 2015.

Organizations

Toastmasters International- Secretary of TCS Maitree Infinity Toastmasters Club, Jan 2014 to June 2014.

Awards and Achievements

1.       Awarded merit scholarship during first semester of Undergraduate education for outstanding academic performance.

2.       Star Performer of the learner’s group during training period with Tata Consultancy Services.

3.       Star of the Quarter awarded by Tata Consultancy Services in July 2014.

4.       Star Team awarded by Tata Consultancy Services in Sep 2013.

5.       Award from Director of Information Management, The Hartford in Apr 2013 for outstanding contribution.

6.       Several awards from Tata Consultancy Services for exceptional performance.

7.       Best speech, best evaluator, best table topics awards from Toastmasters International.

8.       ‘Customer Whisperer’ award received in July 2017 in recognition of excellent customer satisfaction record.