Experience Summary:

• Over 8+ years of extensive experience in Database Solutions and BI Solutions using Microsoft Technologies.
• Microsoft Certified Professional in Querying Microsoft SQL Server 2012.
• Microsoft Certified Professional in Implementing a Data Warehouse with Microsoft SQL Server 2012.
• Extensive experience in Data Modeling, Design, Development of Database systems using MSSQL 2000/2005/2008 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS,SSIS, SSAS)
• In depth Knowledge in ER modeling and Dimensional modeling (Star and Snowflake schema) building Dimension and Fact tables.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
• Good knowledge of MS SQL Server 2012 implementing new features like Change Data Capture (CDC), Master Data Services (MDS), Data Quality Services (DQS).
• Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems
• Experience in database programming in writing T-SQL Stored procedures, User Defined Data Types ,Triggers, Indexes and Batch Scripts using various DDL and DML commands, Views, Cursors.
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.
• Created Partition function, Partition scheme and multiple file groups and files to host the table data for Data partitioning.
• Experience in design and development of Master Data Management (MDM) hub for various domains.
• Excellent knowledge of performance tuning in tuning stored procedures, Queries using tools like SQL Profiler, Execution Plans and DMV’s.
• Hands on Experience in Forward / Reverse Engineering Data Models between Erwin and MS SQL Server
• Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2, and Oracle, Sybase, Teradata.
• Highly experienced in full cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Developing, Scheduling, Configuring, Troubleshooting and monitoring) for performing ETL Purposes across different servers.
• Experience in working with source control like Team Foundation Server (TFS).
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Scheduling and Monitoring ETL Processes using DTExec utilities and batch files
• Experienced in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008 across various environments.
• Expert and proficient in highly analytical & detailed reports that include drilldown, drill through, parameterize, Summary, OLAP, cross tab, linked and sub reports and filters, charts in SSRS 2005/2008.
• Good experience in Designing Aggregations and pre-calculating the same in SSAS.
• Used advanced MDX, MS Excel pivot tables, Reporting Services to browse, query and analyze OLAP cubes, Scorecard KPI’s and calculation were used frequently.
• Created Ad-hoc reports and data driven subscription reports by using Report Builder in SSRS
• Experience in integrating SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS).

Technical Skills:

Programming Languages: T-SQL, SQL, PL/SQL, Dynamic SQL, ASP.NET, ActiveX, XML, MSAccess, HTML, DHTML, Shell Scripting.

RDBMS: MS SQL Server 2000/2005/2008 /2008R2/2012, MS Access 97/2000/2003 , Oracle 10g, AS400.

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling Relational, Fact& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball& Inman Methodologies, MS Access, and MS Visio.

Tools And Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio.Net, DTS, Business Intelligence Development Studio (BIDS).

Operating Systems: Windows XP/ 98/2000/2003/2008/ NT/9x/Vista and MS-DOS.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Service (SSAS), Business Intelligence Development studio (BIDS).

Web Technologies: HTML, XML, XSL, JavaScript.

Professional Experience:

Confidential, Richmond, VA

SQL Server Developer/SSIS Developer/MDM Developer

Estes has provided top-quality transportation solutions since 1931. Estes offers a full spectrum of shipping and supply chain management services for virtually any destination in the world. The project is to build ETL using SSIS for MDM on Customer, Location and Fleet domains and cleansing master data using MDS and DQS and building the data warehouse (EDW) from scratch for Confidential

Roles and Responsibilities:

• Created High level ETL design document and data mapping documents for different MDM domains.
• Worked with data modelers in designing complex data model for MDM on Customer, Location and Fleet domain to provide appropriate physical and logical design of data model.
• Involved in the architecture and design of the MDM hub.
• Analyzed the existing DB2 database for different business units and documented them.
• Installed and configured Master Data Services (MDS) and Data Quality Services (DQS).
• Documented test plans including regressive testing for newly developed features.
• Worked closely with data modeler and project manager to validate the business rules.
• Profiling data sets to better understand the requirements.
• Migrated or Upgraded from SQL Server 2005 to SQL Server 2008.
• Designed SSIS Packages to populate the data from AS400 (transactional system), Flat Files into staging and then to SQL Server 2012 (data warehouse) by using multiple transformation such as Data Conversion, Conditional Split, Merge Join, Lookup, Union all.
• Developed complex T-SQL queries, common table expressions (CTE), stored procedures, and functions used for designing SSIS packages.
• Migrated SSIS packages from visual studio 2008 to visual studio 2010 using SSIS Upgrade Wizard.
• Developed complex stored procedures and user defined functions with best execution plan.
• Handled slowly changing dimensions Type 1 and Type 2 using Lookup, Merge join and Conditional Split Transformations to maintain the history of the data.
• Experience in performance tuning/optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Implemented partitioning to handle tables with over 200 million rows.
• Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
• Designed SSIS packages to populate the data into MDS server using staging tables and stored procedures from SQL server 2012.
• Created Data quality projects using data quality client to cleanse the address information of all the domains of MDM hub.
• Designed SSIS packages to populate the data into data warehouse (SQL server 2012) using CDC control task, CDC splitter transformation.
• Experience in working with Change Data Capture (CDC).
• Cleansed master data using DQS cleansing component, fuzzy lookup and lookup transformations in SSIS packages.
• Configured SQL Mail agent for sending automated alerts/emails.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Configured and scheduled packages to be deployed out to various environment using Package deployment model and project deployment model in Visual Studio 2010 or TFS 2012.
• Participate in peer code review to ensure using best practices with in the entire system.
• Assisted end users in USER ACCEPTANCE TESTING, by explain all the functionality of the data warehouse and its applications

