We provide IT Staff Augmentation Services!

Business Analyst Resume

Charlotte, NC

PROFESSIONAL SUMMARY:

  • Over 8+ years of experience as a Business Analyst with a solid understanding of Business Requirement gathering, Business Process Flow, Business Process Modeling and Business Analysis.
  • Excellent experience in the business analysis and application development field with a commitment towards perfection in work entrusted upon and seeking professional excellence in all endeavor assisted by the right opportunity.
  • Strong analytical and logical skills combined with experience in various cycles of software development including development, testing, implementation and maintenance of applications.
  • Proficient in facilitating large meetings to help define vision, scope, requirements, design, and risk mitigation plans.
  • Full understanding of the SDLC: requirement analysis and business specification, development, enhancement, quality assurance, testing including developing Test Cases and Test Scripts. Experienced in conducting User Acceptance Testing (UAT).
  • Excellent skills in Business Analysis, Data Analysis, Gap Analysis, Requirement Analysis, Business Modeling and Use Case Development using UML methodology.
  • Well - versed in the documentation of, Business Requirements Documentation (BRD), Functional Specification Documentation (FSD), Current-State and Future-State Process Models, Performance Indicators.
  • Exposure to Client/Server, Web Application developmental tools and Software development and design. Process/tools including Java, Oracle, SQL Server, MS Visual Basic, JavaScript, HTML, Microsoft Project tools, Reporting tools, XML, Agile and Rational Unified Process (RUP).
  • Experience in solving complex problems, team coordination and motivation skills as well as the ability to communicate successfully across cultural barriers.
  • Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming, and Joint Application Development (JAD) sessions.
  • Expert knowledge in with various capital market instruments and securities including Equities, Fixed Income Instruments, Risk Management (Credit and Market Risk).
  • Expert at Risk Management by Risk Identification, Impact Assessment, Prioritization Analysis, Risk Tracking and Mitigation with monitoring of whole.
  • Experience in various modules of AML such as KYC, Entity Resolution, Compliance Reporting, and Transaction Monitoring.
  • Vast experience in performing SDLC tasks - Requirement gathering, Analysis, and Feasibility, Creating Business Requirement Document (BRD), Transforming BRD to Functional Specification Documents (FSD), High Level and Low-Level Design documents etc.
  • Conducted GAP analysis to capture functionalities of existing systems and analysis requirements of the proposed system followed various SDLC methodologies which include AGILE Scrum, AGILE Extreme Programming, Rational Unified Process (RUP), Iterative, and Incremental and Waterfall models to execute the proposed requirements.
  • Experienced in working with a Testing team, participated in writing Test Plan, Test Cases, Test Scenarios, RTM, Test Reports, and conducting various forms of testing, which include Integration Testing, Smoke Testing, Regression Testing.
  • Lead JAD sessions with corporate tax department and all source system SME's and prepared FRS for FATCA Reporting project.
  • Experience in Automation tools like Rational RequisitePro and Quick TestPro.
  • Expertise in Database Administration of Test Environment Databases, Data Pools and identifying performance issues due to inefficient Database Administration.
  • Strong knowledge of HL7, HIX (Health Insurance Exchange), EMR/EHR, Health Care Reform, and Patient Protection and Affordable Care Act (PPACA) and Facets.
  • Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
  • Solid Experience in developing Scope/Vision Documentation and Project Plan.
  • Excellent writing skills in generating, Project Charter, Project Plan, Business Requirements documents, Use Case Specifications Test Plan, Credit Risk Management Plan Liquidity risk assessment, and Publishing Regular Reports with status and metrics.

TECHNICAL SKILLS:

Project Methodologies: RUP, Waterfall, Agile (SCRUM)

Business Modeling Tools: MS Visio, Rational Rose

Requirement Management Tools: Rational Requisite Pro, Enterprise Architect.

Business Applications: Microsoft Office Suite- MS Word, Excel, Outlook, PowerPoint, Quality Assurance Software Application Testing Life Cycle.

Defect Tracking Tools: Rational Clear Quest, Quality Center

