SUMMARY:

• Experienced database professional since 2009 with vast experiences in various platform including MySQL, DB2, Oracle (PLSQL), PostgreSQL(PL/PGSQL), SQL Server and Sybase (ASE, Anywhere & IQ)
• Experience with database normalization, data migration, query optimization, Tablespace, Schema, database objects(Indexes, Constraints, Triggers, Cursor, Records, Stored Producer & Functions) and DBA
• Experienced utilizing both Oracle and SQL Server systems congruently including Oracle Client and linked Server to extract and manipulate data using both TSQL and PLSQL statements in a SQL Server 2008R2 Database Instance
• Experienced with various ETL applications including Pentaho, Talend, Informatica PowerCenter Express and SSIS
• Experienced with Data Warehouse Architect including Kimbal and Inmon,dimensional modeling, de - normalization and ETL process
• Experienced with BI applications like SSRS, Cognos BI, Business Objects and Crystal Reports and BI development utilizing multiple sources like SSAS (MDX quires), XML(SSRS), Excel, data warehouse and relational database systems

TECHNICAL SKILLS:

Applications: Microsoft ( Excel, Visio, Visual Studio 2008 & 2010 and Business Intelligence Development Studio(2008) /SQL Server Data Tool(2012))Oracle (SQL Developer, JDeveloper(Database Development) and SQL Developer Data Modeler), Toad

Business Intelligence: Microsoft (SSAS 2008 & 2012 Tabular, SSIS 2008 & 2012, Power Pivot, Report Builder, SSRS 2008 & 2012 and Power View)Pentaho Data Integration, Talend Open Studio Data Integration, SAP Crystal Reports,IBM Cognos Express(Query Studio, Report Studio and WorkSpace),SAP Business Objects Edge 4.0(Web Intelligence Rich Client and SAP Information Design Tool), Tableau, Cognos BI and Informatica PowerCenter Express

Courses: Database Administration, Distributed Database, Data Warehouse, Data Mining, Database Design, Database Security, Java, Object Relational Database, System Analysis,Web Scripting(PHP,HTML, XHTML, JavaServer Pages, Cascading Style Sheets, VB.NET)

Database & DW Design: Data Flow Diagram, Entity Relationship Diagram, Normalization, Relational Database Schema, Logical Data Model, Physical Data Model, Dimensional Model, Kimball and Inmon Model, ETL

Databases Systems: IBM DB2 Express, Microsoft SQL Server 2005,2008 R2, 2012 & 2014, MySQL 5.5 &5.7, Microsoft Access, Oracle 10g, 11g, &12c, PostgreSQL 9.2.4, Sybase SQL AnyWhere 12, Sybase IQ 15.4 and Sybase ASE

MS SQL Server: DCL, DDL, DML, UDF, Stored Procedure, Triggers, XML, SQL Server Agent, Linked Server, Server Management Studio, Queries, Constraints, Open Query

MySQL: MySQL Workbench, MySQL Command Line Client, Backup and Recovery, DDL, DML, Functions, Triggers, Stored Procedure, TCL, JDBC, ODBC, Constraints, MySQL Installer

Oracle: Application Context, Audit, Cursors, DDL, Database Link, DML, Oracle Label Security,Profile, Records, TCL, Triggers, Stored Procedures, Package, UDF, XML, Sequences, JDBC, SQL Plus, Oracle Client, ODBC, Constraints, Dynamic ViewsTalend(Open Studio):Pentaho(Spoon): Palette (tmap, tLogrow, tSortRow, tAggregateRow, tFilterRow, tJoin, tFileOutput,, tFileInput), OLEDB JDBC, Job, Metadata (Db Connection, File Excel,File Deliminited)Merge join, Mulitway Merge Join, Join Rows,Concat Fields, Sort Rows JDBC, Flat File, CSV

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, OLEDB, ODBC, Flat File, ExcelPostgres(PostgreSQL): Triggers, Function, Index, Schema, Tables, Constraints, DDL, DML, Queries, Sequences, Postgres Pg Admin, JDBC, ODBC, SQL Shell Back and Recovery

Sybase: Sybase Central, ODBC, OLEDB, DDL, DML, Triggers, Stored Procedure, Constraints, Queries, Functions(ASE &IQ), Schema, Sequence(IQ),TCLDB2 Express(DB2): IBM Data Studio,JDBC, ODBC, DB2 Command Line Processor, Stored Procedure, Triggers, Functions, DDL,DML, TCL

PROFESSIONAL EXPERIENCE:

SQL Developer

Confidential, Sun Prairie, WI

Responsibilities:

