Consulting, Analysis, Health & Welfare, Data Analysis, Integration

Adnan rasheed

*** ********** **** **********, ** 60446

630-***-**** *********@*****.***

SUMMARY

Accomplished and Results Oriented Professional who contributes to the organizations business objectives with over 15 years of work experience in IT Consulting, Business Intelligence, Product management, Implementation, Development, Testing, Documentation and Quality Assurance in the field of Insurance, Banking, Benefits Administration, Finance, Health Care industry and Supply Chain.

An excellent team player & Manager who has capability to work with business users, team leads, architects and peers, thus maintaining healthy environment in the project using SDLC and Agile

Proven experience in gathering requirements and assessment of requirements to both technical and business applications. Highly effective systemic thinking skills; Superior communication skills with proven ability to relate with both technical and business professionals. Excellent relationship building and interpersonal skills

TECHNICAL SKILLS

Functional Areas: Enrollment Applications, Process Improvement, Release Management, Healthcare system Implementations, Change requests & Systems Enhancement, Project management, Supplier Relationship Management

Programming Languages: SQL, Relational Databases SQL, Toad, Oracle SQL Developer, PL/SQL, Teradata, XML

Other Software: Expert MS Office Suite (Project, Word, Access, Excel, PowerPoint, Outlook and Visio), SharePoint, ACL, UltraEdit, FTP-Pro, ClearQuest, ServiceNow, Cognos, DataStage, Tableau, JIRA, Confluence

PROFESSIONAL EXPERIENCE

McDonald's Corporation Oakbrook, IL July 2016 – August 2017

Sr. Consultant/Project Manager

Developed a Tableau dashboard portal by writing requirements and designing wireframes, presented to stakeholders to get better integrated view; Assisted in developing Metadata, physical and logical data model

Planned and facilitated functional design and JAD sessions and with LOB senior management to provide project status, and highlight risks and issues; Managed assigned tasks/projects to meet business objectives and requirements

Implemented Agile process for re-platform, re-hosting data projects by training team to use Jira, help the Team better manage the Project and save time documenting and escalating issues

Executed and maintained project plans; review, track, monitor and report on project status; identified, tracked and resolved issues by proposing viable solutions

Created deployment documents, data mapping, project charter and translate business requirements into written technical specs; Created flowcharts, data flow diagrams for process mapping

Blue Cross Blue Shield Association Lombard, IL July 2015 – April 2016

Sr. Consultant/Project Manager

Gathered and created Technical Design specifications and Systems Use cases based on requirements

Worked as a unit BSA lead with Data Warehouse team for transferring information between the business, developer, data modeler and testing team; Worked with EDI & different file layouts.

Handled product/system development progress; iterates product requirements with Software Development, Quality Assurance, and Content teams to ensure customer needs, schedule, and budgets are met.

Developed testing, validation and implementation plans and processes; lead and implemented the whole project

Experienced in projects working with healthcare claim codes (e.g., ICD9, ICD10, HCPCS, CPT) and value-based care contracts and outcomes

Discovery Health Partners, Itasca, IL Sept 2014 – June 2015

Sr. Consultant/Manager

Assisted in defining business requirements for the IT team and created BRD and functional specifications to assist the developers in their coding; Performed data mining on Claims data using SQL queries and discover Health care claims pattern, Developed and Performed execution of Test Scripts manually to verify the expected results

Identified & record defects with required information for issue to be reproduced by development team

Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update

Collaborated with stakeholders to ensure projects are delivered on time, within budget and agreed upon scope

Change Healthcare, Lombard, IL June 2010 – Aug 2014

Sr. Analyst

●Analyzed and loaded massive and highly complex data sets, performed ad-hoc analysis and data manipulation to extract data for reporting, creating scripts and research.

●Managed multiple DRG/HBA/Contract Compliance accounts by deploying multiple tiers of support and technology to ensure consistent approach. Worked as a SME for many processes

●Developed Inbound Interface using ETL programs and PL/SQL validation scripts to load claims, eligibility and provider data from staging tables to production tables

●Managed the entire product life cycle from strategic planning to tactical activities; developed the product road map and set feature priorities

Bank One/JP Morgan Chase, Arlington Heights, IL July 2009 - May 2010

Senior Analyst

Established strong rapport with significant consumer and business clients to encourage long-term business

Assisted clients to open new accounts for all products and services; Coordinated with existing customer bases and obtained information for all first mortgage inquiries

Maintained product knowledge to provide support to all referral and selling programs as per client requirement

Keep up to date with latest loan and mortgage regulations, prospect for new business regularly by establishing relationships with local referral networks; Planned and supported rollout of new releases

Aetna/Coventry Healthcare, Downers Grove, IL July 2007 - June 2009

Senior Systems Analyst

●Conducted analysis of client business processes and functional specifications utilizing Use Case scenarios. Applied technical and business knowledge in the analysis of requirements in IT testing and product acceptance, new business operating models with innovative approaches to IT solution support.

●Created test plans, conditions, scripts, and test data; performed IT testing, UAT, remote user testing, Regression Testing, usability standards validation, and performance testing; and resolve system defects; Supported technical and QA resources by providing functional expertise during the development and testing phases.

●Worked with EDI & different file layouts, Medicaid, 834, 835, HIPAA x12 4010, IDX claim systems; maintained and test File Management System

Aon/Hewitt Associates, Lincolnshire-IL- Oct 2005 – June 2007

Business Analyst

Coordinated the administration of DuPont and MWv Health & Welfare plans and assist in the development, implementation and communication. Maintained eligibility, billing, claims payments and tracking of all H&W plan costs.

Champion process improvements by identifying the root causes of issues, process delays, and quality problems and recommends solutions; Coach Business Analysts on Issue resolution techniques. Participated in training efforts for Customer Service associates, Shared Services, Global Delivery Teams (e.g. BPO), and for new associates joining team.

Plego Technology, Westchester, IL - Jan 2002 - August 2005

Business Analyst

●Performed requirement sessions with Business users of health and welfare teams Developed Test Plans, Test Cases, and Test Scripts for testing the functionality and Performance requirements of the application.

●Worked with Practice Leadership and processing teams to identify enhancements to SOPs .

●Involved in the User Acceptance Testing, Participated in various meetings and discussed Enhancement and Modification Request issues.

EDUCATION

University of Illinois, Chicago, IL; B.S., Management and Information Systems, May 2000

Green Belt Six Sigma Certified

Contact this candidate