SUMMARY

• Over 8 years of in - depth consulting experience in database design, development, administration and maintenance of SQL Server 2012, 2008R2 and 2005 for both OLTP, OLAP systems and Business Intelligence tools - SSIS, SSAS, and SSRS.
• Proficient in T-SQL, developing complex Stored Procedures, Triggers, Tables, Views, User Functions, common table expressions (CTEs), Relational Database Models and Data Integrity, SQL joins and Query Writing, Clustered and Non-clustered Indexes, Data Cleansing and Data Migration. Hands on with table Partitions for better performance of database using partition Function and Partition schema.
• In-depth Knowledge in Relational and Dimensional Data modeling for creating Logical and Physical Design and ER Diagrams using multiple modeling tools like ERWIN 7.1, Visio, Rational Rose and Unified Modeling Language.
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, Sybase, Excel and MS Access CSV, Oracle, flat file.
• Designed high level ETL architecture for overall data transfer from the OLTP - Online Transaction Processing to OLAP - Online Analytical Processing with the help of SSIS.
• Proficient in creating, configuring and fine-tuning ETL workflows, migration of DTS packages to SQL Server Integration Services (SSIS) 2005/2008R2.
• Expert in creating/designing large volume data warehouse, Data Mart and cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS). Strong in optimizing MOLAP cubes by partitioning them, designing aggregations and implementing hierarchies.
• Generated calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions along with the creation of KPIs (Key Performance Indicator).
• Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and parameterized reports. Created on demand and scheduled reports in SSRS 2012/2008R2.
• Expert in writing parameterized queries for generating tabular reports, formatted report layout, created sub-reports using global variables, subtotals, expressions, functions, sorting while defining data sources.
• Created subscription reports and generated Daily, Weekly and Monthly frequencies to support rhythm of business. Administered available reports and created security layer to implement various levels of permissions.
• Performed Database Installation, Capacity Planning, Backup and Recovery Strategies for applications and databases.
• Extensive working knowledge on Configuring and version controlling with Team Foundation Server (TFS), Visual Source safe (VSS).
• Worked in collaborative team environment with other Developers, Business Analysts, and Project Managers. Great team player and managed communication within all tiers of management.

TECHNICAL SKILLS

• SQL Server 2012/2008r2/2005
• SQL Server Enterprise Manager
• Query Analyzer
• Transact-SQL (T-SQL)
• PL-SQL
• TOAD 6.0
• 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
• MDX
• C
• C#
• UNIX
• HTML
• ASP .NET
• XML
• Oracle 9i/10g
• Crystal Report
• Erwin Data Modeler 7.3/4.1/4.0
• Rational Rose
• Unified Model Language
• Performance Point Server
• Java script
• Visual SourceSafe (VSS)
• SQL Server Profiler
• Team Foundation Server(TFS)
• Data Base Tuning Advisor.

PROFESSIONAL EXPERIENCE

Confidential - Littlerock, Arkansas

MS SQL Server/SSIS Developer

Responsibilities:

• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Experience in gathering requirements, participated in client discussions and designed according to the business requirements.
• Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints.
• Involved in migration from 2008R2 to 2012 MS SQL Server
• Developed custom dash boards and MDX queries for dashboards.
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusing Fore Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task,Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Developed and deployed data transfers packages using SSIS, and maintained jobs on Servers. Involved in Production support with the Deployment of the SSIS Packages and scheduled using SQL Server Agent Job.
• Created SSIS Packages to perform filtering operations and imported data on daily basis OLTP system, DSR to SQL server. Created C# Script for Control Flow and Check File existence using Script task in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Deployed reports on Report Server and SharePoint Server also scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008R2 and 2012 Reporting Services (SSRS) in different modules.
• Monitored and fine-tuned report performance by analyzing the execution plan of the reports. Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level. Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitored and optimized) to ensure database optimization. Used SQL Server Profiler to trace the slow running queries and the server activity.
• Tested and debugged custom objects run time and design-time methods.

Confidential, NYC, NY

SSIS/SSAS/SSRS Developer

Responsibilities:

• Worked in Agile Environment and gathered Business Requirements to develop the business logic, analyzed and designed database solutions.
• Defined Technical Design Specifications, ETL workflows and Source to Target Mapping (STTM) spreadsheets for each Vendor system interfacing with the High Point system.
• Designed, developed and deployed complex SSIS packages based on STTM conversion rules for the transformation of Pre-staging data from AS400 systems to subsequent target layers in SQL Server 2008R2.
• Designed custom dashboards and integrated with SSAS.
• Generated SQL Server Database Objects including Tables, Views and Indexes. Created and modified stored procedures, triggers and queries for automating interface tasks using T-SQL. Designed a new schema for the Data Mart databases and created MDX queries to extract data from the Data Mart.
• Optimized queries and fine-tuned performance using SQL Server tools including SQL Profiler, SQL Performance Monitor and Execution Plan.
• Analyzed and Created SSAS cube and set up role based security in the cube and built the dimensions and fact tables with star schema using SQL Server Analysis Services (SSAS) and to perform analysis. Generated Dynamic reports from Cubes (SSAS) using SSRS-2008R2.
• Identified and defined Key Performance indicators (KPIs) for vendor reporting.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the 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.
• Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps. Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Ensured the quality of the output for each system Interface by conducting Meetings with the respective vendors to review the output and obtain continuous feedback.
• Supports the development, implementation and daily administration of SQL Server databases, performs database design, modeling and implementation of new database structures, as required.
• Utilized Microsoft Team Foundation Server (TFS) to manage the software development lifecycle including deriving product backlog items, defects logging.
• Designed Testing strategies and Test Plans to test each system Interface output and validated output data from each Interface based on respective Test Plans.

Confidential, Minnetonka, MN

MS SQL Server Developer/ SSIS/ SSAS/SSRS Developer

Responsibilities:

• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Converted the Oracle DB objects to MS SQL Server 2005 DB objects like Tables, Views, and Stored Procedures. Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Designed a new schema for the Data warehouse using Dimensional Modeling and developed it using the ER win tool. Migrated the entire schema as well as data into MS SQL Server 2005 and also validated the migration process to ensure that it has been successfully migrated.
• Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
• Performed transformations like Conditional Split, Sorting and included data about the environment using the Audit Transformation.
• Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures. Developed MDX expressions for cube calculations and KPIs using SSAS.
• Created Calculated Measures and Dimension Members using MDX, Mathematical formulas and User Defined Functions in SSAS
• Defined Referential Relationships with the Measure Groups and Fact tables. Defined Granularity within a measure group and drill through actions in SSAS. Generated automatically grouping Attribute Members.
• Generated Assessment Reports to analyze the Scope and Complexity of the migration projects. Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Automated the migration of data from Oracle DB to MS SQL Server 2005 DB using Microsoft SQL Server Migration Assistant (SSMA).
• Successfully Installed and configured MS SQL Server 2005 on the production server.
• Worked with Team Foundation Server for version control and project tracking.

Confidential

MS SQL Server Developer

Responsibilities:

• Worked as a developer on databases MS SQL Server 2005, MS SQL server 2000
• Involved in migration of SQL server 2000 to SQL server 2005 using Upgrade Advisor.
• Designed DTS (Data Transformation Service) packages to transfer data between servers, load data into database, archive data file from different DBMS using SQL Enterprise Manager/SSMS on SQL Server 2005 environment, and deploy the data, scheduled the jobs to do these tasks periodically.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Tested successfully all stored procedures on SQL 2005 server Environment: SQL Server 2005, T-SQL, SQL Server 2005 Reporting Service, Windows 2005 Server, Enterprise Manager, Query Analyzer, SQL Profiler
• Involved in Performance tuning and optimizing of SQL Server Application by using performance monitor.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.