BUSINESS INTELLIGENCE EXPERTISE

• Project Management Professional PMP , Microsoft Certified Technology Specialist MCTS Certified Professional of Healthcare Information System CPHIMS aim to associate with a progressive organization that challenges my wealth of 20 years of Information Technology Business intelligence skills and involved me as a part of a team that dynamically contributes towards the growth of the organization.
• Accomplished Business Intelligence, Datawarehouse, Data Management and Data Architect professional with over 20 years of extensive diverse experience working with organizations that are leaders in their specific domain HealthCare Hospital , Health Care Claims TPA Managed Care PPO .
• Consistently focus on Business Intelligence BI as the driving force to assure that return in investments in BI delivered business value, enabling organizations to achieve and maintain a strong competitive advantage.
• Deep ability to understand business goals, requirements, articulates a vision, evaluate risks and define roadmaps to build and strengthen IT BI capabilities, processes, and infrastructure/system investments.
• Self-starter and expert skilled in creating IT strategic plans aligned with company's business drivers while providing a clear roadmap to deliver business objectives with a passion for people leadership.
• Quickly and effectively developed key relationships with a range of project participants including boards, executives, directors, managers, vendors, client stakeholders, and developers. Has proven international experience and success working with multi-cultural and multi-functional teams.
• An innovative and dynamic management professional providing leadership in the design, development, and delivery of Cost-effective, high-performance data warehouse and BI technology Solutions.
• BI architect with hands on expertise in design developing reports, Dashboards and KPIs. Self-starter with a can-do attitude, adaptable and excellent communicator with an ability to translate loosely-defined business problems into set objectives to concise and logical requirements making process.
• Effectively communicate technical concepts to both technical and non-technical resources in a professional manner.
• Participated in several purchases and upgrading agreements. Involved in contracting and outsourcing services to the software vendors and suppliers in US and India.
• Participating and Developing Technology process design flow for the SAS 70 Audits.

TECHNICAL EXPERIENCE

Business Intelligence Management and BI-Project Management:

Defining Strategic IT BI Direction leadership, Business Case Development, Identifying opportunities to link analytics, Project Management, Requirement gathering and analysis, Design IT BI framework, Systems Design, Execute BI Roadmap, Data warehouse Development Methodologies Waterfall/Agile , Infrastructure Design, Data warehouse Architecture, Data Modeling Data Architecture, Physical Database Design, Data Extraction ETL from Several diverse sources, Data Quality Reporting, Metadata Design Development, Multidimensional Database Development CUBES , Data Visualization/Dash Boarding/Scorecards KPI /Data Mining/Reports, Development of Self-service tools P.Pivot , Stakeholder management and building relationships.

Technical Skills:

• Project Manager, Team Leader, Data Strategist, Data Architect, DBA SQL , Data Analyst, Data System Manager, SQL Programmer, Report Designer.

Databases: SQL Server, MS Access, Oracle.

• Analysis Dash Boarding: SQL BI/Excel Power Pivot/SSRS.
• Data Integration Tools: SQL Server, DTS, SSIS, C , VB.net.
• Database Client: SQL BI Studio, Developer 2000, SQL Plus.
• Database Monitoring: Idera SQLDM, Red gate, Solar winds, SQL Profiler.
• OS: Windows 2003, 2008, Unix.
• Data warehouse Architecture: Cube, Dimensions, MDS, NDS, ODS, MDM.
• Architect techniques: Kimball Methodologies.
• Workflow DFDs Tool: MS Visio.
• Data Modeling Tools: MS Visio.
• Project Management Tools: MS Project.
• Project Management Methodologies: PMBOK.
• Development Methodologies: Waterfall, Agile.
• Documentations Presentation: MS Word, PowerPoint.
• Testing Methodologies: Unit testing, Integration Testing, System Testing, User
• Acceptance Testing UAT .

Others:

• Significant experience in SQL Server 2008 R2/2005/2000/7, IDERA SQL Diag., MS Access, Excel ,SQL Programming and BI, DTS/SSRS/SSIS/SSAS, Crystal Reports, Oracle 8i, PL/SQL, Fox pro.
• Extensive experience in SQL Server Database Architecture, Data Architecture, Data Modelling, Cube Development, Database Alteration, Database Backup and Recovery, Database Administration, Performance and Maintenance Database Creation, Triggers, Constraints, Views, Database Programming Data Integration ETL , SQL/SSRS/SSIS/SSAS, Crystal Reports Business Objects .
• Significant programming experience in Microsoft.NET 2003/2005, ADO.NET 1.x, 2.0, VB.NET 03/05,Visual C 03/05, ASP.NET, Visual Basic 6, Java Enterprise JavaBeans, JSP, JDBC, Java Script, Servlets, RMI, HTML, C , C, C , SQL, PL/SQL, IBM WebSphere Studio, Visual Age for Java, Web Server/Servlet Development Environment, IBM WebSphere Application Server and Web Logic Application Server 5.0.
• Familiar with network operating systems: Windows 2k/2003, UNIX, IBM TSM, Solar Winds ORION Troubleshooting and maintenance of computer network and peripherals.

