OBJECTIVE

• A collaborative, self-directed, business savvy, project oriented IT Professional with over 13 years experience in MS SQL Server, Oracle, Project Management, Reporting Tools, Software Development, Database Administration and Technical Training. High-energy team player with exposure to private and government sectors.
• IT Strategic Planning / Business Solutions / Team Leadership / Project Management / Vendor Relations

TECHNICAL EXPERTISE

• Operating Systems Windows 2008 R2, Windows 7/XP/2000/NT/98/95, AS400, 2003/2000 server, AIX UNIX, MS-DOS, IIS 5.0 6.0
• Databases MS SQL Server 2012, 2008, 2005 2000, Oracle 10, 9, 8, DB2, MySQL, MS Access 2005 2000, SYBASE, dBase
• Languages T-SQL, PL/SQL, XML, XQuery, Visual Basic, Visual Studio.NET, DotNetNuke, MS Visual Interdev, VB Script, J Script, C, HTML, ASP
• Software/Utilities Team Foundation Server TFS , BIDS, Tableau reports, Ms Visual Studio 2012, 2008 2005, SQL Server Reporting Services 2012, 2008 2005 SSRS , SSIS 2008 2005, IBM Navigator, SQL Sentry, Crystal Reports Business Objects Version: XI/10.0/9.0/8.5/8.0/7.0/6.0, Crystal Enterprise Web-based Reporting , Jasper Reporting, DTS, SDLC modeling, Microsoft Project, Microsoft Office Suite, ERwin, Active X, Net Objects Fusion 8.0, MS Front Page, Macromedia Dream Weaver, VMWare, MS Image Composer, Fortres, Cooler

PROFESSIONAL EXPERIENCE

Database Developer

Confidential

• Responsibilities include SSIS, SSRS, SQL Server development and project management. Work with end user to understand requirements and automate processes. Automate manual processes using TSQL, SSIS and SSRS
• ETL and SQL Server 2005, 2008 2012 development
• Creating reports using SSRS used tabular, matrix layouts, drill through and sub-reports to name a few
• Design ETL solutions using SSIS
• Train and work with junior developers to troubleshoot SSRS, SSIS and TSQL issues
• Troubleshoot and improve performance of queries, reports and ETL processes
• Data Analysis and Design
• Project management, analysis, design and implementation
• Convert Excel reports to SSRS
• Import data from multiple sources using SSIS
• Create Dynamic SQL statements
• Create Excel report using VBA
• Database Performance enhancements: Review existing functions and procedures and improve performance. Modified procedures and functions to increase performance by over 95 .
• Troubleshoot SQL code and resolve issues in existing code
• Work with team members to resolve issues with code
• Create procedures, functions, triggers
• Transform business logic into SQL scripting and SSIS processes
• Database management
• Document procedure and processes

Reports Developer

Confidential

• Responsibilities include Crystal Reports design and development using Oracle as the back-end
• Understand existing business processes and review specifications
• Design report using crystal reports
• Troubleshoot report formatting issues
• Oracle database: Review existing code and create new procedures
• Modify procedures to increase performance
• Develop and construct a variety of complex reports such as sub-reports, parameter based reports, cross-tab, graphical reports, formula based, well-formatted reports, drill-down reports, and analysis reports.

BI Developer

Confidential

• Responsibilities include Tableau reports, SSIS, SSRS, SQL Server development and project management. Work with end user to understand requirements and automate processes. Automate manual processes using TSQL, SSIS and SSRS
• Awards: Process Improvement Award
• ETL and SQL Server 2005, 2008 2012 development
• Creating reports using SSRS used tabular, matrix layouts, drill through and sub-reports to name a few
• Design ETL solutions using SSIS
• Train and work with junior developers to troubleshoot SSRS, SSIS and TSQL issues
• Troubleshoot and improve performance of queries, reports and ETL processes
• Data Analysis and Design
• Project management, analysis, design and implementation
• Convert Excel reports to SSRS
• Import data from multiple sources using SSIS
• Create Dynamic SQL statements
• Database Performance enhancements: Review existing functions and procedures and improve performance. Modified procedures and functions to increase performance by over 95 .
• Troubleshoot SQL code and resolve issues in existing code
• Work with team members to resolve issues with code
• Create procedures, functions, triggers
• Transform business logic into SQL scripting and SSIS processes
• Database management
• Document procedure and processes
• Build Data Warehouses
• Build Data Marts

Database Developer

Confidential

• Responsibilities include SSIS, SSRS, SQL Server development and project management. Work with end user to understand requirements and automate processes. Automate manual processes using TSQL, SSIS and SSRS
• ETL and SQL Server 2005, 2008 2012 development
• Creating reports using SSRS used tabular, matrix layouts, drill through and sub-reports to name a few
• Design ETL solutions using SSIS
• Train and work with junior developers to troubleshoot SSRS, SSIS and TSQL issues
• Troubleshoot and improve performance of queries, reports and ETL processes
• Data Analysis and Design
• Project management, analysis, design and implementation
• Convert Excel reports to SSRS
• Import data from multiple sources using SSIS
• Create Dynamic SQL statements
• Create Excel report using VBA
• Database Performance enhancements: Review existing functions and procedures and improve performance. Modified procedures and functions to increase performance by over 95 .
• Troubleshoot SQL code and resolve issues in existing code
• Work with team members to resolve issues with code
• Create procedures, functions, triggers
• Transform business logic into SQL scripting and SSIS processes
• Database management
• Document procedure and processes

Database ETL Developer

Confidential

• Responsibilities include ETL and database development, performance enhancements, issue resolutions and code review.
• ETL and SQL Server 2008 development: Extract, transform and load from multiple data sources to SQL Server 2008.
• Database Performance enhancements: Review existing functions and procedures and improve performance. Modified procedures and functions to increase performance by over 90 .
• ETL Performance enhancements: Optimize packages for performance, process optimization and automation
• Troubleshoot SQL code and resolve issues in existing code
• Train Junior developers in ETL and T-SQL
• Review and modify existing SSIS packages as per specifications
• Work with team members to resolve issues with code
• Create procedures, functions, triggers
• Transform business logic into SQL scripting and SSIS processes
• Document procedure and processes
• Database management
• Setup email notifications, schedule SQL jobs, setup operators and notifications
• Other job responsibilities similar to the ones performed from Feb 08 June 12 below

Crystal Reports Developer

Confidential

• Skillsets: Oracle 10g, crystal reports 2008, Unix
• Responsibilities include reviewing existing business processes and modifying critical crystal reports version: 2008 and PL SQL code in Oracle 10g database.
• Understand existing business processes and review specifications
• Code, test and debug existing crystal reports
• Troubleshoot report formatting issues
• Oracle database: Review existing code and modify procedures
• Modify procedures to increase performance
• Develop and construct a variety of complex reports such as sub-reports, parameter based reports, cross-tab, graphical reports, formula based, well-formatted reports, drill-down reports, and analysis reports.
• Work closely with QA resources to ensure the quality deliverables are in support of the business requirements

Senior Database ETL Developer

Confidential

• While working in an Agile environment create a data warehouse from three different data sources. Responsibilities include extract, transform and load data, extensive database scripting and troubleshoot current issues while training multiple developers in ETL, database procedures and processes.
• ETL and SQL Server 2008 development: Extract, transform and load to data warehouse from multiple data sources over 3000 tables to SQL Server 2008.
• Create SSIS templates
• Performance management: Optimize packages for performance, process optimization and automation
• Train Client and Junior ETL developers in SSIS
• Create procedures and policies for ETL development
• Understand business requirements and transform it into scripts and code
• Work with end users to design data model
• Design scripts for reporting to track, performance and usage statistics
• Creating procedures, SQL scripts, functions using T-SQL
• Work with team members on multiple tasks to troubleshoot and resolve existing scripting errors and issues
• Database administration, setup maintenance plans for backup, indexing and statistics , automate maintenance processes and manage database performance issues.
• Reverse engineer existing processes to transform them into meaningful code
• Setup documentation procedures
• Document process flows
• Other job responsibilities similar to the ones performed from Feb 08 Feb 12 below

Database ETL Developer

Confidential

• Manage Worldwide Disney consumer products sales analytics. Responsibilities include extracting and transforming retail sales, promotions and discount data for all Disney stores in North America and European regions. D.A.T Black Friday analytics support and database management.
• ETL and SQL Server 2008 development: Extract, transform and load to data warehouse from AS400 to SQL Server 2008.
• XML: Retrieve XML data from AS400 using XQuery to transform and insert data into database tables. Create XML schema collections.
• 24/7 database support and administration: Database administration, setup maintenance plans for backup, indexing and statistics , automate maintenance processes and manage database performance issues.
• Performance management: Optimize packages for performance, process optimization and automation
• Work with MicroStratergy to optimize SQL
• Seasonal Sales Analytics support
• Other job responsibilities similar to the ones performed from Feb 08 July 10 below

Database ETL Developer

Clients: American Reality Advisors, ABPA-American Benefit Plan Administrators Medical Insurance, Trust Fund Management, Medical, Dental Vision Plan Management , IEHP-Inland Empire Health Plan Medical Insurance Industry , Talon International Fashion Industry , City of Rancho Cucamonga City Government , City of West Covina City Government , City of Anaheim City Government

Primary responsibilities include create reports using SSRS 2005 , application support, Extract Transform and Load ETL Data from various sources manipulate close to 15 million records per table , and Crystal Reports XI or earlier , Migrate data from SQL 2000 to SQL 2005, Project Management, Requirement Analysis and Documentation. Manage junior developers and train them in reporting tools, procedures policies and documentation guidelines. Manage projects and resources to achieve desired project objectives. Make sure that documentation and procedures are up to HIPAA standards.

Database management:

Tune complex T-SQL PL/SQL statements, create tables and views, write insert and update statements, analyze and create indexes

Work with end-users to understand their needs and transform the data to meet their needs

SQL 2005 and SQL 2000 management and administration

Write complex queries to extract and analyze data Data Mining

Create and maintain databases in Access

Create views to isolate and get required information while increasing query performance and return time

Export data to Excel, text files and various other sources

Work with Excel to manipulate data, create pivot tables, write functions, create macros and create graphs

Automation: Analyze the current processes, procedures and provide solutions using MS Excel, MS Access, SQL Server, SSRS and SSIS thereby reducing duplication of effort and improving efficiency.

Reporting Tools: Create reports using SSRS 2005 and Crystal Reports XI and earlier . Created reports for Customer service, Operations, Finance, Purchasing, Accounts Payable, Accounts Receivable, General Ledger, Inventory and Sales. Develop and modify various analytical, financial, monthly, year-end reports, while utilizing sub-reports, formulas, views, SQL queries, custom functions, procedures, parameters, cascading parameters, dynamic sorting, graphs, cross-tabs, etc. Design reports for financial, permitting and Data Warehouses.

SSIS SQL Server Integration Services :

• Work with Business Analysts and end users in translating business requirements.
• Create SSIS Packages to move data between the Staging server and Data warehouse. Load data from various sources, cleanse, transform data and schedule jobs. Convert and rewrite old DTS Packages to SSIS. Migrating data from SQL 2000 to 2005.
• Tools used: Connection Managers, Control Flow Tasks like For Each Loop Container, Sequence Container, Send Mail, Execute SQL Task, File System Task, etc., Data Flow Sources, Transforms and Destinations like Text Files, OLE DB Source and Destination, OLAP, Audit, Transforms, Conditional Split, Data Conversion, OLE DB Command, etc., , Logging, Package Configuration XML, SQL Server, Registry Entry, etc., and Error Handling.
• Create, maintain, review and modify Template packages that are used by other in-house developers. Define, review and document standards for SSIS Package usage, error handling, logging and package configurations.
• Train, mentor and assist staff in SSIS
• Suggest ways to rewrite loads to increase load speed and improve error handling and communication.

Development Tools: Work with Visual Studio 2008 2005 to retrieve information from different data sources, create and modify applications using Visual Basic.

