SUMMARY

• Providing over 7 plus years of experience in IT. Diverse experience includes project successes in the areas of Requirement Gathering, Documentation, UML diagrams, Vendor software Implementation, Business Intelligence, and Quality Assurance and Testing. Have extensive knowledge of different domain such as Healthcare, Banking, Automotive Finance, Fixed Income, U.S. Government DOD Supply, Real Estate and Advertising corporate sectors. IT Project Manager, Professional Consultant, Financial Analyst, Business Analyst, and Systems Administrator
• Experience in Healthcare Industry with strong operational knowledge as HIPAA, Six Sigma & ISO
• Highly familiar with HIPAA version changes (4010, 5010) and how it impacts Backend systems and Front end systems and applications.
• Knowledge of ICD - 9 and ICD-10 Diagnosis, Surgical and Procedural Codes Hands on experience in Medicare and Medicaid Claim Process
• Program, test, implement and maintain any data extraction programs necessary to extract the data from source systems and move to the data warehouse. Utilize global development teams to develop ETL and Analytical solutions.
• Strong experience working with HIPAA ANSI X12 Transactions (837/835/834/ 270/271/276/277 ) Familiar with 9 claim acknowledgment transactions.
• Experience on 277CA / 864 Error Response Transactions. Knowledge of Blue exchange standards and regulations for compliance
• Specialize in knowledge and Investment banking domain intensive projects involving multiple stakeholders.
• Excellent understanding of financial market instruments such as -- stocks, bonds, futures, swaps, forwards, options, and Credit Derivatives products
• Knowledge of Structured Finance products such as CDO, CMO, CBO, CLO, Mortgage Backed Securities, and Asset Backed Securities
• Profound knowledge of Pricing Models such as Binomial Pricing, Black-Scholes Options Pricing Model, and CAPM for pricing different financial instruments
• Self-starter with a high degree of self-confidence and good executive presence. Possess excellent analytical and conceptual, communications skills, with the capability to structure and oversee sophisticated hypothesis and data driven analyses.
• Extensive experience in Gathering Requirements, analyzing them, modelling Business Process Flows, writing Business Requirements Document (BRD), Use case Specifications, Functional Requirement Document (FRD), Data Dictionary, Business Continuity Plan (BCP), Workflows and using UML and RUP methodology.
• Adept in creating Narrative Use Cases, Use Case diagrams, Sequence Diagrams, Activity Diagrams, Flow Diagrams and other related UML diagrams. Extensive knowledge experience using of MS Project, Visio and Rational Suite.
• Adept using Gap Analysis techniques to gain a clear understanding of the AS IS of the system and additionally derive new user scenarios to understand the potential TO BE system.
• Adept at creating, editing and coordinating extensive communication networks through the facilitation of joint application development (JAD) sessions and joint requirement planning (JRP) sessions and interviews, written correspondence, reports, implementation requirements, project status reports, oral presentations and email, to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts.
• Good experience in developing testing scenarios and testing scripts.
• Excellent knowledge of analyzing requirements for data migration, data reconciliation, mapping rules, staging rules and transformation rules for the ETL processes
• Adept at writing SQL queries and scripting in PL/SQL, TSQL. Web portal development in HTML, Making & linking Style sheets with HTML. Hold OCA 10g Oracle Administrator Certified Associate Certification.
• Hands on experience in Development and Implementation of Business Intelligence solutions using Business Objects XI and Crystal Reports XI.
• Strong conceptual understanding of a wide variety of applications - technologies and their appropriate use
• Hands on experience in conducting and managing User Acceptance Testing (UAT), Train-the-Trainer Sessions, Class Room Pilots and Requirements Gathering Sessions.
• Worked closely with Project Managers and performed Project Management related functionalities.
• Experienced in managing human resources and acting as SPOC (single point of contact) with Client, HR team, and senior management.
• Developed excellent professional skills in management decision tools like MS Project with proficiency in GANTT Charts and Project Tracking.

TECHNICAL SKILLS

Business Modeling Tools: MS Visio, UML, Rational Rose, Rational Requisite Pro, Snag It, and MS Access 7.0.

Client Services System: Oracle, e-Business Suite, DB2, Hyperion Essbase, Hyperion Enterprise, Hyperion Planning MicroStrategy, BaaN for Delphi, MS Query, Bi-Query, TOAD SQL, GPS and Donovan.

Project Management SDLC Methodologies: Rational Unified Process (RUP), SDLC (Waterfall Method, Agile Methodology)

Microsoft Tools: MS Word, MS Excel, MS PowerPoint, MS Project Server, MS Outlook, MS Visio

HIPAA Tools: TSO, File Aid, Claredi, HIPAA ANSI X12 EDI Transactions (837/835/834/270/271 )

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Project Manager/Business Analyst

Responsibilities:

