OBJECTIVES:

• Microsoft SQL Server Developer
• Microsoft BI Developer

SUMMARY:

• One real Microsoft SQL Server/BI Developer veteran who has over 7 years of experience in SQL Server development area in many fields like financial, retail and manufacturing.
• Involved with the professional group in development and maintenance process for enterprise - level databases in various projects.
• Seasoned experience in data modeling, database design, data quality management, trouble shooting and Business Intelligence (SSIS/ Confidential /SSRS).
• Proven ability to deal with multi-tasking, planning and problem solving under pressure.
• Good communication and excellent cooperation skill.
• Look for new challenge to improve self and rich knowledge reserve.
• 7 years’ working experience in MS SQL Server/BI developers (TSQL/SSIS/ Confidential /SSRS)
• Experience in using SQL Server 2008, 2008R2, 2012
• Strong experience with data warehouse and ETL (Extraction/Transformation/Loading)
• Proficient with SQL Management Studio, SQL Server Business Intelligence Development Studio, SQL Profiler, Performance Monitor, and Query Designer
• In-depth knowledge of complex Transact-SQL. Power user of advanced SQL queries with multi-table joins, group functions, subqueries, set operations and functions.
• Strong experience with Data modeling and Database Design
• Experience with SQL based reporting tools: SSRS and Crystal Reports
• Deep understanding and solid skills in MS SQL Server Log Shipping, Database Mirroring, Snapshot/Transactional/Merge Replication, Failover Cluster.
• Worked with other team to develop web server application using Agile Development
• Excellent English writing, verbal and communication skills. Strong team player and able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

TECHNICAL SKILLS:

Database: MS SQL Server 2008/2008R2/2012/2014, MS Access, Oracle 11g/12g

Language: T-SQL, Visual Basic, PowerShell, C#

Tools: Microsoft SSRS/ Confidential /SSIS, Visual Studio/ SharePoint/Agile

Development: GIT / Subversion / JIRA / Rally

Application: FTP, Samba, DNS, Firewall, VPN, VMware

PROFESSIONAL EXPERIENCE:

Confidential, Huston, TX

Senior Microsoft SQL Server Developer

Responsibilities:

• Developed Microsoft SQL Server object (stored procedures, views, scalar-valued and table-valued functions) by using T-SQL
• Created ETL packages using SQL Server SSIS Designer to extracted data from flat file, reformat the data, and insert the reformatted data into fact table, loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio (BIDS).
• Configured and created SSIS solutions for ETL and Business Intelligence process for data integration and migration services and managed event handlers, package configurations, logging, system and user-defined variables for SSIS Packages
• Generated variety of business reports using SQL Server 2008R2/2012 SSRS including matrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint, built Performance Points Dashboards in SharePoint 2010
• Generated parameterized reports in MS SSRS 2008R2/2012 based on Confidential cube databases
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data
• Converted Excel based reports to MS SSRS 2008R2/2012 based reports
• Generated variety of business reports using SQL queries, SSRS, Crystal Reports and Excel

Confidential, Lincoln, RI

Sr. Microsoft SQL Database Developer

Responsibilities:

• Created and maintained store procedure for SSIS package and Report service to access data in the SQL Server database using T-SQL
• Performed data extraction, transformation and loading (ETL) between systems using SSIS
• Managed and maintained all the current SSIS packages
• Worked on migrating Data from Access to SQL Server 2008R2
• Developed end-to-end system design for specific data warehouse applications to meet the goals of business
• Developed projects using SQL Server 2008/2012 Confidential, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships
• Modified cube and dimensions and added new measure groups and dimensions;
• Created data-mining solutions in BIDS, deployed them to Confidential instance, trained the model and queried the model using MDX.
• Created views based on report requirements
• Deployed KPIs on SSRS and created different metrics
• Collaborated with different teams for different projects

Confidential, Deerfield, IL

Microsoft SQL Server Developer

Responsibilities:

• Assisted the database developer compiling store procedure, trigger, and other SOL Server object
• Involved in Data Warehouse design process and created dimension tables and fact tables
• Used SSIS to extract data from different data sources, transform and load them into SQL Server Data Warehouse
• Designed ETL solutions through analysis of business objectives
• Developed and maintained ETL processes to manage data from several internal/external systems
• Troubleshot production issues, identified root cause and implemented sound technical resolutions in a timely manner