SUMMARY:

• Twelve years IT Experience as a Sr. SQL Developer/ETL Developer/BI/ DBA/.NET and other Microsoft technologies.
• Worked on the Data Analysis, design, and development of many database applications systems and Business Intelligence reporting systems by using full Microsoft SQL Server stack such as Creating ETL Tools using SSIS, TSQL, and .NET C#.
• Designing and implementing full business intelligence systems or expanding existing ones. This included designing and implementing Data Stores, Data Warehouses (based on the Kimbal’s Methods), implementing ETL tools, Data quality Services (DQS) for data cleansing and formatting, designing and implementing different types of reports using SSRS, tabular, master child, mapping, flat format, and interactive reports, implementing visualization tools such as tableau for upper management (measuring business KPI’s).
• Experience in 3 tier database design applications utilizing MS Visual Studio for writing middle tier components, dlls.
• Designing UI forms utilizing MS Access as the front end, ASP.Net, Windows Forms. With SQL Server on the Back End.
• Designing and maintaining ASP.Net MVC applications for the UI framework by utilizing languages such as, C#, Linq, ADO.NET, .NET framework 3.5, 4.0, 4.5. Using different versions of MSVS. Designing and implementing databases in different versions of SQL Server, 7.0, 2000, 2005, 2008, 2008R2, 2012, and the latest SQL Server 2014.
• Writing lots of TSQL Code, UDFs, Stored Procedures, custom inline code and had hoc SQL reporting. Maintenance, integration, and customization of different CRM systems.
• Familiarity with SQL Database system out in the cloud. Familiarity with administration of Tableau Servers. And Tableau site design to implement Tableau reporting projects. Familiarity administering SSRS server and SSIS servers, and SSAS servers.
• Experience administering SQL Servers and databases for performance, hardware and software configurations, designing and implementing Disaster recovery methodologies, and implementing availability topologies, such as Mirroring, Log Shipping, Replication, clustering Services, and the latest, AlwaysOn availability groups in SQL Server 2014.
• Design and implementation of SQL Server upgrades and database migrations.
• Experience on working with Windows server implementations, installations, configurations, and aiding of third party software installations and upgrades. Experience in upgrading and patching Windows and SQL Servers.
• Experience on requirement gathering and customer service help desktop support. Experience leading projects and meeting death lines, putting teams together, such as a Business Intelligence team.

TECHNICAL SKILLS:

Rdbm Systems: MS SQL Server 7.0/2000/2005/2008/2008 RS/2012/2014. 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 Developer

• 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.
• Designing ETL tools to integrate data from different Oracle, My SQL, DB2, Flat files, CRMS, XML data sources.
• Migration from Oracle and My SQL server databases into MS SQL Server databases using Microsoft migration tools.
• Development and administration of SSRS.
• Working with Kingsway software components for SSIS to integrate, convert, download, upload, and pull different pieces of information from MS CRM System servers.
• Feed CRM databases with data from other sources such as SQL, Oracle, and IBM mainframe data bases.
• Design of ETL SSIS packages to pull data from CRM Database servers and integrate them into our Global Database repository for data warehousing.
• Designing SQL Server database applications from scratch in order to support reports and UI front ends build on ASP.Net and Win forms.
• Design and implementation of SSRS reports with Patient data analysis.
• Design of Drilldown reports, mapping reports, interactive drill down SSRS reports.
• Design Scorecard and KPI SSRS reports.
• 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 T-SQL 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.
• Assisting on Database Monitoring for performance.
• Production Support (providing maintenance, deployments, fixes, patches, and upgrades)
• 24/7 SQL Server Production support.
• 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.
• Basic maintenance for database performance of SQL Azure Databases out on the cloud.
• Troubleshooting of database performance issues on the SQL Azure databases.
• Creating ETL SSIS packages to pull data from SQL Azure databases to feed reporting standalone SQL database servers.

Confidential, New York

Sr. Developer/BI

• 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 ICD-9 codes to new Government Compliant ICD-10 codes for surgical procedures.
• Maintaining SQL Databases out on the cloud (SQL database Azure).
• Writing new SPs and application development on SQL Azure Databases.
• Writing TSQL scripts to migrate data to SQL Azure databases.
• Monitoring and maintenance for database performance on SQL Azure databases.
• Pulling data from SQL Azure databases to integrate new data into our stand alone database repository.
• 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 T-SQL 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.
• Data Analysis and requirement’s gathering (interacting with Customers, Users and Upper management to gather business requirements)
• Data Analysis on legacy systems and old SQL Server versions.
• Documenting business processes and business process flowcharting and logical flow diagrams.

Confidential, San Antonio, TX

Sr. SQL Server Developer/.Net Programmer

• Programming and maintaining existing databases for the Drug Stores/Pharmacies/Drug 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 T-SQL code to extract pharmacies-drug new data files in order to integrate the data into our SQL Server Database repositories.
• Proposed the use of a visualization tool like Tableau and implement some reporting projects once approved.
• Work with other developers on the reporting projects using TSQL, SSIS, SSRS and C#.Net.
• Working on new projects to manage Patient/Pharmacy memberships and Insurance discounts for the purchased and insurance covered drug claims.
• Write lots of T-SQL code to enhance existing Stored Procedures. And implement new coding standards according to company policies.
• Writing and maintaining extensive Stored Procedures, user defined functions for data management and reporting.
• Taking over a big data archival project and extending its functionality by implementing design and code enhancements on SQL Server databases.
• Working on SQL Server application automations for Data and files movement pulling data from other sources such as hubs and ftp servers.
• Of shore product support to India. Working with offshore team on enhancements to a Clearing House product written in SSIS.
• Working on flexible schedule hours for product support, including some remote work for support.
• Troubleshooting performance issues with database processes. And supporting Dev, QA (Test), and production environments during deployments.
• Work with the development team and Business Analyst on designing an application to automate Patient prescription drug re-fills, since this was affecting insurance claims due to not completing re-fills or over-filling 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.
• Working with other Developers troubleshooting and enhancing SSRS reports for upper management.
• Designing all sorts of had hoc reporting for insurance claims and drug/pharmacy claims.
• Team work to analyze and understand business processes with PBS, Farmacies, and switch technology to route drug store data.
• 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 well-formed 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 well-formed documents.
• Creating XML well-formed documents out of Stored Procedures as the based query platforms and format for web based UI tools for Patient-Drag prescription information.

Confidential, Dallas, TX

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

• 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 T-SQL 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

• 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 multi-dimensional 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 T-SQL 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

• 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 T-SQL code for performance enhancements through use of Query Analyzer, Execution Plans’ Analysis, SQL Profiler, and Apex Performance Monitor.
• Database integration from other DB sources (DB2 main frames, Oracle, MySQL)
• 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, Phoenix, AZ

SQL Developer Consultant

• 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 T-SQL 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)

• 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, Los Angeles, CA

Database Programmer/Analyst

• Writing T-SQL 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 T-SQL code.
• Designing DTS packages for ad-hoc 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

• Writing T-SQL 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 ad-hoc 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

• 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 3-tier Client/Server Applications using VB 6.0, ADO, and T-SQL 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 T-SQL 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 sub-reports 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.