SUMMARY

• Over 7 years of experience in Microsoft BI Tools (SSIS/SSRS) & T - SQL using SQL Server 2005/2008/2012/2014/2016.
• Highly proficient in the use of T-SQL for developing database objects like complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins, Sub queries, correlated sub-queries and query writing.
• Involved in Database Design, Data modeling, Development, Implementation, ETL & Reporting in SQL Server 2005/2008/2012/2014.
• Experienced in installing, configuring, managing, monitoring, & troubleshooting SQL Server 2005/2008/2012/2014/2016
• Extensive experience in Software development life cycle (SDLC) using agile development approach and Waterfall development approach.
• Excellent noledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, user-defined functions (UDFs), Common table expressions (CTEs), Cursors, relational database models, data dictionaries, and maintaining data integrity and indexes using T-SQL.
• Experience wif 2016/2014/2012/2008concepts like In Memory, data partitioning, online indexing, DDL triggers, DMV, DMF, Policy based Management, Query Store, Extended Events, Stretch Database, Snapshot Isolation, Always Encrypted and Row Level Security.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for tuning and monitoring SQL Server performance.
• Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Experience in Data Modeling (logical modeling and physical modeling) using Erwin.
• Good noledge of Data Marts, Data warehousing, OLAP, OLTP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Hands on Experience in Data Modelling Tools (Microsoft Visio, QUEST).
• Proficient Knowledge in dealing wif RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Hands on experience wif migrating of DTS packages to SSIS from lower version (2005) to higher version (2005/2008/2012/2014/2016) and troubleshooting migrating issues.
• Hands on experience working wif Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Worked on data extraction, data integration and loading from different data sources using SQL Server Integration Services (SSIS)
• Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, Cleaning bad data, Validation of data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
• Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008/2012/2014
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating several types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Experience in performance tuning, processing and deploying the cubes.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Involved in building the dimensions, cubes wif star schema and snow flake schema using SSAS.
• Worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema and Entity relationship diagrams from business requirements.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.

TECHNICAL SKILLS

RDMS/Databases: MS SQL Server 7.0/2000/2005, 2008, 2012, Oracle 8i/9i/11g

SQL Server Tools: T-SQL, Data Transformation Services (DTS), SQL Server Profiler, SQL Server Query Analyzer, Import/Export tools, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server analysis Services (SSAS), SQL Jobs, SQL Alerts and SQL Mail, SQL Server Management Studio, TOAD 6.0, Jira, Enterprise Architect

Languages: C#, C++, PL/SQL, SQL, TSQL

Scripting: HTML5, Java Script, Ajax, CSS 3, JQuery

Microsoft Products: MS Word, MS Excel, VSS, MS Access, MS Power Point, MS Visio 2008

Operating Systems: MS-DOS, Windows 95/98/NT 4.0/XP/2000/2003 Server, UNIX

PROFESSIONAL EXPERIENCE

Senior MSBI Developer

Confidential, Valhalla, NY

Responsibilities:

• Experienced in installing, configuring, managing, applying Service Packs and administering SQL Server 2016/2014/2012 in development, test and production environment.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Implemented error-handling in the stored procedures by using try-catch and handled the duplicate records.
• Extensive experience using data modeling tools ERWIN, POWER DESIGNER and MICROSOFT VISIO.
• Designed ETL packages dealing wif different data sources (SQL Server, Oracle, Flat Files, Excel Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Experienced in working wif different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
• Designed SSIS Packages wif Dynamic Tasks and Connections Using Variables, Expressions and Packages Configurations and followed best practices to maintain Optimized performance.
• Experience in designing the data models for both OLTP and OLAP systems. Experience in Conceptual, Logical and Physical Modeling techniques, Experience designing normalization, star and snow flake schemas.
• Extensive experience in Agile environment and have experience wif the Agile project management tools like Version one and JIRA.
• Participated in Maintenance activities of SQL Azure. Writing stored procedures, functions and complex T-SQL queries in SQL AZURE Cloud.
• Designed, deployed, and maintained complex reports using SQL Server 2014/2016 Reporting Services (SSRS) and Power BI.
• Created Power BI Dashboards and integrated them to share point.
• Implemented and enhanced existing reportslike Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.
• Created OLAP cubes, identifying dimensions, KPI's, hierarchies and calculating measures and dimensions using SSAS.
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries.

Environment: MS SQL Server 2016/2014/2012/2008 R2/2008/2005, MSOffice Access 97/2000/2003/2010, SQL Azure Database, SSIS, DTS, SSRS, Power BI, Tableau, SQL Server Enterprise Manager, Profiler, Query Analyzer, SQL Server Manager, SSMS, Database Tuning Advisor, Erwin 7.x, Visual Basic 6.0 & 9.0, ODBC, Excel, ADO.NET, Visual Studio 2003/2005/2008/2012/2013/2015, T-SQL, Power Shell, PL/SQL, C#.net, ASP.net, VB.net, VB Script, HTML, Java Script, Unix Shell.

Senior MSBI Developer

Confidential, Minneapolis, MN

Responsibilities:

• Responsible for gathering and defining user report requirements and developing appropriate interfaces for the reporting infrastructure environment to meet customer business needs, based on business processes and data entities between various systems.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Understanding the business requirement from customers for enhancements and customizations.
• Designed, developed and tested software using Agile Methodology.
• Worked on Views, cursors, CTE’s, schemas, permissions and performance issues wif client/server database design.
• OLTP Design (conceptual/logical/physical), development, implementation, and maintenance phases.
• Migrated old data from MS Access and Excel into SQL Server 2014 using SSIS Packages in Business Intelligence Development Studio.
• Implemented and executed SSIS 2012 packages to import/export data from the different source to perform the ETL process.
• Used different SSIS transformations such as Record Set destination, For Each Loop container, Multicast Transformation, Derived Column Transformation to create new column, Conditional Split Transformation to split data flow using Business Intelligence Development Studio (BIDS).
• Created SSIS packages to load data from Flat Files, Excel spreadsheet and SQL Server 2012 to SQL Server2014 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps) and integrated them to share point.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Implemented and enhanced existing reportslike Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Experience wif KPI reporting and dashboards to support decision-making and performance tracking process.

