SKILLS:

• ASP.NET, VB.NET, C#, T - SQL, PL/SQL, SQL, COLDFUSION, Oracle Developer 2000(6i), VBA, JavaScript, HTML, Crystal Reports, SQL*Loader, C, PRO*C, Pascal, FORTRAN, Basic, UNIX K-shell,.
• Clear Case, PVCS, CVS, SVN.
• Quatro Pro.
• SSMS, SSIS, SSRS ORACLE data warehouse builder10g, TOAD, SQL Developer, SQL*Navigator, Rational Rose, ORACLE Discoverer, ORACLE ENTERPRISE MANAGER (OEM).
• Erwin, Designer 2000

EXPERIENCE:

Confidential

ASP.NET/C#/VB.NET Developer

Responsibilities:

• Developed front end web pages in ASP/C#/VB.NET, JavaScript, html, in VisualStudio 10, and internetExplorer.
• Utilitized MasterPages, Skinfile, Updatable GridViews, Popup Pages, Calendars.
• Developed/Designed Stored Procedures/Functions in T-SQL(2005.2008,2012) to collect data from MS Historian.
• Developed, and maintained SSRS Reports.
• Performed DBA duties such as creating databases, backup/Recovery. Space Management, and database Migration from SQLSERVER(2005.2008) to SQLSERVER 2012, and Windows Server 2012.
• Migrated SSRS reports from Windows Server .
• Created Linked Servers from SQLserver(2005.2008,2012) to SQLSERVER, and ORACLE 11g.
• Gathered business requirements.
• Wrote documentations.
• Created test scripts.

Confidential

ASP.NET/C#/VB.NET, SQLServer 2012, SSIS, SSAS Developer

Responsibilities:

