We provide IT Staff Augmentation Services!

Sr. Data Warehouse/etl Developer Resume

Ruther Glen, VA

PROFESSIONAL SUMMARY:

  • 12+ years of data driven Software Engineering experience in designing and developing enterprise - level ETL, Analytical and Reporting architecture solutions in Agile environment following SCRUM framework
  • Certified Scrum Master (CSM) with 8+ years of experience working in Agile environment building software application in cross functional teams
  • Extensive experience in designing and developing complex financial Power BI graphical and visualization solutions such as balance-sheet & ledger dashboard, KPI, matrix and parametrize reports using BI tools
  • Experience in Designing, Developing, Testing and Release of the enterprise-level ETL architecture solutions strategy to populate the data from various source systems utilizing Data Vault 2.0 concepts using SSRS, SSIS, Power BI, Tableau & WhereScape RED & 3D, Python, Oracle
  • Provides senior technical leadership to design, architecture, integration and support of the entire data sourcing platform with a focus on high availability, performance, scalability and maintainability
  • Dynamic team player with well- rounded technical knowledge combined with strong work ethics

TECHNICAL KNOWLEDGE AND SKILLS:

Databases: MS SQL Server 2005/2008 R2/2012/2014,2016/2017, Oracle 10/11g, MySQL, Snowflake

Programming Languages: T-SQL, Python, PL/SQL, C, C++, C#, HTML, CSS, XML, Java, PHP

Operating Systems: Windows 7&10, Windows Enterprise Server, UNIX

BI Tools: MS SSIS, SSRS, Power BI, Azure Data factory, MS Visual Studio, Tableau, Informatica PC

Version Control: Team Foundation Server (TFS 2015,2017), JIRA, Visual SourceSafe (VSS)

Data modeling Tools: WhereScape Red & 3D, Snowflake, Erwin 7.2/4.5/4.0, MS Visio

PROFESSIONAL EXPERIENCE:

Sr. Data warehouse/ETL Developer

Confidential, Ruther Glen, VA

Responsibilities:

  • Responsible for designing and developing enterprise-level ETL architecture solutions utilizing Data Vault 2.0 concepts following Agile and Scrum framework best practices
  • Responsible for implementing and managing release processes for code through development, test, and production environments using Team Foundation Server (TFS) as a source code repository and Visual Studio as a Release Management tools
  • Responsible for Leading and facilitating project planning, daily stand-up meetings, reviews, retrospectives, sprint and release planning, demos and other activities as needed with the Scrum Team, Stakeholders and responsible parties including the execution of the deployment Plans and prioritizing the checklists of the backlog items utilizing SCRUM best practices
  • Responsible for gathering the requirements to design and develop complex financial Power BI graphical and visualization solutions such as KPI, balance-sheet & ledger dashboard, PowerPivot, matrix and parametrize reports using Power BI and Tableau
  • Technologies used: WhereScape RED & 3D, MS Azure, SSRS, SSIS, Power BI, TFS, Python, Azure Data factory, Tableau, Informatica, Snowflake, Shell scripting, Oracle, SolarWinds, REST and MS Intune API

Sr. BI/Reporting Analyst

Confidential, Richmond, VA

Responsibilities:

  • Responsible for designing and developing the enterprise-level BI architecture solutions for ETL & Analytical reporting systems using Power BI & Tableau
  • Responsible for designing, developing and maintain analytical reporting systems and stored procedures for various types of complex dashboard and Parameterized reports like drill down, matrix, cross tab, sub report, bar charts using Power BI graphical and visualization solutions and Tableau
  • Responsible for implementing and managing release processes for code through development, test, staging and production environments using Team Foundation Server (TFS) as a source code repository
  • Responsible for facilitating project planning, daily SCRUM stand-up meetings, reviews, retrospectives, sprint and release planning, demos and other activities as needed following SCRUM best practices

Technologies used: SSIS, SSRS, Power BI, Tableau, Informatica, Oracle, Python

Sr. Programmer Analyst

Confidential, Denver, CO

Responsibilities:

  • Worked on multiple client related projects in Application Development, Business Intelligence and Data Warehousing in designing, developing, maintaining and support of web-based Software application
  • Responsible for Designing, Developing and Testing of the Reporting and ETL strategy to populate the data from various source systems in data warehousing projects using BI tools (SSRS, SSIS)
  • Design and developed various types of reports like drill down, matrix, cross tab, sub report, dashboard

Technologies used: MS SQL SERVER 2008 R2 , T-SQL, SSIS, SSRS, Oracle 11g, Cognos

Software Development Engineer

Confidential

Responsibilities:

  • Design, develop and maintain advanced software products for printed circuit boards (PCB) manufacturing, ECAD viewing, collaboration, and documentation utilizing the diverse disciplines of software and algorithm development, data structure, data modeling, and electrical engineering to build world-class applications
  • Designed, developed and maintained Relational databases using C++, MS SQL Server 2005 and OpenGL
  • Analyze the requirement from the customer to add the new functionalities in CAMCAD software

Software Developer

Confidential

Responsibilities:

  • Worked on database applications in designing and creating several reports and reporting templates to support manufacturing/test software used in the development and production of medical devices
  • Responsible for designed, developed and maintained Relational databases using SQL Server 2005
  • Create Cross-Tab, Drill-down, Matrix, Sub-Report, dashboard reports using SSRS, SSIS.
  • Created Complex Stored Procedure, Triggers, Cursors, Tables, Views and other T-SQL Queries

Hire Now