We provide IT Staff Augmentation Services!

Senior Ssis/etl Engineer Resume

Los Gatos, CA

SUMMARY:

  • Highly proficient SQL Server Developer, Data Architect, BI Developer
  • Solid background in relational database design, table design, query/view design, stored procedures, form design, report design, T - SQL, user friendly interfaces
  • Solid development experience with Microsoft BI Stack, SSIS/ETL, SSRS, SSAS
  • A former corporate controller with a strong understanding of the financial side of business

PROFESSIONAL EXPERIENCE:

Confidential, Los Gatos,CA

Senior SSIS/ETL Engineer

Responsibilities:

  • Created Operational Data Store and Business Intelligence system for financial analytics for global operations, using the Microsoft Business Intelligence stack.
  • Integrating data into Operational Data Store using SSIS/ETL for SQL Server. Consolidating financial systems into an integrated analytic system. Converting Oracle, MySQL, and NetSuite data into the Operations Data Store.
  • This involves extensive system analysis, data modeling and data discovery of multiple systems to create a dimensional model for use with Microsoft analytic tools.

Technologies Utilized: SSIS/ETL, SQL Server, SSIS/ETL, MDX, DAX, Power pivot, T-SQL, .NET, Office 365, Azure, Power BI, Hue, Looker, Hive

Confidential, San Francisco, CA

Senior SSIS/ETL Engineer

Responsibilities:
  • Integrating data into data warehouse using SSIS/ETL for SQL Server. Creating Data Warehouse and Business Intelligence system for financial analytics for global operations, using the Microsoft Business Intelligence stack. Consolidating Oracle and Hyperion financial systems into a unified integrated analytic system. Converting Hyperion Essbase cubes to a dimensional model.
  • This involves extensive system analysis and data discovery of multiple systems to create a dimensional model for use with Micro Strategy analytic tools.

Technologies Utilized: SSIS/ETL, SQL Server, MDX, DAX, Power pivot, T-SQL, .NET, Office 365, SQL Server

Confidential, San Francisco, CA

Senior SSIS/ETL Engineer

Responsibilities:
  • Worked on Data Integration using Informatica Cloud, SSIS/ETL and FTP sites. They have a cloud based help desk application. I integrated the cloud based database back end to extract real time and relevant data to be used in the company’s database. This involved SSIS/ETL, data modeling, requirements gathering, and data.
  • Worked with Yardi Voyager for Real Estate and SSIS/ETL and SQL Server Management Studio extracting and integrating data for data consolidations and business intelligence analytics.
  • Worked on process analysis and made recommendations when appropriate for enhancements to systems and processes. Worked on creating and documenting plans to implement enhancements for existing systems.
  • Provided Help Desk support for internal applications.

Technologies Utilized: SSIS/ETL, SQL Server, T-SQL, Office 360, Azure, Yardi, Agiloft, MS Access, VBA

Confidential, San Francisco, CA

Senior SSIS/ETL Engineer

Responsibilities:
  • Using SSIS, SQL Server and Teradata, worked on data warehousing, data architecture, data quality processes, data warehousing design and implementation, table structure, fact and dimension tables, logical and physical database design, data modeling, reporting process metadata, and ETL processes.
  • Used various data sources and databases to blend data in Tableau. Also set up ETL routines to consolidate data into various data marts.
  • Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.
  • SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.
  • Used C# for scripting task in SSIS/ETL, SSAS, SSRS, SSMS and Visual Studio. Linux scripting translation to SQL.
  • Experience designing and developing data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching.
  • Ability to read, analyze and digest what the client wants to accomplish with its data, and design the best possible ETL process around those goals to discover new opportunities.
  • Experience with data modeling, especially using some or all of the following: Unified Modeling Language (UML), including Entity-Relationship Diagrams (ERD), Sequence Diagrams, and Dataflow Diagrams (DFD)
  • Extensive use of SSIS/ETL.
  • I used SSIS/ETL for data warehouse environments accessing Oracle, Vertica, Teradata databases. Created SSIS/ETL packages for cross functional teams, such as email marketing. Implemented SQL Agent jobs and scheduled jobs.
  • Added indexes where appropriate for optimized queries, defrag and rebuild indexes if needed.
  • Experience developing executive dashboards and implementing design requirements based on discussion with an understanding of technical and visual design considerations.
  • Interacted with business users to identify dashboard strategies, report layouts, analysis and presentations.
  • Migrated existing legacy reports into Tableau while building new reports from our formal data warehouse initiative.

