SUMMARY

• More than 6 years of experience in designing, testing and implementing application software for large and complex database systems.
• More than 5 Years of Experience in ETLs, Data warehousing (DTS, SSIS) for SQL Server Business Intelligence framework (SSIS)
• Experience Troubleshooting SSRS Reports and Data Sources.
• Involved in all areas of Software Development Life Cycle (SDLC) including Requirements Gathering, Architecture, design drafts and proposals, and ongoing staff meetings, testing, implementation, and deployment.
• Created Ad hoc queries, ETL processes and conducted system troubleshooting, and overall system optimization.
• Designed, developed, and managed SSIS packages to extract, transform, and load data coming from multiple data sources.

TECHNICAL SKILLS

Application Software: Microsoft Visual Studio, SSIS, BIDS, SQL Server Management Studio, SSRS, SQL Profiler, SQL Server Agent

SQL Scripting (RDBMS): SQL Server 2005/2008/2008 R2//2014

Operating Systems: Windows 2000/2003/XP/Vista/7/8/8.1

Languages: T - SQL, Knowledge of C#, Microsoft SQL Server

Version Control Tools: Microsoft Visual SourceSafe, Team Foundation Server (TFS)

CRM: Sales force, SharePoint

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, CA

Senior Database Engineer

Responsibilities:

• Creating and Troubleshooting ETL using SSIS (SQL Server Integration Services) through Visual Studio 2012 for Medicare Claims, Labs, Encounters, and Pharmacy data.
• Wrote stored procedures to send mail notifications for Pharmacy files delivered to the clients and business users on a weekly basis.
• Wrote numerous queries, functions, stored procedures, to parse combination of various codes (ICD9, ICD10, Lab, Encounter, etc…) with their respective identifiers and produced outputs for the reporting team.
• Worked with DBAs and the management team to coordinate deployment with documentation and codes to promote processes to production as well as synchronizing all tests, staging, UAT, and production environment.
• Created customized log tables and triggers to track ETL processes errors and SQL job failures to then send notification to the required teams, users, developers, as well as the DBAs.
• Responsible for creating standard guidelines and steps to follow to get proper code development documents, codes, files, and processes ready to facilitate the deployment process which resulted time consuming efforts and the amount code failures in production.
• Engaged in weekly code between peers to discuss impact and issues with mainly SQL based codes such as Views, functions, stored procedures, tables, Indexes, triggers, and more ad hoc queries.

Confidential, Culver City, CA

Database Engineer

Responsibilities:

• Creating, managing, and supporting various ETL for claims data Integrations.
• Applied ETLs with SSIS to load files (flat file .txt, excel, csv) for claims, pharmacy, lab, diagnosis, disease registries, physician rosters, and members’ enrollment data to the warehouse.
• Worked on aggregating and calculating revenues and payment clients
• Working on C# alongside SSIS to create file transfer processes across the development server platforms and servers.
• Creating Logging and auditing resources for our periodical and ad hoc processes for ETLs using SSIS and stored procedures to skip error prone processes during our multi-client automated run.
• Actively involved in creating and managing daily mail notifications using SQL Server Agent jobs and database mail engine to provide ad hoc reports, insights, status, loggings, and occurring errors. The notifications are used to update the clients and the development team on major processes running periodically.
• Creating store procedures, functions, and tables to accommodate new projects and data for new clients as well as providing code reviews and optimization for improving database usage and processes.
• Troubleshooting and deploying various existing SSRS reports on the report server. Task involves using SQL server profiler to trace reports execution and configuration throughout the server.

Confidential, Torrance, CA

ETL Developer

Responsibilities:

• Participated in the integration of client s healthcare data for different processes such as medical claims, enrollment, eligibility, pharmacy labs, and orders.
• Applied ETLs with SSIS (SQL Server Integration Services) through BIDS 2008 based packages to load client files containing patients claims adjustments and integrating the data into the data warehouse.
• Extracted and processed files coming from FTP in CSV formats, as well as data sources coming from the OLTP database to the data warehouse target tables.
• Provided logical procedures and query to identify data anomalies
• Actively engaged in meetings with co - workers for gathering information on the full scope of the project, not just the claims process.
• Created and designed the structure for new tables to accommodate new incoming clients data.
• Created mappings as well as ETL implementation documentations to facilitate application sharing throughout the whole data warehouse team.
• Established configurations, custom SSIS auditing, email alerts through SSIS Event Handlers.

Confidential, East Greenwich, RI

SQL Programmer / Analyst

Responsibilities:

• Worked on coding for stored procedures, functions, and triggers, views, indexes, temporary tables, SSIS packages, C# programs to be used for daily and weekly clients’ processes
• Applied ETLs with SSIS 2012 (SQL Server Integration Services 2012) based packages to load client eligibility files containing customers and employees profile information as well screenings and biometrics.
• Overall ETL process included extracting from flat, CSV, excel as well as data sources coming from the OLTP database.
• Set up queries and algorithm logics to calculate and report appropriate incentives for participants in activities set by the client company protocols for their employees.
• Worked on pulling large volume of data from various clients’ feeds or sources mainly, excel, CSV, text delimited files using various tasks such data flow task, execute SQL task, Script Task, loop containers, Execute Process Task, File System task, and more, but also applied matching logics for incremental load.
• Actively engaged in meetings with the business consultants for requirement gathering.
• Provided assistance with data tuning, optimization, indexes, quality assurance.

Confidential, Fishers, IN

SQL Server Developer/Data Analyst

Responsibilities:

• Created several tables, views, indexes, functions, triggers, stored procedures, CTEs, temporary tables, result set based upon the functional or business specifications.
• Utilized SSIS (SQL Server Integration Services) to manage Extraction, Transformation and Loading (ETL) process to pull large volume of data from various clients’ feeds or sources.
• Set up various package configurations for package sharing between Teams involved the Development (DEV), Quality Assurance (QA), and Production environment).
• Responsible for creating common module to process all clients’ files into one shared ETL as opposed the previous module which processed clients’ files and ETLs one at a time.
• Provided analysis to establish business and technical plans to troubleshoot system issues.

Confidential

Software Engineer

Responsibilities:

• Created new database objects like Stored Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008 R2
• Provided technical supports between the front end and back-end development
• Modified database structures as directed by developers for testing and development environments and assist with coding, design and performance tuning
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases
• Participated in the creation of vendors and customers targeted interfaces in which records were loaded daily via data entry or other resources such as Excel, Text files.
• Supported the reporting team in querying business specific data from SQL Servers
• Provided back-end support for system functional and performance testing