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.
• Well Knowledgeable in API modeling language and actively worked on Swagger to provide the detail for development.
• Participate in compliance/ technical meeting applicable to API’s
• Well familiar with REST and SOAP API web services.
• 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.