Technologies Utilized: SSIS/ETL, SQL Server, T-SQL, Visual Studio, .NET, Azure, Tableau, SSRS, SSMS, Vertica, Teradata, SAS, ERD

Confidential, San Francisco, CA

Senior SQL Server Developer

Responsibilities:
  • As lead SSIS/ETL Engineer I provided an ETL platform for customer analytics, which would be part of the web based customer experience. I automated data integration into a web based analytics tool (BIRST/Tableau) for web based business intelligence, customer dashboards, reports, charts and graphs. And of course this allowed for the customer to filter data, say for a region or the country. They can slice and dice the data on their customer web portal.
  • I also saw the need for a data warehouse and an ODS, Operational Data Store, which I architected and deployed using Microsoft SSIS/ETL. I also initiated the use of SSAS and cubes for the purpose of customer analytics. This was all part of a “platform” initiative to improve overall companywide performance of the application, with the real goal of customer retention. It worked
  • Confidential is a web based event management company (SAS), which is a comprehensive event management platform is built for marketers and event professionals, such as Oracle, Harvard, Microsoft, etc.
  • Extensive SQL Server Management Studio work, involving heavy use of CTE’s, complex query development with outer joins, joins back to CTE’s, inner joins, unions, excepts and intersects.
  • Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.
  • SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.
  • Used C# for scripting task in SSIS/ETL, SSAS, SSRS, SSMS and Visual Studio.
  • I also worked on SQL Server backend architecture and extensive query performance tuning. The queries were initiated from the web interface, so they needed optimal performance to enhance the customer experience, when using the app.
  • All of this done in junction with Business Analysts, DBA and the testing group.

Technologies Utilized: SSIS/ETL, SQL Server, T-SQL, Visual Studio, .NET, BIRST, SSAS, Azure, MDM, DQS, Toad Data Modeler, Tableau

Confidential, Alameda, CA

Senior SQL Server & BI Developer

Responsibilities:
  • Using SSIS/ETL, SSAS, SSRS, SSMS and Visual Studio, I provided Business Intelligence and Executive Dashboards for consolidation of numerous business units within the Confidential Portfolio of Companies. This enabled instant access to information for the entire portfolio of companies, enabling a more nimble and well-informed decision process for the entire enterprise.
  • Developed with SQL Server Management Studio and SSAS cubes for West Coast operations Work closely with developers of the Port Manager software to determine analytics to integrate into SSAS. I worked with Union Contracts to determine labor costs to integrate into SSAS.
  • Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.
  • SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.
  • Worked with Business Analyst to create user requirements and complex queries for data analysis.

Technologies Utilized: SQL Server, MDM, DQS, Visual Studio, .Net

Confidential, San Francisco, CA

Senior SQL Server Developer/Architect

Responsibilities:
  • I used SSIS/ETL for data warehouse environments accessing Oracle, Vertica, Teradata databases. Created SSIS/ETL packages for cross functional teams, such as email marketing. Implemented SQL Agent jobs and scheduled jobs. Used C# for scripting task in SSIS/ETL.
  • Using SQL Server Management Studio created and optimized stored procedures. Troubleshoot pre-existing stored procedures. Create and deploy tables, views, stored procedures, triggers, functions. Make changes on all database schemas with DDL scripts. Work with cross functional teams to architect database designs for custom in house applications. Recommend best practice designs for SQL Server.
  • Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.
  • SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.
  • Used C# for scripting task in SSIS/ETL, SSAS, SSRS, SSMS and Visual Studio.
  • Added indexes where appropriate for optimized queries, defrag and rebuild indexes if needed. Developed complex queries, incorporating CTE’S.