Databases: Oracle (11g/12C,10g), SQL Server, MS Access, SQL, PL/SQL

Data Warehousing: Data Marts, OLTP, OLAP, ROLAP, MOLAP, Oracle, Query/Reporting, Multidimensional Analysis

BI/ETL Tools: Informatica, SSIS, OBIEE 11g, Informatica Power Center, SQL * Loader

Operating System: Windows, Linux, Unix, Mac, Solaris.

Documents & Processes: SRS, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process Modelling, Project Planning & tracking

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential, Charlotte, NC

Responsibilities:

  • Reviewed, implemented, and maintained policies and procedures to ensure compliance with all federal (including FCRA, Fair Lending, OCC, and CFPB) and agency requirements.
  • Extensively involved in migrating the fields of financial instruments such as Fixed Income, Derivatives Securitized Products such as MBS on Trading Platform.
  • The assisted development team in understanding various financial products and help them grasp the technicalities of Derivatives Analysis, Credit Derivatives and Fixed Income Securities, CVA/DVA.
  • Performed SQL queries using TOAD software. Wrote SQL statements to extract data from the Tables
  • Prepared for GAP Analysis; identified and documented improving areas to meet capital markets requirement regulations.
  • Created test cases and provide testing along with coordinating UAT.
  • Constant interaction with Capital Market business users for job shadowing, understanding certain issues which I need to deal with for completing Proof of Concept and BRD.
  • Helped with Data Mapping between the data mart and the Source Systems.
  • Responsible for taking requirements from business users, understanding Business Needs by scheduling a meeting on a regular basis.
  • Involved in creating the Project templates, use case specifications, Change request form, functional specification documents, and Business Requirement documents.
  • Mentor teams to effectively use agile ceremonies like sprint planning, daily stand-ups, and retrospectives and sprint reviews to provide working outcomes in every sprint.
  • Designed and analyzed Business Process Model, Use Case model and test procedures based on agile methodology.
  • Worked with cross-functional teams for building use cases, demonstrating the business requirements, developing business models; Designed and developed business flow diagrams, activity diagrams, sequence diagrams, object-oriented models using MS Visio.
  • Conducted Model reviews with project team members; Publish and communicate models to various IT and business-based teams.
  • Conducted data mapping to collect and show relations between data from dashboard function to the ODS table on the PeopleSoft database, represented this mapping using ERDs, and Process Modeling DFD's on MS Visio.
  • Proactively prepared scenario analysis of different product mix and identified the areas of improvement and solutions to meet the customer needs.
  • Organized JAD sessions to flush out requirements, performed Use Case and workflow analysis, outlined business rules, and developed domain object models.
  • Utilized Management Information Software (MIS) and Financial Accounting Software (FAS) that ensured daily balancing of accounts and vendor reconciliation.
  • Designed, Developed and Supported Extraction Transformation and Load (ETL) Processes using Informatica Power Center 9.5 for data migration from source systems into the ICD-10 Data warehouse.
  • Data mapping the data in the new system to match the table columns of the old system/ data warehouse.
  • Develop SQL and SSIS ETL business intelligence solutions, data wrangling, migrate disparate source data into a centralized data mart structure for HEDIS and SSRS reporting, SSIS flat file processing, advanced SSIS features for data mapping, data conversion.
  • Designed stored procedures, triggers, and other SQL scripts to automate complex business rules and processes.
  • Studied existing KYC/CIP system and prepared test data for CDD and EDD based on inputs.
  • Conducted multiple gap analysis against Basel II, II.5 and III rules. Validated the Basel II framework, including internal rating systems (PD, LGD, EAD models) and RWA calculation.
  • Determination of customer's risk in terms of propensity to commit money laundering, terrorist finance, or identity theft.
  • Managed the project schedule and scope to ensure the project is delivered on time with high quality.
  • Involved in Defect Reporting, Defect Tracking and in Preparation of Defect Report using HPQC.
  • Wrote SQL queries to understand data relations and variances from other source systems.

