We provide IT Staff Augmentation Services!

Sql Resume

Atlanta, GA

SUMMARY

7 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.

Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.

  • Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
  • In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
  • 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 R2 Integration Services (SSIS) (2005/2008).
  • Experience in creating dashboards, scorecards and building reports using performance point server 2007.
  • Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
  • SQL Server 2000/2005/2008 RDBMS database development including T-SQL programming.
  • SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
  • ETL implementation using SQL Server Integration Services (SSIS).
  • Experience in creating and maintaining security mechanisms for reports, creating repository domains using Business objects Supervisor.
  • Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
  • Thorough understanding of Kimball’s’ theory, KPIs, SQL 2005 Architecture.
  • Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
  • Worked with Business Decision Appliance (BDA) to accelerate analysis and decisions.
  • Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
  • Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Involved in DBA activities such as backups, restores, replication etc.
  • Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.
  • Excellent communication skills, analytical skills, understand business requirements in various domains.

CERTIFICATIONS

  • Microsoft Certified Technology in SQL Server 2008.

TECHNICAL SKILLS

SQL Server Tools:

SSMS, Profiler, Erwin, Export & Import (DTS), Lite speed, SQL Backup5

Monitoring & compliance tools:

SCOM, Spotlight, SQL secure, VMware ESX3.5

Databases:

MS-SQL Server 2000/2005/2008,MS Access 97 & 2000,My SQL, Oracle

BI Tools:

SSAS, Pro Clarity, SSRS, PPS, Hyperion

Languages:

SQL, PL/SQL, C

Operating System:

Windows NT 2000 Server/ Server/ Server 2003/server 2008/Professional/ 4.0, Win XP Prof/Standard, Win 98, HP Unix 10.x

Professional Experience

Confidential,Atlanta, GA Aug 2011-Present
SQL Server Developer (SSRS/SSAS)
Confidential,is a professionally monitored “Security 2.0” product that combines the benefits of a traditional home security system with advanced features such as remote access, video, and home automation. Currently about 17% of U.S. households subscribe to a traditional monitored security system. Cox research has shown that the market can grow due to the new Security 2.0 features, evidenced by the 10-12% down-weighted purchase intent in CHSI subscriber households that do not currently have a monitored security system.
Responsibilities:

  • Performance tuning, and optimization of procedures and queries.
  • Performed all aspects of database administration, including data modeling, backups andrecovery.
  • Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
  • Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Worked with Business Decision Appliance (BDA) to accelerate analysis and decisions.
  • Excellent report creation skills using Microsoft Reporting Services (SSRS). Extensively used SQL Reporting Services and Report Builder Model to generate custom reports: Designed and created Report templates, bar graphs and pie charts based on the financial data; Wrote queries to generate reports for analysis of data; Used table control, matrix control to create cross tab reports; handled sub reports and defined query for generating drill down reports in SSRS.
  • Developed SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading (ETL).
  • Writing reports using Microsoft Reporting Services (SSRS)
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server R2 Integration Services (SSIS) (2005/2008).
  • Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
  • Worked with development teams in the design of physical databases and in modification.
  • Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
  • Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
  • Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
  • Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
  • Designed cubes with star schema using SQL Server Analysis Services (SSAS).
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Created packages in SSIS with error handling.
  • Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
  • Developing and extending the cubes with around 35 dimensions, about 10 measures, and 25 calculated members, Design Dimensions and using the MDX expressions for the various Optimizations like Optimizing cube schema
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
  • Worked with different methods of logging in SSIS.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Have deployed packages on different servers by configuring it.
  • Installed and configured SQL Server 2008/2005 in Test environment with latest service packs and migrated few databases.
  • Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
  • Implemented computational sensitive queries Stored Procedures.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
  • Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
  • Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
  • Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
  • Involved in migration from SQL Server 2000 to SQL Server 2005.
  • Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
  • Written DDL / DML Triggers as per company policy.
  • Actively involved in Normalization (3NF) & De-normalization of database.
  • Experience in installation, un-attended deployments, configuration and administration of Windows NT, 2000 and 2003 servers in very large environments.

Environment: MS SQL Server 2008/2005, SQL Server SSAS/SSRS/SSIS, MDX Cubes, OLAP, Microsoft Windows 2003 Advanced Server, ASP.NET, C#, ETL, Enterprise Edition, Microsoft Visual Basic 6.0, SQL LiteSpeed, OLAP.

Confidential,Columbus, OH. Sep 2010-Aug 2011
SQL BI Developer
Confidential,is a property and casualty insurer domiciled in the State of Ohio with primary interest in Property and causality, Health, Banking and Mortgage, Life insurance & Retirement Savings and Asset Management. The project primarily involved Extracting Underwriting, Rating and Product rules from online and batch process of Policy Administration System. These rules will be loaded into a rule engine as a next phase. The project involved in converting multiple BizTalk Applications to SSIS
Responsibilities:

  • Analyzing the FTA’s and the business requirements and building logical and physical data models.
  • Creating high level design of the ETL process
  • Creating three step ETL process to get the files from the server and load the data into database.
  • Designing several ETL processes to Load data from Text or Excel Files
  • Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
  • Designing of SSIS Packages to get data files fromFTPandSFTPServer and decrypting thePGPfiles,batch processingof incoming data and purging of old files
  • Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Created Packages in SSIS with error handling.
  • Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
  • Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
  • Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2005.
  • Designed and created cubes in SSAS.
  • SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.
  • Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
  • Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi dimensional model.
  • Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
  • Involved in creating Dimensions, KPI, Measures and calculations in SSAS 2008.
  • Worked with different methods of Logging in SSIS.
  • Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
  • Generation of reports from the cubes by connecting to Analysis server from SSRS.
  • Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
  • Created complex Stored Procedures to validate and process the incoming data.
  • Generating Validation Reports to notify the client with the invalid data received.
  • Used C# to merge multiple XML reports, convertXMLto HTML format usingXSLTfiles and sending Validation Report emails.
  • WrittenPower shell scriptsto purge files
  • Understanding of existing DTS packages and redesigning them into SSIS packages and facilitate batch processing
  • Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files
  • Scheduling execution of ETL Packages using SQL Server Agent.
  • Creating detail design documentation of the packages and creating release notes for each installs.

Environment: SQL Server 2008, Oracle, MS Access, Excel, Windows Server 2008, IIS, Visual Source Safe, Share point Server, Cold Fusion, Net Frame Work, ADO.Net, VB.Net, ASP.Net, XML Parsing, VB6, VB Script, Java Script and C# , SSAS, SSRS, SSIS, MDX Cubes.

Confidential,Denver, CO May 2009 – Sep 2010
SQL Server Developer/ SSRS Developer
Description: Successfully developed and maintained ETL maps to Extract, Transform and Load data from various sources like Flat files, relational data and XML files into the Enterprise Data warehouse called Pharmacy Data Warehouse Management system. This includes creating and running scripts. Data warehouse collects full life cycle data for Biological Pharmaceutical products right from the new product introduction through its manufacturing, testing, shipping, and success and failure analysis. The data is used to make decisions for new product improvements, failure analysis of existing products, improve customer service. Various reports were generated using Microsoft reporting services (SSRS).
Responsibilities:

  • Writing stored procedures, triggers, cursors, and views to improve the quality of application, and manage mission-critical information using T-SQL.
  • Develop and support reports built with Microsoft Reporting Services on SQL 2005 SSRS.
  • Created/developed/maintained the stored procedures, triggers to interpret complex business rules, history data and audit analysis.
  • Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
  • Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation
  • Ensure that periodic (daily, weekly and monthly) reports are delivered in a timely and accurate fashion using Reporting services SSRS.
  • Using Integration Services (SSIS), built high performance Data Integration Solutions, including extraction, transformation and loading (ETL) packages for data warehousing.
  • Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
  • Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
  • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
  • Migrated data from the DB2 database using SSIS Packages.
  • Optimized performance and capacity planning of various data transformation processes related to the reports.
  • Provided technical support to internal developers and external clients.
  • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
  • Develop and support reports built with Microsoft Reporting Services (SSRS) on SQL 2005.
  • Maintain and monitor the data warehouse to ensure its proper operation, performance and availability.

