SUMMARY:

• Business Analyst with 8 Years of experience in Business Analysis, Data Analysis, Business Intelligence with specialize in authoring Business Requirement Document, Requirement gathering, Use Case Specifications, Business process Modeling, Technical Documentation, System Design Specification, Functional Specification.
• Experience in the domains of Insurance, Healthcare, Pharmacy Benefit Management (PBM), Financial, Supply chain and Banking Industries.
• Experience in Data Migration, Data Governance, Data Integration, Enterprise Data Warehouse (EDW), Business Intelligence (BI).
• Worked on Payment gateway to process credit card payments for online and traditional brick and mortar stores.
• Expertise in Software Development Life Cycle (SDLC) with version, change control and new software rollouts.
• Expertise in implementing the Agile, Rational Unified Process (RUP) and Waterfall Methodologies throughout the Software Development Life Cycle of the project.
• Experience in business process analysis for supply chain functions with deep understanding of ERP systems like SAP, Oracle, JDE etc.
• Expertise in Data Modelling in creating FACT and Dimension tables, Logical and Physical Data Modeling, Star and Snow Flake Schema, Normalized and De Normalized models.
• Experience in Global trade systems SAP GTS, Eclipse and PRISMA.
• Experience in Global supply chain implementation.
• Expertise in advocating process recommendations for automated system and documenting business process using UML (Unified Modelling Language).
• Excellent knowledge of Business Requirement Document (BRD), Web Design, Functional Requirement Document (FRD), Functional Specification Document (FSD), UX, UI Design, Prototype creations.
• Strong Understanding of Enterprise data warehouse, Data Analytics, Data Mining and reporting.
• Facilitated weekly and monthly business review meetings to keep SME's, Stakeholders, executive staff and team members apprised of goals, project status with timely identification, tracking, resolving issues and conflicts and preparing product demonstrations.
• Experience in G Suite and Google Cloud Platform Computing.
• Worked on Hadoop Ecosystems: HDFS, HIVE, PIG for storing data and running applications on clusters of commodity hardware.
• Worked on Robotic Process Automation (RPA)to deliver direct profitability while improving accuracy across entire business functions.
• Experience on automation technologies like OCR and Cognitive.
• Worked on BI tools like Tableau to focus on data visualization, dash boarding and data discovery.
• Exceptional Documentation Skills for writing Use Cases and Functional Requirement Documents (FRD) as well as for creating Use Case diagrams, Activity diagrams, Sate diagrams and Business object modeling flow diagrams.
• Implemented systems that are highly available, scalable and self - healing on the AWS platform.
• Encrypted data with an encryption algorithm and an encryption key.
• Combined data residing in different sources and provided users with a unified view of them with data integration.
• Performed data mapping, cleansing, transformation using metadata, SQL queries and Joins/Filters in the transformation and loaded tables into data marts and generated customized reports in DWH.
• Focused on User Experience (UX) on optimization of software solution in terms of user’s experiences associated while interacting with the solution or product.
• Expert in identifying and converting business needs into technical and non-functional requirements.
• Project Life Cycle with Business Analysis, Project Planning, Workflow, Execution and control with ability to support multiple simultaneous short-term projects.
• Recurrently conducted Joint Application Development (JAD) sessions with end-users and development team for project meetings, walkthroughs and customer interviews.
• Diverse experience in creating and maintaining Requirement Traceability Matrices (RTM) to keep the stakeholders informed of the progress of the project, conducting GAP Analysis and Cost Benefit Analysis.
• Proficient in performing ETL operations by using SQL, SAS Data Management and MDM software.
• Thorough experience in extracting and manipulating data from various disparate data sources like (XLS, csv, TXT) files, Oracle, SQL Server, MS-Access. Command in exporting complex internal data to word and .pdf format using ODS procedure.
• Experience in Quality Assurance (QA) and conducting User Acceptance Testing (UAT).
• Excellent knowledge in SQL, PL/SQL on the SQL Server and Oracle database environments.
• Excellent communication skills with a proficiency in problem abstraction, business modeling, leadership skills and ability to work in a cross functional team.

TECHNICAL SKILLS:

Operating Systems: UNIX, LINUX, Windows 2000/NT 4.0/XP

Technologies: UML, SQL, HTML, XML, C, C++, JAVA, J2EE

MS: Access, MySQL, RDBMS, Oracle 10g, MongoDB, IMS

Methodologies: RUP, UML, Business Modelling, Agile, Waterfall, Scrum