Environment: SQL, TOAD, GAP, BRD, FATCA, Adobe Dreamweaver, HPQC, CIP, RWA, HP ALM Quality Center, MS Visio, BRD.

Business Analyst

Confidential, Bloomington

Responsibilities:

  • Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
  • Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
  • Involved in business process re-engineering, including gathering and documenting requirements, documenting workflows and developing specifications for the programmers
  • Implemented and maintaining a successful billing process to ensure timely and accurate billing monthly.
  • Meet with technical and business staff to document requirements and current processes for the data warehouse solution
  • Managed all capital expense appropriations and budgets associated with data warehouse and Business Intelligence projects.
  • Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
  • Review clinical data in the Cerner System to promote timely, relevant, accurate and consistent information use
  • Performed testing for Medicare, Medicaid, and X-Over claims for the Medicaid Management Information System (MMIS)
  • Developed Test scripts for testing EDI transactions to run in different environments.
  • Managed Electronic Document Management System (EDMS) for automating R&D and Regulatory document repositories for submissions to the FDA.
  • Interacted with the Development team to help write technical specifications to describe Functional Requirement Documents(FRD), Business Requirement Documents(BRD), design specifications and module specifications.
  • Implemented recommendations from the Basel Committee on Banking Supervision on IT projects for Credit Risk, Operational Risk and Market Risk in line with Basel II
  • Carried adjustment in operations of values of Credits, Debits, i.e. CVA/DVA, Fixed income security, and credit derivatives.
  • Completed Project Status Reports & led PMO meetings to update senior management and other stakeholders on progress, issues, and deliverables of the project.
  • Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel, and Flat Files.
  • Data mapping the data in the new system to match the table columns of the old system/ data warehouse.
  • Develop SQL and SSIS ETL business intelligence solutions, data wrangling, migrate disparate source data into a centralized data mart structure for HEDIS and SSRS reporting, SSIS flat file processing, advanced SSIS features for data mapping, data conversion.
  • Designed stored procedures, triggers, and other SQL scripts to automate complex business rules and processes.
  • Wrote, Reviewed and approved test plans, scenarios, scripts, and procedures.
  • Performed Data mapping, logical data Modeling, created class diagrams and ER diagrams and used SQL queries to filter data
  • Involved in Designing data models for Data warehouse supporting data from multiple sources in real time.
  • Designed the ETL processes using Informatica to load data from Oracle, Flat Files, XML Files to target Oracle Data Warehouse database.
  • Apply medical necessity guidelines, determine coverage, complete eligibility coverage, and apply all cost containment measures to assist in the claim adjudication process
  • Working in the Enterprise Business Intelligence Services group, analyzing issues and new requests for the Enterprise Data Warehouse.
  • Defined the duplication of data and columns between tables using TOAD and SQL.

Environment: ETL, MS SQL, HEDIS, Oracle, Flat Files, XML Files, FRD, SSRS, SSIS, TOAD, SQL, CVA/DVA.

Busines Analyst

Confidential, Tampa, FL

Responsibilities:

  • Conducted one to one interviews with the Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
  • Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
  • Used MS SharePoint for the purpose of managing documents and for hosting websites which were used to access shared workspaces and documents.
  • Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS Power Point MS Project for data migration into the CI System Knowledge Data Base in Microsoft SharePoint. Used the ODBC/SQL to migrate all data to one database before uploading it into the Knowledge Base.
  • Developed and maintained custom Access databases and.Net Applications to interface with LIMS system and provide sample tracking.
  • Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
  • Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
  • Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
  • Identified internal and external system Requirements, design and configuration set-up.
  • Developed Business Requirement Document as well as High-Level Project Plan.
  • Developed Functional Specification Document and Supplementary Specification (non-functional) Document.
  • Participated in the Logical and Physical Design sessions and developed Design Documents.
  • Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
  • Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
  • Develop User Manuals and Training Manuals as per Project Specifications and timelines.

Environment: Microsoft Office Suite, MS Visio, Windows XP, Dreamweaver, SQL, PL/SQL, XML, VB, ASP, Crystal Reports, Adobe Photoshop, Mercury Test Director, UAT, Win Runner, Load Runner.

Business Analyst

Confidential, Waltham, MA

Responsibilities:

  • Worked according to the activities/roles laid down in each phase of the software development life cycle created using the Rational Unified Process.
  • Analyzed and documented the system specifications, Business requirements and detail design of the software for a full understanding of the business and used Requisite Pro for the requirement tracking and analyzing.
  • Performed requirements analysis and design using Rational Rose and Requisite Pro.
  • Analyzed, documented, and managed all project requirements and change to requirements throughout the software development lifecycle using Requisite Pro.
  • Created full life cycle documentation from product requirements in the developmental stage to functional specifications for the completed modules of application components.
  • Created Use-Cases, Sequence, and Collaboration Diagrams to demonstrate software architecture and interaction of system components before prototyping. Used Rational Rose, Requisite-Pro for requirement traceability.
  • Worked with the Project management team, SharePoint, Microsoft Project, and JIRA
  • Involved in GAP analysis around the identification of business rules, business and system process flows, user administration, requirements, and assumptions.
  • Developed test cases and scripts based on business requirements for the GUI, functional, User Acceptance & System Back-end testing.
  • Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
  • Maintained a close and strong working relationship with teammates and management staff to achieve an expected QA result for the project team.
  • Reviewed and evaluated all the modules of the software before delivery to users to confirm its meeting the standard criteria.

Environment: Windows XP/NT, UNIX, C++, Java, HTML, XML, Java Script, Oracle, Rational Requisite Pro, UML, JIRA, Load Runner, Quality Centre.

Data Analyst

Confidential

Responsibilities:

  • Created new reports based on requirements.
  • Responsible for Generating Weekly ad-hoc Reports
  • Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
  • Designed models in Framework Manager and worked with parameter maps.
  • Optimized the performance of various stored procedures by redesigning T-SQL queries and changing and connection and server level settings.
  • Worked on transferring the data files to the vendor through sftp &Ftp process
  • Involved in defining and Constructing the customer to customer relationships based on Association with an account & customer
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Experience in performing Tableau administering by using tableau admin commands.
  • Worked with architects and, assisting in the development of current and target state enterprise-level data architectures
  • Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
  • Involved in defining the source to target data mappings, business rules, and data definitions.
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
  • Migrated three critical reporting systems to Business Objects and Web Intelligence on a Teradata platform
  • Created Excel charts and pivot tables for the Adhoc data pull.

Environment: MS Office Suite, MS Visio, MS SharePoint, Test Management Tool, MS Project, Crystal report, HTML.

Data Analyst

Confidential

Responsibilities:

  • Processed data received from vendors and loading them into the database. The process was carried out on a weekly basis and reports were delivered on a bi-weekly basis. The extracted data had to be checked for integrity.
  • Performance tuning of stored procedures and functions to optimize the query for better performance.
  • Transformed complex business logic into database design and maintaining it by using SQL objects, stored procedures, user defined functions, views, T-SQL scripting, and jobs.
  • Created Sub Reports, Parameterized and Drill-down Reports based on the requirements provided using SSRS.
  • Scheduled SSRS reports for end users and managed the security of the reports.
  • Created various SSRS reports such as Multi-valued reports, Parameterized, linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams.
  • Exported SSRS reports to various formats like PDF, Word, and Excel and scheduled for reports to send us an email body.
  • Documented requirements and obtained signoffs.
  • Automated the existing system to achieve faster and accurate data loading.
  • Generated weekly, bi-weekly reports to be sent to client business team using business objects and documented them too.
  • Learned to create Business Process Models.
  • Ability to manage multiple projects simultaneously tracking them towards varying timelines effectively through a combination of business and technical skills.
  • Good Understanding of clinical practice management, medical and laboratory billing and insurance claim with processing with process flow diagrams.
  • Assisted the QA team in creating test scenarios that cover a day in the life of the patient for Inpatient and Ambulatory workflows.

Environment: SQL, data profiling, data loading, QA team, SQL objects, T-SQL.

Hire Now