SUMMARY

• Over 7+ years of extensive experience as a Healthcare/Finance Business Analyst with diverse IT implementation experience in Health Insurance, Investments and Banking domains.
• Very strong knowledge of SDLC, RUP and Agile methodologies and project life cycle
• Experience working with business users to analyze and document business requirements and system functional specifications.
• Excellent analytical skills and understanding of business processes and functionality requirements and ability to translate them to System Requirement Specifications.
• Responsible for the design, development, and delivery of reporting and analytics solutions to all the areas of the business Evaluate requirements and advice on relevant, actionable reports related
• Experience in Data Warehousing projects in Collecting Client requirements, Data modeling, Workflow manager, Workflow monitor.
• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snowflake Schema & Dimension Tables), OLTP and OLAP.
• Experience in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Summary Reports, List Reports and distributed reports in multiple formats using Report Builder.
• Strong ability in defining query for generating drill down reports, handling parameterized reports, Cascaded Reports, Custom Reports and creating stylish report layouts in SSRS 2014/2012/2008.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Extensively used tools like SQL Profiler, Database Engine Tuning Advisor and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQL Server Management Studio, SQL Server Integration/Analysis/ Reporting Services etc.
• Strong analytical, and problem- solving skills with emphasis on clear, detailed Business Requirements and Functional Specifications, as well as reports for management.
• Direct responsibilities include experience with planning, organizing, and Change Management.
• Experience with User Acceptance Testing (UAT) and release skill sets.
• Well versed in SQL writing queries/scripts for data analysis and writing test strategies, test plans, test cases, Defect Reports and developing Test Scripts and Traceability Matrices
• Transformed the user experience for global channel partners by conducting thorough impact assessments and releasing online, customized, change management content
• Able to master new concepts and applications within a timeframe and capable of rising up to mounting challenges.
• As a key player in the team with strong interpersonal and communication skills, explored and contributed the technical expertise as and when needed by the team.

TECHNICAL SKILLS

Business Modeling Tools: Rational Rose, MS Visio, MS Office.

Methodologies: Agile, RUP, Waterfall, Kanban.

Requirement Management Tools: Rational Suite ( requisite Pro, Clear case, Clear Quest, Rose), NASCO, Informatica 9.0, QNXT 5.3, HSP 10.5.3( Health Solution Plus)

Applications: MS Office (Word, Excel, PowerPoint, InfoPath, OneNote, Publisher, Outlook) MS Project 2000, PowerBuilder, Intuit QuickBooks, Business objects, Crystal Reports, Tableau, Database, Clear Quest. SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Report Builder, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTSX, Business Intelligence Development Studio (BIDS), Tableau, MicroStrategy, Excel V.15.0/V.14.0/V.12.0 Crystal Reports, Web Services, SOAP, JIRA, CA Agile.

Languages: T-SQL, SQL, PL/SQL, Dynamic SQL, .NET Framework, C#, ASP.NET, VBScript, JAVA, XML, HTML5, CSS, DHTML, HTTP, Shell Scripting. MDX

Operating System: Unix, Windows NT/ 98/2000/2003 , Windows XP.

Databases: MS Sql Server 2014/2012/2008 R2, MySQL, Oracle 11g/10g/9i/8i.

PROFESSIONAL EXPERIENCE

Confidential, MD

Sr. Business System Analyst

Responsibilities:

