PROFESSIONAL SUMMARY:

• Having 8+ Years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2014.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Strong experience in design and developing ETL using MS SQL Server Integration Services (SSIS). Worked with various versions starting 2000, 2005, 2008, 2008 R2, 2012, 2014 and 2016.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional Table, Matrix, Chart and Sub Reports.
• Solid knowledge of Power BI Desktop & report performance optimization.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Derived column, Conditional Split, Bulk Insert, Merge and union all.
• Developing SSRS reports on SQL Server and have very good understanding of SSAS, OLAP cube and Architecture.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL.
• Worked Extensively on ETL process using SSIS package.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Good understanding of Data Warehousing concepts and ability to utilize star schema and snow flake schema according to the requirement.
• Experience in using T-SQL in SQL Server 2000, 2005and 2008 platforms.
• Experience in Performance Tuning and Query Optimization.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), and Power BI.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Good knowledge of System Development Life Cycle (SDLC), Agile and Waterfall development environments.
• Good understanding and hands-on experience on XML, XSL (XSLT, XPath, XSL-FO).
• Experience with defect tracking and analysis using different defect tracking tools such as TFS (Team Foundation Server)
• Good knowledge of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake Schema Modeling. Written MDX query in OLAP databases.
• Expert in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.

TECHNICAL SKILLS:

Databases: MS SQL Server 2008/2012/2014/2016 , ORACLE

Scripting / formats: T-SQL, PL/SQL, C#.NET, HTML, XML

Business intelligence: MSBI Stack (SSIS, SSAS, SSRS), Data Warehousing

Analytics: POWER BI, MSBI Self Service, MS Excel

IDE: SSMS, SSDT/ Visual Studio

Collaboration: MS SharePoint, MS Visio, TFS, JIRA, Confluence

Operating systems: WINDOWS, UNIX

Methodologies: Agile, SCRUM

PROFESSIONAL EXPERIENCE:

Sr. MSBI Developer (SSIS, SSRS)

Confidential, Indianapolis, IN

Responsibilities:

• Responsible for designing and creating a staging database for temporary processing of data, consolidating data and loading data to central repository using SQL Server Integration Services (SSIS).
• Interact with Development Teams and Managers to analyze end-to-end business needs.
• Involved in creating relational database models linking the tables providing relationships and maintaining the normalization rules.
• Created technical specification documents to outline data flow design from sources to targets.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using SQL Server Profiler and Index Tuning Wizard.
• Implemented Incremental loads to transfer data from OLTP to data warehouses using Control flow and Data flow tasks.
• Enforced data consistency by Debugged SSIS Packages using Data Viewers, Breakpoints and check points.
• Designed ETL packages with Error Handling, Package Configuration and SSIS Logging.
• Used various SSIS tasks such as Conditional Split, Derived Column, script task using visual basic which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Databases.
• Deployed SSIS Packages and scheduled the jobs in various environments by configuring it.
• Created stored procedures and performed index analysis for slow performing reports to bring down the report rendering time.
• Generated new reports, maintained existing reports, optimize performance tuning for the existing reports which took longer time to generate.
• Deployed SSRS reports into Report Server and managed reports subscriptions, delivery, generation, rendering in Report Manager.
• Interpret data, Visualization and analyze results using statistical techniques and provide ongoing SSRS reports.
• Supported multiple teams, developed and delivered reports, to analyze efficiency performance and to predict future level of operational activities.
• Used Team Foundation Server (TFS) for all code and deployment source, extensively worked with TFS to keep track of all changes made in the project.
• Monitoring performance of the database and to optimize queries using Execution plan, SQL profiler, and SQL server performance alert.
• Wrote T-SQL queries in creating Stored Procedures, indexes, functions, tables, views and other SQL joins and statements according to requirement.

Environment: MS SQL Server 2016/ 2014/2012 , MS SQL Server Management Studio (SSMS), Visual Studio 2015, TFS, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS Excel, T-SQL, C#

Sr. MSBI Developer (Power BI, SSIS, SSRS, SSAS)

Confidential, Pleasanton, CA

Responsibilities:

• Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Involved in gathering requirements, business rules and prepared BI technical specifications.
• Created Complex Stored Procedures for implementing the business rules, also worked on Joins, CTEs (Common Table Expressions), Pivot and Unpivot tables, Materialized Views, Aggregate Conditions.
• Created various data models like Flattened, Star schema in SSAS - Tabular model / PowerPivot
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Extensively worked on views, cursors, CTE's, schemas, permissions and performance issues with client/server database design.
• Developed SSIS packages using various Transformations such as conditional splits, fuzzy look ups, aggregations and multicasting.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge using SQL Server 2014 SP1.
• Designed ETL package, with ETL Import/Export wizard for transferring data.
• Delivered required Power BI report as internet link, embedding in Office Tools.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)
• Build MDX queries and Data Mining Expression (DMX) queries for Analysis Services SSAS and Reporting services SSRS.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Created Tabular Models as a source to Power BI dashboards and scheduled jobs to refresh it in a timely manner.
• Elevated existing Power BI Dashboard on a regular basis as per requests from Business.

Environment: MS SQL Server 2012/2014, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS 2014), SQL Server Analysis Services (SSAS 2014), SQL Server Reporting Services (SSRS 2014), Power BI, Power Pivot, Windows 2010, MS Excel, SQL Server Profiler.

SR. MS SQL SERVER BI DEVELOPER (SSIS, SSRS)

Confidential, Nashville, TN

Responsibilities:

• Experience in application development and implementation.
• Experience in relational database model, design, development and performance tuning (SQL 2014).
• Experience in Data Warehouse dimension modeling.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Development experience working with large databases.
• Experience in gathering requirements and development of technical/functional specifications.
• Worked with agile software development techniques including designing software for unit testing and acceptance testing and use of continuous integration.
• Experience with full lifecycle software development.
• Experience with using TortoiseSVN as Source Control
• Experience with using SQL Data Compare Redgate
• Understanding Program specifications based on Business and Data requirements and to develop ETL solutions based on these requirements and specifications.
• Understanding upstream and downstream systems and processes including impact and gap analysis of current databases and reporting systems.
• Ability to write complex SQL queries, stored procedures, functions and triggers to support complex business needs.
• Performing Data analysis using SQL tools to query databases and provide technical assistance.
• Supporting and troubleshooting production processes and issues.
• Working with other ETL developers in the team to ensure smooth transition of data requirements into code.
• Analyzing data to understand business impact and proposing new changes and alternative solutions to existing data structures.
• Migrating SQL server jobs with dependencies to AutoSys.
• Creating testing scenarios in Development environment to test and validate data integrity of the SSIS packages.
• Experience in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Experience in creating SSIS packages using Script task (Vb.net, C#) and Script Component.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages
• Parameterized Control flow and Data Flow using variables and expressions in SSIS Package to achieve business needs and business requirement.
• Routinely analyzing, testing and cleaning data to ensure data integrity.
• Following company policies and procedures and maintaining constant security awareness since the position has access to sensitive data.

Environment: MS SQL Server 2012/ 2014, SQL Server Management Studio (SSMS), Windows 7, T-SQL, SQL Server Report Services (SSRS), SSIS, Microsoft Excel, Redgate, TortoiseSVN, CA Workload Automation AutoSys Edition.

MS SQL SERVER BI Developer

Confidential, Boston, MA

Responsibilities:

• Experience in complete Software Development Life Cycle.
• Experience working with Business Users and Business Analysts in gathering the requirements.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Create joins and sub-queries for complex queries involving multiple tables.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle,DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Created data loads and Performed Data validations.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Have deployed packages on different servers by configuring it.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Monitoring the jobs in case of heavy data loads and high memory usage. .
• Worked on SSRS to generate reports for various user groups and developer groups.
• Created Tabular reports, Matrix reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used MS Team Foundation server for Code Check -in and check out.
• Prepared documentation related to database design, Low-Level-Design Documents, Service Level Agreement and Unit testing plan and scripts.

Environment: MS SQL Server 2008R2/2012, TFS, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), T-SQL, SharePoint server 2007.

SQL/BI Developer

Confidential

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.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• 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.
• Created Cubes and used basic MDX to retrieve the result set for Calculations.
• Worked on advanced dimension Design and Cube design.
• 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.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• 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, Microsoft Business Intelligence Development Studio, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, ERWIN.

JUNIOR SQL DEVELOPER

Confidential

Responsibilities:

• Created Database as per the requirement of the bank to maintain the student records using SQL server 2000.
• Maintained and supported the SQL Server databases as a developer helping administrator.
• Involved in the Data modeling, Physical and Logical Design of Database.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Written Stored procedures and triggers to implement business rules.
• Involved in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Maintained disaster recovery Backup and Re-Indexing was implemented to increase the performance.
• Created user profiles and corresponding read, write and DDL and DML access properties were maintained on the database.
• Created documentation as required.

Environment: MS SQL Server 2000, T-SQL, DTS, Visual Studio, MS-Excel, MS-Office, Oracle8i and C.