SUMMARY:

• Over 11 years of experience as Sr. Technical Business System Analyst / IT Architect in Information Technology industry with focus on Data Analysis, MDM Development, Data Management, Data Mapping & Data Modeling, Business Process Improvement, Information & Data Management; expertise in implementation of IT projects using Project Management methodologies.
• Extensive experience in diversified industry sectors including Healthcare, Life Insurance, Personal & Commercial Insurance, Property and Casualty Insurance, Telecommunication, Retail & e - Commerce (Web Merchandising), Commercial & Investment Banking and Credit Card services.
• Excellent expertise in Data Modeling for ODS and DW using Erwin which involves data analysis and data mapping.
• Excellent understanding of Reverse and Forward Engineering, Logical and Physical Model.
• Strong skills in Data Warehouse Design using Star Schema roll out for the fact and dimension tables. Design of cubes, partitions and aggregations with excellent knowledge of Type 2 Data modeling.
• Expertise in application development with Full Lifecycle implementation of large Data Warehouse including Project Scope, requirements gathering, Star Schema Design, Snowflake Schema, Data Modeling and ODS.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Informatica PowerCenter.
• Thorough knowledge of eCommerce architecture; ATG framework its functional limitations and the platform features, application capabilities, etc. including industry wide terminologies like B2B, B2C, C2B, C2C with its eCommerce categories and strong knowledge of PCI DSS standards.
• 5 years of extensive experience as MicroStrategy Developer, Architect & Administrator building projects and creating reports and Dashboards using MicroStrategy 7.i/ 7.5/8.0/8.1/9.0/9.0.1, Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.
• Expertise in Desktop creating and integrating Microstrategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
• Strong working knowledge of Balsamiq Studio, SnagIT Editor, Snipping Tool and other wireframing and proto-typing tools used for mock-ups.
• Hands on experience with EDI HIPAA transactions 834s, 837s, 270/271, 999, 277CA.
• Multiple large eCommerce implementation experience. With hands-on experience & deep knowledge in following modules (ATG Version 2006.3 and latest version): Commerce, Merchandising, ATG Search, Content Management, Customer Intelligence, Campaign Optimizer, Outreach, Commerce Service Center.
• Technical expertise in handling large-scale platform architecture, integrations, Enterprise Service Bus (ESB) integration, development using Java/J2EE Technologies. Experience on Oracle Commerce includes ATG Commerce (B2B/B2C), ATG Multisite, ATG Merchandising, and Content Management working in some of the key areas such as the Business Control Center (BCC), Profile Management, Shopping Cart, Checkout, Pricing, performance tuning, caching, infrastructure setup and Endeca.
• Strong knowledge of design patterns, design concurrency, scalability and fault tolerant designs. Strong knowledge of application and systems performance improvement techniques, integration technologies, approaches and patterns, Web APIs / Web Service API calls (SoapUI / SOAP, RESTful API, SOA, XML, HTTP like GET / PUT / POST / DELETE, JSON, BitTorrent, Web 2.0, etc.). Strong knowledge of security aspects like risks and threats, authentication, authorization, certificates, encryption. Experience in utilizing frameworks and re-usable components.
• Proficient in using Business Analysis tools such as MS Visio, Word, Excel (including Pivot tables, Macros and Vlookup), Rational Requiste Pro, ReqTrace Web, Caliber RM, Optimal Trace, ClearCase and ClearQuest.
• Strong Experience with end-to-end implementation in Master Data Management including Data Profiling, Data Mapping, Data Cleansing and Data Quality Tools.
• Strong working knowledge with Trizetto Facets claims processing system / platform.
• Expertise in creating the dimensional models and creating ETL specifications.
• Strong knowledge of Payer operations (Membership, Provider Ops, claims processing, care management)
• Expertise in writing BI report formats and templates/specs.
• Proficiency in elaborating the Use cases, writing Test cases and preparing Requirement Traceability Matrices (RTM).
• Solid understanding of the third party administrator Pharmacy Benefit Management (PBM) Healthcare industry or health insurance experience and healthcare data standards.
• Conducting the UAT and hand holding the users during the initial usage of the software.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Ability to work on multiple projects simultaneously and prioritize appropriately.

TECHNICAL SKILLS:

• Windows 95/98/NT/2000/XP/Vista/7
• MS Visio
• MS Access
• MS Word
• MS Excel
• MS Project
• Rational Rose Enterprise
• IBM Rational Software Architect
• Microsoft Project
• Rational Requisite Pro
• MS SQL Server 7.0/2000
• PL/SQL
• CSS (Cascading Style Sheet)
• OLTP & OLAP
• Synon/2E
• COBOL
• IBM AS/400
• CICS
• Citrix
• DB2
• SAP R/3 FICO
• ERWIN Data Modeler 4.2/4.1/4.0
• Business Objects XI r3 r2 r1
• 6.5
• 6.1
• 5.x
• 4.x
• Crystal Reports XI
• Informatica
• HTML
• Dream Weaver
• MS FrontPage
• IBM COGNOS (Report Studio
• Query Studio
• Framework Manager
• Virtual View Manager
• Business Insight Dashboard)
• Oracle BI Enterprise Edition (OBIEE)
• C#
• C++
• R Programming Language (Version 3.2.5)
• Minitab
• XML
• XSD
• WSDL
• X12
• SAP PowerDesigner
• SAP PowerBuilder
• Analysis of Variance (ANOVA) and Experimental Design
• Total Quality Management and Lean Six Sigma Manufacturing Methodologies.

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

Sr. Technical Business System Analyst

Responsibilities:-

