North Highlands CA 95660
Seeking Data Mart Developer job in a data warehouse environment and explore my expertise in Oracle developing applications like TOAD and PLSQL to design Data Marts.
Strong Technical command of online analytical processing and Business Intelligence Tools:
- Oracle OLAP, MDX
- Cognos and SAP Business Objects XI
- MS Analysis and reporting services
Profound knowledge of developing Data warehousing using:
- ETL(Extract, Transform and Load) Procedures
- DataStage Tools and SQL Server Integration Services
Data organizing qualities:
- Analytical processing
- XML file transferring
Designing and developing calibers in:
- BO Universe
- Independent data marts
Oracle based Data management:
- Ascential DataStage Server
- Java EE
Cognitively expert in:
- Data Stage XM
- DW and BI applications
Understanding of Operating systems like:
Great virtuous sense:
- to identify user requirements and
- to interpret dimensional modeling
Data Mart Developer
January 2012 – Present
- Designed and supervised overall development of Data Mart and Oracle-hosted dimensional models.
- Contributed in creating ETL designs and provided end users an easy accession to data marts.
- Troubleshot and resolved data models issues and formulated reports and analytical programs.
- Tested, adjusted and monitored alterations in designs.
- Maintained data marts up-to-date and in accordance with company’s requirements and practices.
- Documented data discovery, designs, patterns and mining projects.
Data Mart Developer
November 2010 – January 2012
Fort Meade, MD
- Employed Oracle database to create and maintain Data Marts.
- Designed and developed DS data flows and ETL components.
- Extracted data mart reports and transferred from Mx 2.10 to MX 3.1.
- Developed DM feeders and reported financial office for any Risk matrix.
- Formulated processing scripts, tables, feeder batches and PL variance.
- Developed unit testing strategies and provided process improvements insight and requirements to end users.
Master’s Degree in Information Systems Science
Bellingham Technical College
August 2008 – May 2010
Bachelor’s Degree in Computer Science
September 2004 – June 2008
Oracle Certified Professional (OCP DBA)