SUMMARY

• Over 8 years of IT experience in analysis, design, development, testing, implementation of applications, reports and databases (MS SQL Servers 2014/2012/2008/2008 R2/2005/2000) in production environments.
• Extensive experience in Systems Development Life Cycle (SDLC) from Design, Development and Implementation.
• Extensive experience in TSQL Development which includes creating Complex Business Stored Procedures, Tables, Views, Indexes, Triggers and User Defined Functions.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in using Microsoft Visual Studio.
• Extensive experience in developing and implementing Microsoft SQL Server integration services (SSIS); Microsoft SQL Server Analysis services (SSAS), Microsoft SQL Server Reporting Services (SSRS) and MDX for data warehouse and data mart solutions.
• Hands on experience with performing various SSIS data transformation tasks like Look - ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in creating packages to extract data from Excel, Flat file, Oracle, DB2, Sybase to MS SQL Server by using MS SQL Server DTS and SSIS.
• Experience in data Migration (using tools like DTS) between different heterogeneous systems and SQL Server as part of data migration and data maintenance.
• Experience in Jobs, Sending Alerts using SQL Mail.
• Experience in creating simple and parameterized SQL Reports using SQL Server Reporting Services (SSRS).
• Experience in SSRS with Report authoring, Report management, Report Delivery and Report Security.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience In creating Crystal Reports.
• Good knowledge in SQL Server Analysis services, OLAP, OLTP Design & Implementation.
• Experience in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Familiar with OLAP cubes and fact table, star and snowflake schemas.
• Experience in designing Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models and Data Mart.
• Extensive Knowledge in MS SQL Server configuration manager, client/server connectivity, query optimization, back-up/recovery.
• Experience with .NET in interacting with Business users and the development team.
• Extremely diligent, strong team player with an ability to take new roles.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and interpersonal communication skills.

TECHNICAL SKILLS

BI Tools: SSIS, SSAS, SSRS, PowerBI:

Programming: T-SQL, SQL, PL/SQL:

RDBMS: MS-Access, MS SQL Server 2000/2005/2008/2012 , MS-Access:

Operating Systems: Microsoft Windows 98/2000/2003 Server/XP/7/8/2008 Server/2012 Server:

Analytical Tools: SAS, MS-Excel (VBA), Tableau:

Web Technologies: HTML, DHTML, XML, XSL:

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS):

Other Tools: MS Office Suite (Word, Power Point, Visio), OLAP, OLTP, ERwin, Photoshop, Abode Flash:

Reporting Tools: SQL Server Reporting Services (2012/2008/2005/2000 ), Microsoft Access 2013, Excel:

PROFESSIONAL EXPERIENCE

Confidential, Lancaster, South Carolina

BI/SSIS/SSRS Developer

Responsibilities:

• Involved in installation and configuration of MS SQL Server 2008/2012.
• Involved in the designing, development, modification and enhancing the database structures and database objects.
• Involved in planning and designing data based on business requirement and provided documentation for further reference.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Moving/Coping data from APPX environment to SQL environments and Preparing windows batch scripts.
• APPX activities on various Servers TMG, STG, PROD, Wave 1,2,3,4,5,6,7 environments.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.
• Improved data load performance by analyzing database design and query plans.
• Modified and Created Joins to Improve the Database and execution speed.
• Involved in Performance Tuning using SQL Server Profiler and SQL server Hints.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2012.
• 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 SSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Maintain all the SQL documents including installation and data conversion procedures.
• Understanding the functional specifications. Estimating the effort Involved in fulfilling the requirements and preparing the analysis document.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Developed Sub Reports, Matrix Reports and Charts using SQL Server Reporting Services (SSRS).
• Worked on the performance of reports, created appropriate indexes on tables and modified the code in existingstored procedures to get the quick response on SharePoint site.

Environment: SQL Server 2012, APPX, SSRS, SSAS, ERWIN, Crystal Reports, SSIS 2012, Visual Studio 2014,c# 4.0.

Confidential, New Jersey, NJ

BI/SSIS/SSRS Developer

Responsibilities:

• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications. Provided knowledge transfer to the company’s SQL programmers.
• Created several materialized views and UDF’s to be accessed by the new front end applications.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: SQL server 2008/2005. BIDS 2005, Reporting services 2005, Integration Services 2005, Analysis Services 2005, Windows Server 2003, HealthCare database, DB2, Share point server.

Confidential, Minneapolis, MN

MSBI Developer

Responsibilities:

• Understanding the Reporting design requirements from the Architects and Business Analyst.
• Interact with SME’s and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008/2005.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Served as technical expert guiding choices to implement analytical and reporting solutions for complex financial scenarios.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Responsible for processing CUBE Partitions and Dimensions.
• Involved in writing MDX queries for various calculated members.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.
• Helped Quality Assurance Team to generate Test Plans and Test Executions.

Environment: Windows 2003 Server, SQL 2008/2005 Enterprise Edition, Import-Export (DTS), SSRS, SSAS, SSIS, OLAP, OLTP, MDX, T-SQL, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL 2007.

Confidential

SQL Server Developer

Responsibilities:

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i.
• Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007.
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters.
• Created sub reports, bar charts and matrix reports.

Environment: SQL Server (2003, 64 bit edition of SQL server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS, ERWIN.

Confidential

SQL Server Developer

Responsibilities:

• Study and understand the requirements of the information required by company’s Procurement Department about the vendors.
• Designed T-SQL scripts to identify long running queries and blocking sessions
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
• Data migration (import & export - BCP) from Text to SQL Server
• Error handling using Try-Catch Block
• Normalization and De-Normalization of tables
• Developed Backup and Restore scripts for SQL Server 2005
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions
• Written T-SQL queries for the retrieval of the data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Enterprise manager, MS Office & Windows 2K platform.