Professional Summary

• 9 years of experience in IT ranging from Business, Systems and Data Analysis, Application Enhancement Production Support of complex data warehousing applications in the P C Insurance industry.
• Highly skilled in working with stakeholders to elicit, analyze, specify and validate business and solution requirements to meet business needs.
• Able to bring together a diverse stakeholder group, drive consensus and create a shared understanding between the customer community and the solution delivery team while maintaining alignment with Business and IT Strategies.
• Experienced working face to face with business stakeholders at onshore client location to clearly understand business requirements for past 4 years.
• Experienced in working with large Data warehouse databases and data marts.
• Worked closely with COGNOS developers to better understand how efficiently data can be provided to them at the semantic layer for their reporting needs.
• Experienced in using SQL for Data Profiling Analysis.
• Experienced in the use of SAS Enterprise Guide 5.1 for data profiling and analysis
• Experienced in working with multiple data warehouse projects utilizing Star and Snowflake schemas.
• Experienced in analyzing source data structures to validate business rules to ensure efficient and error free data transformation in the ETL code.
• Experienced in presentation of Data Analysis findings for Functional Requirements clarification to the business team and other Subject Matter experts.
• Experienced in creating Requirement Artifacts such as Functional Requirements Document, Attribute Mapping document, Requirement Traceability Matrix, Data profiling package.
• Experienced in working with data models around data warehouses and data marts to understand source data and how data needs to be landed in the target database.
• Experienced in Business Requirements clarification with Subject matter experts along with maintaining multiple interaction points with functional areas such as QA, DBA, ARCH and Project Tech leads.
• Worked closely to assist Project Manager to estimate Project Scope after understanding Business Requirements and extent of work.
• Experienced in working on Ad-Hoc data analysis queries from business users regarding anomalies in production data.
• Has worked as a part of a data warehouse production support team to provide Ad-hoc data extracts from data marts.
• Strong analytical skills and the ability to handle multiple tasks as well as projects independently or in a team.
• Strong written verbal communication and collaboration skills.

Core Strengths

• Core understanding of the software development process and methodologies.
• Excellent communication skills
• Insurance domain knowledge
• High level analytical skills
• Ability to learn and migrate to different platforms, applications and programming languages in a short period of time.

Technical Skills

• Operating Systems - MS-Windows98/2000/XP, UNIX.
• Languages - Cobol, JCL, CAFM,XML, Web Services
• Database - DB2,Teradata,SQL Server
• Tools -Teradata SQL Assistant, Ab-Initio BRE, Data profiler, SAS EG, QlikView
• Technologies/Concepts - Data Warehousing Concepts, Teradata, Datastage, Ab-Intio.

Accomplishments

B2T-Business Analyst

• Domain Certification INS-21Certified US Insurance Certification
• Teradata V2R5 Certified Professional
• SCJP Sun Certified Programmer for Java 2 Platform 1.4 310-035
• Awarded the Spot Excellence Award for the 4QTR of 2006 by L T Infotech.
• Awarded the Team Excellence Award for the year 2006 by L T Infotech.

Experience

Systems and Data Analyst

Confidential

• FlowMart is a Business Insurance Data warehousing datamart project that deals with capturing the most recent look of a policy from the front-end RQI issuance system. This information from the RQI system flows into the underlying transactional database and finally into the source data warehouse below it from which it is extracted into FlowMart.
• FlowMart is the premier source of analytical information across the lifecycle of a policy from submission to renewal for Product development and Underwriting Dashboards whose focus will be KPI's related to production coverage and flow metrics.
• The opportunity to perform advanced analytics also includes the added functionality to perform and derive rule analytics and additional metrics.

Systems and Data Analyst

Confidential

• The underwriting process starts with the gathering of information necessary to evaluate the profit and loss potential risk vs. reward of an account submitted for coverage. Account conditions and situations are evaluated against company underwriting standards and expectations and a decision is made to either accept or reject an account or requested coverage's. While it is desirable that all accepted accounts meet or exceed all of our company underwriting standards and requirements, the degree of compliance with those standards and requirements becomes more important as the size and complexity or the account increases. Documentation provides the opportunity to consolidate our analysis and record the reasons for the handling of an account showing considerations, rationale, decisions and the actions taken during the underwriting process including any collaborative discussions or conversations with others. Underwriting documentation also provides an opportunity to facilitate and expedite the handling of subsequent account transactions by the same or different underwriter, assure others both internally and externally that proper underwriting was completed and assure compliance with governmental insurance regulations where applicable.
• All underwriting documentation and triggers are handled within the UDoc application, which is a new application that went live in April 2012. Today, there is no structured MI that utilizes the vast amount of information found within the Underwriting Documentation SQL database. The business has requested that reports be created off of the information available within the UDoc application that can be leveraged by individuals across the underwriting organization.

Responsibilities:

• Involved in business requirement elicitation meetings with the users of the intended application to understand the required functionalities that the application would need to fulfill, to satisfy the client needs.
• Involved in data element identification from source systems to ensure that the designated warehouse data points would satisfy the ultimate functionalities of the application.
• Performed data profiling on identified data elements and presented the findings of data analysis to business for further requirements refinement.
• Ad-Hoc requests for time slices of production data and scenario based data-samples which helped business requirements fine-tuning.
• Working with upstream application teams to understand source data to effectively arrive at required data transformation rules.
• Conducted Requirement analysis and data profiling to ensure that the designated warehouse data points would satisfy the ultimate functionalities of the application.
• Conducted walkthroughs of the documented requirements for business sign-off.
• Responsible for communicating the signed off requirements to development and quality assurance teams for code design and functional test phases.
• Responsible for driving discussions during times of ambiguity around system design from a requirements perspective.
• Assisted to ensure all test scenarios that should be validated where made available to the project quality assurance committee.
• Was on point for the clarification of requirements during functional and user acceptance testing.

Senior Software Engineer

Confidential

This project was centered around Data warehousing in which our team were complete owners and were vested with the responsibility of maintenance of systems which brought in Auto insurance policy related data from the customer front-end, were formatted and finally updated into the client database which was on DB2 platform. Code enhancement, Production support real-time discrepancy-fixes formed the core of this project.

Responsibilities

• Was a strategic partner between the business community and IT development teams to resolve functional and technical issues related to business applications, to troubleshoot data or transaction issues, and to review opportunities to leverage new functionality
• Identified gaps between the current deployment of applications and future requirements that had evolved due to organizational growth, changes, or strategy. Translate business requirements into system definitions and solutions.
• Analyzed requests or requirements for application patches or upgrades to determine impact to business and integrated systems
• Comprehensive project management of new business application initiatives, performing requirements gathering, development effort estimates, resource management, gap analysis, implementation configuration, scope control, testing, training and end-user support, according to project methodology.

Trainings Attended:

• Underwent professional training at L T Infotech, Powai , Mumbai in technologies such as UNIX, JAVA,ASP.NET, C,MS SQL, and concepts related to SDLC.
• Was 1st in the English language proficiency exam held during L T Infotech training period.
• Trained in Data stage ETL technology, Data warehouse and Insurance Domain concepts
• Underwent training in Conflict resolution.

Extra-curricular Activities:

• Was a member of The Boy Scouts of America BSA Troop 463, stationed at Yanbu, Saudi Arabia and has earned various Merit Badges
• Member of Cochin University Football Team -represented the college at University levels.
• Was the Sr. Vice-Captain of the Don Boscos Boarders Association in the year 1997.
• Treasurer of the college charitable organization Wings Of Hope