SUMMARY

• 13+ years of experience in SQL Development using SQL Server 2005/2008/2008 r2/2012/2014 and in Data Warehousing using Business Intelligence Development Studio 2005/2008/2008 r2/2012 and Data Tools for 2014.
• Experience in designing and creating technical specification documents such as Data Dictionaries, Business Requirement documents, Test documents, Diagrams, and Procedural documents.
• Expertise in gathering requirements for various types of projects and actively involved in Project Management along wif the Project Manager to ensure a successful delivery of completed system.
• Experience in QA test. Executed UAT, Stress testing, Unit testing, and Functionality testing.
• Extensive experience in implementing SSIS Transformations such as Slowly Changing Dimensions (Type 1 & 2), Look up, Derived Column, Aggregate, Fuzzy Lookup, Multicast, Conditional Split, Data Conversion etc.
• Extensive experience in using SQL Server Agent for Scheduling Jobs which in turn would contain SSIS Packages to run.
• Experience in creating cubes using SQL Server Analysis Services.
• Experience in creating various reports using SQL Server Reporting Services.
• Experience in T - SQL, Stored Procedures, Functions, Database Triggers.
• Self-Starter who can adapt and learn fast wif excellent communication & interpersonal skills.
• Excellent Analytical and Problem Solving Skills.

TECHNICAL SKILLS

ETL Tools: SQL Server Integration Services 2005/2008/2008 r2/2017

Database: SQL Server 2005/2008/2008 R 2/2012/2014/2017, Oracle 9i/10G, MS-Access, MS-Excel

BI Tools: Business Intelligence Development Studio( 2005/2008/2008 r2/2012), SQL Server Data Tools 2014, SQL Server Analysis Services 2005, SQL Server Reporting Services 2005, Visual Studios 2015, Visual Studios 2017

Others: Visio, ERWin, MS-Office, Share Point, SQL Developer, Batch files, EM Editor

PROFESSIONAL EXPERIENCE

Confidential, Temecula, CA

SQL/ETL Developer/Data Analyst/Report Writer

Responsibilities:

• Work wif company support/sales/implementation managers and client for gathering detailed requirements and specifications.
• Trouble shoot issues that client is having wif their current processes/reports. Required to create new processes/reports per specifications.
• Design and create ETL packages to pull from flat files, excel sheets and push into SQL Server 2017 instances using Visual Studios 2017 SSDT.
• Utilized various SSIS Transformations such as FTP Task, Derived Column, Execute SQL Task, Execute Package Task, Flat File Transformation and OLEDB Source and Destination Transformations.
• Weekly meetings for progress reports on technical issues, status reports, and new requirements.

Environment: SQL Server 2017, Visual Studio 2017 SSDT, Windows 10, Power Shell, Github

Confidential, San Diego, CA

SQL/ETL Developer/Data Analyst

Responsibilities:

• Work wif key personnel such as End Clients, DBA’s and Data Custodians for gathering detailed requirements and specifications.
• Analyze, document, and test SSIS packages, stored procedures and job agent tasks for possible errors and optimization.
• Design and create ETL packages to pull from flat files, excel sheets or other SQL Servers instances and push into SQL Server 2008 R2/2012 or 2014 instances.
• Develop test packages to simulate errors and notifications for implementation into final packages.
• Created and implemented package configurations on the production, development, and test environments.
• Utilized various SSIS Transformations such as FTP Task, Derived Column, Execute SQL Task, Execute Package Task, Flat File Transformation and OLEDB Source and Destination Transformations.
• Weekly meetings for progress reports on technical issues, status reports, and new requirements.

Environment: SQL Server 2008 R2/2012/2014, Business Intelligence Development Studio 2008/2012 and Data Tools, SVN (Subversion), Windows 7/10, starting SQL Server 2016 and Visual Studios 2015.

Confidential, San Diego, CA

ETL Developer/Data Analyst

Responsibilities:

• Work wif key personnel such as End Clients, DBA’s and Data Custodians for gathering detailed requirements and specifications.
• Analyze, document, and test SSIS packages, stored procedures and job agent tasks for possible errors and optimization.
• Design and create ETL packages to pull from flat files, excel sheets or other SQL Servers instances and push into SQL Server 2008 R2 or 2012 instances.
• Develop test packages to simulate errors and notifications for implementation into final packages.
• Created and implemented package configurations on the production, development, and test environments.
• Utilized various SSIS Transformations such as FTP Task, Derived Column, Execute SQL Task, Execute Package Task, Flat File Transformation and OLEDB Source and Destination Transformations.
• Weekly meetings for progress reports on technical issues, status reports, and new requirements.

Environment: SQL Server 2008 R2, Business Intelligence Development Studio, VSS (Visual Source Safe), Windows 7, SQL Developer.

Confidential, San Diego, CA

ETL Developer/Data Analyst

Responsibilities:

• Work wif key personnel such as End Clients, DBA’s and Data Custodians for gathering detailed requirements and specifications.
• Analyze, document, and test SSIS packages, stored procedures and job agent tasks for possible errors and optimization.
• Design and create ETL packages to pull from Oracle 10G and push into SQL Server 2008 R2
• Develop test packages to simulate errors and notifications for implementation into final packages.
• Created and implemented package configurations on the production, development, and test environments.
• Utilized various SSIS Transformations such as Look up, Derived Column, Execute SQL Task, Execute Package Task, Multicast, Data Conversion and Derived Column. Also utilized 3rd party transformation form Cozy Roc and Atunity like Lookup Plus, Oracle source transformation, Excel plus Transformation.
• Weekly JAD meetings for progress reports on technical issues, status reports, and new requirements.

Environment: SQL Server 2008 R2, Business Intelligence Development Studio, TFS (Team Foundation Server), Windows 7, SQL Developer.

Confidential, Shreveport, LA

ETL Developer/Data Analyst

Responsibilities:

• Work wif key personnel such as End Clients, DBA’s, Data Custodians, and System Users for gathering detailed requirements and specifications.
• Analyze, document, and test SSIS packages, stored procedures, views, and job agent tasks for possible errors and optimization.
• Design and create ETL package to interact wif the different source systems wifin the casino industries such as IGTA, Oasis, LMS, or Sysco. These source systems would lie on database platforms such as Oracle, AS400, SQL 2005, DB2 and other custom built databases.
• Develop test packages to simulate errors and notifications for implementation into final packages.
• Created and implemented package configurations on the production, development, and test environments.
• Utilized various SSIS Transformations such as Slowly Changing Dimensions (Type 1 & 2), Look up, Derived Column, Execute SQL Task, Execute Package Task, Multicast, Data Conversion etc.
• Weekly JAD meetings for progress reports on technical issues, status reports, and new requirements.

Environment: SQL Server 2005/2008, Business Intelligence Development Studio, Share Point, VSS (Visual Source Safe), Windows XP.

Confidential, Boise, ID

ETL Developer/Data Analyst

Responsibilities:

• Work wif key personnel such as End Clients, DBA’s, Data Custodians, and System Users for gathering detailed requirements and specifications.
• Created documentation for readability of code and understanding of packages wif data dictionaries, data mappings, step by step data processing, and package annotations.
• Created Test plans and Test cases for the QA process. Tested each package per plan and case scenario.
• Design and create ETL package to interact wif multiple databases such as Oracle, SQL 7.0, SQL 2000, SQL 2005 and a custom built database.
• Design and develop a master plan to handle errors and notification emails.
• Created and implemented package configurations on the production, development, and test environments.
• Utilized various SSIS Transformations such as Slowly Changing Dimensions (Type 1 & 2), Look up, Derived Column, Execute SQL Task, Execute Package Task, Web service Task, Multicast, Data Conversion etc.
• Automated the execution of packages by implementing a Master Child package and the SQL Server Job Agent according to the designated time frame.
• Created and documented a disaster and recovery plan.
• Weekly JAD meetings for progress reports on technical issues, status reports, and new requirements.
• Created a time table for UTC date time processing.

Environment: SQL Server 2005, Business Intelligence Development Studio, Share Point, VSS (Visual Source Safe), Windows XP/Vista.

Confidential, Phoenix, AZ

Business Analyst/ETL Development

Responsibilities:

• Analyze and comprehend the structure of the data in the source databases and the destination databases to determine where issues would cause problems based on the Business Requirements.
• Gather requirements by conducting JAD meetings and special sessions wif key personnel and end users.
• Designed and created specific technical documents such as a Data Dictionary, Data Flow document, Relationship schema, and Process and Error Log manual.
• Develop test packages to simulate errors and notifications for implementation into final packages.
• Create a development and test environment for the redesigned SSIS packages.
• Optimized and documented existing ETL packages to process data faster.
• Created various QA test plans and scenarios for UNIT TESTING, UAT, STRESS TESTING, and INTEGRATION TESTING.
• Classified packages into a Master Child Package Hierarchy and scheduled the Master Package using SQL Server Agent.
• Analyzed re-designed reports to better suit the client and user’s needs.

Environment: SQL Server 2005, Business Intelligence Development Studio, VSS (Visual Source Safe), Windows XP.

Confidential, Phoenix, AZ

ETL Developer/ Data Quality Analyst

Responsibilities:

• Analyze and comprehend the structure of the data in the source databases and to design the ETL architecture in SSIS 2008.
• Created User Defined Stored Procedures and Functions.
• Created ETL packages using SSIS to populate the data warehouse utilizing various SSIS Transformations such as Slowly Changing Dimensions (Type 1 & 2), Look up, Derived Column, Merge Join, Fuzzy Lookup, Multicast, Script Component, Data Conversion etc.
• Classified packages into a Master Child Package Hierarchy and scheduled the Master Package using SQL Server Agent.
• Utilized various troubleshooting techniques to optimize and speedup the processing time for each package.
• Conducted unit testing, stress testing, and functionality testing to each package before approval of completion of package.

Environment: SQL Server 2008, Business Intelligence Development Studio, TFS (Team Foundation Server), Windows XP.