SUMMARY:

• Around 9+ years of progressive experience inRetailer,Finance, and Media domains with expertise in MS SQL Server with Business Intelligence Development Studio (BIDS) 2005/2008/2012 in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Highly proficient in Data Extraction, Transformation and Loading (ETL) process to import, extract and transform data between databases and external data sources.
• Adapt in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task and SSIS data flow transformations like Aggregate, Derived Column, Data Conversion, Conditional Split, Multicast, Fuzzy Lookup, Union All, Merge Join, Lookup, Slowly Changing Dimension, and Pivot applying ETL concepts.
• Proficient in error handling and debugging in SSIS upon using break point and check point to provide error information during debugging process once failure execution occurred; experienced in configuration and deployment of SSIS packages to different server.
• Strong experience in generating different types of Reports like Ad - hoc reports, Dashboard reports, Linked reports, Sub-reports, Parameterized reports, Drill-down and Drill-through reports by using T-SQL, SSRS and Tableau.
• Effectively built queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS. Supported team in resolving SQL Reporting services and T-SQL related issues.
• Proficient in T-SQL Programming using DDL, DML, DCL commands for various business applications
• Extensive SQL Server Developer experience to develop tables, views, indexes, triggers, stored procedures, CTEs and joins
• Combined knowledge and experience in designing Data Mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Data Mining.
• Quantified knowledge of Data Mining model and Algorithm including Decision Trees, Association Rules Clustering and Naive Bayes.
• Experience in RDBMS Concepts, Database Management System, Database Physical and Logical design, Data Mapping,Table normalization, Data Modeling Creating ER diagrams using tools such as MS Visio Studio and Erwin.
• Profound understanding of entire Software Development Life Cycle (SDLC), and methodologies including Waterfall and Agile Development.
• Facilitated in creating Product Backlog, User Case, Data flow Diagram, UML Diagram and BNF for documentation.
• Excellent communication skills with a strong self-motivating, ability to multitask, and accomplish detailed business requirements, and functional specifications.

TECHNICAL SKILLS:

RDBM/DBMS: MS-SQL Server & 7.0, Oracle 10g, MS Access, MS Excel

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Visual Studio

Database Utilities: MS DTS, MS Enterprise Manager, DB2, SQL Profiler, SQL server Query Analyzer, Index Analyzer, DTS Backup Server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, SSRS.

Languages: Transact-SQL, PL/SQL, C/ C++, HTML, XML, Sybase, C, C++, PL/SQL, T/SQL, JAVA, Java Script, VB Script, Share Point

Reporting Tools: SSRS, Crystal Reports 10.0, ERWIN

Application Packages: MS Office, Microsoft Visio 2007

Testing Tools: Selenium, Unit test, Win Runner 7.6, QTP 8.2, SQA Robot, and Jira

Operating Systems: Windows XP/98/NT, Mac, UNIX, DOS

PROFESSIONAL EXPERIENCE:

SQL Developer (SSIS/SSRS/SSAS)

Confidential,San Francisco, CA

• Worked on SSIS/SSRS/SSAS 2014/2016 SQL Server Staging and Live.
• Worked on SQL database to create Cubes on SSAS from scratch.
• Worked on SQL queries using Left Joins Extract data for Stolen Vehicles.
• Created SSRS Reports by Designing, create parameters, creating Subscriptions.
• Optimized SQL queries for improved performance and availability.
• Ensured Data Recovery, Maintenance, Data Integrity and space requirements for physical Database.
• Designed ETL architecture with SQL Server SSIS mappings.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQLServer Integration Services (SSIS)
• Created SSIS packages to read and extract data from XML files, Understanding and Analyzing of Xml files to extract the necessary information.
• Worked on all activities related to the development, implementation and Support of ETL processes for large - scale Data Warehouse using SQL Server SSIS
• Understanding and Experience using C# Scripts to create a console application for loading data using windows task Scheduler.
• Writing T-SQLs for Testing and Reporting on the Data Quality of the Reports
• Involved in writing T-SQL queries, Stored Procedures and designing SSIS Packages and Review of T-SQLs, SQL Server Execution Plans and SSIS Optimizations
• Writing complex MDX and T-SQL queries, Stored Procedures for implementing the business logic in SSRS Reports
• Development of various SSAS Actions to publish the SSRS Reports.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Worked on SSIS Packages using SQL Scripts, Execute SQL task, Slowly Changing Dimension, derived Columns, XML task etc.
• Worked on SSIS Configuration Packages.
• Worked on Problem Solving on CUBES and SSAS projects.
• Created Documentation for Change Control after the Task is completed.
• Worked on existing SSIS Packages.
• Worked on SSIS Parameters.

Environment: Windows 7 Server, MS SQL Server 2005/2008/2012/2016, T-SQL, SSRS, SSAS, SSIS Packages, SSAS Cubes, JIRA Ticketing system, MS-Team Foundation Server, Visual Studio, SSMS, MDX Studio, ETL, ODBC, Excel, Share point, JIRA, c#. XML, MDX, OLAP, OLTP, Access, Tableau desktop (8 and8.1), Tableau server, Tableau reader, SAP power Designer

SQL Developer (SSIS/SSRS)

Confidential,San Francisco, CA

• Working on store procedures, indexes and tables.
• Working on 2012/2014 SSIS/SSRS for creating reports.
• Creating different type of reports including: A Sub report, Drill - down and Parameter prompts, Linked reports and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages. Used various Data Flow Transformations like Lookup, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• Scheduling jobs for SSIS Packages as per client requirement like daily, monthly etc.
• Working on QNXT Reports(SSRS)
• Working on QNXT transformation for existing SQL Store Procedures and SQL Queries.
• Working on QNXT Front End.
• Environment: SQL Server 2012/2014 SSRS, SSIS MDX, Visual basic, XML, MS Access, Excel, Share point, JIRA, GBD FACETS, RAMS, EXCEL, QNXT

MS SQL DEVELOPER (SSRS)

Confidential, Virginia Beach, VA

Responsibilities:

• Worked on synonyms, views, tables, stored procedures
• Worked on Optimization by using Common Expression Tables, Temp Tables, and Global Temp Tables.
• Worked on 2005/2008/2012 SSRS servers for creating and generating reports.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions by writing complex queries and joins.
• Worked on Subscriptions for Generating Reports to run.
• Designed and created reports in different formats such as Excel, PDF, HTML, and CSV using SQLServer 2005/2008/2012 Reporting servers (SSRS).
• Created different types of reports like tabular, matrix, ad-hoc, and drill down reports.
• Wrote queries for Matrix reports.
• Worked on Matrix reports for 2005/2008/2012 servers.
• Worked on converting the oracle coding to SQL coding.
• Load providers: New Add Provider, Networks Add, Address Add, Term Provider, Add Provider Group RAMS.
• Analyzing data for Providers data through FACETS.

Environment: SQL Server 2005/2008,2012 SSRS, MDX, Visual basic, XML, MS Access, Excel, Share point, JIRA, GBD FACETS, RAMS, EXCEL, FACETS

SQL Server (SSIS/SSRS) Developer

Confidential,Baltimore,MD

• Actively participate in gathering System Specification Requirements for the project
• Working on Writing scripts on different Projects like PCMH, Accounts Search Lighting
• Working on Designing the Reports Using SSRS
• Work on Microsoft SQL (2012 & 2008&2005)
• Created databases and database objects tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions in SQL Server 2012/2008
• Designed and created reports in different formats such as Excel, PDF, HTML, and CSV using SQLServer 2008/2012 Reporting servers (SSRS).
• Work on Data migrations, Environment refresh activities
• Wrote queries for Matrix reports.
• Work on Share Point to run the reports for Testing Purpose.
• Worked on Matrix reports for 2008/2012 servers
• Worked on converting the oracle coding to SQL coding using Facets Database.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2008 Reporting Services (SSRS) and Crystal reports
• Developed data model based on the BA's and the reporting Team using SSRS, SSIS
• Responsible for creating Tabular, Matrix and Drilldown Reports using SSRS
• Responsible for migrating DTS package to SSIS
• Monitor on share point and work on threshold issues.
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.
• Coordinate resources with work load and Client needs.
• Wrote the queries for the drill down reports, identifying and adding the report parameters and uploading reports on to the report manager and organized them in folders

SQL Server (SSIS/SSRS) Developer

Confidential,Baltimore,MD

