PROFESSIONAL SUMMARY

• Over Nine 9 plus years of experience in design, development analysis of SQL Server 2005/2008/2008R2/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/2008R2/2012 , .NET and other Microsoft Technologies.
• Hands on Experience in Installing, Configuring, Managing, monitoring, troubleshooting, Upgrade and Maintenance Patch on SQL Server 2005/2008/2008R2/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.
• 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/2008R2/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 creating SSIS packages using Active X scripts and with Error Handling.
• 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/2008R2/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/2008R2/2012.
• Experience in using Stored Procedures, CTE's, Variables, Expressions, Function's for the reports and in handling Parameterized reports in SSRS 2005/2008/2008R2/2012.
• Experience with creating and managing roles for security in SSIS, SSAS, and SSRS Reports.
• Experience with Agile Methodology for software and solutions development.
• Experienced in TSQL development, documenting, coding, modifying, implementing business technology solutions, using MS SQL Server 2008/2008R2/2005/ 2012.
• 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.

SOFTWARE 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/2008R2/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, Unix.

PROFESSIONAL EXPERIENCE

Confidential

Confidential

Development Tasks:

• 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.
• 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/2008R2/2012 Analysis Services.
• 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.
• Extensively used Stored Procedures, CTE's, Variables, Expressions, Function's for the reports and in handling Parameterized reports in SSRS 2005/2008/2008R2/2012.
• Developed Drill down reports, Crystal reports, Cascaded parameterized, Parameterized reports, Linked reports, sub reports, Adhoc Reports, charts using SSRS 2005/2008/2008R2/2012.
• Developed business reports from both relational OLTP databases and OLAP cubes using Report Designer as well as Report Builder.
• Developed reports for different applications using SSRS, Crystal reports and xCelsius tools.
• Experience on performance point server and dashboards, scorecards, building reports and created management reports
• Used DBCC and DMV/DMF for SQL performance tuning.
• Worked on developing and executing data cleansing scripts manual data conversion scripts.
• Implemented and managed BO Security Model Test - Load Balancing periodically,
• Monitoring BOE services tracing Migrating BOE Objects across environments.
• Monitored and managed system operation metrics and performance
• 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.
• 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

Infrastructure Tasks:

• Documented job performances and issues of various RREEF applications.
• Created installation packages by identifying all components of applications to deliver to business users for hassle free application installation.
• Worked with various vendors to open required firewalls, upgrading server and application packages.
• 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.

Production Support Tasks:

• 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.
• Coordinate with Development teams and external vendor teams to improve application performance and address issues related to data, and error handling.
• Support ETL packages developed using SSIS and BODI tools for all DB RREEF applications.
• Developed automated alerts to check the job status.
• Worked on migrating applications from one server to another, configuring the interfaces, and validation.
• 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, Business Objects Data Integrator, Business Objects XI R3.

Confidential

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.
• 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 .
• Performed the ongoing delivery, migrating client mini-data warehouses or functional data-marts from different environments to MS SQL server.
• Involved in creation of dimension and fact tables based on the business requirements.
• 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, .NET,

Microsoft Visual Studio 2000/2005, Oracle, MS Access, CSV, MS Excel, Load Runner, TSQL,

ERwin, Pro-Clarity, User Notification Services, and MicroStrategy.

Confidential

SQL Server/ ETL 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.

Confidential

SQL Developer

Responsibilities:

• Created new SSIS packages corresponding to the existing SQL server 2000 DTS packages.
• Developed detail design documents for datawarehouse/data mart.
• Involved in Implementation of database design and administration of SQL based database.
• Developed SQL scripts, Stored Procedures, functions and Views.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Generated Sales Reporting Dashboard with different types of Reports like Tabular, Matrix, and Charts with SSRS.
• Performed Unit testing.

Environment: MS SQL Server 2005, DTS MS SQL Server 2000 WIN-2003,.Net, VBA, SQL Analysis services, ERWIN, MS Project, MS Access 97 / 2000.