SUMMARY

• SQL Server Developer with over 7 years of experience in the Analysis, Design, Development, Implementing and Testing, Administrating Client/Server applications using Microsoft Technologies.
• Extensive experience with all phases of Software Development Life Cycle in Different Environments like Banking, Insurance, Engineering and Information Technology.
• Expert in working with the Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS.
• Expert in writing T - SQL, working on DTS, Data Cleansing and Data Migration.
• Involved in migrating and upgrading SQL server 2005 to SQL Server 2008.
• Migrated data from different sources including flat files, MySQL, MS Access, Oracle 11g, and OLE DB sources to various Destinations by using SSIS 2008.
• Managed slowly Changing dimensions (SCD) and optimized fact table inserts.
• Used DTS/SSIS packages and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Experience in implementing Dynamic ETL.
• Deployed several SSIS packages using package configurations.
• Loading data into Dimensions and fact tables using SSIS
• Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Services (SSIS).
• Expertise in developing reports using SQL Server 2008 Reporting Services (SSRS).
• Experienced in sorting the data, defining subtotals for reports and designing report layout.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option.
• Developed interactive reports using Crystal Reports and SQL Server Reporting Services.
• Excellent knowledge on Object Oriented Analysis and Design concepts.
• Experience in creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access. .
• Experience in developing reports using Tableau.
• Experience in creating multidimensional cubes using SSAS and OLAP including interfaces with BIDS
• Developed new or modified existing SAS programs to load data from the source and create study specific datasets.
• SAS experience includes detailed knowledge of statistical analysis of financial, marketing and health care data and in production of reports, tables, graphs and listing.
• Expertise in developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0.
• Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
• Great Knowledge in Dimensional Modeling, applying Kimball’s methodology, Star Schema/Snowflake Schemas, ODS. Experience in Performance Optimization of SSAS cubes.
• Wrote MDX Queries and expressions in Cubes for use in front end Business Intelligence applications.
• Create various Data Mapping Repository documents as part of Metadata Services(EMR).
• Configured product meta-data tables to support client data reporting needs.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation. A quick learner with an attitude for taking responsibilities.

TECHNICAL SKILLS

Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, SSAS Business Intelligence Development Studio, Data Transformation Services,Tableau.

RDBMS/DBMS: MS SQL Server 2014, 2012, 2008R2,2008,2005,2000, Oracle 10g/9i/8i, MS Access 2003/2000

Reporting Tools: MS-EXCEL, SSRS and Crystal Reports, Report Builder 3.0,SAS web report studio, SAS OLAP cube studio.

Data Modeling: ERWIN, MS Visio.

Operating Systems: Windows 2000/2003XP/2008, UNIX and Windows NT 4.0.

Languages: C, C++, C# .Net, VB.Net, SQL, PL/SQL, Transact-SQL, MDX, UNIX Shell scripting.

PROFESSIONAL EXPERIENCE

Confidential, Kansas city MO

Sr. ETL Developer/SQL Server BI Developer

Responsibilities:

• Responsible for gathering project requirements from the users for designing and developing data warehouse as needed
• Responsible for Dimensional modeling.
• Responsible for managing BI environment which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Used various SSIS tasks such as Conditional Split, Derived Column etc. which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Responsible for creating Databases, Tables, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Performed table partitioning to increase the performance.
• Responsible for Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Created Alerts to report successful or unsuccessful completion of Jobs.
• Performed backup/restore database objects such as tables, procedures, triggers, constraints, indexes and views.
• Involved in project planning also schedule for database module with project managers
• Migrated SQL server 2008R2 to 20 .
• Designed, deployed, and maintained various SSRS Reports in SQL Server2008R2/2012.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions and Functions, Sorting the data and Subtotals for the reports using SSRS 2008R2/2012.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts and synchronized queries.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2/2012.
• Responsible for maintaining the MS SQL Environment’s Infrastructure, working with the infrastructure team to coordinate the support of (Hardware-Physical & Virtual, Storage, Software Versions & Licensing).
• Responsible to maintain and troubleshoot existing processes with thorough understanding of the processes and interrelationship with other programs and processes
• Responsible to ensure that projects are completed in a timely manner.
• Performed checkpoints/reviews on designs and code being created by the other Data Integration developers.
• Responsible for creating and executing Test cases, performing UAT and documenting the results.
• Created SQL server Analysis Projects using MS SQL Server 2012.
• Implemented the calculations to aggregate physical measures.
• Maintained and managed SharePoint installation, data, and recovery
• Experienced in performing comprehensive backups and restores of SharePoint data
• Responsible in creating and customizing Dashboard pages
• Developed mapping spreadsheets for ETL with source to target datamapping with physical naming standards, datatypes, volumetric domain definitions and corporate metadata definitions.
• Integrating and managing SSRS reports in SharePoint environment.
• Generated reports using Tableau.
• Responsible to create and deploy Data sources, data sets, reports to the SharePoint document library.
• Created and deployed adhoc reports, drill down reports as required.
• Performance tuning the existing reports.
• Created reports from OLAP, sub reports, bar charts matrix reports using SSRS.
• Developed Multidimensional objects(cubes, dimensions) using SQl server Analysis services.
• Performed data extraction, analysis and published results using SAS enterprise guide.
• Hands on experience working with SAS enterprise guide, Information Map, Data integration studio, Web report studio.

