SUMMARY

• Over 8 years of strong IT industry experience as a MS SQL Server 2012/2008R22008/2005/2000, Data Warehouse Developer/BI Developer in various domains. Maintained positive communications and working relationship at all levels.
• Skilled professional with experience in all stages of SDLC: planning, analysis, design, implementation and Worked with SDLC methodologies like Waterfall, RUP, Agile (Scrum).
• Extensive experience in SQL Server 2012/2008R2/2005/2000, Business Intelligence in SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Analysis Services.
• Proficient in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Created DDL and DML triggers.
• Exceptional Ability of writing ad - hoc queries utilizing Dynamic SQL and SQLCMD command line utility.
• Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into teh Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Extensive experience working with BCP, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Expert in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).
• Skilled in Creating and Deploying SSRS Reports on teh portal for user accessibility.
• Expert in Creating, Configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Engine Tuning advisor.
• In-depth Knowledge in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN 7.1 and Visio
• Proficient in Importing/Exporting Data from various data sources like Excel, Oracle and Flat file using SSIS utility. Involved in transformation of OLTP data to teh Data Warehouse using SSIS 2012/2008r2/2008/2005 and SQL commands.
• Expertise in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Proficient in designing, creating and maintaining reports in Accela Automation schema.
• Generated calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in creating KPI and Calculated Measures using SSAS.
• Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports, creating on demand and scheduled reports in SSRS 2012/2008r2/2008/2005
• Experienced in Logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• An enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills with good work ethics

TECHNICAL SKILLS

• SQL Server 2012/2008r2/2008/2005
• SQL Server Enterprise Manager
• Query Analyzer
• Transact-SQL (T-SQL)
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• MS SQL Server Integration Services (SSIS)
• Data Transformation Services (DTS)
• SQL Server Management studio (SSMS)
• Business Intelligence Development Studio (BIDS)
• MS Access
• MS Visual Studio
• Bulk Copy Program (BCP)
• Microsoft Office
• MS Visio 2003/2007/2010
• C
• HTML
• ASP .NET
• Crystal Report
• Erwin Data Modeler 7.3/4.1/4.0
• Performance Point Server
• Java script
• Visual SourceSafe (VSS)
• SQL Server Profiler
• Data Base Tuning Advisor
• IBM Netezza.

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

SQL Server Developer

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference.
• Designed Database using Erwin data modeler.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.
• Developed SSIS Packages using Lookup Values & implementing rules provided by Business in teh mapping document.
• Developed SSIS packages using Fuzzy Lookup and Fuzzy Grouping for data cleansing purpose.
• Used SSIS Variables for storing teh values, which are used in various components of Data Flow Task.
• Developed Unit Test Plans for SSIS packages for checking teh functionality of each component.
• Scheduled Jobs for executing teh stored SSIS packages, which were developed to update teh database on Daily basis.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2012
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2012
• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS 2012.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Scheduled teh monthly/weekly/daily reports to run automatically onto teh Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Configured teh report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools & Technologies: Microsoft SQL Server 2012, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Query Analyzer, Microsoft SharePoint, Erwin

Confidential, Monmouth, NJ

MS SQL Server Developer

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2008 to SQL Server 2008R2 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking teh functionality of each component.
• Modified teh existing SSIS packages to meet teh changes specified by teh users.
• Scheduled Jobs for executing teh stored SSIS packages which were developed to update teh database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track teh status of teh events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008R2.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008R2
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled teh monthly/weekly/daily reports to run automatically onto teh Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured teh report viewing security for various users at various levels using Report Manager
• Deployed teh generated reports on to teh server.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools & Technologies: SQL Server 2008R2, SSIS, SSRS, Report Builder, EMSE Java Script, Oracle SQL Developer, Automation, AMO, ACA, ETL, AA classic, Tortoise SVN.

Confidential, Fairfield, OH

MS SQL Server Developer

Responsibilities:

• Designed data architecture, data model and Mapping Process to load data based on business requirement and provided documentation.
• Implemented Table, Views, Function, Stored Procedures and Triggers for load data and validation purpose.
• Worked with Agile Methodology tracking teh product backlog and resolved teh defects/Solution assigned in daily scrum.
• Created SSIS package to load data from XML Files, Excel, CSV file, Ftp server and SQL Server to SQL Server 2012 by using Derived Columns, Condition Split, Data Conversion, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Script Component Task.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data Ware House.
• Converted DTS Package to SSIS package for synchronizes existing process (DTS migrations).
• Used Team Foundation Server to retain Project code during deployment process.
• Part of Code review during Production deployment and QA deployment.
• Designed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to teh Data Ware House.
• Designed Console application to generate Single .CSV and text file from Different relational Database table using SSIS and C#.
• Created Process for Error Details in Application system, Control-M Job, SQL agent Job to easily identify Issue for Support and Solution.
• Scheduled Jobs for executing teh stored SSIS packages which were developed to update teh database on Daily basis using SQL Server Agent.
• Created reports to retrieve data using function, views, cube and Stored Procedures using parameters.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

Tools & Technologies: MS SQL Server 2012, SSIS Package, SQL BI Suite(SSMS,SSIS, SSRS,SSAS), XML, MS Excel, MS Access 2007 & Windows Server 2008, SQL Profiler, SQL Profiler, Erwin r 7.3.,Net 4.0/4.5.,TFS 2010.

Confidential, Detroit, MI

MS SQL Server Developer

Responsibilities:

• Defined and Designed data based on business requirement and provided documentation.
• Created SSIS package to load data from XML Files, Ftp server and SQL Server to SQL Server 2008 by using Lookup, Derived Columns, Condition Split, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Slowly Changing Dimension.
• Worked with Agile Methodology tracking teh product backlog and resolved teh defects assigned in daily scrum.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
• Developed Validation Plans for SSIS packages for checking teh functionality of each component and Code review.
• Planned and executed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to teh Data Ware House.
• Modified teh existing SSIS packages, Script Component Task to meet teh changes specified by teh users and adding column to teh newly design table and to teh existing table.
• Scheduled Jobs for executing teh stored SSIS packages which were developed to update teh database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.Job overlap alert
• Worked in setup auditing, logging environment to track teh status of teh events like error raise, task fail.
• Designed tool to Automatic added Derived column, Parameter and Configuration value to teh package.
• Analyzed and Designed and developed MOLAP cubes with SSAS.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008
• Created reports to retrieve data using function, views, cube and Stored Procedures using parameters.
• Created various database objects like stored procedures, functions, tables, views, triggers.
• Configured teh report viewing security for various users at various levels using Report Manager
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds SSIS packages.
• Designed and implemented Stored Procedures and Triggers (DDL & DML) for automating tasks.

Tools & Technologies: MS SQL Server 2008/2012, SQL BI Suite (SSMS,SSIS, SSRS), XML, MS Excel, MS Access 2007 & Windows Server 2008 Access 2003 & Windows Server 2003, SQL Profiler, Data Analyzer, Erwin r 7.3.,Net 4.0/4.5.,TFS 2005/2008/2010/2012

Confidential, CA

SSAS/SSRS Developer

Responsibilities:

• Gathered user requirements to develop teh business logic and analyzed and designed database solutions.
• Defined Technical Design Specifications, ETL workflows and Source to Target Mapping (STTM) spreadsheets for each Vendor system interfacing with teh High Point system.
• Designed, developed and deployed complex SSIS packages based on STTM conversion rules for teh transformation of Pre-staging data from AS400 systems to subsequent target layers in SQL Server 2008R2.
• Optimized queries and tuned performance using SQL Server tools including SQL Profiler, SQL Performance Monitor and Execution Plan.
• Generated SQL Server Database objects including Tables, Views and Indexes.
• Created and modified stored procedures, triggers and queries for automating various interface tasks using T-SQL.
• Analyze and Created SSAS cube and set up role based security in teh cube.
• Defined Testing strategies and designed Test Plans to test each system Interface output and validated output data from each Interface based on respective Test Plans.
• Ensured teh quality of teh output for each system Interface by conducting Meetings with teh respective vendors to review teh output and obtain continuous feedback.
• Identified and defined Key Performance indicators (KPIs) for vendor reporting.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008R2.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting teh data, Defining Data sources and Subtotals for teh reports using SSRS 2008R2.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008R2.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Supports teh development, implementation and daily administration of SQL Server databases, performs database design, modeling and implementation of new database structures, as required.

Tools & Technologies: SQL Server 2008R2, SSIS 2008R2, SSAS, SSMS.

Confidential, Beijing, China

Duration: Aug 2006- July 2008

Role: MS SQL Server/SSIS/SSRS Developer

Confidential, as one of best-known software companies, is a leading software developer and Internet service provider in China.Teh project was to design and load teh RDS (Reporting Data Store) using teh dynamic SSIS packages, stored procedures and views from CDW (Central Data Warehouse) and to create drilldown and drill through reports to show teh Reconciliation variance’s from Source to Target using SSRS.

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams (Physical and Logical using ERWIN) and mapping teh data into database objects.
• Developed teh procedures for getting teh data from source systems to Data Warehousing system. Teh data was standardized to store various Business Units in tables.
• Used various SSIS tasks such as Conditional Split, Script Component Task, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading teh data into teh Data warehouse.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Extensively participated in functional and technical meetings for designing teh architecture of ETL load process (mappings, sessions, workflows from source systems to staging to DW) and offshore team management
• Extensively used ETL to load data from flat file to SQL Server database.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages.
• Created SQL server configurationsforSSISpackages.
• Responsible for creating reports based on teh requirements using SSRS 2005.
• Identified teh database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Defined teh report layout and identified Datasets for teh report generation.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Scheduled teh monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Created and tuned stored procedures, triggers and tables.

Tools & Technologies:

SQL Server 2005,Query Analyzer, Enterprise Manager, SSIS,SSRS,SQL Management Studio, Business Intelligence Development Studio(BIDS), Erwin 7.1,Microsoft Visual Studio, Windows 2000/2003 servers, XP Professional.