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

• 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