SUMMARY

• An experienced Systems / Data Analyst with DBMS and Information Technology skills focusing on Business Intelligence and Data Integration.
• An analytical problem solver with demonstrated ability to deliver projects through all phases of the SDLC methodology, from planning to deployment, using best practices.
• A skilled communicator with excellent verbal, written, presentation skills with the ability to grasp and simplify complex process interactions to others.
• A proven technical professional that can work with dissimilar hardware systems, languages, software applications - both custom and 3rd party.
• Proven experience with ensuring data integrity, monitoring logs, troubleshooting, establishing policy, developing procedures to prevent issues and creating effective methods for problem resolution.

TECHNICAL SKILLS and SYSTEMS

• Project /SDLC Methodologies Waterfall, Agile/Scrum, V-Model, PMBOK
• Databases - Oracle, MS SQL 2005-2008, Access 2003-2008, DB2
• Operating Systems - UNIX/XP/Vax/ Microsoft
• Tools - Oracle SQL/ PLSQL, Microsoft SQL/TSQL, Enterprise Manager, Query Analyzer, Visual Source Safe, AxoSoft, Microsoft Office Suite, MS Project, Visio, SameTime, Wiki, WebEx, Able2Extract,
• Intranet/ Business Integration Reporting SSIS/SSRS 2008 r2, SharePoint, Crystal XII, Excel
• Data Modeling - Erwin

EXPERIENCE

Confidential

SYSTEM / DATA / REPORTING ANALYST

As Systems / Data / Reporting Analyst, assisted this company, specializing in the air freight and premier passenger charter industry, with IT governance across multiple worldwide sites. The project required integrating disparate security files for entitlement analysis using advanced Excel, SSRS, and SqlServer. Created an interim system to drive and report solution for 28 applications.

Confidential

BUSINESS / DATA / REPORTING ANALYST

• As Systems / Data / Reporting Analyst, assisted this rapidly growing company, specializing in the senior executive services market, to maximize their members' career potential with leading edge services, and marketplace analytics. Responsible for the design, Sql code, development of multiple database tables and the creation of three critical new systems, Vendor Fulfillment Payment, Order Tracking, and Standard Cost. Development methodology: V-Model
• Interacted with senior management, stakeholders, accounting, and customer service.
• Gathered requirements, accomplished and delivered to milestones. Designed, created reports as needed in SSRS and Excel. Wrote complex queries, created stored procedures, views, functions, and tables. Documented tables and data interactions of the project. Converted existing Sql queries to SqlServer Reporting Services - SSRS.
• Advised technical staff on advanced configuration and techniques of SSRS, techniques for improved performance, advanced techniques for data manipulations, advanced Excel Export/Import
• Assisted with automating setups for e-mailing marketing campaigns. Reduced multiple daily manual tasks into single batch streams. Encrypted sensitive member data for Internet mailings.
• Created Standard Cost maintenance process using export Excel to SqlServer tables.
• Created data model of the tables and data interactions. Suggested data structure efficiencies.

Confidential

SYSTEM / DATA / REPORTING ANALYST

• As System/Data /Report Analyst, assisted client to position their company for interoperability with other health care systems, per HL7 and Health Information Exchange industry standards. Assisted the client's conversion to a more robust HIPPA compliant medical system and their transition from Crystal Reports to SSRS and web-enabled patient reporting while fulfilling Meaningful Use requirements. Development methodology was V-Model
• Designed solution, created RDL, SQL, stored procedures, tested with minimal direction using SSRS 2008 R2. Mentored, tutored junior developer. Created report documentation package and technical manual of the new system for client.
• Tested reports initially with a few live patient cases. Created volume test data using several hundred live patient cases. Worked with SME's on final testing. Presented results to Chief Medical Officer for user acceptance.
• Created data model of the tables and data interactions of the project

Confidential

SYSTEM / BUSINESS ANALYST

• As System / Business Analyst, assisted the client to integrate diverse legacy health care systems into a single source of web-based member benefit information. Development methodology was Agile/Scrum.
• Performed high level gap analysis of multiple legacy systems. Presented findings to Integration Team and senior management regarding data feeds, functionality, resources, queries, membership and reports.
• Created, presented data model visualizations in Visio flow diagrams of the legacy systems' data feeds, resources used, and outputs created to management and Integration Team.

Confidential

BUSINESS / SYSTEM / DATA ANALYST

• As System / Data / Report Analyst, assisted the client, a health care provider specializing in infertility. Aided with infertility research, management of custom software releases, trouble shooting, creation of a new reporting system architecture, and coordination of offshore development/production. The development methodology was Waterfall.
• Gathered requirements, wrote detailed business specifications document and functional specifications for developers. Estimated work requirements to project parameters.
• Developed report prototypes, coordinated the development activities of offshore team.
• Developed process flow documentation, created user-training aids.
• Release Management
• Managed the testing and implementation of multiple, seamless, application enhancement releases to the software - with no-disruption to normal business or call-center operations.
• Eliminated a 6-month backlog of 70 bug fixes and upgrades by organizing, prioritizing all issues, creating plan, tracking progress of the testing. Lead team to a successful upgrade.
• Created a structured approach for QA testing for off shore team, end-users, and project managers, used successfully for 32 releases of the software.
• Performed regression testing . Testing system, ensuring new code changes had not inadvertently introduced errors into the previous version of the system.
• Analyzed, assisted with troubleshooting of SQL and T-SQL queries. Suggested object or code improvements for performance, such as table handling and indexing.
• Introduced Release Notes to track source code changes, enhancements for each release.

Research

• Analyzed, mined internal data to identify trends in utilization and costs over time, across demographics, service providers, and medical treatments for medical research, marketing.
• Using advanced features of Excel to trend, graph data, provided periodic financial summary analysis reports of the business for stakeholders.
• Created Statistical Analysis of Infertility Trends research report.
• Data harvested produced infertility statistics by age group, infertility reasons, diagnosis and treatments.
• Summaries compare statistical data to national statistics for marketing. Findings have been presented at national infertility conferences.
• Responsible for Post-birth Long Term Outcome Service Results project from initiation, to project launch. Worked closely with management team, end users in Finance, Claims, Customer Service, and Clinical to create a data capture system to HiPPA guidelines.
• Created targeted mailing to the providers who provided services to patients with outcomes resulting in births, capturing valuable research data for post-birth infant data.

Reporting

• With key users, evaluated legacy reporting. Discontinued approximately 100 ineffective reports written in Crystal Reports representing a 20 savings in offshore costs to produce these reports.
• Met regularly with stakeholders to understand business requirements and present possible solutions.
• Designed, prototyped, new reporting system infrastructure for Medical, and Pharmacy and Claims departments.
• Solution allowed on-line reporting and the accurate tracking from the creation of a patient authorization through payment of the claim.
• Designed, documented in Visio the new data model for integrated structures of 3 Data Marts.
• Manipulated skewed data with functions, allowing accurate current reporting while facilitating future data integration projects.
• Created data and process flow visualizations in Visio of Clinical, Pharmacy and Claims
• Coordinated the development activities of offshore team.
• Created user-training aids.
• Trained support staff.
• Data Integration
• With BI team, participated in development of plan for migration from 3 Data Marts and the custom Access legacy data into data warehouse using SSIS/SSRS for Integration Project while adhering to HIPAA EDI file format standards for new enrollments.

Confidential

ADJUNCT PROFESSOR

• Relational Database Development Curriculum /Certification 9i 3 courses - 4 credits each
• SQL, Logical / Physical Database Design, Data Modeling, Normalization, Database Administration
• The Development methodology was Waterfall.

Confidential

LEAD DATABASE ADMINISTRATOR

• Responsible for database creation, data integrity, management of manufacturing databases for ten Mailing Systems business units.
• Developed schemas, data models in Erwin for optimal functionality and performance. Created DDL. Maintained Metadata. Reverse engineered schemas to ER drawings.
• Supported online transaction processing, and warehouse applications including SQL, UNIX shell scripting, error handling, transaction logs, audit trails to ensure data integrity.
• Performed multiple data base reorganizations, offloading, loading data to improve efficiency, add new features. Responsible for orderly and accurate data reorganizations.
• Created backup/recovery and off-site Disaster Recovery procedures for multiple databases.
• Developed production batch processing procedures for concurrent nightly processing of multiple business units. Performed troubleshooting, monitoring logs.
• Assisted the creation of Business Objects Universe for reporting.
• Responsible for introducing integration software ISG that allowed legacy systems over non-heterogeneous software and platforms to be shared - online, real time.
• Developed the plan and retired the legacy data from VAX hardware to SQL Server 2000 via ETL, resulting in significant cost savings by eliminating license fees and overhead.
• Provided system data integration assistance for upgrade to ERP solution, SAP DB2/IBM .
• The Development methodology was Waterfall.