Sql Server Data

Maheshwar

**********@*****.***

SSRS/SSIS/SSAS/SQL SERVER DEVELOPER

Cell : 952-***-****

Summary:

Nine plus years of experience in Development, Design, Working experience of MS SQL Servers in Production, QA, Development environments.

Overall database design, such as creating normalized databases, tune queries, assigning proper indexes, creation of triggers and stored procedures.

Experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services.

Flexible and versatile to adapt to any new environment and work on multiple projects.

Experience in creating Ad hoc reports and tuning of reports.

Excellent knowledge in RDBMS concepts and constructs.

Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS and SSIS Packages.

Extensive knowledge of MDX and creating cubes.

Experience in Data cleansing or data scrubbing.

Experience in working with version controlling tools for managing SQL scripts and changes that are going to production.

Transformed data from one server to other servers using Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.

Good understanding of capacity planning.

Extensive knowledge of Relational Database Management Systems.

Expertise in planning and implementing MS SQL server security and database permissions.

Experience in Database Backup, Recovery procedures.

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

Hands on experience in trouble shooting database issues.

Experience in writing and debugging stored procedures and triggers.

Experience in Data Modeling using ERWIN tool and normalization of tables.

Creation of users, configuring permissions and assigning roles to users.

Experience in scheduling SSRS reports using subscriptions.

Hands on experience in writing T-SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers.

Experience in managing Alerts, Operators and Jobs through SQL Server Agent.

Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

Technical Skills:

Operating Systems Windows 2003/2000,Windows XP, Windows NT 4.0 Server/Workstation, Windows 98/95, Terminal Server 4.0, Windows 2000 Advance Server, MS DOS, Unix.

Languages C, C++, JAVA, XML, T-SQL, SQL Plus, ISQL, OSQL, VB Scripts, C#

RDBMS MS SQL Server 2012, 2008 R2, 2008, 2005, 2000, 7.0 and 6.5, Oracle, MS-Access

Front End MS Visual Basic, Dream Weaver

Internet Technologies ASP, Java Script, HTML

OLAP Tools MS OLAP Services Manager

Version Control Tools SVN, Visual Source Safe, TFS

Reporting tools SSRS, Crystal Reports, Cognos Reporting

Other Tools Idera Diagnostic Manager, Quest Spotlight, SQL Lightspeed, ERWIN 3.0, Toad, Crystal Reports, SQL Backup, SQL Developer.

SQL Server Tools Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS),SSIS, Visio, SSAS,SSRS

Educational Qualifications:

Master in Information Technology, Allahabad University, India

Bachelor in Computer Science, Osmania University, India.

Work Experience:

JpmChase, New York, NY Jun 2013 – Till Date

Sr. Developer

Responsibilities:

Developed stored procedures, views, triggers and user-defined functions using T-SQL.

Created email and file share subscriptions on report manager to share the reports to the clients.

Used monitor all subscription jobs and sends email alerts to the reporting team.

Developed and deployed and monitored SSIS Packages.

Generated the weekly, monthly, and quarterly report by using SQL Server Reporting Services.

Tuned of Stored Procedures and SQL Queries and created some indexes on tables.

Created SQL Server jobs for SSIS packages and scheduled them and monitored them.

Created table, views and modified tables, views based on new requirement.

Documented the whole system and life cycle of the project.

Worked extensively with business analysts to gather requirements to generate customized SQL reports.

Used stored procedures with parameters and SQL queries to generate the reports.

Created drill down reports based on the requirement.

Modified stored procedures and functions based on new business rules and deployed them.

Generated reports using SSRS from cubes.

Used Excel PIVOT tables to validate reports.

Converted Crystal reports to SSRS reports.

Created reports using Tableau and converted Tableau reports to SSRS reports.

Developed role based Dashboards to monitor KPIs and Ad hoc reports for Accounting and Claims using SSRS.

Converted Oracle reports and procedures into SSRS reports and SQL Server stored procedures.

Environment:

SQL Server 2008 R2/2012,SQL Server Reporting Services, SSIS, Windows Server 2003, Windows XP, C#, MS Office, VSS, Visio, Excel, Tableau, SSRS 2012.

Ameriprise Financials, Boston, MA Sep 2012 – May 2013

Sr. Developer

Responsibilities:

Created SSIS packages to export Data from Flat Files(IBM Mainframe) to SQL server.

Created data driven subscriptions on report manager to use single subscription to distribute different reports to different clients.

Created ER Diagrams for all tables which are used in SSIS packages and documented the work flow.

Used Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.

Generated Reports using SQL Server Reporting Services (SSRS).

Deployed the SSIS packages on different servers and tested those packages.

Optimized Query Performance and Reliability.

Created new tables and databases, normalized and indexed all the tables.

Written stored procedures for front end and helped the front end application developers with their queries.

Created Cube and Created reports using MDX queries.

Created temp tables and table variables.

Cleaned data and corrected corrupted data.

Created all types graphs in reports using SSRS.

Sent reports to the clients using email subscriptions and file share subscriptions.

Tuned of Stored Procedures and SQL Queries and created some indexes on tables.

Created procedures using PL-SQL using SQL Developer.

Environment:

Windows 7,VSS, MS SQL Server 2008,T-SQL,Visio, SSIS, MS Excel, MS Word, SSRS 2008 R2, C#, ASP.NET, DB2, Unix, MS Access, Oracle, PL-SQL,SSAS,MDX.

