PROFESSIONAL SUMMARY:

• Key contributions in requirement analysis including Use cases, user stories, BRDs, HLDs, Functional specifications, Qualitative and quantitative reports, scripting, web services, SQL, presentations, UI designs, wireframes and Proof of concepts.
• Proven skills in synthesizing and prioritizing requirements and assessing the impact of initiatives based on business needs, facilitating translation of business requirements with stake holders including SMEs, technical teams, architects, data analysts, QA and compliance groups.
• Hands on roles in design and maintenance of Data warehouse, ODS, ETL, data models, data mining, data integration, performance analysis, UI planning and research, codification, data strategy including mapping & reporting, data parsing, data cleansing and data .
• Worked on end - to-end projects covering discovery, gap analysis, WBS, new product implementations, solution integration, application sun set processes, migrations, quality assurance, UAT and roll out support.
• Adaptation and practice of BABOK guidelines in business analysis and PMBOK specifications in project management process.

TECHNICAL SKILLS:

Business Analysis: Elicitation, Interviews, presentations, surveys, Questionnaires, comprehension, brainstorming, research, data mining, JAD, presentations, workshops and focus group meets.

Business Documentation: Use cases, User stories, BRD, FS, Wireframes, work-flows, Interface analysis, Process modelling, UML activity diagrams, Competitive comparison matrix, Data flow diagrams, Data models, mind maps, feature matrix, prioritization and stakeholder matrix, feature roadmap, navigation map, performance reports, process flow diagrams, process improvement progress reports, scope models, stakeholder mapping, SWOT analysis, system architecture diagrams, system context diagrams, user interfaces, visualization presentations, As-is, To-be, Qualitative and quantitative analysis, traceability matrix, WBS.

Project Landscape: New development, Product configuration, User interface (Text, Graphical, Voice)Data Migration, DWH, Data Mart, ODS, Data Models, Business Rule Engines, Business Process optimization and Data migration. Workflow optimization, business rule engines, rate matrix, and meta-data configuration. Discovery, gap analysis, product implementations, UAT and production roll out, production support, Critical business acceptance testing, Process modelling, best practices, Facilitating scrum meetings, Triage, and coordination of onsite, offsite and offshore. Pre-sales support RFP responses, POCs, SLAs, Escrow, Estimation, Bid management.

Methodologies: Agile (Scrum), V-Model and Waterfall - PMBOK practice

Tools: SQL, Toad, Visio, Erwin, XML, Excel, MS Project, Java, JavaScript, HTML, JSON, XML, VB, Advanced Excel, visual basic, JavaScript, COBOL, ADABAS, CICS TFS, JIRA, Share Point, SSIS, SSRS, Informatica; Web logic, Web Sphere, Windows Active directory, SSO, OLAP, Authentication, PAM; Crystal Reports, Jasper Reports, Tableau ; HIPAA, EMR, HL7, DiCOM, ACORD, HIPAA, BASEL II, SOX, Swift

Bug Tool / Testing: Bug-zero, HP ALM, Bugzilla; QTP, Selenium;

ERP: SIEBEL, Oracle EBS v11;Sugar CRM; DB2, Oracle, SQL Server, MongoDB;

Tibco, WebServices: REST JAVA,.Net, JavaScript, HTML, CSS, XML, COBOL, xbasic, vba, Foxpro, Power Script

Databases / OS: Oracle, DB2, SQL Server, MS Access, MongoDB; UNIX, WINDOWS,Linux, Xenix, Mainframe ICL 2900, Mainframe Z/OS, AS/400

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Sr. Business Systems Analyst / Solution Architect

Responsibilities:

• Key contributions in BRD, use cases, process architecture, data modelling, QA strategy through Elicitation, interviews, JAD, presentations.
• Defined and executed data migration architecture in the creation of operational MDM, data, meta data, data governance, data audit and data metrics through data profiling, cleansing, conversion, transmission, reporting and monitoring & control.
• Worked extensively in key entities including Patient, Provider, Drug, Claims, Revenue Cycle, PDMP reporting to respective state agencies.
• Worked on design, document and execution of Archiving and initial reporting requirements for ODS and historical data.
• Coordinated Offshore/offsite meetings, facilitated daily scrum, presentations to periodical reviews and top management reporting.

Tools: Excel, Visio, SQL, Toad, MS Suite; MongoDB, SQL, TIBCO, APIs, ETL, XML, Control M, Mainframe / AS400 (DB2, COBOL, Flat files), Rocket DB, Oracle DB, SQL Server; Drug DB, HIPAA, PDMP

Confidential, Chicago, IL

Sr. Business Systems Analyst/ Solution Architect

Responsibilities:

• Facilitated through meetings, JAD, architecture sessions, interviews, questionnaires, presentations with all stake holders contributed in
• Capturing as-is business processes, business rules, flows, user access, security consideration, meta data, MDM, data structures, data streams, dependent external and internal applications, interfaces and data archiving.
• Creating to-be state application documentation including functional specifications, revised business rules, configuration, streamlined (combined) meta data, back provisions, data constraints for both historical and current information, functional specifications, process follows, checks and balances reports, verification processes, reports, data model enhancements, archiving rules and processes.
• Worked extensively on existing and future state of product configuration, design, data and functioning of Life, Annuity, UL, Accident Insurance, Critical Insurance, Disability Insurance, Worksite Insurance, Health Management, Occupational Health, Fitness and other Health products; PAS (Policy Admin Services); Producer Support System (Agent Management); Actuary ratings and calculations; UL configuration and re-calculation; Commission and Compensation; Claims;

