TECHNICAL SKILLS:

RDBM Systems: MS SQL Server 7.0/2000/2005/2008/2008 RS/2012. MS Access 2000/2002/2003/ DQS (Data Quality Services), MDS (Master Data Services), SSRS, SSIS, SSAS, MySQL 6.0 and up.

PROGRAMMING: T - SQL, MDX, VB.NET, C#, ADO.NET, XML, Light, Silverlight, WCF, LINQ, Entity Framework.

WEB: HTML5, CSS3, ASP.NET MVC, Jquery

APPLICATIONS: Office 2000/XP/2010, Microsoft Project 2003, Microsoft Visio 2003, Microsoft Team Foundation Servers.

OPERATING SYSTEMS: Windows 95/98/2000/XP/Vista/Windows7/8 - Windows 2000/2003/2008 RS Server.

HARDWARE: Basic A+ skills.

BI visual Tools: Tableau 8.2, Tableau 9.3 (Public), Tableau 9.3 Server, and Desktop.

OTHER: Data Warehousing (Kimball s method), Windows Networking, TFS.

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

Sr. SQL Server DBA/Developer/.Net Programmer

Responsibilities:

• Assisting on Database Monitoring for performance.
• Designing ETL Tools for massaging and converting Patient/Drug Data/HIPPA compliant data for reporting projects.
• Administering Database Access security for users that manage Patient, doctors, and HIPPA compliant data.
• Enhancing database performance and troubleshooting back end issues.
• Developing new applications for data processing using SSIS ETL design. For data extractions and Manipulations for Database repositories, feeding this data from other MS SQL Server Databases and MySQL databases.
• MySQL database admin and development. Monitoring MySQL performance and maintaining SQL code applications for performance in MySQL and MS SQL Server dbs.
• Development and administration of SSRS.
• Design and implementation of SSRS reports with Patient data analysis.
• Administration of SSRS server for performance and security implementations.
• Administering and assigning different security credentials to users for use of specific reports.
• Creation new databases from scratch to support patient and prescription services applications.
• Maintenance and enhancements to existing patient billing applications in C# and SQL server as the back end.
• Assisting on the HA and DR implementations through the use by backing up and restoring databases, creating and monitoring server performance.
• Writing extensive TSQL Code as part of the optimization for Stored Procedures and functions as part of the weekly top 20 performance killers.
• Remote customer support and team work for outsource developer back in India.
• Planning and implementation of SQL server replication, log shipping, Back Ups and restores of large databases.
• Automating maintenance plans for system availability and performance. This includes assisting developers on troubleshooting code and application performance issues.
• Maintaining Web Servers, SQL Servers and Application Servers for HA.
• Assisting as a Support Engineer performing software installations, upgrades, and server administrations on SQL boxes.
• Developing Business Intelligence processes from Database design and maintenance, to ETL tools development, to data reporting to high level management.
• Database Migration and conversions from Oracle Databases using advance Microsoft tools.
• Building ETL tools to combine different database systems (Oracle, SQL Server, IBM main frames) into single repositories in SQL server.
• Health/Hospital industry, HIPAA compliant.
• Managing and maintaining Clustered SQL Server environments.
• Adding SQL Server Patches and fixes according to Microsoft recommendations.
• Configurations and maintenance of Mirroring SQL Server environments.
• Troubleshooting Clustered and Mirrored issues with the servers.

Confidential, New York

Sr. SQL Server DBA/Developer/SSRS

Responsibilities:

• Administering Existing Data Stores and Databases holding General Hospital Patient and surgical data sitting in SQL Server 2008R2 and SQL Server 2012 boxes.
• Creating SQL Server 2012 ETL Packages for massaging and converting Patient/Drug Data/HIPPA compliant data for reporting projects.
• Creating a Database application and ETL Tool for converting and migrating ICD9 codes to new Government Compliant ICD10 codes for surgical procedures.
• Taking over new projects for new SSRS Reports needed by Doctors.
• Creating new had hoc reports for surgical and patient drug information.
• Managing data for Health/Hospital daily operations.
• Responsible for the security of HIPPA compliant data during the development process.
• Programming TSQL Stored Procedures and SQL Functions to query data from the Database Data Repositories and provide other developers with this request for their front end applications and 3rd party reporting tools.
• Monitoring databases queries for performance, due to issues on slowly running transactions from UIs and SSRS reports.
• Providing Help Desk support for users such as Doctors, Hospital users, and IT Staff 24/7 on application and reporting issues.
• Designing new Tableau projects to display Business Intelligence reporting data for upper management, such as key indicators, patient drug usage and level monitoring, patient’s and Doctor’s surgery information.
• Configuration and Maintenance of Log Shipping and Mirrored SQL Server Environments.
• Troubleshooting Issues with Log Shipping and fixes and SQL server patch issues.

Confidential, San Antonio, TX

Sr. SQL Server DBA/Developer/.Net Programmer

Responsibilities:

• Administering and maintaining existing databases for the Drug Stores/Pharmacies/Drug/Patient Industry.
• Developing SQL Server and Application Solutions for the SSRS reporting projects for Pharmacies/Drug/Patient data.
• Taking over a Clearing House project to learn an existing ETL tool and extend that tool with new functionality for clearing house data.
• Programming C# and Database TSQL code to extract pharmaciesdrug new data files in order to integrate the data into our SQL Server Database repositories.
• Designing Business Intelligence projects for data warehousing reports for upper management.
• Proposed the use of a visualization tool like Tableau and implement some reporting projects once approved.
• Work with other developers on the reporting projects for Tableau and SSRS,
• Working on new projects to manage Patient/Pharmacy memberships and Insurance discounts for the purchased and insurance covered drug claims.
• Work with the development team and Business Analyst on designing an application to automate Patient prescription drug refills, since this was affecting insurance claims due to not completing refills or overfilling patient drug request.
• Working on the design of a centralized hub location to fulfill pharmacy and hospital drug depletion level requests.
• Working on a database application to fulfill the search for depleted drugs between different pharmaceutical entities and drug providers.
• Managing and maintaining Private Patient data or HIPPA compliant data for reporting projects.
• Designing financial SSRS reports for upper management.
• Designing all sorts of had hoc reporting for insurance claims and drug/pharmacy claims.
• Constant training courses for HIPPA rules and patient data secure implementations.
• Parsing XML documents into actual SQL Server database schema structures for storage into the databases.
• Converting data from Database repositories into actual XML wellformed documents for easy exchange of data between different database systems.
• Maintaining tables for XML storage for performance I/O by creating and maintaining xml indexes on xml column types on tables designed exclusively for storing xml wellformed documents.
• Creating XML wellformed documents out of Stored Procedures as the based query platforms and format for web based UI tools for PatientDrag prescription information.
• Design and maintenance of Tableau Dashboards (interactive dashboard design).
• Configuration of real live data monitoring on Tableau Dashboards.
• Design of different key indicators and Interactive reports on Tableau for upper management.
• Administration of Tableau Servers and Tableau dashboard projects sitting on the server.
• Installation and support to users using Tableau reader on their PCs.

Confidential, Phoenix, AZ

SQL Developer

Responsibilities:

• Design and creation of Databases for the medical industry of dialysis.
• Maintain and assist on daily database operations as part of the DBA role.
• Working closely with Analysts and gathering database requirements for new development.
• Working with front end ColdFusion developers to make data available for the applications and fulfill their front end data requirements.
• Creating and maintain ETL processes in SSIS.
• Migrating old MS Access databases to SQL Server instances.
• Writing and maintaining Stored Procedures, Functions, triggers on existing SQL Server 2005 databases.
• Optimizing existing TSQL code for performance enhancements through use of Query Analyzer, Execution Plans’ Analysis, and SQL Profiler.
• Helping QA teams during the pre/post final stages of product deliverables.
• Taking Technical Leadership through new and existing projects related to the new Scheduling application named “ScheduleWise”.
• Providing production development and production support.
• Working remotely as a team to get projects done on time.

