EXPERIENCE AND CAREER SUMMARY

• Extensive and In-Depth knowledge of T-SQL, SSIS DTS, Reporting and Analysis
• 10 years of IT and RDBMS experience in the Analysis, Design, Development, Testing, Debugging, Implementing, Administering and Maintaining of Client/Server applications using Microsoft SQL Server and user interfaces
• Excellent skills and experts in ETL implementation. Data load and Data Transformation among different Servers/applications. Bulk Copy Programs BCP , Data Transformation Services DTS and SQL Server Integration Services SSIS
• Expert skills in High Level Design of SSIS packages for various applications and server deployment and automated jobs. Data transformation among heterogeneous sources and file formats: CSV, Excel, Flat File, Focus File, Teradata, Microsoft Access database
• Extensive experiences in developing SQL Server objects: Tables, Views, Triggers, Indexes, Stored Procedures, Functions Including Partitioning and comprehensive SQL server Application Scripts
• Knowledge and sound experience in SQL Query/Codes performance Tuning through utilizing Index Optimizing ,Partitioning Implementation and Server Built in tools
• Strong Reporting and Analytic Skills. Extensive experience in Developing Routine and AdHoc Financial Health Care Reporting Process and applications. Strong debugging, data validation and quality assurance abilities and skills
• In-Depth knowledge and experience in Microsoft SQL server DBA activities including SQL database administration and maintenance, backups, restores, replication and SQL Server agent automated jobs.
• Excellent analytical skills, communication skills, Problem Solving Skills and time management skills. Fast learner, quick adapter and works well both independently and in team environment
• Achieve Corporate Spirit Award both in 2010 and 2011 for outstanding work performance and contributions to Enterprise wide Application Tools
• Achieve Excellent Ratings Above Expectations or Exceeds Goals in Annual Performance Reviews in every corporation every career year when applicable

CERTIFICATION

MCP MCTS:

Microsoft Certified Technology Specialist in SQL Server Database Development

TECHNICAL SKILLS HIGHLIGHTS

MAJOR PROFESSIONAL WORK EXPERIENCE

Senior SQL Developer/Lead Production Reporting Analyst

Confidential

• Team Lead: Design, create, test and deploy Reporting Application for Bank Loan Modification Appeals Process Full SDLC . Utilize TSQL stored procedures, SQL 2008 programming codes, ETL, and SSIS Packages.
• Team Lead: Production Support on daily reporting application process, new reporting developments, loan modification reporting maintenance and upgrade.
• Maintain and perform DBA activities on routine Loan Appeals Reporting process. Debug and performance tuning.
• Production Loan Modification data reporting research and analysis. Debug and find work around to ensure data accuracy and integrity. Work with auditors to ensure compliance and loss/risks mitigations.
• Work with all application teams across the company for root issue analysis and debugging efforts in the Load Mod Appeals application.

Environment: T-SQL, SQL server 2008, SSIS 2008, VB.NET, ETL, iSeries, Visual Studio, SharePoint

Senior DB Engineer Contracting Project

Confidential

• Upgrade legacy ETL framework from DTS Packages to 2008 SSIS Packages. Perform review on SSIS Packages, SQL server jobs concurrency process flow, and T-SQL codes.
• Design and Develop Statistical Report process and generation for Client's web interface usage performance data.
• Assist the team with T-SQL code rewrite/upgrade in an effort to decrease process contention and increase query performances.

Environment: T-SQL, SQL server 2005/2008, SSIS 2005/2008, VB.NET, Visual Studio, Source Safe

Lead Actuarial System Consultant/Senior SQL Database Developer

Confidential

• Develop ETL/SQL Process to automate Actuarial financial reports Load, Allocation and Generation processes. Perform query and code redesign for ultimate query optimization. Simplify the monthly Profit and Loss reports generation process by 15 days.
• Lead the Executive Forecasting Application Model Development cycle: SQL process analysis, design, code creation, process testing, debugging, implementing and data validation activities.
• Perform detailed analysis and research on financial actuarial data and data requests. Deliver timely and accurate Ad hoc and routine reports for Actuaries to use in Forecasting and Pricing models.
• Maintain and upgrade Profit and Loss financial reporting system process including programming codes/packages, debugging enhancement, data analysis, report balancing and verification.
• Develop codes packages to upload data into SQL Server tables from various data source: Focus flat file, text file and Excel files. Build process to generate reports for internal Actuaries on various data requests, always in a quick and timely approach.
• Reconcile internal Profit and Loss reports data with other reporting systems and identify the cause of discrepancies.
• Achieve Corporate Spirit award both in 2010 and 2011 for outstanding work performance and contributions to Enterprise Wide Executive Financial and Forecasting Application Tools

