We provide IT Staff Augmentation Services!

Etl/ Bi/ Database Developer Ii Resume

4.00/5 (Submit Your Rating)

MO

Hire Now

SUMMARY:

  • Passionate, responsible and committed engineer with 5+ years of Software Development experience in designing, implementing and adapting Data Warehousing technologies.
  • Hands on Working experience in SQL, PL SQL, Tableau, SQL Server, Vertica, Business Objects.
  • Deep understanding of the Relational Data Warehousing, ETL Architecture and Business Intelligence.
  • Extensive Experience in Data modeling, Data Integration, Data Migration, Query Optimization and Performance Tuning, Relational, Dimensional, Star and Snowflake Schema, Stored Procedures, Functions, Views, Triggers, Cursors.
  • Exposure to Informatica Power Center, SSIS and SSRS.
  • Strong Understanding of Data Visualization concepts and working knowledge of SAP Business Object 4.1, Tableau Desktop, Tableau Server and Qlikview.
  • Superior communication skills, strong decision making and organizational skills along with outstanding analytical and problem solving skills to undertake challenging jobs. Able to work well independently and in a team by helping to troubleshoot technology and business related problems.
  • Worked in Scrum, Kanban and Pair programming agile environments.

TECHNICAL SKILLS:

Programming Languages: SQL (Proficient), PL/SQL (Proficient), Python (Beginner)

Automated Testing: Jenkins, Junit

Data Analytics & Visualization: SAP Business Objects 4.1, Tableau Desktop, Tableau Server, Qlikview

Web Scripting Languages: HTML, CSS, JavaScript, HTML, XHTML, XML

Database: Oracle SQL Developer, MS SQL Server 2005/2008, MySQL, Vertica

Other Tools: SVN, GIT, JIRA, Crucible, Visio

WORK EXPERIENCE:

Confidential, MO

ETL/ BI/ DATABASE DEVELOPER II

Responsibilities:

  • Developed and managed ETL framework for Meaningful Use reporting using Oracle SQL and SAP Business Objects 4.1.
  • Currently working on development and enhancement of ETL framework that provides high - speed OLAP and BI reporting through the Vertica Database System.
  • Working on creating Dashboards forecasting defect/enhancement JIRA's using Tableau for improving team processes.
  • Designed Database using Star Schema, performed normalization of the database, ensured data integrity is maintained through security and change management.
  • Wrote efficient Stored Procedures, Triggers, Views, and Cursors for accessing Oracle database and automation process.
  • Applied Data Warehouse concepts of Normalization, Database objects, SQL Trace, Explain Plan, CBO and RBO Optimizers, Hints, Indexes, Materialized Views, Global Temporary tables.
  • Automated processes using Python, SQL, Jenkins to improve the development and management processes.
  • Followed Software Development Life Cycle and Agile methodology practices.
  • Lead a team of 4 engineers, provided designs, running daily scrums, assigned tasks and managed their work by making sure they meet the deadlines.
  • Consistently and effectively participating in resolving client related issues and escalations.
  • Extensively participating in project collaboration sessions such as requirements gathering meetings, code review meetings, retrospective and project status meetings, iteration planning within the team as well as across the teams.
  • Strong professional, interpersonal skills and the ability to effectively communicate and build strong relationships with wide range of clients and coworkers.
  • Awarded “You Rock Award” for peer recognition for 2nd, 3rd Quarter 2016 and leadership skills 1st Quarter 2017.

Technologies: PL/SQL, SQL, Tableau, Business Objects 4.1, Oracle SQL Developer, UNIX, Jenkins, JUnit, Python, SVN, GitHub, JIRA, Crucible, Universe Design Tool, Universe Information Tool, HTML 4.0, XHTML 1.0, XML, CSS, Microsoft Visio, Erwin.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship