SUMMARY

• Over Nine (9) plus years of experience in design, development, analysis and administration of SQL Server 2005/2008/2008 R2/2008/2008R2R2/2012 and SQL Server Business Intelligence tools (BIDS) - SSIS,SSAS,SSRS.
• Highly motivated SQL Server Professional experienced with SQL Server 2000/ 2005/2008/2008 R2/2012, .NET and other Microsoft Technologies.
• Hands on Experience in Installing, Configuring, Managing, monitoring, troubleshooting, Upgrade and Maintenance Patch on SQL Server 2005/2008/2008 R2/2012.
• Experienced in Identification of Entities, Attributes and Relationships and design the logical/ physical model; creation of DDL scripts using Erwin and complete compare with the development databases.
• Experienced in normalization and de-normalization needs; Strong analytical database design skills; Delivered optimum benefits and has full life cycle implementation exposure: Business Requirements Definition, Modeling, Logical Database Design, Mapping, Gap Analysis, Data Conversion, Validation, Testing, Documentation, Production Migration, Post Implementation Support, Assessments, Enhancement and Refinements.
• Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication, Mirroring, Partitions and SQL Server clustering.
• Well versed with DBCC commands to maintain SQL server and BI databases
• Involved in developing Data Models, reverse engineering of databases, updated existing databases from models using tools like Erwin, MS Visio, and MS Visual Studio.
• Experience in analysis, design, modeling, development, implementation and testing of Client/Server and Data warehouse applications using MS SQL server on Windows OS.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Hands on experience with SQL Server and T-SQL in constructing DDL/DML triggers, tables, user defined functions, views, indexes, Stored Procedures, user profiles, relational database models, cursors, Common Table Expression (CTE’s), data dictionaries, and data integrity.
• Experience in Kimball methodology, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables, and Operational Data Store (ODS).
• Expertise in planning and implementing SQL server Security and database permissions, creating roles and managing user permissions.
• Solid knowledge and recent experience with all aspects of SQL Server Management Studio (SSMS) including Query Editor, Server objects, SQL Server Agent, Management and Notification Services.
• Expertise with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Well versed in Normalization/ De-Normalization techniques for optimum performance in relational and dimensional database environments and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Hands on experience in Performance Tuning, Query Optimization, database optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Expertise in solving dead Locks, Long running queries using Performance Monitor and SQL Profiler.
• Worked extensively on creating complex queries including correlated queries and queries with complex joins involving multiple tables and aggregate functions.
• Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
• Very good experience working with Visio, Creating ER diagrams, reverse engineering and creating data flow diagrams.
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, Backup & Recovery, Database mirroring, Log shipping, Replication Services, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Demonstrated expertise in designing, developing and deploying Business Intelligence Semantic Model (BISM) solutions using SQL Server Data Tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Server (SSAS).
• Experience in data migration from legacy systems like Oracle/DB2/SQL Server/MS Access /Excel Sheets /Flat Files to SQL Server databases using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Highly experienced in whole cycle of SQL server integration services (SSIS 2005/2008/2008 R2/2012) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Well-versed in usage of SSIS Control Flow items and SSIS Data Flow items.
• Extensively used VB.Net and C# for Script task primarily to control the flow of SSIS package.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
• Experience in Designing and Building the Dimensions and cubes with star and Snowflake schemas using SQL Server Analysis Services (SSAS).
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, Key Performance Indicators (KPI’s) & Multi-Dimensional Expressions (MDX), Data Analysis Expression (DAX) Queries using SQL Server 2005/2008/2008 R2/2012 Analysis Services.
• Experience on performance point server and dashboards, scorecards, building reports and created management reports
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational (OLTP) databases and OLAP cubes using Report Designer as well as Report Builder.
• Experience in generating Drill down reports, Crystal reports, Cascaded parameterized, Parameterized reports, Linked reports, sub reports, Adhoc Reports, charts using SSRS 2005/2008/2008 R2/2012.
• Experience in using Stored Procedures, CTE’s, Variables, Expressions, Function’s for the reports and in handling Parameterized reports in SSRS 2005/2008/2008 R2/2012.
• Experience with creating and managing roles for security in SSIS, SSAS, and SSRS Reports.
• ExperiencewithAgileMethodologyfor software and solutions development.
• Experienced in TSQL development, documenting, coding, modifying, implementing business technology solutions, using MS SQL Server 2008/2008R 2/2005/ 2012.
• Very good knowledge of BizTalk servers.
• Good understanding of new database technologies like SQL server 2014, Big Data concepts like Map-Reduce, HDFS and relevant tools like Sccop, ZooKeeper, Pig, and Hive.
• Knowledge of NoSQL databases like Cassandra and HBase.
• Experience with developing Disaster Recovery plans and maintaining backup servers.
• Worked with several offshore and onsite teams in resolving the application issues.
• Excellent communication skills, analytical skills, understand business requirements in various domains. Effectively manages time spent on multiple projects to meet deadlines.

TECHNICAL SKILLS

Relational Databases: SQL Server (2000, 2005, 2008/2008R2, 2012), MS Access, DB2, Cognos, Oracle 10g/9i/8i

NoSQL Databases: HBase, Cassandra

Querying/Reporting: T-SQL, PL/SQL, SQL * Plus, SQL*Loader, TOAD.

Reporting Tools: SSRS,Cognos 8, Crystal Reports

Modeling Tools: SSAS 2005/2008/2008 R2/2012, ER-win, MS-Visio, MS Visual Studio.

ETL Tools: Microsoft Integration Services (SSIS)

Data Mining Tools: Microsoft Analysis Services(SSAS).

Programming Languages: C, C++,JAVA,.Net.

Documentation Tools: MS Office (Including MS Project, VISIO)

Web Portal Technologies: HTML, Photoshop, SharePoint.

Operating Systems: Windows (2000, NT, XP, 7, 8), Windows Server 2000/03/08, BiztTalk, Unix.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Business Intelligence Lead

Responsibilities:

• Working on designing and developing integration framework using SSIS and BizTalk to extract, manipulate and load data between different systems.
• Worked on preparing Functional Specification, High Level and Low Level Design documents.
• Worked on preparing Proof of Concept for multi-phased ETL and Reporting development activities.
• Developed user test cases in coordination with business analysts and business users.
• Day to day interaction with client to capture requirements and document.
• Work in collaboration with onsite and offshore teams.
• Developed SQL jobs according to the ETL specifications for the staging area & warehouse data loading using SSIS 2012.
• Working on developing dashboard reports, Parameterized reports, Linked reports, sub reports, operational Drill-through and Drill-down reports using SSRS 2012
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Involved with Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Deploy packages and reports to Development and Testing Environment’s.
• Developed complex SQL queries to verify data from Source systems to Target Systems
• Worked with Business Analysts to define testing requirements to satisfy the business objectives.
• Created Triggers to capture the Data manipulation transactions on the Fact tables and Fact history tables.
• Implemented the best practices of SQL usage within the project to improve the performance of the SQL.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, User Acceptance Testing to verify whether the data is loading into target databases.

Environment: SQL Server 2012/2014 Enterprise, SSIS, SSRS, BizTalk, DB2, PeopleSoft, Windows Enterprise Server 2008, .NET, Microsoft Visual Studio 2013, Microsoft Visio 2010, SharePoint, TFS.

Confidential, Chicago, IL

SQL Consultant

Responsibilities:

• Extensively worked with SQL Server and T-SQL in constructing DDL/DML triggers, tables, user defined functions, views, indexes, Stored Procedures, user profiles, relational database models, cursors, Common Table Expression (CTE’s), data dictionaries, and data integrity.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
• Worked extensively in administering multiple large OLTP and OLAP databases and make them highly available 24x7.
• Used SQL profiler and database tuning wizard to identify bottle necks and built index’s to improve database performances.
• Involved in migrating the database from SQL Server 2000/2005 to SQL Server 2008/2008R2/12.
• Generated Data Models from existing databases using reverse engineering process with MS Visio.
• Developed ETL packages using SQL Server Integration services tool to perform data migration from legacy systems like DB2, SQL Server, Excel Sheets, XML files, Flat Files to SQL Server databases using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Developed data flow tasks using SSIS Control Flow items(For Loop, Execute package/SQL tasks, Script task, Send mail task, For loop container, For each loop container, Sequence container) and SSIS Data Flow items (Conditional Split, Slowly Changing Dimension, Data Conversion, Fuzzy lookup, Merge, Multi cast, Derived column, Character map, Union all, Sort, Row count, OLEDB command).
• Developed Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Built Dimensions and cubes with Star and Snowflake schemas using SQL Server Analysis Services (SSAS).
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, Key Performance Indicators (KPI’s) & Multi-Dimensional Expressions (MDX), Data Analysis Expression (DAX) Queries using SQL Server 2005/2008/2008 R2/2012 Analysis Services.
• Experience on performance point server and dashboards, scorecards, building reports and created management reports
• Developed reports for different applications using SSRS, Crystal reports and xCelsius tools.
• Developed business reports from both relational (OLTP) databases and OLAP cubes using Report Designer as well as Report Builder.
• Developed Drill down reports, Crystal reports, Cascaded parameterized, Parameterized reports, Linked reports, sub reports, Adhoc Reports, charts using SSRS 2005/2008/2008 R2/2012.
• Extensively used Stored Procedures, CTE’s, Variables, Expressions, Function’s for the reports and in handling Parameterized reports in SSRS 2005/2008/2008 R2/2012.
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, Backup & Recovery, Database mirroring, Log shipping, Replication Services, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Used DBCC and DMV/DMF for SQL performance tuning.
• Worked on developing and executing data cleansing scripts manual data conversion scripts.
• Developed and maintained administration policies, procedures, and best practices.
• Performed database health checks daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor on Development and UAT environments.
• Developed different levels of access to different applications and assign to users as per requests.
• Proactively monitored the Production Database and optimize stored procedures for better performance by resolving locking conflicts and resource utilization.
• Created installation packages by identifying all components of applications to deliver to business users for hassle free application installation.
• Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring
• Created alerts and notifications for system errors, insufficient resources, fatal database errors
• Scheduled and monitored all maintenance activities including database consistency check, index defragment
• Monitored all databases status including CPU, memory, I/O, space Management, block, and dead lock
• Worked with various vendors to open required firewalls, upgrading server and application packages.
• Perform all infrastructure related tasks for RREEF core, RREEF Securities, and RREEF opportunity teams.
• Performed Disaster Recovery Tests and documented disaster recovery management for each application.
• Worked on Installation, configuration, managing, monitoring, upgrading and troubleshooting MS
• Worked closely with various teams within DB to perform server maintenance and database tasks in order to comply with DB infrastructure policies.
• Developed reports for internal and external auditing.
• Day-day troubleshoot any issues with daily processing of batch jobs and application access issues.
• Deploy application packages, folders and content store from a development environment to test and then to production environments.
• Worked on installing and upgrading the applications.
• Worked on migrating applications from one server to another, configuring the interfaces, and validation.
• Developed automated alerts to check the job status.
• Support ETL packages developed using SSIS and BODI tools for all DB RREEF applications.
• Coordinate with Development teams and external vendor teams to improve application performance and address issues related to data, and error handling.
• Develop special job plans and coordinate with different teams to accomplish business requirements.
• Manage and monitor regular jobs and special jobs as per user requirement.
• Prepare detailed documentation on error handling for regular and special runs.
• Monitor and schedule jobs in Development, UAT and Production environments.

