SUMMARY

• 7 + years of IT experience in the field of Data/Business analysis, ETL Development, Data Modelling, and Data Management.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, Data governance and Metadata Management, Master Data Management and Configuration Management.
• Extensive experience with Business Intelligence, Data Warehousing, ETL processes and BI reporting projects.
• Extensive experience in Business Analysis, Database Analysis, and Data Quality check.
• Extensive experience with writing ETL (Extraction, Transformation and Load) Processes to capture, transform and Load/flow company and enterprise data from various applications to Data Warehouses.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Involved in gathering, analysing, and documenting Reporting requirements from business/Stake holders and applying reporting requirements rules to the datasets within SQL DB, developing ad - hoc reports via reporting tools such as SSRS, Crystal Reports and Tableau and automate the delivery.
• Views and reporting tools like SSRS BIDS, Tableau, Qlik-View, Crystal Reports, and Power Pivot etc.
• Worked on Inventory Reports, Savings Reports, Expense Reports, Usage Reports and designed interactive dashboards with KPIs, sub-reports, Graphs, Scales, Top/bottom usage categories etc.
• Worked on advanced features of MS Excel like VLOOKUP’s, Macros, Pivot Tables, Data Validation
• Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
• Participated in User Acceptance Testing, Verifying Business Processes and Rules being delivered to the users.
• Extensive work in PL/SQL, SQL, SQL*Plus, PRO*C, C, Unix Shell Scripting. ORACLE 7.3 and ORACLE 8i and Oracle 9i Oracle 10g and Oracle 11g in UNIX and Windows NT environments.
• Experience with ETL tool Informatica Power center 7.1.
• Extensive experience with developing, enhancing and maintaining ETL (Extract, Transform, and Load) processes for Data Mart.
• Extensive experience in developing Top down Approach/Bottom up Approach of Data warehouses as well as in developing Data marts, data mining, data mapping, OLTP and OLAP process etc.
• Experience working as Joint Application Development (JAD) facilitator, agile project management and meetings coordinator with excellent interpersonal skills
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Have excellent interpersonal, verbal, and written communication skills.

TECHNICAL SKILLS

Business Skills: Business Requirements, Business Process Analysis & Design, Financial Analysis, Risk Analysis, Requirement Gathering, Use Case Modeling, JAD/JRP Sessions, GAP Analysis & Impact analysis.

Languages: T-SQL, PL SQL, UML, HTML, XML, Java scripts.

Packages: Rational Rose, Enterprise Architect EA, MS Visio, MS Project, MS Share point.

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2

Data warehousing Tools: Informatica, Business Objects, ETL, Erwin

Operating Systems: UNIX, Linux, Windows NT/server/Xp/Seven, MS-DOS.

Office Tools: MS office, MS Visio, MS Project.

Reporting tools: Business Objects, Tableau, Crystal Reports, and SSRS & PowerPivot.

PROFESSIONAL EXPERIENCE

Confidential, Newark, DE

Sr. Business System/Data Analyst

Responsibilities:

