SUMMARY:

• A System Analyst with 6 years of Hands on Experience in Data Analysis, Business Requirements gathering, SDLC with Agile and Waterfall Methodology. Database design and development of Web Based, and Client/Server applications. Extensive experience working on using Rational tools for creating Use Cases, Version Control, and Defect Tracking and Monitoring. Star/ Snowflake Schemas and Data Modeling (Physical/Logical/ER - Diagrams) etc. Able to work independently as well as in a Team Environment. Effective Time Management skills and the consistent ability to meet client deadline.
• Skilled in Analyzing client data to determine Analytics suitability for process improvement.
• Extensive experience working on a distributed Agile team. In depth knowledge of end to end planning project estimation and execution.
• Knowledge of Rational Unified Process (RUP) methodology in all areas of the Software Development life cycle (SDLC) with Waterfall and agile methodology.
• Star/ Snowflake Schemas and Data Modeling (Physical/Logical/ER-Diagrams) etc.
• Extensive experience working on using Rational tools for creating Use Cases, Version Control, and Defect Tracking and Monitoring and used the Rational Unified Process (RUP) methodology in all areas of the Software Development life cycle (SDLC) with Waterfall and agile methodology.
• Experience in testing Business Intelligence reports generated by various BI Tools like Tableau, Cognos Series and Business Objects. Performed data analysis and data profiling using SQL and Informatica Data Quality on various sources systems including Oracle and Teradata SQL Assistant.
• Extensively involved with data quality and data governance solutions including platforms and supporting data processes.
• Industry knowledge on Business Planning Scrum Methodologies, Project Management Technical Support, Data Visualization Project, Planning Project Estimation.
• Hands on experience with using tools & technologies like Greenplum, File net, Informatica Data Quality & RDNG requirement management tool, Business Support System (BSS), BI Content Management System, Word Press, Analytical Skills, Scrum and Agile Methodologies Expertise in analyzing system and functional specifications used cases, Business Requirements and business rules to prepare Test Plans and design Test Cases.
• Substantial experience in Sanity and Smoke Testing of applications before testing effort of UAT and Regression Testing of applications. Well versed with Enhancing and Editing Test Scripts.
• Knowledge with Process Improvement and process flow.
• Performed extensive Backend Testing of the applications using SQL Queries.
• Well known with flow of EDI transaction processing through trading partner to the core database and also know the process for External database for the facets system. Experienced with batch processing system for claim electronic transaction.
• Well known with end to end processing for the Claims, Subscriber/Family and with Providers. Knowledge of production & operations management, value analysis, demand forecasting, risk analysis, SWOT analysis, DMAIC approach.
• Excellent Communication, presentation and interpersonal skills. Exceptional inquisitiveness and ability to learn new concepts.

TECHNICAL SKILLS:

Business Tools: MS Office Suites- Word, Excel, Outlook, Visio, PowerPoint, UML 2.0 (Use Cases, Process Flow/Swim Lane Diagrams, Sequence Diagrams, Activity Diagrams, Business Support System (BSS), Content Management System (CMS).

Operating Systems: Solaris 10/9/8, HP-UX (11.00, 11.11, 11.23, 11.31), RedHat Linux (RHEL 3/4/5/6), IBM AIX 95.1, 5.3), Windows NT 2000/2003

Data Warehousing: Informatica Data Quality 10.1.1, Data Stage 8.x, SSIS

Reporting Tools: Business Objects XIR3, Congo’s 10.2/9.0 Suite, SSAS, SSRS, Micro Strategy.

Testing Tools: ALM, HP Quality Center, Rational Tools, QTP Traceability Matrix, MS Visio, AGILE, QTP, Informatica Data Quality

RDBMS: Oracle 11g/ 10g/9i, MS SQL Server 2012/2008, UDB DB2, Sybase, Teradata15, MS Access.

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Hyperion, Novell NetWare. Teradata SQL Assistant, Quality Center, Rational Clear Quest, Green Plum, File NET, JIRA, Waterfall & Agile Methodology. SharePoint 2010, Contexte, Mainframe.

PROFESSIONAL EXPERIENCE:

Sr. App Support Specialist/Business Analyst

Confidential

• Assist end users to identify, analyze, resolve and document solutions to support requests.
• Properly triage and escalate distribute support requests as needed.
• Provide clear communication and liaison between both technical and non-technical customers and team members.
• Engage and coordinate with appropriate Subject Matter Experts across the business to see solutions to completion.
• Contribute to the development processes and maintenance of departmental best practices, documentation, and manuals.
• Collaborate with team members and management define and prioritize tasks important for customer satisfaction.
• Participate in an on-call support rotation structure with other team members to coordinate emergency support.
• Providing Business and Technology guidance and facilitate requirements gathering sessions, workshops, meetings, and interviews with the Courts.
• Responsible for creating and maintaining meeting minute for meeting with SME and Sponsors of the Project, ie Judges and Court Administrators.
• Create detailed project documentation with Test & Evaluation Master Plan included in (BRD) and Functional Requirement Document (FRD), Process Maps for process improvements on various possible sector of the court.
• Preparation and Analysis of current state of Process Flow like Bail, Standard Sentencing, File and Serve Delaware, University of Delaware process improvement projects for Courts, Contexte, ASOP, JP Court Form Conversion Project. Resolve issue with Context and CJIS.
• Adept at creating and transforming business requirements into functional requirements and designing business models using UML diagrams, Use Case, Sequence, Activity diagrams using Enterprise Architect, MS Visio and Rational Rose.
• Prepare testing plans and scripts with track keeping on Traceability Matrix.
• Serve as a liaison and point of contact between the Information Center (JIC). Responsible for supporting and contributing to System Integration Testing as well as evaluating current system and business process and initiating recommendations in applications, procedures, and processes.
• Responsible for developing and documenting System Design Document and Small Software Change Request.
• Worked extensively on requirements modeling and Business Architecture, event analysis, context diagram, process map as well as Business Process Modeling Notation and use case modeling
• Analytical ability with experience in performing detailed analysis of system processes and requirements, including process mapping and analyzing business problems to provide innovative solutions. Proficiency with MS Visio and MS Project Traceability Matrix.
• Develop a deep knowledge in the company’s select technology products to be the subject-matter expert and follow the Standard Operating Procedure in documentation and execution of any Project.
• Interview subject matter experts, customers, and other stakeholders to clarify and document customer business needs and translate those needs into clearly defined and detailed requirements and user-focused specifications.
• Configure proprietary software to satisfy customer requirements.
• Work independently to design, configure, implement, and document technical solutions
• Facilitate System Integration & User Acceptance testing and testing of new system functionality. Review of test plans for new developments/releases/reports.
• Ensure quality and distribution of project deliverables, status reports, meeting minutes, etc.

Business System Analyst

Confidential, Richmond VA

• Responsible for BA, QA sign off documents and coordinate with release engineers during deployments.
• Created ‘claims test-bed’ by data profiling and selecting representative claims based off clinical and cost factors from the data warehouse.
• Experienced in facilitating Joint Application Development (JAD) sessions and conducting walkthroughs, surveys, and questionnaires, interviews, brainstorming sessions with end-users, clients, stakeholders and development team.
• Superb ability to communicate with a wide variety of people including Business, Technical, Leads, and Peers to achieve the technical and business goals.
• Strong architecture skills such as process modeling, business process modeling, data gathering and analysis, class diagrams, sequence diagram and UI design, Mockups, and wireframes.
• Extensively involved with data quality and data governance solutions including platforms and supporting data processes. Involved in the complete SDLC- (System Development Life Cycle) from Requirement gathering to actual delivery.
• Hands on experience with several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request. Extensively involved in Data Extraction, Transformation and Loading (ETL process) from XML to the staging area and from Staging to ODS using Informatica Power Center.
• Data Mapping in coordination with Business and Developers and responsible for writing transformation logic for different kinds of extract sent to different State according to the mandate.
• Validated the report generated using SSRS using SQL queries. Write complex SQL queries against the target Oracle database to generate reports and compare against legacy Access database reports.
• Performed Data Validation with Data profiling for data migration. Involved in the testing of Data Mart using Power Center. Extensively used Informatica Power Center for Extraction, Transformation and Loading process.
• Worked in an Agile technology with Scrum. Responsible for different Data mapping activities from Source systems to Teradata.
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of the project.
• Designed & developed various Ad hoc reports for different teams in Business (Teradata and Oracle SQL, MS ACCESS, MS EXCEL) Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Worked collaboratively with multiple business entities and successfully implemented new business processes and established data governance. Write complex SQL queries against the target Oracle database to generate reports and compare against legacy Access database reports.
• Responsible for migrating the code changes from development environment to SIT, UAT and Production environments.
• Load RDM and Update tables in various stages like DWTEST & DWPROD, according to the mapping and the data obtain from the business in regards to maintain Cross Reference table, Threshold & extract submission codes.
• Work with business for creating user stories, entering defects and epic in JIRA. Work with business for creating user stories. Made minor adaptations and modifications to standard techniques, procedures and criteria.
• Prepared and submitted reports on Software Change Request. Write SQL Statements to extract Data from Tables and to verify the output Data of the reports. Ensuring that Hospital is in adherence to current DHS, FDA, HIPAA, CDPH and JC Regulations. Document activities, recording information such as the numbers of applications completed, presentations conducted, and persons assisted.