WORK EXPERIENCE

Confidential

IT Administrator/ BI Project Manager/Database Administrator

Management Duties:

Responsible for BI project projects and strategic IT leadership. Provide BI vision, initiative, leadership for managed care unit of Lutheran Health Network PPO and MedPartners TPA business unit. Provide Information System solutions to meet the business goals, objectives and strategies of Managed Care unit PPO and MedPartners TPA . Maintain relationships, collaborate and coordinate BI Projects EDW/Web/Soft.Apps/ETL/Reports with Software/Healthcare System/Healthcare vendors like IKA System Healthcare Claims , Aptera Software Dev. , TEK Systems Software Resources , Emdeon Payment Cycle , TKS System EDI Clearinghouse , Anion Tech healthcare BPO , Caremark Pharmacy , Hewitt Benefit Admin , MarryBlack Health System , Smith Premier Pharmacy Benefit , Value options Behavior Wellness , Smart Data Solutions Software and international outsourced vendor IDS System BPO and Several regional hospitals of Community Health System CHS . Involved in project meetings with Business Analyst, System Analysts, network analyst and DBAs to establish timely deliverables and project related issues. Involved in meetings with VP, CIO and CTO of IT Lutheran Hospital or Lutheran Health Network and CEO of Managed Care to establish policies and change management. Oversee the Projects planning, implementation, control and ensure deliverables are met within scope, timeframe and resource constraint. Strategically plan information, data and technology system to support distributed and centralized business operations to achieve cost effective IT solutions. Supervise and administer the healthcare data, related to insurance, billing, and payments to providers physicians and facilities Confidential with in HIPPA privacy and Security framework. Actively involved in Management of Technology and System process designs for SAS 70 audits. Actively involved in project related to Integrating Business Intelligence BI tools for data management, Data warehouse and Analytics for Decision Support System. Preparing Manage care for Affordable Healthcare Act by introducing analytics and forecasting.

Achievements :

• Successfully developed and implemented several health care projects such as health care Claims Adjudication/Reprising, Providers Payer Management health claims and CHS Community Health System Benefit based Information System.
• Fully integrated all managed care IT operations with intranet based web applications. The web applications used by the business unit located in the Fort Wayne, Kosciusko, Bluffton, Duke county hospital.
• Successfully managed and implemented several CHS Community Health System provider data migration and Data integration projects for managed care unit PPO and medpartners TPA .
• Planned and implemented migration project of 2000 crystal/Access reports to new scale out SSRS 2008 R2 reporting services over several report servers.
• Made Managed care unit among first to successfully implement the integrated BI solution using data warehouse with SSIS-SSAS-SSRS-SQL tools. Using Analytics for Reporting, Dashboards, KPIs and Health Care claims Analysis.
• Provided the self-service web intranet solutions which cut down help desk customer service call by 50 .
• Developed Mailroom automation claims/forms picture archiving and retrieval which increased the operational performance and cut-down the resources.
• Emphasized on paperless work environment created solutions to reduce paper printing cost by 60 by implementing dual screen monitor solutions, auto fax, auto email attachment reports to different health care providers.
• Automated several reports executions to get executive on time financial operational information.
• Successfully Implemented 2 mil. dollars budgeted, IKA Healthcare Claims Adjudication and Payment solution Software Project in Medpartners TPA .
• Successfully lead BI team to deliver several health care claims data requests to several providers and other internal and external vendors using automation.
• Successfully designing and managing a data repository datawarehouse and reporting solutions for TPA. The average client have over 50,000 members with annual claims paid exceeding 100 million per year.

Actively involved in following teams:

• Data Center migration team
• Database virtualization team
• Database BI integration team
• Offshore vendor management India team.

Confidential

Business Intelligence Project Management

Responsibilities:

• Prepare BI and IT Project management plan for Managed Care unit. Facilitate BI projects, remove barriers, monitor milestones and deliver requirements according to project plan.
• Manage project scope and coordinate change management, track milestones and deliverables. Communicate project status to stakeholders. Anticipate customer needs and proactively develops solutions within timelines and budget.
• Analyze root-cause issue, provide effective solutions and key recommendations for implementation process improvements.
• Communicate and Coordinate with Confidential.
• Provides leadership overseeing all Business Intelligence and Data Warehouse functions, including related documentation for IS and business leaders.
• Prepare Data flow, process flow diagrams, Data Modeling, MDM, Data quality, Metadata, database documentation, data standards, and Infrastructure architecture design to support Business Intelligence.
• Communicate regularly with technical, applications and operational staff to ensure the database integrity and security, implementing best practice and procedure to improve performance, delegate responsibilities and work on leadership and team building skills.
• Manage and administer the configuration of the development, test and production environments for ETL, data warehouse and business intelligence, as well as test data in pre-production.
• Provide oversight of production support for all BI and data warehouse related applications, including data load and report ETL job monitoring and resolving incidents and support tickets.

