OBJECTIVE:

To work for a company in need of a person with high experiences in Business Warehousing or Business Intelligence using SAP BW (BI), Business Objects Enterprise and Microsoft SQL Server 2012 or 2008 R2, Oracle and MS SQL database administration and PL/SQL. Additional experienced in developing using Microsoft Visual Studio, Oracle, Visual Basic /MS SQL

PROFESSIONAL SUMMARY:

• More than 20 years of experience in Information Technology
• Exceptional experience in all phases of the project life cycle with technical emphasis on systems design, development, implementation, validation and maintenance including project management.
• Excellent in Administering MS SQL Server 2012 or MS SQL 2008 R2 databases
• Excellent in Oracle Database Administration (DBA)
• Excellent experiences in Business Warehousing or Business Intelligence
• Excellent in SAP Business Object and Business Intelligence Tools
• Knowledge of MS SQL SSIS, SSRS and SSAS
• Excellent experiences writing automation scripts/programs specifically related to SAP and other systems integrations using SAP BAPI Connector, SAP .Net Connector and Microsoft Visual Studio (.NET).
• Excellent oral and written communication skills
• Excellent in MS Sharepoint Administration and Development
• Excellent experiences with Revenue Management Solutions specifics for Government Pricing, Chargebacks and Medicaid systems.
• Experienced developer with strong analytical, design and leadership abilities.
• Experience with client - server or multi-tier application development.
• Excellent knowledge of Database Management Systems (DBMS)
• Design, development, deployment, and support skills for large, complex databases
• Knowledge of Extract, Transform and Load (ETL)
• Ability to design, develop, and deploy new solutions while supporting and enhancing existing enterprise and reporting solutions
• Microsoft Office skills

SOFTWARE:

Microsoft SQL Server 2012, 2008 R2, SSAS, SSIS and SSRS

SAP Business Warehousing (BI)

Microsoft Visual Studio 2010 Ultimate

Microsoft Sharepoint 2007,2010,2013

SAP Netweaver Visual Composer

SAP Netweaver Business Explorer Query Designer and Web Applications Designer

SAP Business Objects Enterprise and Crystal Reports

Oracle DBMS, PL/SQL

SAP BW, ABAP, Workflow

Visual Basic 3, 4, 5 & 6, VBA

ODBC, DAO, RDO, ADO

MS Access 2, 95 and 97, 2000

HTML, IIS, ASP and XML, VB Scripts

MTS, OLE, DLL, ActiveX, COM and DCOM

Microsoft Front Page, DATAFLEX Object Oriented Programming

Method/1, SalesLogix, DB2

EXCEL /Lotus Notes Macros

Microsoft Server 2012, 2008 R2, 2005, 2003, 2000

WORK EXPERIENCE:

Confidential

Data Management Lead

Responsibilities:

• Database Administration of all MS SQL Databases within the Enterprise including proactively monitoring and maintaining availability of all databases in the Enterprise
• Provide the troubleshooting and resolution of support issues.
• Analyze performance of stored procedures, queries and systems configuration and acts to correct deficiencies.
• Develop test, document, implement and support high quality solutions on time that perform according to specifications and requirements documents.
• Develop and manage effective working relationships with other departments, groups and personnel with whom work must be coordinated or interfaced.
• Participate in all systems development lifecycle stages including architecture specifications and design; application configuration; database design; programming; quality assurance; testing and implementation; and ongoing maintenance and support.
• Work with IT counterparts and management team to employ analysis and design techniques including object modelling and database/application schema design to ensure business goals.
• Provide status reports updates for current projects
• Meet professional obligations through efficient work habits such as meeting deadlines, honoring schedules, coordinating resources and meetings in an effective and timely manner, and demonstrates respect for others.

Confidential

Consultant

Responsibilities:

• Administration of company’s Microsoft SQL Databases across the enterprise
• Installation and Deployment of MS SQL Databases in a non-clustered or clustered environments
• Development, design and creation of databases (Production/QA/Developments databases)
• Responsible for implementing Backup and Restore procedures so that databases are available 24/x7.
• Monitoring and improving databases performances including analyzes of Stored procedures, Queries or Views for optimizations
• Backup and restoration of Production databases to be used for QA or Testing.
• Responsible for Oracle database administration including design,
• The installation and configuration of Oracle Software
• Creations of databases instances and Schemas used for various systems for Production, QA and Development environments.
• Fine tuning, index creations, database optimization and maintenance for all oracle databases within Confidential domain.
• Backup and restoration of Production environment to be used for QA or Testing.
• Developed and designs the Business Intelligence reports using SAP Business Objects (SAP Webi) and schedule these reports for daily distributions. Reports developed are Top 10 Sales by Products, Customers, etc..
• Developed, designed and maintain Systems Integration programs across the enterprise
• Developed and maintained Customer websites and approval systems.
• Assist and participated in systems development lifecycles including database architecture designs, application development and configuration, data modelling, programming, testing, implementation and maintenance.
• Designed analytics including the ETL Development and data integration across the enterprise
• Development and maintenance of SAP Automations/Integration across other systems using SAP BAPI Connector, SAP .NET Connector thru RFC and Microsoft Visual Studio (.NET)
• Developed stored Procedures and Views on high transactions systems.
• Provided 24 hours support to databases and applications.
• Assists business in testing and validations including writing validation documents and specifications.

Confidential

Senior Manager

Responsibilities:

• Successful implementation of ModelN Revenue Management System for Government pricing, Chargebacks and Medicaid
• Create and configured Oracle Databases for production, QA and development environments
• Converted data from legacy CARS, GP and Medicaid systems
• Developed various interfaces to support system integration to SAP and ModelN, Business Warehouse BW
• Successful implementation of Imany CARS Revenue Management System
• Create and configured Oracle Databases for production, QA and development environments
• Preferred and convert Master data from other sources
• Upload Customers, Products and Contracts records
• Developed Interface programs needed to various systems (SAP, Business Warehouse-BW)
• Successful implementation of Imany Government Pricing (GP)
• Create and configured Oracle Databases for production, QA and development environments
• Preferred and convert Master data from other sources
• Developed various Government pricing; AMP, BP, NFAMP, etc.
• Developed Interface programs needed to various systems (SAP)
• Successful implementation of Imany Medicaid System
• Create and configured Oracle Databases for production, QA and development environments
• Preferred and convert Master data from other sources
• Developed various interface for Medicaid Claims upload received from various States
• Developed check request payments and acknowledgments from Finance
• Developed logics for the calculations of the per Unit Rebate Amount (URA)
• Developed a Business Warehousing and Reporting using SAP Business Objects for Direct Sales and Indirect Sales
• Reports and analysis to achieve Revenue Leakage
• Rolling Forward Chargebacks
• Comparative Analysis by SKU
• Developed a Canada Secondary Sales System
• To achieve Rebates and Commissions calculations
• Developed the Manufacturing Production KPIs
• Analysis on Weekly and Monthly Manufacturing Plan vs Actual
• Developed website for Plan upload from Excel
• Developed Confidential Sunshine Act for Government Federal/State Reporting
• Achieve government compliance
• Achieve reporting to CMS and Federal Reporting Agencies.
• Administrator for US Confidential Sharepoint sites
• Developed sites including content types
• Administration for the company’s Sharepoint system.
• Developed Intranet and Internet sites for Local and External Customers tracking

Oracle Database Administrator (OracleDBA)

Confidential

Responsibilities:

• Responsible for database administration including design,
• The installation and configuration of Oracle Software
• Creations of databases instances and Schemas used for Chargebacks, Government Pricing and the Medicaid Systems for Production, QA and Development environments.
• Fine tuning, index creations, database optimization and maintenance for all oracle databases within Confidential domain.
• Backup and restoration of Production environment to be used for QA or Testing.
• Responsible for implementing Backup and Restore procedures so that databases are available 24/x7.
• Oracle versions 8i and 9i,10g, 11g and 12
• Development of stored procedures, functions, views and extraction of data using PL/SQL.
• Data analyzing and optimization.
• Maintaining the availability of the databases 24zx7.

