available afternoons available evenings available mornings education completed: masters
QR Code Link to This Post
SQL SERVER, SSIS, SSRS, T-SQL Developer
REMOTELY ONLY. NATIONWIDE. ANY US TIME ZONE
Accomplished SSIS ETL, SSRS Reporting, TSQL Developer
PROFESSIONAL EXPERIENCE's SUMMARY
Extensive experience in
-- identifying, documenting, developing, implementing, and validating business requirements, extensive in depth researching, documenting, developing and implementing data lineage and data mapping with complex business and technical requirements for OLTP, OLAP, DW environments for high-volume transactional and analytical systems in the banking, health management, securities trading, credit card, and other industries.
-- building automated data quality verification systems for ETL, Data Warehouse, and analytical solutions.
-- Adept in being part of and leading off-site/off-shore teams that spanned different continents.
SQL Server 2019 (and prev), SSIS/VSTA/C#, SSRS, TFS, SharePoint, T-SQL, SSDT/VS INTEGRATED SHELLS, TFS, REDGAGE, COGNOS IBM DATA MANAGER, ORACLE, PL/SQL, JIRA, GIT, LINUX
May 2017 – current: Health Care /HMO Provider, Oakland
Senior Staff ETL Developer, Financial and Operation Services
Design, development, performance tuning, production support and maintenance, production issue(bug) fixes and emergency overnight patches to the business critical SSIS ETL processes.
Contributing to the conception, design, and development of a FOS Data Warehouse - from the database modeling and design to the upstream and downstream ETL processes development that collect the company’s financial and operation data hosted on the mainframe and linux-based DB2 and SAS, ORACLE, HADOOP,TERADATA and other upstream source systems, as well as the ones that feed the downstream data-mart systems. Recovering and improving the legacy upstream systems data flows and underlying data lineages; intense/in depth collaboration with the data consuming entities.
Microsoft SQL Server 2019, T-SQL, SSIS, SSRS, VS 2017 (SSDT), IBM DATA MANAGER, GIT
Feb 2016 – May 2017: BEBE Design Studios, Inc. and Dorfman Pacific, Inc.
ETL and Reporting Systems Designer and Developer
Design, development, and implementation a OLTP to OLAP and OLAP to DSS ETL solutions, the DW and the DS Reporting System.
Converted 40+ legacy (ACCESS-based) reports to SSRS reports
Environment: SQL Server 2012, SSIS, SSRS, SharePoint, T-SQL, VBS, LINUX
Feb 2016 - Feb 2017: First Republic Bank
Senior Data Warehouse ETL Developer
Design, development, enhancement of the ETL solutions for transferring data from the various business lines from the existing FRB banking platform to the new one.
Environment: SQL Server 2012, SSIS, T-SQL, #C.NET, TFS, SQL Server Data Tools
Apr 2015 - Feb 2016 Pacific Pulmonary Services, Inc
Data Solutions Senior Consultant
Design, development, implementation of the Operational Data Store and the ETL system for populating it; performing the task of a data modeler, a database architect, an ETL designer and developer, a reporting layer designer and developer.
The system provides a daily processing of 40+ flat files that are FTP-ed in and put through a multi-step transformation process that delivers their information to the data warehouse and the subsequent reporting layer database.
Environment: SQL Server 2012, SSIS, SSRS.
May 2014 - Apr 2015 Rodan + Fields® Dermatologists
Senior Data Solutions Consultant
Development and maintenance of the R&F Uni-level Breakaway Hybrid Compensation Plan (ULBHCP) SSRS-based reporting solution - developed and/or enhanced 40 reports, including development and performance tuning of the underlying SQL SERVER TSQL stored procedures.
Development and maintenance of the ULBHCP automated data quality validation solutions of the ETL system that delivers the R&F E-Commerce data to the ULBHCP reporting layer database, automated the data quality verification process of major data inflows, such as the account management, order processing and cancellation, product inventory maintenance.
Researched, analyzed, and addressed the R&F ETL and reporting layer's flaws, performance bottlenecks
Extensive regular communications with the ULBHCP business analysts over new and change requests for new and existing SSRS reports, improvement of the end-user experience.
Environment: SQL SERVER 2012, SSIS, SSRS, Microsoft SQL Server Management Studio 11.2, RedGate DB Tools, Microsoft Visual Studio 2013
Dec 2012 - May 2014: CalCPA - California Society of CPA
Member-based non-profit organization of the California CPAs
Business Analytics and Applications Lead Developer
Led a DEV/BA team of 3 people
Developed, maintained and expanded the data management solutions for heterogeneous data silos/database systems residing in SQL SERVER 2005, 2008r2, SQL SERVER 2012, SALES_FORCE Cloud solution
Built and maintained data interfaces between various data nodes to assure timely synchronization of the business critical information across the company-wide topology
Developed custom ETL and Analytical solutions to support strategic business planning and decision making processes
Identified and resolved data quality issues in partnership with business owners and external vendors
Supported the UAT activities; assured sufficient quality data for productive UAT cycles, resolved data issues and addressed/fixed defects found
Reviewed and assessed technologies/solutions provided by external vendors to ensure smooth integration with the existing CalCPA ones
Provided/created business analysis, formal specifications, implementation and post-implementation and production support for the in-house reporting, analytics, and data synchronization solutions
Participated in and contributed to the Change Control and Management Decision activities by providing business and systems justification for proposed change requests.
Environment: SQL SERVER 2008, SQL SERVER 2012, SSIS, SSRS
Mar 2012 - Dec 2012: DBBest Technologies, San Francisco, CA
Senior Consultant for AUTODESK EIS
Development, enhancement, tuning of the data access layer; providing the data to the consuming Web Services; development of stored procedures, triggers, finding/addressing custom ETL performance bottlenecks and functional deficiencies, data related maintenance, data quality, data cleansing; queries performance tuning / optimization.
Environment: SQL SERVER 2008, T-SQL, O_RA_CLE 10, PL/SQL.
Apr 2010 - Mar 2012: Wells Fargo - San Francisco, CA
Bank Secrecy Act and Anti-Money Laundering (BSA/AML)
ETL, Data Warehousing and Analytics Systems' Test-Ware QA Lead Developer
Development of test-ware for verification of the vendor-specific and in-house ETL solutions developed for collecting money movement transactions within, between, in and out of various Wells Fargo divisions (retail banking, wholesale banking, investment management, securities trading) and accumulating these transactions in the centralized EDW for analysis, interception, and reporting those individuals, organizations and institutions that did not comply with the BSA/AML rules and regulations to the federal government.
My solutions were also used to validate the correct implementation of the latest BSA/AML requirements monitoring via a Fortent/Actimize custom fraud prevention monitoring UI tool for the Wells Fargo fraud prevention specialist, and some other in-house systems, which obtained the information directly from the EDW or from downstream Data Marts.
Environment: UDB, SQL SERVER, D_B_2, O_RA_CLE, TE_RA_DA_TA, UNIX, WINDOWS, MAIN_FRAME
Wells Fargo Bank - San Francisco, CA Oct 2009 - Apr 2010
Data Migration; Data Quality Solutions Lead Developer
Data Analysis, Data Mining, Data Profiling, Development of the test-ware for verification of the IN_FOR_MA_TI_CA-based ETL for migrating Wachovia's data into the Wells Fargo target data silos.
Environment: O_RA_CLE 10, SQL SERVER 2008, PL/SQL, T-SQL
(prior professional/work/experience history is available upon request)
(professional references available upon request)
MS in Math
OK for recruiters to contact this job poster.
do NOT contact me with unsolicited services or offers