SUMMARY:

• 10+ 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 using SAS for purposes of 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 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.

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

Technologies/Concepts: Data Warehousing Concepts, Teradata, Datastage, Ab-Intio.

PROFESSIONAL EXPERIENCE:

Business Data Analyst

Confidential

• The work in the BI knowledge and Insight team involves currently working as Analyst / data scientist on various project to bring various health care systems data from such as Cerner, All Scripts, BMD, Centricity Business m Cactus,

• Siemens Invision etc. into Enterprise Data warehouse.
• Is responsible for gathering business and technical requirements, source system analysis, gap analysis, data profiling, requirements documentation for ETL development and report development.
• Work involves the use of various technologies Business objects, Tableau, Informatica, COGNOS, ORACLE, SQL Server, Mainframe etc. and tools such as TOAD, AGINITY and JIRA.
• Responsibilities involve performing UAT testing & report testing. Attending data model walkthroughs and providing feedback to assist modelling, architecture, ETL team on daily basis.
• Walkthrough of requirements mapping document and impact analysis with respect to any changes in the ETL process.
• Participation in Scrum meetings (agile methodology) and provide updates on stories.

Systems and Data Analyst

Confidential

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

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.
• 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.
• 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”