EXPERIENCE SUMMARY:

• Over 20 years overall experience delivering IT solutions and enabling business success
• 15+ years of experience in Business Intelligence and data warehouse development
• 8+ years of development experience on Oracle and MS SQL Server databases
• 5 years of experience ETL development with Informatica, PL/SQL, Transact SQL
• 4 years of BI development experience in Microsoft SSRS, Actuate, IBM Cognos Report Studio
• 3+ years of experience as Application System Analyst
• Technical experience with Visual Basic and HTML

TECHNICAL SKILLS:

Database: Oracle 10g/11g, MS SQL Server 2000/2005/2008 , Microsoft Access, Netezza 7.0

ETL Development: Informatica, Microsoft SSIS, T/SQL, PL/SQL, DTS

BI Development: Microsoft SSRS, Actuate, Cognos Report Studio, Cognos Query Studio

Programming languages: Visual Basic, PL/SQL, T/SQL, SQL*Plus, Linux shell script

Other Tools: MS Visual Studio, MS VSS, Crystal Report, MS Office Tools

PROFESSIONAL HISTORY:

Confidential, Columbia, MD

System Analyst

Responsibilities:

• Participate in the successful delivery of application releases, delivered on time with minimal to no rework.
• Support multiple CMS projects for Physician Quality Reporting System Confidential ) under Development Effort Consolidation Contract ( Confidential ), which includes:
• AIA (Automated Intervention Application)
• CSP (Communication Support Page)
• GPRO (Group Practice Reporting Option)
• IR (Informal Review)
• IRRMA (Informal Review Request Management Application)
• PQIP (Provider Quality Information Portal)
• QNP - QSP (QualityNet Portal - QualityNet Secure Portal)
• Participate in UDS (Universal Data Set) ETL and UDS GPRO ETL application releases by successful delivery mapping detailed design documents for Informatica team.
• Work closely with DBAs, BAs, and Informatica Developers to keep UDS ETL Mapping Detailed Design Document for this project accordingly requirements, timely updated and perfect shape.
• Participate in research and comparison different BI tools (SAS, OBIEE and Cognos)
• Participate research, development and present POC (Proof of Concepts) in Confidential Composite Portal Implementation.
• Support Requirements, Design, Testing and bug fixes for assigned applications compliant with Confidential program standards.
• Produce required eXpedited Life Cycle (XLC) Documentation as required
• Leverage Confidential best practices, methods, tools, techniques to further improve application delivery.
• Join all required (and possible optional) trainings, classes, conferences and meetings to learn and use newest requirement, technologies, and etc. to keep my work on highest level
• Implement and participate in Confidential approved Peer Review Processes within assigned releases.
• Participate in research and implementation Automated Data Mapping and Document creation for Informatica PowerCenter.

Confidential, Columbia, MD

Sr. Programmer/Analyst

Responsibilities:

• Utilized ETL tools - SQL Server Integration Services (SSIS) and Informatica to prepare Health System Data such as claims data, clinical patient data, outpatient data, behavioral health data, Magellan Complete Care data, Magellan Radiology Benefits Management (NIA), Magellan Specialty Pharmacy Management data (iCore and MMA), finance(statistics) data.
• Worked as report and front end solutions developer. Created reports using MS SSRS, Actuate, Crystal Report, and Cognos Report Studio.
• Developed projects utilizing Microsoft Visual Studio.
• Developed various analytics report for major insurance Health Care System, allowing them to analyze performance and achieve efficiencies in the areas of patient satisfaction, reduce error in disease coding, improve processing of Clinical Care, Behavioral Health, and Radiology, Pharmacy, insurance claims and research.
• Created and supported BI Cognos report (based on packages with relation data or cube data) allowing survey team to analyze custom satisfaction data and to evaluate the trend.
• Developed data driven reports to support decision-making processes for Business Analysts and Management team.
• Supported legacy satisfactory survey datamart (SMART) application (based on SQL server data and stored procedures) and WEB SMART application (based on Oracle server data and VB.NET project), enhanced Informatica ETL processes to pull in more sampling data.
• Completed monthly survey data loads and data cleaning for administrations; worked with the survey team to troubleshoot and resolve issues with the legacy satisfactory survey applications.
• Developed, tested and maintained code using software development methodology and appropriate technologies for the system being used.
• Performed analysis on projects and provided a project plan that indicated the tasks needed to be completed and a time estimate for each task.
• Provided status reports with detailed description of the current project’s progress and time devoted to each task of the project.
• Participated in design walkthroughs with appropriate focus groups and related users to verify accuracy of design in meeting business needs.
• Always complied with regulatory standards of Protected Health Information (PHI) and Electronic Protected Health Information (ePHI) under Health Insurance Portability and Accountability Act (HIPPA) requirement.

Confidential, Columbia, MD

Programmer/Analyst

Responsibilities:

• Developed client/server and file server applications using VB or Actuate and Pl/SQL queries to generate statistical or dynamical reports.
• Developed different types of SQL blocks: Packages, Procedure, Functions, Sequences, etc.
• Designed relational databases in Oracle, SQL Server using Stored Procedures or MS Access using queries, macros or modules.
• Created, developed, tested, ran and supported different application and reports, use VB, Actuate, MS Access, SQL, Oracle, Crystal Reports to run different analytics reports regarding NSQA requirements and different standards, such as HEDIS, MEKA, Matrix, DQR MAC, Venture, OPS, ORS, Provider Queue, etc.
• Developed, tested and maintained code using software development methodology and appropriate technologies for the using system.
• Prepared installation instructions and coordinated installation procedures with the Quality Control Specialist.
• Worked closely with Business Analysts, other developers, DBAs, and Peer Review team to develop detail systems design and written test plans for on-line and report application programs.
• Provided support services for dataset creating, cleaning and dissemination.
• Prepared dataset for submission to the client for analysis.
• Performed data cleaning and validation operations.
• Reported provider baseline for quality control and quality improvement.
• Designed and developed warehouse software package, stored procedures and triggers.
• Reviewed, analyzed and modified programming systems including encoding, testing, debugging and documenting programs.
• Experienced coding using Business Specifications or flow charts, assisted in determining the causes of computer or program malfunctions, and conferred with technical personnel in systems analysis and application planning.
• Analyzed and created technical designs, which will meet user's needs (Includes all product output).
• Verified program logic by preparing tests data for trial runs.
• Analyzed problems in terms of detailed requirements.
• Performed analysis on projects and provided a project plan that shows the tasks needing to be completed and a time estimate for each task.
• Participated in design walk-through with appropriate focus groups and related users to verify accuracy of design in meeting business needs.

Confidential, Baltimore, MD

Patient Care Associate

Responsibilities:

• Created documents and forms using MS Excel and MS word.
• Checked equipment for proper functioning.
• Performed delegates nursing duties.

Confidential

Information Service Programmer/Technician

Responsibilities:

• Developed database applications to track patients, medical supplies, equipment information using MS Access and SQL.
• Investigated and resolved software and hardware problems.
• Trained new arrival personnel how to use PC, OS and applications.
• Developed database applications to track patients, medical supplies and equipment information using Electronic Pages, MS Access.
• Created documents and forms using MS Excel and MS word.