Sql Server Data

Summary:

Over * years of experience in IT industry as a SQL Server Developer with specialized skills in SSIS, SSRS and SSAS.

Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.

Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, DCL commands for various business applications.

Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.

Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures

Experience in Error handling and debugging coding issues and troubleshoot production problems.

Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import, Export Data, Bulk Insert .

Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits, Error Logging and Event Handlers.

Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages

Experience in conversion of packages from legacy systems and migrating, deploying the packages across DEV/UAT/Prod environments.

Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.

Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.

Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters.

Data modeling experience focusing on high-activity, normalized transaction systems (OLTP), highly-usable de normalized reporting systems (OLAP) as well as staging areas and data marts.

Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP and Normalizations.

Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling.

Excellent analytical/Communication Skills, Team Play and very much result Oriented.

Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.

TECHNICAL SKILLS:

Data Modeling : ER-Win, MS Visio.

Data base : SQL Server 2005/2008, 2008 R2/2012.

BI Tools : BIDS/SSDT, SSIS, SSAS, SSRS, Power Pivot, Power View, Tableau Desktop 6.x/7.x/8.x, Tableau Public, Tableau Reader, Tableau Server, Tableau Online, Micro Strategy Analytics, Micro Strategy Mobile, Micro Strategy Cloud.

Languages : T-SQL, C, C++, C#.Net.

Web Development : HTML, DHTML, XML, IIS, LINQ, Asp.Net

Operating Systems : Windows XP, Vista, 7, 8, Windows Server, Tableau server

SDLC : Spiral Model, Waterfall, Agile, Scrum.

Others : MS Dynamics, CRM, TFS, VSS, SharePoint Dashboard.

CERTIFICATIONS:

MCSE-DP : Data Platform Solutions Expert

070-464 : Developing Microsoft SQL Server Databases

070-465 : Designing Solutions for SQL Server

MCSM/MCSE-BI : Business Intelligence Solutions Expert

070-466 : Implementing Data Models and Reports with MS SQL

070-467 : Designing Business Intelligence Solutions with MS SQL Server

Education: Bachelor of Technology in Computer Science from JNTU University.

PROFESSIONAL EXPERIENCE:

Ironside Group, Lexington, MA Sept’15 - till date

Role: SQL Server/SSIS/SSRS Developer

Ironside Group is a leading innovator in the rapidly evolving world of business analytics; help organizations ranging from Fortune 500 members to startups solve core business challenges through best-of-breed analytics technology. To meet the diverse needs of the clients, it specialize in all facets of business analytics, including business intelligence, performance management, predictive analytics, information management, big data.

Roles and Responsibilities:

Created new database objects like Procedures, Functions, Indexes and Views using T-SQL.

Created Service Broker Queue for internal or external processes to send and receive guaranteed, asynchronous messages by using extensions to Transact-SQL Data Manipulation Language (DML).

Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.

Implemented different built in transformations tasks including SCD, Aggregate, Lookups and Data Conversion to implement complete ETL strategy.

Used various Package configurations available for SSIS Packages like XML files and SQL Server Tables.

Implemented the Master Child Package Technique to manage big ETL Projects efficiently.

Involved in debugging the Packages by utilizing SSIS features like breakpoints, Data-Viewers and custom loggings.

Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.

Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly.

Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.

Automated the ETL process by scheduling SSIS package execution by creating jobs.

Created QA (Quality Assurance) scripts and sanity checks to further test ETL packages by comparing QA output with output from ETL package.

Tested the packages developed in DEV server to find out any bug and handled the errors encountered at the time of testing.

Identified and defined the Datasets for the report generation and wrote the queries for the drill down reports, identifying and adding the report parameters.

Developed designed and implemented - Executive Dashboards (BI), Marketing Analytics, and Life cycle management - from customer acquisition to collections management, Mobile strategy, Digital Analytics using Micro Strategy Analytics.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS),OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003

The Manhattan Professional Group, NY Nov’13– Aug’15

Role: SQL Server/SSIS/SSRS Developer

The Manhattan Professional Group provides integrated financial solutions that address the wide-ranging needs and goals of its clients. The project was aimed at developing a solution for Investment firms to manage their accounting and tax processing needs.

Responsibilities:

Created new tables, views, stored procedures, user defined functions and triggers in development.

Worked closely with Web Developers and Business Analysts to produce all required documentation.

Handled database objects with Enterprise Manager and Query Analyzer.

Write T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries and stored procedures.