• Conducts JAD sessions with extensive involvement from Business, Development, testing teams, Architects, SME’s (Subject Matter Experts) and Managers of various Business Units to gather the
• Utilize expertise in the analysis of existing business rules, processes and systems to recommend process and system enhancements to improve business performance and maximize the effectiveness of available technology.
• Design complex queries by accessing SQL databases to pull information for Billing & Payment data.
• Responsible for developing SQL reports and SQL queries to Insert/Update and Delete data in SQL databases on daily based of various requests and regulatory requirements.
• Design, Develop, Analyze and Maintain the Billing & Payment dashboards report scheduling using Visual Studios and Report Builder.
• Involved in creation of ER modeling for OLTP and dimension modeling for OLAP and using STAR and SNOWFLAKE Schema also developed business flow diagrams, activity diagrams, and interaction diagrams so that the development team and other stakeholders could understand the business process clearly.
• Utilize experience in providing technical systems guidance for modifications to current systems and/or recommends design solutions for new systems initiatives.
• Involved in all the phases of Data warehouse and Software development life cycles involving Requirement Analysis, Design, Coding, Testing, and Deployment with timely delivery against aggressive deadlines.
• Develop Business Intelligence Solutions using MS SQL Server 2014/2012 tools, including Reporting Services, Analysis Services and Integration Services.
• Utilize experience in configuration of FACETS Subscriber/Member application to perform Gap Analysis in the upgrade of the existing Claims. And analyze the mainframe reports for Member/Eligibility/Claims and mapped the field with FACETS batch jobs and reports.
• Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Utilize experience in the moderately complex Business/User/Functional requirements analysis, verifications and prioritization sessions.
• Co-ordination with multiple teams and integration architects to research and analyze basic complex issues surrounding the process of speed and stability.
• Involved in System Integration Testing (SIT) and User Acceptance Testing (UAT) efforts by defining, developing and implementing practices and procedures for complete end user test plans.

Environment: Facets, Toad for Oracle, MS-Excel, MS-Word, SharePoint, MS SQL Server 2012/2014, Visual Studio, Report Builder, HP ALM, MicroStrategy.

Confidential, NJ

Sr. Business/Reporting Analyst

Responsibilities:

• Identifies and defines business needs, identifies opportunities for improvement and develops the business plan.
• Determines requirements using interviews, document analysis, surveys, site visits, business process descriptions, user stories, scenarios, and task and workflow analysis.
• Determines requirements using interviews, document analysis, surveys, site visits, business process descriptions, user stories, scenarios, and task and workflow analysis
• Consults with subject matter experts, technical experts, end users and other stakeholders to gather information about functions, features, data requirements, input requirements, output requirements, interfaces with other systems etc.
• Evaluates information gathered from multiple sources, reconciles conflicts, segments high-level information into details, and abstracts up from low-level information to a general understanding.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables. Developed views using complex split week logics.
• Documents business, task, and workflow processes using industry standard methods including business process descriptions, use cases, scenarios, diagrams, flow charts, etc., ensuring that these deliverables can be used to design a solution to the stated business problem.
• Progressively elaborates the stated requirements to sufficient level of detail that accurately define the business need within the specified solution scope. Validates that requirements meet the business need.
• Assesses solutions to ensure that goals are met and requirements are satisfied, including assessment of request for proposal responses, internal designs, and manual procedures.
• Serves as liaison and resource to project managers, developers, and other project team members throughout each phase of the process to help clarify and/or resolve issues related to requirement, design, testing and acceptance specifications.
• Confirms that stakeholders have a shared understanding of requirements; manages conflicts and issues to resolution. Obtains needed approval of solution requirements. Ensures that stakeholders have access to business analysis work products. Uses communication methods appropriate to departmental stakeholders.

Environment: Diamond/CRM, HSP 10.5.3, M S Visio, Microsoft Office, SharePoint, MSP Project, SQl, JIRA, Work Front, Windows Performance Monitor.

Confidential, Oaks, PA

Sr. Business System Analyst

Responsibilities:

• Work with developer, BI team and business owners to evaluate requirements and advice on relevant, actionable reports related to claims and provider data etc.
• Developed Use Cases using MS Visio, and a detailed project plan with emphasis on deliverables.
• Responsible for standard daily, weekly and monthly reports that used and distributed internally.
• Assisted Developer with drafting the requirements, implementing design and development of various components of ETL for various applications
• Give technical support in the areas of policy, process and procedures as they relate to Change Management.
• Extensively used Transformation Language functions in the mappings to produce the desired results
• Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts
• Performed Data cleansing to detect and correct corrupt data. Responsible for creating and maintaining end-to-end Data Mapping and Data conversion spreadsheet
• Understood and articulated business requirements from user interviews and then converted requirements into technical specifications
• Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and Unconnected Lookups, Filters, Sequence, Router and Update Strategy
• Developed and Implemented Test Strategies using the Test Director.
• Assisted QA team in testing phase by creating Test Plans and Test Cases documents.
• Followed the RUP methodology for the entire Software Development Life Cycles.
• Assisted the development team during the second and third iteration using the RUP model.
• Checked the data flow through the front end to backend and used SQL queries to extract the data from the database.
• Involved in project planning, coordination and implemented QA methodology.
• Developed the Requirements Traceability Matrix, prioritized and determined Impact of all applications.
• Identified the all applications and interviewed the application owners to recommend the process improvements.
• Developed Use Cases using MS Visio, and a detailed project plan with emphasis on deliverables.
• Designing Logical and Physical Data Model with Erwin tools.
• Monitored Change Requests and documented requirements, integrating them with Use Cases.
• Developed and Implemented Test Strategies using the Test Director.
• Assisted QA team in testing phase by creating Test Plans and Test Cases documents.
• Followed the RUP methodology for the entire Software Development Life Cycles.
• Assisted the development team during the second and third iteration using the RUP model.
• Identified the all applications and interviewed the application owners to recommend the process improvements.
• Provided overall project management to multiple projects successfully completing them on-schedule and on-budget.

Environment: MS-Office, MS Visio, Mainframe DB2, UNIX & Windows XP, Informatica 8.5, SQL, RequisitePro, Rational ClearQuest, Cognos, Microsoft SharePoint

Confidential, PA

Business/System Analyst

Responsibilities:

• Conducted JAD sessions with extensive involvement from Business, Development, Testing teams, Architects, SME’s (Subject Matter Experts) and Managers of various Business Units to gather the requirement
• Instrumental in writing the Business and System Vision documents, Business and System Use Cases, Supplementary Specifications and extracting Stakeholder requirements.
• Supported full traceability among all artifacts throughout the software development life cycle.
• Realized Use Cases and their corresponding activity flows with complete entity relationship, recording all flows in Rational Rose and using Clear Case for Version Control
• Organized one to one interview sessions with Directors (sales & marketing, underwriters for large &small group renewal packages), create questionnaires, brainstorm sessions, research with the business, underwriters, marketing and sales to track, analyze, review and document clear, concise and feasible detailed business requirements in BRD document.
• Created parameterized, drill down, drill through and aggregation type of reports, charts and dashboards in SSRS.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Possess in-depth understanding and experience in using Visio to trace and update business requirements throughout the lifecycle of a project and keep stakeholders informed about the progress of the project utilizing Requirement Traceability Matrix (RTM)
• Created User stories by taking inputs from business users and mapped it to the requirements in High Level Requirement Document
• As a member of the Benefits File team, was responsible for Analysis, Research and benefits coding
• Extracted / Tested in Model Office with test data
• Analyzed the Benefit / Procedure file to determine the specific POS/TOS conditions for Column routing
• Analyzed and documented the Level / Set / Division / Column routing for Groups to particulars and sub-particulars
• Developed Use Cases, Activity Diagrams, and System Context Diagrams entailing grandfathering process, preexisting condition exclusions, dependent coverage age increase & other required provisions
• Developed business flow diagrams, activity diagrams, and interaction diagrams so that the development team and other stakeholders could understand the business process clearly.
• Extensively involved in performing Gap Analysis in the upgrade of the existing Claims
• Processing system and highlighting related issues.
• Co-ordination with multiple teams and integration architects, in performing analysis for issues regarding speed and stability.
• Extensively involved in performing the System Integration Testing (SIT) and User Acceptance Testing (UAT) of new system.

Environment: NASCO, HIQK, HEHK, HRBK, HRRK, HURK, MS-Excel, MS-Word, SharePoint, SQL, SSIS, SSRS and MicroStrategy.