Testing Tools: QTP, Rational Clear Quest, HP ALM, Win Runner

Other Tools: SAP, MS Visio, MS Office, Rational Rose, COGNOS, TOAD, Lucid Chart, G Suite, RTC, Oracle SQL Developer, Oracle BI, BALSAMIQ, service now

Reporting Tools: Business Objects, Tableau, PowerPivot, QLIKVIEW, Power BI

PROFESSIONAL EXPERIENCE:

Confidential, NC

Senior Business Analyst

Responsibilities:

• Involved in conducting reviews, walkthroughs and facilitating in requirement definition workshops (JAD) to get consensus on Business requirements for the project.
• Attended workshops facilitated by Program Managers involving Business to ask questions and get clarifications that will enable in documenting System requirements.
• Worked of effort estimate Sizing in terms of resource needs from BA track perspective.
• Created key documents such as System Requirements Specifications(SRS), Requirements traceability matrix(RTM), mapping sheet between Loan Origination system(LOS), Operational Data store(ODS) having transactional data and downstream systems like OFAC, Document storage, Home Mortgage Disclosure Act, etc.
• Used Robotic Process Automation (RPA) systems to log into applications, move folders and files, copy and paste data, extract structured and semi structured data from documents using Uipath.
• Mapping document for real time web-services for sending leads to CRM, data to LOS’ pricing engine to generate customizable rates.
• Described various relation between various modules and functions of the system covering the system architecture and database design using High Level Design (HLD).
• Worked on Payment gateways in ecommerce transaction process authorizing payments made between the client and customer.
• Tracked and stored data about customers, activities, assets and other elements using Oracle BI.
• Used Hyper Text Transfer Protocol Secure (HTTPS) a secure version of HTTP over which the data was sent between the browser and website.
• Assisted a project team with retrieving necessary data from operational systems and updating source to target mapping documents.
• Modified and created database objects like Tables, Indexes, Constraints, Packages, Stored Procedures, Functions and Triggers using SQL and PL/SQL.
• Assisted in Data Model design for ODS by mapping with LOS’ data-model in compliance with MISMO.
• Assisted the QA in identifying test scenarios.
• Conducted several training sessions with the users to familiarize them with the functionality and understood their business process and made recommendations on using the system so that it achieves the end goal efficiently.
• Run Ad-hoc reports for management as well writing SQL queries on MS SQL Server and upload reports on SharePoint site.
• Managed the design and execution of data migration activities, system improvements and extensions.
• Worked in Salesforce environment to get data for reporting needs.
• Lead management process in Salesforce.com Sales Cloud module for channels like IVR, web portal of the company, existing customers from Marketing Analytics.
• From web portal, leads were pushed to CRM and post qualification of leads into opportunities, they were sent to LOS.
• Interacted directly with the stakeholders and Business Managers and served as a primary point of contact for Data warehousing and COGNOS reporting solutions.
• Operational Data Store (ODS): The client wanted to have a data store to be intermediary between any two systems exchanging data. E.g. Web portal to Salesforce via ODS.
• Worked with ETL developers for creating real time data interfaces and Db extracts (ETL Design).
• Created data store to be intermediary between Web portal to Salesforce via ODS.

Environment: Oracle, Agile, MS Visio, JIRA, One Confluence, Salesforce, Word, Excel, SWOT, ETL, SQL, JAVA, MS Access, Rational Suite, Caliber RM, TOAD, HP ALM, JSON, Loan Center LOS

Confidential, NJ

Senior Business Analyst

Responsibilities:

• Involved in building business requirement collection approach based on the project scope, SDLC methodology and provided Business Requirement Documents (BRD).
• Interacted with business stakeholders to get a better understanding of the requirements to build a business case for the IT Financial Management (ITFM) project.
• Gathered Business Requirements, analyzed data/workflows, defined the scope, financial projections, and Cost/Benefit analysis.
• Prepared technical design documents including data mapping document.
• Analyzed high-level user requirements, translated them into functional and business specifications documents for development and testing.
• Worked with Enterprise data warehouse team and BI Architecture team to understand repository objects.
• Conducted meetings with cross-functional stakeholders to address business issues and developed resolutions.
• Used Data transformation tools such as DTS, SSIS, Data Stage.
• Worked with SQL and Data Warehousing for arrangement of customer data.
• Worked on two models/cubes in Confidential environment for budget data (ITFM model) and Staffing data (Workforce model) with shared and unique dimensions in SAP BPC 10.1.
• Dimension members for all the dimensions were added and updated according to the business requirement.
• The system included data integration, Audit, Workflow, Actuals tracking, versioning, archival and recovery, and headcount management capabilities.
• Strong working experience in building BPC input schedules and reports using EPM (Enterprise Performance Management add-in for Excel) formulas.
• Developed an automated monthly automated financial reporting package called Financial Package for all the IT Cost Centers using BPC reporting capabilities and VBA for Excel.
• Developed Input schedules to upload budget and staffing data into BPC, Validation reports to fetch the data back from BPC.
• Worked on PL/SQL and Dynamic SQL to extract Data from Oracle databases.
• Used TOAD and ERWIN for creation of packages and stored procedures for database modelling.
• Reviewed the data model and reporting requirements for COGNOS Reports with the Data warehouse/ETL and reporting team.
• Created department training and procedure related user manuals regarding system functionality.
• Developed, planned, and participated in user acceptance testing, functional testing, and regression testing.