Confidential, El Segundo, CA

SQL Developer (Consultant) 100% OnSite work

Responsibilities:

• Working closely with Business Analyst to translate project requirements into SQL applications.
• Creating SSRS reports and Had Hoc reporting solutions for upper management and doctors with Dialysis Patient’s information.
• Administering databases holding patient and drug information.
• Writing Stored Procedures to extract Patient and Drug data to feed cold Fusion front ends.
• Familiarity with HIPPA requirements.
• Working with Claims data for the accounts receivable and Accounts Payable to produce reports for collection of payment for doctor and dialysis services.
• Working with Business Analyst and other developers as a team with the objective of solving Call Request (CRs) issues for Quality Assurance of application programs.
• Fixing and enhancing stored procedures that are part of a legacy system or that require changes due to business rules.
• Writing Store Procedures to generate advance reports as part of a team work with the Crystal Reports developers.
• Enhancing legacy relational databases with Database Architects at the enterprise level.
• Working with ColdFusion developers by writing stored procedures, triggers, and scheduling Jobs, as part of automation processes for data manipulation.
• Designing DTS package architectures as part of huge data migrations from Informix and Oracle databases.
• Supporting different Replication architectures by monitoring and maintaining replication to make data available on Development, Staging, and Production environments.
• Managing TSQL code and SQL Objects in Starteam (a program similar to Visual Source Safe).
• Supporting the QA team to push new applications into production
• Maintaining the Reggie warehouse applications in SQL Server 2000.
• Maintaining existing cubes and writing MDX queries to customized existing dashboards for analysis services.
• Creating and deploying new reports for used by marketing department and HR personel by way of SSRS.
• Optimizing and adding new logic to ETL processing to update data marts.

Confidential, Dallas, TX

Sr. SQL Server DBA/SQL Business Intelligence Developer/.Net Programmer

Responsibilities:

• Monitoring database systems performance and availability.
• Performing new installations and upgrades to new SQL boxes.
• Assisting other developers on new code deployments and installations on different environments.
• Performing upgrades from prior SQL server versions to SQL Server 2012 versions.
• Planning and implementation of SQL server replication, log shipping, Back Ups and restores of large databases.
• Automating maintenance plans for system availability and performance. This includes assisting developers on troubleshooting code and application performance issues.
• Maintaining existing Data Warehouses and creating new cubes for report data feedings.
• Implementing new BI designs using he full development life cycle.
• Creating ODS and Data Mart repositories as part of the Data Warehouse design.
• Designing ETL systems with SQL SSIS 2008R2 and 2012 versions.
• Designing and implementing new Master Data Services prior to push data to Data Marts.
• Designing new cubes and KPI’s to feed SSRS Reports.
• Designing new SSRS reports for KPI’s used by management for daily and weekly status reports.
• Working with other DBAs on new task and putting together a BI team of developers to work on new projects.
• Optimizing existing TSQL code on slow running Stored Procedures as part of the Performance improvement process.
• Maintaining ASP MVC .NET web applications and implementing new changes for application improvement and new designs.
• Maintaining and writing new C# and VB.net code for extending functionality on existing Web applications.
• On call 24/7 availability for customer service support an IT support.
• Doing both on site and remote work to perform regular work on a daily or weekly basis.
• Health/Hospital industry, HIPAA compliant.
• Managing AD accounts, users and groups.
• Add users by copying properties of another users in AD Manager.
• Creating and using templates with common user attributes in AD.
• Creating new AD OUs.
• Resetting user Passwords in AD Manager.
• Enabling/Disabling users in AD.
• Unlocking users modifying user properties, names, login names in AD.
• Moving users between different groups in AD.
• Search users, groups, pcs and OUs within domains using AD Manager.
• Implementing security attributes to restrict user control with the domain and OUs.

Confidential, Austin, TX

Sr. SQL Server DBA/SQL BI Developer/.Net Programmer/Analyst

