SUMMARY

• Over 7 years of IT experience in Analysis, Database Design, Development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives.
• Experience in Development and Implementation of Client - Server Applications & Database systems using MSSQL 2005/2008/2008 R2/2012 for both OLTP (Batch Processing, Online Processing) & Business Intelligence (SSIS, SSAS, SSRS) applications.
• Extensive experience in T-SQL to write: stored procedures, triggers, user defined functions, tables, views, cursors, indexes and relational database models.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Experience in writing complex T-SQL queries using Inner Joins, Outer Joins and Cross Joins.
• Strong experience with ETL tool in Mapping, Transformations, Expressions, lookups and Aggregations.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Merge Join.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Created data sources, connection strings and defined the datasets for generating the report.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Drill-through, Parameterized reports, Linked reports, OLAP and Sub reports, and formatting them using both SSRS 2005/2008.
• Strong ability in defining query for generating Cascaded Reports, Custom Reports and creating stylish report layouts in SSRS 2008/2012.
• Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Experience in database performance tuning and query optimization, data integrity and statistics.
• Expertise with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Extensively worked on vNOC platform and Amazon Cloud services for SQL 2014.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Knowledge of Software Development Life Cycle (SDLC).
• Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Possess excellent oral / written communication, interpersonal skills, technical writing, presentations and a good team player.
• Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS

Data Bases: MS SQL Server 2005/2008/2012 , Oracle 9i/10g, MS access, Teradata.

Languages: C/C++, SQL, T-SQL, PL/SQL, HTML, XML

ETL Tools: SQL Server Integration Services (SSIS), SQL scripts, Data Junction

Operating Systems: Windows Server 2003/2008, Windows XP/Vista/7/8.

SQL Server Tools: SSIS, SSRS, SSMS, Enterprise Manager, Query Analyzer, Profiler, Export.

Business Intelligence Tools: Business Intelligence Development Studio (BIDS), SQL Server Analytical,Services (SSAS), DTS Packages, Server Reporting Services (SSRS)SQL Server Integration Services (SSIS), Cognos report studio.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams (Physical and Logical using Erwin) and mapped the data into database objects.
• Upgraded MS SQL Server 2008 database to MS SQL Server 2014, by using Detach/Attach, Back up & Recovery.
• Working on SSIS Packages to import and export data from Oracle, Teradata, MS Excel, SQL Server 2014 and Flat files.
• 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.
• Working on all the required Stored Procedures, user defined Functions, Triggers, and Views using T-SQL as per business logic.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Wrote complex T-SQL queries for data extraction, loading the Data in RDB Landing through SSIS Packages.
• Created SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created Merge procedure for delta load of the data from landing database to Staging area database.
• Used Merge in development, test and production for changing the referenced data.
• Deployed the scripts and migrated data to Production and Cloud server through Amazon Cloud services.
• Created ad-hoc, Drill Down and Drill through Reports and Generated custom and parameterized reports using SSRS.
• Automated the execution of SSRS Reports using Subscriptions and Data driven subscriptions.
• Performed the SQL Production objects deployment on Amazon production cloud services using AWS.
• Extensively worked on vNOC platform and Amazon Cloud services.
• Scheduling Jobs and Alerts using SQL server Agent and responsible for providing 24 X 7 dedicated production support.

Environment: SQL Server 2012/2014, SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services),Business Intelligent Studio, SQL Server Management Studio, ASP, vNoc, Amazon Web/cloud services, MS Excel, Windows, Teradata, oracle.

Confidential, Carlisle, PA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Understanding Customer requirement via interaction and writing functional specification.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Involved in designing and implementing database applications using MS SQL Server 2012 and Business Intelligence (BI) tools to support transactions and business decision-making.
• Developed complex T-SQL code for the application.
• Created Stored Procedures, Triggers, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Created various database objects such as tables, indexes and views based on the requirement.
• Implemented constraints on tables.
• Automation of creating Accounting code module for each account.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
• Used different Transformation in SSIS as per design specifications.
• Documentation of SQL objects using Red Gate’s SQL Source Control tool and Erwin.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Responsible for stylish design layout like Pie charts, Graphs and Linked Reports.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Created Report Subscription and Data Driven Subscription using SSRS.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Involved in creating Cubes using SQL Server Analysis Services (SSAS).
• Monitor and provide support to the application during the testing and production environments.

Environment: SQL Server 2012/2014, SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services),Business Intelligent Studio, SQL Server Management Studio, ASP, Enterprise Manager, MS Excel, Windows XP Professional.

Confidential, Richardson TX

SQL server Developer

Responsibilities:

• Worked on the data mapping and performed various data validations while migrating from oracle to Teradata.
• Experience in creating ETL packages to Validate, Extract, Transform and Load data into Data Warehouse and Data Mart.
• Upgraded MS SQL Server 2008 database to MS SQL Server 2012, by using Detach/Attach, Back up & Recovery.
• Worked on Manual and Automated SSIS Packages to load data in to the Data warehouse.
• Developed stored procedures, functions, views and triggers.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, before loading the data into the Data warehouse.
• Worked on migrating the oracle store procedures to Teradata using Teradata SQL assistant.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created indexes, constraints and rules on database objects.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Experienced in making technical specifications report by gathering information from end user.

Environment: SQL Server 2008SR2,2012, MS SQL BI Suite (SSIS, SSAS, SSRS), MS Visio2005/2008, SharePoint2010, XML, VB. NET, MS office 2007, MS Project, Windows Server 2003, Internet Information Server (IIS) 6.0/7.0, My SQL, MS-Access, ASP.NET, MS Visual Studio 2005/2008, DTS, T-SQL, SQL Profiler, Teradata, Power Builder, Management Studio, TOAD.

Confidential, Irving TX

SQL Server Developer

Responsibilities:

• Involved in Reporting, Analytics, Data Mining, Business Performance Management, Benchmarking and Predictive Analytics.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes (Data Warehousing).
• Developed all the required Stored Procedures, user defined Functions, Triggers, Views using T-SQL as per business logic.
• Used SQL Server 2000/2005 Reporting Services (SSRS) for generating reports as per business requirement.
• Created projected income statements and other financial reports. Developed yearly, quarterly, monthly sales reports, bench marking reports and commission reports.
• Worked on Ad-Hoc complex analyses and reporting to address business needs - Examples include Channel Profitability, Market Profitability and Door Profitability.
• Automated Database Maintenance tasks by creating Jobs, Alerts and Operators through SQL Server Agent.
• Developed and created Excel Macro charts like Pie, Column, Bar, Line graph as per Business requirement.
• Extract, transfer, load (ETL) data from SQL Server Database, Oracle and Access into Excel Spreadsheet.
• Worked extensively on MS Excel to generate Pivot Table Reports, Pivot-chart Reports, Filtering, Sorting, and Conditionally Formatting Data.
• Created numerous reports on the fly on a daily basis for business users, which reflect company and sales performance, based on various business rules.

Environment: SQL Server 2008R2, Oracle, Toad, SQL Server Management Studio, SSIS, SSAS, SSRS, Mirroring, Replication, WINDOWS 2003, ETL, Log Explorer, Visual Studio 2008, VISIO, ERWIN, Excel Macro, Data-Warehousing.

Confidential, Bellevue WA

MS SQL Developer

Responsibilities:

• Rebuilding the indexes at regular intervals for better performance.
• To analyze long running slow queries and tune them to optimize application and system performance.
• Worked on SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.Txt file, *.CSV files
• Created and managed schema objects such as tables, views, Indexes, procedures, triggers, while maintaining referential integrity.
• Used SQL Profiler for troubleshooting, monitoring, optimization of MS SQL Server and non-production database code.
• Created SSIS packages to import data from MS Access, Excel to MS SQL and generated reports using SSRS.
• Worked on teradata for extracting data from Teradata database using SSIS package and source connection as ODBC driver for Teradata.
• Involved in Test Script development, Verification, Testing, Data Extraction and Loading using DTS, Import and Export Utility.
• Created stored procedures for the business logic using T-SQL.
• Created job schedules to automate the routine tasks.
• Performed Database Normalization and performance tuning.
• Worked with SSIS for data integration and retrieving the data from various sources.
• Developed SQL Scripts for creation of various Database Objects (Stored Procedures, Indexes, Triggers, and User Defined Functions).
• Responsible for creating fact and dimension tables, build cubes using SSAS.

Environment: SQL Server 2008, BIDS 2008R2, Microsoft Visual C # 2008 Express Editions, Teradata, SharePoint 2010, Microsoft Visual SourceSafe, T-SQL, Windows XP/2003 Server

Confidential

Jr. SQL DBA/Developer

Responsibilities:

• Worked on escalations, troubleshooting complex SQL issues
• Implementing High availability solutions (setting up log shipping, Cluster installation)
• Performed Log shipping, cluster Failovers to maintain high availability
• Involved in root cause analysis for blocking and on-going SQL issues
• Suggesting backup strategy for clients and working on performance tuning issues on a need basis.
• Modification of existing stored procedures and development of new modules, tools related to enhanced support management.
• Organized trainings and transferring Knowledge to the team members.
• Participated in root cause analysis meetings with clients and post mortem analysis meetings conducted by clients.
• Performance tuning the DBA issues for SQL Server Instances.
• Auditing of Incidents and plan to automate recovery procedures.

Environment: SQL Server Enterprise 2005, Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard, Windows Server, Query Plan, Profiler.