PROFESSIONAL SUMMARY:

• Over 11 years of experience as a Sr. Technical Business System Analyst (Technical BSA) / IT Manager in Information Technology industry with focus on Data Analysis, Data Mapping & Data Modeling, Business Process Improvement; 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.
• 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 e-commerce architecture; ATG framework its functional limitations and the platform features, application capabilities, etc. including industry wide terminologies like B2B, B2C, C2B, C2C with its e-commerce categories and strong knowledge of PCI DSS standards.
• 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.
• Proficiency in elaborating the Use cases, writing Test cases and preparing Requirement Traceability Matrices (RTM).
• 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

Lead Technical Business Analyst / Technical Project Manager

Responsibilities:

• Authored, owned, managed and maintained 1Pagers to give brief overview of the products / services to be 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.
• 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.
• Defined, designed and elicited core business objectives in order to deliver qualitative product, program and project with optimum utilization and the most efficient use of enterprise resources.
• 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.
• 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.
• Strong knowledge of Unix commands and running those Unix commands in various boxes to validate server logs.
• Effectively and lucidly communicated project risks, issues (especially launch gating), dependencies, progress status, launches, concerns and retrospectives in structured RAID template designed and choreographed by me.

Environment: Activiti BPM, XML Spy, RestFUL API, SoapUI, HP Quality Center ALM (Application Lifecycle Management) 12.20 & 12.01, Quest Toad For Oracle 12.0 (64bit), Programmer’s Notepad, PuTTY.exe, JIRA, CA’s Clarity PPM, Cloudsite SharePoint, Confluence document repository, APEX Search Client RealTime application, DB2 AppDevClient 9.7, MS Office Project Standard 2007, MS Office Standard 2007, MS Office Visio Standard, Open Source XML tools, Oracle Client 11g R 2 11.2.0.1.0, Techsmith’s SnagIT Editor 12, SQL Developer 4.1.3.

Confidential, Whitehouse Station, NJ

Lead Technical Business System Analyst / Project Architect

Responsibilities:

• 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.
• Created and documented 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.
• 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.
• 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.

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.

Confidential, Union, NJ

Lead Technical Business System Analyst / Technical Product Manager

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.
• 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”.
• 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.

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; Oracle Endeca; UNIX; Java; .Net.

Confidential, Baltimore, MD

Lead Technical Business System Analyst / BI Reporting Lead

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.
• 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.
• 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.

Environment: MMIS / CMS Regulations, HIPAA Privacy, Wire Framing, UML, SCRUM, eCAMS & ProviderOne ( Confidential 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, SharePoint, Service Oriented Architecture (SOA), RUP (For MMIS Development), Informatica PowerCenter, Enterprise Architect 10 UML (SPARX System’s EA Visual Modeling Platform).

Confidential, Franklin Lakes, NJ

Lead 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.
• 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.
• 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 Office Suite, 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.

Confidential, Richardson, TX

Lead Technical Business 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).
• 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)
• 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.
• Developed project definitions, project scope, cost/benefit and risk analysis, work plans, daily and weekly progress reports, and presentations.

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.

Confidential, Greensboro, NC

Technical System Analyst

Responsibilities:

• 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).
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• 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, MS Outlook, Rational tools, ORACLE SQL Server Developer, Teradata, DB2, Informatica Powercenter, Bugzilla, Snagit, Adobe Acrobat Professional, HP Quality Center, CA ERwin Data Modeler, MagicDraw UML.

Confidential, New York, NY

Technical Business Analyst/Datastage Professional

Responsibilities:

• 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.
• 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.
• Analyzed research on operational procedures and methods and recommended changes for improvement, with an emphasis on automation and efficiency.

Environment: RUP, Requisite Pro, Data Stage, Cognos, Rational Tools, MS Project, MS Visio, Microsoft SQL Server 2008, T-SQL, SSIS, SSRS, SSAS, Crystal Reports XI, ERWIN.

Confidential, Houston, TX

Technical Business 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.
• 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.
• Performed analysis and design of applications using OOAD techniques, UML and Design Patterns.

Environment: Data Stage, Cognos 8, MS Project, MS Word, MS Excel, MS Visio, MS Office Suite, Rational Rose, Windows Vista, ERWIN, MS SQL Server, PL/SQL.

Confidential

Technical Business Analyst

Responsibilities:

• Participated in implementing the XP (extreme programming) method and continuous interaction with the developers.
• 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.
• Reviewed the use cases, functions and features list, map the requirements to design, and update the Requirements Traceability Matrix (RTM).

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