• Authored, owned, managed and maintained 1Pagers to give brief overview of the products / services to created and maintained in our MCS / SCM portal. Facilitated meeting sessions with Product Managers, Product Owners, Architectures and Analyst to hash out visio IoT (Internet of Things) Vendor flows, Order Fulfillment Flows and Order Processing Flows.
• Authored, owned, managed and maintained Design Approach Document (DAD) to provide the solutions on how the business requirements are to be met and fulfilled by our application. Authored, owned, managed and maintained SCM / MCS Catalog Sheet (SKU / Items Setup sheet) that is leveraged to stock, create and publish items / SKUs into SCM Portal. Thereby created Enterprise, Items, Price Plans, Category and then associated that Item (by ‘Create Association’) by adding DEEPLINKING category within the SCM Portal and VIG (Vendor Intelligence Portal) SCM GUI Graphical User Interface).
• Planned, created, designed, managed and baselined draft high-level Project Scope, In-Scope & Out-Scope Functionalities, Draft SLAs (for 3rd party vendors / partners), Baseline Project Timelines & Gantt Chart at project implementation level with external 3rd party vendors / partners (in order to accomplish System Integration Testing SIT milestone) system application. Also assisted CAM (Client Account Manager) and PMs from frontend system applications to baseline draft Program / Portfolio Timelines & Gantt Chart at program implementation level with multiple external fulfilling partners / vendors (in order to accomplish User Acceptance Testing UAT and Commercial Product Launch milestone). Facilitated and drove multiple / recurring SIT (System Integration Testing) sessions with vendors / partners to cover and make sure all the “Sunny Day Scenarios” of a business use-case and edge-case scenarios (negative scenarios) from the Test Case template were tested, verified and validated by the QA team. Thereby providing sign-offs on system integration & API implementation milestones between source and target system applications.
• Planned and developed methods and procedures for implementing program; directed and coordinated program activities; and exercise control over personnel responsible for specific functions or phases of the program.
• Managed project charter, project plans, scope statement, project execution, risk mitigation, contingency plan and achievement of project and program objectives. Managed SIT & UAT test activities by ensuring defects are logged accurately in JIRA and issues resolved appropriately.
• Proven expertise in systems integration and development, Enterprise Service Bus (ESB) integration, package implementation, and interactive designing. With proficiency in Java, OO Application Development, under UNIX and strong understanding of complex computer science and software engineering principles.
• Reviewed reports and records of activities to ensure progress is being accomplished toward specified program objectives and modified or changed the approach design document as required to redirect activities and attain objectives.
• Logged risks, assumptions, issues, dependencies in RAID sheet and raised concerns to important launch gating issues, thereby escalating pertinent issues appropriately. Created technical powerpoint presentations, slides, weekly statuses in powerpoint alongwith brief project write-ups that includes NPV (Net Present Value), Product Overview, Key Features, Reasons as to why should VZW implement this project, etc.
• Created, aligned and logged EPICS, User Stories / Features, Tasks (Development, Infrastructure & QA Tasks), Bugs, Defects, BRs (Build Requests), DRs (Deployment Requests), Issues, etc. in JIRA tool. Thereby identified cardinality, associated, defined and linked these issues and tasks to appropriate issues within JIRA. Provided and updated JIRA with LOEs / ROMs / Rough Estimates for different functional areas / modules like CMP (Catalog Management Platform), SCM (Service Creation & Maintenance / Service Configuration & Management) etc. Identified and updated appropriate components (like CMP, SCM, Infrastructure, QA) i.e. impacted system applications (internal to VZW-MCS team OR external multiple cross applications within VZW) for ‘Components’ field in JIRA. Also ran JIRA reports for daily management status reporting and daily Sprint Status calls, by applying user defined queries and filtering parameters. Thereby shared those bookmarked queries with internal MCS team members upon giving appropriate title to those queries. Identified Fix Versions, planned & actual Sprints (Future and Current Sprints) based on the mapped Enterprise Releases (E.Rs) for that particular calendar year and thereby updated to each JIRA issues. Conducted and drove Sprint Planning sessions along with Scrum Master during Monthly Sprint Planning & Process Design sessions.
• Requested Project Clarity IDs (Project IDs) and Labor Codes from IT CAM (Client Account Manager) for Auditing and Budgeting purposes. Thereby updated JIRA tool with respective Clarity Project IDs mapped to MCS Internal Project IDs. Identified and defined parent to child relationship between JIRA EPIC, User Stories, issues, tasks, BRs, DRs, Bugs, Defects and tied them accordingly within the JIRA tool.
• Identified potentially impacted system applications within VZW (i.e. x-apps / cross application outside MCS business unit) for a particular IoT (Internet Of Things) & ReSale products and thereby facilitated requirement clarification sessions with the POCs (point of contacts) from those system areas. Those systems areas / system application consisted of frontend applications like POS, Omni-channel ACSS, MyBiz / EPB, ACSR, etc. and downstream system applications like Billing (i.e. VISION), Settlements (VSG / BBS) Vendor Settlements Gateway, CCRS (Commissions system), EPOD (Enterprise Purchase Order Databases), ECPD (Enterprise Customer Profile Database), etc. from the VZW System Architecture standpoint. Other impacted system applications consisted of 3rd party applications i.e. external to VZW system areas.
• Leveraged ThingSpace platform to process & fulfill AgTech (Verizon Precision Agriculture Platform) Orders, along with the Software and Professional Services items within an AgTech Order. As ThingSpace SME (Subject Matter Expert) provided architectural guidance to internal MCS team members, thereby proving primary POC (Point of Contact) for MCS business unit from the overall Program / Portfolio perspective.
• Led and managed business requirements, functional requirements and system requirements from overall program / portfolio perspective for major IoT (Internet Of Things) and ReSale products and services like Intelligent Video, AgTech, Samsung Knox etc. Understood and perform impact analysis on any new features and functionalities to be introduced and thereby implements to the existing BAU (Business As Usual) service workflows.
• Thoroughly understood concepts on Recurring Charges, Recurring Manager to recur license subscription, Event Handler, Publish Go-Live, Online tables vs. Offline tables, Single Line Item Cart, Multiple Line Item Cart, Order Level versus Item Level triggering / invoking / firing of APIs, One Time (Perpetual) Charges, Recurring Charges / Subscription, Bill To Account (BTA), Billing Frequency (One time / Monthly / Annually), Is First Purchase check, Check Eligibility, Commissionable Items / SKUs, Commission Category, Bundled SKUs, Kitted SKUs, Modify License, Cancel Subscription / Cancel Order, Terminate Subscription, etc.
• Reviewed SCM API Integration Guide with Partner, determine timeline of project and any special requirements, provide / revise Business Requirements Documents.
• Leveraged RealTime API web-service calls like Checkout Cart XML, Submit Purchase XML, Event Notification XML to post / submit IoT & ReSale Orders in Single Line Item and Multiple Line Item format, thereby firing / invoking / triggering these APIs at Order level and at Item Level (these API we-service calls were predominantly used for Outbound / External communications with 3rd party vendors / partners). Also used API web-service calls Get View, Check Eligibility, View Purchase, etc. API web-service XMLs to perform Sanity test on the existing BAU (Business As Usual) functionalities.
• Explained High-Level Dataflow, System Process Flow, Order Processing Flow, System Flow and API Dataflow to impacted multiple cross applications (x-apps) within VZW system architectures.
• Authored, owned, managed and maintained “Vendor OnBoarding” sheet that Middleware Infrastructure team used in order to onboard any new vendors / partners system applications into our internal VZW - MCS networks and systems. Thereby identified specific set of APIs that were to be used and implemented in order to integrate with External vendor / partner systems application; versus the ones those were obsolete and not to be used. Provided and filled connectivity details like the IP addresses of the external vendor / partner system servers, external Endpoint URLs and Complete Endpoint URLs that were to be whitelisted into internal VZW - MCS networks (via IBM WebSphere DataPower) for us to communicate to outside network (i.e. external 3rd party vendor’s / partner’s network); for both PROD (i.e. Production environment) and NON-PROD environments (lower environments like T1/QA1/Dev1, T2/QA2/Dev2, etc. for System Integration Testing). Facilitated numerous calls with 3rd party vendors / partners and internal VZW MCS Infrastructure team in order to troubleshoot and make sure connectivity between both system applications is established and setup properly, thereby finalizing on Middleware Connectivity Requirements and timelines.
• Answered Detailed Questions regarding API flows and types of APIs to be used. Determined type of web-service API calling Model to be used (Synchronous API calling versus Asynchronous API calling) in the designed solution “Approach document”. Depended on Partner Capability, Business Billing Requirements.
• Provided Schemas, XML samples, Business purpose of the APIs, Onboarding sheet, etc. to key resources belonging to different system modules. Facilitated Connectivity Setup & Connectivity Testing with Infrastructure Team.
• Wrote Test Cases and Worked with Vendor / partner to create SIT Test Cases. Verified End to End Functionality for all System Integrations. Attended Stand up Calls/Live Testing Calls with 3rd Party Vendors / Partners.
• Strong knowledge of Unix commands and running those Unix commands in various boxes to validate server logs. Executed and ran Oracle SQL queries into different database (DB) tables (both CMP and SCM online/offline each) belonging to non-prod environments (like T1/QA1/Dev1, T2/QA2/Dev2, etc.).
• Troubleshoot and connected to SCM & CMP Database environments. Discussed on project timelines and created baseline draft copy of Gantt Chart for “Intelligent Video” & “Samsung KNOX (Phase2)” for IoT (Internet Of Things) & ReSale projects respectively.
• Discussed on vendor/partner’s system connectivity issues with business & IT. Worked on and understood turn-around times needed by Infrastructure team to set-up the servers and environments to point to external vendors/partners’ systems.
• Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• Distributed “Vendor OnBoarding” sheet to partners/vendors we are integrating with for “Intelligent Video” project. Briefly touch-pointed on “AgTech / Verizon Precision Agriculture Platform” project that requires product enhancement for upcoming phased E.R delivery; having impacts on FrontEnd Applications like POS, MyBiz / EPB, ACSS). Received transition/assignment allocation on the same from peer meeting.
• Discussed on resource alignments for IoT (Internet Of Things) & ReSale projects, along with Development resource allocations for the Intelligent products. Meeting with Vendors/Partners to discuss on requirements and needs for the Intelligent Video product from System Integration, Catalog display & Pricing and API elements (in Vendor OnBoarding sheet) standpoint. Thereby resolved issues, technical clarifications needed by vendors/partners during the call.
• Created user experience (UI/UX) flows for business use cases using Balsamiq studio professional version.
• Provided overview of the approach document to off-shore VDSI testing team on the “Intelligent Video” product. Discussed and confirmed new business requirement to be captured, documented and coded for “Partial Order Fulfillment”. Understood various business scenarios, use-case triggering points and front-end applications and back-end systems that will be impacted. Performed Impact Analysis for the same.
• Dealt with timelines issues on Development, Design & Code Drop for Intelligent Video and thereby discussed internally to prioritize release dates for Intelligent products viz. Intelligent Video & Intelligent Smart Lighting.
• Understood end-to-end system flow for IoT (Internet Of Things) & ReSale product. Gave walkthrough on ThingSpace platform, its core features and functionalities. Created business justification and business benefits for the purpose of using ThingSpace platform to fulfill AgTech product orders.
• Led assigned strategic projects as well as relied on to effectively evaluate current state business processes compared to business needs, analyzed data to assess performance and identified new opportunities for continuous improvement.
• Evaluated, designed, executed, measured, monitored and controlled business processes.
• Handled all aspects of the development & implementation of more than one large project and provides a single point of contact (SPOC) for those projects - original concept thru final implementation.
• Identified and created a business process to include requirement gathering, develop relevant operational specifications, and assisted with the design of effective solutions that take into account both associated costs and benefits.
• Acted independently or in collaboration for fulfilling complex business requirements with the implementation of reliable & efficient automated solutions; and enterprise wide initiatives.
• Built project teams and acquired resources for project activities through competitive and negotiated procurement processes. Oversaw activities of project team members including internal client resources as well as external vendors, contractors and design professionals.
• Captured and documented meetings, produced reports, presentations and other documentation and reporting status to all stakeholders and team members.
• Managed scope expectations, project costs and schedule to deliver accurate projects, on time and within budget.
• Accountable for driving project/program teams to identify and resolve risks/issues that arise during plan’s execution and effectively communicate to teams, senior management and governance bodies.

