Sql Server Data

Professional Summary

*+ years of experience in Analyzing, Designing, Development, Implementation, Maintenance and Documentation of Database and Client Server applications.

Extensive experience in Designing Relational database model and Implementation as per business needs.

In-depth knowledge of T-SQL.

Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.

Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers using tools like SQL profiler, and database tuning Advisor (DTA).

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

Very strong T-SQL skill in creating and maintaining database objects like Indexes, Views, Stored Procedure, User Defined Functions, Triggers in SQL Server 2008.

Experience in Change Data Capture (CDC), Change Tracking (CT) in SQL server 2008.

Efficient in building recursive queries using CTEs (Common Table Expressions).

Expert in Query Tuning, including Updating Statistics, Re-building and Re-organizing Indexes.

Thorough knowledge of addressing Performance Issues and Involved in Index tuning, Data profiling and other database related activities.

Experience in writing, testing (unit testing) and debugging stored procedures, triggers and troubleshooting database issues.

Hands on experience in performance tuning, query optimization, and database optimization.

Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks and used Profiler to solve Dead Locks.

Experience in Monitoring, Job scheduling, Trouble shooting, Backup, Recovery and System upgrading.

Very Strong in Implementation of Microsoft Business Intelligence (BI) platforms including Performance Point Server 2007 (PPS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Microsoft Office SharePoint Server 8 (MOSS) in SQL Server 2005.

Proficiency in using different Transformation tools like DTS packages, BCP and Bulk Insert as well as SQL Server Integration Services (SSIS).

VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package.

Expertise in Extraction, Transformation, Loading data from Oracle, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.

Designed high level ETL architecture for data transfer from the OLTP to OLAP Using SSIS.

Experience in developing, configuring and deploying SSIS packages and providing security.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Analyzed all facets of Residential Mortgage-Backed Securities (RMBS), including fixed Income, hybrid, and subprime.

Experience working with Active Directory issues such as: logon failures, account lockouts, and authentication problems.

Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.

Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.

Expertise in creating SQL server Reports using SSRS 2005/2008.

Was part of rebuilding all of the Hyperion applications

Proficiency in creating different types of complex reports like Cascading parameters, Parameterized Reports, Crosstabs, Conditional, Pie Chart Reports, Drill-down, Top N, Summary and Sub reports Developed Dash Board Reports on Cognos8.4 report studio.

Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.

Expertise in SQL Server Analysis Services (SSAS) CUBE design, Development and Deploying.

Optimized large cubes by creating partitions, usage based optimization, and using proper storage modes like MOLAP, HOLAP and ROLAP.

Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts and OLAP cubes.

Technical Skills

Tools

SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Server Profiler, Data Base Engine Tuning Advisor, Data Transformation Services, Visual Studio.

Data warehousing

&

Business Intelligence Tools

SQL Server 2008/2005/2000, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SSMS, DTS Packages, MDX Queries, ETL, Performance Point Server, OLAP, OLTP, Visual Studio.

Database Design Tools

&

Data Modeling

MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inman Methodologies, MSX, MS Access, MS Project, ProClarity.

Others

MS Office, Ms Outlook (Microsoft Office Suite), Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007 , TFS.

Professional Experience

K&L Gates LLP, Pittsburgh, PA July 2011 – Till Date SSIS/SSRS/SSAS Developer

K&L Gates LLP comprises nearly 2,000 lawyers who practice in 39 offices located on four continents and practices law on an integrated basis and indeed has the largest integrated network of offices of any global law firm. K&L Gates LLP delivers legal services supported at both the individual office level and through seven firm wide practice areas. I am in a Team called Data & Application Architecture Team. My responsibilities include creating various database objects such as tables, indexes, views and stored procedures. Based on the requirement different SSIS Packages and corresponding SSRS reports were created with data sources, connection strings and defined the datasets for generating the reports.

Responsibilities:

Developed complex queries, stored procedures, views and constraints, triggers using inner and outer joins, unions, and SQL Statements for various applications in different environments.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.

Upgraded MS SQL Server 2005 database to MS SQL Server 2008 R2, by using Detach/Attach, Back up & Recovery.

Well versed in creating Dynamic SSIS packages, using containers & variables, configuring and scheduling the packages.

Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, Fuzzy Grouping etc. for creating many SSIS packages.

Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.

Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.

Created packages in SSIS with error handling.

Migrated all the packages to Test Environment and finally deployed from Test Environment.

Expert in managing Logins, Users, Roles, User Permissions and strong knowledge in Security and Performance.

Created Use Case and Technical documents for PeopleSoft Budget reports to hand-off to the offshore development team.

Documented Report Models and Report Templates for other Team Members.

Created different Parameterized Reports (SSRS 2005/2008), Dashboard Reports (Metrics) for different business modules such as Education, Advertisements etc.

Created Crystal reports in visual studio 9.0 and converted Crystal Reports (.Rpt) to Sql Server Reporting Services (.Rdl).

Created Linked reports, Ad-hoc reports etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition of the reports.

Designed models using Framework Manager and deployed packages to the Report Net Servers.

Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.

Experience in Report Builder in SSRS 2005 and 2008(R2) and Report Builder 3.0.

Designed SSAS cube to hold summary data for Targit dashboards. Developed Cube with Star Schema.

Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.

Worked closely and pro-actively with project leadership to identify and resolve key risks with the Hyperion upgrade project.

Identified and defined Fact relationships. Maintained and deployed OLAP Cubes in SSAS

Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements and Created roles using SSAS to restrict cube properties.

Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.

Generated reports using SQL Server Reporting Services 2005/2008 R2 from OLTP and OLAP data sources.

Designed and deployed report with Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Created report models and deployed on report server.

Designed and implemented several complex reports and administration modules.

Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.

Clear Channel, San Antonio, TX April 2009 – June 2011

SSIS/SSRS/SSAS Developer

Clear Channel Communications, Inc is a global media and entertainment company specializing in mobile and on-demand entertainment and information services for local communities and Premiere opportunities for advertisers. In this project my job is focused on creating Reports according to the business requirement using SQL Server Reporting Service (SSRS) and populate data warehouse using SQL Server Integration Service (SSIS) also includes creating data marts and cubes to improve Information access, enhance analysis process (SSAS).

Responsibilities:

Collected business requirements from users and translated them as technical specs and design docs for development.

Create data verification methods and comply with standard system procedures.

Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.

Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.

Migrated Data from Sql Server 2000 to 2008 and Bulk data migration using SSIS from flat files.

Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc.

Created derived columns from the present columns for the given requirements.

Migrated DTS packages to SSIS using DTS Exchange.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.

Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.

Developed, monitored and deployed SSIS packages.

Developed billing scripts and reports using SQL and PL/SQL.

Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink).

Created reports by using SSRS 2005 and 2008.

Created sub reports, graphs, matrix control for cross tab reports, linked reports & Ad – hoc reports using Report Model Projects.

Environment:

MSSQL Server 2008/2005,Visual Studio 2005. Reporting Services (SSRS 2000/2005/2008),Report Builder 2.0 and 3.0, Business Intelligence Development Studio (BIDS), Crystal Reports, VB,C# , Office 2007 , MS Access, ETL , MS Excel, TFS(Team Foundation Server 2010).

Well Care Health Plans Inc, Tampa, FL Nov 2007 - Mar 2009

SSIS/SSRS Developer

Well care Health plans, Inc. provide managed care services exclusively for government sponsored health care programs, focusing on Medicaid and Medicare. The company served approximately 2.2 million members as of march 31st 2010. The goal of this project is to migrate data from the various systems in the manufacturing domain e.g.: - CAPA, GLIMS, SAP, Sybase etc. The data is extracted from different systems and flat files from these systems into a MDI data mart using Informatica Power Center 8 tools.

Responsibilities:

Extensively used T-SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database

DDL Scripts for generating Tables, Views, Functions.

Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.

Scheduling Jobs, Backups and Restore database.

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

Performance tuning, query optimization and execution plan of queries for better performance.

Maintaining records in Excel Spread Sheet and Exporting data into SQL Server Database using SQL Server Integration Services.

Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.

Experience in Debugging, Error logging, Error Handling and Production support for SSIS.

Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).

Experience in using SSIS tools like Import and Export Wizard, Package Installation, SSIS Package Design.

Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging

SSRS installation and report server configuration.

Worked on all types of report types like tables, matrix, charts, sub reports etc.

Configured IIS and Deployed Reports and Analysis Project in to server.

Extended Data to XML and Excel Spread Sheet.

Perform complex SQL queries and generate reports.

Report parameters included single valued parameters, multi-valued parameters which also consist of different parameter types like hidden, internal, default (queried and non queried parameters).

Data Dimensional Modeling (Erwin Data Modeler), Data Migration (ETL), Data Warehouse / Business Intelligence analysis, design, development implementation.

Environment:

Visual Studio 2005, .NET(C#, VB), SQL Server Management Studio, T-SQL Stored Procedures, SQL Server reporting services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services(SSAS), Crystal Reports, Office,.net, Excel.

T-Mobile Wireless, Atlanta (Georgia) Nov 2006- Oct 2007

SQL Server/SSIS Developer

T-Mobile Wireless Company offers a comprehensive range of wireless and wire line communications services bringing the freedom of mobility to consumers, businesses and government users. T-Mobile is widely recognized for developing, engineering and deploying innovative technologies, including wireless networks services.

Responsibilities:

Created new tables, written stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.

Defined Check constraints, Business Rules, Indexes and Views.

Involved in performing data conversions from flat files into a normalized database structure.

Created and managed users, roles and groups and handled database security.

Worked with Configurations on the Server for sending automatic e-mails to the respective people when a DTS process failure or success.

Developed database objects such as DTS Packages, Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.

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

Developed DTS Packages, worked with DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.

Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Performed development support, document reviews, test plan, integration of the system.

Creation/ Maintenance of Indexes for various fast and efficient reporting processes.

Monitored the Database Growth and Space Requirement. Handling Users/Logins/User Rights.

Managing historical data from various heterogeneous data sources (i.e. Excel, Access).

Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.

Environment:

MS SQL Server 2005, T-SQL,s DTS, Microsoft Visual Source Safe 6.0, Flat files, SQL Server 2005 Management, Windows 2003 Server. SQL Server Analysis Services (SSAS), Crystal Reports, Office, Excel.

Citi Bank, Chicago, IL Apr 2006 – Nov 2006

Microsoft BI Developer

Citi Bank is second-largest bank has a network of 2,014 branches and presence in 18 countries. Citi Bank offers a wide range of banking products and financial services to corporate and retail customers. The project involved migrating old legacy data to SQL Server 2000 using DTS, calculate different investment management business logics and generate reports for the Investors and managers.

Responsibilities:

Involved in writing scripts for the clients requirements for reporting purposes.

Involved in creating SQL server Analysis Projects using MS SQL Server 2005.

Created cubes and dimensions.

Defined the Referenced Relationships with the measure groups and fact tables.

Automatic generation of grouping attribute members.

Defined Granularity with in a measure group and drill through actions.

Implemented calculations to aggregate physical measures.

Defined the Browsing Prospective and Browsing Translations.

Responsible for identifying KPIs in SSAS 2005.

Responsible for Process Database Objects Security Role.

Developed SSIS project for transferring the data.

Responsible for writing T-SQL code for creating cursor and handling the data validations.

Developed complex T-SQL code for the application.

Transformed the complex business logic and calculations into coding.

Developed stored procedures, functions, tables, views and triggers.

Implementing MS SQL Server Security and database Permissions.

Wrote DTS scripts that extract data from database tables and write the data to text files

Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.

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

Created SQL reports, data extraction and data loading scripts for different databases and schemas.

Environment:

SQL Server 2005 Enterprise Edition, SSIS, SSRS, SSAS, MS-Excel, DTS, Visual Studio.Net 2005, Windows server 2003, T-SQL, PL/SQL, MS Access 2000, C#, ADO.NET, XML, Web Services.

Deloitte Consulting PVT Ltd, HYD, AP Jun 2003 – Feb 2006

SQL Server Developer/DBA

“Deloitte” is the brand under which tens of thousands of dedicated professionals in independent firms throughout the world collaborate to provide audit, consulting, financial advisory, risk management and tax services to selected clients. These firms are members of Deloitte Touché Tohmatsu, a Swiss Verein (DTT). The Project involved development of Price Analysis System. The objective was to develop efficient and effective price analysis strategies. The new system eliminates the traditional MRP method and gives more visibility on prices. Implementation of this system has given the company a huge competitive edge over its competitors.

Responsibilities:

Performed the creation, manipulation and supporting the SQL Server databases.

Involved in Creation of tables, indexes, sequences, constraints, triggers and procedures.

Migrated the data (Import & Export of data) from one server to other servers using tools like Data Transformation Services (DTS)

According to the business requirements made the documentation of the performed tasks.

Backing up, restoring system & other databases as per requirements, and also scheduled those backups.

Managing the security of the servers, creating the new logins and users, changing the roles of the users

Experience in Database Backup, Recovery and Disaster Recovery Procedures.

Determined the MS SQLServer2000 installation options. Installed SQL Server Management tools using SQL Server Setup Program. Tested the Installation of SQL Server and implemented different security modes.

Experienced on Database creation, database tuning, and performance planning, backup planning and database administration.

Involved in Creating Database Objects like Tables, Stored Procedures and Views.

Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to the I/O.

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

Environment:

MS SQL Server 2000 Enterprise Edition, Enterprise manager, MS Access 2000 &Windows NT platform, Reporting Services, DTS, Business Objects 4.0/6.5, Windows Active Directory.

Education:

Bachelor’s in Computer Science, Jawaharlal Nehru Technological University, Hyderabad, India.

Contact this candidate