Environment: SQL Server 2012/2014 Enterprise Edition, SSIS, T-SQL, SSRS,SSAS Windows Server 2008R2/2012, C# .net, SharePoint 2010

Confidential, Atlanta GA

Sr. ETL Developer/SQLBI Developer/ DBA

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse Involved in installing and maintaining MS SQL Server 2008R2 /2012.
• Experience in designing Database Models using Erwin.
• Involved in designing the Logical and Physical data models for the data warehouse.
• Created DDL scripts to create database schema and database objects like tables, stored procedures, views, functions, and triggers using T- SQL.
• Create the clustered/non-clustered indexes on tables; Trace out for any table required any indexes and determine the type of index on it.
• Created triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
• Involved in database designing using Normalization.
• Place the huge table/non-clustered index on the separate file group to improve the performance.
• Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
• Efficient use of Joins and sub-queries in queries that retrieve data from multiple tables.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS.
• Worked extensively on SSIS Package designs for Import/Export from various Data Source Flat file, Excel, Oracle to MS SQL Server and vice versa and schedule the jobs.
• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Responsible for maintaining and updating databases.
• Migrated databases from SQL Server 2008R2 to SQL Server 2012.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery whenever needed.
• Optimized indexes to improve queries and analysed database performance with SQL Profiler.
• Partitioned many tables, which have frequent inserts, updates and deletes to reduce the contention and to improve the performance.
• Created different types of reports such as Cross-Tab, Drill-down, Summary reports using SSRS 2008R2/2012.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Developed many cubes for reporting based on the business requirements using SSAS 2008R2.
• Created dimensions, levels and hierarchies.
• Responsible for unit testing and integration testing complex queries.
• Designed Dimensional modeling using SSAS packages for End-User. Created hierarchies in data modeling.
• Created Time dimensions on OLAP cubes using SSAS

Environment: SQL Server 2008R2/2012 Enterprise Edition, SSIS, T-SQL, SSRS, Windows Server 2008R2/2012, SharePoint 2010

Confidential, OAKLAND

SOFTWARE ENGINEER (SQL/SSIS DEVELOPER)

Responsibilities:

• Developed SQL queries for different control - M Jobs and shell scripting batch jobs.
• Implemented SSMA (SQL Server Migration Assistance) for migrating the data from SYBASE to SQL server. Created maintenance procedures and provided data integrity strategies.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads
• Actively supported business users for change requests.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Designed and implemented stylish report layouts. Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created various reports by using SSRS and also worked with the VSS visual basic .net coding.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Developed SSIS solution for developing a full-fledged data warehouse solution
• Developed SP and modified stored procedures according to the different java applications.
• Identified and defined the Datasets for the report generation.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.
• Formatted the reports using the Global variables and expressions.
• Deployed the generated reports on to the server.
• Maintained data integrity by performing validation checks.
• Optimized queries, tuned and monitored server performance.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
• Created views as per design needs.
• Created Unix shell scripts to execute control - M jobs using SQL server as ODBC

Environment: MS SQL Server 2008 R2, MS SQL Server Integration (SSIS, SQL SERVER MIGRATION ASSISTANCE (SSMA),TFS and Source Control.

Confidential, Minnetonka MN

SQL developer

Responsibilities:

• Created complex SQL stored procedures and functions using Microsoft SQL Server 2008
• Involved in code review and code review meetings
• Involved in error handling, performance tuning of stored procedures
• Used Team Foundation Server for version control needs, track check-ins and roll back code as necessary
• Coordinated with Technical Analysts in understanding the business requirements and translated them in to technical specifications
• Analyzed the data as per business needs to build the Interface.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created Views and Index Views to reduce database complexities for the end users.
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Developed Scheduled Jobs to automate the packages.

Environment: ASP.NET, C#, SQL Server 2008, Visio, Crystal Reports 10, HTML, CSS

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word