SUMMARY

• Over 8+ years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• High proficiency with SQL Server Architecture (Fundamentals of SQL Server Architecture, Features of SQL Server, Relational Database Components, Database Architecture, Relational Database Engine Architecture, Administration Architecture, Application Development Architecture).
• Strong Transact - SQL Queries writing skills (DDL- data definition language and DML- data manipulation language).
• Experience of Working With one of the Largest Databases (EDW/ECDW) in the industry using Teradata. Also with Microsoft Parallel Data Warehouse (PDW). The latest in the industry.
• Good knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• In depth knowledge of developing complex stored procedures, views, efficient triggers, required functions, and creating indexes and indexed views for speedy performance using SSMS and SQLCMD.
• Experience in Tuning SQL queries and T-SQL queries & improving the performance of the Database.
• Experience in MS-SSRS, SSIS, SSAS, OLTP, OLAP, Slowly Changing Dimensions, Data cleansing and Data Migration, Performance tuning, Designing logical/physical databases and Troubleshooting.
• Hands on experience in migrating data from external system including flat files, excel, MS Access and oracle into SQL Server 2008 using SSIS packages.
• Experienced in Leading a Team and achieving the goals in quick and efficient manner.
• Hands on Experience in working with Teradata, Oracle, Db2, MySql environments.
• Hands on experience in developing and deploying DTS and SSIS Packages, creating Jobs, Alerts and scheduling DTS/SSIS Packages, and also working with Agile and Scrum Methodology.
• Strong SQL Server Administration skills using various backup strategies, Model (simple, bulk and full), database maintenance plan, user (NT/SQL) security authorizations, database creation, Tables, indexes.
• Experience in different types of Cube Designs such as Rolap, Holap and Molap.
• Having Hands on Experience on work with Drill down reports and Cube Caching using Pre aggregations and effectively partitioning the cube for optimal performance.
• Experience in implementation and maintenance of Very Large Databases (VLDB).
• Experience in Disaster Recovery with Backup and Restore Strategies and scheduling those backups.
• Hands on experience in database tools like SQL Server Management Studio, Enterprise Manager, SQL Server Business Intelligence Development Studio.
• Hands on experience in migrating Database from SQL SERVER 2000 to SQL Server 2005 and SQL Server 2008 and SQL Server 2012.
• Knowledgeable in various new features of SQL Server 2012 like Big Data Support, Column Store Indexes, compression based backup methodology etc. Related to SQL Server 2008, Knowledgeable about its features like: Merge Join, Common Table Expressions, Rank Function etc.
• Experience in connecting to Salesforce cloud and getting the huge data sets into Sql Server Tables using SSIS and third party tools like BiExpress and Cozyroc
• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience in logical and physical data modeling and database design using Erwin.
• Excellent communication, learning, problem solving. Proficient in technical writing and presentations.
• Excellent Interpersonal skills, self-motivated, quick learner, and a strong Team player with excellent team work skills and ability to adapt to new projects very easily.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008/2012 , Teradata 13/12, Microsoft Parallel Data Ware House (PDW). Oracle 11g/10g, MS-Access 2007/2010, Mysql 5.02.

Database Tools: Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, BiExpress, CozyRoc, DTS, BCP, Business Intelligence Studio, Crystal Reports, Agile

Languages: T-SQL, MDX, Pl-Sql, C, C++, HTML, Java script, PHP, UNIX Confidential Scripts.

Operating Systems: Windows 7, Windows 2003, Windows 2000 server, Win ME/NT/XP/vista, UNIX.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2008/2010/2012 , Pentaho Kettle, Microsoft Visio2010. Sales Force.

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP,ETL Tier

PROFESSIONAL EXPERIENCE

Confidential, Fort Lauderdale, FL

Sr SQl Server SSAS/SSIS Developer

Responsibilities:

• Responsible for building a new Services BI database with the respective tables and views required as given by the business team
• Responsible for connecting to the Sales force cloud using Cozyroc and BIExpress via SSIS
• Design and Development of SSAS Cubes from the created database
• Implemented Many SSIS Packages and Jobs to assist with daily running queries.
• Created complex stored procedures and developed dynamic SQL Queries to adopt dynamic environment.
• Responsible for Creating Calculated measures, Partions and aggregations for performance of the Cube.
• Creating Multi-Dimensional-Queries (MDX) for complex calculation and better performance of Cube.
• Proactive monitoring of Database performance.
• Responsible for creating an SSRS report to track all the SQl Agent Job runs and its status dynamically.
• Responsible for having meeting with the clients and getting the business requirements
• Created user defined data types and added them to model database for future purpose.
• Involved in Database design and worked with Production DBA.
• Was single point of contact between the Business Users and the Technical team to make sure they get the desired result.
• Also responsible of giving Technical presentation to demo the applications to users.
• Setting up database backup and recovery procedures for production, quality and development servers.
• Monitored and scheduled new jobs on production environment.
• Experience on migrating the data to Microsoft Parallel Data Warehouse (PDW) servers.
• Mentor the front end users on how to use the Datamart and the reports created out of the Cube.
• Responsible for Creating Data Design Document (DDD) which documented everything in the project.
• Successfully deployed SSIS Package into Production environment and used 2012 SSIS latest features like project parameters for better integration.
• Worked with deployment, maintenance, usability and portability of SSIS Packages
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Environment: SQL server 2012/2008, Microsoft Visual Studio 2008/2012, SSAS, SSIS, SSRS, BI Express,Cozy Roc, Sales Force Cloud, Tableau, MS Office- 2013, MS Visio 2010.

Confidential, San Antonio, TX

Lead SQL SERVER /Teradata Developer

Responsibilities:

• Manage and Maintain the Application Reporting Database.
• Responsible for sending each months reports to its corresponding Manager using SSRS or advanced Excel.
• Design and Development of SSAS Cubes to sustain the Application Demands and Needs
• Implemented Many SSIS Packages and Jobs to assist with daily running queries.
• Created complex stored procedures and developed dynamic SQL Queries to adopt dynamic environment.
• Worked with Huge Databases in Teradata and SQL Environment.
• Successfully created Snapshots Report, Report Subscription, Data Driven Subscription and Report caching using Report Manager.
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Involved in dimensional modeling to design data warehouse.
• Developed Dimensions, Data Source Views, SSAS Cubes. Deployed and Processed SSAS Objects
• Created Partitions for faster response of Data in SSAS
• Tuning of SQL Queries for Performance improvements in Teradata and SQL.
• Hands on Experience with Teradata and working through huge data sets and overcoming the Spool Space Errors
• Periodic checking of databases with DBCC commands for maintaining data consistency and integrity.
• Coordinated with back-end programmers in writing stored procedures, implemented referential integrity by using triggers, performance and tuning.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Configured replication methods like snapshot, transactional and merge replications.
• Dealt with critical and serious production SQL Server issues in a timely manner.
• Responsible for Providing 24x7 fast paced DBA support for production, development and testing environment.
• Monitoring the Scheduled jobs and Disk spaces on all the servers.
• Mentor front end users about SQL Queries. And as a Team Lead responsible to update weekly progress to the management.

Environment: SQL Server 2008/2005, Teradata 13, SSRS, SSAS, SSIS, Microsoft Visual Studio 2008/2005, Relational DBMS, Client-Server Architecture, Clustering, MS Office- 2010.

Confidential, Austin, TX

Sr SQL SERVER Developer/DBA

Responsibilities:

• Involved in requirements gathering, analysis, design, deployment and user .
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects in Sql server 2008.
• Developed E-R diagrams (logical and physical using Erwin) mapping the data into database objects.
• Designed and developed various DB Objects like Stored Procedures, User defined functions, triggers and used Indexes for accomplishing various tasks.
• Created Views to facilitate easy viewing implementation and for security
• Used SQL Server Agent to automate the process of rebuilding indexes at regular interval for better performance.
• Used Pentaho Kettle as ETL Tool for Extracting data from different sources to production servers and from there to the OLAP Data ware house.
• Created Logins and Job roles.
• Responsible for Backup of databases.
• Built the SSAS Cubes and optimized them.
• Loaded Data Daily into SSAS cubes using Process Incremental and Caching of SSAS Cubes to have even more faster response
• Created packages using various Data transformations and tasks and scheduled jobs to perform filtering operations and to export the data (reports) on daily, monthly basis on to SFTP server using SSIS.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Worked with deployment, maintenance, usability and portability of SSIS Packages
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Used SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Worked on SSRS 2008 to generate more than 80+ reports for various user groups and developer groups.
• Developed Reports, Sub Reports, Drilldown reports, Data driven subscriptions, and used various features like Charts, graphs, filters etc.
• Created stored procedures and used as the datasets for the Report Design.
• Developed Linked reports in SSRS.

Environment: SQL Server 2008, MYSQL 5.2, SQL Server Management Studio (SSMS), Pentaho Kettle, SSRS, SSAS, Business Intelligence Studio (BIDS), Windows Server 2003.

Confidential, Schaumburg, Illinois

Lead SQL Server Developer/ DBA

Responsibilities:

