Sql Server Data

Location:

Posted:

May 07, 2012

Resume:

PROFESSIONAL SUMMARY

• * years of extensive experience in Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2000/2005/2008.

• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.

• Expert in creating Tables, Views, User Created Data Types, Functions, Indexes, Stored Procedures and Triggers.

• Used SQL profiler to view indexes performance to mostly eliminate table scan.

• Experience in requirements gathering, analysis & design of ETL processes using SQL Server Integration Services (SSIS) and SSRS.

• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.

• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).

• Experienced in extraction & migration of data from heterogeneous data sources like Excel, MS Access to MS SQL Server by using import/export Wizard, DTS/SSIS

• Extensive experience in creating ETL packages using SQL Server Integration Services (SSIS) and scheduling packages, validating data using SSIS.

• Experience in providing Logging, Error handling by using Event Handler for SSIS Packages.

• Good experience in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008 across various environments.

• Experience in creating Ad-hoc reports, data driven subscription by using Report Builder in SSRS.

• Expertise in generating drill down reports, parameterized reports, linked reports, sub reports in SSRS 2005/2008.

• Monitored and analyzed the performance and results of an organization using Dashboards and KPI’s in Performance Point Server 2007 (ProClarity).

• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.

• Knowledge in Data warehousing, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.

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

AREAS OF EXPERTISE

Platforms Windows Server 2000/2003/2008, Windows Vista/XP/2003/2000 UNIX, Linux, DOS

SQL Server Tools

&Packages/BI tools SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, Crystal Reports, ETL, SSIS, SSAS, SSRS, Erwin Data modeler

Applications C/C++, HTML, XML, Visual Studio

Desktop MS Office Suite, Word, Excel, Access, PowerPoint, Outlook

Databases SQL Server 2000/2005/2008, MS Access 97/2003/2005/2008

EDUCATION

Bachelor’s in Pharmacy, Osmania University, Hyderabad, India.

PROFESSIONAL EXPERIENCE

Public Consulting Group, Windsor, CT May 2011 to till

MS SQL Server / BI Developer

PCG Education™ helps schools, school districts, and state departments of education to maximize resources, achieve their performance goals, and improve student outcomes. With more than two decades of K-12 consulting experience across the U.S. and in Canada, PCG’s expertise, capacity, and scale help educators to improve their decision making processes and achieve measurable results.

Responsibilities:

• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008

• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.

• Designed, reviewed, and created objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.

• Wrote various T-SQL queries, Stored Procedures and used them to build packages.

• Created Triggers, Tables, Views and SQL Joins for various applications.

• Responsible for Database and Log backups & Restoration, backup strategies and scheduling backups. Scheduled the SSIS packages and Jobs.

• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.

• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.

• Constructed Cubes based on data volumes mostly adhering to Star Schema.

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

• Created SSIS process design architecting the flow of data from various sources to target.

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.

• Created reports to retrieve data using Stored Procedures that accept parameters.

• Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.

• Proficient in SQL Server Reporting Services as I transferred and made reports in SQL Server Reporting Services( total more than 70 reports including sub reports) with different types like Drill down, using Parameters, with sub reports and also work for ad hoc reporting services.

• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.

• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.

• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.

• Experience in using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL SERVER 2005, MS SQL Server 2008, SSIS, SSRS, SSAS Business Intelligence Studio, SQL Profiler, Windows XP / NT / 2000/2003, Microsoft Access.

Microsoft Corporation, Redmond, WA Oct 2010 – April 2011

SQL Server SSAS/SSRS/SSIS Developer

Microsoft Corporation is an American Public Multinational Corporation headquartered in Redmond, Washington, USA. Working as Tier 2 operational engineer supporting various property groups. Providing services to Enterprise service delivery team to improve the efficiency and automation of services.

Responsibilities:

• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.

• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.

• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.

• Extract Transform Load (ETL) development using SQL Server 2005 Integration Services (SSIS).

• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.

• Enhancing and deploying the SSIS Packages from development server to production server.

• Created complex SSAS cubes with multiple fact measures groups.

• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.

• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.

• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

• Modifying report content and exporting reports in multiple formats based on the business requirements.

• Designed and implemented Parameterized and cascading reports using SSRS 2005.

• Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.

• Created Triggers to enforce data and referential integrity.

• Defined Check constraints, Business Rules, Indexes, and Views.

• Created derived columns on the final fact and dimension tables as per the business requirements.

• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.

• Created Analytical reports by PROCLARITY tool.

• Played a major role in production support of SSAS (cube refresh), SSIS jobs.

• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle

Wachovia Corporation, Charlotte, NC Nov 2009 – Sep 2010

SQL Server/SSRS/SSIS Developer

