SUMMARY

To obtain an IT position that will allow me to grow professionally and enhanced my IT skills while learning new technologies

TECHNICAL SKILLS

Applications: Microsoft Excel, Microsoft Visio, MySQL Workbench, MySQL Command Line Client, Oracle SQL Developer Data Modeler, Oracle JDeveloper, Oracle SQLPlus, Oracle SQL Developer, IBM Data Studio, Microsoft Visual Studio, Sybase Central, SAP Web Intelligence Rich Client, SAP Information Design Tool, Microsoft SharePoint Server 2010

Business Intelligence: SSAS, SSIS 2008 & 2012, Microsoft Power Pivot, Microsoft Report Builder, SSRS 2008 & 2012, Pentaho Data Integration, Talend Open Studio, SAP Crystal Reports, Cognos Express, SAP Business Objects Edge 4.0, Microsoft Power View, Tableau, MS MDX, Oracle OBIEE, Tableau, Cognos BI

Courses: Database Administration, Distributed Database, Data Warehouse, Data Mining, Database Design, Database Security, Java, Object Relational Database, PHP, System Analysis, Web Development, VB.NET

Design: Data Flow Diagram, Entity Relationship Diagram, Dimensional Model, Normalization, Relational Database Schema, Logical Data Model, Physical Data Model

Databases Systems: IBM DB2, Microsoft SQL Server 2008 & 2012, MySQL, Microsoft Access, Oracle 10g, 11g & 12C, Postgres,Sybase SQL AnyWhere, Sybase IQ, SAP ASE

Database: DCL, DML,DDL, Cursors, UDF, Stored Procedures, Triggers

MS SQL (TSQL): DCL, DDL, DML,UDF, Stored Procedure, Triggers, XML, SQL Server Agent, Linked Server

Oracle ( PLSQL): Application Context, Audit, Cursors, DDL, Database Link, DML, Oracle Label Security, Profile, Records, TCL, Triggers, Stored Procedures, Package, UDF, XML

Pentaho: tmap, tLogrow, tSortRow, tAggregateRow, tFilterRow, tJoin Merge join, Mulitway Merge Join, Join Rows,Concat Fields, Sort Rows

MS SSIS: Data Flow(Aggregate, Merge Join, Merge, Row, Count, Data Conversion, Conditional Split, Sort, Union All, Derived Column, Pivot), Script Task, For Loop Container, Execute TSQL, File System Task

Operating Systems: Windows, Basic Unix, Windows Server

PROFESSIONAL EXPERIENCE

SQL/SSIS Developer Consultant

Confidential, Greenwood Village, Co

Responsibilities:

• Designed stored procedures and various object in SQL Server Database for ETL processes
• Designed and Implemented SSIS packages embedded with stored procedures using Microsoft Business Intelligence Development Studio
• Validated SSIS packages using Microsoft Business Intelligence Development Studio and Microsoft SQL Server Execute Package Utility
• Reviewed and updated technical design documents
• Designed reports using Microsoft SSRS for ETL processes

SQL/Business Intelligence Consultant

Confidential, Oakbrook, IL

Responsibilities:

• Assisted business analysts with TSQL statements
• Design and implemented reports using Microsoft Power Pivot and SQL Server 2008
• Created views in SQL Server 20008

Quality Assurance Analyst

Confidential

Responsibilities:

• Conducted functional tests on software components
• Linked and updated software requirements and functional requirements using HP Quality Center
• Wrote and updated test conditions and test cases
• Utilized Serena Teamtrack to submit and manage application defect reports

Desktop Assistant Intern

Confidential, Washington DC

Responsibilities:

• Installations of new operating system and applications on Microsoft Windows and Macintosh Computers
• Network services installations for various conferences
• Installation of Ethernet switch and Fiber Optic cables for new network servers
• Hardware and application troubleshooting

Database Developer Intern

Confidential

Responsibilities:

• Installed Application Object Severs using Microsoft SQL Server and Net Business connection
• Deployed Microsoft SharePoint Service to set up the database and administrative virtual servers
• Managed Dynamics user accounts with Microsoft SQL Server 2005
• Established proxy accounts to allow remote access to Microsoft Dynamics Ax 4.0

Confidential

Data Mining Project Fall Semester

Responsibilities:

• Created and deployed cubes to implement Decision Tree, Regression and Clustering Algorithms analysis
• Created users accounts, object privileges and roles for each user accounts
• Implemented application context to create dynamic views to restrict data based on user account
• Implemented password profile to enhance password security by validating passwords based on established requirements
• Utilized the audit mechanism to monitor users activities including database operations and log ins
• Implemented virtual private database using application context to restrict data to specific user
• Extracted data into Excel for reports

Data Warehouse

Confidential

Responsibilities:

• Extracted and transformed data from Microsoft SQL Server 2008 into a CSV and text file using SSIS
• Utilized Oracle JDeveloper to load data into dimensional and fact tables using Oracle SQL Loader
• Utilized MS Visio to conduct reserve engineering process to capture ERD of a databases from MS SQL Server
• Utilized Oracle JDeveloper to generate insert statements from a data text file
• Created reports with MS Excel and Power Pivot by retrieving stored queries in MS SQL Server
• Imported data into MS Excel from Oracle 11g and MS SQL Server 2008 Database Systems using SSIS 2008