SUMMARY

• Over 7 years of IT industry experience with Microsoft SQL Server 2000/2005/2008/ 2012, SSIS/SSRS/SSAS in OLTP and OLAP (Data warehousing) environments.
• Extensive experience in Design, Development, Implementation of Database systems using MSSQL 2000/2005/2008/2012 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS,SSIS, SSAS).
• Expertise in testing Stored Procedures, Triggers, Reports and Packages and writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results.
• Experience in writing complex T - SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Experienced in creating Tables, Views, Indexes and query writing.
• Created Reports with complex formulas and to query the database for Business Intelligence.
• Experience in migrating data from external system including flat files, excel, MS Access and Oracle into SQL Server using SSIS/DTS packages.
• Hands on experience in installing, configuring, managing, upgrading and monitoring and troubleshooting SQL Server 2008/2012.
• Experience in developing User reports and management reports using MS SQL Server Reporting Services (SSRS).
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Involved in Designing Developing and Testing of the ETL strategy to populate the data from various source systems.
• Experience in building Data Integration and Extract, Transform, and Load (ETL) solutions between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML) for data warehousing using SQL Server Integration Service (SSIS).
• Expertise in designing Data Flow task and Work Flow task on SSIS.
• Experience in Dimensional Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Expertise in migrating data from MS-Access, MS-Excel and other external data sources.
• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.
• Analytical thinker that consistently resolves ongoing issues or defects, often called upon to consult on problems that have eluded resolution by others.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008/2005/2000, 7.0, Oracle 10g/9i/8i/7.x, MS Access.

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, Database Tuning Advisor, SQL Profiler, Enterprise Manager, Query Analyzer.

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS)

Reporting Tools: SQL Server Reporting Services 2012/2008/2005/2000 (SSRS)

OLAP Tools: SQL Server Analysis Services 2012/2008/2005/2000

Programming Languages: SQL, T-SQL, PL/SQL, C, C++,C# .Net, Asp .Net

Data Modeling: MS Visio

Operating Systems: UNIX, Windows (NT/2000/XP/Vista/7/8), Windows Server (2003/2005/2008/2012 )

Packages: Microsoft Office

Web Development Tool: HTML, XML, JavaScript, CSS, PHP, Python

PROFESSIONAL EXPERIENCE

Confidential, Sunrise, FL

SQL/BI Developer

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Created SQL joins, Sub queries, tracing and Performance Tuning for better running of queries.
• Designed different type of reports including: Tabular, Matrix (cross Tab report), List items, Charts and Linked reports.
• Created and designed reports based on query parameters and Report parameters.
• Created nested Grouping, sorting columns and writing expressions according to the business requirements.
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions to migrate data from staging to production environment
• Modified existing stored procedures, functions using joins following SQL Standards to enhance the performance of the reports.
• Experience with Indexing, normalization and query optimization.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse Worked on SSIS script task, look up transformations and data flow tasks using T- SQL.
• Generated Custom ETL scripts using SSIS, develops and unit test SSIS load processes for performance check.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.

Environment: SQL Server 2012 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), OLAP, OLTP, Performance Point Server, ETL, Enterprise manager, Windows Server 2012 R2.

Confidential, San Diego, CA

SQL/ BI Developer

Responsibilities:

• Develop ETL Packages and Reports.
• Create tables, stored procedures when required.
• Served as the primary point of contact for most of the Enterprise Business intelligence design and development.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL Server 2008 and 2012 Integration services.
• Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Extensively worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis, file-transfers from one location to other.
• Hands on experience in using different transformations like data Conversions, lookups, Derived column transformations etc. for data cleansing to remove unnecessary columns, eliminate redundant, inconsistent data and unnecessary Data like removing empty rows using SSIS.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Modified different packages where the issues (like removing the duplicate records or just updating a record and disable the previous records that had different IDs for one person) rose after the user interference.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Create databases, tables, and fields for data entry, performing database capacity planning.
• Enhancing and deploying the SSIS packages from development server to production server and scheduled jobs. Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Developed Stepped and Block reports using SSRS.

Environment: s: SQL Server 2008/2012, MS Access, EXCEL, VBScript, HTML, XML, Visio, Windows Server 2005/2008, ASP.NET, BIDS 2005/2008, Visual Studio 2005/2008/2012.

Confidential, Iowa

SQL BI Developer

Responsibilities:

• Gathered requirement and designed technical document to implement the application.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Created functions and developed procedures to implement application functionality at the database side for performance improvement, involved in Performance tuning of Queries, Indexes and Stored Procedures using SQL Profiler.
• Experience in designing Database Models for creating tables, indexes, optimizing views using MS Visio.
• High Level Design of ETL SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Flat file, Text Format Data).
• Involved in ETL framework standards like error processing, reconciliation, and validation.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Business Intelligence reporting using Excel with PowerPivot.
• Worked on Excel 2010, PowerPivot for providing ad-hoc reporting for the clients.
• Designed and developed SSIS Packages to extract data from various data sources such as MS Access database, Excel spreadsheet, and flat files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Migrated SSIS Packages from SQL Server 2008 to SQL Server 2012.
• VB Script has been written for scripting the task in SSIS packages.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Created partitions and designed various storage modes to increase the performance of cubes using SSAS.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services.

Environment: MS SQL Server 2012/2008, Windows server 2005/2008, SSMS, SSAS, SSIS, Business Intelligence Development Studio(BIDS) 2008, Visio, SQL Profiler, Team Foundation Server, Excel PowerPivot, MS-Visual Studio, XML.

Confidential, Los Angeles, CA

SQL Server / BI Developer

Responsibilities:

• Worked with business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Handling reporting team and resolving their issues.
• Created reports using SSRS for revenue, Sales and demand.
• Generated Sub-Reports, Drill down reports and Parameterized reports using SSRS
• Created Data Driven subscriptions.
• Worked on ETL to integrate and analyze data from multiple Sources
• Created Deployment utility to deploy SSIS packages.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Responsible for the Performance tuning of the Complex SQL Queries with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.
• Performing restore/backup of Data Warehouse.
• Version management using SVN.
• Responsible for Testing and Debugging the Stored Procedure, SQL Scripts, SSIS package and Reports.
• Created OLAP Cube for the Sale people
• Worked in on site/ off shore environment; coordinated my activities by proactively communicating with my counterparts in the off shore team and working closely with my manager.
• Experience working in Agile environment and supported iterative testing methodology.

Environment: MS SQL Server 2008,SSRS 2008 R2, MS SQL Profiler, C#, .Net, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2010, MS Office 2010

Confidential, VA

SQL Server / BI Developer

Responsibilities:

• Experience in working with SSIS for Data integration services. Expert in extracting and transforming data using SSIS Import/Export, SSIS Import Export Data, SSIS Packages, Bulk Insert and BCP.
• Highly capable in developing and monitoring SSIS and SSIS packages for using it in regularly scheduled jobs to extract, modify, or transform data for a variety of purposes.
• Experienced in developing User reports and management reports using SQL Server Reporting Services (SSRS).
• Efficient in creating reports with complex formulas and to query the database for Business Intelligence.
• Transformed data from various data sources using OLE DB / MS AS connection by creating various SSIS packages
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Demonstrated ability to write testable SSIS maps in the SQL Server 2008 environment or greater.
• Ability to communicate fluently with stakeholders when asked to present the completed work.
• Demonstrated experience with organizing techniques when dealing with a large library of SSIS scripts.
• Collaborated with test teams who ran the SSIS maps during test and validation phases of a project.
• Expert in developing ETL packages with different data sources (Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SSIS transformation for Data cleansing to remove unnecessary columns, eliminated redundant and inconsistence data.
• Designed SSIS packages using control flow task, Data Flow Task, For Each Loop container, Execute SQL Task. Also, actively involved in deploying and scheduling packages
• Extensively participated in database design and creating E-R diagrams for participant and client databases.
• Involved in writing the stored procedures, checking the code for efficiency using T-SQL.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Generated and deployed interactive and non-interactive complicated reports from various database and cubes. Built the mockup reports using SSRS and Excel for prototype.
• Used Integration services for the purpose of Transforming data from the cubes and storing it in to SQL SERVER tables.
• Tested the performance of Stored Procedures and execution plan by using SQL Profiler.
• Worked on Recovering the Backups of SQL Server production databases in test servers as part of regular maintenance activities.

Environment: SQL Server 2005, Windows server 2003, SQL Server Configuration Manager, T-SQL, SSIS, SQL Server Reporting Services (SSRS), .Net Framework 3.0/3.5, SQL Profiler.

Confidential

Junior SQL developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Developed Database Triggers to enforce Data integrity and Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Defined relationship between tables and enforced referential integrity.
• Involved in Implementation of Database design and Administration of SQL based database.
• Established connectivity to database and monitored systems performances.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

Environment: SQL Server 2000, Windows server 2003, Enterprise Manager, SQL Profiler, SQL Query Analyzer, DTS, T-SQL.