SUMMARY

• In depth knowledge of SDLC methodologies like AGILE, RUP, SCRUM and Waterfall.
• Strong knowledge in developing project plan and estimating project timeline.
• Expert in business process analysis/modelling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
• Efficient in writing various BRD, Technical Specification document, Use Case and Functional Specifications. Creating diagrams to extract business process and workflows design using UML, MS Visio and Rational tool.
• Results - oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
• Helping development and quality assurance teams in understanding the requirements.
• Perform Gap Analysis to check the compatibility of the existing system infrastructure with new business requirements along with Risk analysis-risk engineering.
• Excellent Knowledge on HL7, Membership, Billing, Claims Payment Processing in relation to EDI 4010, 5010 X12, ICD-9 ICD-10, codes 834, 837,835, and 270, 271.
• Worked on ad-hoc and canned reports in multiple projects to provide analysis and end results.
• Worked closely with Project manager on Project planning, scope diffing along with organizing meetings and supporting during UAT.
• Strong expertise in Health Insurance Claim process, Medicare and insurance and well versed with HIPAA, claim adjustments and processing from point of entry to finalize it.
• Well versed with client server environment and tools like SQL*Loader, UNIX shell scripts and TOAD
• In-depth knowledge data modelling and mapping and used various tools like Erwin and Power designer.
• Extensive experience with databases like Oracle, Teradata, SQL Server, DB2, and MS Access and Data Warehousing concepts and web design and development.
• Proficient in ETL implementation using SQL Server Integration Services ( SSIS ) from source to data warehouse.
• Experience in Designing, Creating and maintaining reports extensively used BI process through My Sql server studio, WEBI reports and Domains (Security, Universe, Document) in Business Objects.
• Strong knowledge in Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions.
• Well versed knowledge of big data tool as Hadoop and virtualization tool Denodo.
• Hard working, positive thinking, self starter with a strong goal orientation and good communication skills.
• Ability to inculcate new relevant skills with ease in a time sensitive frame.

TECHNICAL SKILLS

Programming Languages: C, C++, C#, VC++, VB, VB.NET, C#.NET, ASP.NET, XML, Java, SQL

Scripting languages: VB script, JavaScript

Development Methodologies: AGILE, RUP, Waterfall

Databases: MySQL, SQL Server, Oracle, Teradata, DB2, SQL Developer

Business/ Automation Tools: MS Visio, Rational tools; RequisitePro

Bug Tracking Tools: HPQC, Jira, Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop, Rally

Reporting Tools: Crystal Reports, MSBI; SQL Server Reports (SSRS ), Business Objects, Cognos

Data warehousing/other Tools: Informatica, Erwin, Hadoop, Denodo, Sybase PD

PROFESSIONAL EXPERIENCE

Confidential, San Leandro CA

Sr. Business-System Analyst

Responsibilities:

• Gather and review requirements with business and external team.
• Work as Lead cum Product Owner and participate in Planning, effort Estimation and Monitoring.
• Analysis, design, programs, documents and implements new systems and/or software programs.
• Prepare Sequence, Process flow diagram by using Visio Enterprise architect using Gliffy Diagram on Confluence.
• Define Epic and write user stories for different functionality and maintain Jira board.
• Define Acceptance criteria and Write User Acceptance Testing (UAT) document.
• Prepare Solution Design document and maintain them on Project confluence page.
• Closely work with other functional project teams on development and business changes.
• Identify and define error codes mapping document for development when error occurs during process and convert those status into customer facing language.
• Organize meetings with different teams to discuss functionality and development changes.
• Host daily stand-Up scrum meetings and refinement sessions along with backlog grooming.
• Works with UI development team to understand and develop the functionality as per requirement for operational search and reporting of wells on Payments.
• Define and validate the functionality development of various API’s in DevTest Virtual tool on dummy data.
• Review Business Criticality on MVP changes post MVP development.
• Prepare weekly project and team status reports and present to business during progress meeting estimation.
• Extensively use the Visio, Confluence, Excel for business representation to show the model structure.

Environment: Agile-Hybrid process, MS- Office Suit, VISIO, Enterprise Architect SQL Developer, Windows 10, Kafka host/FTP, SQL Server, SharePoint, Confluence, Jira Github and DevTest(LISA).

Confidential, Atlanta GA

Sr. Data Security-System Analyst/Data Analyst

Responsibilities:

