PROFESSIONAL SUMMARY:

• 9 years of overall experience with majority experience in multiple tools of the MSBI suite of products (SSIS/SSRS/SSAS).
• Extensively worked with clients to understand business requirements, recommended technical solutions and documented functional requirements.
• Hands on experience in installing, managing, configuring, upgrading, migrating, monitoring and troubleshooting SQL Server 2014/2012/2008R2/2008/2005.
• Expertise in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Requirements gathering, analysis and design of ETL process using SSIS and SSRS.
• Experience in maintaining SSIS by creating Jobs, Alerts, SQL manager Agent, and scheduling SSIS Packages.
• Extracted and migrated data from heterogeneous data sources such as MS Excel, Oracle, MS Access, flat file to MS SQL Server by using import/export wizard as well as third party connectors and creating ETL packages in SSIS.
• Experience in developing, monitoring, extracting and transforming data using SSIS, Import Export Wizard.
• Experience in creating SSIS package to load data from Flat Files to SQL Server using various types of transformations like Lookup, Fuzzy Lookup, Multicast, Derived Columns, Condition Split, Term Extraction, Aggregate, for transferred data modifications and dataflow tasks, script tasks, for loop container, for each loop, sequence container and Slowly Changing Dimension.
• Created data - driven subscriptions for reports linked reports, and ad-hoc reports using Report Builder in SSRS.
• Generated drill down reports, parameterized reports, linked reports, sub reports in SSRS 2012/2010/2008/2005.
• Worked onPowerBIDesktop tools to build and customize, visualization on new or existing reports
• Involved in writing / modifying new/existing T-SQL andMDXqueries as part of bug fixing in the existing ETL/Reports or to build any ad hoc reports.
• Created dashboards, scorecards and building reports using Performance point server 2007.
• Rewritten Impromptu reports toPowerBI, SSRS and OBIEE reports.
• Worked onTeradatainsert, Update, modify and DynamicSQLto transform and load Summary tables built on Core Data Warehouse.
• Designing Reports using Tableau on a small data warehouse environment.
• Data Warehousing, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Data Vault Modeling, FACT and Dimensions Tables.
• Created different types of reports such as Conditional, Drill-down, Summary and Sub reports, and formatted them and Performed unit testing at various levels.
• Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model using Report Builder.
• Rendered reports in CSV, PDF, XML and delivered reports by file share and E-mail according to schedule.
• Extensive experience in Designing and Developing data warehouse and its component tools for data storage.
• Exposure to T-SQL Programming and Architecture, and translated complex legacy process with T-SQL Procedure, Functions and Package.
• Experience in designing Database Models using MS Visio and ER-Win
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS

Databases: MS-SQL Server 2014/2012/2008R2/2008/2005.

Languages: T-SQL, HTML, DHTML, XML, C, C++, Java Script, C#, VB.Net.

ETL Tools: SQL Server Integration Services (SSIS), DTS.

Data Modeling Tools: Erwin,visio

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports, Power BI.

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

Operating System: Windows 10/8.1/8/7/vista/XP/2003.

PROFESSIONAL EXPERIENCE:

Confidential,

MSBI Developer

Responsibilities:

• Gathered business requirements from business and clients to develop various reports.
• Migrated data from Heterogeneous data sources (Excel, Flat File and CSV file) to centralized SQL server database using SQL server integration services (SSIS).
• Used SSIS jobs for implementing ETL and importing data from the flat files that brings the data to the application tables.
• Used various SSIS control flow tasks such as Execute SQL task, File system task, for each loop, and sequence containers, send-mail task.
• Worked on OLAPDatawarehouse, Model, Design, and Implementation.
• Developed reports using SSRS 2008 and crystal reports, used table control, matrix control for cross tab reports.
• Responsible for creating SQL datasets forPowerBI.
• Deployed the SSIS packages to different environments using XML & SQL Server configurations.
• Designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Expert on creating multiple kind ofPowerBIReports and Dashboards.
• Created Tablix, Drill down and drill through reports, multi value parameter reports.
• Created reports using SQL Reporting Services (SSRS) for Customized and Ad-hoc Queries.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Extensively worked on Design and development ofSSIS(ETL) packages to extract, transform and loaddatafrom different Sources like Excel files, flat files to theDatawarehouseusing different tasks and transformations like File System Task,DataFlow Task, Derived Columns, and Execute SQL Task
• Created Parameterized reports and Linked reports with through knowledge of report serving architecture.
• Implemented the Error handling in the Stored Procedures and also Modified existing stored procedures according to the requirement.
• Extended data to XML and Excel spread sheet.
• Experience with full development cycle of aDataWarehouse, including requirements gathering, design, implementation, and maintenance.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Triggers, Stored Procedures.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2012, SSIS, SSRS, SSAS, T-SQL, Erwin, TFS, Windows server 2012, Crystal Reports, Power BI, Visual Studio 2010, MS Excel and .Net.

Confidential, charlotte,

Sr SQL Server BI Developer

• Developing SQL database and BI solutions using T-SQL, SSIS, SSRS, SSAS, MDX, query performance tunings, database development, implementation, support of data, and underlying data models.
• Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Design and development ofDWHto accommodate upcoming update or incremental data sets.
• Developed SQL scripts to Insert/Update and Delete data in MS-SQL database.
• Used Exceptional Handling and log in SSIS to handle errors and track the package execution.
• Configure SSIS Package for run time Parameters and Config file.
• Intensively involved in Prod Support.
• Scheduled the SQL jobs and SSIS Packages using Job Controller (Enterprise Scheduler).
• Wrote SQL queries ondatastaging tables anddatawarehousetables to validate thedataresults.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs.
• Knowledge on writingSQLqueries andSASscripts for extracting data from PostgreSQL Database, manipulating and summarizing the data as per the business requirement.
• Extensively worked on Performance Tuning ofTeradataSQLusing explains plan and understanding Joins and Data distribution.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scaleDataWarehouses using SQL ServerSSIS
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created Cross-Tab, Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
• Imported the data from flat files and were transformed and placed in DB2,TeradataDatabases as they were the target databases.
• Extract data from SharePoint document library and load intoAzureSQL server.
• Understood underlying Data and reworked Data Analysis withPowerBI.
• Used Try Catch Finally exception handling extensively to avoid circumstances leading to abnormal program termination.
• Experience with writing Multidimensional Expressions (MDX) queries.
• Created reports inPowerBIpreview portal utilizing the SSAS Tabular via Analysis
• Maintained error logs for the Stored Procedures.
• Used Team Foundation Server and Visual Source Safe as a version control tool.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2014/2012/2008, Visual Studio 2010/2012, TFS, VSS, Reporting Services (SSRS), Power BI, Integration Services (SSIS),Azure, T-SQL, .Net, Excel.

Confidential, Virginia

SQL Server BI Developer

Responsibilities:

• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Gathered the functional requirements from the client.
• Designed SSIS packages to Extract Data from different sources like Flat Files, Excel Files, SQL Server and Transform them and then load into Dimension and Fact tables in Data Warehouse using SSIS.
• Developed SSIS packages using For Each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQLtable.
• Used various SSIS tasks such as Conditional Split, Derived Column, Lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes using dimensional modeling standards in SQL server.
• DevelopedPowerPivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Wrote queries for Drill down reports to get the dataset required to build the report.
• Identified and included report parameters for parameterized report.
• Simultaneously maintained the existing ETL and recreated new SSIS packages and also created test cases for testing the SSIS packages.
• Wrote complex SQL queries and stored procedure to create reports using SSRS from the relational database.
• Used MicrosoftPowerBIPowerQuery to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
• Good understanding inDataMarts anddatawarehousing concepts (OLTP & OLAP).
• Created SSRS Data Model projects using Microsoft Visual Studio and using Report Builder for report server to create reports.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Developed and maintained system documentation, diagrams and flowcharts.

Environment: SQLServer2008R2, SSIS, SSRS, SSAS, T-SQL, MS Office (Word, Power point, Excel), Microsoft Visual Studio 2008,Power BI,TFS, ERWIN, SharePoint.

Confidential -