Responsibilities:

• Performing Integration Analysis between different system data sources.
• Creating the Business Intelligence Platform for a BI architecture.
• Implementing Data Integration system through used of different methodologies such as SSIS (ETL) systems, SQL Replication topologies, and other external data source automations.
• Designing reports using SSRS. Score card reports, mapping reports, Revenue reports, drill down reports, Interactive reports, Data Warehouse reports, Cube reports.
• Setting up, configuring, and designing DQS architecture as part of the data quality process prior to pushing the data into our new DMS server.
• Setting up and configuring CDC (Change Data Capture) in SQL server 2012.
• Maintaining CDC as part of the maintenance plan.
• Monitoring CDC for performance and implementing CDC indexes on CDC tables.
• Setting up, configuring, and designing DMS architecture prior to pushing data into our Data Warehouse data marts.
• Setting up, configuring, and designing SSAS architecture prior to pulling data from MDS to feed our multidimensional cubes, through use of SSIS (ETLs).
• Creating and Designing executive reports and score card reports in SSRS.
• Creating SharePoint dashboards to display and view read only reports and interactive reports.
• Analyzing, maintaining, and troubleshooting performance and availability of SQL Server databases.
• Setting up, configuring and upgrading SQL Server databases from 2005, and 2008 to SQL Server 2012.
• Setting up, configuring, Database Mirroring and SQL server replication as part of the fault tolerance security procedures.
• Assisting on the migration to SQL server databases to different network domains.
• Assisting and training other developers with TSQL and .Net programming issues on their applications and training them on new SQL 2012 DQS and MDS architectures as well as implementing new coding best practices techniques.
• Design and maintenance of Tableau Dashboards (interactive dashboard design).
• Configuration of real live data monitoring on Tableau Dashboards.
• Design of different key indicators and Interactive reports on Tableau for upper management.
• Administration of Tableau Servers and Tableau dashboard projects sitting on the server.
• Installation and support to users using Tableau reader on their PCs.

Confidential, Costa Mesa, CA

SQL Developer/.Net Programmer/Analyst

Responsibilities:

