PROFESSIONAL SUMMARY:

• 7 years of Industry experience as a Business Systems Analyst with solid experience in Information Technology with expertise in data warehouse design, development, implementation and maintenance. Worked extensively with Microsoft Excel Macros, VLOOKUPS, and Pivot Tables . Proficient Microsoft Word, Power Point, Access and Lotus Notes.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Sound Knowledge of data architecture concepts, data warehouse and datamarts.
• Experience in creating custom site templates and list templates for developing web part pages for the portal using SharePoint Portal Server 2003.
• Adequate knowledge in Health Administration Claims processing auto adjudication , COB, EOB/Drafts, Claims pricing and testing, HIPAA, enrollment, EDI, Medicare, Medicaid, CDHP consumer driven health plans
• Competent in Creating Unified Modeling Language UML diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Experience with data migration ETL development , document data manipulation processes and scripts
• Extensively worked with WINTEL, a computer running Windows on an Intel processor, created RAID volumes to improve overall performance.
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Developed extensive SQL queries using Query Manager against oracle database for data verification and backend testing
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix RTM which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Strong experience in conducting User Acceptance Testing UAT and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

Software/Hardware:

ERWIN, ETL: Ascential DataStage 7.x, 6.x, 5.x , Star-Schema Modeling, Snowflake Modeling, FACT and dimension tables, Erwin 4.0, Business Objects, CRM, Micro strategy, SAS, Macros, Erwin 4.x, C/C , Java SE 1.4, TURBO PASCAL 7.0, VB.Net, HTML, COBOL, SQL Server, SOA, SAP SD, MySQL, Agile/Scrum, Oracle 8i,Visio, Sybase ASA 6 - 9 .ASP/ASP.net, PHP, Microprocessors 8085 8086, Unix, Wintel, MVS, MS Windows/95/98/NT/2000/XP, MS DOS, MS Office 2000

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr. Business Systems Analyst

Confidential is a medical technology company that serves healthcare institutions, life science researchers, clinical laboratories, industry and the general public. It is organized by three segments: BD Biosciences, BD Diagnostics, and BD Medical, BD manufactures and sells a broad range of medical supplies, devices, laboratory equipment and diagnostic products. Our system solution focuses on customized data analysis software for the Biomarker Discovery Platform. The project was focused on managing Site Readiness with MS Excel T-minus schedule and c supervising cross-functional matrix teams during deployments

.

Role Achievements:

• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Configured Claims, Provider and Member Data via EAI tools for RAPS file and TRR files to CMS for Risk Management.
• Worked on EDI transactions: 270, 271, 834, 835, and 837 P.I.D to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business processes.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Performed System testing of the Claims processing systems Pricing Rules, Duplicate/Limits validation, Member Eligibility, Provider Enrollment, et al .
• Worked as a Data Analyst in order to gather requirements and reaching each and every deadline well ahead of the time line. Methods employed were in compliance with IIBA standards.
• Associated extensive backend testing to verify correctness of the report data using SQL scripts and data comparison.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Created a test plan and a test suite to validate the data extraction, data transformation and data load and used SQL and Microsoft Excel.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Worked with developers to make sure that they understood the Use Cases.
• Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents and performed Data Extraction and Data Compilation using SQL queries.
• Worked with key members from various cross-functional teams to analyze various third-party CRM solutions to make a 'buy vs build' decision. Conducted cost/benefit and impact analysis.
• Conducted Joint Application Development JAD sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Creation and maintenance of Relational Databases for information access and dissemination using MS-SQL Server, MS-ACCESS and Windows Server
• Conducted current state study which included data collection methodologies, data quality and data integration problems, data storage and infrastructure related issues.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Scheduled jobs for backup, and created alerts for error reporting
• Data conversion from other platforms to native database. Creating Customized modules or data maintenance.
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environment
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Created dynamic data cleansing modules to identify duplicate student data using rules from a rules table in the database.
• Participated in meetings to establish and enforce SharePoint best practices and standards manage proper security group naming conventions security assignment processes
• Involved in Managing Data modelling project from Logical design and implementation of Sybase Database
• Worked on data modelling and produced data mapping and data definition documentation
• Responsible for the data cleansing in Quick Base, as per the court orders.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, RUP,VBScript, CRM, SharePoint, Unix, DB2, Adobe Photoshop, Caliber RM MIS-IP, C . NET, ASP.NET, Business Objects, TestDirector, LoadRunner.

