Microsoft Developer / Business Analyst Resume
NJ
SUMMARY
- 10+ years of Property & Casualty / Healthcare Insurance industry experience as Requirements Manager and Sr. Business System Analyst/Data Analyst
- In - depth knowledge of Insurance functional areas such as Risk Assessment, Claims Administration, Policy / Submission Administration, EHR (Electronic Health Record), PHR (Personal Health Record) and Wellness
- Key strengths with Functional requirements of Business Intelligence / Data warehousing technical solutions
- Hands on experience with Data Analysis with Teradata, Oracle 10/11g, SQL Server 2005/2008 databases
- Latest experience with BPM solution involving, mobile and offline system requirements analysis for Global users
TECHNICAL SKILLS
Business modeling: Microsoft Visio
Requirement Management: Microsoft Office (Word & Excel), BluePrint, Agile tool - Rally, JIRA, Confluence
Front end tools: Microsoft Front page, Microsoft Project, Microsoft Office, .Net
Defect Tracking: HP Quality Center
Query and Programming: VB Script, Java Script SQL, .Net 2.0, HTML
Databases: Teradata 13.0, DB2, MS Access, SQL Server 2008, Oracle 11g
Document Management: VSS, Sharepoint
Methodologies: Waterfall, Agile, Iterative
PROFESSIONAL EXPERIENCE
Microsoft Developer / Business Analyst
Confidential, NJ
Key Responsibilities:
- Drive interviews with business SME’s to collate functional requirements
- Work with CHUBB Business/IT SMEs and Solution Architects to draft the Program roadmap
- Perform data-profiling / data - analysis activities
- Develop Source to Target Mapping documents
- Develop requirements artifacts - functional architecture, high-level requirements (i.e. system features) and use case inventory
- Plan, document, conduct and conclude with test results the Testing activities - QA and UAT. This includes preparing the Test Strategy, Test cases and organizing the UAT sessions
Requirements Manager
Confidential, NJ
Responsibilities:
- Project Requirements Team Size: 14
- BPM Solution for Single System Solution Delivery - followed SDLC process
- Client Portal for Global Commercial clients - followed Agile methodology
- Offline and Mobile Solution - followed Agile methodology
- Accompany Field Engineer for an onsite survey for a real-time understanding of a standard risk-assessment survey of a commercial property
- Drive interviews session with business SME’s like Global field managers, account engineers, field engineers to collate functional requirements
- Worked with AIG Business /IT SMEs and Solution Architect to draft the offline program roadmap
- Responsible for requirements planning and tracking in ‘Rally’, conducting meetings with business SMEs and System leads
- Responsible for Weekly Status Reports for Program Manager
- Close coordination with project management & PMO for MVP definition & walkthrough of each sprint
- Responsible for reviewing the test results of the Testing activities - QA and UAT. Includes reviewing the Test Strategy, Test results and organizing the UAT sessions.
Lead Business System Analyst
Confidential, CT
Responsibilities:
- Worked as a Lead Business System Analyst for team(size of 13) and project team size of 40
- Awareness of various systems includes Rate Quote Issuance(RQI), Underwriting Documents, Dashboards
- Served as a liaison between the business specialists and the technical team
- Contributed to the definition of scope, preparation of work plans and definition of business requirements.
- Provided gap analysis after detailed study for the replacement of Field Management Dashboard within Workstation
- Created Detailed Functional Requirement Document, Source to Target mapping document and Traceability matrix
- Participated in Joint application requirement sessions to gather requirements and documentation
- Actively participated in project planning for the year /2013
- Involved in POC phase of the project, worked closely with business leadership/ partners on deriving business and IT benefits and defining the reusable components
- Performed Data Analysis in Oracle 10g / Teradata 13.1 and also involved in creating the inventory list of impacted data elements
- Created the Report specification document and Data Profiling document
- Solely responsible for identifying reporting needs, creating specification, and work closely with report development team to achieve the reporting goal
- Assisted ETL development done using abintio components / graphs. Participated in Technical design discussions
- Participated in the review of Test Strategy and Test plan documents
- Assisted the function lead in creating estimate and defining the roles/responsibilities in the project
- Have conducted several mentorship program to educate newly joined team members
- Have extensively contributed to defining the Business Systems / Data Analyst process and constantly refining the artifacts, templates, process flows etc.
- Involved in creating screen mockups for User Interface screens
- Assisted the Business Intelligence Architect / Data Architects on creating architecture for new projects
- Supported Project Manager as back up, running meetings, filling project plan and monitoring budget
- Designed queries for the System’s developers to facilitate rapid development/understanding of the UI-functionalities/reports
Technology/Tools Involved: Teradata, AbInitio, Oracle, SQL, BluePrint (Req tool)
System Analyst
Bellingham, WA
Responsibilities:
- Worked as an Data Analyst/Tech Lead with a team of 5 onshore and 3 offshore employees
- Understanding existing business model and customer requirements
- Have been involved in all phases of project development life cycle (PDLC) model.
- Created technical documentation for the programming changes
- Assisted the development team and QA in clarification of the requirements
- Analyzed program / code, business logic, store procedure calls and transaction calls for gathering requirement
- Prepared Understanding Document, Analysis Spread sheet, discrepancy documents
- Created Business process flow chart using MS Visio
- Code debugging and gap analysis
- Reverse Engineering
- Unit and Integration testing
- Effective and timely communication to Client Business Team
- Participating in review meetings and conducting detailed walkthrough
Technology/Tools Involved: Oracle, SQL, MSAccess
Business Analyst
Confidential, IL
Responsibilities
- Requirements gathering & analysis in the form of scope, supplemental specifications and use case documents
- Create workflow diagrams and UI mock-ups
- Requirements walkthrough to the development team
- Managing the Software Development Lifecycle for CSG; Analysis, Development, QA, UAT and Production
Technology/Tools Involved: Oracle, SQL, JIRA and Confluence (Req tools)