SQL Server Developer/SSRS/SSIS.

Responsibilities:

• Developed database objects such as SSIS Packages, Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving.
• Multipletables & calculations from different databases.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Monitored the SQL profiler and tuned queries and procedures to boost database performance.
• UsedSSISto create ETL packages to validate, extract, transform and loaddatatodatawarehouse databases, DataMart databases.
• UsedPowerBI,PowerPivot to develop data analysis prototype, and usedPowerView andPower Map to visualize reports.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Used variousSSIStasks such as Conditional Split, Script Component Task, Derived Column, lookup which wereused forDataScrubbing,datavalidation checks during Staging, before loading thedatainto theData Warehouse.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Used Bulking techniques, Table partitioning to increase database performance.
• Consistently worked and communicated with CMS (Center for Medicare & Medicaid) to ensure data received met the company expectations.
• Wrote complex expressions and calculations for SSRS reports with Conditional Formatting.
• Responsible for the design and deployment of the report using SSRS and MS Excel.
• Created Ad Hoc reports by building models in Report Builder using SQL 2008 Model Designer and Report Builder.

Environment: SQL Server 2008,Oracle 10g,T-SQL,BIDS,SSRS,SSIS, SSAS, Crystal Reports,Power BI, MS Excel, Erwin, SharePoint

Confidential, Cleveland, OH

MS SQL BI Developer

Responsibilities:

• Provide 24x7 supports and streamline EOD (End of Day) Production process to ensure high availability and accuracy of data to end users and managers.
• Successfully replaced third party reporting application ‘eGlue’ with SQL Server, SSIS, SSRS and Excel.
• Responsible for Installation, configuration, maintenance, security, availability, backup/restore and upgrading of Microsoft SQL Server and related products.
• Reviewing and re-writing/re-building TSQL codes, SSIS packages and SSRS reports for performance improvement and logging in SQL Server 2012.
• Wrote PowerShell scripts to automate Excel Macros and generate various reports.
• Responsible for all functions associated with the design, implementation and maintenance of SQL Server databases including security, back up, logging, reporting and recovery procedures.
• Proactively monitor and profile production database servers for load and performance bottlenecks and provide solutions for query optimization and performance tuning.
• Update statistics, database integrity check and Backup operations.
• Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
• Designed and implemented Disaster Recovery Plan for Production and source servers.
• Implemented highly advanced Error Handling techniques in all production SSIS packages.

Environment: SQL Server 2005/2008/2008 R2,2012, SSIS, SSRS, Idera 8.0, Lite Speed 6.1, C# .Net, Putty, Power Shell 2.0, Excel Macro, Windows Server 2003/2008, Toad for SQL Server 5.6

Confidential

MS SQL BI Developer.

Responsibilities:

• Involved in designing and writing Stored Procedures, Triggers, Cursors, functions and maintained referential integrity and implemented complex business logic using T-SQL for SQL Server 2000.
• Creating new Database with objects such as tables, views, indexes, triggers etc.
• Complex queries and stored procedures to get the updates data from other servers.
• Creating and Modifying T-SQLstored procedures/triggers for validating the integrity of the data.
• Performing query plans and making sure every query is using appropriate useful indexes.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Backup and restore databases.
• Used MicrosoftSQLserver 2005 Integration Services to extract data from Flat file, to transform data using data conversion transformation, aggregate transformation and to load the result into fact table dimension.
• Designed and created packages using Business Intelligence Design Studio, organized them in Solutions and Project.
• Analyzed the existing data mart inSQL2000, planned and performed the migration fromSQLserver 2000 toSQLServer 2005 following the Normalization standards to maintain data consistency.
• Created logging for the package to record the inserted rows, error rows, and updated rows in the data pipeline.
• Worked with report parameters and performed multi valued Parameterized and cascading parameterized reports using SSRS in Visual Studio.
• Created Ad hoc reports, Drill down and Drill through reports, sub reports using SSRS.
• Experience in securing the reports.

Environment:SQLServer 2005/2000, Microsoft Business Intelligence Development Studio, T-SQL, SSIS, SSRS, Windows Server 2003