Environment: SQL Server 2000/05/08/12 Enterprise, SSIS, SSRS, SSAS, DB2, Windows Enterprise Server 2003/08, .NET, Microsoft Visual Studio 2008/2008R2/10, Microsoft Visio 2010, Oracle, Xcelsius, Litespeed 5.0, Business Objects Data Integrator, & Business Objects XI R3.

Confidential, Pella, IA

SQL Server Developer

Responsibilities:

• Designed DTS/SSIS packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data.
• Worked with business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Created SSIS packages to capture the daily maintenance plan scheduled jobs status (success failure) with a status report daily. Also created SSIS package to list down the server configuration, database sizing, non-dbo owned objects, public role privileges necessary for the Monthly report as per the audit requirement.
• Worked closely with the team in designing, developing and implementing the logical and physical model for the Data mart.
• Identify and resolve database performance issues, database capacity issues and other distributed data issues.
• Involved in creation of dimension and fact tables based on the business requirements.
• Performed the ongoing delivery, migrating client mini-data warehouses or functional data-marts from different environments to MS SQL server.
• Designed ETL (Extract, Transform, Load) strategy to transfer data from source to stage and stage to target tables in the data warehouse tables and OLAP database from heterogeneous databases using SSIS and DTS (Data Transformation Service).
• Developed SSIS packages to export data from Excel (Spreadsheets) to SQL Server, automated all the SSIS packages and monitored errors using SQL Job on a daily basis.
• Prepared reports using SSRS (SQL Server Reporting Service) to highlight discrepancies between customer expectations and customer service efforts which involved in scheduling the subscription reports via the subscription report wizard.
• Involved in generating and deploying various reports using global variables, expressions and functions using SSRS.
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data.
• Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using DTS, SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads
• Designed reports using SQL Server Reporting Services (SSRS) 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.

Environment: SQL Server 2000/2005 Enterprise, SSIS, SSRS, SSAS, Windows Enterprise Server 2003, .NETMicrosoft Visual Studio 2000/2005, Oracle, MS Access, CSV, MS Excel, Load Runner, TSQLERwin, Pro-Clarity, User Notification Services, and MicroStrategy.

Confidential, Seattle, WA

SQL Server Consultant

Responsibilities:

• Involved in the full life cycle of this project (Analysis, Design, Implementation, Testing and Maintenance).
• Worked on upgrading databases and ETL packages SQL Server 2000 to SQL Server 2005.
• Developed, deployed and monitored SSIS packages including upgrading DTS to SSIS.
• Worked with development teams in the design of physical databases and in modification.
• Customized Application Software according to the functionality and developed new Sessions, Reports and Forms.
• Optimized components and performed primary testing and Fixed Bugs during testing.
• Worked on DTS Package, DTS Import/Export for transferring data from various database (Oracle and Text format data) to SQL Server 2005.
• Developed complex reports which involved multiple prompts, filters, calculations, multi - page, multi-query reports using MicroStrategy reporting tool.
• Worked with Cognos Reporting team for extensively reporting using Data mart for Slice & Dice, Drill Down and Drill through.

Environment: SQL Server 2000/2005 Enterprise, SSIS, SSRS, Windows Enterprise Server 2003,IIS 6.0, .NET, Microsoft Visio 2005, Teradata, Oracle, Cognos 8x.