• Work on HL7 and CCR/ CCD interoperability projects to integrate eCW with other EMRs and HIEs (Private and State).
• Integration involve: Interfacing eCW with other Practice Management EMRs
• Interfacing eCW for Laboratory, Radiology, PACS, and Departmental Reports interfaces with hospitals and vendors using EHR systems like private labs, Medicity, McKesson, etc.
• Experience with PL/SQL in create tables, views, indexes, database links, views materialized views, stored procedures and other database objects as needed.
• Experience with PL/SQL, SQL Loader, and all aspects of data ETL into Oracle database on Windows systems.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Participate in the development of new ETL processes to make new and existing data sources readily available to statisticians, analysts, applications, and outside business partners using SQL Server
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Ability to troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Knowledge of backups, restores, recovery models, database shrink operations, DBCC and commands.
• Oversee project plans, and design complex interface flows and make recommendations in order to improve and support clients’ business activities.
• Expansion of data available for reporting and analysis in the Enterprise Data Warehouse
• Experience with DBAs and Data Architects to plan and implementing appropriate data partitioning strategy for an Enterprise Data Warehouse
• Work with Development and QA team on the requirements and Client needs.
• Provide time estimates for project related tasks.
• Analyze and document client's business requirements and processes; construct project plans and scope documents to communicate requirements.
• Lead and assist product developers, implementation technicians and project managers during the implementation cycle to insure that design and timeline requirements are achieved.
• Generated test case scenarios for testing and/or monitoring of business applications to verify that client requirements are incorporated into the system design.
• Made project plans, integration Scope and designed complex interface flows and made recommendations in order to improve and support client’s needs.

Confidential - Cincinnati, OH

Senior Business System Analyst

Responsibilities:

• Worked as Consultant for the EDI E-Commerce team, supporting all the divisions of the company.
• Involved in full-life cycle software development for mid-size to complex projects by performing requirements analysis and testing.
• Worked on EDI transactions 850, 810, 855,824,864, 856,997, 940 & 945.Monitoring IDOCs daily to resolve any production Issues.
• Experience Structured Query Language (SQL), PL/SQL
• Experience in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, etc.
• Understand ETL basic concepts of data flow, data extraction, data consolidation, change data capture and transformation.
• Experience with performance/scalability tuning, algorithms and computational complexity
• Solid experience with data analytics and high volume data processing. Familiarity with a variety of data formats and protocols of structured and unstructured data
• Proven ability to analyze data and identify opportunities. Ability to analyze large volume of data and identify patters
• Enterprise reporting using SQL Server Reporting Services and/or Business Objects Crystal Reports (Cognos, Microstrategy, etc.) preferably, in a Enterprise Data Warehouse environment.
• Working closely with CSR’s to resolve any Sales Order Issues.
• Re-Issuing outputs for Invoices & ASN’s when needed.
• Daily monitoring and support of critical EDI functions and provideon call system support.
• Providedbusiness and mapping expertiseduring a transition of theEDIapplications from the Gentran server Application toSterling Integrator.
• Worked closely with bothinternal and external customersto analyze and resolve EDI transmission or data processing problems and exceptions.
• Working with Trading Partnersto define new Interface/EDI requirements, mapping specifications, and testing needs.
• Worked with Sterling for testing all inbound/outbound maps.
• Analyzing transaction flow and verifying segments within each transaction and providing reports to Trading Partner to correct issues if any.
• Coordinates solution definition/delivery activities with vendors as required.
• Responsible for setting up of newTrading partners and configuration.
• Responsible fordeveloping mapsaccording to the customer requirement; performend-to-end testingand co-ordinate Production Turnover.
• Responsible forTrouble shooting Mapping errors.
• Supports project initiation efforts by assisting in the definition of project scope and supporting the development of work plans, estimates, and timelines

Confidential - Detroit, MI

Project Manager/ Senior Business Analyst

Responsibilities:

• Worked on designing & documenting the current process flow and the futuristic Michigan operating process flow.
• Actively involved in gathering high level system requirements needed to implement the new operating platform for claims processing
• Involved in regular meetings with the IBM support team, the Michigan local team & the NPI team to identify the gaps in claims processing
• Experience with analytical database experience on large-scale application data models
• Conducted a detailed research on how the claims migrate on the system through each step in the process flow.
• Experience with Oracle Enterprise Manager 11g, SQL, PL/SQL.
• Worked on applications such as TSO, File Aid & other NASCO applications.
• Experience with Enterprise Data Warehouse to create and enhance analytics and reporting capabilities that fulfill business needs for Frontpoint.
• Deploying solutions using version control systems using Enterprise Data Warehouse
• Worked on claims which involve specific logic for Medicare and Medicaid Claims
• Worked as a team in understanding & documenting the system logics needed to operate the claims on the new operating system. (MOS)
• Experience with Oracle data integrity implementation.
• Involved in GAP analysis on comparing the new MOS TRlogs along with the local systems ADF & TRlogs
• Performed validation of test scenarios needed to ensure that the claims process through smoothly in the new NPS system.
• Performed Unit testing & system testing on Michigan blue basic care claims.
• Worked on enhancements & rescoping of system requirements suited to operate on the new platform.
• Worked closely with the IBM team to make sure that the system defects are rectified and the claims are processing correctly.

Confidential - Miami, FL

IT Business Analyst

Responsibilities:

• Generated a streamline process to understand the various steps in theloan lifecycleand current functionality of the existing system by interacting withusers, management, SME(Subject Matter Experts),stakeholders,borrowers, lenders, underwritersandthird party vendors.
• Facilitated meetings with business users to gather requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Identified, researched, investigated, analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements.
• Conducted and participated inJAD sessionswith stakeholders and system users to collect thesoftware requirement specifications (SRS) and usedRequisiteProto maintain the requirements.
• ConductedGap Analysisby identifying existing technologies, created and documented the end-user’sAS-ISworkflow andTO-BE business processes to better understand the mechanics of the existing system.
• PreparedBusiness Requirement Documents (BRD)as well as high-level project plans and used Rational RequisitePro to manage, analyze, and convert business requirements into functional specifications.
• Created and managed project templates, use-case project templates, requirement types and traceability relationships in RequisitePro.
• Used Rational ClearCase to keep different versions of the documents and Rational ClearQuest to report bugs or defect.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations