SQL Developer Resume San Francisco, CA - Hire IT People

SUMMARY

Strong experience in gathering business requirements and translating business requirements to technical solutions.
Strong experience in designing and implementing Stored Procedures, user defined functions, triggers, and T - SQL scripts and PL/SQL Script (Oracle and Netezza).
Professional experience of SQL Server 2008 Database model and Performance tuning, query optimization, and troubleshooting (error handling).
Strong experience in designing and developing ETL packages (SSIS) with variables, parameters, and expressions and error handling, logging and deploying creating and scheduling SSIS packages in SQL agent to load data to data warehouse or OLTP database.
Good experience in troubleshooting and performance tuning of SSIS packages.
Experience in designing, creating, and processing cubes in SSAS (KPI); writing MDX queries and Data Mining Models.
Extensive experience in designing and developing data-driven SSRS reports from OLTP tables or SSAS cubes using tables, matrices, charts, and dashboards with drill-down and drill-through capabilities and cascading parameters and scheduling and granting permissions on reports in Report Manager and Share Point 2010.
Good experience in MS Excel (Power Pivot) and access.
Working noledge and experience of VB.NET, C#.NET and Unix.
10+ years of team and individual project experience and leading multidisciplinary teams and project management.
Strong in Documentation and team player with great verbal, written communication and interpersonal skills.
Quick learner, detailed-driven, hard worker, willing to take responsibilities.

TECHNICAL SKILLS

RDBMS/DBMS: IBM Netezza, MS SQL Server 2005/2008/2008 R2/2012, Oracle 11g/11gR2, Crystal Reports MS Access 2007/2010.

Programming Languages: T - SQL, MDX, VB.NET, DMX, PL/SQL, C#, VBA, XML.

Software: SSIS, SSRS, SSAS, OLTP, OLAP, SQL Server Management Studio (SSMS), TOAD, JIRA.

Reporting Tools: SSRS, MS Access, Excel, Power Pivot.

ETL Tools: SSIS, Bulk insert, Bulk Copy Program, Oracle SQL* Loader, Import/Export Wizards

Web Servers: SharePoint (MOSS) 2010, Performance Point Server

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

Operating Systems: Windows XP/Vista/7/8, Windows 2008/2008R2/2012 Enterprise Server, Mac, Unix.

Other: Microsoft Visio, Microsoft Studio 2010(TFS), Microsoft Office (PowerPoint/Word), SVB(subversion).

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

SQL Developer

Responsibilities:

Designed and developed SQL batch to load stage data into Target Data in Oracle/Netezza databases
Designed and developed scripts for union test of data from multiple sources and targets
Tested incremental data with Unix and SQL scripts
Organized teh process of project with JIRA
Planed and documented all processes of code design, union test and incremental test

Confidential, Plano, TX

SQL/ETL Developer

Responsibilities:

Loaded mortgage data from excel files to SQL database tables with Bulk insert from remote desk.
Created complex stored procedure to archive database.
Created multiple ETL(SSIS) packages for archive and delete data in product system with database model of creating schema, tables, views, indexes, constraints (PK, FK), partition, stored procedures, functions including T-SQL variables and SSIS variables; monitoring performance of SQL queries and SSIS packages, handing errors with error tables, Try/Catch and SSIS login (xml), SSIS configuration and integrated all database archive and delete SSIS packages, maintained tables and deployed teh packages to SQL server agent.

Confidential, Plano TX

SQL/ SSIS Developer

Responsibilities:

Extracted and analyzed data from various sources, including databases, Excel files through internal environment.
Led team in performance tuning and troubleshooting all SSIS packages.
Created SSRS reports of various formats and delivered reports to report managers.

Confidential, Dallas TX

SSIS/SSRS Developer and Database Administrator

Responsibilities:

Designed and developed SSIS packages to extract, re-format, and load data from 300+ data sources coming from 37 clinical centers, multiple hospitals, and private clinics (Excel and Access) into back-end OLTP database tables.
Extensively usedSSIS Import/ExportWizard for data migration among different EMR instances.
Created and updated complex stored procedures, triggers, and user defined functions for logical T-SQL.
Communicated with other branches and troubleshot data inconsistency.
Designed and developed sub-reports, drill-down reports, parametric reports, matrix, summary SSRS reports and data-driven subscriptions to generate and email reports on a daily and weekly basis.
Deployed SSRS reports, Excel reports (Power Pivot), and Access reports to SharePoint 2010 Server for different end users.
Coordinated with team to schedule and perform database administration activities including but not limited to back up database and maintaining data security.
Maintained detailed documentation for all teh works.

We provide IT Staff Augmentation Services!

Sql Developer Resume

San Francisco, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship