Database Developer and Administrator Available resume
Professional Summary
Database Developer and Administrator with over 14 years of experience in database development and production environments. Areas of expertise include designing, implementing Database solutions. Analytical and skilled in understanding business problems and develop systems that improve functionality. Skilled in working effectively in collaborative and self-motivated environments. Maintenance, security and backup, and recovery. Proficient in Installation, Configuring, Administration, Managing, Monitoring, Performance Tuning, SSIS, SSRS, SSAS, Optimization and troubleshooting of SQL Server *** , TSQL, SAP-ABAP.
Skills
Domain: HealthCare, Retail, Finance, Insurance.
Team leadership
Data management
Database development
Database objects creation
Data analysis
Problem Resolution
Coding and modularization
Agile methodology
*** TECHNICAL EXPERIENCE
Databases: SQL Server *** , MS Access, Oracle 11G
Reporting Tools: SSRS, Crystal Reports 8.5/XI, Business Object
ETL: SSIS, DTS (Import-Export Wizard)
Languages: T-SQL, PL/SQL, Visual Basic 6.0, SAP-ABAP, Python 3.7
Scripting: VBScript, HTML, XML
Protocols: TCP/IP, HTTP
Web servers: IIS / Personal Web Servers
Methodology UML, VISIO, ERWIN
Work History
Sr. Technology Specialist
Blue Cross Blue Shield of Michigan Jul *** Current
Detroit, MI
Clinical Program Data Mart (CPDM) Project
Played a key role while integrating the EDW Data into CPDM Data mart by identifying the data quality issues, conducted meetings with the EDW Team to create a crosswalk between both the systems and filing the gaps in data.
Perform and/or manage daily/weekly/monthly maintenance duties for supported environments.
I am the Subject matter expert for the Claims (Medical, MA, Dental, Lab, Vision, Pharmacy), Payment Innovation (Host Attribution), BCBSA attribution, NCQA Termination Report, Care relation Project and I have been supporting it since it has moved to CPDM Production Support Server.
Responsible for validating the monthly loads which are pulled into CPDM from the legacy sources (CHCQES and EDW)
I have been an integral part of the RMRA initiative and monthly we generate RMRA files from the production Server and quality check the data by creating Data trending and data profiling reports and we finally deliver the quality tested data to Altegra.
Extensively worked with the development team while moving all the ETL packages from SQL 2008 To SQL 2012.
Create and modify database tables, views, user messages, stored procedures, triggers, views and batch files for recurring asks.
Doing performance tuning to identify hardware and software bottlenecks
Design custom queries and reports including reports in reporting services.
Writing and modifying SSIS/DTS packages • Design, implement and maintain queries and automated data transfer processes
Creating complex SSIS Packages.
Design, implement and maintain queries and automated data transfer processes
User profiler to identify and repair database lockups, deadlocks and other issues.
Responsible for documenting all procedures and tasks to be used for departmental references
Responsible for providing functional knowledge and designing database architecture.
Live Production Support
Sr. Database Developer
The Hershey Company Apr *** Jun 2013
Bentonville, AR
Sales and Logistics Support
Maintained company data downloading and data loading processes and developed data modeling process to constantly deliver accurate data in a timely manner and to improve overall reporting system efficiency and performance.
Designed, developed, and implemented business reporting system solutions to provide more efficient and reliable business intelligence tools for all levels of business executives
Developed and maintained custom applications to solve business problems and improve business performance, such as seasonal reporting which helps improving sell-thru percentage for each season, Inventory Reports etc.
Cooperated with the Hershey Wal-Mart US and international team to effectively manage reporting data and reports distribution and to simplify the report management process
Cooperated with other IS team members to design, develop and deliver...