Data Analyst

Confidential, RI

• Analyzed the source data to quantify benefits and improve ongoing data quality. Involved data governance, defined data modelling and model maintenance standard (enterprise-wide).
• Involved in creating source target mappings based on the Technical Design requirements. Involved in Data mapping specifications to create and execute detailed system test plans. Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Performed data analysis and data profiling using Netezza and Informatica Data Explorer on various sources systems including Oracle and Teradata. Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data.
• Established data quality rules and definitions consistent with Business strategies. Developed data quality metrics that identify gaps and ensure compliance with standards across the organization. Established processes to continuously monitor data quality. Recommend enhancements to data acquisition processes to improve accuracy of data warehouse.
• Lead, monitored, and supervised user’s sessions and interviews.
• Gathered, analyzed/researched and formulated data and process flows for projects with moderate to high levels of complexity.
• Responsible for creating Post Implementation Review for business based on project and its scope.
• Defined and documented detailed, functional business requirements, including systems scope and objectives.
• Developed and managed information systems documentation in accordance with the Department’s standards
• Ensured IT understanding of requested modifications of more complex projects, and the accuracy of their technical documents.
• Worked extensively in XML and HL7 messaging standards.
• Gained detailed knowledge and experience working on HIPAA, mapping of ICD-9, and ICD -10 to the services provided by agency’s clinics
• Experienced working and gathering requirements associated with collection of patient service revenue according to the Healthcare Financial Management Association(HFMA).
• Worked on Informatics to resolve production issues perform testing and debugging of mappings and reports Extraction of test data from tables and loading of data into SQL tables. Used Teradata SQL Assistant for Querying Teradata. Created SQL test cases to validate mapping logic, referential integrity in Facts and Dimension Tables in CUE.
• Formulate methods to perform Positive and Negative testing against requirements. Monitored the Informatica workflows using Power Centre monitor. Checked session logs in case of aborted/failed sessions. Perform Functional, Data Validation, Integration, regression and User Acceptance testing. Created test data for testing specific ETL flow. Used SQL developer to connect to Oracle Database to validate data that was populated by ETL applications.

Business Analyst

Confidential, Charlotte NC

• Involved in the complete SDLC- (System Development Life Cycle) from Requirement gathering to actual delivery.
• Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Created extensively involved in Data Extraction, Transformation and Loading (ETL process) from XML to the staging area and from Staging to ODS using Informatica Power Center.
• Validated the report generated using SSRS using SQL queries.
• Write complex SQL queries against the target Oracle database to generate reports and compare against legacy Access database reports.
• Defined data requirements and elements used in XML transactions.
• Worked in an Agile technology with Scrum.
• Designed & developed various Ad hoc reports for different teams in Business (Teradata and Oracle SQL, MS ACCESS, MS Excel.
• Understanding business requirements and translating them into specific software requirements.
• Understanding both technical designs and specifications. Evaluating information harvested through surveys and workshops, task analysis, and business process description.

QA/ Business Analyst

Confidential, Clifton, NJ

Responsibilities:

• Worked through Agile development methodology by dividing the application into iterations and working on each iteration through full SDLC.
• Examined the system in 'AS IS' state, made business process improvement recommendations and TO BE system designs.
• Acted as liaisons between the process owners and stakeholders.
• Coordinated and facilitated the JAD session to understand the user requirements and also their system's implementation.
• Created Screen Mockups and Dependencies using MS Excel.
• Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
• Used MS Project and assisted project manager in making Project Plan with necessary modifications.
• Defined testing objectives and verify requirements are testable.
• Designed and implemented basic SQL queries for QA testing and Report / Data Validation.
• Participated in User Acceptance Testing on the Business-to-Business Transaction testing.
• Responsible for organizing the Quality Analyst (QA) walk through to explain proposed changes.
• Coordinated with the test team to check the weekly status and report the same to the project manager and discussed project manager and other team regarding Flow Process.