SUMMARY:

• Over 7 years of experience as a Business Systems Analystin various domains of Insurance, Health Care, Banking and E-licensing State Government sectors.
• Extensive Experience in documenting Business Process Modeling, Business Requirements BRD , System Requirement Specifications SRS and Functional Requirement Specifications FRS
• Experienced working with complete Software Development Life Cycle such as Agile Scrum , Waterfall etc.
• Managing various project driving techniques such as JAD sessions and client walk-through
• Expertise at creating UML diagrams such as Activity diagram, Use Case diagram etc
• Identified and Created Business Process Flows using MS Visio.
• Well-versed with GAP analysis by analyzing AS-IS vs. TO-BE process
• Solid understanding of the ETL Extract, Transform and Load Process of data into a data ware house/data mart and Business Intelligence BI tools like Business Objects Modules Reporter, Supervisor, Designer and Web Intelligence .
• Knowledge in Data Migration, Data Conversion using SQL Loader, Accela Data Mapping and Data Conversion Tool.
• Worked with SQL queries using MS SQL Server Oracle
• Experience working with Data mapping documents
• Hands on experience in performing User Acceptance Testing UAT
• Expertise using Rational Unified Process RUP Business Processing Model,Rational Suite including Rational Rose, RequisitePro, Rational Clear Quest etc.

Work Experience:

Confidential

Role : Business Systems Analyst

Confidential is implementing an E-Licensing Project to provide flexibility and ease for applying and issuing a License to Business Holders. This project currently deals with 5 State Agencies namely State Liquor Authority SLA , Department of State DOS , Department of Agriculture and Markets AGM , State Education Department SED and Department of Environment Conservation DEC . Project is basically a Data Migration process from the various source State databases to Accela Application, a web based product, which is essentially designed to cater Government needs.

Responsibilities

• Gathered Business requirements, documented and translated them into system specifications and business process flow for internal use.
• Facilitated Joint Application Development JAD for communicating and managing expectations to discuss ways of integration of rational tools with current system.
• Prepared comprehensive Use Case Specifications document by identifying the use cases from the collected business gathering document.
• Coordinated with the Subject matter experts SMEs to obtain domain related information.
• Analyzed the data and understanding the flow of data through various systems.
• Extract data stored in flat files to load finally into a single data warehouse repository, which is a Government based Accela Automation System.
• Design and creation of Control Files and develop the ETL jobs using SQL Loader, which distributes the incoming data concurrently across all the processors, to achieve the best performance.
• Work with end users to understand their data and reporting requirements.
• Perform conversion and migration of client's data to match the configuration of Target Database.
• Analyzing data throughout the course of business processes to help identify where data is created, updated, read and deleted.
• Source to target data mapping with the help of Accela Data Mapping Tool.
• Writing low level design details based on architects conversion design.
• Communicate issues occurring in the project to the Data Architect Lead
• Identified gaps between the As-Is and To-Be process and generated Gap Analysis documents
• Documenting business and system needs via the creation of a variety of documents including Plan Documents, Design documents and Migration Documents.
• Document minutes of meeting with the Clients to ensure project requirements are properly tracked and mutually consented on.
• Managed the change request and analyzed the impact of the change request on the application in regards to Project Plan, Project Scope and Project Schedule.
• Performed Unit Testing for the converted data and reported and tracked the resolution of bugs/errors using Mantis and JIRA application.
• Ensure completed activities meet project specifications and requirements according to NY State standards.

Confidential

Role : Business Systems Analyst

Confidential is an independent licensee of Blue Cross Blue Shield association. Part of the Enterprise Portfolio Management Office was to develop the resourcing tools to further plan resources for upcoming projects. I was responsible for maintaining and troubleshooting enterprise resource management tools. Develop and test enhancements to enterprise resource management tools.

Responsibilities