Environment: AccuRev Client 5.6, Boot File Defrag and Optimization, BTM Collector, BTM Driver V2, Cisco Jabber Client v 11.5.3.36060, Cognos for Microsoft Office 10.2, Activiti BPM, XML Spy, RestFUL API, SoapUI, HP Quality Center ALM (Application Lifecycle Management) 12.20 & 12.01, HP Quality Center Microsoft Excel Add-In 12.20, Quest Toad For Oracle 12.0 (64bit), Access Data Agent x 64 6.0.0.15, Programmer’s Notepad, MySQL Workbench 6.0, WebEx Productivity Tools, PuTTY.exe, JIRA, CA’s Clarity PPM, MicroStrategy 9.0/9.0.1, DameWare Mini Remote Control Service 12.0.3.0, Data Connectivity Components, DB2 AppDevClient 9.7, EMS for Outlook, IBM OnDemand CSDEF.fnt Update, IBM Cognos Dynamic Query Analyzer DQA 10.2.2, IBM Data Studio 4.1.1, IBM On Demand Client 9.0.0.3, Java Runtime Error (JRE) 8 Update 73, Java SE Development Kit 6 Update 45, JNLP File Association, MapMyDrives, MS Office Project Standard 2007, MS Office Standard 2007, MS Office Visio Standard, Notepad ++ JSON Plugin, Open Source XML tools, Oracle Client 11g R 2 11.2.0.1.0, Oracle MySQL 5.6.15, Patch Viewer 4.2.1.0, PC Validation Tool v1.4, SAP 7.4 V2, Balsamiq Studio, Techsmith’s SnagIT Editor 12, SQL Developer 4.1.3, Tableau Essbase Driver 9.1, Universal ID Service Client Installer, Verizon Reload Services 3.3.9, Verizon Wireless ACSS and Training Shortcuts, Verizon Wireless Client Service 4.0, VISION MKS 2007, VZW OnePOS NetACE, WebEx Client 30.10.0.10036.