• Installed and configured MS SQL Server 2012/2008 Enterprise Edition on Development server.
• Created databases and database objects tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions in SQL Server 2012/2008.
• Responsible for Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups and also used SQL Lite when necessary.
• Experience in migrating databases from SQL Server 2008 to SQL Server 2012.
• Developed data model based on the BA's and the reporting Team using SSRS.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Involved in writing stored procedures, functions and created the reports (SSRS).
• Responsible for creating Tabular, Matrix and Drilldown Reports using SSRS.
• Responsible for modification of Revenue reports, Finance reports, Commission reports, Broker pricing reports and other reports used by the business and the finance teams.
• Involved in transformation of data from one server to other servers using tools like bulk copy program (BCP), data transformation services (DTS/SSIS).
• Responsible for migrating DTS packages to SSIS.
• Created SSIS packages to download data from FTP sites and populating into different databases and tables.
• Communicated with Finance team, Business people, Third party vendors, Product Managers and gathered the information for the project requirements.

Environment: SQL Server 2012/2008, Transact-SQL, Visual Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Framework 2.0, C#, OLTP, OLAP, Erwin, Performance Point Server, Team Foundation Server, ASP.NET, VB.NET, ADO.NET, XML.

MS SQL DEVELOPER (SSRS) / (SSIS)

Confidential,Virginia Beach, VA

• Worked on synonyms, views, tables, stored procedures
• Worked on 2005/2008/2012 SSRS servers for creating and generating reports.
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions by writing complex queries and joins.
• Designed and created reports in different formats such as Excel, PDF, HTML, and CSV using SQLServer 2005/2008/2012 Reporting servers (SSRS).
• Created different types of reports like tabular, matrix, ad - hoc, and drill down reports.
• Worked on Tidal reports for time scheduling to run the reports monthly, quarterly.
• Wrote queries for Matrix reports.
• Worked on Matrix reports for 2005/2008/2012 servers.
• Worked on converting the oracle coding to SQL coding.

Environment: SQL Server 2005/2008,2012 SSIS, SSRS, Visual basic, Guide wire, XML, MS Access, Excel, Share point, Crystal Reports

MS SQL DEVELOPER (SSIS/SSRS)

Confidential,Philadelphia, PA

• Performed migration of data from different database like MS Access, MS Excel to SQL server.
• Involved in designing reviewing, and creating primary objects like Tables, Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Developed different SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel.
• Created different reports like tabular, matrix, ad - hoc, drill down and drill through reports using SSRS.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2008 Reporting Services (SSRS) and Crystal reports.
• Wrote the queries for the drill down reports, identifying and adding the report parameters and uploading reports on to the report manager and organized them in folders.

Environment: SQL Server 2005/2008, SSIS, SSRS, Erwin, .Net Frame Work, Visual basic, XML, MS Access, Excel, Share point, Crystal Reports.

MS SQL Server BI Developer/DBA

Confidential,North Brunswick,NJ

• Performed Migration of SQL Server 2005 to SQL Server 2008.
• Generated Logical and Physical Data Models using Erwin.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions by writing complex queries and joins.
• Migrated Stored Procedures from 2005 to SQL Server 2008 to refer to Dynamic Management Views.
• Created and Deployed of Ad - hoc and Customized Reports to satisfy business needs using SSRS.
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.
• Used SQLCMD utility in command prompt to access SQL Server.
• Deployed the SSIS Packages to the MSDB as well as File System depending on the requirements
• Maintained all the SQL documents include installation and data conversion Procedure documents.
• Monitored Indexes, file growths and analyzed blocking & locking issues to remove the performance bottlenecks

Environment: MS SQL Server 2005/2008, ER-WIN, windows 2003/2005 platform, T-SQL, Excel, Access, Crystal Reports 9.0 and Windows NT, DTS, SSIS, SSRS

MS SQL Server Developer

Confidential,Downers Grove, IL

• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
• Based on business requirement, developed the Complex SQL queries with Joins and T - SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Analyzed database performance with SQL Profiler and Optimized indexes to improve query performance.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Extracted the data from Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2005)
• Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2008.
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2008 database
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2005 Reporting Services (SSRS) and Crystal reports.

Environment: SQL Server 2005/2008, SSIS, SSRS, Erwin, .Net Frame Work, XML, MS Access, Excel, Share point (MOSS), ASP .Net, Crystal Reports, ER Studio, Performance point Server

MS SQL Server SSRS/SSIS Developer

Confidential,Galveston,TX

• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price - Range.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports.
• Identified and added the report parameters.
• Uploaded reports on to the report manager and organized them in folders.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Deployed the generated reports on to the server.
• Fine-tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005, MS Excel, Window XP

­