• Participated in Project Planning, Effort Estimation & Monitoring for CERTIFI project.
• Identified requirements, perform feasibility study to identify the gaps and risk, design requirement documents for specification using MS Word and Rational tool.
• Extensively used MS Visio to develop the workflow of a given scenario in programming sequence.
• Acted as subject matter expert and liaison with other areas within RBAC on deployment.
• Defined deployment process to carry out the development and validation of assignation task.
• Reviewed business criticality and work on data storage structures, data mining, and data cleansing Identify and interpret trends or patterns in composite data sets.
• Cleansed, mapped and transformed client data to the desire schema and data standards.
• Worked on test design docs for new enhancements and Hotfixes for the existing system where needed.
• Closely worked with the web Development and testing team to review and resolve the issues of UI application.
• Defined Test Methodology to carry out the development and deployment SME validation process.
• Involved proactively in E2E testing with customer completely from onsite counterpart.
• Developed or modified procedures that solve complex business problems with due consideration for hardware/software capacity and limitations, operating times and desired result.
• Aiding in identifying possible solutions data security using statistical techniques and provide ongoing reports.
• Performed validation process after Role Assignment is prompt in Production.
• Provided support for Analytics Processes monitoring and troubleshooting to end users.
• System design, deployment, configuration and support Windows and Mac OSx environments.
• Evaluated system design specifications and produce technical documentation for new and existing specifications and Performs complex conceptual analysis.
• Wrote queries in SQL Developer to retrieve and refine the data for reporting purposes and for logical model.
• Extensively used the Pivot charts in Excel for business representation to show the model structure.
• Run Scripts to generate the reports through prod servers to review data issues and resolve the issues.

Environment: Agile-Hybrid process, SQL Developer, SQL Assistant 15.0, Windows 10, Passport host/FTP, SQL Server, SharePoint, MongoDB, CERTIFI, MS. VISIO, MS- Office Suits, Putty.

Confidential, Bothell, WA

Sr. Business/Data Analyst

Responsibilities:

• Worked on multiple tracks as Finance, Marketing to develop and support transforming BI operating model.
• Dynamically worked in Hybrid and Agile Methodology from Sprint/backlog planning till retrospective.
• Worked with Portfolio Manager and Business groups to document and create Business & Technical Requirement Documents, Use-Cases, Wireframes, Scope Tracking and Traceability Matrix spreadsheets.
• Actively participated in Sprint meetings to work on the selected User Stories and aligned them on Rally tool.
• Created Change Request document and Participated in Change Control Board (CCB) meetings to present the CR for approval of different requirements.
• Led the SSA’s team to complete the documentation precisely for further development by Dev. team.
• Played a key role in mapping meetings with SME’s to complete and resolve the code logics, queries and get the correct mapping to design and deploy.
• Developed Source Mapping Documents to capture all the changes with logics and status.
• Closely worked with DA team on the S2TM development and Design in Power Designer along with review and finalize the S2TM/designing for Dev. team to deploy Hive Jobs.
• Assisted cross functional project teams with data analysis, data mining and data profiling as needed.
• Ensured developmental activities, changes are consistent and implemented properly in the system.
• Provided solutions to resolve problems related to EDI transactions when occurred as prioritized.
• Helped the team on creating Teradata views for reporting or further processing.
• Worked with CIS data Protection team on the data security and define the process to establish the CIS team approval mechanism.
• Prepared ETL mapping documents explaining complete mapping logic.
• Prepared unit test document and performed unit and regression testing.
• Provided QA/UAT support while code promotion and worked with QA’s to resolve any defects if found.
• Functioned with Data Warehouse team to understand repository objects that support the business requirement and process. Used sandboxes to explore data.
• Participated in Ingestion process to resolve the Ingestion issues and get the files on time.
• Closely worked with Hadoop team to delivered Pre-Prep and Prep jobs and to test the Mapping and identify the gaps and to understand the consequences.
• Used Putty to manage the files on different Servers and Informatica tool to get the results of each source table to review the data.

Environment: Agile process, Hadoop, SQL Developer, Teradata SQL Assistant 15.0, Windows 7, Power Designer, SQL Server, Denodo 5.5, MS. VISIO, MS- Office Suits, Putty, Rally.

Confidential

Sr. Business / Data Analyst

Responsibilities:

• Involved in requirement gathering and was generating the Standards and templates for the data captured.
• Involved in project management using MS Project and created detailed functional specifications documents for development team.
• Worked closely with the Data Warehouse team to understand repository objects that support the business requirement and process.
• Involved in developing HIPAA EDI Transmissions. Work includes complete business cycle management and hands-on production as well and create EDI Testing process, documentation, and performance matrices.
• Worked and tested HL7 Message Validation and sending of ADT Messages like ADT A02.
• Ensured the changes are tested and fulfill the requirement as requested by State.
• Worked on Different HL7 interface messages and facilitate mapping along with migration from clients existing epic interface to CHIA Sends like Mirth.
• Worked with Different vendors to improve and support the EHR software, create document for modifications
• Monitored and resolved the bottlenecks in EDW for smoother process.
• Provided clear and concise documentation regarding requirements management plans, functional requirements, supplemental requirement.
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server environment or through SQL adapter.
• Worked with development team to integrate the data through Datastage from mainframes and oracle systems to do ETL processing.
• Written SQL queries to verify data quality and the code logics implemented as requested.
• Closely work with SAS team to understand and convert the code with ODI developer into SQL..
• Analyzed multiple test scenarios and tested different files in WinSql to see the changes met the requirement.
• Worked closely with different Managers to develop the Specification Documents for capturing the process.
• Worked closely with Development team to understand the consequences.
• Participated to transform the data from one server to other by using SSIS.
• Worked with BI to create reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Worked on Vermont data in ODI with Tech and Buss teams on design and logic changes. Along with testing.
• Sent Reports to State through FileZila and Sends + tool of all claim types.
• Worked with Business on TME and REL to sent through CHIA site and manage reports.
• Generated different types of Delimiters files and used Putty to manage the files on different Servers.

Environment: Oracle Data Integration (ODI), Windows 7, SQL Server, MS. VISIO, CSV files, FileZila, Sends+, Datastage, WinSql, MS- Office Suits, Putty.

Confidential

Business Data Analyst

Responsibilities:

• Implemented and integrated hybrid solutions with complete line of traceability for all the artifacts of web development projects.
• Involved in customer segmentation, Portfolio Analysis/Management.
• Organized JAD sessions and gathered requirements, process mapping to find gaps, to integrate various discrete processes sections with developers and business clients.
• Developed Use cases and functional specifications. Provided UML diagrams.
• Involved in development and maintenance of workflow plans and artifacts.
• Interfaced with external contacts to obtain financial data solutions for clients.
• Managed Scope and change throughout the SDLC process of the product.
• Developed Use Case Models using Rational Rose to depict Actor and Use-Cases in various Business processes and identification of Basic/Alternative flows; definition of pre-and post-conditions of the System.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Closely worked with testers to develop Quality Assurance standards and processes to all levels.
• ETL Design/Development through Informatica Power Center 9.5.1 version.
• Created detailed functional specifications for development team.
• Created Artifacts and defined Milestones and iteration plans for Inception and Elaboration phases of SDLC
• Used TestDirector with QA team for writing and testing Positive and Negative Test cases.
• Designed and develop the data dictionary and Meta data of the models and maintain them.
• Coordinated with DBA on data base build and table normalizations and de-normalizations.
• Assisted in developing the forecasting models for various departments.
• Run simulations and provide recommendations on various scenarios by using critical thinking.
• Prepare accurate, timely and insightful monthly variance reporting to partner departments
• Developed triggers, stored procedures, and functions associated with the project using Pl/SQL.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary evolve and change during the project.
• Created Data Models using Power Designer, implementing physical models for databases.
• Used TOAD to connect to the database and ran SQL queries to view data.
• Used Informatica Data Quality Data to analyze and enhance source data through processes called plans by creating in Workbench application.
• Used PowerCenter tool to perform data integration to pull the data from different sources and cleanse it.
• Worked on data mapping of source to target elements performing gap analysis using TERADATA.
• Worked under Agile/Scrum project methodologies to enhance current dimensional models using Power Designer 12.5 to integrate in DWH.
• Worked on data quality and validated business scenarios for a new database.
• Identified database inconsistencies like orphan objects, duplicate objects and coordinating with various teams to decide on the appropriate action to be taken.
• Coordinated in database changes needed for the frontend development team, explained and guided them on the database architecture and objects for effectively accessing the database.
• Worked directly with non-IT business analysts throughout the development cycle, and provide post-implementation support, once developed including investigation of data and report issues identified.
• Maintained change log for each data model. And participated with dev team solve the production issues by debugging the code.

Environment: Rational Requisite, Visio, Win Runner, HPQC, Test Director, J2EE, Excel, MS Project, MS Office, ODBC, VB Script, PL/SQL D HTML, Windows NT/XP, SQL Server/Oracle, MS Access and Informatica PowerCenter .