• Understood the architecture of existing upstream applications, ODS, data warehouse and data mart, downstream reporting applications and feeds and prepared high level application architecture diagram.
• Created Data Flow Diagrams to represent flow of data from the various upstream Applications and ODS to Data Warehouse, details of various jobs that extracted periodic data from DW and loaded the Data mart and made data available or generated analytical reports, and data feeds sent to downstream reporting applications.
• Designed and implemented a purge process for the DB2 trade data mart to delete operational data from the DB2 data mart and populate it on a TERADATA data warehouse.
• Participated in daily scrum stand-up meetings to provide status for assigned work, raising any issues/ impediments. Wherever needed participate in collaboration meetings for discussion and resolution of issues.
• In absence of Scrum master, at times even played the role of scrum master to take and report daily status from development, QA, BS, Data Modeler and PMO teams.
• Participated in quarterly and monthly release / scrum planning meetings to discuss project backlog stories, story point's estimations and selection of stories for upcoming releases / iterations.
• Created new project stories and couple of minor enhancement stories.
• Interviewed Product owner (PO) and the business SME's and even data experts to solicit and understand requirements and remediate gaps in business requirements.
• Extensively used SQL to create analyse the existing data for better understanding of the requirements.
• Extracted data and performed data manipulation tasks from various sources and developed automated reporting solutions using Teradata, Oracle, Access, Business Objects, and Excel.
• Reporting data model changes and fields; Good Excel Command, Comparing the data using pivot tables
• Conducted JAD sessions between SMEs from different teams to jointly discuss the requirements and define the scope of the assigned project story.
• Analysed business requirements and converted them into System Functional Requirements containing Business Rules and Functional and Non-Functional/ Technical requirements.
• Conducted sessions with Data Modeler for discussing the requirement and creation of logical data base tables design for DW/ DM.
• Develop training material (documents, SharePoint site) to help foster end-user understanding of the technologies available through the Business Intelligence team
• Conducted sessions with key stake holders like Business SME, PO and internal PMO for approvals on functional requirement and logical database design documents.
• For approved stories, worked with Data Modeler to create physical database tables, creation of Source to Target Mappings (STM) for the extraction, transformation and loading strategy for DW and DM for ETL team and report specifications/ layout and data inputs
• Uploaded the above documents to common share point locations and conducted sessions with development, QA and Data Modeler to walk-through the complete requirement, the STM and database to the teams for development and testing.
• Create dashboards and reports utilizing multiple business intelligence tools to provide analysis into operational performance in an effort to make informed decisions.
• All above documents were created using Confidential RPS documentation procedures and templates and maintained for version control in SharePoint Server.
• Maintained requirement traceability between business requirements and functional requirements in system functional document.
• Assisted the SME's in UAT execution and supported QA team for defect tracking and resolution.
• Updated data flow diagrams after successful implementation of the story in production.
• Managed issues and risks by keeping risk and issues log up-to-date.
• Also prepared an SLA/ SLO excel sheet containing contact and escalation details, data flow timings, data input format and type (full or delta extract) for each data input source for D/W, D/M along with the database table names that get populated from the data. Similar sheet was prepared for the data feeds for downstream applications. This sheet provided single point source for production support team for any missing data issues/ escalations.

Environment: Microsoft office, ALM, Requisite Pro, Rational Rose, Agile, PL/SQL, HTML, MS Visio, Rational Clear Quest, Rational Clear Case, UML, RUP

Confidential, Pittsburgh, PA

Business Data Analyst

Responsibilities:

• Created and updated detailed business requirements documents.
• Documented the entire process flow of the system.
• Compared claims in the production region against the test region for discrepancies and then analysed those discrepancies using the available Providers, Members Integration, and Benefits etc. information.
• Used Subscribers Database, Corporate Members Repository (CMR), Benefits Management Database (CPBRE), Corporate Providers Repository (CPR) & Payers information in depth, for discrepancy analysis.
• Worked on data modeling and produced data mapping and data definition documentation for the interface between Epic EMR system and Highmark's in-house system.
• Analysing Worldwide Claims Translations (ICD-9 to ICD-10 conversion) project requirements.
• Used Crosswalk mapping for annual updates of ICD-9
• Worked on Relationship diagrams between tables for building crosswalk between ICD-9 to ICD-10 codes. Also updated the API structure for retrieval of ICD-10 codes for diagnosis as opposed to existing ICD-9 and SNOMED codes.
• Created a PowerPoint presentation for other project teams that explains an entire flow of the processes which are involved in the project.
• Examined the data available in an existing database using SQL queries and collected statistics and information about that data using MS Access and performed Data Mining.
• Analysed and documented requirements for some Web Services projects which involved - using a standardized XML messaging system.
• Created and published Subscribers, Providers and Financial reports.
• Created and published Excel reports using MS Access based Parallel Comparison Tool by using the information provided by the Technical Architecture Team.
• Involved in analysing and documenting the 835 claims payments and remittance advice project which deals the payment from payer to provider.
• Analysed data from all the above repositories by writing complex SQL queries.
• Analysed the discrepancies in various types of claims - like functional, performance, home-host setup, Medicare, RENO payment claims.
• Analysed the claims that route to fatal error location during claims adjudication and reviewed those errors to determine if the error requires a defect.
• Created and published Production Suspension Reports on a regular basis.
• Followed a systematic defect management process that includes analysing the claim, logging a defect in IBM Rational ClearQuest if a defect is required and retesting it after the code fix.
• Involved in one to one interviews with the Project Manager for the possible process improvements on a quarterly basis.
• Conducted and coordinated SME reviews that include one to one interviews with the SMEs.
• Mentored new team members on the use of the Microsoft Access based tool and also to understand the entire claim process cycle.

Environment: SDLC, MS Access, XML, JAVA, SharePoint, MS Excel, MS Word, MS PowerPoint, NASCO, IBM Mainframes, IBM Rational RequisitePro, IBM Rational ClearQuest, IBM Rational Test Manager, SnagIt.

Confidential, Indianapolis, IN

Business System Analyst

Responsibilities:

• Worked with the core team to design business requirement collection approach based on the project scope and SDLC Methodology.
• Designed and developed Project document templates based on SDLC methodology
• Work closely with Business Owners and Stakeholders to outline Business Requirements.
• Work with System analyst and IS teams to understand the flow of data.
• Reviewed and analysed data from various sources.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Facilitate risk management workshops, recording risk and assigning risk for mitigation. Research and resolve system issues and perform application testing as necessary.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Produce metrics reports from data derived from database as necessary for the project.
• Identified gaps and performed gap analysis with respect to CMS requirements
• Created Mapping Documents, Report Mock-ups and modified existing report mock-ups as to CMS requirements and finalized for development
• Coordinated with different agencies in tracking the progress of the software development and resolving the issues and worked with the UI team to create the User Interface Mock-ups to be presented to the Business.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Hands on experience with T-SQL in writing triggers, tables, user defined functions, views, indexes, and relational database models and data integrity.
• Troubleshot the designed jobs using the Datastage Debugger.
• Tuned Datastage transformations and jobs to enhance their performance.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
• Was involved in maintaining and cleaning up of the regression test case database i.e. identifying the redundant or irrelevant test cases and deleting them from the database so that the software certification process is expedited.
• Formulated logical statements of business requirements researched and evaluated alternative solutions and recommend the most efficient solution for system design.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.

Environment: Windows XP, Business Objects, Zachman Framework, MS Excel, Word, Casewise Corporate Modeller, power point, JAVA, SQL, PL/SQL, MySQL, DB2, SAS database

Confidential, Bloomington, IL

Business Analyst

Responsibilities:

• Followed a structured approach for gathering information and business requirements, conduct research, analyse business needs and develop rating requirements to convert existing auto insurance policies to RSPE (Rating Simplification Process Enhancements).
• Served as a liaison between Auto Batch rating team and Actuarial Team regarding premium rate changes, processes and procedures.
• Coordinated and validated functional unit test cases as the rate changes take place, analysing results of the Test cases as required during the life cycle of the rate changes.
• Communicated with the actuarial team for transmitting the rate changes and conduct functional checkouts proprietary mainframe Rumba Host Systems.
• Work on request, incident, and task from End Users, Client and Business Partners, analyse them and provide resolution in timely manner
• Conduct JAD sessions with Business Partners to review and update the rate manual, code manual
• Communicate with the System Analyst to fix in case of defect, bug or program change in the system
• Documented detail state expectations specifications and detailed requirements for rolling out Auto Data Prefill and Customer Underwriting Index Model.
• Documented business rules for eligibility criteria on the company's SharePoint site.
• Performed premium checkout by comparing the agent emails with the issued premium on the Host system.
• Responsible to elicit, analyse, validate, verify, and facilitate business process solutions
• Effectively communicated user acceptance test (UAT) results between users and development team and provided recommendations for Application change requests (ACR).
• Served as the primary point of contact in the product readiness sessions and Release Management status meetings to speak for the various documentation that was compiled over the project's life cycle
• Used MS Project to ensured timely completion of project tasks and deliverables with a high degree of quality by prioritizing tasks appropriately and communicating issues directly with the project manager.
• Reviewed various test cases to calculate rates and premiums.
• Reviewed rate manuals and participated in rate change releases.
• Responsible for Commercial Insurance Standards rating and risk factors for Auto and Garage commercial insurance.
• Worked extensively in Business Analysis, Data Reconciliation and Data Mapping for ETL process

Environment: Requisite Pro, LOTUS Notes, RUMBA Host System, HP Service manager, HP quality center, MS Visio, MS Project, MS Office, Trac, SharePoint, Test Link.