SUMMARY

• Above 7 years of experience in design, implement and maintain MS SQL database, familiar with SQL Server 2005/2008/2008 R2/2012 versions and business intelligence toolset including integration service, analysis service and reporting service.
• Excellent hands - on experiences in TSQL query including develop and maintains complex store procedures, user defined functions, views, indexes, indexed views and appropriate triggers for performance.
• Experienced in creating and managing SSIS packages, projects and solutions, expert in designing ETL control flows and data flows to transfer data from sources to destinations, work with .accdb, .txt, xlsx, .csv and other file formats.
• Experienced in modify data formats using transformation such as aggregate, conditional split, lookup and fuzzy lookup in integration service.
• Experienced in error and event handling such as break points and check points.
• Excellent understanding about data structures, familiar with star schema and snowflake schema.
• Experienced in building cubes and dimensions using analysis service.
• Good experienced in creating, populating and maintaining data marts and data warehouse.
• Experienced in creating Ad hoc reports and reports with complex formulas.
• Expertise in developing reports parameterized, cascading, drill-down, drill-through, nested and sub-reports.
• Excellent in report formatting and create layout for better presentation using matrix, dynamic matrix, gauges, charts, maps and document map.
• Solid understanding of system development life cycle. As part of the team, extensively involved through the system development SDLC process from initial planning through implementation of the projects.
• Ability to work effectively in dynamic environments that implement agile or waterfall developmental methodologies.
• Experienced in preparing use cases, flow charts, data flow diagrams and ER diagrams using MS Visio.
• Experienced in monitoring SQL Server Performance tuning in SQL Server using SQL Profiler, Query Analyzer and Index Tuning Wizard.
• Capable of handling responsibilities independently without supervision as well as a proactive team member. Have excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs. Able to learn new technologies in a short time and strong problem-solving, multi-tasking abilities.

TECHNICAL SKILLS

• MS SQL Server 2005/2008/2008 R2/2012
• T-SQL
• Business Intelligence Development Studio (BIDS)
• SQL Server Management Studio (SSMS)
• MS SQL Integration Services (SSIS)
• MS SQL Analysis Services(SSAS)
• MS SQL Reporting Services(SSRS)
• Online Analytical Processing (OLAP)
• Online Transaction Processing (OLTP)
• Software Development Life Cycle (SDLC)
• MS Visio
• MS Access
• MS Word
• MS Excel
• MS Project
• MS PowerPoint
• MS PowerPivot
• Visual Studio
• .NET framework
• C#
• VB
• ASP.NET
• JavaScript
• HTML
• CSS
• SAP ERP

PROFESSIONAL EXPERIENCE

Confidential - New Berlin, WI

Responsibilities:

• Communicate with team members and understand the business needs and requirements.
• Monitor report performance and take corrective action to optimize or improve report performance, fix report defects when necessary.
• Access, import, extract, transfer or load data from heterogeneous data sources.
• Created report by SSRS in different format and logic to present the required data.
• Design and generate SSRS reports by using variable tools including table, matrix, spark line, dynamic parameters, grouping, expression, and custom coding etc.
• Write complex TSQL query to support report developing, create stored procedures, temporary table, variables and parameters, inner query, case statement, pivot and un-pivot, functions, etc.
• Tuning report stored procedures, design query properly and provided suggestion for possible solutions and test them to meet customer’s requirement.
• Present timely, up to date data.
• Keep working process updated and handle work requirement in agile environment.

Environment: SQL Server 2008 R2/2012, SSMS, TSQL, BIDS, SSDT, SSRS, SSAS, SSIS, MS Excel, MS Outlook, VB, SVN, Axosoft(OnTime)

Confidential - Chicago, IL

Sr. MS SQL Server/BI Developer

Responsibilities:

• Gather requirements and understand the business needs.
• Created database objects such as tables, views, functions and stored procedures for performance improvement.
• Worked extensively on SSIS packages for extracting the data of the file system and transformed that data and load it into OLAP.
• Extensively used various SSIS objects such as control flow, data flow, connection managers, etc.
• Designed, developed, debugged and tested SSIS packages and implement best practices packages to maintain optimal performance.
• Developed SSIS packages to automatically extract, transform and load jobs.
• Developed new mappings using SSIS lookup, aggregation and other transformations to match the needs of the business case.
• Managed the historical data in the data warehouse from various data sources.
• Design, implement and manage data warehousesOLAPcubes and reporting solutions to improve asset management, incident management, and data center services.
• Created charts, matrix, parameterized, drill-down, drill-through and sub-reports using SSRS.
• Generated reports using SSRS and integrated and deploying them using web applications onto the web servers.

Environment: SQL Server 2012/2008 R2, SSMS, TSQL, BIDS, SSRS, SSAS, SSIS, SQL Server Agent, MS Visio, MS Access, MS Project, MS Excel, MS Word, MS PowerPoint, .NET Framework, VB, JavaScript, HTML5, CSS

Confidential, Bloomington,IL

MS SQL Server/BI Developer

Responsibilities:

• Worked extensively with Business Analysts to understand financial concepts for the benefit of accurate financial variable calculations and high quality financial report generation.
• Developed logical and physical data model and mapped the data into database objects.
• Coded TSQL scripts for stored procedures, views and user defined functions.
• Optimized the database by creating various clustered, non-clustered indexes.
• Created SSIS packages to load data into data warehouse using various SSIS tasks like execute SQL task, data flow task, send mail task.
• Created SSIS Packages to export and import data from CSV files, TXT files and Excel spreadsheets.
• Used SSAS to create cubes with various measures and dimensions for financial reports generation.
• Used SSRS to generate drill-down and drill-through reports, with charts, matrix and others.
• Created subscriptions for reports to be sent on fixed schedules (daily/weekly/monthly/quarterly/yearly).
• Created grouped report, document maps and parameterized reports in different file type to meet business requirements.

Environment: SQL Server 2008 R2, SSMS, BIDS, SSRS, SSIS, SSAS, TSQL, MS Visio, MS Access, MS Project, MS Excel, MS Word, MS PowerPoint

Confidential, Mt Arlington, NJ

MS SQL Server Developer

Responsibilities:

• Gathered, updated, and maintained existing requirements documents.
• Created Data Flow Diagrams that outline the existing business process.
• Prepared Use Case Diagrams to identify and organized system interactions and requirement of different elements of system.
• Prepared ER Diagrams for database management.
• Identified data issues and provided recommendations for resolution to ensure optimal performance.
• Architect and implemented physical database models using MS Visio.
• Normalized and modeled database environment for data migration.
• Assisted team members in understanding SQL Server concepts.
• Responsible for ensuring the necessary health insurance plans (medical, dental, vision, etc.) were transferred accurately and that the data was reliable.
• Assisted in the automation of the enrollment process and administration of employee benefit plans.
• Created functions, views, and stored procedures by TSQL.
• Extracted data for reporting and analysis, created and modified SSIS packages to load and process data.
• Involved in developing reports and modify formats for customer requirements.

Environment: MS Microsoft SQL Server 2008,SSMS, BIDS, TSQL, SSIS, SSAS, SSRS, MS Excel, MS Access, MS Word, MS Visio

Confidential, Kansas City, MO

MS SQL Server / SSRS Developer

Responsibilities:

• Created and use multiple data sources and datasets within a single report.
• Converted and redesign Access, Excel, PDF and SSRS 2005 reports to SSRS 2008 reports.
• Supported production operation activities, with focus on integration and development of new and existing products and services.
• Authored very detailed reports focusing on specific report design formatting outputs such as report layout, margins, colors, font selection, border style, padding and chart selection.
• Communicate with analysts to understand different business needs, developing reports to improve reporting services performances.
• Created parameterized, cascaded, linked and sub-reports for different business requirement.
• Authored SSRS 2008 reports to meet advance presentation layout requirements such as matrix, gauges, and charts.
• Created dashboard reports using SSRS 2008 and embedded various images within complex tabular reports based on conditions written in expressions.
• Created reports with grouping in tables and collapsible reports.

Environment: MS SQL Server 2008/2005,SSMS, BIDS, SSIS, SSAS, SSRS, TSQL, XML, MS Excel, MS Access, MS Word, MS Visio

Confidential

MS SQL Server Developer

Responsibilities:

• Assisted in writing technical and non-technical specification documents.
• Developed and implemented database and improved performance and maintainability of corporate databases.
• Created new database objects such as tables, stored procedures, functions and views
• Promoted database objects from development to production.
• Managed user access and created new security accounts.
• Assisted with various report requests.
• Created new reports per week and supported numerous change requests on a daily basis.
• Added scheduled reports to FTP server and extracted data from FTP server.

Environment: MS SQL Server 2005, SSMS, BIDS, TSQL, MS Word, MS Excel, MS Visio, MS PowerPoint, FTP server