SUMMARY:

• Over 16 years of experience in Information Technology including over 12 years of experience in Healthcare Industry 
• Over 13 years of experience as Sr. Database Administrator, Data Architect & ETL developer
• Professional experience in 24x7x365 High Availability environments for many years
• Over 6 years of experience on Confidential Clarity & Caboodle Administration, ETL Development & data conversion, Confidential Crystal Report, Radar & Reporting Workbench
• Excellent analytical, management, self - managing, logical and troubleshooting skills
• Proven ability to communicate and work well with co-workers, end-users and clients on all levels

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/2012/2008 R2/2005 & Oracle 12c/11g/10g/9i, MS Access 7.0/2000/2003

Languages: PL/SQL, Transact-SQL, Exasol, MS Visual Basic 6.0, VB.NET, C#, HTML, ASP, XML, VBScript and JavaScript, Web Services, VMWare vSphere

Operating Systems: Windows NT/2000/XP/ 2003/2008/2012 , UNIX HP, MS DOS, Linux

Tools: Oracle Data Integrator Studio 12c , Tableau, Idera (SQL Diagnostic Manager), Talend, Qlickview , Quest (Foglight, Spotlight & Performance Manager), Veritas, Tivoli, MOM, Visual Studio .NET, Component Services Manager, Erwin, BizTalk Server, TOAD, Crystal Reports, Infoview, Visual SourceSafe, Legato Disk Extender, Veeam 8.0, SSIS, SSRS & SSAS

PROFESSIONAL EXPERIENCE:

ETL Contractor

Confidential, Woonsocket, RI

Responsibilities:

• Provided activities related to the Confidential Accordant project: installed Confidential Clarity & Caboodle POC & TST environments & SlicerDicer, performed cutover Confidential settings from POC to TST, maintain custom KB-SQL code to deliver accurate data, supported crystal reports development needs.
• Applied Confidential Special Updates (SU) for Clarity in TST & PRD environments, supported the systems performance (Console, Compass & Hyperspace), created and scheduled Clarity ETL extracts, resolved Clarity ETL performance issues, troubleshoot extract error messages, load failures, data and table issues, maintained custom KB-SQL code and etc.

ETL & Database Contractor

Confidential, Dover, DE

Responsibilities:

• Performed day-to-day Confidential Clarity & Caboodle Administration, ETL Development & data conversion : monitor and resolved Clarity & Caboodle ETL & DB’s performance issues, troubleshoot extract error messages, load failures, SU upgrades, BI SSIS & SSAS cube development, evaluated and translated clinical requirements into necessary IT specifications for reports, dashboards, and workflows.
• Analyzed & supported reporting needs, tuned and optimized existing Confidential Crystal reports sql queries.
• Provided Caboodle ETL development and created custom SSIS packages and tables for data integration Non- Confidential data in Caboodle
• Developed Confidential Reporting Workbench & Crystal reports logical modeling and presentation solutions.
• C reate d Confidential Clarity, Caboodle and Reporting technical material s and train ed co-workers .

Database Administrator

Confidential, Longmont, CO

Responsibilities:

• Performed Day-to-day remote DBA functions on Confidential SQL Server environments: monitoring, troubleshooting, business needs support, SSIS development, tuning of SQL query, supported reporting needs.
• Analyzed the EMR data mappings, created sql scripts and extracted the discrete Scanned Images and Documents data for the last 10 years from the old legacy source EHR system into flat files format, validated & imported the extracted output files to DataFirst.

ETL & Database Contractor

Confidential, San Diego CA

Responsibilities:

• Provided Caboodle ETL development and created custom Clarity SSIS packages and tables for data integration Non- Confidential data in Caboodle for Pharmacy, HealthPlans, Outside Billers providers, using SSIS & SSAS.
• Supported the Confidential 2014 Clarity & Caboodle ETL & Database Administration in PRD environment.
• Migrated the Cognos 8.4.1 infrastructure from old to new environments.
• Designed and developed data ELT back-end processes using Oracle Data Integrator 12c for financial and clinical applications and Tableau reporting.
• C reate d IBM Cognos & Confidential Clarity training documentations and train co-workers .

Architect/Sr. Database Administrator 

Confidential, Atlanta, GA

Responsibilities:

• Performed Day-to-day DBA functions on SQL Server environments .
• Architect the data warehouse technology and solutions serving internal and external customers.
• Created, published and processed an eProve Data SSAS Cube, created technical documentations & materials.
• Extensively worked on tuning of SQL query, optimizing batch process as well tuning various ETL jobs.

ETL Administrator

Confidential, Cleveland, OH

Responsibilities:

• Provided activities related to the Confidential 2014 Clarity ETL Confidential Platform migration: worked with Confidential Nova case’s related to the 2014 upgrade, support the systems performance for multiple Confidential 2010 & 2014 Clarity non-production and production environments (Console, Compass, Hyperspace, Oracle 11.g)
• Created and scheduled Clarity ETL extracts, resolve Clarity ETL performance issues, troubleshoot extract error messages, load failures, data and table issues, maintain custom KB-SQL code and etc.

ETL & Database Administrator

Confidential, Peoria, IL

Responsibilities:

• Provided activities related to the Confidential 2014 Confidential Database Platform migration: Installed Microsoft SQL Server 2012 Enterprise, upgrade existing Clarity ETL & SQL Server 2008R2 DB environments, restore DB’s & migrate SSIS packages, supported Clarity Cubes using SSIS and SSAS, performed database’s archiving.
• Performed Day-to-day DBA functions: monitoring, troubleshooting, business needs analysis and security.

Database & ETL Administrator

Confidential, Atlanta, GA

Responsibilities:

• Installed and maintained Clarity & Cogito DW non-production and production environments (Consoles, Hyperspace, SQL environments and OLAP Cubes) .
• Assisted with Confidential Horizon Patient Folder (HPF) legacy hospital systems data conversion to Confidential .
• Performed Day - to-day ETL & Database Administration (resolved ETL issues, KB-SQL problems, load failures, data & table issues, maintain custom KB-SQL code to deliver accurate data).
• Supported Confidential reports distribution, developed & executed test scenarios to validate data on the reports.
• Extensively worked on BI SSRS, SSIS & SSAS development, tuning SQL query, ETL and batch jobs.
• Created Database Administration & Confidential Clarity ETL related training documentation and train co-workers.

Confidential

Sr. DBA

Responsibilities:

• Architect & Developed from Business requirements Budgeting tool, including Budgeting database and ETL SSIS packages, where Budget related values was submitted and calculated using Excel templates and SQL Server 2005 Integration & Reporting services (SSIS & SSRS).
• 7x24 Database administration, BI development, performance tuning, assisting development team in China.
• During my assignment in AIG, one of the insurance providers, I have held Sr. SQL Server / Oracle DBA responsibilities: server administration, backup and maintenance implementation for 24x7 SQL Servers & Oracle, ETL work with DTS & SSIS, database schema design, performance tuning, assisting development team in India.
• Setup & troubleshoot different SQL Server High Availability technology’s (Cluster, Log Shipping, Replication)

Sr. SQL Server & Oracle DBA

Confidential, Marietta, GA

Responsibilities:

• Performed Day-to-day the Database Administration in 24x7 SQL Server & Oracle environments : ( Confidential, Kronos, HPF, API, Portal, HCR, HCI & other…) for more than 75 SQL Servers & 23 Oracle Instances running in UNIX and Windows 2003 OS using SQL Server & Oracle Tools (backups, system performance, user access, activity levels, system events, error logs, performance tuning, connectivity issues).