SUMMARY:

• Highly technical and skilled professional with vast experience in developing Middle - tier Business Logic layers, SQL development, SQL Server Transformation and Reporting services, .NET Applications.
• Experienced in designing and creating MS SQL Server relational databases, complex queries, stored procedures, user-defined functions, tables, integrity constraints, indexes, views, triggers, DTS / SSIS packages, customized and interactive SSRS reports, setting up Integration Services Catalogs for Environment Variables and setting up and scheduling SQL Server Agent jobs for SSIS packages.
• Practical and hands-on experience in the analysis of customer and business needs. Development, maintenance and troubleshooting of Middle-tier Business Logic layers such as ASP.Net Web API interfaces using Entity Framework, Web Services, and .NET Windows Forms applications.
• Strong decision-making, problem-solving, analytical, troubleshooting and debugging skills.
• Highly motivated, detail-oriented with the ability to organize and prioritize tasks to ensure timely delivery of projects.
• Displays strong professionalism and outstanding client relationship building skills.

TECHNICAL SKILLS:

MS SQL Server: ASP.Net / Web APIC#.Net / VB.NetHTML / CSS

SSMS: Entity FrameworkVisual BasicMacromedia Flash

SQL / TSQL: LINQVBAActionScript

SSIS / SSRS / DTS: JSONVBScriptJavaScript

MS BIDSPostman: WinFormsjQuery

MS SSDTWeb Services: MS AccessSVN / SourceSafe

SQL Server Agent: XMLMS ExcelServiceNow

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Responsibilities:

• Developed hundreds of SSIS packages for scheduled nightly data processing, and for manual or automated on-demand executions. Such processing would include loading files, creating files and reports, moving data between different servers and databases, decryption, and encryption of sensitive data, scrubbing against DNC lists and restricted states, removing records with invalid, missing, and duplicated data on lead loads.
• Created SQL Server relational databases, tables, stored procedures, user-defined functions, integrity constraints, indexes, views, Integration Services Catalogs for Environment Variables and SQL Server Agent jobs scheduling to support SSIS packages.
• Developed custom tools to compare, analize and move SSIS Environment Variables between development, testing and production environments creating a more efficient, time saving testing and deployment experience.
• Participated in conversion, testing and deployment of all legacy DTS to SSIS packages in the company. Migrating data from SQL Server 2000 to SQL Server 2014/2016.
• Provided and documentation on SSIS packages to offshore support teams on monitoring SQL Server Agent scheduled jobs, troubleshooting, debugging, common issue fixes and step by step instructions on rerunning the processes on failure.
• Developed Web API interfaces using C# ASP.NET Framework for various Web Applications.
• Created customized and interactive on-demand internal SSRS production analysis reports (performance of call-center activities including Agents on call, sales by product, average wait time, abandoned calls, dropped calls, call duration, call penetration, call dispositions, idle time, and hold time) and client specific SSRS production reports (YTD, monthly, daily, hourly sales by product, by state).
• Performed back-end analysis, troubleshooting, and testing of daily/nightly processes.

Confidential

Responsibilities:

• Developed client-specific, customized public-facing, real-time Call-Center sales activities Dashboards.
• Developed and supported Dashboard applications to track real-time progress and performance of call-center activities including Agents on call, sales by product, average wait time, abandoned calls, dropped calls, call duration, call penetration, call dispositions, idle time, and hold time.
• Created and managed SQL Server databases, stored procedures, functions, tables, views, and triggers.
• Performed back-end analysis, troubleshooting, and testing of daily/nightly SSIS/DTS processes.
• Converted legacy Visual Basic applications to C#.Net applications.

Confidential

Responsibilities:

• Developed tools with C#.Net for retrieving Tantacomm digital audio sales recordings from Unix server using DartRc components and converting them to wave files for client on-demand random auditing.
• Developed an internal Windows Forms application using C#.Net for Call-Center site supervisors for maintaining up to date new hires and termination dates, work hours, hours and holiday hours of CSRs for payroll submissions and to manage/track agent’s licensing status by country and by state.
• Developed XML Web Services (WSDL) using C#.Net to support various Web Applications.
• Developed and supported various SSRS Reports including client customized production reports, and internal production analysis reports.
• Developed Sales discrepancy analysis tools using C#.Net to help Lead Management group in conducting a detailed investigation of reports’ data mismatches (missing sales, hours, etc.).
• Developed DTS packages that would create automated internal Call-Center activities and client customized production Excel reports using VBScript.
• Supported legacy Visual Basic applications.

Confidential

Responsibilities:

• Developed applications designed for inbound and outbound Customer Service Representatives for offering and selling products to customers.
• Created applications for licensed Agents confirming sales for transferred customers from CSRs during calls.
• Developed applications for Verification departments to validate sales by listening to voice recordings for final approval of sales.
• Provided on-site application to CSRs and assisted with setup and testing for every new client campaign.
• Used DartRc Tantacomm components in Visual Basic Applications for digital recordings on the Unix server.
• Created databases, tables, and stored procedures to support Windows Forms applications.
• Performed lead loading procedures using Bulk Insurt commands.

Confidential

Responsibilities:

• Created staging tables, stored procedures.
• Used MS Access for file processing.
• Created Excel reports to reflect migration progresses.
• Participated in testing new front-end applications.