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...

See full