We provide IT Staff Augmentation Services!

Etl Developer Resume

2.00 Rating

Cincinnati, OH

SUMMARY

  • Data warehousing design and Physical/Logical Data Modeling, Star Schema and Snow Flake Schema
  • Good noledge in data warehousing techniques for Data Cleansing, Surrogate Key Assignment and Change Data Capture
  • Loading and Unloading Data from the Data warehouse Tables
  • Good understanding of Business Intelligence (BI)
  • Capable in incorporation of various data sources such as Microsoft Access, MS SQL Server, MySQL, Oracle and Flat Files into the Staging Area. Competencies in database concepts, SQL analysis
  • Experience working with SQL queries,and well versed with Unix Shell Scripting
  • Strong proficiency in Python and R for statistical data analysis
  • Strong understanding of SCRUM business processes & interface with IT and it’s all phases of the Software Development Life Cycle (SDLC)
  • Extensively used Erwin to design Logical/Physical Data Models & data architecture, Forward/Reverse engineering
  • Self - motivated and energetic, able to set priorities with adherence to guidelines and deadlines
  • Using prototyping skills when appropriate, clarify customer requests/problems and determine appropriate action with proven success exceeding customer expectations
  • Capable of working under high stress environment with resource constraints
  • Strong organizational and problem solving capabilities
  • Excellent communicator with emphasis on clearly presenting information and developing strong interpersonal relationships

TECHNICAL SKILLS

Data Warehousing/ETL Tools: Pentaho PDI Kettle, SSIS, Informatica

RDBMS: Oracle11g.R2,10g, 9i/8i, SQL Server 2012/2008/2005, MySQL, Access

Scripting Language: XML, XSL, XSLT, XSQL, XPath, DTD, HTML, CSS, Java script, Angular JS 1.x, Bootstrap, Required JS, Toaster

Tools: SQL Developer, Dimensional Data, Star Schema, Snowflake Schema

Data Modeling: ERWin

Languages: SQL, PL/SQL, Python, R

Web Servers: Apache Tomcat 5.x/6.x

Operating Systems: Windows 2000/2003/XP/7,Windows Srvrs 2008/12, Unix/Linux

Application Servers: IBM Web Sphere, Jboss 6/7, Weblogic

Project Management Tools: Mingle, Rally, Jira, Version One

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential, Cincinnati, OH

Environment: Pentaho BI, Informatica, SSIS

Responsibilites:

  • Developed ETL solutions in Pentaho and Informatica
  • Built reports in Microsoft SSRS
  • Direct support for all Pentaho jobs scheduled
  • Report project/task project in Jira following 2 weeks agile process
  • Report day-to-day progress in scrum meeting

ETL Developer

Confidential

Environment: Java J2EE, Infor BI, Microsoft SQL Server, Active Directory, SSIS, AS 400 Server, command-line tools/PowerShell, Citrix Windows Infrastructure, Infor M3

Responsibilites:
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers in Microsoft SQL Server
  • Created parameterized reports, drill down and drill through reports
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Maintained and updated legacy Microsoft Access Database
  • Developed technical platform for global vendor payment in Java.
  • Assisted users set-up with Active Directory (Adds, Moves, Changes, etc.)
  • Installed/configured software from the command line terminal.
  • Configured Citrix to manage single sign-on, enhanced security for client-server communication and monitor the environment 24/7

ETL Developer

Confidential

Responsibilities:

  • Confidential is a prominent software company in Michigan with in-housing software project and staffing operations in USA.
  • me was the Pentaho Developer for the project with Confidential, the health analytics wing of Confidential .
  • me was involved in developing the backend datastore as well report creation and unit testing.

Confidential, Wixom, MI

ETL/Software Developer

Environment: J2EE, ERWin, Liferay, MySQL, Pentaho, Hadoop, Apache Tomcat

Responsibilities:

  • Designing and developing OLAP for Data warehouse and Star Schema, Fact, Dimensions and cubes for reporting.
  • Documented ETL conversion process extensively.
  • Performed dimensional modeling to create star schema
  • Built Enterprise web portal in LifeRay to display interactive reports and charts
  • Maintained and debugged Java MVC applications.
  • Unit tested and documented website applications and code.
  • Followed Agile Development Methodologies

Confidential, Wixom, MI

Business Analyst/Software Developer

Environment: MySQL, ERWin, Pentaho Server, Apache Tomcat, Pentaho Report Designer, Pentaho Data Integration (Kettle), Community Dashboard Framework (CDF), Javascript

Responsibilities:

  • Responsible for collecting, understanding and transmitting the business requirements for the project and
  • translating them into functional specifications.
  • Participated in meetings with business owners, stakeholders and subject matter experts (SME’s) as part
  • f requirements gathering interviews.
  • Analyzed the state of the business and prepared tactical and strategic business plan.
  • Interfaced with the project manager and development team through different stages of the project.
  • Determined Business/Functional Requirements. Created vision, scope and use case documents.
  • Assisted in architecture analysis and design using UML.
  • Worked with the testing team for User Acceptance Testing (UAT), Unit Testing and Integration Testing.
  • Developed use cases from requirements and created UML diagrams.
  • Assisted with required data analysis, interpretation, corrections and document presentation.
  • Implemented Pentaho Kettle transformations for ETL job
  • Performed dimensional modeling to create star schema
  • Built Mondrian Cube based on the star schema for MDX query support
  • Used Community Dashboard Editor (CDE) to create dashboard layout and interactive report/chart display

We'd love your feedback!