Tools: Excel, Visio, SQL, Toad, MS Suite; SQL - Oracle DB, SQL Server, DB2; TIBCO, APIs, ETL, XML, Control M, Mainframe (DB2, COBOL, VSAM, Flat files); Data migration (Mapping, ETL, SSIS, SSRS, MDM, Meta data, Cleansing, Transformation, Data Audit & for Insurance products: Life, Annuity, UL, DI, LTD, STD)

Confidential, Houston, TX

Sr. Solution Consultant / Project Manager

Responsibilities:

• Key contributions in the creation of new data model, data mapping, business acceptance tests, work flows, UI and report enhancements through stake holders meetings (product, users, architects and production support teams).
• Responsible in re-writing and revisions to configuration on new business rule engine.
• Worked Business Acceptance Tests, UAT assistance and post-production support

Tools: Advanced Excel functions, Visio, xml, SQL, Toad, MS Suite; SQL Server 2014; Nielsen data, Digital Assets management, Business Rule Engine, Medialine.

Confidential

Responsibilities:

• Worked on creation of product functional and technical specifications interacting with product architects and potential users.
• Created data model, interfaces and UI designs.
• Facilitated proof of concepts for all stages of media hub.
• Worked on work flows, fine tuning retrieval of right digital assets, verification & authorization, updating schedule and archiving updated digital files.
• Worked Business Acceptance Tests, UAT assistance and post-production support

Tools: MS Suite, Visio, SQL, Digital Hub; SQL Server, MS Access.; Digital Assets management, Scheduler, Archiving, Verification & Authorization

Confidential

Responsibilities:

• Created data model, UI designs, Interface XMLs, business rules configuration, on demand reports using existing documentation, interviews and presentations.
• Worked on the product on both web and mobile platforms
• Worked on interfaces using APIs through XML definitions

Tools: SQL Server, .NET frame work, ASP, Android; MS Suite, Excel, Visio, SQL

Confidential

Responsibilities:

• Worked on enhancements on HR & benefits module, Payroll, Financial Accounts, Asset Management and Engineering Estimates modules - through study of existing configuration, documentation, interviews with stake holders by creating enhancement documentation.
• Worked on creating migration documentation from EBS v11 to v12 including checks and balances, rules configuration, data definitions, on-going enhancements and back processes.
• Worked on business and specification documents for Fund Management including contributions, benefits, withdrawals, interest calculation, remissions and investments.

Tools: EBS v11, Excel, Oracle DB, SQL, MS Suite, Alpha Anywhere - SQL Server; RFP support

Confidential

Sr. Solution Consultant / Project Manager

Responsibilities:

• Key contributions in discovery, gap analysis, enhancements, interfaces and post production phases of product deliveries.
• Created documentation for product design, data model, metadata configuration, integration with internal and external applications through effective meetings, interaction with technical architects, DBAs, SMEs, Testing steams and other stake holders.
• Conducted stake holder meetings, JAD, architecture sessions, interviews, surveys, quality & quantity analysis and produced BRDs, FRs, Process flows, Interface documentation, mapping sheets, analytical reports, gap analysis, solution options and corrective measures.
• Prepared work estimations, work plans and created WBS, identified risks, created SWOT Analysis
• Captured as-is business processes, business rules, work flows, conducted data profiling, mapping, data cleansing, data corrections, incorporated data governance, standards, checks & balances, studied and recommended best possible transmission methodologies.
• Worked on Creating new solution documentation including functional specifications, enhancements, UI, metadata, revised business rules, configuration, new process flows, automated checks and balance reports, verification processes, reports, data model enhancements, archiving rules and processes. Carried out business acceptance audit, assisted in UAT, supported production moves and post-production issues.
• Created xml interfaces with external applications for both incoming and outgoing jobs using API calls, batch jobs and on demand data transmission.
• Presentations to stake holder groups, client steering teams, pre-sales product and POCs sessions, top management reporting, periodical reviews. Business Analytical extensions through reports, dashboards.
• Worked solutions related to Life, Annuity, UL; New business, PAS, Producer Support System (Agent Management), vendor interfaces, Actuary ratings and calculations, underwriting configuration, compensation, claims and Financial Accounting.
• Trained business analysts, configurators and end users in product configuration. Worked on product documentation, user manuals, standard operating procedures, interface process documents.
• Worked on design and documentation of SLAs, solution review reports, release notes, operational manuals, user manuals
• Engaged in key users, mentoring Bas, Configurators and production support resources in product setup, configuration and fine tuning.

Tools: Excel, Visio, SQL, Toad, MS Suite; SQL Server, Oracle, DB2, APIs, ETL, XML Control M, Mainframe (DB2, COBOL, VSAM, Flat files), AS400, Web Sphere, Web Logic; Data migration (Mapping, ETL, MDM, Meta data, Cleansing, Transformation, Data Audit & ); Ingenium, life Asia, Swiss re; RFP support;

Confidential

Sr. Business Systems Analyst/ Project Manager

Responsibilities:

• Engaged in facilitating meetings, interviews, presentations to collect and document requirements using product suite (configurable tools); Conducted client sessions and facilitated identification of gaps, improvements and deliveries.
• Contributed in documenting enhancement requirements, impact analysis and specifications.
• Key contributions in capturing and configuring business rules in designing compensation and campaign management system.

Tools: Excel, Visio, SQL, Oracle DB,, DB2; ETL, Power Builder, COBOL, VSAM, Flat files; ; Data migration (Mapping, ETL, Meta data, Cleansing, Transformation); BRE (Business Rule Engine);RFP support;

Confidential

Business Systems Analyst /Lead Manager

Responsibilities:

• Worked on design, requirement documentation, development and execution of Bank Plus and aptourism.com solutions. ed best solution delivery in banking retail segment ‘Bank Plus’.

Tools: Excel, SQL, MS Suite, DB2, Delphi, ASP, Web Logic, HTML, CSS; RFP support;