PROFESSIONAL SUMMARY:

• Strong knowledge of Insurance Industry including Claim systems and Business Insurance applications across multiple lines of business in P&C Domain with emphasis on creating User Requirements and Functional Requirements
• Strong knowledge in the areas of Management Information Reporting, Claim Data analytics, Predictive data modeling, Claim life cycle, Benchmark pricing tools
• Experience in data analysis of Claim System applications handling various phases of Claim from First Notice of loss to Claim settlement/Closure
• Business Analyst and Data analyst with 8.5 years of industry experience in software requirement analysis, process flow, business data modeling and data analysis skills
• Experience in development, maintenance of Data warehousing and Business Intelligence Applications with strong focus on ETL processes, reporting, data analytics
• Highly skilled in managing, coordinating and working in large enterprise wide initiatives involving team sizes of more than 20+ people and has a project life span of more than 2 years.
• Proficient in SQL query writing and data profiling involving multiple databases like Teradata, SQL Server, MS Access
• Experience in analyzing Business Requirement Documents (BRD) by gathering Business Requirements and Expectations from business partners, Subject Matter Experts (SME) and defining business processes, identifying risks, performing Gap Analysis, ROI analysis, SWOT analysis, Cost benefit analysis, Feasibility Analysis, Impact analysis
• Design and review of various documents including the Software Requirement specifications (SRS), Use Case Specifications, Functional Requirements (FRD), Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Worked on Data lineage analysis from reporting layer mapping back to source data and complete mapping of the front end Applications with the source database systems
• Worked in projects that involve reverse engineering to produce existing system documentation and further refinement of business rules to build the target system
• Experience in creation of automation tools to sunset manual Report generation processes resulting in huge savings of manual efforts and increased quality in report deliveries
• Worked closely with Business and IT peers throughout the requirements, design phases exhibiting strong analytical/problem solving capabilities
• Strong knowledge of all phases in Software development life cycle (SDLC)
• Proficient in preparing Business & System Use Cases and supporting all the documents with UML Diagrams such as Use Case Diagrams, Class Diagrams, Activity Diagrams, Data Flow Diagrams, Sequence Diagrams, Collaboration Diagram, Process Flows (Business and System) using UML modeling tools such as MS Visio
• Well versed in project management tool (MS Project) for status reporting, planning and resource allocation

TECHNICAL SKILLS:

Documents & Processes: BRD, WBS, FRS, FSD, SRS, RTM, CR, UAT Test plans, Test Cases, Project Planning & tracking, Use Cases, UML diagrams

Methodologies: SDLC, OOAD, UML, Business Data Modeling

Process Modeling: MS Visio

Operating Systems: Windows NT/98, 2000, XP, UNIX

Mainframe Technologies: JCL/COBOL/FOCUS, Scheduling Knowledge

Programming Languages: C#, VB.Net, ASP.Net, VB Script, JavaScript

Web Technologies: HTML, ASP.NET, ColdFusion

Databases: Teradata, SQL Server 2000, Oracle 8i/9i/10g, MS Access 2003, DB2

Query Tools: Teradata SQL Assistant, MS SQL, PL/SQL, TOAD

Reporting Tools: Ab Initio, Cognos

Version Control Tools: MS Visual Source Safe, SharePoint Portal

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

Sr. Business Analyst

Responsibilities:

• Understanding the goals and creating functional requirement documents for developing benchmark restatement reporting data warehouse from operational policy and Quoting database systems
• Reverse engineered SAS code (database queries) to document the exiting functionality and further refinement of business rules for target system
• Created data profile packages to help in data modeling and refine business rules
• Suggested iterative waterfall approach versus a traditional waterfall methodology to help phase wise implementation of Project
• Created calculation diagrams for complex data elements involving premium amounts and dividend ratios, showing the extraction and aggregation levels from source elements for ease of development along with detailed process diagrams depicting the interrelation among major components of the system
• Conducting frequent touch point meetings with development and QA teams for requirement clarification and ensure that requirements are clear
• Huge reduction in data compilation efforts for field office professionals, it was manual and used to take 400 hrs and after implementation of this project it is brought down to 4hrs

Environment: Teradata, SQL Server, Ab Initio, SAS, Visio, MS Access database

Confidential

Project Lead/Business Analyst

Responsibilities:

• Transformation of a production support project to a Legacy report strengthening initiative
• Understanding the existing set of reports and sources to create high level and detailed functional requirement specifications for Report redesign
• Lead the team in development of Reverse Engineering tool which captures the entire report inventory capturing mappings from reporting layer to source data
• Report consolidation by detecting common data elements across reports
• Validation of report outputs by comparing them with the manually generated reports
• Overall report execution times are reduced by 40%
• Worked on Data lineage analysis from reporting layer mapping back to data source systems
• Performed Gap analysis of business elements for several data marts built against legacy systems
• Automation of Report execution activities and reduce manual intervention

Environment: Ab Initio, Cognos, Oracle, Mainframe (JCL/FOCUS), Microsoft XL Pivots, ASP.NET

Confidential, Harleysville, PA

Systems Analyst

Responsibilities:

• Understanding the rate review Requirement specifications to create detailed functional requirement documents
• Designed MS Access macros to simulate the rate review updates in a MS Access database that helped in validate data quality and testing efforts
• Designed Error notification module to inform the Business persons to notify database update errors
• Help QAs with the rate reviews and transition into their roles, as they are moved into Business analysts’ role.
• Onsite Offshore coordination and Issue resolution support

Environment:, Mainframe (JCL/COBOL), MS Access

Confidential

Senior Developer /System Analyst

Responsibilities:

• Worked with SME’s to extract Business Requirement and create Functional Specification Document, Non - Functional Requirement Documents
• Prototyped implementation to let users provide feedback on the application
• Designed and implemented backend SQL queries and stored procedures
• Involved in the whole project life cycle from requirement analysis till the testing and deployment phase following the SDLC methodology.

Environment: ASP.Net, C#.Net, SQL Server 2000, Visual SourceSafe

Confidential

Senior Developer /System Analyst

Responsibilities:

• Worked with SME’s to extract Business Requirement and create Functional Specification Document, Non-Functional Requirement Documents
• Prototyped implementation to let users provide feedback on the application
• Designed and implemented backend SQL queries and stored procedures
• Involved in the whole project life cycle from requirement analysis till the testing and deployment phase following the SDLC methodology.

Environment: ASP.Net, C#.Net, SQL Server 2000, Visual SourceSafe

Confidential, Denver, CO

Developer

Responsibilities:

• Understanding the problem tickets raised, debugging, fixing them and deploying in production environment
• Enhancement and maintenance of the applications as per the business requirement
• Administration of Production servers, Continuous Monitoring and reporting of potential problems to onsite team
• Production support along with up gradation of existing system to .Net environment
• Providing solutions to change requests following SDLC and Knowledge transition and training to Onsite team

Environment: Web Methods, ASP, ASP.NET, VB, ColdFusion, SQL Server 2000, Visual SourceSafe