• Developed ASP.NET C#/VB.NET web pages to be used for applicants, HR, and instructors.
• Designed an educational Tabular Data Warehouse. Designed the Star Schemas, Facts/Dimensions, and identified Measures. Utilized SSIS to create an ETL process for the Data Warehouse. Utilized SSAS to design, and create the Tabular Data Warehouse. Performed in depth Business Analysis, and Data Analysis. Performed Data Modelling tasks.
• Developed T-SQL (Procedures/Functions/Triggers, and SSIS to automate the Admission Process. For example, utilized Fuzzy Lookup, and (TF) Taskforce SSIS tool to identify duplicate applicants.
• Code Reviewed, and modified the existing SQL for performance improvement. Utilized Explain Plan, SQL Profiles, and CTE’s (WITH CLUSE). Performed index management, parallel processing, Partitions.
• Created new T-SQL (Procedures/Functions) for reporting purposes. Created QA test Scenarios.
• Performed production trouble shooting, and production support.
• Modified the existing T-SQL, and SSIS routines to fix the production problems.
• Performed some DBA, and Windows Server management tasks. For example, Configured, and installed SSRS Reporting Services.
• Attended Jenzabar Software Training.

Confidential, Las Vegas, NV

ASP.NET/C# Developer

Responsibilities:

• Developed ASP.NET/C# web pages for finance, accounting, and customers.
• Designed, and architected a one-time ETL system from Main Frame to INFORMIX with over 500 million rows/transactions.
• Designed, and architected a daily ETL system (using SSIS) into SQLServer from Informix, and Main Frame source databases.
• Developed SSRS BI Reports. Performed Business Analysis.
• Responsible for architecting, and writing stored procedures, and functions to handle transfer of large volumes (ETL) of data into the Data-Ware house. Designed parallelism in SSIS to improve the performance. Created indexes, and removed some indexes. Designed normalization, and normalization. Utilized the usage of Temp Tables. Utilized INFORMIX External Tables. Designed frequency of the jobs in SSIS, and INFORMIX. Developed summarization stored procedures in both SQLServer, and INFORMIX. Developed Mock Data to imitate BULK processing. Supported QA.

Confidential, Jacksonville, FL

ASP.NET / SQLSERVER T-SQL, Business Intelligence (BI) Developer

Responsibilities:

• Developed, and maintained C#/ASP.NET web pages for Finance, and accounting.
• Developed C#/.NET Utility applications.
• Created T-SQL Stored procedures/Functions. These stored procedures may be called from front end ASP.NET or from SSIS/SSRS.
• Performance tuned the ETL process by parallelism, and rewriting the SQL, and by removing the redundant steps using temporary tables.
• Performance tuned the existing long running ETL, and NON-ETL application SQL statements by rewriting the SQL statements. For example NOT EXISTS queries may have been replaced by EXCEPT statements, or SQL statements were rewritten utilizing CTE’s (WITH CLAUSE). Utilized Analytical functions for performance enhancements.
• Performance tuned using Profiler, and explain plan.
• Created/Maintained SSIS packages for ETL purposes.
• Created/Maintained SSRS Reports.
• Performed Business Analysis, and wrote documentation.

Confidential, Jacksonville, FL

ASP.NET/VB.NET / DBA/ Business Intelligence (BI) Developer

Responsibilities:

• Developed VB.NET ASP.NET Web Pages to be used by claims department.
• Created Stored Procedures, Functions, and Triggers. Wrote Business Rules/specifications. Improved performance of SQL statements by rewriting them, or adding or removing the indexes.
• Designed table partitioning.
• Created SSIS packages for ETL purposes.
• Performed DBA duties: Backup/Recovery using Lite Speed, Creation of Databases, Logins/Users, Granting Permissions, creation of database objects: Tables, Indexes, Schema, Procedures/Functions, Jobs/Schedules, and alerts. Trouble Shooted database locking/ space issues. Created Replication, and utilized Log shipping. Utilized Active Directory, and Windows Management Admin tools.

Confidential, Jacksonville, FL

ORACLE PL/SQL, and SPATIAL Developer

Responsibilities:

• Developed brand new, and maintained existing PL/SQL Stored Procedures, Functions.
• Utilized ORACLE’s Bulk Processing for ETL batch jobs.
• Improved performance of batch jobs by reading Execution plans, and creating indexes (Function based indexes). Utilized Hints, PARTITIONING, WITH CLAUSE, DNS (Native dynamic SQL), ROLLUPS, CUBES, ANALYTICAL FUNCTIONS, and PARTITION EXCHANGE for performance tuning.
• Utilized ORACLESPATIAL functions.
• Loaded Data using SQL*LOADER.
• Used Toad.
• Performed in depth Business Analysis.
• Wrote documentation, and created Test Data.

Confidential, Columbus, GA

C#/ASP.NET Developer

Responsibilities:

• Developed C#/VB.NET ASP.NET Web Pages for credit card processing, and credit card applications.
• Created T-SQL Stored procedures for ETL, and reporting purposes, and SQL DML Scripts Performance tuned using Profiler, and explain plan.
• Created SSIS packages to load data from flat files, and from other databases. Used C#, and VB.
• Performed DBA duties: Backup/Recovery using Lite Speed, Creation of Databases, Logins/Users, Granting Permissions, creation of database objects: Tables, Indexes, Schema, Procedures/Functions, Jobs/Schedules, and alerts. Trouble Shooted database locking/ space issues. Utilized Active Directory, and Windows Management Admin tools.
• Created Snapshot, and Transactional Replications.
• Developed brand new, and maintained existing PL/SQL Stored Procedures, Functions.
• Loaded Data using SQL*LOADER.
• Utilized ORACLE’s Bulk Processing for the batch jobs. Improved performance of batch jobs by reading Execution plans, and creating indexes (Function based indexes). Utilized Hints, PARTITIONING, WITH CLAUSE, DNS (Native dynamic SQL), ROLLUPS, CUBES, ANALYTICAL FUNCTIONS, and PARTITION EXCHANGE for performance tuning.
• Performed general administration duties, such as creation of databases, Data Pump Import/Export, Job management, Space management, and Memory management, generation of Statistics, DDL creation, and RMAN backup/recovery effort.
• Performed in depth Business Analysis. Wrote program documentation.
• Created Test Data for UNIT testing, and QA.
• Utilized oracle’s OEM, TOAD, Developed UNIX K-Shell routines.
• Performed in-depth business analysis.

Confidential, Sunrise, FL

Oracle PL/SQL Developer

Responsibilities:

• Utilized ORACLE Collections. Loaded Data using SQL*LOADER.
• Created adhoc SQL reports.
• Performance tuned existing PL/SQL, and SQL programs.
• Utilized ORACLE’s Bulk Processing for the batch jobs. Improved performance of batch jobs by reading Execution plans, and creating indexes (Function based indexes). Utilized Hints, PARTITIONING, WITH CLAUSE, DNS (Native dynamic SQL), ROLLUPS, CUBES, ANALYTICAL FUNCTIONS, and PARTITION EXCHANGE for performance tuning.
• Performed in depth Business Analysis. Wrote program documentation.
• Created Test Data.
• Utilized SQL Navigator. Developed UNIX K-Shell routines.
• Performed in-depth business analysis.

Confidential, New Jersey

Oracle PL/SQL Data Warehouse Developer

Responsibilities:

• Wrote ORACLE PL/SQL packages to ETL data from various data sources into and out of the Data warehouse.
• Denormalized the existing data warehouse to expedite the ETL process.
• Utilized ORACLE’s Bulk Processing for the batch jobs. Improved performance of batch jobs by reading Execution plans, and creating indexes (Function based indexes). Utilized Hints.
• PARTITIONING, WITH CLAUSE, DNS(Native dynamic SQL), ROLLUPS, CUBES,
• ANALYTICAL FUNCTIONS, and PARTITION EXCHANGE for performance tuning.
• Created T-SQL Stored procedures for ETL, and reporting purposes, and SQL DML Scripts
• Performance tuned using Profiler, and explain plan.
• Created SSIS packages to load data from flat files, and from other databases.
• Performed in depth Business Analysis. Wrote documentation. Created Test Data.
• Utilized SQL Developer. Utilized PVCS.
• Developed UNIX K-Shell routines.
• Performed in-depth business analysis.

Confidential, Michigan

ORACLE PL/SQL Lead Developer

Responsibilities:

• Performed Data Modelling in the new ORACLE database. Utilized Erwin.
• Performed Code Review of the existing PL/SQL packages.
• Recommended Utilizing ORACLE’s Bulk Processing for the batch jobs. Improved performance of batch jobs by reading Execution plans, and creating indexes (Function based indexes). Utilized Hints, PARTITIONING, WITH CLAUSE, DNS (Native dynamic SQL), ROLLUPS, CUBES, ANALYTICAL FUNCTIONS, and PARTITION EXCHANGE for performance tuning.
• Developed brand new, and maintained existing PL/SQL Stored Procedures, Functions.
• Loaded Data using SQL*LOADER.
• Performed in depth Business Analysis. Wrote program documentation. Created Test Data.
• Utilized SqlDeveloper. Developed UNIX K-Shell routines.
• Performed in-depth business analysis.

Confidential, Orlando, Fl

SQLServer Developer/DBA

Responsibilities:

• Back End development team lead. Responsible for design, and code review of Back End ORACLE, and SQLServer routines.
• Created T-SQL Stored procedures for ETL, and reporting purposes, and SQL DML Scripts.
• Developed SSIS packages for ETL purposes.
• Performance tuned using Profiler, and explain plan.
• Created SSIS packages to load data from flat files, and from other databases. Used C#, and VB.
• Improved performance of existing OLTP PL/SQL procedures (Called from J2EE Web applications).
• For example, this was accomplished by rewriting the poor performing queries utilizing WITH CLAUSE. Replacing NOT EXIST clauses with MINUS. Replacing OR clauses with UNIONS, and replacing SUB SELECTs.
• Utilized ORACLE’s Bulk Processing for the batch jobs. Improved performance of batch jobs by reading Execution plans, and creating indexes (Function based indexes). Utilized Hints,
• PARTITIONING, WITH CLAUSE, DNS(Native dynamic SQL), ROLLUPS, CUBES,
• ANALYTICAL FUNCTIONS, and PARTITION EXCHANGE for performance tuning.
• Performed general administration duties, such as creation of databases, Data Pump
• Import/Export, Job management, Space management, Memory management, generation of Statistics, DDL creation, and RMAN backup/recovery effort.
• Developed Web pages using JSP, Servlets, Java Beans, Struts, JSF, JDBC, JMS, and SOAP.
• Used both ORACLE, and SQLSERVER back ends.
• Utilized WebSphere, and Rational Rose IDEs.

Confidential, Tampa, FL

Oracle PL/SQL Developer

Responsibilities:

• Responsible for developing an ORACLE High Performance ETL process.
• Wrote brand new Packages, and stored procedures.
• Utilized ORACLE’s Bulk Processing for the batch jobs. Improved performance of batch jobs by reading Execution plans, and creating indexes (Function based indexes). Utilized Hints, PARTITIONING, WITH CLAUSE, DNS (Native dynamic SQL), ROLLUPS, CUBES, ANALYTICAL FUNCTIONS, and PARTITION EXCHANGE for performance tuning.
• Performed Business Analysis. Utilized Toad.

Confidential, Lakeland, Florida

Oracle PL/SQL Developer

Responsibilities:

• Code Reviewed, and rewrote the existing ETL PL/SQL procedures to add new functionality, and improve performance.
• Utilized ORACLE’s Bulk Processing for the batch jobs. Improved performance of batch jobs by reading Execution plans, and creating indexes (Function based indexes). Utilized Hints, PARTITIONING, WITH CLAUSE, DNS (Native dynamic SQL), ROLLUPS, CUBES, ANALYTICAL FUNCTIONS, and PARTITION EXCHANGE for performance tuning.
• Performed Business Analysis, and produced documentation.