SUMMARY:

• A database developer with over 13 years of experience in the IT industry with exceptional work ethics as well as paying attention to detail. Demonstrating sound judgment in developing methods, techniques and evaluating criteria for enterprise class database support and critical business processes. I have customer facing skills, articulate and a business professional.

TECHNICAL SKILLS:

Database:SQL Server, Oracle 2000, 2005, and 2008R2, 2012 Database design, data mapping, and data modeling Tables, Views, and UDF s, Stored Procedures, T - SQL, PL/SQL, Joins, Query's, Sub Query's Work with SSMS SSIS, Server Agent, Profiler, execution Plans, Database tuning Installation, logging, and security; Replications, Subscriptions

BIDS (Business Intelligence Development Studio): SSIS, SSRS and SSAS; Reports Server; KPI s, hierarchy and application integration Cleansing Data, extraction, transformations Created Containers, Loops, Bulk Inserts, Script Tasks, Maintenance Tasks Data Flows, Merge, Merge Joins, Lookups, Aggregates, Union All, Conditional Split Data Marts and Data Warehouses Reporting Services Configuration Manager Create/Design Reports. Report Server Projects, Report Models

.Net: VB6, MS Office, VBA, VB Script, C#, VB.Net Built web sites in C#, Stored Procedure calls to SQL Server and Oracle API's UI faces very little graphic design Business requirements and backend connectivity/classes Framework 4.0

PROFESSIONAL EXPERIENCE:

Confidential

Consultant - Senior Database Developer/Report Developer

Responsibilities:

• Create reports using SSRS
• Convert legacy code to SQL Server 2008R2
• Create pivot tables and spread sheets using Excel
• Design query execution plans
• Created UI for user to interact with reports

Confidential, California Edison

Consultant - Senior Database Developer/Data Analyst

Responsibilities:

• Analysis of data from summer events
• Convert legacy code to SQL Server 2008R2
• Gathered business requirements
• Gathered report specifications
• SQL programming including stored procedures, functions, tables and views per user requirements
• Create pivot tables and spread sheets using Excel
• Created applications in MS Access
• Design query execution plans
• Created UI for user to interact with reports

Confidential

Consultant - Data Analyst

Responsibilities:

• Created user front end using C# and VB .NET
• Rebuilt legacy applications to VS 2010
• Debugged application when users encountered problems
• Built new class modules to secure database connections
• Worked with Architects to ensure compliance with the Enterprise vision and implementation of DE Data Hubs
• Consulted with ETL designers and developers, making sure that the business rules are implemented
• Created tables based on user needs
• Performance tuning of stored procedures and functions
• Query analysis for best functionality
• Load testing of applications using SQL Server
• Wrote stored procedures and functions for.NET applications
• Designed and Developed data models (Conceptual, Logical, Physical)
• Developed Dimensions and Fact tables
• Loaded and transformed data for data warehouse and data mart using SSIS.
• Prepared Source to Target mapping and transformations
• Developed Fact tables and Processed Cubes
• Developed Multi-Dimensional models, hierarchies
• Translate relational data models to translational data models for SSAS cube development
• Developed applications for use of SSRS reports and data analysis
• Created robust report for different LOB’s to utilize their new reporting infrastructure.
• Consulted on report development using the BI infrastructure
• Created multi-dimensional data models for SSAS cube development using ERWIN and EA
• Aligned Hierarchies, Named Calculations, Named Queries and SQL to MDX
• Showed KPI’s and other analysis
• Attached OLAP to Excel for users to analyze data
• Participated in the design of data integration components including ETL, web services and message

Confidential

Consultant - DBA

Responsibilities:

• SQL programming including stored procedures, functions
• Created tables and views per user requirements
• Developed applications for use of SSRS reports and data analysis
• Created C# interface applications for reports
• Created business logic for middle tier web based applications using C# and VS Studio
• Wrote stored procedures and functions for.NET applications
• Created SSIS Packages that moved data from claims to HR for processing
• Source to target documentation
• SQL Server performance tuning
• Design or redesign query execution plans
• Replicated or databases and setting up user subscriptions
• Setup reporting for users to subscribe to published reports
• Setup reports server for SSRS
• Created the ETL process and validation
• Created UI for user to interact with reports on intranet site
• Implemented business logic for client applications using VS2008

