DataWarehouse Consultant Resume Washington, DC - Hire IT People

COMPUTER SKILLS:

Big Data: PigLatin, MapReduce, Hadoop, HDFS, HIVE, HBASE, SQOOP, OOZIE, FLUME

Databases: MySQL, MSSQL, Oracle

Operating System: Windows, Linux, Ubuntu (CentOS6)

ETL & Reporting Tools: Pentaho BI Suite, Informatica, Talend, TIBCO Jasper

WORK EXPERIENCE

DataWarehouse Consultant

Confidential, Washington, DC

Responsibilities:

Analyze and understand Confidential 's data requirements and reporting system.
Develop & build Confidential 's data warehouse system of mappings from scratch using Talend & MySQL
Design data models and components to extract, store, analyze, aggregate and transform data on MSSQL & MySQL databases.
Design OLAP cubes for adhoc capabilities for Confidential 's reporting system.
Ensure that the database and reporting systems work in conjunction with the company's integrated IT framework, publishing platform and advertising systems.

Business Intelligence Consultant

Confidential, Greenbelt, MD

Responsibilities:

Gather requirements, data profile and develop database models from business requirements.
Design and construct jobs, transformations and dimensional models using Pentaho Data Integration (PDI / Kettle), Schema Workbench and Metadata Editor.
Work on big data plugin samples as part of Pentaho Big Data Analytics.
Develop xactions, reports, dashboards using Pentaho Report Analyzer, Pentaho Report Designer (PRD) and CTools (CDE, CDF, CDA).
Integrate third party charts such as high charts and fusion charts within Pentaho by building custom components/plugins.
Upgrade Pentaho BI (both BA and PDI) production servers with minimal supervision.
Train and mentor interns to quickly learn Pentaho and implement in - house projects.

Software Engineer Intern

Confidential, Rockville, MD

Responsibilities:

Gathered requirements, designed and documented use cases models from business requirements.
Developed caLIMS web application modules, planned project schedules and deadlines using java, agile and scrum.

Software Engineer

Confidential

Responsibilities:

Designed and implemented the ETL processes (mappings) using Informatica tool used to extract data from files/databases, perform business logic on data and then load it to the target files/databases.
Troubleshot issues, ETL job failures, optimized query performances, monitored critical batch-cycle jobs and directly reported to US clients in case of any issues/failures related to the processing of the same on real time basis.
Coordinated with onsite folks, lead and mentored new people in the project.
Worked closely with onsite Business Analysts for requirement gathering, designing the database and developing application.
Developed high level, low level design documents and test cases for the application.
Developed web applications for clients using Java, JSP, JavaScript (JS), HTML, CSS, Ajax, Java/J2EE based projects for clients to perform business functionality.