Confidential

Role: Business/Data Analyst

Confidential is among the most respected health care insurance companies in the US. The project involved generating reports on various service providing systems such as Financial Eligibility, Claims Budget System, Claims Processing System, Automated Authorization System, Insurance and Third Party System, Correspondence, Liquidation and Encumbrance.

Role Achievements:

• Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
• Created different users, roles, Document libraries, Form Libraries, Team sites for projects, Issue Lists on SharePoint Server 2003
• Validated the following: 837 Health Care Claims or Encounters , 835 Health Care Claims payment/ Remittance , 270/271 Eligibility request/Response , 834 Enrollment/Dis-enrollment to a health plan
• Completed the documentation of Claims Scenario's for the source system
• Met with individual departments to communicate SharePoint purpose, application and vision for the future.
• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
• Maintained the data integrity of the Baan ERP system by developing an end-user strategy for data cleansing and engineering revision control
• Designed and implemented basic SQL queries for testing and report data validation
• Conducted Gap Analysis, and Gathered User Requirements by Interviews, user meeting, JAD session, and Requirement Elicitation Sessions
• Developed data cleansing and data auditing procedures to clean external data and provide audit logs of rejected data.
• Creation of Data Comparison Utilities and Excel Macros for IDW to Data Mart Comparisons
• Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on Ms Access.
• Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
• Designed and developed Use Cases using UML and Business Process Modelling.
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData, Data Profiling.
• Worked with data management and other groups to make sure that quality procedures are integrated into their work processes.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design UI screen using Microsoft Visio.
• Implemented Exception Handling, Transaction Management and Error Reporting across Module.
• Used Visual Basic Editor VBE for developing and testing Macros in Excel
• Created SQL reports, data extraction and data loading scripts for different databases and Schemas.
• Wrote complex SQL code with business logic for Production Data Maintenance PDM Impact Analyses and fallow up with implementation monitoring.
• Involved with all the phases of Software Development Life Cycle SDLC methodologies throughout the project life cycle.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases Test Scripts that are executed during testing process.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Designed conceptual and logical data models of Data Warehouse and tables.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Defined the duplication of data and columns between tables using TOAD and SQL.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: Rational Enterprise Suite Rose, ClearCase, ClearQuest , RUP, Visual Basic, SQL, SQL Server, Oracle, DB2, CRM, Wintel, Unix, MS Visio, MS Office, SharePoint, LoadRunner, WinRunner, DOORS, Project Management.

Confidential

Role: Business Systems Analyst

Confidential is to establish as the standard of excellence in management of medicaid and healthcare services. TMHP partner with HHSC and state of Texas to deliver cost effective, customer focused medicaid and healthcare services through a commitment to continuous improvement, pragmatic technical solution and operational excellence.

Role Achievements:

• Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
• Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
• Worked with data migration ETL development , document data manipulation processes and scripts
• Designed the online screens and reports for the Medicaid Online Electronic Claims Submission System.
• Managed the team of consultants responsible for developing on-demand Medicaid Management System reports.

• Wrote database interface specifications and documented in Data Manager data dictionary
• Worked on development of a information access strategy for the client including integrated data and information requirements, Tools Process recommendations.
• Create and maintain data model/architecture standards, including master data management MDM
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Performed Business Process Mapping and performed AS IS and TO BE analysis
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Prepared scenarios, Use Cases UML State Diagram for scenarios using Rational Rose.
• Integrate Data from wide range of sources including in-house clinical data management systems, labs and contract research organizations and perform data cleaning.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Provided technical support to the Database Team on Oracle 9/10 based architecture, developed SQL queries for data extraction purposes.
• Assisted in mapping the requirements to the source systems, the DW and applicable data marts.
• Organized the data for the court report performing data extraction from different data repositories
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.

Environment: Rational Clear Case,Doors, IBM WebSphere, XML, Java, J2EE, JSP, RUP, VoAVPN, Oracle, MS Visio, MS Office, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential

Role: Business Systems Analyst

Confidential is a well known name in Specialty Hospitals, Nursing Centers and Rehabilitation Centers. Confidential is a web based intranet site, which has information about the organization and is a one stop shop, where an employee can find his timesheets, benefits related material, doctors can find the different forms related to them, nurses can take online training and therapists can apply for the courses and jobs. Knect is a transition from web based application to SharePoint Portal within the intranet. PFR Portal is an extranet site containing information for the therapists and the patients.

Role Achievements:

• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM Master Data Management .
• Create and maintain Use Cases, visual models, including activity diagrams, logical Business process models, and sequence diagrams using UML.
• Prepared Use cases and Data flow diagrams and Work flow diagrams, considering the scope of the project with MS VISIO 2003.
• Reviewed Stored Procedures for reports and wrote test queries against the source system SQL Server to match the results with the actual report against the Data mart Oracle .
• Created and scheduled Sessions based on demand, run on time and run only once using Informatica Server Manager.
• Took lead role in migrating pages and data from old intranet to new SharePoint platform
• Upgrading and Patching of SharePoint and its' related systems
• Developed demonstrated prototypes including data models, business objects universes , reports and business dashboards and received their feedback to define the information access strategy for an integrated data warehousing and reporting solution.
• Used Test Director for error reporting and communicating between developers, product support and test team members
• Worked on MS Excel Macros for creating automatic reports
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on the configuration design and prototypes.
• Associated extensive backend testing to verify correctness of the report data using SQL scripts and data comparison.
• Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Prepared Data Comparison tool by using VBA Excel Macro .
• Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
• Defined the test criteria and project schedules, and baseline the Test Plan with the help of project meetings, walkthroughs.
• Used master data management MDM to define reference data
• Developed Functional Specification Document and Supplementary Specification non-functional Document.
• Participated in the Logical and Physical Design sessions and developed Design Documents.
• Developed schemas for extraction, transaction, and loading ETL using Solonde Warehouse Workbench to expedite data integration between systems.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Develop User Manuals, and Training Manuals as per Project Specifications and timelines.

Environment: Microsoft Office Suite, MS Visio, Windows XP, SharePoint, DreamWeaver, CRM, SQL, PLSQL, XML, VB, ASP, Crystal Reports, Adobe Photoshop, Mercury TestDirector, WinRunner, LoadRunner

Confidential

Role: Business Analyst

Confidential is committed to providing life-saving systems. ARC operates in raising and providing blood and blood-related services through its chapters across the country. Developed BioArch business process model and DTRL Plasma Services system validation. Data Analysis on BioArch aimed at integrating all blood regions in the country. Involved in business process analysis design, and implementation of Six Sigma methodologies on BioArch model.

Role Achievements:

• Met with stakeholders and users to review / manage expectations and identify opportunities to improve ROI.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Created and Documented test cases and test data for Business Users.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Facilitated JAD sessions with end users, development and QA teams.
• Developed the Test plans for quality assurance based on functional requirements.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Moreover, I also authored functional requirements documents FRD by interacting with development team for improving client's legacy system.
• Conducted status report meetings with the business and the IT team on a weekly basis, as the most important aspect of the project was Data Mapping.

Environment: Oracle, SQL Server, Windows, Rational Enterprise suite, MS Office, MS Project.