Wachovia Corporation is the fifth largest bank holding company in the United States. The project aimed at providing maintenance and support for the various operations of the bank after merging with the Wells Fargo. The project mainly dealt with migrating data and integrating data using SSIS. The project deals with mortgage where it aims at achieving financial goal with the usage of SQL Server Integration Services that provides for improved quality control and increased productivity.

Responsibilities:

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.

• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.

• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination.

• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.

• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.

• Knowledge of developing reports from Cubes using the KPI’s for decision making, also debugged data connections, data sources and Data Source Views.

• Creating Ad Hoc and Parameterized various Reports using SQL server 2005 Reporting Services

• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.

• Have used BCP, BULK INSERT to transfer data from and to SQL server database.

• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL SERVER 2000, MS SQL Server 2005, SSIS, SSRS, Business Intelligence Studio, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Pacific Life Insurance, Newport Beach, CA May 2009 - Oct 2009

SQL Server Developer/DBA

Pacific Life provides life insurance products, annuities, and mutual funds, and offers a variety of investment products and services to individuals, businesses, and pension plans. Pacific Life counts more than half of the 100 largest U.S. companies as clients and is a member of the Insurance Marketplace Standards Association (IMSA), whose membership promotes high ethical standards for the sale of individual life insurance and annuities.

Responsibilities:

• Involved in gathering the functional requirements from the client.

• Involved in Creating Complex Store Procedure using T-SQL to evaluate result for the repots to implement using Management studio.

• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.

• Developed different Scripts for the Data analysts for Verification of reports.

• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.

• Performed data conversions from flat files into a normalized database structure.

• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.

• Created Triggers to enforce data and referential integrity.

• Defined Check constraints, Business Rules, Indexes, and Views.

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

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

• Perform T-SQL tuning and optimizing queries for Reports.

Environment: Microsoft SQL Server 2000, SQL Server Reporting Services (SSRS), Windows XP, MS Excel 2003, VBScripts.

Ameriquest Mortgage Co, Irvine, California Oct 2008 – April 2009

SQL Server Developer

Ameriquest was one of the United State’s leading wholesale lenders which are no longer into existence. It was among the first mortgage companies to use computers to search for prospective borrowers and to speed up the loan process.

Responsibilities:

• Designed a data share system using SQL Server Integration Services. Architected a database for a project that would host secure keys and assign keys to users based on business rules.

• Automated several legacy tasks using a combination of SQL Server and .NET (VB).

• Used tools such as Coefficient, SQL Server Profiler, Query Estimation Plan to obtain and analyze traces on worst performing stored procedures and queries.

• Provided training to junior/intermediate level members of the data management team on several DBA related responsibilities and tasks such as Backup Maintenance plans, Replication and Log Shipping.

• Assisted the programming department with the maintenance of create/upgrade SQL scripts pertaining to software versioning. Created high level design documents to go along with projects and tasks.

• Maintained a very high availability and Administered 53 databases spread across 15 production SQL servers.

Environment: SQL Server 2000, SSIS, VB. Net, T-SQL, SQL Server Profiler, ETL Tools.

SBI Life Insurance, Bangalore, India Jan 2008-Sept 2008

SQL Server Developer

SBI is a leading provider of a full range of insurance and healthcare services, offered through its subsidiary companies. Its focus is to offer a comprehensive range of life insurance and pension products at competitive prices, ensuring high standards of customer satisfaction and world class operating efficiency, and become a model life insurance company in India in the post liberalization period.

Responsibilities:

• Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.

• Part of team for analyzing and implementing the physical design for the database.

• Responsible for drafting documentation for describing the metadata and writing technical guides.

• Created Stored Procedures, Triggers, Views and SQL Joins and other statements for various applications.

• Responsible for transferring of the databases and database objects from Development to Production Server using DTS.

• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.

• Exposure in developing reports using SSRS 2000.

Environment: SQL Server 2000, T-SQL.

UTI Bank, Hyderabad, India May 2005–Dec 2007

Jr. SQL Server Developer

UTI bank is one of the largest banks in India providing 24 hour’s service. UTI bank deals in retail and corporate banking services. I started my IT career with this project as a Jr SQL Developer.

Responsibilities:

• Data transfer between Development, Testing and Production databases.

• Actively designed the database to fasten certain daily jobs, stored procedures.

• Provided support to development staff about database related issues.

• Use DDL and DML for writing triggers, stored procedures, and data manipulation

• Scheduled database backup and performed full, incremental and differential backups of database and transactional logs

• Alteration of tables and fields as per requirements and recreation of indexes.

•

Environment: SQL Server 7.0/2000, T-SQL, Query Analyzer, Windows NT/2000 server.

Contact this candidate