SSIS Architech Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

David Katona

25 Glass Window Court East

Reston, NE 20411

Tel 735.711.9244

Dkatona97@gmail.com

Microsoft database systems professional with 18+ years technical contracting and consulting experience in various industries –Finance, Government, Health Care, Software, Law - with expertise in: SQL Server 2008 R2Database Administration, T-SQL Programming, Integration Services, Analysis Services, Reporting Services, DTS, High Availability, ETL, Performance Tuning, Data Modeling, Data Architecture

HEALTH RISK PARTNERS – RICHMOND, VA                                                                 Oct ‘11 – Present

ETL/ SSIS ARCHITECT (contractor)

·         Supported startup medical claims processing venture to release software product by year end.  Designed SQL Server SSIS Packages to Extract, Transform, Load and process Medicare Claims in SQL Server system with output to government agencies.  Coded SQL to reflect business rules and properly adjudicate claims.  Optimized and tuned stored procedures and UDFs.  Managed change control between server environments for all developers.  Developed error handling routines and treatment for invalid claims. 

·         Tools and Methodologies: Data Extraction, ETL Coding (SSIS, SQL Server 2008 R2, Visual Studio 2010, Team Foundation Server, Performance Tuning , Data Validation, Medicare Enrollment Reconciliation, Payment Reconciliation, Data analysis, Compliance, Regulatory Reporting

WASHINGTON GAS – SPRINGFIELD, VA                                                                      Jan ‘11 – Oct ‘11

SR SQL SERVER DATABASE ENGINEER (contractor)

·         Assessed SQL Server environment, creating Consolidation Strategy to migrate and upgrade SQL Server 2000 and 2005 instances and databases onto clustered 64-bit High Availability platform running SQL Server 2008 R2.  Devised and implemented Disaster Recovery Solutions with standby servers, Log Shipping, Database Mirroring, Backup and Recovery Plans, etc.

·         Worked with Application teams to identify database dependencies and create test plans for the upgraded hardware and software.  Managed redirection of Web applications and Reporting interfaces.Solely responsible for all aspects of the project from planning, through coordinating resources, through implementation.

·         Migrated Analysis Services and Reporting Services environments.  Redesigned DTS packages for 2008 Integration Services from scratch; optimized existing SSIS packages. 

·         Performed exhaustive parallel systems testing; utilized Red GateSQL Compare for data comparisons, designed custom refresh mechanisms with SSIS.  Developed ETL processes as needed, extracting and transforming data from various sources: Teradata, FTP, IBM DB2, Oracle, flat files, etc., to feed into de-normalized reporting structures.

·         Provided DBA programming, administrativeand technical support; standardizing maintenance and monitoring tasks, notifications and alerts.  Incorporated new management and programming features of SQL Server 2008 for enterprise-wide use, especially (Resource Governor, Data Encryption, Data Compression, Security Auditing, etc.)

CHRISTIANA CARE HEALTH SYSTEM – NEWARK, DE                                      May ‘10 – Dec ‘10

SR SQL SERVER DATABASE ENGINEER (contractor)

·         Migrated and upgraded Health Systems databases and data warehouses from SQL Server 2000 32-bit to SQL Server 2008R264-bit architecture on Windows Server 2008 R2.

·         Fulfilled new high availability and disaster recovery needs with a combination of Failover Clusters, Database Mirroring, and custom Log Shipping.

·         Utilized Visual Studio2010,Team Foundation Server, and SharePoint, ERwin, and MS Visio 2010 to create, manage, deploy and document the database builds throughout the new environments.  Built logical and physical data models, creating readable diagrams depicting tables, relationships, and keys.  Managed change control processes initiated by the check-in process in TFS, approving DDL implementations, and pushing all code through the Visual Studio Database Build.

·         Performed in-depth SQL Server Backwards Compatibility analysis and testing; debugged all database issues, SQL code,and operational DTS and SSIS packages.  Modified complex nested SQL Agent Job steps laden with hard coded server and file system references,pluscross-server and cross-database dependencies.  Createdparallel environments for functional and performance Test and QA,mitigated the challenges of maintaining synchronized real-time data in both. 

·         Utilized third-party products( Red Gate, Erwin and MS Visio),and custom code, for data comparison, validation of row counts, dependency analysis, and forward / reverse engineering of data models.

·         Migrated DTS Packages to Integration Services Packages.  Improved data flow logic and workflow to optimize parallel processing.  Wrote packages to extract, convert, transform, and load mainframe data sets.

·         Defined synchronization, backup / restore, and capacity planning strategies for large dispersed critical hospital databases having complex interdependencies.Developed and promoted implementation of enterprise standards for new SQL Server 2008 R2 features to improve management of DBA responsibilities, such as Policy Management, SQL Server Audit, Data and Backup Compression, SQL Encryption, Resource Governor, etc.

BANK OF AMERICA–    WILMINGTON, DE                                                                     Jun ‘09 – May ‘10

SR SQL SERVER DBA/ ETL ARCHITECT (contractor)

• Designed SQL Server 2008 SSIS Data Conversionpackages to extractand isolate sensitive customer data from existingshared application platform to a new dedicated server and application environment.  Finalized physical database design, built staging environment.  Developed SSIS packages with complex and dynamic Stored Procedure logic, transformations, conditional logic, parallel data flow pipelines, etc. to automate and validate all converted data.
• Planned architecture and storage capacity for database components; built and configured SQL Server 2008multi-instance clusters for Development, QA, Test, and Productionenvironments.
• Combined Disaster Recovery and Reporting Servicessolution into one environment utilizingSQL Server Log Shipping.  Redesigned existing Table and View definitions, incorporating complex security features and permissions based on interwoven group, user, and analytical requirements, while addressing performance, aggregate calculations, and de-normalized output requirement challenges.
• Managed all database DDL and DML script creation and implementation through all environments.  Identified and tuned criticalProduction environment stored procedures and indexes based on changing business rules.  Created complex rollback mechanism for mitigation readiness.  Enhanced and automated enterprise-wide corporate data directory and daily data feed, which was the basis for security sensitive permissions company-wide for tens of thousands of users.
• Worked closely with developers to fulfillaggressive code deliverables, particularly in conforming table attributes and structure, tuning SQL in application code, reducingserver round trips, debugging stored procedure code and Visual Studio project builds, eliminating cursors, constructing SSIS data flows, etc.

JPMORGAN CHASE – WILMINGTON, DE                                                                       May ‘07 – May ‘09

SR SQL SERVER DBA (contractor)

·   Accomplished large scaleSQL Server 2005 server upgrades and migrations across all database environments of Chase Credit Card Services.  Planned consolidated server architectures, disk subsystems and SAN allocations; implemented clustered, multi-instance servers, supporting terabyte size databases.

·   Built SQL Server 2008high availabilitysolutions, designing and managinginstances employingFailover Clustering, Log Shipping, DatabaseMirroring, and SQL Server Replication.

·   Fulfilled 24x7 on-call production support and administrative duties to sustainhighly available and secure mission critical database systems.  Worked with complex backup, security, audit, asset management, and other third party software.  Performed code review and change implementations.  Generated performance metrics, conducted data analysis, designed reports, managed customer relations.  Designed and implemented disaster and data recovery solutions in accordance withService Level Agreements (SLAs).

·   Worked with developers throughout the SDLC, ensuring efficiency and consistency in database and SSISdesign, in stored procedure and SQL programming, and in change control.  ConvertedDTS Packages to SSIS, programming automation (self-healing error treatment, retry logic, wrappers) in scheduled processes.

SCHOOLNET, INC – NEW YORK, NY                                                                            May ‘05 - May ‘07

SR SQL SERVER DBA(contractor)

·   Provided SQL Server 2005 administration, architecture and programming for growing educational software startup.  Managed hosted database servers and web sites for large school districts nation-wide.  Responsible for all database installations, web site data, and adherence with stringent SLAs. 

·   Performed server upgrades and migrations for Development, Test, QA, and Production environments.  Built Failover Clusters housingdatabases, applications, and BI stack components (SSRS, SSIS, SSAS).  Distributed data to clients using all methods of SQL ServerReplication (Snapshot, Transactional, Merge).

·   Coordinated stress tests and server baselining to ensure high performance for thousands of user connections.Teamed with network / web administrators on hardware capacity planning, maintenance, design, and software releases.  Enforced change control.

·   Developed and reverse engineered data models, logical and physical design, utilizing ERwin and Visio.

·   Resolved stability issues affecting production database servers.  Corrected physical design inefficiencies and redundancies; created proactive systems monitoring and alerts, with self-healing mechanisms.  Enforced Change Management policies for databases, servers, and application version control.

RYAN HEALTH NETWORK - NEW YORK, NY                                                                 Apr ‘03 - May ‘05

SR SQL SERVER DBA / ARCHITECT (contractor)

·   Supported SQL Server and Mainframe based Medical Claims database systems.  Optimized SQL Server environment with server consolidation, normalization, security policy enhancement, improved data recoverability, performance tuning, and data and security auditing mechanisms.

·   Constructed complex hierarchical extractsfrom legacysystems into conformed relational and dimensional SQL Server structures.  Enabled near real-time analysis and reporting capabilities with newly designedETLprocesses, Analysis Services Cubesand Reporting Services Reportson the front end.  Resolved data issues related to State regulatory compliances.

·   Conducted production code reviews.  Instituted new agency-wide database standards / naming conventions.  Redesigned mainframe extracts by conforming attributes across business units; added event and error handling logic to comply with HIPAA rules.  Created and maintained ETL processes for data warehouses and OLAP environments.  Maintained tables, loaded facts, dimensions, derivations, aggregates, history, etc. to support Analysis Services cubes, dimensions and other presentation layers.

·   Designed and coded a DTSbased pre-processing “engine” and data cleanser, which analyzed and adjusted Diagnosis and Procedure Codes, a previously lengthy manual process, resulting in speedier claims adjudications, higher approval rates, and improved State rankings and subsidies.

IBM CORP / JOHN HANCOCK FINANCIAL SERVICES– STERLING FOREST, NY May ‘00 – Apr ‘03

DATABASE ENGINEER (contractor)

·   Under IBM’s Global Services, built and hosted high availability SQL Server clusters for John Hancock,and other major clients.  Provided 24x7 remote production database and cluster support and performance monitoring.  Managed change control between development, test and production.

·   Consolidated SQL Server environments onto ClusteredWindows 2000 Advanced Server / SQL Server 2000 platforms.  Designed conformed dimensional schemas for data warehouse loads.  Wrote data cleansing routines and other ETL processes with DTS and Microsoft BI Accelerator.  Built cubes and dimensions with SQL ServerAnalysis Services, enabling analytical capability which uncovered new bargaining potentials with raw material vendors based on data now combinedacross U.S. regions.

·   Migrated database systems from legacy COBOL platform to Windows /SQL Server.  Translated hierarchical data structures into relational models.  Worked with developers through physical design iterations. Planned and implemented comprehensive change control and security models, resulting in noticeably improved application and performance stability. Assisted developers with writing T-SQL stored procedures for new Visual Basic and Web front ends.  Also developed back end batch processes and ETL procedures with DTS.  Built stand-by servers withSQL Server Log Shipping.

STATE OF MASSACHUSETTS- BOSTON, MA                                                    Feb ‘98 - May ‘00
SQL SERVER DBA (contractor)

·   Performed database hardware and software upgrades for State Agencies (Division of Registration, Board of Medicine, Dept of Energy, City of Boston, State Laboratory, Office of Consumer Affairs). Migrated production systems from Alpha to Intel platforms with near zero downtime.  Upgraded Windows NT servers and SQL Server databases, modifying T-SQL syntax for compatibility. Normalized logical models, re-designed physical structures, table partitions and RAID subsystems.  Led System, User, and QA testing.

·   Implemented SQL Server Replication to isolate OLTP and OLAP environments. Built further high availability with SQL ServerFailover Clustering.

·   Resolved critical database performance problems for Visual Basic / SQL Server Newborn Baby Screening Application at the State Laboratory, optimizing stored procedures, cursors, triggers, indexes, views, etc. alleviated concurrency issues, enhanced security model.

·   Scaled agency data warehouses; implementedmore data granularity for drill-down analysis, added logic to handle slowly changing dimensions and historical data. Significantly enhanced ETL processes in DTS.  Optimized hardware and tuned procedure code to achieve order of magnitude performance gains.

FIDELITY INVESTMENTS - BOSTON, MA                                                                      Aug ‘95 - Feb ‘98
PL/SQL PROGRAMMER / ANALYST (contractor)

·   Developed Dimensional Data Models and Schemas for enterprise Finance Data Warehouse project. Optimized SQLcode, indexes, materialized views and browsing capabilities; improving workflow processing for Oracle Financials modules and Oracle Discoverer reports.  Created metadata repositories, and designed complex transformations. Optimized PL/SQL code to extract large data sets from remote servers and multi-platform sourceswithin narrow maintenance windows.

·   Served as the key liaison between Systems and Finance business units, ensuring proper translation of business requirements, and facilitating logical and physical development of business rules and data elements.

·   Extracted Web logs and clickstream data, profiling user activity, product sales, demographics, etc.

STAPLES, INC - FRAMINGHAM, MA                                                                              Jul ‘93 - Aug ‘95
SR. TECHNICAL SPECIALIST - PC/LAN

·   Administered large Windows NT network, supporting rapidly domains. Maintained accounts, shares, security, printers, & other services. Managed IP subnets, address allocation, name resolution services, andCitrixhost connectivity between IBM AS/400, UNIX, and Windows environments.

·   Responsible for installation and upkeep of network hardware (cabling, hubs, switches, routers, etc.). Built database, remote access, and application servers.

BAKER & MCKENZIE, ATTORNEYS AT LAW - NEW YORK, NY                          Aug ‘89 - Jun ‘93
SYSTEMS ADMINISTRATOR

·   Maintained LAN containingSQL Server, Sybase, HP/UNIX and Wang servers running on Banyan Vines. Performed daily administrative / upkeep routines and global e-mail replication.  Supervised operators. 

·   Provided performance tuning and troubleshooting for server components and disk clusters. Maintained network hardware infrastructure.

TSI, INC - NEW YORK, NY                                                                                            Apr ‘85 - Jul ‘89

COMPUTER SPECIALIST

·   Installed, configured and supported desktop and server hardware, software, operating systems, and databases for major corporations: AT&T, Goldman Sachs, Air France, Merrill Lynch, American Express, Chemical Bank, Hospital for Special Surgery, Blue Cross.

 

EDUCATION

Harvard University(Extension School) Cambridge, MA                                                    Jan ‘09 - Present
Long Island University(Undergraduate) – Brooklyn, NY                                       Jan ‘92 - May ‘93
Tufts University(Undergraduate) - Medford, MA                                                    Jan ‘82 - Jan ‘85

PROFESSIONAL AFFILIATIONS

IEEE (Institute of Electrical and Electronics Engineers)

IEEE Delaware Bay Section

PASS (Professional Association for SQL Server)

Harvard Extension School Association

Tufts Alumni Association

Download Resume Format