Environment: SQL Server 2014/2012/2008R2, Microsoft Access, Microsoft SQL Server Integration Services (SSIS) 2014/2012/ 2008R2, Microsoft SQL Server Reporting Services (SSRS) 2014/2012/ 2008R2, Microsoft SQL Server Analysis Services (SSAS) 2014/2012/ 2008R2, Visual Studio 2013, ASP .Net, MS Excel, TFS, Agile, SVN

MSBI Developer

Confidential, Virginia Beach, VA

Responsibilities:

• Responsible for requirement gathering, analysis and coding.
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of transformations while loading the data.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Great expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Designed and Developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Monitoring SQL Server performance using SQL Server Profiler to trace the slow running queries and optimized query execution wif the use of Index Tuning Wizard and Rebuild indexes if necessary.
• Created SSIS packages to load data into warehouse from different sources.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Created Sub-Reports, Drill Down-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.

Environment: SQL Server 2012/2008 R2, Business Intelligence Studio (SSIS, SSRS), Team Foundation server, SharePoint 2007, T SQL, Erwin, Oracle 10g, MS Excel.

MS SQL Server BI Developer

Confidential, Franklin Lakes, NJ

Responsibilities:

• Created Stored Procedures, Triggers and Functions, Indexes, Views, Joins and T-SQL code for applications.
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Designed and developed data models for the data warehouse using star and snowflake schema.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Designing SSIS Packages using transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Used different Control Flow Tasks and Data Flow Tasks for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleansing the data from different Sources.
• Developed the packages wif monitoring features and Logging capturing the audit information of the packages and their execution results for support and troubleshooting.
• Also developed log tables to maintain the details of the failures and hence to improve the performance of the business modules.
• Used FTP and SFTP servers to transfer files to vendors.
• Extensively used HTML and DHTML technique.
• Involved in debugging / troubleshooting stored procedures, upgrading existing ones according to new requirements.
• Scheduled and executed SSIS Packages using SQL Server Agent.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Developed Query for generating drill down/drill through reports in SSRS.
• Actively involved in generating Matrix, Sub reports and complex reports wif multi value parameters for the analysis of Performance.
• Responsible for scheduling the subscription reports wif the subscription report wizard.
• Created cubes wif multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Identified and defined Key Performance Indicators (KPIs) in SSAS.
• Worked closely wif DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.

Environment: MS SQL Server 2008/2008R2, Business Intelligence Development Studio, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), SQL Profiler, SQL Server Agent, Erwin, Windows XP/7.

MS SQL Server Developer

Confidential

Responsibilities:

• Created stored procedures to transform the data and worked extensively In T-SQL for various needs of the transformations while loading the data.
• Involved in writing SQL queries, complex stored procedures, triggers, views, constraints, joins, DDL, DML and user defined functions (UDF) to implement the business logic
• Migrating MS Access/Sybase SQL Server 11.5 databases to SQL Server.
• Optimized the performance of queries wif modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Involved in unit testing of the mappings.
• Work on SQL Server Management studio and Visual Studio for day to day activities.
• Troubleshoots hardware and operating system problems.
• Following Data Warehousing methodologies and concepts, including Star schemas, snowflakes, dimensional modeling.
• Developed various SSIS packages for refresh process and ongoing daily updates from JDE to Mirror database and to theDatawarehouse and scheduled jobs using SQL server Agent.
• Created SSIS package in which records were loaded daily, also from other data resources such as Excel, Access, flat file, Oracle and XML in order to create and maintain a centralized data warehouse.
• Created cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS2008.
• Developed OLAP cubes based on the business requirements using SSAS 2008.
• Created Key Performance Indicators (KPIs) using different storage settings for cube designing.
• Designed and developed different reports like tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement using SSRS 2005/2008.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, MS Reporting Services 2008, MS-Excel, MS Access, MS Visio, Teradata, T-SQL, Erwin, LDAP, Visual Studio 2008, VBA, BTEQ.

SQL Developer

Confidential

Responsibilities:

• Involved in beginning of the project, updated existing database from SQL server 2005 instances to SQL server 2008. Managed database security policy login using Windows and SQL server autantication mode.
• Involved in Design of Data warehouse using Kimball and Star Schema and created Fact tables and dimension table.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Tuned, monitored and maintained SQL Server Jobs.
• Created logical and physical data models for new requirements after discussion wif technical team and application users as per agile methodology.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Created Views to replace old tables and created new tables wif triggers to support new business needs.
• Efficient use of Joins and sub-queries in queries that retrieve data from multiple tables.
• Used Execution Plan to optimize and enhance the performance of SQL Queries.
• Actively involved in Normalization of database.
• Optimize query performance by creating indexes.

Environment: SQL Server 2005, Visual Basic, .NET, PL-SQL.