PROFESSIONAL SUMMARY:

• 8+ years of experience in Database Design, Development and maintenance of database applications on SQL Server in OLTP/OLAP/BI environment.
• Proficient in MS SQL Server and Business Intelligence using MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS).
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, and Excellent knowledge in RDBMS concepts and Data Warehouse Concepts.
• Extensive working experience in usage of SSIS Control Flow items.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Worked extensively in Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data and in creating Report Models for building Ad hoc reports using SSRS.
• Experienced in working with SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio/SQL Server Development Tools, scheduling jobs with SQL Server Agent, SQL Server Storage Structures, Index and Security Architecture and SQL Profile.
• Very Good Experience in BI Development (SSRS, SSIS, SSAS).
• Proficient in implementing all transformations available on the SSIS toolbox.
• Experience in enhancing and deploying SSIS Packages from development server to production server.
• Experience in providing Logging, Error handling by using Event Handler.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in data normalization and de - normalization.
• Great ability in creating Property Expressions, Script Tasks for ETL(SSIS) packages.
• Proficient in building Cubes, defining d Relationships and creating Hierarchies in SSAS.
• Expertise in creating Cell Level Security, Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Partly involved in administration tasks such as data loading, configuring IIS, data uploading, backup & recovery.
• Experience in Trouble Shooting, Performance tuning of reports and resolving issues with in Tableau Server and Reports.
• Created Tableau wireframes for various lines of business.
• Worked closely with the business and as Tableau SME for creating the dashboards that are desired by them.
• Flexible and versatile to adapt to any new environment and work on any project.
• Experience implementing high availability using Log shipping, and knowledge of DB mirroring. Experience in Database administration activities for DB security (creating logins, users, roles, and assigning permission to them).
• Well Versed in creating Dashboard Reports to support end users using SSAS. Strong inclination for finishing job before project deadline.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Self-motivated, enthusiastic and project oriented team player with ability for critical thinking, analysis, good interpersonal, communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

Operating System: Windows 7/8, Linux

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

Tools: Informatica, SSIS, SSRS, SSAS, Tableau Erwin, QNXT

Databases: MS Access, MS SQL Server Oracle8i/9i/10g, DB2

Tools: /Utility: Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning AdvisorAnalysis Manager, BCP, SQL Profiler, SQL SERVER BIDS, Visual Studio

Software: MS Office, Visio, MS-Project

PROFESSIONAL EXPERIENCE:

Confidential, West Chester, PA

Sr. SQL/BI Developer

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008/12
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008/12.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Created reports with Analysis Services Cube as the data source using SSRS.

Environment: MS SQL Server 2014, SSIS (SQL Server Integration service), SSRS

Confidential - Chicago, IL

Sr SQL/BI Developer

Responsibilities:

• Involved Automation of Back Office project and Migration of SQL.
• Involved in gathering business requirement from business users and prepared BI technical specifications.
• Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within SQL Server 2012 environment.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database
• Created Position and Transaction OLAP Cubes for mortgages Loans for various measure groups and dimensions (Loan Position, Commitment Schedule, Loan Journal Entry, Loan journal Entry Period Zero, Time Period, Loan, Account, Portfolio, Property, Business Unit, Borrower, Journal Entry Demographic, Journal Entry Line Item etc.) to address the business needs using SSAS
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Integrated SQL server reporting services with ASP.Net to view generated reports in Crystal reports.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Environment: MS SQL Server 2008R2, T- SQL, MS Excel 2010/2007/2003, Microsoft

Confidential - McLean, VA

Sr MS SQL BI Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect.
• Designed SSIS Packages to transfer data from various sources like Flat Files, XML, Excel and OLE DB.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Used Lookup transform to create the SSIS package for inserting the new entry from excel master source spreadsheet to the SQL Server table and update the old data.
• Responsible for the deployment of the reports on the reporting server and scheduled subscription for the windows file share.
• Developed different types of reports like Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Drill through reports.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Build packages and handled slowly changing dimensions (SCD) to maintain the historic data.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Created and Configured OLAP Cubes using SQL Server 2012 Analysis Services scaling to large numbers of users.
• Build the Dimensions, cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS) and created SSRS reports.
• Evaluate business performance with key performance indicators (KPI) using SQL Server Analysis Services.
• Provided cube solutions in Excel which allows slicing and dicing the data for analyzing and Analysis Services MDX Query to pool the data from cube.
• Used SQL Server profiler for auditing and analyzing the events, which occurred during a particular time frame.
• Involved in developing dashboards by using Power Map and deployed reports in Microsoft Office SharePoint.
• Developed analyzing complex reports by using power pivot in excel.

Environment: Microsoft SQL server (SSIS, SSAS, SSRS) 2012, T-SQL, Power pivot, Visual Studio 2010, PowerPoint, MS Access, T-SQL, MDX, Tableau 8.0.

Confidential - New York, NY

SQL BI Developer

Responsibilities:

• Developed dimension tables, added named column and implemented a hierarchy along with attribute relationship for the flexibility of the cube analysis.
• Created calculated members, Key Performance Indicators (KPI), Perspectives and designed Aggregations in SSAS.
• Generated cube reports by using multiple reporting tools including cascading parameter report, matrix report as well as also map report in SQL Server Reporting Services (SSRS).
• Created periodic report based on statistical analysis of data from various time frames and division using SQL Server Reporting Services (SSRS).
• Generated reports from shared or embedded data source by writing queries or using stored procedures in SQL Server Reporting Services (SSRS).
• Created complex tabular and matrix report with drilled-down, drilled-through and drop-down option, based on specific requirements of the end user.
• Involved with managing security of reports for different users by using Report Manager.
• Developed adhoc reports to users in Tableau by connecting various data sources.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated tableau dashboards with combination charts for sales with forecast and lines.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application.
• Developed ETL packages to load data warehouses from various sources and transformed it according to business requirement.
• Validated and monitored SSIS packages using SSIS Catalog 2012.
• Used SSIS to implement the slowly changing transformation, to maintain historical data in EDW.

Environment: MS SQL Server (SSAS, SSRS, SSIS) 2012/2008R2, SharePoint 2013/2010 Tableau 8.0, MS Visual Studio 2010/2008.

Confidential

MS SQL BI Developer

Responsibilities:

• Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Created and use multiple data sources and datasets within a single report.
• Converted and redesign Access, Excel, PDF and SSRS 2005 reports to SSRS 2008 reports.
• Supported production operation activities, with focus on integration and development of new and existing products and services.
• Authored very detailed reports focusing on specific report design formatting outputs such as report layout, margins, colors, font selection, border style, padding and chart selection.
• Communicate with analysts to understand different business needs, developing reports to improve reporting services performances.
• Created parameterized, cascaded, linked and sub-reports for different business requirement.
• Authored SSRS 2008 reports to meet advance presentation layout requirements such as matrix, gauges, and charts.
• Created dashboard reports using SSRS 2008 and embedded various images within complex tabular reports based on conditions written in expressions.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Generated different SSIS packages using transformations such as fuzzy lookup, derived column and slowly changing Dimensions (SCD) to perform different business requirements.
• Created reports with grouping in tables and collapsible reports. Analyzed and designed software and database solutions.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Worked on other packages of the SQL server 2005 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created data mapping between two distinct models.

Environment: MS SQL Server 2008/2005, SSMS, BIDS, SSIS, SSAS, SSRS, TSQL, ETL, XML, MS

Confidential

MS SQL Server Developer

Responsibilities:

• Responsible for the design of the SSIS package to load data into the data mart from OLTP database using ETL tools.
• Use Data Viewers in SSIS Packages to see whether the data flow properly or not.
• Provided Dynamic Configuration, Custom Package Logging, and Error Handling to SSIS template package.
• Created deployment utility to deploy SSIS Packages.
• Created various database objects including Tables, User Defined Functions, Procedures, Packages, Triggers, Indexes and Views based on user requirements.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Tuned SQL queries using Show Plans and Execution Plans for better performance.
• Provide fields mapping document, refreshed table/packages data load to UAT after delivery up on the completed data mart.
• Developed and maintained enterprise reporting (SSRS Reporting Service) based on specifications and business needs and modified existing reports as needed.
• Use temporary table to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Created complex stored procedures to generate reports using SSRS
• Designed Reports in SSRS, using Shared data source and specified data source.

Environment: MS SQL Server 2008, T- SQL, MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS),Microsoft SQL Server Reporting Services (SSRS), SQL Server Business Intelligence Development Studio, MS Visio 2007.