SQL Developer / BI Developer Resume Hayward, CA - Hire IT People

SUMMARY

6+ years experience in developing and testing ETL packages and BI applications using MS SQL Server, Data Warehouse, SSIS, and SSRS
6 years of experience working as SQL Server Developer
Strong skills in writing complex SQL queries
4 years of experience on developing Crystal Reports
Sound understanding in SSAS, OLAP cube and Architecture.
Knowledgeable in Star/Snowflake Schemas
Extensive experience in developing/executing Test Plans, Test Cases and Test Scripts
Solid analytical and problem solving skills, ability to work independently and in team - oriented, work well under pressure

TECHNICAL SKILLS

BI Tools: MS SQL Server SSIS, SSRS, SSAS, Crystal Reports

Database: SQL Server 2005/2008 R2/2014, Data Warehouse, MySQL.

Text Editors: SMS, Eclips, Visual Studio

Source Control: Git, Jira, TFS

Testing Tools: Selenium, JUnit, TestNG, QTP, Quality Center

PROFESSIONAL EXPERIENCE

Confidential, Hayward, CA

SQL Developer / BI Developer

Responsibilities:

Develop SQL queries, stored procedures, views and UDF. Work on performance tuning using SQL Profiler and Index Tuning Wizard.
Create SSIS packages on transforming data from Flat file/Excel file, source databases to target SQL database for generating BI reports using SSRS and Crystal Reports.
Discuss business requirements with all parties. Generated Data Mapping documents and technical specifications
Develop SSRS reports, manage and deploy SSRS reports on web portal.
Data Migration from SQL server 2008R2 to SQL Server 2014.
Perform the unit and functional testing to validate the data is extracted, mapped or transformed and loaded correctly in target tables.
Implemented Selenium automation test scripts in Java language. Refactored testing code by setting up testing framework utilizing JUnit and TestNG.

Environment: SQL 2008 R2/2014, SSIS, SSRS, Crystal Reports 12, Visual Studio 2012, Selenium 2.45, Eclipse 4.4, Xpath Helper, Jira, HTML, CSS, Java, PayPal Integration, Photoshop, Google Docs, Google Sheets .

Confidential, Ann Arbor, MI

SQL Developer / BI Developer

Responsibilities:

Translated system and subsystem requirements into test cases on Seapine.
Proceeded V&V testing, Functional Testing, Positive Testing, and Negative Testing against user interface.
Tested all Biological Parameters defined by requirements.
Tested the UIS Emulator.
Troubleshooting defects root cause. Reported testing estimates, status, timeline, showstopper frequently.

Environment: Windows 7, 64 bit OS, Java platform, Seapine

Confidential

BI /SQL Developer

Responsibilities:

Designed business reports using Crystal Reports and SSRS based on business requirements.
Wrote complex SQL queries, Created and Maintained SQL Stored Procedures and UDFs.
Worked on Data Conversion and Data Migration using SSIS packages across different databases like Data warehouse, MS access and flat files.
Worked withSSASoncubes, dimensions and MDX.
Performed functional, and regression testing against the releases.
Wrote and executed automated test scripts (VB Script) using QTP for regression testing.
Tested Web Services on SoapUI Pro. Diagnosed XML DTD data types and validated XML data based on SoapUI request and response.
Performed Backend Testing. Tested database objects, including stored procedures, views, functions, and triggers.
Troubleshoot production database issues.

Environment: Windows 7, Windows XP, Mac, QTP9.1, QC9, VB Script, .NET Framework, Crystal Reports 10.5, SQL 2008, SoapUI 4.5, Agile, TFS, HTML/DHTML, CSS, Selenium.

Confidential, Redford, MI

SQL Server / BI Developer

Responsibilities:

Collaborated to support Agile planning, estimation, and execution processes.
Created SSIS packages for extracting massive data from third parties including Flat files, Excel files, and OLE DB data sources, data transformation, and loading.
Developed Daily/Weekly shipping schedule Reports including Packing List, Bill of Lading and Invoice using Crystal Reports and SSRS.
Handled SSIS and SSRS deployment.
Worked on performance optimizing and improving of SSIS packages.
Developed T-SQL stored procedures, functions, triggers and views.
Built database backup and restore plans.
Actively involved in creating and implementing test plan and test case document.
Performed defect reporting and defect tracking using Mercury Quality Center (QC).

Environment: Windows 7, Windows XP, Windows 2000, SQL 2008 R2, Crystal Reports, SSIS, SSRS, QC9, QTP, Agile.

We provide IT Staff Augmentation Services!

Sql Developer / Bi Developer Resume

Hayward, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship