TECHNICAL SKILLS

• SQL
• Data Warehousing SDLC
• Enterprise Architecture
• Requirements Analysis
• Performance Tuning
• Integration
• Architecture
• Disaster Recovery
• Agile Methodologies
• Data Warehouse Architecture
• Microsoft SQL Server
• SSRS
• SSIS
• SSAS
• HP NonStop TACL
• Relational Databases T - SQL
• Crystal Reports Erwin
• Data Migration Data Architecture UML
• Requirements Gathering Eclipse
• High Availability SQL Tuning
• Database Administration
• Enscribe
• GoldenGate
• FUP
• Subversion

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Modeling simple and complex types that are used as building blocks by the developers in their APIs. Modeling is done in XMLSpy and IgniteXML. Providing mappings to the developers in various forms. Also doing modeling for the data warehouse using ER/Win.

Utilitized: XMLSpy, Ignite XML, ER/Win V9.

Confidential

Data Warehouse Architect/Data Modeler

Responsibilities:

• Designed new entities for the warehouse. Mapped requirements to the logical model and mapped physical elements to the physical model for use by the ETL team. Reported on the enterprise data model using the ER/ Win tool. Implemented naming and data type standards. Used ER/Win to generate scripts for deployment. Helped developers to analyze, design and create SQL queries.

Utilized: ER/Win V9, Oracle.

Confidential

Responsibilities:

• Modeling class diagrams using UML which can be of the canonical or message flavor to be used throughout the enterprise by all the various products in the new SOA architecture with the eventual goal of all data from all products going through a single multi - tenant database. Artifacts being generated out of VP (Visual Paradigm) models include XSD, ORM, Entity Relationship Diagrams, Canonical and Message Class Diagrams. Providing light gap analysis with the help of the Business Analysts. Interviewing and surveying various levels of individuals and groups to accumulate the necessary data to determine which attributes are re-usable across the enterprise. Using the ISO standard canonical and message layouts where possible.

Utilitized: VP, UML, XSD, ORM (hibernate or JPA formats), DDL (Oracle).

Confidential

Senior Database Designer/Senior Data Modeler

Responsibilities:

• Created and implemented naming standards, data type standards and a domain dictionary to ensure consistency across the enterprise. Designed the normalized relational logical and physical data models from the ground up using the ER/Win CASE tool. .Interfaced with the business analysts, development team and the product group to gather requirements for the multi-tenanted database design. Created, updated and reported on the enterprise data model using the ER/Win CASE tool. Used the ER/Win CASE tool to generate scripts for deployment. Used SSMS to deploy the generated scripts to the various development environments. Checked the generated scripts into SVN via Eclipse. Worked in SQL Server 2012 environment. Helped developers to analyze, design and create basic SQL queries.

Utilized: ER/Win CASE tool V9, T-SQL, SQL Server 2012, SSMS, Eclipse, SVN. Pursuing MSCE.

Confidential

Sr. Database Architect /Sr. Data Modeler

Responsibilities:

• Created, updated and reported on the enterprise data model using the ER/Win tool. Used ER/Win to generate scripts for deployment to production. Worked in both the Guardian and the OSS (POSIX) environments. Create, install and maintain tables, indexes and views for multiple catalogs. Help developers to analyze, design and create SQL queries. Run EXPLAIN plans against queries. Recommended best practices for SQL. Analyze queries for performance and functionality. Coordinated database activities during integration testing through to successful delivery to the clients. Modeled and helped convert a flat file Enscribe database into an SQL database using Escort. Researched, tested and set up MXCS Servers to reduce the number of SQL Compiles in one of the newly introduced products that uses Java.

Utilized: SQL, SQLCI, MXCI, MXCS, OSS, Unix, Emacs, DDL, TACL, Pathway, Inspect, Peruse, FUP, Spoolcom, TMF, DSAP, SCF, Tedit, ViewSys, SQL ReportWriter, Escort, SVN, Eclipse, NSM/Web.

Confidential

Responsibilities:

• Create, install and maintain tables, indexes and views for multiple catalogs. Help developers to analyze, design and create SQL queries. Run EXPLAIN plans against queries. Recommended best practices for SQL. Analyze queries for performance and functionality. Coordinated database activities during integration testing through to successful deployment to production. Used Golden Gate to set up replication with userexits for data scrubbing of demo system. Monitored and interfaced with many aspects of the Golden Gate software. Utilized SQL, SQLCI, C, OSS, Unix, Emacs, DDL, TACL, Pathway, Inspect, Peruse, FUP, Spoolcom, TMF, DSAP, SCF, Tedit, ViewSys, SQL ReportWriter, Golden Gate.

Confidential