Sr. Technical Business System Analyst / IT Project Architect

Responsibilities:-

• Analysis & Research on existing target environments within CHUBB and formulate questions for ACE's integration project.
• Created and documented roadmap for meetings with ACE. Baselined documents used for source to target mapping. Understanding CHUBB's system and applications i.e. Target system for CLIENT INT project.
• Designed, developed and maintained consistency of the Pre-landing and Landing tables “Generic Landing Layout” file / sheet that the core execution team leveraged for Source To Target Mapping sessions.
• Performed Source To Target Mappings (STTM) for disparate policy admin system data residing within their individual database environments. Thereby facilitated and drove numerous STTM clarifications and mapping sessions.
• Planning & organizing presentations for project kick-off meeting with ACE. Identified and analyzed Chubb's CPI MDM triggers, updates and matching rules at Client level.
• Conducted copious Requirement Elicitation sessions during the high level requirements conceptualization meetings, also facilitated and drove many Requirement Gathering sessions in form of formal Joint Application Development (JAD) meetings.
• Updated Business Requirements CPI CLIENT - Year 1 INT document, reviewed and created CPI CLIENT UI Year 1 INT Requirement Management Plan document. Participated in meetings with ACE stakeholders and gave walk-through on Policy Update triggers & MDM matching rules.
• Created and document High Level Data Movement and Data Flow diagrams, High Level & Detailed Conceptual Architecture diagrams using BPMN (Business Process Model and Notation) standards encapsulating every system components within visio flows.
• Created, designed templates and documented Requirement Management Plan for the Client INT UI project. Documented and created ACE's Policy Life cycle visio flow.
• Mapping of business policy transaction types and transaction entry codes, mapping "Individual" roles between Legacy ACE & Legacy Chubb policy admin systems.
• Performing mapping on "Individual" roles for Client UI application, policy status mappings for PLS & ORCA admin systems. Participated in designing Generic File layouts for the mappings from pre-landing to landing tables.
• Facilitated and drive "OOS - Out Of Sequence" endorsements and processing in PLS & ORCA source systems. Elicit and capture business requirements specific to individual legacy ACE source systems. Designed and drafted MDM File Standard / Generic File Layout for CPI Client Integration project.
• Facilitated requirements gathering sessions for ORCA source system. Thereby captured high level business requirements for the Yacht - ORCA / Rec Marine system. Also performed Policy Status mapping exercise.
• Confirmed on the mapping performed within “ORCA Policy Status Mapping” sheet for “Transaction Status” type and “Contract Status” type. Confirmed the data points in “Match Columns” column for the “Match Rules” from “Client INT ORCA Match Rules” sheet. Gave an overview on “System Triggers” and introduced team on triggers.
• Facilitated Client MDM - Generic Landing File Layout clarifications (for ORCA) session. Performed ORCA Policy Status Mapping on each and every ORCA system policy transactions.
• Thorough utilization of Tableau and SAP Lumira for creating and designing innovative customer centric dashboards for data visualization.
• Integrated Survivorship Rules for 6 Personal Lines Systems. Overview of “Survivorship Rules” (like “What is Survivorship and what does it mean to MDM process & Client UI application?”) and introduce team to “Survivorship / Survival Rules Matrix” sheet. Brief glance at the “Client INT Current Survivorship Rules”. Once team was on-boarded with better understanding on the concepts of “Survivorship Rules” (MDM Trust & Validation criteria) and have uniform understanding for decision making in terms of “Survivorship Rules” on 6 Personal Lines Source Systems; we would progress towards ranking availability and dependability of various data fields residing within each of these 6 systems (MasterPiece, CAAS, Yacht, PLS, ORCA, DRC).
• Involved in "Data Mapping - BRD Phase" meeting for ASP & CSP project that will be eventually impacting "Client Phase 3" project.
• Discussed & reviewed on “ORCA AnnualPremByTransaction.xlsx” sheet that shows the effects of policy changes on “Annualized Premium” in ORCA system; and “Calculated Annualized Premium” field calculation.
• Discussed “VOID” transactions and what happens when user deletes a vessel or coverage on a policy. Addressed concerns like What “Premium” amount should be displayed in MDM. Confirmation on “Out of Sequence (OOS)” processing the ORCA system will process and confirm on the triggers to be applied. “Agreed Upon Requirements” - Re-visit and confirm working documents for ORCA system integration. Complete initial draft version of MDM Match Rules. Discussed on Client INT ORCA Policy Status Matrix v1.5 DNR Processing & its business events triggers. Annualized Term Premium Calculations - identified business requirement and Non-Functional Requirements - Forecast / Prediction on % Growth Increase or Decrease in Transactional Volume for 2016.
• Conducted walk-through on First draft version of the PLS & ORCA Business Requirement Document (BRD for the stakeholders for their walk-through. Participated in PLS BRD walkthrough, discussed on the Non-Functional Requirements, facilitated Client MDM/UI - ORCA Nightly Batch Updates file extract window meeting. Participated in Client Integration Conceptual Architecture walk-through.
• Discussed & clarified PLS BRD Questions / Findings from Capgemini. Participated in Client Integration BA - Architecture meeting & Project status meeting. Gave walk-through on Client MDM/UI INT - ORCA BRD, in parts (i.e. Session1 & Session2). Participated in Client MDM Field Mapping document walkthrough. Participated in Conceptual Architecture Walk-through Part II.

Environment: Informatica Data Director (IDD), Informatica Analyzer, DB2, Informatica Power Center, MDM, Oracle 11g, Information Builder’s WebFocus 8, IBM Cognos Report Studio 10, IBM Lotus Notes, CICS, Cobol, Oracle SQL Server, MS Visio, MS Office Suite, MS Access, MasterPiece, Guidewire policy admin system, CAAS, Yacht, PLS, ORCA, DRC, SAP Lumira, SAP HANA, Tableau, SharePoint.

Sr. Technical Business System Analyst

Responsibilities:-

• Performed requirements gathering & analysis by actively soliciting, examining, investigating and negotiating customer requirements with business directors and Product Development Managers, while leading the technical requirements analysis and driving the system design and construction.
• Created Business Systems Design documents and Technical System Design documents along with POC (Proof of Concepts) for new functionalities introduced to accommodate ad-hoc feature updates from business team.
• Analyzed current Riversand’s PIM system, business processes and created strategic vision and roadmap for STIBO’s PDM system.
• Understood and analyzed the Current (As-Is) system context diagram on the existing Item Flow interfaces, in order to design and outline the future system context flow diagram.
• Worked with MicroStrategy Architect to build Attributes, Facts and Dimensions and developed perfect logical models for reporting environment.
• Involved in trouble shooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Identified PIM system’s pain-points, drawbacks & constraints in order to develop and design both a short-term (tactical) and long-term (strategic) solutions. Thereby improved the efficiency and operational behavior of Digital Merchandising workflow / work area.
• Deployed the software application/modules for various concepts within BBBY on both desktop & mobile channels.
• Performed extensive SKU to Product relationship mapping at UPC level, SKU/item level, Product level, Collection & Accessories level, etc. Thereby understood cardinality between SSWPs (Single SKU Web Products) and MSWPs (Multi SKU Web Products) and process by which they are “Web Enabled” and “Web Disabled” for “Digital Merchandising”.
• Designed and documented the complete user experience of the 3rd party light box modal/pop-up configurator (integrated with BBBY’s ATG platform) for the web users to enter the personalization details within the free form fields and thereby defining the enabling disabling logic for CTA (Call to Action) buttons on the configurator / light box modal.
• Used Tableau and QlikView for slicing and dicing the data to come up with key business insights and deriving compelling performance metrics.
• Conducted numerous impact analysis sessions, thereby analyzing the behavior of multiple features & functionalities on different web pages like PLP (Product List Page - Grid View & List View), PDP (Product Detail Page), Quick View, Collection & Accessories, Your Cart page, Single Shipping & Multi Shipping Location, Order Confirmation, Order Preview, Order History, Track Order, etc. and on the user CTA (Call to Action) button (buttons like Add to Cart, Add to Registry, Save for Later, Find in Store).
• Created / Documented, managed, controlled and delivered user stories, features and functionalities in form of Story or Functional Requirements (i.e. formal FRD) within the CCM & RM tools respectively. Updated the tools with appropriate COS (Condition of Satisfaction) / Acceptance Criteria, Story Title, Card, Conversation, Assumptions etc. by following standardized Agile SCRUM methodology/process.
• Also created / documented, managed, controlled and delivered Epic, Features, Story, Tasks, Spikes by breaking these out appropriately and then tie them back to the concerned Feature and Story within the RM (Requirements Management) tool.
• Aligned with business, IT/Dev & UX design team to understand discuss and document various Use Case scenarios, Use Case flows etc. by facilitating and driving copious Joint Application Development (JAD) working sessions.
• Tested the software applications on various higher (i.e. EUA and EQA) and lower (i.e. QA, Test1 + Test2 + Test3 etc.) testing environment. Performed integration and regression testing for end-to-end code testing for complete functionality/features.

Environment: IBM Lotus Notes; IBM’s Rational Tools; IBM Requirement Management (RM) Tool; IBM Change & Configuration Management (CCM) Tool; RMTrack – Defect Tracking; JIRA; ATG eCommerce Platform; TIBCO; Riversand’s PIM (Product Information Management); Tableau, QlikView, STIBO’s PDM (Product Data Master); Web2.0; Oracle SQL Server Developer; Microstrategy 9.0/9.0.1; MicroStrategy ODBC test tool; Oracle Endeca; UNIX; Java; .Net.

Sr. Technical Business System Analyst

Responsibilities:-

• Reviewed, analyzed and evaluated business processes and associated IT application requirements. Analyzed business workflow and system needs for conversions and migrations; performed data mapping and data conversions.
• Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims. Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set.
• Understood and deciphered the Business Logic behind the “Document Number Generation” for KDP and BCCDT program documents. Deciphered High Level Business Logic as well as COBOL job packages/program codes to understand and discuss with its SME on CMS-64; CMS-37; CMS-416 and CMS-372 Federal mandate reports.
• Applied thorough understanding and knowledge of “Claims Processing”, “Eligibility, Editing and Pricing of Claims”, “eCAMS Healthcare Rules Engine” and “Life Cycle of Claim”.
• Conducted detail oriented analysis on the current “AS-IS” Maryland MMIS legacy system and driving iterative GAP analysis sessions for the same to propose the effective target “TO-BE” MMIS system.
• Developed an implementation guide for Partners for EDI X12 transactions such as 834, 835, 837, 270 and 271. Recommended tactics to implement HIPAA 4010 (EDI X12 837,834,278,270) in the new System. Validated all the incoming/Outgoing data from EDI 837/835 interfaces.
• Developed Mapping rules, Designed specifications and Use Cases for the HIPAA 837 (P.I.D); 270/271, 276/277, 835, 824, 275 and others. Worked on multiple 837s and multiple Eligibility (270/271) and healthcare claim status (276/277). Created EOB systems (835).
• Created baseline architecture of the system with guidance from Solutions Architect, and a detailed system design to provide a stable basis for the Iterative development effort in the Construction Phase, and conduct an assessment of the risk.
• Collaborated with Business Leaders from DHMH and CSC counterpart, to share and gather Cognos and Oracle BI Planning requirements, designing and developing system work flows, thereby implementing these process flows for Dev., Prod. and Test environments.
• Designed Dashboards/Reports using the Oracle Business Intelligence Analytics platform for requirement analysis and data analytics. Enhanced performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc.
• Prepared ER Diagrams, documented Data Dictionary, identified database schemas, its data elements/fields, and studied their nomenclatures from the identified columns, for phased deliverables.
• Tested BI Reports and documented user testing manuals for Cognos 10 Reports. Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Evaluated data profiling, cleansing, integration and extraction tools (e.g. Informatica). Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Created the test scripts and complex queries to test the application and for quality assurance of the data.

Environment: MMIS / CMS Regulations, HIPAA Privacy, Wire Framing, UML, SCRUM, eCAMS & ProviderOne (CNSI owned & developed Claims Administration System), iLotus Notes, IBM COGNOS 10 Report Studio, Oracle Financials, JIRA (Defect Tracking Tool), ReqTrace Web 2.1, Oracle SQL Developer, J2EE, .NET, Oracle ODBC, Oracle BI Enterprise Edition 11g, MS Office Suite, MS Excel, MS Project, MS Office 365, SharePoint, Service Oriented Architecture (SOA), RUP (Rational Unified Process – For MMIS Development), Informatica PowerCenter, Enterprise Architect 10 UML (SPARX System’s EA Visual Modeling Platform).

Sr. Technical Business System Analyst

Responsibilities:-

• Gathered all the Reporting Requirements and functional requirements through JAD sessions, formal interviews and brain storming sessions from the Business Owners and stakeholders based on the project scope and documented it in form of FRDs and Use-Cases in CaliberRM/Optimal Trace.
• Involved in the System Analysis, Design and Development of the project. Integral part of end-to-end implementation of IW Reporting from capturing reporting requirements, Relational data modeling in Cognos, Metadata analysis, mock-up template designing and BI reporting system.
• Identified the functional as well as technical needs of the department and accordingly engaged as liaison between the Upper Management and IT Team to develop Cognos based BI Reports, applications and softwares. Integrated and implemented Trizetto’s FACETs claims processing platform.
• As an FRD owner, have driven functional requirement gathering sessions that included understanding and drafting (with Visio flows) Current State as well Future/Desire State ESI West-East process mappings.
• Tested the ANSI X12 Version 5010 / EDI transactions (HIPAA) for Claims Status and Eligibility (270, 271, 276, 277, 834, 837P, 837I, 837D, 835 remittances and NCPDP Claims). Managed the planning / test process for Medicare Part D Pharmacy Claims (PBM) & NCPDP code sets.
• Suggested and implemented innovative tools like RAID (Risk-Assumptions-Issues-Dependencies) and RACI (Responsible-Accountable-Consulted-Informed) in MS Excel to track and monitor these 8 performance parameters for any deliverables, tasks or milestones that can otherwise prove as a show-stopper.
• Interacted with several technicians like IW database developers and systems administrators to ensure smooth functioning of the business intelligence systems, Virtual View Manager (Cognos functionality) and Cognos BI Reports.
• Generated CCRF (Change Control Request Forms) forms for the UNIX & Cognos BI Reporting admin team to migrate the Cognos Codes, Reports and Report Packages from one environment to other environment (from Dev. to QA and QA to Prod.).
• Documented existing (current state / “AS-IS”) and proposed (future state / “TO-BE”) process flow, analyzed current and target ESI West-East Legacy systems, and conducted GAP analysis on functional requirements as well from the reporting requirements to the existing data in ODS.
• Documented the Technical specifications in the TSD and created the project templates for Use case specification, drafted Change request forms based on the SOPs (Statement Of Purposes) for Cognos application, functional specification documents and Business Requirement documents and Defect status forms.
• Analyzed and designed software and database solutions. Created and designed data flow diagrams in MS Visio for cross-functional data marts and multidimensional Data Warehouses at Confidential .
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Swim Lane Diagrams, Sequence Diagrams, Business process models, Component Based Diagrams and Collateral Diagrams.
• Assisted in development of the reports using Cognos Report Studio and Framework Manager. Developed Forms, Reports and Queries using MS Access and Excel (including Pivot tables, Vlookup and Macros).

Environment: SCRUM, RUP, SharePoint, Synon/2E, COBOL, IBM AS/400, IBM Cognos 10 (Report Studio, Query Studio, Framework Manager, Virtual View Manager, Business Insight Dashboard), DB2, UNIX, Microsoft SQL Server 2008, T-SQL, MS SQL Server, Teradata IW, BRIO Query Intelligence, MS Excel, MS Word, MS Access, MS Project, MS Visio, ERWIN, OiM (Oracle Identity Manager), Oracle BI Enterprise Edition 10g, PL/SQL, PC Media, CAs ALL Fusion Harvest, HP Quality Center, EDI, XML, .CSV (Comma Delimited), Rational Clear Quest, Anchor DW, Foundation14 (F14), CaliberRM 64Bit Production, Optimal Trace.

Sr. Technical Business System Analyst

Responsibilities:-

• Gathered, analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders, thereby drafting the Technical Design Document (TDD) and System Specification Document (SSD).
• Performed Data mapping on the extracted data by identifying the data sets, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Designed and developed Use Cases and Use Case scenarios, Activity Diagrams, Sequence Diagrams, High Level and Low Level Process Flow Diagrams, OOAD using UML and Business Process Modeling.
• Profiled data in the sources prior to defining the data cleaning rules. Perform small enhancements (data cleansing/data quality)
• Conducted surveys, interviews, and JRP, JAR and JAD sessions and translated them into system Requirements. Suggested measures and recommendations to improve the current application performance of the system.
• Assisted the team members to develop Service Oriented Architecture (SOA), and data warehouse system (EDW) to utilize data mining for data analysis.
• Responsible for preparing Business Requirement Document (BRD), Functional Requirement Document (FRD) and then translating into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
• Facilitated various brainstorming, requirement gathering sessions, and provided training on HIPAA Compliance, HIPAA Standard transactions and current version of X12 HIPAA 4010A1.
• Assisted in the development of project definitions, project scope, cost/benefit and risk analysis, work plans, daily and weekly progress reports, and presentations.
• Managed requirements traceability information and tracked requirements status throughout the project. Also managed changes to baseline requirements through effective application of change control processes and change management tools.
• Proposed and came up with the RAID document to identify the Risks, Assumptions, Issues and Dependencies involved with every tasks assigned.

Environment: RUP, SharePoint, Synon/2E, COBOL, IBM AS/400, CICS, Citrix, Cognos 8, DB2, SAP R/3 FICO, Microsoft SQL Server 2008, T-SQL, SSIS, SSRS, SSAS, MS Excel, MS Word, MS Access, MS Project, MS Visio, ERWIN, Data Stage, OiM (Oracle Identity Manager), Oracle, PL/SQL, PC Media, Oracle BI Enterprise Edition 10g, CAs ALL Fusion Harvest, EDIFECS, HP Quality Center, Velocedi/Claredi, EDI, XML, DIAMOND, COSMOS, FACETS, LOGISTICARE, Rational Rose.

Sr. Technical Business System Analyst

Responsibilities:-

• Played key role in System Development Life Cycle Process consisting of Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
• Involved in the process methodology of analyzing, developing and gathering technical requirements in a P&C insurance setting.
• Performed complete production support for the Microstrategy Environment, maintaining I server, weekly reboots of the I server etc. Responsible for maintaining the Microstrategy Web Servers.
• Designed and documented web-based interface GUI/UI screens for various legacy systems including the HUB 1.0 and HUB 2.0 applications.
• Created source table definitions in the DataStage Repository by studying the data sources by importing the data from Mainframe.
• Translated Business requirements, business rules and business criteria to system specifications and system requirements thereby preparing SRS (System Requirement Specifications) and PRS (Performance Requirement Specifications).
• Developed a Master data model (MDM) using ERWIN. Also designed the infrastructure for usage of the MDM by different applications during the elaboration phase.
• Participated in the Master Data Management (MDM) effort, provided technical advice and support toward the development of strategic and tactical plans for client master data management strategy, data inventories, data governance, data management, storage, and distribution alternatives in support of client MDM strategy.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Worked with systems area to translate business needs into system requirements.
• Was responsible for identifying and documenting business rules and creating detailed Use Cases, Use Case models, Use Case diagrams and Object Oriented Analysis and Designs (OOAD) using UML (Unified Modeling Language).
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.

Environment: RUP, GAD (Gap Analysis Document), MS Visio, Windows Professional, MS Office Suite, UAT, MS Outlook, Rational tools, ORACLE SQL Server Developer, Teradata, DB2, Java, MicroStrategy 9/8.1 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Informatica Powercenter, Bugzilla, Snagit, Adobe Acrobat Professional, HP Quality Center, CA ERwin Data Modeler, MagicDraw UML.

Sr. Technical System Analyst

Responsibilities:-

• Worked closely with PM to coordinate daily activities between Applications Development and Master Database Management teams.
• Collected and studied the Meta data about the Master data for MDM and the transactional data.
• Assisted project manager with the development of project schedules and prepared the reports that are possible with the existing data.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle.
• Created users, roles & privileges in the Microstrategy Environment. Responsible for setting the Microstrategy Environment for any Proto type projects.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volume data
• Documented existing and proposed process flow, analyzed current and target system, and conducted GAP analysis from the reporting requirements to the existing data in ODS.
• Gathered all the requirements from the stakeholders based on the project scope and documented it in RequisitePro.
• Conducted interviews with various business users and Subject Matter Experts (SMEs) to collect Requirements and business process information, using Requisite Pro exercised all the different types of views in Requisite Pro Attribute matrix.
• Organized and Scheduled user interviews, user meetings, group meetings, and JAD sessions and populated complete User Requirements Document (URD) for sign off.
• Responsible for improving data quality and for designing or presenting conclusions gained from analyzing data using Microsoft Excel as statistical tool.
• Prepared detailed design documents to translate business process effectively for developers and product managers using MS Visio and helped realize Use Case Scenarios.
• Identified data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process using Informatica.
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.
• Analyzed research on operational procedures and methods and recommended changes for improvement, with an emphasis on automation and efficiency.
• Tested the BI reports and done the user acceptances.

Environment: RUP, Requisite Pro, Data Stage, Cognos, MicroStrategy 8.0.3/8.1(Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Rational Tools, MS Project, MS Visio, Microsoft SQL Server 2008, T-SQL, SSIS, SSRS, SSAS, Crystal Reports XI, ERWIN.

Lead Technical System Analyst

Responsibilities:-

• Gathered the business requirements from the managers through JAD sessions, formal interviews and surveys and worked extensively with the users and with different levels of management to identify requirements, business events to develop functional specifications.
• Analyzed the AS-IS and TO-BE processes to understand the key findings, the short term considerations, the long term considerations and its benefits.
• Using MicroStrategy Agent (Templates, Filters, Metrics) to generate advanced reports in grid, graph, and SQL mode, consisting of data analysis by combining a template with filters. The end users were able to generate ad hoc report by drilling up, down, within and across dimension or anywhere.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Documented the business requirements in BRD, prepared data models, ERDs and process models, DFDs.
• Drafted project charter and devised a Work Breakdown Structure by decomposing the project deliverables.
• Created MicroStrategy Filters, Prompts, Drill Maps, Transformations, Documents, Facts, Attributes, Hierarchies etc. for Developing Project.
• Prepared the test cases, activity diagrams and sequence diagrams (ER – Dimensional models).
• Wrote Use cases to demonstrate the business requirements and assisted in developing business models.
• Assisted in the analysis and design of applications using OOAD techniques, UML and Design Patterns.
• Documented the Functional specifications in the FSD and created the project templates for Use case specification, Change request form, functional specification documents and Business Requirement documents and Defect status form.
• Prepared the ETL specifications and helped the ETL development using Data stage.
• Assisted in ETL testing and in developing the Business Flow Diagram using MS Visio.
• Worked with the design team to assist them extensively in designing the database.

Environment: Data Stage, Cognos 8, MS Project, MS Word, MS Excel, MS Visio, MS Office Suite, Microstrategy7.5/8.0 (Desktop, Administrator, Intelligence Server, Web), Rational Rose, Windows Vista, ERWIN, MS SQL Server, PL/SQL.

Technical System Analyst

Responsibilities:-

• Participated in implementing the XP (extreme programming) method and continuous interaction with the developers.
• Concentrated on Cash Management to attire investors both globally and Asia Pacific with the vendors.
• Collaborated with the development team to enforce the implementation of requirements throughout the entire coding cycle and managed change request using Rational Clear Quest.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Documented requirements as in SRS and functional specifications, UML models with Visio.
• Developed Use Cases to capture different scenarios for each functional group.
• Developed test plans, test cases along with the QA team.
• Reviewed the use cases, functions and features list, map the requirements to design, and update the Requirements Traceability Matrix (RTM).
• Documented activity, deployment and workflow diagrams in Visio.

Environment: Windows2000, Rational Rose, Agile, Rational Clear Quest, Oracle, and Microsoft Project 2000, MS Office Package, MS Outlook.