SUMMARY:

• Data Analyst/ Business Analyst with over 10 years of experience and expertise in gathering user requirements for database changes and analyzing database requirements.
• Hands - on experience in providing specialized data and advanced research-programming support as necessary within department and in cross-functional teams.
• Extensive experience in developing, designing and unit-testing T-SQL program code, functions and complex scripts to efficiently extract data from multiple databases.
• Experienced Data Modeler with conceptual, Logical and Physical Data Modeling skills, Data Profiling skills, Maintaining Data Quality, experienced with JAD sessions for requirements gathering, creating Data Mapping, documents, writing functional specifications, queries.
• Excellent experience in SQL Loader, SQL Data, SQL Data Modeling, Reporting, SQL Database Development to load data from the Legacy systems into Oracle Databases using control files and used Oracle External Tables feature to read the data from flat files into Oracle staging tables. Used EXPORT/IMPORT Oracle utilities to help the DBA to migrate the databases from Oracle 10g /9i
• Well Versed in creating automated Reports using Crystal Report and SQL Server Reporting Services.
• Expertise experience in coding complex, dynamic queries and stored procedures clearly and concisely, with a keen awareness of how the query/ procedure meets the needs of the business.
• Hands-on experience in design reporting templates and creation of report mock-ups and final report illustrating the results of the analytic and programming processes.
• Extensive experience in contributing to all aspects of requirements definition and management execution activities for SDLC projects.
• Knowledgeable in Data Analysis, Data Validation, Data Cleansing, Data Verification and Identifying Data Mismatch.
• Good experience in developing Test Plans and Test Scripts, and perform test execution.
• Experienced in Database performance tuning and Data Access optimization, writing complex SQL quires and PL/SQL blocks like stored procedures, Functions, Triggers, Cursors and ETL packages
• Excellent communication and writing skills.

TECHNICAL SKILLS:

Client/Server Development Tools: PowerBuilder 6.0, Visual Basic 6.0, Developer 2000, Oracle Forms and Report 6i, Oracle Developer Suite 9i, Remedy, Visual Studio 2000/2005, TOAD, HP Crystal Report, SDLC AGILE, SDLC Documentation, Crystal Report, ERWin

Web Development: HTML, VBScript, ASP/ ASP .NET

Databases: Oracle 8i, Oracle 9i, Oracle10g MS Server, and MS Access

Operating Systems: Window NT/ 95/ 98, UNIX, DOS,

Microsoft Dynamic Applications: MS CRM, Great Plains, and Documentum, MS SharePoint 2010

Languages: C, JavaScript.

Medical Terminology: Clinical and Disease Management

PROFESSIONAL EXPERIENCE:

Confidential

Business Process Analyst

Responsibilities:

• Serve as primary point of contact between the United States Social Security Administration (SSA) user community and Confidential in compiling user/process requirements for information systems development.
• Provide business process reengineering and business/user requirements, including usability and accessibility design/requirements, support for the development of next generation IT applications, including those developed in Service-Oriented Architecture.
• Responsible for understanding the needs of the customer and the realities of commercially available IT products and for creating business/user requirements that allow implementation by the development team and Commercial-Off-the-Shelf (COTS) products.
• Monitoring program deliverables to ensure compliance with quality standards and applicable governance processes.
• Provide business expertise to effectively identify, document, and adapt functional business processes and requirements. Adapt processes to technical solutions based upon comprehensive enterprise application solution sets; and Identify best practices, change and business management techniques, organizational development, activity and data modeling, and/or information systems development methods and practices.
• Provide business process/requirements support throughout all phases of the Systems Development Lifecycle (SDLC): contributing to technical briefings and reports; participating in meetings and walkthroughs; analyzing problems and providing solutions; providing user support; and conducting research.
• Provide support to the Validation team by tracking defects and correcting them. Contribute to recommendations and solutions for complex problems throughout all phases of the SDLC.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Created an entity relationship diagram to visualize relationships between employee database concepts.
• Created a conceptual-level data dictionary to communicate data requirements that are important to business stakeholders.
• Create a data mapping for data conversion potential data issues for a data migration or integration project utilized ERWin.
• Provided weekly status report and meeting minute’s agenda.