Environment: JSON, MS Visio, TOAD, MS Office, XML, SQL, PLSQL, Crystal Reports, Win Runner, MS SQL Server, Visual Studio, TFS

Confidential, NJ

Business/Data Analyst

Responsibilities:

• Interacted with stakeholders to get a better understanding of client business processes and gathered business requirements.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop, Documented User Stories, and facilitated discussions to analyze the level of effort on project specifications.
• Gathered Business Requirements, analyzed data/workflows, and defined the scope, financial projections, and Cost/Benefit analysis.
• Performed ad hoc data analysis and creation of reports using SQL and Excel.
• Tracked and managed incoming data, developed data validation routines.
• Identified Use cases from the requirements and wrote Use Case Specifications.
• Interacted with enterprise architects, developers and Data warehouse teams regarding project requirements explanation and interpretation.
• Claims are received in terms of electronic (EDI 837) and paper claims (CMS 1500, UB 04).
• Prepared graphical depictions of User stories, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams using MS Visio.
• Created Error files and log tables containing data with discrepancies to analyze and re process the data.
• Claims processed accordingly with the appropriate system reason codes.
• Medical Claims Processing files and HIPAA guidelines adherence across the company are included.
• Prototyped the application, provided screen shots for better visualizations.
• Coordinated and collaborated the business, operations, and the technical areas throughout the project life cycle.
• Facilitated Board meetings and acted as a liaison between parties impacted by the change requests.
• Verified EDI transactions 837 (Health Care Claims), 835 (Health Care Claims Payments)
• Actively interacted with other corporate departments, including executive, legal and information services as well as vendor relationships.

Environment: MS Word, MS PowerPoint, MS Visio, MS Excel, SQL server, MS Project, MS Share point, Outlook.

Confidential

Business Analyst

Responsibilities:

• Interacted directly and assisted project manager and team members to allow compliance with successful implementation of project within time and cost.
• Addressed all aspects of the claim processing lifecycle, starting from identifying a claim right up to closure.
• Thoroughly studied the Project Proposal and Business Rules.
• Monitored of implementing partners, contractors to ensure compliance with MOUs and World Vision policies
• Designed the Use Case Diagrams, State Chart Diagrams for all functional requirements.
• Supervised day-to-day activities of team members.
• Managed all financial and human resources aspects of the project.
• Coordinated meetings with business stake holders and representatives to further clarify requirements.
• Used SQL, spreadsheet (Excel) on daily basis to accomplish tasks.
• Developed the various steps in the lifecycle and then constructed the system in such a way that the riskier claims could be easily identified and monitored.
• Assisted in building a business analysis process model using Rational Rose and Visio.

Data Analyst/Business Intelligence

Responsibilities:

• Instrumental in developing new tools, procedures and methods for data analysis.
• Improved the design of BI tools such as dashboards, alerts, reporting and played a vital role in data visualization.
• Worked on data requirements, design, development, error fixes according to the client requirements in various projects.
• Developed project plans, designs and procedure for data analysis and worked with the clients satisfying the requirements.
• Design the procedure for analyzing and visualizing the data for clients.
• Responsible for deep data mining and analysis.
• Training the clients on new software usage.
• Error fixes on raised issues of software and windows.
• Meet deadlines set up on sprint meeting on heavy projects.
• Instrumental in creating test plans, project plans and other management scenarios.
• Resolve multiple tasks 24/7 on technical issues for clients in person or over phone.
• Responsible for statistical analysis for business and management documents.

Environment: JavaScript RUP, MS Visio, Microsoft Outlook, Pencil Project, Share point, MS Office (Word, Excel, Power Point).