Environment: SQL Server 2008/2005, SSIS, SSRS, SSAS, MDX, OLAP, DB2, ETL, Visual Studio.NET, Erwin, DB Artisan, Windows NT/2003, UNIX.
Client: Confidential,Sunnyvale, CA Aug 2008 – May 2009
MS SQL Server Developer
Confidential,combines Photonic Integration with our unique Bandwidth Virtualization technology to create the Digital Optical Network.
Responsibilities:

  • Involved in Migration of SQL Server 2000 to SQL Server 2005.
  • Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
  • Implemented and maintained Database mirroring as a Disaster Recovery Solution.
  • Installed, authored, and managed reports using SQL Server 2005 Reporting Services
  • Analyzed the project environment and sub systems of the project, and prepared a high level documentation for application designing.
  • Interact with the clients and gather the requirements and analyzed.
  • Responsible for gathering business requirements, developing and reviewing of design documents
  • Did trouble shooting of Client connections, viewing error log and applications.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Transferred data (ETL) to Data ware house Environment using SSIS.
  • Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
  • Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases
  • To analyze long running queries and tune the same to optimize application and system performance.
  • Maintained the database consistency with DBCC at regular intervals.
  • Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.

Environment: MS SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS and Windows Server 2003, MS Access.

Confidential,India Nov 2006 – Aug 2008
SQL Server Developer

Description: Administration of GE-SBI Credit Card Databases, SBI/SBBJ ATM Card databases and Maruti-GE databases. State Bank of India (SBI) is the largest bank in India of which GE is supporting entire credit card business for SBI. I as a team member used to maintain risk and remittance server for the business and high availability.
Responsibilities:

  • To ensure trouble free access to SQL Server databases 24 hours a day.
  • Timely completion of activities for database backup, restoration and health of databases.
  • Monitoring Log shipping/Replication and trouble shooting of errors.
  • Planning for and carrying out installation and upgrade of SQL Servers.
  • Security issues related to logins, database users, and application roles and linked Servers.
  • Performance Tuning of SQL 7.0 / 2000 Servers.
  • Involved in trouble shooting and fine-tuning of databases
  • Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
  • Wrote scripts for generating Daily Backup Report, verifying completion of all routine backups, Log Space utilization monitoring etc.
  • Created Linked Servers between SQL Server 2000 & Oracle 9i. Also created DTS package for data transfer between the two environments.
  • Backups and Restoration of data/database using a Third Party Tool (SQL LiteSpeed).
  • Involved in Design and Development of Disaster Recovery Plan.

Environment: SQL Server 2000/7.0. Windows 2003/2000 Server and SQL LiteSpeed

Confidential,India Jun 2005 – Nov 2006
SQL Server Developer
Confidential, is one of the leading providers of auto, home and life insurance in INDIA. As a consultant for the HRMS, part of an ERP, I developed and helped to implement HRMS to handle human resource activities. HRMS , a web based three-tier architecture system which provides information about employee data, new hire, applicants, promotion, demotion, absence, payroll data, and change of certain business rules that required development of new modules to the system.
Responsibilities

  • Involved in logical modeling and physical modeling of the database.
  • Successfully implemented physical database on MS SQL Server 2000. Supported complex relationship using triggers.
  • Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database.
  • Facilitated simplified access of database for end users using de-normalized views and created triggers on them to maintain to database integrity.
  • Created audit trails of activities on database using triggers on backend.
  • Implemented the business logic and processing of the payment by developing stored procedures and scripts.
  • Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment.
  • Used SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.

Environment: MS SQL Server 2000, T-SQL, Visual Basic 6.0 and windows NT.

Hire Now