Microsoft SQL DATABASE ADMINISTRATOR

Confidential

Responsibilities:

• Install Microsoft SQL Server 2008 R2 and other version of Microsoft SQL Servers.
• Provided Databases administration to all MS SQL Databases.
• Responsible for implementing Backup and Restore procedures of company Microsoft SQL Server 2008 R2 and Sharepoint systems
• Provided data warehouse and business intelligence subject matter expertise and technical leadership
• Monitor and improved database performance and capacity and planning.
• Designed and develop data warehouse and data mart specifications
• Provided data warehouse and business intelligence subject matter expertise and technical leadership
• Provide project management support for the Development of Confidential Enterprise Portal using Visual Composer, Web Applications Designer and Query Designer.
• BW Administrator Workbench (rsa1 and rsa1old)
• Design/create iviews using Visual Composer, Query Designer or Web Application designer
• Design InfoCubes,BW ODS, Infocubes Objects and Multi Provider
• Design and implement data migration from various non-sap systems (Oracle databases) into BW
• Maintain extraction schedules from various applications.
• Responsible for the extraction of Imany CARS data using oracle views into the SAP BW systems; (extraction of CARS submission, adjudications and settlements items within CARS) for analysis for excess Charegebacks, auto deductions, sales, etc.
• Provide Project management support, Lead, analyze, develop, maintain and validate various phama applications using Microsoft .Net (ASP.Net), Visual Basic, Microsoft Access.
• Established data architecture design, development and deployment methodologies
• Perform data analysis to recommend appropriate design models for warehouse and analytics.
• Development of various interfaces between Imany CARS Application and using SAP Function Modules; Customers, Products and Pricing interfaces from R/3 and also development of interfaces to upload all credit memos into R/3.
• Development and maintenance of SAP Automations/Integration across other systems using SAP BAPI Connector, SAP .NET Connector thru RFC and Microsoft Visual Studio (.NET)
• Development of various government pricing models using IMany Government Pricing application
• Development of various interface between Imany Medicaid, CARS and SAP and Government Pricing modules (ASP, Best Price and AMP).
• Developed InfoObjects, InfoProvider and design of various data conversion (CARS, Government Pricing, Medicaid, SAP) into SAP BW.
• Development of SAP Function Modules/ABAP.
• Complete automation of all interfaces.

Crystal Administrator/Developer

Confidential

Responsibilities:

• Installed and Administer Business Objects Enterprise (Crystal Enterprise)
• Developed crystal reports using Oracle database, MS-Access and MS-SQL as source and published to the Business Object Enterprise
• Argus Drug Safety
• Product Complaints
• ModelN Revenue Management System
• IMany CARS system
• IMany Government Pricing
• Imany Medicaid
• Other locally developed applications

Confidential

Senior Analyst Programmer/Consultant

Responsibilities:

• Provide analysis, programming support and maintenance
• Development of various financial and underwriting reports using Crystal Report.
• Development of various web based management report using Crystal Reports.
• Wrote SQL Stored procedures and Views.

Environment: Windows 95/98/2000, Visual Basic, MS-SQL Server, MS-Access, Crystal Reports, ActiveX, VBScript, COM/DCOM.

Confidential

Senior Analyst Programmer

Responsibilities:

• Analyzes user requirements including liaison with business partners and various Airlines for validation requirements.
• Designed database and modules
• Wrote ActiveX components and modules.
• Developed, tested and implemented to 600+ users.
• Analyzes user requirements.
• Wrote ActiveX components and modules.
• Provide production and Clients support.
• Designed database and modules
• Wrote stored procedures and triggers.
• Integrated and tested modules.
• Developed and implemented the system.

Environment: Windows 95/98/2000, Visual Basic, MS-SQL Server, BCP (Bulk Copy Program), Galileo (Computer Reservation System - Travel), Crystal Report, DB2