Modified some of the existing stored procedures and created new stored procedures for the current year to implement business logic.

Create joins and sub-queries for complex queries involving multiple tables.

Proper use of Indexes to enhance the performance of individual queries and enhance the Stored Procedures.

Dropped and recreated the Indexes on tables for performance improvements.

Involved in writing detail design document for future reference.

Involved in setting up the data for testing.

Responsible for moving the database objects from development to testing environment (SIT) for testing.

Responsible for Unit testing and helped the QA team in fixing up the defects at the time of system testing.

Used SQL Profiler to optimize queries and enhance the performance of database.

Responsible for stored procedures optimization, performance tuning and index tuning.

Extensively used SQL Analyzer and Profiler for studying the SQL statements and procedures.

Extensive testing on the Performance of the Stored Procedures.

Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.

Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.

Experience in enhancing and deploying the SSIS Packages from development server to production server.

SSRS installation and report server configuration to Support all Renders of Reports.

Developed reports using SSRS 2008. Used table control, matrix control for cross tab reports.

Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.

Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.

Environment: Windows XP, MS SQL Server 2000/2005/2008,SSIS,SSRS,ASP.Net, T-SQL

Sterling Bank, Houston, TX. Oct’11-Sep’13

Role: SQL Server Developer/SSIS

Sterling Bank is a leader in banking for business owners in Texas with 40 offices serving the metropolitan areas of Houston, Dallas and San Antonio. Sterling has grown to $3.7 billion in assets since going public in 1992 with assets of $256 million. Sterling is a wholly owned subsidiary of Sterling Bancshares, Inc., which trades its common stock through the NASDAQ National Market System under the symbol SBIB.

Responsibilities:

Managed index, statistics and optimizing queries by using execution plan for tuning the database.

Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

Experience in Extracting Data From XML and flat files using SSIS

Expert in SSIS Deploying and Scheduling

Developed, monitored and deployed SSIS packages.

Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Data Transfers between various servers using BCP and Managing Disk space on NT systems.

Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures

Identified the Data Source and defined them to build the Data Source Views.

Developed Query for generating drill down reports in SSRS 2005.

Designed and implemented stylish report layouts.

Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas and user-defined functions.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Created SQL Server Reports using SSRS 2005.

Identified and worked with Parameters for parameterized reports in SSRS 2005.

Responsible for scheduling the subscription reports with the subscription report wizard.

Deployed the generated reports directly on the client’s workstation.

Analyzed reports and fixed bugs in stored procedures.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Drove the adoption of TFS across contracts through briefings, training and requirements gathering. Extended Team foundation server events with custom web services.

Used Visual SourceSafe for source control and versioning

Environment: MS SQL Server 2000/2005 Enterprise Edition,,.Net,ASP.Net, MS SQL Server Reporting Services 2005,SSIS,SSAS, Erwin 4.1, .NET 2.0 sp1 &sp2,Windows Server 2003,VSS,TFS.

Asian Paints India Ltd. Mumbai, India Aug’09– Dec’10

Role: SQL Server DBA /Developer

Asian Paints is India's largest paint company and ranks among the top ten decorative coatings companies in the world today. The company has an enviable reputation in the corporate world for professionalism, fast track growth, and building shareholder equity. Asian Paints operates in 23 countries and has 29 paint manufacturing facilities in the world servicing consumers in over 65 countries. Besides Asian Paints, the group operates around the world through its subsidiaries Berger International Limited, Apco Coatings and SCIB Chemicals.

Responsibilities:

Installed SQL Server Management tools using SQL Server Setup Program.

Tested the Installation of SQL Server.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.

Worked on replication server and managed.

Fine tuning of database objects and server.

Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database.

Data migration (import & export - BCP) from Text to SQL Server.

Created Triggers to enforce data and referential integrity.

Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.

Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.

To setup, implement, and maintain industry standards in database management.

Monitoring SQL server performance using profiler to find performance and dead locks.

Monitoring the servers using spot light third party Quest software.

Recovering the databases from backup in disasters

Maintaining the database consistency with DBCC at regular intervals

Monitoring SQL server performance using profiler to find performance and dead locks.

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000/2005.

Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.

Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

Wrote Transact SQL utilities to generate table insert and update statements.

Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.

Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.

Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Coding, debugging and testing of the application

Environment: SQL Server 2000/2005 Enterprise Edition, T-SQL, Enterprise manager, VBS, MS Office & Windows 2K platform.

References on request…..

Contact this candidate