SUMMARY

• Senior Business Analyst/Data Analyst with 8+ years of experience in recording, interpreting and analyzing data for driving business solutions.
• Business Analyst with in - depth knowledge of databases, data warehousing concepts and in the field of Functional Business Analysis with expertise in End to End SDLC in Waterfall, Agile methodology (Sprint/Scrum) based projects.
• Proficient in Functional analysis, Business analysis, Requirement Elicitation, Requirement Analysis, Requirement Management and Communication, Impact analysis, As Is- To Be study, Gap analysis and JAD sessions.
• Experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Efficient in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Experience in diversified business domains (Insurance, Property& Casualty, Banking & Finance, Health care) with heterogeneous relational databases such as Oracle, Microsoft SQL Server.
• Proficient with Data Extraction, Transforming and Loading (ETL) using various tools such as Informatica Power Center.
• Skilled in creating and maintaining Functional Specification Documents (FSD), Use Cases, Data field mapping, Process Flow mapping, Requirement Traceability Matrix, performing Impact Assessment and providing Effort estimates.
• Assisted business in preparing BRD (Business Requirement Document) and FRD (Functional Requirement Document).
• Experience on source to target mapping, gathering business requirements from business/user, creating source to target mapping document, creating process flows, and DFD.
• Experience in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis.
• Expertise in writing SQL queries using Toad and Query Optimization.
• Master in creating Oracle PL/SQL Functions, Stored Procedures and Triggers.
• Excellent in Data warehousing concepts like OLAP, OLTP, Slowly Changing Dimension (SCD) types (I, II &III) methodologies, Incremental Loads and Change Data Capture (CDC).
• Expertise in creating Use case diagrams, Use case specifications, Dataflow diagrams using Rational Rose, IBM Rational Software Architect, MS Visio and wireframes using Balsamic, Pencil.
• Experience in campaign management tool - Zeta hub and content management tool- Drupal.
• Scrum Events: Backlog Grooming, Story- Point Estimation
• Agile Scrum Ceremonies: Daily Scrum Call, Sprint Planning, Sprint Review, Sprint Retrospective Meeting.
• Scrum Artifacts: Product Backlog, Sprint Backlog, Product Increment and Burn-down Chart.
• Hands on Experience in preparing Test cases, Test plan, Product Backlog, Release plan documents.
• Proficient in working as lead from both onsite and offshore.
• Experienced in team handling, reporting with excellent track record of delivering within stringent timelines.
• Excellent communication, analytical, goal oriented approach, problem identification and solving skills.

TECHNICAL SKILLS

ETL Tools: Informatica- PowerCenterv 9.x (Mapping Designer, Workflow Manager, Repository Manager, Workflow Monitor)

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Conceptual, LogicalData Physical Modeling, SCD type I, II, III, Erwin r7.2/3/4, Visio

RDBMS: Oracle 11g/10g/9i/8i, Microsoft SQL Server

Web Tools: HTML, XML, CSS

Wireframes: Balsamic, Pencil

UML diagrams: Use case diagrams, Rational Rose, Rational Software Architect, Smart draw, MS Visio

Scripting Languages: UNIX Shell Scripting, Auto sys JIL Scripting

Operating Systems: Windows XP/7/8/10, UNIX, Mac OSX.

Office Applications: MS Office (Word, Excel, Visio, PowerPoint, Project, Outlook)

Programming Languages: SQL, PL/SQL, T-SQL

Other tools & utilities: SQL* Plus, TOAD, Auto Sys, SQL Developer, Putty, Remedy, Service now, JIRA, Zeta hub, Drupal, Rally

Business Intelligence Tools: Tableau, Cognos

Project Methodology: Waterfall, Agile, Hybrid Client Specific

Domain: Insurance, Property & Casualty, Banking & Finance, E-Commerce, Health care

PROFESSIONAL EXPERIENCE

Confidential, CT

Senior Business Analyst/ Data Analyst

Responsibilities:

• Gathered new requirements frombusinessmatter experts and communicated the same to external vendors.
• Performeddataprofiling anddatamapping to map various sourcedatasystems to the new Basel database.
• PerformedDataAnalysis andDataValidation by writing complex SQL queries using Toad for Oracle Utilized Quality Center to record, track, update or close any defects related tobusinessrequirements ordataquality.
• Assisted Test team in drafting test strategies and test plans to verify accurately any functionality issues and successful system integration.
• Wrote and maintainedBusinessRequirements Documents (BRD) and Functional Requirements Documents (FRD) defining new systems operations for the project using Rational Requisite Pro.
• Created Use cases, Use Case Diagram,Businessflow diagram, Work and Navigation flow diagram using Unified modeling language (UML).
• Conducted many informal sessions to develop an architectural solution that the application meets thebusinessrequirements, resolved open issues, and change requests.
• Linkedbusinessprocesses to organizational objectives and perform critical path analysis.
• Documented alldatamapping and transformation processes in the Functional Design documents based on thebusinessrequirements.
• Created Technical specifications documents based on the functional design document for the ETL coding to build theDataMart.
• PerformedDataProfiling andDataQuality; Createddatatrace map anddataquality mapping documents.
• Used Erwin fordatamodeling and expertise in Dimensional modeling, cubes, Fact tables, Star schema, and Snow Flake schema for OLAP and OLTP systems.
• Involved inDataExtraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.
• Experience with Metadata tables, Data dictionary and Data Glossary.
• Worked on daily basis with leadDataWarehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
• Hands on experience in Autosys Scheduling tool.
• Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF.
• Responsible for making the report available for scheduling or viewing on demand.
• Worked with Technical Experts to Improve Report Performance and performed System testing.
• Recorded project changes on a weekly basis using changedatato update the project plan and provide up-to-date information for project status reporting using MS Visual Source Safe.
• Businessteam of four FSP team in bringing aboutbusinessrequirements, architectural specifications, corporate priorities, functional specifications and screen mockups/definitions.
• Participated in the analysis and definition of efficient, cost effective solutions, Gap Analysis,Business Impact Analysis Evaluated and reengineered existing systems, tools, methodologies, Standardization of processes (SQA, Test processes, and Configuration management).
• Organized the QualityAnalyst(QA) walk through to explain proposed changes.

Environment: Oracle 11g, SQL Server 2008, Windows XP, Microsoft Project 2000, Informatica Power Center 9.5, HTML, Business Objects, Erwin, MS Excel, Balsamic, Toad, Autosys, SharePoint, PowerPoint, MS Visio and MS Outlook.

Confidential, Wayne, NJ

Business Analyst

Responsibilities:

• Responsible for taking requirements frombusinessusers, understandingBusinessNeeds by scheduling meeting at regular basis.
• Used Agile Methodology in collecting requirements and sending them for development, which was carried using an iterative approach.
• Involved in creating the Project templates, Use case specifications, Change request form, functional specification documents, andBusinessRequirement documents.
• Worked with cross-functional teams for building use cases, demonstrating thebusiness requirements, developingbusinessmodels.
• Designed and developedbusinessflow diagrams, activity diagrams, sequence diagrams, object oriented models using MS Visio.
• Conducted Model reviews with project team members; Publish and communicate models to various IT andbusiness-based teams.
• Conducted data analysis to provide all facets ofBusinessPerformance and produce added value reporting to senior management.
• Conducted data mapping to collect and show relations between data from dashboard function to the ODS table on PeopleSoft database, represented this mapping using ERDs, and Process Modeling DFD's on MS Visio.
• Proactively prepared scenario analysis of different product mix and identified the areas of improvement and solutions to meet the customer needs.
• Organized JAD sessions to flush out requirements, performed Use Case and work flow analysis, outlinedbusinessrules, and developed domain object models.
• Utilized Management Information Software (MIS) and Financial Accounting Software (FAS) that ensured daily balancing of accounts and vendor reconciliation.
• Assisted in the Implementation of Case management automation (on Case Object) to track and solve customer's issues.
• Built total Revenue Cycle Management (RCM) processes to improve the revenues.
• Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Conducted performance tuning to primarily focus on writing efficient SQL Queries to generate reports.
• Worked with the design team to assist them extensively in designing the database.
• DocumentedBusinessand Test Plans based on gathered requirements; involved in executing existing test scripts, writing and updating new test scripts.
• Designed, developed, and maintained variousbusinessunit reports by using, SQL, and MS Excel.
• Created SQL Assistant scripts, temp tables to be compatible for the monthly segmentation and migrated tables.
• Produced daily, weekly and monthly reports, on-time and accurate, on process andbusiness performance to various stakeholders.

Environment: MS Visio, MS Project, Reporting tools, Gap Analysis, Case Management, Java, HTML, CSS, RCM, SQL, MS Office, Agile, Oracle.

Confidential, Bloomfield, CT

Tech Lead/Business Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initialdatamodels that containBusinessRequirement Documents and supporting a document that contains the essentialbusiness elements and detailed definitions.
• Gathered and understoodbusinessrequirements and transformed them intodatawarehousing solutions for Group Health Insurance Customerdata.
• Worked alongside Users/SMEs (Subject Matter Experts) to recommend and gather low-levelbusinessprocesses and convert them into technical requirements for the development team, at various stages of the SDLC (System Development Life Cycle).
• AnalyzedBusinessRequirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining theDataProcess Models.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD, Visio andBusinessProcess Modeling.
• Collaborated with Quality AssuranceAnalystin Automated and Manual Black box testing.
• Responsible for architecting integrated HIPAA, Medicare solutions, and having sound Knowledge ofdataarchitecture concepts,datawarehouse and data marts.
• Strong skills at SPSS, Microsoft SQL server and Excel.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate thedatabetween EnterpriseDataWarehousing andDataMart Staging Tables.
• Coordinateddatamapping, testing and validation strategies of 837 and 277 transactions to ensure adherence to HIPPA and State regulations.
• Created/Revieweddataflow diagram to illustrate wheredataoriginates and howdataflows within the EnterpriseDatawarehouse (EDW).
• Reviewed thedatamodel and reporting requirements for Cognos Reports with theData warehouse/ETL and Reporting team.
• Worked on HIPAA compliance, ElectronicDataInterchange (EDI), Medicare, ANSI x12 formats and implementation of HIPAA code sets, ICD-9, ICD 10.
• Wrote Test cases for EnterpriseDataWarehousing (EDW) Tables andDataMart Staging Tables.
• Involved inDatamapping specifications to create and execute detailed system test plans.
• Thedata mapping specifies whatdatawill be extracted from an internaldatawarehouse, transformed and sent to an external entity.

Environment: Oracle, PL/SQL, MS-Project, MS-Office Suite, MS Visio, Rational Rose, Clear Quest, MS Visual Source Safe, HPQC.

Confidential, Long Grove, IL

Business Analyst/ Tech Lead

Responsibilities:

• Involved in meetings with stake holders and Product Owners to understand the Business Requirements.
• Facilitated Agile Scrum Ceremonies including Daily Scrum Call, Sprint Planning, Sprint Review and Sprint Retrospective Meeting.
• Created Scrum Artifacts including Product Backlog, Sprint Backlog, Product Increment and Burn-down Chart.
• Involved in Scrum Events like Backlog Grooming, Story- Point Estimation.
• Experience in working with campaign management tool - Zeta hub.
• Worked on eBusiness and eMarketing data collection, design, implementation and reporting.
• Worked on E-commerce tools such as Paid search engine listing development, optimization, administration and ROI tracking (Ad Words, Overture & ePilot) and SEO strategy development.
• Planned and worked with the online marketing team to develop Direct-to-customer initiatives.
• Worked on Email, Search Engine Marketing, Display Advertising, Webcasting, Social Media and other campaigns with extensive knowledge on CPC, CPM and CPA.
• Actively interacted with other corporate departments, including executive, shipping, legal and information services as well as vendor relationships.
• Involved in leverage marketing advanced analytics, demographic enhancements and customized statistic models.
• Lead JAR sessions and JAD sessions with end user community ensuring that the software addressed allbusinessneeds and also involved in Rapid Application Development sessions (RAD).
• Identifying & Managing risks, Resource analysis, Cost analysis, Post project analysis & coordination among cross-functional teams & follow-up with clients for settlement of project based issues.
• Knowledge on Content Management Systems- Drupal.
• Experience in E-R Diagrams for the logical Database Model, created the physical DataModel with Erwin DataModeler.
• Involved in Data analysis,Data discrepancy reduction in the source and target schemas.
• Extensively wrote SQL Queries (Sub queries, correlated sub queries and Join conditions) for DataAccuracy, Data Analysis, Data Extraction and Data Hygiene.
• Created Data mapping document for ETL process for Informatica Power Center 9.5.
• Performed User Acceptance Testing (UAT) and analyzed the tables once the imports were done.
• TOAD, SQL Developer tools were used to develop programs for executing the queries.
• Worked with Database team in maintaining ETL(Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Created Wireframe mockups using Balsamic.
• Created Use Cases, and developed detailed Use Case Diagrams and Sequence diagrams describing how actions are to be carried out using MS Visio.
• Documented and maintained Requirements Traceability Matrix to ensure all requirements are traceable from top to bottom.
• Utilized existing internal processes and improved those same processes for software problem identification, escalation, and resolution and facilitated project team meetings. Continually reviewed and revised project processes to ensure accurate and timely results.

Environment: Oracle 11g, Windows XP, Microsoft Project 2000, Informatica Power Center 9.5, HTML, XML, JSON, PHP, Business Objects, Erwin, MS Excel, Balsamic, Toad, Autosys, JIRA, Zeta hub, Drupal, SharePoint 2010, Power Point, MS Visio and MS Outlook, Google Analytics, E-Commerce, Shopping cart, E-payment.

Confidential, NY

PL/SQL Developer

Responsibilities:

• Involved in the meetings with business analysts and DBAs to gather and understand the business requirements and process flow details in order to plan the loading to DWH.
• Involved in meetings with Data modeling team for Dimensional modeling in Erwin.
• Expertise in Oracle SQL, PL/SQL, Toad, Informatica.
• Hands on experience in writing SQL queries and Query Optimization.
• Master in creating Oracle PL/SQL Functions, Stored Procedures and Triggers.
• Experience in using Analytical functions like Rank, Dense Rank, Row number.
• Proficient in Designing Informatica Mappings/sessions/workflows based on the requirements.
• Skilled in transformations like Filter/Sequence Generator, Router, Update Strategy, Lookup/Joiner.
• Expert in developing mappings, mapplets, sessions, worklets, workflows.
• Expertise in Designed Metadata Tables.
• Hands on experience in implementing Slowly Changing dimension types (I, II &III) methodologies, Incremental Loads and Change Data Capture (CDC).
• Generated DDL scripts and Created and modified database objects such as tables, views, functions, synonyms, indexes, packages, stored procedures.
• Worked extensively with the release team to plan and execute the releases.
• Responsible for migrating projects between multiple environments (Dev, QA, UAT and Prod).
• Used the advanced features and implemented various techniques at Informatica level and database level to improve the performance of the applications

Environment: Informatica Power Center (Mapping Designer, Workflow Manager, Repository Manager, Workflow Monitor), Erwin, Oracle SQL, PL/SQL, Autosys