Environment:

MSSQL Server 2008R2 Standard Edition, MSSQL Server 2012 Enterprise Edition, Visual Studio 2012/2010/2008 , SSIS, I Series (AS400), TFS 2012, System I Navigator, Sequel View Point, MDS 2012, DQS 2012, MS Visio, SSIS Upgrade Wizard, Data Quality Client .

Confidential, Overland Park, KS

Sr ETL/SQL Server BI Developer

Roles and Responsibilities:

• Gathered functional requirements from users and translated into technical specs, creating data dictionaries and mapping documents.
• Involved in Installation, Configuration and Upgradation of SQL Server 2008/2005 BI Components across various environments.
• Involved in proof of concept for the Datawarehouse and involved in dimensional modeling by Identifying the fact and dimension tables for various Analytics and reporting needs
• Understand the underlying database schema and involved in datamodelling and dimensional modeling
• Responsible for creating datasets using T-SQL and stored procedures
• Migration of existing ETL DTS Packages(2000) to SSIS (2008R2) and Creation of new SSIS packages to transfer data from Oracle to SQL server using different SSIS components using configuration files ,variables for deployments
• Extensively implemented error handling, error logging, scheduling thru batch files and 3RD party schedulers for SSIS packages supporting ETL Processes.
• Created SSIS packages to transfer data from various sources like Oracle 10g, Excel, flat files into SQL server using different SSIS components and used dynamic configuration files and variables for production deployment.
• Supported the Director of Business Information in their interactions with key stakeholders to define, design and develop critical reporting needs using SSRS 2005/2008
• Supported end users through training by developing tool specific and content based training materials.
• Performed ongoing monitoring and refinement of database queries and ETL programs.
• Designed and developed various custom defined reports using SQL Server Reporting Services (SSRS) and deployed them on SharePoint 2010 Portal
• Worked with advanced data regions like Tablix, Guages, Charts, Matrix, Rectangle, Textboxes in SSRS 2008
• Designed new Aggregations by creating Hierarchies and then pre calculating the Aggregations using Aggregation Wizard in SSAS.
• Configured application settings using the Configuration files and Consumed and created XML Web Services.
• Prepared written documentation on new and modified reports, OLAP tools or ETL programs.
• Involved in Performance Tuning and query tuning stored procedures, SSIS Packages, partitions using various database tools like SQLProfiler, DTA,DMV’s and DMFs.

Environment: MSSQL Server 2008/2005/2000 , VS2010/2008, SSRS 2005/2008, SSIS, SSAS,TFS 2008, Oracle 10g, Toad, Asp .Net, SharePoint 2010.

Confidential, Quincy, MA

SQL Server Developer/SSRS/SSIS

Confidential is a largest chain of Women Clothing based in Quincy, Massachusetts which has 224 stores all over USA. The firm targets active, affluent women ages 35 and up, and banks on its J. Jill brand. The catalog and the website offer private-label casual wear made in the US and abroad. Confidential 's retail operations are its fastest growing division.

Roles and Responsibilities:

• Developed Query for generating drill down and drill through reports in SSRS 05
• Uploaded reports on to the report manager and organized them into folders.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Created XSLT files for loading the XML data to database.
• Identified and worked with Parameters for parameterized reports in SSRS 2005
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created parameterized, drill down, drill through and aggregation type of reports, charts and dashboards in SSRS
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
• Created cubes to support specific analysis conducted by upper management, the cube included few materialized views as well as fact arranged by topic
• Administered the SQL server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Worked with Application Developers to design databases and tables to support development activities and achieve optimal efficiency
• Hands on experience with Performance Point Server and ProClarity to design and deploy KPIs, Scorecards and Dashboards on SharePoint Server.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc. as required.
• Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS).
• Designed and deployed reports with Drill Down, Drill Through, Parameterized and Sub-reports using SSRS.
• Managing security roles in SQL Suite.
• Diagnosing and tuning the server optimal performance using SQL Server 2005 SQL Profiler and Database Engine Tuning Wizards.