• Working closely with Project leaders and Business Analysts during the designing and development stage.
• Writing and maintaining Stored Procedures, Functions, triggers on existing SQL Server 2000/2005/2008 databases.
• Optimizing existing TSQL code for performance enhancements through use of Query Analyzer, Execution Plans’ Analysis, SQL Profiler, and Apex Performance Monitor.
• Customizing 3rd Party databases to fit business requirements.
• Optimizing and creating new users and executive reports as part of Business Intelligence projects (using SSRS).
• Creating new SSRS reports for use with Dashboards.
• Writing Visual Basic.Net and C# middle tier components to support UI and Back End functionality.
• Working closely with Broker services personal by designing and writing Web Services (WCF) and XML code to exchange data used by the middle tier to get and manipulate data access layers.
• Supporting different Database environments (Production, UAT, Testing, and Development) during and after new code implementations.
• Supporting and customizing a 3rd party Database called ONYX for CRM management systems written in SQL Server and .NET business objects.
• Working closely with the Data Warehouse team to synchronize data between different databases during the ETL processes (using SSIS as the main tool).
• Creating New SSIS packages for automated data cleansing and loading to Data Marts.
• Maintaining and Migrating legacy customized DTS packages (SQL 2000) to import data from flat files and other SQL 2000 database sources.
• Optimizing existing database system architectures for performance (creating indexes, optimizing and analyzing execution plans for processing speed.
• Supporting QA and Test teams during the final stage of testing.
• Supporting the development team by taking Technical Leadership through some project releases.
• Providing production support during the releases of new projects.
• Working on site and remotely as a team to get projects done on time.
• Creating and maintaining cubes on top of data marts.
• Maintaining existing data warehouse by constantly improving performance for speeding data dashboards for MDX custom querying.
• Maintaining Data Mining algorithms for data drilling.
• Maintaining ETL processes to feed data marts.

Confidential, Los Angeles, CA

Database Programmer/Analyst

Responsibilities:

• Writing TSQL programs to process data on large scale databases through the use of
• Query Analyzer.
• Gathering user specifications thorough the SDLC analysis process, and converting these specifications into physical system implementations.
• Writing store procedures to process data for reporting and front end applications.
• Creating triggers and modifying existing indexes for existing databases.
• Heavy querying of databases trough TSQL code.
• Designing DTS packages for adhoc reports.
• Moving and converting data from different systems into SQL Server 2000.
• Creation of data warehouse and data storages for critical and historical data for reconciliation, financial, and historical reports for management.
• Analysis and design of automated report by using MS Access or Crystal Reports 8.
• Documenting existing and new database systems, including business rules.
• Documenting front end applications through the aid a UML diagrams and MS Visio software.
• Writing Visual Basic 6.0 front end applications (BAK Operations project) from scratch.
• Integrating MS Office Suit for automation of reports.
• Coding and design of front end screens for process automations.
• Testing and debugging existing and new program units from legacy and new systems.
• Maintaining Visual Basic 6.0 front end applications to access and query data for data entry and report generations.
• Designing small VB.NET and ASP.NET front ends for internal reporting with SQL Server 2000 as the back end.
• Working on a full SDLC phase process to gather user specifications for database application design.
• Implementing SQL Server administration including database replication and security.
• Analysis of new software solutions with existing applications’ integration to fulfill user and management needs.

Confidential, Gardena, CA

IT Consultant/Database Programmer

Responsibilities:

• Writing TSQL programs to process statistical data stored on SQL Servers.
• Writing store procedures to process data for reporting.
• Fine tuning existing databases in SQL Servers.
• Writing adhoc queries to generate reports for upper management.
• Designing DTS packages for data mining.
• Gathering and analyzing user and system specifications.
• Designing MS Access Databases based on those user specifications.
• Designing forms and writing VBA, ADO and SQL code to automate the interaction and management of local and remote data.
• Designing reports using the MS Access reporting tool in combination with VBA so users can run them dynamically.
• Writing VBA code to interact with other MS Office Objects and facilitate the exporting of data to excel spreadsheets.
• Implementing database enhancements on existing database applications, such as maintaining forms, reports and VBA code within existing databases.
• Performing database replication and backups.
• Using other types of software packages such as MS Outlook, MS Visio, MS Excel, and the whole office suite to document existing system processes.
• Working with different departments (Distribution departments) helping them on the usage of new system and office applications.
• Helping users with existing Excel spreadsheets: designing workbook templates and writing basic formulas to perform business calculations.
• Automating Excel spreadsheet applications by coding VBA functions in the form of Macros.

Confidential, Tustin, CA

Visual Basic/ Access Programmer

Responsibilities:

• Designing Databases and Database Applications for the publishing and directory distribution departments.
• Writing SQL Queries using MS Access and MS SQL Server 2000 RDBMS.
• Maintaining 3tier Client/Server Applications using VB 6.0, ADO, and TSQL to manage stored data on SQL Server 2000 databases.
• Adding new enhancements to MS Access database applications, such as designing new forms, queries, and reports.
• Automating Office 2000 Applications such as Excel and Word.
• Writing reports and maintaining existing ones using Crystal Reports 8.0 by querying data through TSQL store procedures in a client/server environment.
• Designing reports from scratch using Crystal Report 8.0 designer environment or report experts to do the formatting of reports and subreports for financial data.
• In addition I also provided Desktop Support and PC repairs within the IT departments.
• Assisting the Senior DBA on administering and troubleshooting clustered SQL Servers. - Assisting the Senior DBA on designing new databases, store procedures, triggers, and DTS packages implemented on SQL Servers.
• Backing up and replicating MS Access 2000 databases.
• Assisting Backup Operators; backing up the network Servers en a daily basis.
• Working with Excel 2000 spreadsheets: Automating Excel workbooks with VBA.
• Maintaining existing Excel files and designing new ones.
• Some traveling to other branch offices.