Technologies Utilized: Daily use of T-SQL for schema changes, analytics, BI, data modeling, data cleansing, SSIS/ETL.

Confidential, Redwood Shores, CA

Senior SQL Server Developer

Responsibilities:
  • Confidential Corporation is one of the world's largest suppliers of branded office products, which not many have even heard of. They market products in more than 100 countries through their own sales force and distribution networks. They have approximately 24 different companies, such as Kensington computer products, Wilson Jones, Cambridge, Swingline, Day-Timer, etc.
  • I leveraged SQL Server, SSIS/ETL, SSRS, SSAS and Cubes to consolidate data across the enterprise. SharePoint Server was also incorporated for a complete global solution.
  • With a global data warehouse improved financial understanding of the worldwide enterprise and gave them the ability to streamline operations and effectively compete in a competitive global market.
  • Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.
  • SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.
  • Used C# for scripting task in SSIS/ETL, SSAS, SSRS, SSMS and Visual Studio.
  • I worked extensively with SQL Server Management Studio in a global warehouse environment. I was responsible for setting up and managing connections to ERP systems in Europe, Australia, Mexico, Brazil, Columbia and Asia. I also created hundreds of SSIS/ETL packages to pull data from SAP, Oracle, SQL Server, DB2, Microsoft Dynamics and various ERP systems for data consolidation in the enterprise. Implemented and enforced Master Data Management principles.

Technologies Utilized: SQL Server 2008, SSIS/ETL - BIDS 2008, SQL Server, MDM, DQS, SSRS, SSAS, T-SQL, XML, .Net 4, Stored procedures, Tableau

Confidential, Concord, CA

Senior SQL Server Developer

Responsibilities:
  • As Application Developer I used SSIS/ETL to create database tables and ETL packages to create an Financial Data Mart
  • As Application Developer I used SSIS to create database tables and ETL packages to create a large Data Mart.
  • Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.
  • SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.
  • Used C# for scripting task in SSIS/ETL, SSAS, SSRS, SSMS and Visual Studio.
  • SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type
  • Data conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.
  • Used C# for scripting task in SSIS/ETL, SSAS, SSRS, SSMS and Visual Studio.
  • I also created stored procedures, views and Sql scripts in support of business partners for financial analysis. I created an ASP.net interface. Used ADO to pull data directly into Excel based on multiple criteria selected in the Excel sheet.
  • Reports and calculations were made for reporting rates on interest and mortgages. Worked within a strong environment of Master Data Management while enforcing the Banks data policies.

Technologies Utilized: SQL Server 2008, SSIS/ETL BIDS 2008, SSRS, T-SQL, XML, .Net 4, Stored procedures, VBA, ASP.NET

Confidential, Modesto, CA

Senior SQL Server and SSRS Developer

Responsibilities:
  • With SQL Server Management Studio created SSRS inventory management reports, focused on finding and saving the company millions in proper inventory management. Identified slow moving inventory to facilitate converting it to sold items with SSRS dashboards. Created databases to track project management to help with managing contractors.
  • Projects, hours and billing. Created SSAS cubes for analysis. Also created numerous SSRS reports to implement on the web for various business groups. Modified cubes for reporting
  • Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.
  • SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.
  • Used C# for scripting task in SSIS/ETL, SSAS, SSRS, SSMS and Visual Studio.
  • Used DDL, indexing, stored procedures and tuned queries to improve SSRS performance. Interacted with users for requirements gathering. Used SSIS/ETL to create data stores from diverse data sources. Participated in design meetings and code reviews.

Technologies Utilized: SQL Server, SSIS, SSRS, MS Access, VBA, Visio (Data Modeling)

Hire Now