Confidential

Data Analyst

Responsibilities:

• Provides data analysis to meet goals and objectives associated with department initiatives and database requirements. 
• Collect and submit accurate, complete, and timely data to the MBSAQIP Data Registry Platform.  In collaboration with the Metabolic and Bariatric Surgery Director and the Metabolic and Bariatric Surgery Coordinator to ensure high-quality data compilation, documentation, data reporting, and data integrity of metabolic and bariatric procedures performed at the SAH submitted electronically to the MBSAQIP Data Registry Platform.
• Documentation of reporting requirements, procedures, and business rules necessary to support the maintenance of MEDITECHS and eClinicalWorks application in Bariatric Surgery.  
• Supports measurement and system improvement. Develops quality, safety, reliability and customer satisfaction metrics and analytics.
• Collaborates on metric development, reporting system design and design and delivery of routine and ad hoc reports.
• Manages resources, process and quality assurance of projects within scope of responsibility.
• Develops and updates the ongoing management plan. Monitors and ensures that detailed project plans, reporting mechanisms, issue resolution processes, and communications are timely and meet quality guidelines.

Confidential, Bel Air, MD

Data Analyst/ Business Analyst

Responsibilities:

• Identified and analyzed project objectives and develop innovative, efficient solutions for accomplishing required data processing, data base management and specialized report generation tasks.
• Provided specialized data and advanced research-programming support as necessary within department and in cross-functional teams.
• Documented processes/procedures for departmental use as well as identifies and implements enhancements.
• Interacted with other clients and facilitate improvements or enhancements to claims processes application to ensure standardization.
• Maintained accurate up-to-date records, and documentation on assigned software solution.
• Assisted with special requests or aiding other departments when the need arises.
• Elicit requirements using interviews, document analysis, requirements workshops, business process descriptions, use cases, scenarios and workflow analysis.
• Coordinate with product and support teams through the full life cycle of new products, services, and business process; supporting project planning activities and enforcement of project deadlines and schedules.
• Translate business requirements into technical specifications data models, event models, reporting output, technical architecture and related end-to-end data flow.
• Worked on database design, relational integrity constraints, OLAP, OLTP, Cubes and Normalization (3NF) & De-normalization of database
• Developed various charts and graphs like bar chart (side-by-side, stacked), line graphs, pie -charts etc. by using chart expert of Crystal Reports.
• Gather user requirements, write technical specifications and develop the required queries and Crystal reports
• Maintained and make changes to existing reports and SQL queries. 
• Optimize and tune new and existing queries.
• Experienced in designing, creating and testing report using enterprise reports such as Business Object and Crystal Reports.
• Performed different project management scenarios like Change Control, Quality Assurance, Defect Tracking, System Integration and Scheduling and worked with QA team to resolve issues in test plan and test case for UAT
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests.
• Involved in Normalization /De-normalization, Normal Form and database design methodology. Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases. 
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts. 

Confidential, Columbia, MD

Data Analyst

Responsibilities:

• Developed, designed and unit-tested T-SQL program code, functions and complex scripts to efficiently extract data from multiple databases.
• Create automated Reports using Crystal Report and SQL Server Reporting Services.
• Analyzing personal clinical health data information Medical Claims, Rx Claims, Eligibility, Clinical and Provider data to ensure accuracy of reports being delivered to upper management and respective clients Rules Management (Claims Explorer) and Physician Quality Profiler.
• Ability to code complex, dynamic queries and stored procedures clearly and concisely, with a keen awareness of how the query/ procedure meets the needs of the business.
• Designed reporting templates and creation of report mock-ups and final report illustrating the results of the healthcare claims analytic and programming processes.
• Provide ad-hoc reports base on client’s requirement.
• Develop reports from databases to assist the operations team with formula, clinical, and cost management initiative decisions.
• Contribute to all aspects of requirements definition and management execution activities for SDLC projects.
• Develop Test Plans and Test Scripts, and perform test execution.
• Perform detailed analysis business processes and to identify inaccuracies or inconsistencies in business requirement.
• Analyzed of business and user needs, documentation of requirements and translate into report that meet the quality.
• Researched, analyzed and calculated quality indicator measures related to clinical topics and conditions across healthcare setting; familiar with ICD-9 and HEDIS measure base on Rules Management (Claims Explorer).
• Performed different project management scenarios like Change Control, Quality Assurance, Defect Tracking, System Integration and Scheduling and worked with QA team to resolve issues in test plan and test case for UAT.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2008 with high volume data.
• Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
• Worked on SQL Server concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services). 
• Provided weekly status report and meeting minute’s agenda.