• Development of a long-term automated data feed solution to prevent frequent data issues in the reporting system.
• Creating SQL Server Integration Services (SSIS) packages to load data from the feeds (.DAT files and CSV files) to SQL Server tables using features like ragged right.
• Dirty data handling, data cleansing and data transformations in the ETL process.
• Hierarchical restructure of data maintaining right parent-child relations before loading into dim tables.
• Creating complex stored procedures and T-SQL upload scripts for incremental load of the data (using ‘Merge’) into Dimension and Fact tables in the data warehouse.
• Data Migration from SQL 2005/ Oracle 10g/ Teradata to SQL Server 2008
• Creating synonyms for efficient handling of the code in Stored Procedures.
• Using complex joins and sub-queries in Teradata
• Unit testing, End to End Testing, Documentation of the automated data feed solution for the reports.
• Responsible For Database Backups and Performance.
• Requirement gathering from the business users of the reporting system.
• Producing Ad-hoc reports as per the business requirements.
• Creating SQL Server jobs for email notifications of the system level failures, long running jobs and job failures.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Creating User Defined Functions (UDFs) in the Data warehouse.
• Using complex joins and sub-queries in T-SQL.
• Periodic checking of databases with DBCC commands for maintaining data consistency and integrity.
• Creating SQL Server Reporting Services (SSRS) & Micro strategy reports on top of the Data warehouse.
• Worked with SQl BI tools like SSIS,SSAS,SSRS
• Managing SQL Server reporting databases in the Data warehouse.
• Responsible for loading the Data Faster and writing efficient queries.
• Created roles for the reports through report manager.
• Used SSRS to develop business perspective reports.
• Writing ETL packages to load data from OLTP databases to Data warehouse dimensional and fact tables.
• Designing table structures in the data warehouse based on the business logic.

Environment: MS SQL Server 2005/2008/R2, MS SQL Integration services 2008, Teradata 12, Oracle 10g, MS VISIO 2008.

Confidential, Addison, TX

Sr SQL Server Developer/SSIS Developer

Responsibilities:

• Created database objects such as tables, views, stored procedures, and indexes and modified them.
• Involved in Extract, Transform and Load (ETL) development using SQL Server 2005/2008 Integration Services (SSIS).
• Successfully designed and developed SSIS Packages to import and export data from Flat files, MS Excel, SQL Server 2005/2008.
• Created complex SSIS packages using proper control and data flow elements with error handling.
• Used different kinds of Transformations in SSIS as per the client’s Requirement.
• Have deployed packages on different servers by configuring it.
• Created packages in SSIS, for data conversion using various transformation tasks
• In charge of converting data using SQL Server 2005 using SSIS.
• Created SQL Server Reports based on the requirements using SSRS 2005.
• Worked with different methods of logging in SSIS.
• Developed SSIS packages to extract, transform and load into the Campaign database from OLTP using SQL Server 2005 Integration Services (SSIS).
• Optimized the Cubes so that the data Retrieval is fast and Quick
• Worked with MOLAP, ROLAP and HOLAP Cube designs.
• Designed various report layouts.
• Identified and defined the Datasets for the report generation.
• Identified the database tables for defining the queries for the reports.
• Designed various report layouts.
• Defined parameters for parameterized reports.
• Created roles for the reports through report manager.
• Used SSRS to develop business perspective reports.
• Provided index tuning as required for performance improvement of the Applications.
• Created new jobs and monitoring the daily scheduled jobs.
• Tuned the SQL scripts that are dependent on slow running applications.
• Designed and worked with cubes having star schema using SQL Server Analysis Services (SSAS).
• Worked in the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Environment: SQL Server 2008, SQL Server Management Studio, SQL Server Business Intelligence Studio, MS Access 2007, Visual Studio 2005.

Confidential, Houston, TX

SQL Developer/DBA

Responsibilities:

• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
• Responsible for Object oriented programming using C++
• Involved in gathering and analysis of user requirements.
• Create functional and technical specifications for projects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Data Migration from SQL 2005 to SQL Server 2008
• Responsible and for logical and physical design of database using Erwin Tool.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Bulk data migration using SSIS from flat files.
• Used Index Tuning Advisor for Database performance for proper indexes.
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005
• Implementing Load balancing Replication across the Databases.
• Performed Database Refresh tasks from production to Development and Staging Servers
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments.
• Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities.
• In charge of converting data using SQL Server 2005 using SSIS.
• Performance tuning and testing on stored procedures, indexes, and triggers.
• Performed daily back up of entire database and recovery.
• Designed and deployed various complex reports using MS Reporting Services.

Environment: SQL Server 2000, SQL Server 2005, Windows 2000 Server, DTS, SSIS, SSRS, Erwin, SQL Profiler, MS SQL Server Reporting Services.