Project Management: Perform need analysis, requirement analysis, research, estimate and analyze the components involved in automation, application security enhancement and database migration projects from SQL Server 2000 or earlier to SQL 2005 . Determine the scope of work for database migration and Database Failover Plans.

Information Systems/Services Analyst

Confidential

• Primary responsibilities include project management, vendor management, supervision, systems analysis and design, application support, database management design and reporting tools management crystal reports and other reporting tools .
• Database management PL/SQL Transact SQL : Manage MS SQL Server databases 2000 2005 security user management, analysis, backup, database optimization, migration, indexing, SSIS, DTL etc., Access and Oracle databases in Windows and UNIX environments. Design, develop and document queries, views, procedures and triggers in SQL Plus and T-SQL. Work with DTS and SSIS to import and export data from various sources. Retrieve information from several data warehouses for analysis.
• Advanced reporting tools management: Create, troubleshoot and maintain reports for 8 different software applications financial, registration, permitting, ticketing, etc., that use reporting tools like Business Object's Crystal Reports 8, 8.5, 9, 10 XI, SQL Server Reporting Services SSRS and other custom reporting tools. Setup and Maintain Crystal Enterprise. Database sizes vary from 50 to over 1000 tables per database. Developed and modified over 1500 financial, analytical, monthly, year-end reports, which include sub-reports, formulas, views, SQL queries, custom functions, procedures, graphs, cross-tabs, etc.
• Project management: Assist in purchasing new software, analyze user needs, requirement analysis, technical specifications, tasks, deliverables, RFP process, technical expertise, time management, team communication, manage resources, perform research, coordinate software demonstrations, prepare appropriate documentation, vendor management, prepare requisitions, provide application support, server configurations, database management. Implementation of the following projects was done while meeting 99 service level agreements while reducing 40 delay in processing time and 50 decrease in processing errors.
• Participated in following projects as project manager co-project manager during implementation:
• Volunteer Management System
• EPayment system
• Telephone Interactive Voice Response System Online Permit Mgmt. System
• Asset Management system for Theater and City Yard
• Tree Management system geographic mapping software used to track tree locations in a defined area
• GeoSmart software interacts with exiting ArcGIS database to provide interactive geographic maps for end-users
• Training: Train users in crystal reports and other applications and create training material and document procedures as necessary for end-users.

Application management and systems analysis: Provide technical expertise, support, upgrade and maintain Tidemark permitting system, IVR, web-based registration, web e-payment, asset management and tree management applications. Provide backup application support for financial management Bi-Tech IFAS , Class registration and ticket management applications. Provide secondary backup for 8 different web and desktop financial, registration, ticketing and licensing applications. Primary database back-end Oracle and MS SQL Server.

Miscellaneous: Write macros in excel and import and export data to and from Excel. Diagnose hardware and software issues and provide end-user support Help Desk for Windows XP, 2000, Windows 2000. Design, configure and maintain kiosks.

Confidential

Software Consultant

Finesse Personnel Associates,

Summary: Worked with various city governments and private organizations while providing application support, primary crystal report developer, crystal enterprise support, worked with PL/SQL and T-SQL, database s design, development and implementation, served as a Technical Advisor/ technical consultant for various important software implementations

Software Developer

Confidential

Summary: Served as a Technical Advisor for various important software implementation projects for City of Rancho Cucamonga. Primarily responsible for design and development of crystal reports for a permitting software application.

Programmer Assistant

Confidential

• Summary: University Database management, System support and maintenance
• Digitized over 50 maps for Nevada Townships using ARC Info Software
• Maintenance of the CASAT clearing house database reducing transactional process time by 35
• Helped develop electronic functionality for web page for the University of Nevada medical school

Software Developer

Confidential

Summary: Designed various database applications like Inventory Management System, Invoice Billing System and Employee Information System. Performed user analysis, created the database and also created different modules in Visual Basic. Design and developed various relational database schematics custom to TA Hydraulics saving process times by 15 and Cost reduction by 23 . Designed tables and developed triggers according to the various business requirements. Create front-end applications and develop customized reports using the Crystal Reports