Confidential, Columbia, MD

Business Analyst

Responsibilities:

• Sorts and analyzes received (be specific what kind of documents) healthcare provider documents specific data fields relevant to the federal HIPPA NPI enumeration process.
• Quality reviews all provider/ practitioner data in corporate information system to ensure accurate processing have assigned billing numbers.
• Monitors and resolves all duplicate/ incorrect processed data related to NPI enumeration within the corporate information management queues.
• Responsible for gathering and documenting business requirements and translating them into functional system design specifications.
• Perform detailed analysis of large protocol to identify inaccuracies or inconsistencies.
• Developed internal reports for various departments and disseminate information to practitioners and providers.
• Focus on new development in legal, business and technology related to transfer of data files.
• Querying databases such as Oracle utilizing query tools such as TOAD and SQL Plus.

Confidential, Columbia, MD

Software Developer

Responsibilities:

• Developed reports using Microsoft Server Reporting Services and Crystal Reports tools.
• Maintained and monitored DTS packages job utilizing Microsoft MS SQL Server.
• Technical point of contact for the day-to-day activities related issues reported to Service Center.
• Prepared and delivered Weekly Activity Reports for the business unit’s managers.
• Coordinated multi-site activities and various other daily activities as arises by the Business Units.
• Maintained version control of all programs using MS Visual Source Safe.
• Maintained and enhance COT software application CRM/ Viryanet.

Confidential, Baltimore, MD

Programmer Analyst II

Responsibilities:

• Maintain and develop Oracle application using Oracle 9i Developer Suite, creating Ad Hoc reports in Discoverer and Oracle Report.
• Developed Oracle database object, store procedures, packages, functions, and triggers using PL/SQL in support of multiple applications in UNIX environment.
• Exported and Imported utilities to reorganize data and using SQL* loader to migrate from other application.
• Defined user requirements, developing data definitions, detailed logic flows, and system and program specifications.
• Participated in continuous review and update to ensure that processes meet changing business unit conditions.
• Collects and analyses data concerning manual and automated processing systems to determine the purpose of the system, work methods used, cause and effect of the problems and improvements needed.
• Performed application level configuration of COTS software as needed.
• Designed and developed a client’s information system (GUI) using Visual Basic 6.0 front-end, on MS SQL and utilizes ADO and RDO as the data access methods for Parole and Probation Department.
• Developing reports using MS Access, Excel (Pivot tables and filtering) and Crystal Reports.
• Performed Data Analysis, Data Migration and data profiling using complex SQL on various sources systems including Oracle.
• Designed (DED), ActiveX Data Object (ADO) OLE DB, COM/DCOM in Visual Basic 6.0 and data-aware ActiveX controls for viewing modifying related data in application.

Confidential, Gaithersburg, MD

Office Manager

Responsibilities:

• Processed credit applications and orderings.
• Processes account receivable activities and performed clerical duties.
• Generated database reports in response to account inquire and trained new employees.
• Oversees administrative work including daily, weekly, and monthly paperwork.
• Route requests to appropriate staff person.
• Maintain and order office supplies, equipment, and postage as necessary.
• Maintain and update organizational files and design filing systems where appropriate.
• Back up computer files on server weekly.
• Maintain the appearance of the office.
• Oversee routine and emergency maintenance of office equipment.