Confidential

Database Administration

Responsibilities :

• Set up and giving input for the course development and new programs.
• Taught Senior Citizens to use the personal computer to reach out to their loved ones and friends, as well as use social media to communicate with others around the world.
• Testing of new releases and features for application, O/S and Database upgrade and Troubleshoot application performance and Optimize query and index performance. Installed, configured Microsoft Distributed Transaction Coordinator, both for high availability and disaster recovery to remote locations.
• Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks and other locking issues. Proficient with Server-Side System.
• Designed and implemented a data warehouse for Managed Care, and used T-SQL scripts and SSIS for transferring to create the Data warehouse.
• Determine appropriate risk levels of Vendors, and categorize Line of Business payments based on existing HIPPA rules.
• Managed Security, Schema changes, monitored Data warehouse ETL and updated Applications as needed.
• Monitored and modified Performance using Wait States, Index tuning and Execution Plan management. Index and Data Management to determine Defragmentation level - whether to Update Statistics or Rebuild Indexes.
• Security Architecture and Policy Based Management including experience with Authentication, Auditing, File and Data Encryption using Certificates.
• Built best usage processes of Dynamic Management Views and SSIS Management Framework design to troubleshoot issues estimating resource activity.
• Designed data Partitioning solutions for tables and indexes and Risk monitoring and control.
• Database upgrades, patching and configuration.
• Performance Tuning using DMVs, Wait-States and Performance Monitor Counters to quickly find the Root Cause of performance slow-downs.
• Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance issues. Analyze deadlocks and diagnose issues on the server. Troubleshoot Infrastructure issues related to SQL database server such as memory, CPU, I/O, Disk, etc. Monitor log files to proactively resolve issues.
• Perform day to day Database Maintenance tasks - Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
• Manage and Administer several production databases, SSRS reporting servers and SSAS Data warehouse servers.
• Provided technical expertise for procurement of PC and network equipment.

Confidential

Sr. System Analyst Consultant

Job Responsibilities:

System, Analysis, Design and Development of Web based and windows based Applications.

• Prepared process and procedure design documents.
• Prepared data flow and process flow diagrams.
• Web based Development using java, c and SQL.
• Created tables and establish relations between tables, implement business rules.
• Write stored procedures, triggers, indexes and views.
• Created keys and constraints for data integrity on tables.
• Prepared patch and upgrade scripts for service packs and new releases.
• Reviewed and modify existing code for maintaining standards and performance improvement.
• Performed troubleshooting and bug fixes.
• Data transfer and conversion, Backups and recovery plan of database.
• Trained users how to write SQL and to boost performance and reduce the response time.

Confidential

Project Manager

Management Responsibilities:

• Managed IT staff and responsible for hiring/evaluating.
• Mediated any issues that occurred with IT staff at G.B. Pant Hospital and administration of the hospital.
• Responsible for developing standard operating policies and procedures for IT staff at G.B. Pant Hospital.
• Reported to the Director of the Hospital and was involved in projects and committees to address the needs of IT at G.B. Pant Hospital.
• Managed project scope and coordinate change management , track milestones and deliverables. Communicated project status. Identified and helped resolve open issues with programmers. Identified and removed obstacles to project success.
• Facilitated project meetings: took notes, flagged risks, and distributed meeting notes.
• Monitored project to ensure completion within defined schedule, budget, and quality parameters.
• Advocated for the use of best practices and methodologies as we evolved our software development process.
• Coordinated closely with counterparts Directors of Software Development and Information Systems Technology . Fostered collaboration, innovation, creativity, and a fun work environment among cross-functional project team members.
• Worked on several clinical and nonclinical software development and management.

Confidential

System Analyst/Programmer

Job Responsibilities:

• Prepared database high level and detail design.
• Responsible for process and procedure design documents.
• Created data flow and process flow diagrams.
• Developed tables and established relations between tables.
• Wrote stored procedures, triggers, indexes and views.
• Created keys and constraints for data integrity on tables.
• Prepared patch and upgraded scripts for service packs and new releases.
• Reviewed and modified existing code for maintaining standards and performance improvement.
• Performed troubleshooting and bug fixes.
• Responsible for data transfer and conversion and backup and recovery plan of database.
• Ran database consistency check and update statistics.
• Assigned user access and privileges.
• Trained users how to write SQL and to boost performance and reduce the response time.
• Provided technical support to Database Programmers.
• Trouble shooting and tuning of databases.