• Worked with the business users to define business requirements and developed business requirements Documents
• Understand business processes, identify problems and opportunities in the context of reporting requirements
• Worked with the client and the database administration team to design database structure for different modules. Use pivot tables in Excel to replicate the reports that can be expected.
• Performed requirement analysis and created Requirement Traceability Matrix RTM
• Extensively used ETL tools to extract data stored in Access database and Business Objects Universe, flat files to load finally into a single data warehouse repository, which is in Access.
• Utilizing Business Objects to create implement data query templates to efficiently gather data.
• Using Ad-Hoc database in MS Access generated reports in Microsoft Excel, Report Builder and Crystal Reports.
• Assist in creating wireframes for web interface with the GUI design team.
• Perform conversion on Excel files created on different versions of Excel.
• Enhance the Resourcing Reports using power pivots, slicers and sparklines.
• Data mapping, logical data modeling, created class diagrams and ER diagrams.
• Developed reports using Crystal Reports and Business Objects.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Extensively used Excel and Access Macros and VBA with Excel Forms
• Gather user and business requirements through open-ended discussions, brainstorming sessions and role-playing
• Created Information Dashboards displaying resourcing information.
• Re-engineering the MS-Access reports and converting to Crystal Reports
• Responsible for designing and developing universes for development of reports using business object designer
• Documenting business and system needs via the creation of a variety of documents including Scope documents, GUI wireframes and Software Requirement Specifications.
• Document step by step procedure for the development of resourcing tools for training purposes.
• Ensured that project requirements are properly tracked and documented.
• Dedicated a good portion of time with the QA team in front-end, back-end and Regression testing.
• Ensured completed activities meet project specifications, requirements and Wellmark Standards.

Confidential

Role : Business Systems Analyst I

Confidential is a financial service company offering a variety of banking products and financial solutions like personal banking, small business, retail banking, home financing and equity loans, asset management, wealth management, corporate and investment banking and credit card services to its customers. Personal Banking involves opening and maintenance of checking, savings, recurring deposit accounts and personal loans. The web-banking project was developed in .NET environment. It is an online banking application that enables customers to access their checking and savings accounts, and credit card account using the Internet.

Responsibilities

• Liaised with Business and Functional owner during risk engineering and High-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Interfaced with business users to prepare and update Business Process Requirements BPR and Software System Requirements SSR .
• Ensured all artifacts complied with corporate SDLC Policies and Guidelines.
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.
• Performed GAP analysis of Business Rules, Business and System Process Flows, User Administration and Requirements.
• Developed Use Case with UML for new product functionality
• Involved in creating Business Processes and Modeling Diagrams using Rational Unified Process RUP .
• Actively participated in status reporting meetings and interacted with development team to discuss the technical issues.
• Using oracle Siebel CRM to see the status of a customer's file and all the activities under that customer's account.
• Performed GAP analysis of System Integration solution wise
• Created Sequence Diagrams and State Diagram
• Worked with System Owners for System Architect Diagram
• Worked on Retail Front End and Authentication level for internal and external users
• Worked on JIRA for Bug Reporting
• Performed UAT testing

Confidential

Role : Business Systems Analyst

Confidential with the Medicare Centers and Medicaid Services CMS to provide quick, easy, and affordable access to the health care service of their choice. Market Prominence is the only system that provides management with the ability to tailor each step of the regulatory process based on the health plan's interactions with each of its beneficiaries. Project involves integrating Market Prominence and the Claims processing System with the data warehouse to support the reporting requirements.

Responsibilities

• Involved in inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting a document that contains the essential business elements and detailed definitions.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Merged data from heterogeneous data sources into SQL Server to populate data warehouses using SSIS.
• Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Wrote PL/SQL statement and stored procedures in SSRS for extracting as well as writing data.
• Worked with Cognos and micro strategy reporting systems to extract the data for analysis using filters based on the analysis.
• Deliver platform related specifications such as security, performance, and capacity, Standard code sets such as ICD-9 preparing for ICD-10 , HIPAA EDI, CPT and DRG.
• Developed business process models in RUP to document existing and future business processes.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.

Confidential

Role : Business Systems Analyst

Confidential Communications is a telecommunications company owned by Confidential, data and IP. The scope of the project was to integrate the data from various systems and transform them such that they could be loaded into data marts from where the business carried on its analytical processes.

Responsibilities

• Participated in a numerous meetings with the business, DBA and business analysts to understand the scope and the requirements of the project.
• Participated in JAD sessions and other meetings to clarify the naming conventions followed with the Business Analysts.
• Reviewed the Business Requirement Documents BRDs and created a high level Bus Matrix.
• Performed Data Profiling to understand the operational data.
• Created a high level dimensional model and produced several attributes list based on the requirements.
• Participated in peer reviews and maintained an issue list.
• Used ER Studio to create the logical and physical models.
• Created and used Source-to-target document to record how the data is moved from source to target databases.
• Understood the need for the different fact tables and the dimension tables.
• Good experience with slowly changing dimensions and mini dimensions.
• Used several conformed dimensions across different star schemas or data marts.
• Accumulating snapshots
• Degenerate dimensions/Role-playing dimensions/junk dimensions
• Edited SSIS packages to define the workflow and also provide real-time monitoring.
• Building reports using SSRS