SUMMARY

• Over 7+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2005/2008/2008 R2/2012.
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Extensive experience in using Microsoft BI studio products like SSIS,SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Expertise in generating reports using SQL Server Reporting Services and MS Excel spreadsheets.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• With the ease of TFS, managed user permissions among team projects and also, further made it easy to identify any missing permissions
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, C, C++, C#, ASP (.NET).

Databases: MS SQL Server Denali,2014,2012,2008R2,2008,2005

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Informatica, Visual Studio, Cognos, Crystal Reports.

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques.

Packages: MS Office, Microsoft Office Suit

Tools: and Utilities: SQL Server Management Studio, Import & Export Wizard, Visual Studio .Net, Business Intelligence Development Studio (BIDS), Excel.

Operating Systems: Windows 7/XP/2003

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

SQL Developer / BI Developer

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views in SQL Server 2000, 2005, 2008.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created adhoc reports using Import and Export Wizard.
• Handled Tableau admin activities granting access, managing extracts and Installations Created backup scripts to take periodic backups for the content on Tableau server.
• Defined group level security standards for Tableau.
• Used MS SQL Server 2012 SSIS to create SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging and before loading the data. Pulled the data from multiple database sources such as UDB/DB2/TeraData/SysBase and flat file sources that includes CSV, Excel, Main Frame (SAS).
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Strong experience increatingandpublishingpackagesin Framework Manager.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS and Created Ad-Hoc Reports, Summary Reports, Sub Reports.
• Used SQL Server 2008R2/2012 Reporting Services (SSRS) for generating reports which resulted in efficient decision making. 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)
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Creating stored procedures/SQL queries and optimizing existing SQL queries. Moving reports to QA and Production environment
• Day to day report server administration Gather requirements across the departments also Documentation of requirements
• Involved in Development, QA and Production environments

Environment: SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, Tabular, Excel 2013, XL-Cubed, Power view, Power pivot, Performance Point, MDX, Report Builder 3.0, DTS,C#, Windows Server 2008

Confidential, Charlotte, North Carolina

SQL/MSBI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, and written functions, stored procedures and triggers.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files and Excel etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Variables, Expressions and Functions for the reports.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Performance Tuning of multiple databases by fixing indexes, usage of temp tables, redesigning schemas and many more.
• DDL Scripts for generating Tables, Views, Functions.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: Environment: MS SQL Server SSIS, SSRS, Windows Server, Oracle, MS Access 2007, System Monitor/Performance Monitors, MS Office.

Confidential, Dallas, TX

MS SQL / BI Developer

Responsibilities:

• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts. Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Worked on Filtered Views, views and Base table integration between different Source systems.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Interacted with vendors, developers and customers to manage the business requirements.
• Verified business requirements and functional specifications.

Environment: Windows2007, ODBC, MS SQL Server 2005/2008/2012, TSQL, PL/SQL 11g, Visual Studio 2008, SSRS, SSIS.

Confidential

MS SQL/BI Developer

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Interacted with vendors, developers and customers to manage the business requirements.
• Verified business requirements and functional specifications.

Environment: SQL Server 2005/2008 R2, SSIS, SSRS, ODBC, BIDS, Visual Basic Excel, windows 2007

Confidential 

SQL Server Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating the regular Jobs.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Worked on Documentation using MS word

Environment: MS SSAS 2005, MS SSRS 2005, MS SSIS 2005, T-SQL, VB Script, Windows Server 2003.