Environment: T-SQL, SQL server 2005/2008, Teradata, ASP.Net, MS VISIO, MS ACCESS, MS EXCEL, SSIS 2005/2008, VB.NET, Visual Studio, Source Safe

Reporting Analyst

Confidential

• Developed DTS Packages, queries, stored procedures and triggers on MS SQL Server platforms. Optimized SQL/ reporting processes and make them run more reliable and faster than before
• Created/Designed report process using Crystal Report. Performed disease management reports generation and analysis for both internal and external clients including Blue Cross Blue Shield, Humana, and other health care providers. Improved production reporting process so that the customers could retrieve reports from reporting repository on a timely/accurate basis
• Monitored the daily replication and report automating process and outcome. Performed reporting process debugging and problem solving
• Enhanced reporting database process performance and reporting data accuracy by using effective index design, and effective coding

Environment: T-SQL, SQL server 7/2000/2005, Crystal Reports, DTS Packages, ASP.Net, MS VISIO, MS ACCESS, MS EXCEL, VB.NET, Visual Studio

SQL Report Developer

Confidential

• Developed DTS Packages, queries, stored procedures and triggers on MS SQL Server 2000 platforms.
• Monitor Report Requests through internal web application. Developed T-SQL codes to create and generate both routine and Ad hoc requested data report requests.
• Automated legacy reporting applications written in Access Databases and PowerShell scripts to SQL Server processes ETL, Stored Procedures and Functions .
• Performed reporting process debugging and problem solving. Monitor routine reporting application process on a daily process.
• Enhanced reporting database process performance and reporting data accuracy by using effective index design, and effective coding

Environment: T-SQL, SQL server 2000, Crystal Reports, DTS,MS VISIO, MS ACCESS, MS EXCEL, VB.NET, Visual Studio, PowerShell, Mainframe

DBA / Reporting

Confidential

• Maintained administered reporting MS SQL Server databases for the company's electronic prescription products. The reporting databases stored and tracked prescription drug data, relevant insurance company pharmacy data.
• Developed SQL DTS packages, queries, stored procedures and triggers for reporting data retrieval. Created, developed, supported analyzed routine and Ad Hoc reports for sales and marketing activities.
• Utilized statistical analyzing tools to make product retention analysis and marketing forecasts for the executive management team.

Environment: T-SQL, SQL server 7/2000, Crystal Reports, DTS, MS VISIO, MS ACCESS, MS EXCEL, VB, Visual Studio

Programmer Analyst

Confidential

• Developed, Installed, upgraded, configured, analyzed supported the report database management application: Data Access Information System DAISY used for banking industry and mortgage companies including Wells Fargo, Bank of America, Countrywide, Washington Mutual.
• Managed and maintained the operation of the same reporting database application in a MS SQL server MS Access environment. This included requesting identification and specification, evaluating new databases structure, coding, testing and distribution to separate client sites with multiple users, troubleshooting, problem resolution and client user training.
• Maintained and monitored clients Microsoft SQL server databases in both production and development environments.
• Enhanced and monitored automated data load procedures for daily reporting process and history file archive. The data movement process ETL included DTS packages and nested stored procedures utilizing the BCP and Bulk Insert commands
• Designed and implemented SQL databases' backup and recovery strategies.
• Provided training to external clients on reporting system. Assisted external customers in reports writing, data retrieving, formatting and presentation

Environment: T-SQL, SQL server 7/2000, Crystal Reports, DTS, MS VISIO, MS ACCESS, MS EXCEL, VB, Visual Studio, Mainframe, COBOL, ORACLE, PL/SQL

DATA / DATABASE ANALYST

Confidential

• Designed, administered and maintained complex Quality Assurance Reports databases on multiple platforms using Visual Basic/MS SQL language. The databases stored and tracked physicians' data, survey data, and Medical Claim Complaint data.
• Established reporting database standards and guidelines and assured the quality of database deliverables using VB/MS SQL program coding.
• Generated and wrote appropriate ad hoc and routine reports applications. Perform data management, data manipulation and data transformation among different reporting applications. Performed data and reports analysis in support of quality assurance marketing activities.

Environment: T-SQL, SQL server 7, Crystal Reports, DTS, MS VISIO, MS ACCESS, MS EXCEL, VB, Visual Studio, Mainframe, COBOL