PROFESSIONAL SUMMARY:

• Senior Business Analyst/ Senior Data Analyst/ Senior Data Systems Developer and Analyst / Big Data Analyst and Analytics/ Acquisition Integration / Enterprise Data Warehouse / Metadata Analyst in mainframe, client - server and object oriented technologies / Data Modeler / Database Administrator / Senior Data Analyst / Data Conversion Analyst / QA Tester / Mainframe Programmer Analyst
• Strategic and versatile technical professional combining more than 20 years of programming and senior analyst experience: system integrations, web and database development, business application programming, business analysis, administration & support, software development (web portal, content management, enterprise system solutions) and SDLC. Extensive experience and demonstrated success in systems analysis, data modeling, programming, implementations, upgrades, system development,, testing and installations.

TECHNICAL SKILLS:

Development Tools (Mainframe): CICS, COBOL, JCL, UltraEdit, Big data, Ab-Initio, SAS, SQL, (Web): ASP, HTML, Java Script, UNIX Shell Scripting, Cllient/Server, SharepointMetadata Tools: MetaCensus, Rochade, CA Repository

Methodologies: Method 1, Waterrfall, AGILE SCRUM

Databases: Teradata, DB2, IMS DB, Microsoft Access, ORACLE, SQL Server, SYBASE.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, Illinois

Senior Data Analyst

Responsibilities:

• Analyzed customer data, data elements and applicable data integrity.
• Defined/documented and QA tested requirements for the movement, integration and reconciliation of customer data sets.
• Imported/exported large data sets using a variety of big-data tools.
• Documented data mapping to ensure external data sets aligned with internal file systems requirements
• Interacted with various stakeholders including customer implementation teams and technical IT teams during all phases of SDLC
• Advised team of process enhancements for future production support such as Crash Logs, Skills Inventories for resource support and on the job support tools
• Tested/validated the data to ensure the loads were accurate and ready for the customer's go-live processes.
• Technical data experience with: Access, MS Office, SQL, ASCII, AS400, Ab-Initio, ServiceNow, Sharepoint 2010, Sharepoint 2013.
• Healthcare industry and pharmacy data analysis and conversions expertise.
• Experience with payors (health insurance carriers), providers, and managed care/benefit management
• Produced management reports and queries using SQL, Sharepoint and ServiceNow.

Confidential, Downers Grove, Illinois

Senior Business Analyst

Responsibilities:

• Possessed understanding in the areas of application programming, database and system design.
• Responsible for project leadership and mentoring.
• Responsible for project planning and monitoring progress of the business and technical team members’ progress of their deliverables, ensuring that delivery dates are met.
• Responsible for ensuring that critical path tasks are addressed with upper management, and that these tasks will be delivered on time and under budget.
• Understood Internet, Intranet and client/server architectures.
• Understood how legacy and web-based systems interface with each other.
• Used Agile tools such as Rational Requirements Composer (RRC), Rational Team Concert (RTC),moderates Planning Poker as required, uses WebEx to run meetings
• Excited about learning new things and sharing her knowledge with her teammates

Confidential, Downers Grove, Illinois

Senior Business Analyst

Responsibilities:

• Continued to perform lead business analyst role for conversions of CDW pharmacy data from Coventry to Confidential platforms using all facets of the system lifecycle using Agile, Waterfall and SCRUM methodologies. .

Confidential, Downers Grove, Illinois

Senior Data Analyst

Responsibilities:

• Responsible for the acquisition, analysis, data validation and quality of all external vendor data included in the Coventry Data Warehouse.
• Provided leadership in the evaluation of external vendor information needs for CDW business partners.
• Wrote and tested complex SQL queries using TOAD for Oracle for resolving production issues for the CDW.
• Performed annual HEDIS reporting validation with the Business to validate corporate data trending analytics as required by the Business.
• Implemented vendor solutions for third party vendor data to load into the CDW.
• Participated in major enterprise wide mandate solutions such as the Medicare Part C EOB effort as business lead for the CDW.
• Performed lead data analyst role in conversion efforts to move all Coventry Pharmacy data over to Confidential platforms.

Confidential, Chicago, Illinois

Application Systems Consultant

Responsibilities:

• Successfully managed multiple areas for a four year phased implementation of the Enterprise wide Rochade Metadata Managed Metadata Environment (MME) tool; implemented systems, processes and tools to continue to maximize system utilization (Teradata, DB2, Cognos, CICS, VSAM, Datastage, all other languages) to increase programming efficiency and free technical resources.
• Served as lead analyst and administrator of MetaCensus since inception in 2005.
• Partnered with vendor (Coffing & Associates) for implementation of MetaCensus.
• Interfaced with SQL Server DBA and the Teradata DBA to ensure all loads to application took place each time the production EDW was loaded.
• Oversaw loading of all EDW metadata. Provided process documentation.
• Full management oversight for enterprise data warehousing team.
• Trained, coached, evaluated and managed team of 15 ETL Developers; leading ETL full life cycle tasks, maintenance and development projects.
• Created standardized, efficient system to reduce costs and lead time for issue resolution.

Confidential, Naperville, Illinois

Member of Technical Staff

Responsibilities:

• Coordinated project management operations working with on/offshore teams, including requirement analysis, project planning, scheduling, coding, testing, validation and post implementation support.
• Developed, tested and documented Unix programs written in C & C++ for global customers.
• Created low/high level designs; led system development for complex web based features.

Confidential, Chicago, Illinois

Technical Analyst

Responsibilities:

• Led and/or supported development, testing, validation, technical support and post-go-live implementation support for multiple applications for seven core systems in on/offshore models.