Confidential

Consultant - Senior Database Developer/Data Analyst

Responsibilities:

• Gathered business requirements from attorney's
• Gathered report specifications
• SQL programming including stored procedures, functions
• Created tables and views per user requirements
• Create pivot tables and spread sheets using Excel
• Created ad-hoc query’s using MS Access
• Design query execution plans
• Created UI for user to interact with reports

Confidential

Consultant - Systems Analyst

Responsibilities:

• SQL Server 2008R2 Development
• Created tables, views, stored procedures and UDF's
• Developed Dimensions and Fact tables
• Loaded and transformed data for data warehouse and data mart using SSIS
• Prepared Source to Target mapping and transformations
• Created validation process for previous nightly load of data
• Created MDX queries for reports
• Processing cubes
• Scheduled reports to deliver through email

Confidential

Consultant - Senior Database Developer / Data Analyst

Responsibilities:

• Reconciled GL for accuracy
• MS SQL Server and SAS to perform data analysis
• Managed a reporting system and analysis database used for Credit Operations federal delinquency reporting
• Creation of database objects including tables, views, indexes and stored procedures
• Gathered data to create new algorithms to determine actions for delinquencies
• Gathered requirements for ETL and data mapping
• Liaison between IT and Under Writers
• Data extraction from MS Access and MS Excel using VB.NET, VB and VBA for automation and verification of data before final reporting
• Reconciled delinquency data between forecasters and data marts
• SSIS packages created by SSMS
• Cleansed Data, Gather Data to Load into Data Marts for reporting
• Used Management Studio and SSRS to modify existing reports
• Server Agent to schedule jobs for efficient use of resources
• Updated legacy code to more modern practices as needed.
• Created and performed ad-hoc queries

Confidential

Consultant - Senior Programmer Analyst

Responsibilities:

• SQL programming including stored procedures, functions, triggers
• SSIS packages Designed Control Flow, Data Flow
• Creation of database objects including tables, views, stored procedures, and functions
• Perform database tuning through methods such as reviewing indexing strategies, database and server configurations, and data access methods
• Setup test plans for validation and data integrity
• Analyzed data and relayed finding to management to determine escalation if needed
• Manage and implement schema and data dictionary change control.
• Created and performed ad-hoc queries
• Crystal Reports Enterprise XI
• Completed BRDs, FDDs
• Translate business requirements detailed technical documents and diagrams using Visio
• Gathered and defined requirements from PMO
• .NET C#, front end code writing and implementation for SharePoint
• Updated legacy code to more modern practices as needed.

Confidential

Consultant - Database Developer

Responsibilities:

• Deployed MS Access reports as applicable to Executive IT team members
• Analysis of data for credit operations
• Created validation for credit portfolio
• Scheduled and maintained existing reports
• Used Micro Strategy to create canned reports and queries

Confidential

Consultant - Senior Programmer Analyst

Responsibilities:

• Designed applications and reports for real estate portfolio management using VB.Net
• Wrote queries and stored procedures used to report on monthly, quarterly, and year-end earnings and projections as well as debt management for strategic planning.
• Created MS Access application front ends with SQL Server backend
• Tested and validated accounting balances verses IT calculations in database tables
• EBITDA reporting
• Built output to report generation of 8-K, 10-K, and 10-Q
• Gathered user requirements, developed, and maintained reports accessed through a report generation system utilizing Crystal Decision.
• Reconciled portfolio before report publication to SEC
• Managed software needed to report taxes and 1099 data to IRS.
• Trained Accounting users on the use of new reports and Federal Tax software

Confidential

Consultant - Software Application Developer

Responsibilities:

• Created web sites from ASP to ASP.NET, VB.NET
• Created business logic for the company’s online catalog
• Database development for the call center screens and data upload
• Web site middle tier and back end development

Confidential

Software Application Developer

Responsibilities:

• Created .NET web applications to work with Oracle modules
• Created flow charts and Erwin diagrams for Oracle and SQL Server databases
• DTS of old and new data for the Oracle upgrade.
• Created several user screens for users on a new Oracle system
• Business Requirements gathering, and testing of new modules