PROFESSIONAL SUMMARY:

• Over 20 years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2012, 2008/2005/2000 DTS/SQL Server Integration, Reporting & Analysis Services.
• Extensive SQL Development experience in Oil & Gas, Petro - Chemical and Healthcare industries with a strong understanding of data & analytics.
• Hands on experience in installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2012/ 2008/2005/2000 .
• Experience in Upgrading of SQL Server 2000/2005 databases to SQL Server 2005/2008.
• Extensive experience in using T-SQL (DML, DDL) in SQL Server 2008/20005/2000 platforms.
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
• Expert Experience in Normalization, De-normalization.
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio.
• Experience in creation of Database authentication modes, configuring permissions and assigning roles to users.
• Skilled in Business Intelligence tools like SQL Server 2005 Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
• Expertise in building and migration of various DTS packages.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Ability to define and develop Report Structure with data definition, report layout and report definition language.
• Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services.
• Excellent in rendering reports, managing subscriptions, creating reports with report builder, report snapshot and report cache.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Hands on experience with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2012 Analysis Services.
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.

TECHNICAL SKILLS:

Databases: SQL Server 2005/2008/2012 , MS Access 2000, MS Excel, Oracle 9i/10g, Mainframes, DB2

Programming Languages: T-SQL, PL/SQL, VB.NET,ASP.NET HTML, XML, Java

Operating Systems: Windows 98/2000/2003/ XP/NT/Vista, Windows 2000Advanced Server, Windows

IDE & BI Tools: SQL Server BI Development Studio (BIDS), SharePoint, MS Visual Studio 2008/2012

Version Control: Team Foundation Server (TFS), Visual SourceSafe (VSS).

ETL Tools: SSIS, DTS

Data modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007

Methodology: Agile-Scrum

Packages: Microsoft Office 2007/2003/2000

Front End: ASP.NET and VB.NET

PROFESSIONAL EXPERIENCE:

Confidential, Houston, Texas

SQL Developer/ Team Lead

Responsibilities:

• Requirements Gathering - meet with internal and external partners to identify data needs.
• Logical Data Model - Using CA Erwin, created the repository logical data model.
• Physical Data Model - Using CA Erwin, created the Physical Data Model to include all attributes.
• Mapped the Physical Data Model to source systems (OTPS).
• Designed and co-developed the SSIS packages needed to move the source systems data into the repository.
• Using SSAS, design and developing multi-dimensional cube used by internal shareholders;
• Created data source connection
• Created Data Source View, select dimensions and fact (start schema).
• Created Cube, selecting measure and attributes.
• Created Cube, selecting dimension and attributes, and hierarchy and relationships.
• Deployed Cube to Analysis Service database.
• Process Cube loading data from the OLAP source.
• Designed and co-developed parameter driven SSRS reports (tabula, matrices and charts).
• Designed and developed a series of stored procedures using DML and DDL statements preparing SQL tables for migration.
• Designed a suite of ETL (SSIS) packages to migrate data to External partners.
• Implemented Cube Partitioning and Refresh strategy for monthly delivery.

Confidential

SQL Server BI Developer, Houston, Texas

Responsibilities:

• I was hired to design and develop a data warehouse to catalog claim on behalf of Berkley’s claims. Claims were captured into multiple source systems. There were 1.5 billion claims comprising the initial load. The steps to create the claims warehouse are as follows:
• Gathered Data Requirements, meet with internal and external partners to identify data needs.
• Logical Data Model - created the logical data model using VISO 2012.
• Physical Data Model - Using VISO 2012, created the Physical Data Model to include all attributes.
• Mapped the Physical Data Model to source systems (OTPS).
• Designed-co-developed the SSIS package to move the source systems data into the repository.
• Utilized SQL Agent to schedule multiple ETL (SSIS) batch runs.
• Designed and co-developed parameter driven and business critical SSRS reports (tabula and charts).
• Designed ASP.Net 4.0 maintenance application, allowing business users to resolve data integrity issues.
• Provided error handling using SQL Transactions and SQL Mail.
• Provided end user and end user support documentation.

Confidential, Houston, TX

Trade / Credit Risk Support Analyst/ SQL Developer

Responsibilities:

• Provide Level 2 support for the Energy Credit and Trade Application.
• Design and develop stored procedures to deliver trade and credit information to shareholders.
• Utilized VB.Net to extend the Trade and Credit Application.
• Utilized Crystal Reports to add additional report capacity.
• Developed the Vital Stats ASP.Net web page.
• Provided data analysis via SQL Query and PL SQL. Design SQL Queries both Oracle and SQL Server to extract financial information such as AR/AP data for the Trading application in support of risk management decision.

Confidential, Houston, TX

Technical Analyst / Support Analyst

Responsibilities:

• Provide Allegro Trading and Risk Management Support for 10 Traders and 7 Supply Chain Reps, at support levels one and two.
• Developed the Market Price interface, vb.net front-end, and SQL Server e back-end.
• Developed T-SQL stored procedure that provided on demand market price data for refineries.
• Implement and upgrade Prophet X which is intergraded with Allegro Trading and Risk Management application.
• Used CWI case tracking application to record and management support cases.
• Developed and Implemented new procedures in support of help desk cases.
• Developed and Implemented computer based courses in support of help desk cases.
• Conduct shareholder, and presentations using Power Point.
• Create spreadsheet with VBA technology to compute trade prices and calculate shipments delivery windows.
• Develop a custom manual for the Trading application. Scope: Trade Deals, Trade Risks Valuations, Shipment Schedules and Settlements.
• Participated in the selection and implementation of CWI which is Help Desk Tracking Software. Provide to Business to Business partners who are a part of the Trading application integration layer.
• Designed Application Test Cases, and correction scripts.
• Utilized Query Tool to perform data analysis in support of help desk cases. Expertise with: Inner Joins, Left Outer Joins, Right Outer Joins, Sub Queries, Inserts, Updates, Deletes, Stored-Procedures and Views.
• Designed and implement the Marine Schedule report using Crystal Reports XI - stored procedures driven.
• An active member of the Business to Business integration team relative to Trading.

Confidential, Houston, Texas

SQL Server & Crystal Reports Developer

Responsibilities:

• Confidential provides health insurance coverage for citizen over 65, or disabled.
• Using FACETS medical database as the company on-line transaction process systems; my job was to provide dynamic query and static report support to the Claim and Marketing department.
• Create a data mart that contains claim information.
• Gather the data mart data requirements, meeting with claims and marketing personnel.
• Design and developed the Logical and Physical models.
• Provided Fact Modeling (claims count and claims amount).
• Provide Dimensional Modeling (organization and date time).
• Used SSAS to create Claims cube.
• Develop SSIS packages migrating data from the (FACETS) source system.
• Provided Excel and Poly Vista for cube browsers.
• Developed multiple Crystal Reports.
• Provided multiple adhoc T-SQL queries.

Confidential, Houston, Texas

SQL Server & Crystal Reports Developer

Responsibilities:

• Lead Crystal Reports Developer for Confidential .
• Wrote stored procedures that prepared data for processing by Crystal XI.
• Used report features such as record selection at the group and record levels, data parameters, sorting, use of the distinct record feature, sub reports, cross-tab and charting.
• Developed summary and detail level reports.
• Worked with running totals, and trained end-users to create Crystal Reports.
• Performed such database activities as Profile Trace, Data Modeling, View Creations, Functions Creations, Constraints, Indexing and Table Creations.
• Created DTS packages that execute store procedures to transfer data to Excel.
• Experienced interface developer using both Java and VBScript.
• Converted several VB6 utilities to VB.Net.
• Developed the Hayes Interface, which is Export agent. It allows business-to-business information sharing of student information using SQL Server and Oracle 11 as the back-end.
• Converted 80 Crystal 7 and 9 reports to Crystal XI with SQL Server on the back-end.
• Created Crystal Reports to interface with Oracle, SQL Server and Sybase.

Confidential, Dallas, Texas

Senior Application Developer / Technical Analyst

Responsibilities:

• Using ASP.Net developed the company’s flagship Record Management Software products.
• Duties included business systems analysis, business systems design, database design, project management, product development, automated and manual testing, end-user and change management.
• Confidential is a company, which requires experience among multiple technology paths.
• Routinely follow PMI’s project management strategy to organize all project activities.
• Core technologies were ASP Net, Crystal 7-11, PL/SQL, SQL Server, VBScript, JavaScript, VB.Net., VBA and VB6.
• Developed and supported web-based LMS application (EKOS) to include interactive and testing.
• Designed and developed Auto Dealer management systems, to include, Sales Contracts, Inventory Purchasing, Sales Revenue reporting, Spare Parts Inventory management, Expense tracking, AR,AP and Payroll.

Confidential, Houston, Texas

Development Manager / Business Analyst

Responsibilities:

• Served as the Business Analyst gathering specifications for functional programs such as Order Entry, Scheduling, Routing, Inventory Management, Great Plains Accounting System Interface, Compliance Reporting and Personnel Management.
• Managed the development of IMS cradle to grave (SLDC).
• Scheduled deployment of IMS for 40 U.S. and Canadian locations. Hands-on experience was required.
• Worked with technology such as VB6, Sybase, Crystal Reports 7 and a host of third party tools.