SQL/MP Query Analyst & Senior Programmer/Analyst

Responsibilities:

• Analyze, design and create new native SQL/MP queries. Create and maintain C/Native Cobol programs. Analyze programs for performance and functionality. Run EXPLAIN plans against queries. Coordinated activities during integration testing through successful deployment to production. Utilized SQL/MP, SQLCI, Native COBOL language, SCUP, DDL, TACL, SCOBOL, Enscribe, Pathway, Inspect, Peruse, FUP, Spoolcom, TMF, DSAP, SCF, Tedit, ViewSys, SQL/MP ReportWriter, SQL/MX, MXCI, OSS, Unix, Emacs, make, C .

Confidential

Consultant

Responsibilities:

• Mananged a 2.5 gigabyte Data Warehouse that contained 8 Datamarts. Perform splits, drops, creates, loads, etc using SQLCI & Dataloader. Setup ODBC. Analyze, design and create new native SQL queries. Run EXPLAIN plans against queries. Recommended best practices for SQL. Analyze queries for performance and functionality. Write scripts to make tasks more efficient using Obey streams and TACL. Coordinated activities during integration testing through successful deployment to production. Created test tools to allow for better unit tests before going to QA. Utilized SQL, SQLCI, OSS, SCUP, DDL, TACL, Pathway, Inspect, Peruse, FUP, Spoolcom, TMF, DSAP, SCF, Tedit, ViewSys, SQL ReportWriter

Confidential

Responsibilities:

• Analyze, design and create new native SQL queries. Run EXPLAIN plans against queries. Recommended best practices for SQL. Create and maintain C/TCL programs. Analyze programs for performance and functionality. Coordinated activities during integration testing through successful deployment to production. Created test tools to allow for better unit tests before going to QA. Utilized SQL, SQLCI, C, OSS, Unix, Emacs, TCL, Gmake, VI, SCUP, DDL, TACL, Pathway, Inspect, Peruse, FUP, Spoolcom, TMF, DSAP, SCF, Tedit, ViewSys, SQL ReportWriter.

Confidential

Responsibilities:

• Analyze, design and create new native SQL queries. Run EXPLAIN plans against queries. Recommended best practices for Escort & SQL. Convert old Enscribe programs to native SQL. Analyze programs that will be using Escort to verify performance and functionality. Coordinated activities during integration testing through successful deployment to production. Utilized SQL, SQLCI, ESCORT and Native COBOL languages, SCUP, DDL, TACL, SCOBOL, Enscribe, Pathway, Inspect, Peruse, FUP, Spoolcom, TMF, DSAP, SCF, Tedit, ViewSys, SQL ReportWriter.

Confidential

Computer Consultant

Responsibilities:

• Technical Team Lead for various projects. In-house SQL database/query expert and mentor. Taught SQLCI and Advanced SQL in-house courses. Analyze, design and create new native SQL queries, tables, indexes and views. Run EXPLAIN plans against queries. Partition tables as necessary. Update statistics as necessary. Recommended best practices for SQL. Use MEASCOM to help solve performance issues. Convert old Enscribe programs to native SQL. Convert Enscribe files to Escort SQL tables. Coordinated activities during integration testing through successful deployment to production. Utilized SQL, SQLCI, ESCORT and COBOL85 languages, SCUP, DDL, TACL, SCOBOL, Enscribe, Pathway, Inspect, Peruse, FUP, Spoolcom, TMF, DSAP, SCF, Tedit, ViewSys, Enform, SQL ReportWriter, KLIST.

Confidential DPS

D.B.A. and Senior Programmer/Analyst

Responsibilities:

• Analyze, design and create new programs and database files for the E-Pay Electronic Payment Subsystem which interfaces with Deluxe Data's Connex System. Add functionality to various Connex utilities programs. Coordinated activities during integration testing through successful deployment to production. Utilized SCOBOL, TAL and COBOL85 languages, SCUP, DDL, Enscribe, Pathway, Inspect, Peruse, FUP, Spoolcom, TMF, DSAP, Tedit, ViewSys, Enform.

Confidential

D.B.A. and Senior Programmer/Analyst

Responsibilities:

• Analyze, design and create new queries, tables and indexes. Use EXPLAIN plans. Develop new on-line programs that include an on-line bank comparison module which is used for bank reconciliation. Convert old Legacy programs to the new on-line system. Maintain Legacy code as needed. QA all programs written/ converted. Coordinated activities during integration testing through successful deployment to production. Utilized SQL, SQLCI and COBOL85 languages, SCUP, DDL, SCOBOL, Enscribe, Pathway, Inspect, Peruse, FUP, Spoolcom, TMF, DSAP, Tedit, ViewSys, ErWin, SQL ReportWriter.