We provide IT Staff Augmentation Services!

Lead Etl Designer/developer Resume

New York, NY

SUMMARY:

  • Business Intelligence Lead/Developer, ETL Developer
  • Cloud Engineer
  • SQL Server, Oracle and Sybase database design & implementation experience
  • Significant ETL process design and implementation experience
  • Report design and development experience
  • Financial services industry experience (Equity Derivatives, Fixed Income, Repos, Securities Lending)
  • Insurance industry experience

TECHNICAL SKILLS:

Cloud: Amazon Web Services (AWS), Amazon Relational Database Service (RDS), Amazon Elastic Compute Cloud (EC2), Amazon S3, Amazon Simple Workflow Service (SWS), Amazon DynamoDB, AWS Elastic Beanstalk, AWS CloudFormation, AWS Identity and Access Management (IAM), Amazon Virtual Private Cloud (VPC), Cloud Security

Databases: Microsoft SQL Server (2016, 2012, 2008/R2), Oracle

Operating Systems: Windows, LINUX/UNIX

Languages: Microsoft (MS) SQL Server BI platform, SQL Server Integration Services/Analysis Services/Reporting Services (SSIS, SSAS, SSRS), .NET, SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), Business Intelligence Development Studio (BIDS), Visual Studio, Team Foundation Server (TFS), SharePoint, Power BI, Data Mining, Red Gate, SQL/T - SQL, C#, SVN, Tidal, PL/SQL, PL/SQL Developer, Power BI, Tableau

Other: Business intelligence and data warehouse (DW) solution design & implementation, Business Analysis, Relational and OLAP database design & implementation, Data Warehousing, Decision Support, ETL, Data architecture, Data Management, Business Process Management, Logical & physical data modeling, Dimensional modeling, Reporting & analytics, Data quality, Data cleansing, / Master Data Management (MDM), Software engineering, Software Development Life Cycle (SDLC), Agile software development, Query optimization, Performance tuning, Disaster recovery (DR), Microsoft Certified Professional (MCP), Cloud, Workday, Murex, Jenkins, Continuous Integration

PROFESSIONAL EXPERIENCE:

Confidential

Lead ETL Designer/Developer, New York, NY

Responsibilities:

  • Interfacing and collaborating with management, stakeholders and peers.
  • Converting complex business requirements into technical solutions.
  • Leveraging/cloning fixed income processing suite for equity derivatives purposes.
  • Solution design, implementation & automation incl. creation/maintenance of database objects (e.g. tables, views, stored procedures, functions) and ETL processes featuring:
  • Extensive use of complex, high performance stored procedures.
  • SSIS incl. use of:
  • Script tasks.
  • Property expressions.
  • Configurations.
  • Troubleshooting, performance tuning.
  • Process automation using Tidal.

Confidential

Business Intelligence Lead, Princeton, NJ

Responsibilities:

  • Interfacing and collaborating with management, stakeholders and peers.
  • Manage and lead projects incl. working w/ offshore teams.
  • Requirements gathering, analysis and documentation.
  • Solution design and implementation.
  • Design and development of solutions incl. database objects (tables, views, stored procedures), reports/visualizations using SSRS, Tableau and Power BI. ETL processes using SSIS incl. use of:
  • Script tasks.
  • Property expressions.
  • Configurations.

Confidential

Lead ETL Designer/Developer, Mount Laurel, NJ

Responsibilities:

  • Requirements gathering, analysis and documentation.
  • Interfacing and collaborating with management, stakeholders and peers.
  • Solution design improvement.
  • Performance tuning.
  • Design and development of solution incl. database objects, ETL processes using SSIS incl. use of:
  • XML files.
  • Script tasks.
  • Property expressions.
  • Configurations.

Confidential

Business Intelligence Lead/Developer, New York, NY

Responsibilities:

  • Requirements gathering, analysis & design, development & implementation, support & documentation.
  • Interfacing and collaborating with management, stakeholders and peers.
  • Architecture, design and development in all areas of solutions incl. data warehouse, ETL processes, report production
  • Disaster recovery (DR) implementation
  • Design, development and implementation of the data warehouse incl.:
  • Dimensional data model.
  • ETL processes using SSIS incl. use of:
  • Script tasks/components.
  • Property expressions.
  • SSIS configurations and logging.
  • SCD (slowly-changing dimension).
  • Design and development of reporting suites (using SSRS) leveraging the data warehouse and providing following functionality:
  • Reporting and analysis of repo and securities lending data (incl. reconciliation against the general ledger).
  • Risk Weighted Asset (RWA) Calculations.
  • Management Reporting suite combining general ledger and timesheet data to provide additional perspectives and analysis vs. GAAP reporting, incl. reporting/analysis by business units and cost centers.

Confidential

Business Intelligence Lead/Developer, New York, NY

Responsibilities:

  • Requirements gathering, analysis and documentation.
  • Architecture, design and development of BI solution incl. data warehouse, ETL processes, OLAP cube/UDM, report production.
  • Design and development of dimensional model for data warehouse incl. definition of measures, dimensions, hierarchies, etc.
  • Design and development of ETL processes using SSIS.
  • Design and development of SSAS OLAP cube/UDM database including:
  • Maintenance of dimensions, measures and measure groups.

Confidential

Business Intelligence Lead/Developer, Florham Park, NJ

Responsibilities:

  • Development and maintenance of data warehouse objects and ETL processes using SSIS, including:
  • Dimensional modeling/data warehouse design.
  • Multiple source data integration/Master data management (MDM).
  • Development and maintenance of SSAS OLAP cube databases including:
  • Maintenance of dimensions (incl. regular, and many-to-many dimension relationships, attribute relationships and hierarchies).
  • Maintenance of measures and measure groups.
  • Development and maintenance of production reports/dashboards for BI portal.

Confidential

Principal, Edison, NJ

Responsibilities:

  • Developer and author of class content, class software and user manuals covering how to use all components of the Microsoft SQL Server BI platform, i.e.:
  • Integration Services (SSIS).
  • Analysis Services (SSAS - Multidimensional data).
  • Reporting Services (SSRS).
  • Data Mining.

Confidential

Software Developer/Business Intelligence Architect, New York, NY

Responsibilities:

  • Work with Business and Technology groups to design solutions that meet their needs.
  • Participate in all phases of SDLC incl. working with stakeholders and peers in identifying and defining requirements.
  • Design and implementation of BI solutions using SQL Server platform for financial and CRM functional areas incl. relational data warehouse & OLAP databases incl. dimensional data warehouse design.
  • Design and implementation of reporting/analytics solutions

Hire Now