ESM (A Xerox Company), Highlands Ranch, CO Apr 2010 – Aug 2012

Sr. Developer

Responsibilities:

Created Data Sets and used the data sets for different Reports.

Created proper indexes for some tables for better performance of the queries.

Designed databases and tables for data warehouse.

Created Mapping Excel Spread Sheets for export data between two databases.

Created Visio diagrams for some data bases.

Exported data from flat files to SQL server using SSIS packages.

Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.

Wrote complex SQL queries for data retrieval.

Designed new data bases for Reporting purpose.

Created stored procedures, tables, triggers, and views for data warehouse databases.

Created new SSIS packages in place of old DTS packages.

Documented the guidelines for SQL programming.

Worked on Exception Handling with @@error and with Try/catch.

Created a report to notify the status of all report subscriptions.

Environment:

Windows Server 2003,Oracle,Cobol,IBM Mainframe, MS SQL Server 2005, VSS, SSIS, T-SQL, MS Excel,, MS Word, SSRS,C#, Sybase.

Wells Fargo Bank, Bloomington, MN Jul 2009 – Mar 2010

Developer

Responsibilities:

Created Views and Extracted Data from the Views and Modified some Reports also.

Cleaned data in the tables and removed some inaccurate records from tables.

Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.

Tuning of Stored Procedures and SQL Queries and created some indexes on tables.

Loaded Data to Flat Files from SQL server using Integration Services.

Created and Scheduling Jobs, Backups and Restore of Databases.

Created stored procedures, triggers, views and Functions for front end requirements.

Used XML data type in stored procedures.

Created new tables and normalized.

Created new ad hoc reports and tuned existing reports for best performance.

Deployed all the Integration Service Packages on Testing Server and successfully scheduled them.

Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

Suggested creating Clustered and Non Clustered indexes on tables.

Environment:

Windows Server 2003, MS SQL Server 2005, T-SQL, MS Office Access 2003, VSS, SSIS, MS Excel, MS Word, C#, Sybase, DB2,Cobol.

Cabot Cheese Company, Montpelier, VT Mar 2008 –Jun 2009

Developer

Responsibilities:

Extracted data from legacy system using SSIS(SQL Server Integration services)

Wrote Store procedures to convert data logically as per the business requirement.

Created linked servers for multiple legacy systems using ODBC drivers and OLEDB Providers.

Transform the data using different components of SQL Server Integration Services.

Loaded data into SQL Server using Integration Services.

Wrote Triggers on to migrate the data from current system to legacy systems

Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints..

Created Jobs and scheduled them for Backups and Restore of Databases.

Loaded data through bulk inserts from Flat Files using Bulk Insert

Analyzed the current OLTP system to interface with legacy OLTP System

Created Mapping Spread Sheet to map columns from current OLTP System (Source SQL Server) to legacy OLAP System (Target SQL Server)

Converted some crystal reports to SQL Server Reports using SSRS.

Wrote Triggers to Invoke Jobs to Transfer real-time data to OLAP.

Environment:

Windows 2000, MS SQL Server 2005, T-SQL, MS Office Access 2003, VSS, MS Reporting Services(SSRS),SISS, MS Excel, Oracle, PL-SQL,ASP.NET.

HealthSpring, Nashville, TN Jul 2007 – Feb 2008

Developer

Responsibilities:

Developed SSIS packages to export data from OLTP database to OLAP database.

DDL Scripts for generating Tables, Views, Functions etc.

Using Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.

Generated T-SQL scripts for application development.

Created cursors and User Defined functions.

Created Indexes to speed up the queries.

Created Views for Extracting Data.

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.

Using Bulk Insert to move large data from Text files to SQL Server.

Scheduling Jobs, Backups and Restore of Databases.

Helped the front end application developers with their queries.

Generated SQL reports using MS Reporting Services.

Environment: MS SQL Server 2005, MS Outlook, TSQL, VSS, Visio, SQL Server Business Intelligence Development Studio, Informix, DbVisualizer 4.2.2, SSIS, MS Reporting Services(SSRS),C#,MS Access.

TJC Technology Services, Lexington, KY Jan 2007 - Jun 2007

Developer

Responsibilities

Actively involved in different stages of Project Life Cycle.

Actively participated in gathering of User Requirement and System Specification.

Created new database logical and physical design to fit new business requirement and implemented new design into SQL Server 2000.

Successfully migrated old data from legacy system into SQL Server2000 using DTS Packages.

Filtered bad data from legacy system using complex T- SQL statements, and implemented various constraint and triggers for data consistency.

Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

Created Reports using SQL Server Reporting Services (SSRS).

Wrote complex stored procedures to process drivers record and balanced the processing load between front end and back end.

Implemented batch processing for approval process using Jobs and DTS.

Created Users and Roles, and managed security and permission of database.

Documentation of all the processes involved in maintaining the database for future reference.

Actively participated in User Acceptance Testing, and debugging of the system.

Environment: SQL Server 2005, Active x script,T-SQL, MS Excel, MS Access 2000, Erwin, Windows NT.

Capgemini(Neilsen EDI Corp), Hollywood, CA Mar 2006-Dec 2006

Developer

Responsibilities

Created Logical & Physical Database modeling for in house development application.

Wrote complex stored procedures and cursors to implement various business logics as per the client requirements.

Performed Database Design, Data Modeling using Erwin.

Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.

Environment: Windows NT 4.0, MS SQL Server 2000, MS SQL Server 2005

Contact this candidate