• Designed and Deployed Database System embedded with Stored Procedures, Tables, temporary Tables, Views and User Defined Functions (UDF) using SQL Server 2008R2 instance to automate ETL Processing.
• Manipulated and Extracted data using PLSQL statements embedded with functions from Oracle 11g Data Warehouse System using Oracle SQL Developer across multiple fact and dimension tables
• Installed and Deployed Oracle 11g Client to establish linked server in SQL Server Database to extract data from Oracle based Data Warehouse using OpenQuery nested with both TSQL and PLSQL statements within Stored procedures and UDF
• Installed JTDS JDBC driver within Oracle SQL Developer to establish connection with a Microsoft SQL Server database instance
• Utilized TSQL Statements embedded with UDF, Stored Procedures, Views and Functions to extract and manipulate data using SQL Server Management Studio and Oracle SQL Developer from SQL Server Database
• Utilized SQL Server Import and Export utility and bulk insert statements to load data into SQL Server Database
• Installed and utilized Microsoft.ACE.OLEDB.12.0 to create linked server to various Excel files
• Imported and exported files to various Microsoft Excel files using OpenQuery within stored procedures
• Created and managed user accounts including passwords and privileges for SharePoint and InfoPath user accounts
• Archived and restored Databases within SQL Server instance
• Imported archived production database into a development database for InfoPath application development
• Created and managed multiple databases including ETL and SharePoint database
• Collaborated with Business team and Data Architect to review data requirements, data structure and ETL automation
• Resolved data discrepancies with Business team and Data Architect
• Utilized data requirements to analyze data using Excel to discover any discrepancies
• Installed and deployed SharePoint Server in a development server using Windows Server 2008
• Utilized Microsoft Visual Studios 2010 to create and deployed Web Services using C# scripting language
• Designed and Deployed Database System using SQL Server 2008R2 instance embedded with tables, views, stored procedure, constraint, indexes and UDF to store and process data generated by InfoPath 2010
• Utilized ADO.Net within web service to execute SQL Server Stored Procedures to process and retrieve data from a database or user using InfoPath dynamic forms
• Deployed a web services to a SharePoint Server
• Utilized SharePoint Designer to create and manage sites
• Designed and deployed forms using Microsoft InfoPath 2010 to a SharePoint form library

SQL/SSIS Developer Consultant

Confidential, Greenwood Village, CO

Responsibilities:

• Designed various database objects including tables, User Defined Function (UDF) and Stored Procedures within a SQL Server 2008R2 database
• Utilized complex TSQL Statements embedded with functions to extract and manipulate data using UDF and Stored Procedures
• Designed and deployed SSIS packages using Microsoft Business Intelligence Development Studio 2008(BIDS)
• Utilized stored procedure within each SSIS Packages to retrieve and process data based on input parameters
• Cleaned and Loaded data into a SQL Server 2008R2 database using SSIS 2008 various Control Flow and Data Flow components including Script task, Foreach Loop Container, File System Task and Data Flow like Merge, sort and Row Count
• Utilized C# code to display row count message to end user using Row Count and Script Task
• Utilized custom C# code to log error message using Script Task to a SQL Server Database
• Validated SSIS packages using BIDS and Microsoft SQL Server Execute Package Utility
• Extracted data into various files using Flat File Destination within SSIS packages
• Designed and deployed reports using SSRS 2008 embedded with Stored Procedures to allow user to retrieve data based on input parameters
• Reviewed and updated technical design documents

SQL/Business Intelligence Consultant

Confidential, Oakbrook, IL

Responsibilities:

• Designed reports using Microsoft Power Pivot and Excel 2010
• Utilized Excel reports to analyze data to discover new trends
• Utilized TSQL embed with functions statements to manipulate data from SQL Server 2008 R2 Database
• Assisted business analysts with TSQL statements
• Created views in SQL Server 20008 database

Intern

Confidential, Washington D.C

Responsibilities:

• Assisted with various office assignment

Quality Assurance Analyst CO-OP

Confidential, Timonium, Maryland

Responsibilities:

• Conducted functional tests on software components to determine the quality of data
• Worked with Application and Database Developers to resolve various issues relating to Database or Software Applications
• 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 and deployed Microsoft SQL Server 2005 database instance using Windows Server and Active Directory
• Installed Application Object Severs using Microsoft SQL Server 2005 and Net Business connection protocols
• Deployed Microsoft SharePoint Service to set up the database and administrative virtual servers
• Managed Dynamics user accounts using Microsoft SQL Server 2005
• Established proxy accounts to allow remote access to Microsoft Dynamics AX 4.0

Academic Research

Confidential

Responsibilities:

• Created cubes to implement Decision Tree, Regression and Clustering Algorithms
• Created users accounts, object privileges and roles for each user accounts
• Utilized PLSQL statements to create various objects including stored procedure, tables, user defined functions and triggers
• 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
• 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