Andre Satge

ANDRE SATGE 809 22nd Street Union City, NJ- -U.S. Citizen SQL Server DBA, T-SQL Developer, and SSIS / ETL software engineering professional. Vast project experience with implementing, administering and optimizing production SQL Server database systems, with SQL development, data integration, data migration, data analysis, data quality, and with software engineering of SSIS and ETL pipelines and interfaces, Prominent project involvement through all phases of database and software development lifecycle, including design, coding, build, test, implementation, and support. PROFESSIONAL EXPERIENCE MONTEFIORE INFORMATION TECHNOLOGY – YONKERS, NYNov 2017 – Jul 2018 SQL Developer / Software Engineer (Consultant) Designed and developed SQL Server 2016, T-SQL, and SSIS based migration and integration solutions for the healthcare organization. Built SSIS packages to interface between existing provider, member, and claims sources and the new Epic software installation. Tools used included SQL Server 2016, SSDT, Visual Studio 2015, and Team Foundation Server. Profiled and analyzed data for conversion and integration, teaming with SMEs to define business rules, logical mappings, and format specifications (i.e. HL7, HCFA). Coded, debugged, optimized, and deployed T-SQL stored procedures and scripts to support the SSIS interfaces, as well as for daily server administration, and for custom / ad hoc reports, data consolidation, deduplication, and other scrubbing and standardization routines. Fulfilled key roles through all parts of the development lifecycle (requirements gathering, business analysis, data analysis, application design, coding, automation, code review, testing, deployment and maintenance). THE LEADING HOTELS OF THE WORLD, LTD – NEW YORK, NY Sep 2016 – Sep 2017 SQL Server DBA / SSIS Developer (Consultant) Designed ETL framework for implementation of a new BI and data platform for hotel consortium. Converted data from legacy reservation transaction system to Sabre platform. Developed real time feeds, replacing daily ODS snapshots, and making real time data available for reporting and analytics. Created and modified T-SQL scripts and stored procedures to ingest, scrub, and transform data (i.e. address standardization, householding, merge/purge of master data, deduplication, customer attribute reconciliation. Managed database objects, code, schemas, and project tasks and deliverables with Jira and Confluence. Decomposed Web Service APIs, XML schemas, and SOAP messages and performed gap analysis between legacy and future systems and its interfaces. Combined with a detailed discovery and analysis of the existing undocumented custom ETL software, this provided a new transparency to the organization’s data processes. MAIMONIDES MEDICAL CENTER – BROOKLYN, NY Dec 2014 – Jun 2016 SQL Server DBA / SSIS Developer (Consultant) Developed SSIS ETL pipelines and solutions to gather, transform, and output the 145+ structured and unstructured sources of “Meaningful Use” data, and generate and deliver data sets and metrics based on CMS and other regulatory specifications. Developed T-SQL data validation scripts. Built SSIS constructs to extract, cleanse, conform, deduplicate, and load clinical and provider data. Managed project timelines, change control, user training. Ensured code and data exchange mechanisms were in accordance with HIPAA rules. Automated event and error handling, and ETL restarts. Drove overall effort to fruition. Exceeded project goals of 80% ETL automation by achieving 100% end to end automation. PUBLICIS GROUPE – NEW YORK, NY- PARIS, FRANCEMay 2014 – Dec 2014 ETL Developer / SQL DBA (Consultant) Functional, technical, and language liaison between France, U.S. and offshore team for large SAP data migration and conversion of legacy financial and CRM systems. Supported multiple project streams through development lifecycle with teams across various time zones. Worked with functional and technical teams in France to define data mappings, conversion rules, transform logic, error triage, general ledger reconciliation, etc. for the new ETL build. Built and administered Dev and QA server environments and components (SQL Server, SSIS, SSRS, Visual Studio, etc.) Developed T-SQL scripts and stored procedures for address validation, standardization, deduplication, cleansing and to define master data. Converted original VBA code (which only supported Euro currency) to SQL Server platform, with dynamic properties and code enhancements capable of processing worldwide currencies. NYC DEPT OF TRANSPORTATION – NEW YORK, NYJan 2012 – May 2014 SQL Server DBA / SSIS Developer (Contractor) Successfully accomplished enterprise scale SQL Server 2014 upgrade and migration. Coordinated build of new SQL Server instances on VMWare and AWS platforms. Migrated hundreds of critical production DTS packages with complex dependencies to SSIS and Visual Studio platform with no down time. Developed robust SSIS based data refresh processes supporting critical City applications (Permits, Bridges, Sidewalks, Signals, GIS). Developed stored procedure logic and data feed components for the MTA Bus and Subway Time applications. Designed secure data interfaces between DOT and other NYC agencies (DoITT, FDNY, City Hall, etc.). CHRISTIANA CARE HEALTH SYSTEM – NEWARK, DEMay 2010 – Dec 2012 SQL Server DBA (Contractor) Managed and executed SQL Server 2008 server upgrade / migration.  Migrated DTS packages to SSIS. Enhanced high availability features and robustness of backup, restore, replication and disaster recovery processes for the hospital’s mission-critical systems. Built new Reporting Services back end, teaming with front end developers to build, test, and deploy over 150 key reports for staff and management. JPMORGAN CHASE – WILMINGTON, DEMay 2007 – May 2010 SQL Server DBA (Contractor) Completed SQL Server 2005 and 2008 upgrades and migrations for Chase Credit Card division.  Migrated DTS Packages to SSIS. Monitored and administered 24x7 production environments. Enforced stringent JPMC change control, code review, and deployment policies. Implemented disaster recovery solutions. Developed SSIS packages to extract transactional data from Oracle onto SQL Server. Designed complex data refresh and synchronization processes between the environments.  Coded and debugged T-SQL stored procedures, ETL transformations, business rule logic, maintenance procedures, data cleansing scripts. RYAN HEALTH NETWORK – NEW YORK, NY Apr 2003 – May 2007 SQL Server DBA (Contractor) Consolidated and optimized medical claims database systems. Normalized data models, enhanced auditing and security policies, improved recoverability. Developed ETL software, extracting legacy data, applying business rules and other transformations and aggregations. Dramatically improved availability of near real-time data for reporting and analysis.   Built ETL data scrubbing engine, which corrected diagnosis and procedure codes prior to claims submittal, resulting in higher adjudication rates and hence increased State subsidies. EDUCATION Harvard Extension School (Continuing Education) - Cambridge, MAJan ‘2009 – May 2015 Long Island University (Undergraduate) – Brooklyn, NY Jan 1992 – May 1993 Tufts University (Undergraduate) - Medford, MA Sep 1982 – Jan 1985 AFFILIATIONS Institute of Electrical and Electronics Engineers (IEEE) Professional Association for SQL Server (PASS)