SUMMARY:

• Exceptional ETL developer with over 12 years of experience in data quality, transformation, reporting development, and SQL Server administration. Professional, self - motivated, organized team player capable of wearing many hats with relational character values. I offer well-rounded practical solutions that correct bottlenecks with parameterized automated solutions. I have a passion for leadership and coding that started from childhood (QBASIC) that transitioned into high school (Clarion) to college (JAVA), to web development (HTML, CSS, JSP, jQueryUI) and now as a professional database engineer (TSQL, SSIS, SSRS, C#).
• Proven ETL and SQL developer with 12+ years of experience
• Data Conversion (Database, Excel, flat files)
• Dashboard and operation reporting
• Import/Export (MSSQL, MYSQL, flat files, excel)
• DB Backup/Restore
• ETL & DB Backup Automation
• Data Cleansing
• C# Script Task & Data Flow Programming
• Excel Spreadsheet Templates
• SSIS Custom Components
• Dynamic SSIS Package Generation
• SQL Database Administration using SQL Server and C#.
• Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Proficient in writing T-SQL Queries, Dynamic-queries, sub-queries, joins complex stored procedures, views, user-defined functions (scalar, tabular), views, cursors, and triggers.
• Experienced with aggregate functions, temp tables, SQL windows functions, derived tables, common table expressions, sub queries, to facilitate efficient data manipulation and data consistency.
• Excellent with XML queries, pivot, unpivot, views, and table functions to reorganize structure into proper conformed input.
• Experienced with Entity Relational diagrams and excellent at maintaining one to many, and many to one relationships with constraints.
• Good at identifying poorly performing joins and skilled at scripting clustered, non-clustered, and column store indexing to improve query performance.
• Skilled improving work efficiency by using stored procedures and dynamicSQL generate useful SQL
• Able to administer MSSQL servers with users, roles, db create, db backup, db restore, activity monitor, job scheduler, packages.
• Owned and maintained SSIS data extractor framework that imports schema and replicates data from a remote server through incremental and full jobs
• Experienced with a vast majority of SSIS Tasks, Components, and connection types
• Experienced with project parameters and parameterizations to deploy the SSIS packages, Import/Export wizard, and the SQL server integration services catalog.
• Good at enumerated file imports for Excel(32 bit driver), CSV, tab delimited, and text qualified.
• Experienced at using C# OOP in script tasks and script components
• Excellent with XML tasks and components using XSD, XSTL, and XPath to transform XML files to conform to the XML source component.
• Experienced at C# development in VS Class Library for creating customized data flow components
• Skilled at using SSIS tasks for file processing or executing external process such as API calls, PowerShell, or executables.
• Good with SSIS error and event handling: precedence constraints, break points, check points and Logging.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Professional report application developer skilled at presentation and layout for notable clients such for Children’s Hospital of Chicago, Wal Mart, ABC, SEGA
• Reports include formal signed documents such as death s, change of custody, and annual dashboard reports. Features include scheduling, parameters, conditional sections, drill-down, sub reports, for all browsers and tablet devices.
• Skilled in analyzing, designing, developing, installing, configuring, and familiar with the report manager settings and permissions. Skilled at resolving any SQL Reporting Service and T-SQL related issues.
• Familiar with the various data design models and data warehouse concepts of star and snowflake schema
• Able to create views, dimensions, and cubes.
• C# custom SSIS custom components used for ETL used with an installation wizard to install the component
• C# web application dashboard to help end users manage (check stats, start, and stop) SQL jobs.
• C# form application that reads excel spreadsheets and convert them into a different format.

TECHNICAL SKILLS:

Formal Programming Languages: JAVA

Reporting: Crystal Reports, Telerik, Strategy Companion

WEB: HTML, CSS(tableless HTML), jQuery, jQuery UI, JavaScript, JSON, JSP, Servlet

Database/Tools: MYSQL, Toad, dbForge

Other: DevOps, SSH, FTP, Linux, Tortoise SVN, Fogbugz, Jira, Tomcat 6, Eclipse

PROFESSIONAL EXPERIENCE:

Confidential, Boise, ID

Sr. ETL Developer

Responsibilities:

• Adaptor Development & Research: Team development for adaptor solutions to import data from popular EMR systems: AllScripts, AriaMO, AriaRO, Centricity, Clarity, FreezerWorks, Intellidose, Lynx Mobile, Metriq, Mosaiq, NextGenEHR, and OncoEMR. Focused on schema, data quality, performance tuning, and location of data. Imported and automated this data into our consortium software solution.
• Automated SQL Server Setup Configuration: Sole developer for the installation model for new client servers. Includes SQL metadata extraction, metadata updates, dynamic SSIS package creation complete with parameterized variables with database connections for full or incremental loads. Improved manual setup from 1 weeks to 1 hour.
• Automated Deployment: Sole developer for deployment model to client nodes with downloads, package deployment, versioning, scripts which are triggered by SQL Agent jobs. Improved workflow from 2 weeks on all nodes to 1 minute.
• Report Logging & Export: Sole developer for operational reporting framework. Created job log framework complete with exception handling and detailed error reporting. Daily/Hourly exports of flat file exports with aggregate report totals to report on data anomalies not caught in job status.
• Report Framework: Sole developer for the ETL operation of all SSRS reports. Created import process for flat file exports from client nodes with logging status. Summarized the tables into traditional fact and dimension tables along with aggregate tables and proper indexing to improve imports and report queries. Also created over 100 drill down reports for monitoring all ETL operations on client nodes. Also developed custom reports for Lurie Children’s’ hospital with iPad interactivity for the PICU and ED departments at Lurie Children’s hospital used by doctors and nurses to monitor Confidential t mortality rates through PIM2, ESAPS, PELOD, and RIFLE scores.
• Flat File Validation Framework: Developed SSIS custom component data flow parser for VCF (Varient Call Format) files and redirecting the output to relational database. Include file validation with automated success and error alerts for automatic uploads

Confidential, Morgan Hill, CA

Product Developer

Responsibilities:

• Involved in all roles of the software development process
• Primary web/database design & developer for new and existing systems
• ETL developer for data conversions from various database systems into MSSQL database
• Managed software releases and go-live dates
• Expert formal report developer SSRS/Crystal Reports
• On site requirements gathering, wireframes, schema design
• Analytical QA and bug tracking skills
• Deployments, maintenance, and module updates
• Project management contributions for new and existing projects

Confidential, San Jose, CA

Database Engineer

Responsibilities:

• Designed schema and implemented entire database reporting services environment
• Improved query performance by indexing summary tables
• In charge of data cleanup scripts to clean up report data caused from production bugs.
• Primary report builder for both SSRS reports and data warehouse reports (Strategy Companion) for B2B, B2C and the executive staff.
• Contributed to replication between database servers along with replication data migration between database and report servers.
• Created process for all dashboard tools, reports, content, and device configurations from the ground up with wireframes.
• Documented and created operational processes for mobile content and devices
• Managed content operations, deployments and releases. Hired, and built the operations team from the ground up
• Basic test and deployment engineer with all project releases that relate to MT, MO, SMS, PSMS, and Content Delivery services.

Confidential, San Jose, CA

Owner/Developer

Responsibilities:

• Customized registration setup with price points, coupon codes, and PayPal integration
• Facebook integration (likes and share)
• Multiple account groups
• Separate user interfaces for league, administration, coach, and referee roles
• Manage contacts, login permissions, teams, divisions, and games, game scheduling, referee, and results
• Includes player card reports, exports, and system management functions
• View games that are assigned to the referee
• Submit scores which formulate to standings and statistic leaders