Environment: SQL Server 2008/2005, SQL Server Integration Services (SSIS), SSRS,SSAS, Windows Server 2003, DTS, T-SQL, SQL Profiler, SQL Server Agent, Oracle, MS Excel, C, C++, XSLT, Visual Studio 2008, .Net (Asp.Net).

Confidential, Long Beach, CA

SQL Server Developer/SSRS/SSIS

Confidential has been a leader in providing quality healthcare to those who depend on government assistance. The company commitment to the members has made it a national leader in providing affordable healthcare to families and individuals. During this time, it has become one of the most experienced managed healthcare companies in the country.

Roles and Responsibilities:

• Responsible for creating stored-procedures, views, Unique/check constraints and indexes.
• Creating the functions and developing the procedures for implementing the application functionality at the database side for the performance improvement.
• Creating and Modifying the SQL Stored Procedures for validating the integrity of data.
• Provided data verification and tuned queries to define the requirements.
• Configured complex queries to meet the customer requirements as needed.
• Created the Packages in SSIS. Worked with the SSIS for the data integration.
• Migrated data between databases and different servers.
• Created SSIS Packages to get the data from different sources, consolidate and merge into one single source.
• Designed and developed the packages for extracting the required data, transforming it and then exporting the data.
• Created ETL package for data conversion using various transformation tasks.
• Assisted in the design of star schema and snow flake schema
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts
• Created custom and Ad-hoc reports using SSRS.
• Created reports and added parameters to it so that users can have choice of selecting according to their wish.
• Created reports where in users can drill down to optimum level of the detail.
• Created reports that call Sub reports in SSRS.
• Coding of several stored procedures and maintaining the integrity constraints.
• Created the stored procedures for the business logic using the T-SQL.

Environment: MS SQL Server 2008/2005, SQL Server Reporting Services (SSRS 2008), Business Intelligent Development Studio (BIDS), SQL Server Integration Services (SSIS 2008), ETL, Visual Studio 2005, MS Excel.

Confidential, KS

SQL Server Developer/SSIS/SSRS Developer

Confidential is a parent company for REW Materials and Magnum Products that distributes interior and exterior construction products. The project is to Create ETL using SSIS to get corporate data from SQL 2000 to SQL 2005 and build reports on SQL 2005 to provide valuable information to discover customer needs and provide this information to the marketing department to aid them in creating new products and identifying customer needs that may be also satisfied by existing products.

Roles and Responsibilities:

• Created Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers
• Wrote efficient stored procedures for the optimal performance of the system
• Monitored performance and optimized SQL queries for maximum efficiency
• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data
• Created indexed views, and appropriate indexes to reduce the running time for complex queries
• Generated custom and parameterized reports using SSRS
• Created reports that call sub reports in SSRS
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Responsible for creating datasets using T-SQL and stored procedures
• Created several packages in SSIS
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals
• Used various transformation tasks to create ETL packages for data conversion
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Responsible for performing ETL by extracting data from different Oracle 9i and 10g databases, transforming them and loading it in to SQL Server
• Responsible for Query optimization and Performance tuning

Environment: SQL Server 2005 Enterprise Edition, XML, T-SQL, SQL Server 2000, SQL Server 2005, SSIS 2005,SSRS 2005, Windows 2000 Advance Server, Windows 2003 Advance Server , MS Excel, MS Access, Visual Studio 2005,Oracle 9i and 10g.

Confidential

SQL Server Developer

Confidential is fortune 100 companies that develops and invents and manufactures technologies to address tough challenges linked to global megatrends such as safety, security, and energy. The project was all about integrating into a centralized database with dynamic design and user friendly web application, to keep track of Direct Bill Payments, New connections and Late Payment charges from consumers across the state. Process involved data entry and verification of Payments and Unpaid Policies verifications.

Roles and Responsibilities:

• Involved in developing SQL server T-SQL stored procedures through data layer.
• Developed complex SQL Queries for the application.
• Developed complex stored procedures, views, cursors, and other SQL joins and statements for the application.
• Implemented constraints on the table.
• Created DTS packages to get data from different sources, consolidate and merge into one single source.
• Creating and modifying T-SQL stored procedures for validating the integrity of the data.
• Worked with the data extraction using DTS.
• Implemented complex queries to view the results based on the business requirements.
• Migrated data from the text to the SQL Server.
• Created Views as required for the front end developers for easier data retrieval on the web pages.
• Created Triggers to enforce data and referential integrity.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success
• Creation/ Maintenance of Indexes for fast and efficient reporting process.

Environment:

SQL Server 2000/2005 , T-SQL, DTS , MS Excel, MS Access 2000