SUMMARY

• Around 8 Years of experience in analyzing, designing, tuning and developing Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC) using SQL Server Integration, Reporting & Analysis Services
• Experience using Oracle data sources/targets
• Extensive knowledge in T - SQL queries (DDL and DML) and construction of complex queries involving multiple tables to create and maintain database objects like Stored Procedures, User Defined Functions, Triggers, Views, and Indexes.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS)
• Created SSIS Packages to import data from various sources and loaded data to SQL OLAP database
• Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data, etc.
• Used various transformations in SSIS such as Data Conversion, Conditional Split, merge and union all
• Designed dimensional data model utilizing star schema with multiple facts and dimension tables
• Used Slowly Changing Dimension Wizard to load the data into data warehouse
• Implemented parent child relationship, CDC (Change Data Capture) using SSIS
• Implemented error and event handling: precedence Constraints, Break Points, data grid and Logging
• Hands on experience in Scheduling Jobs and Alerts in MS SQL Server Integration Services (SSIS)
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys
• Good Understanding in Dimensional Modeling, ER Modeling, Star Schema and Snow Flake Schema, Fact and Dimensional tables and Operational Data Store (ODS)
• Developed OLAP Cubes (Tabular, Multi-dimensional) using SSAS through complex MDX queries
• Used SSAS in creating Data Source Views with added Measures, Dimensions, Calculations and actions
• Expert in analyzing the Dimension Tables, Hierarchies, Levels, Cube Partitions and Aggregations in SSAS
• Expertise in developing reports using SQL Server Reporting Services and MS Excel spreadsheets
• Experienced in creating several types of Parameterized, Tabular, Matrix, Drill-Down, Cross Tab, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS)
• Experience in developing User Reports and Management Reports using Power BI and Tableau
• Designed dashboards and score cards utilizing Power BI and Tableau for improved business analysis
• Experience working with Amazon Web Services
• Experience working with Azure SQL Database Import and Export Service, Data Lake
• Experience in deploying SQL Databases in cloud (AZURE)
• Expertise in Performance Tuning and Query Optimization
• Hands on experience in using tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Proficient in Performance Tuning of SSIS packages by using row transformations, blocking, semi blocking and unblocking transformations
• Familiarity with DBA Activities in Development/Test environments including Backups, Restores, Security, User management
• Created database maintenance plan for the performance of SQL server, which covers database integrity checks, update database statistics and re-indexing
• Incorporated TFS for solution source control, project coordination, and task management
• Performed the task of data transfer from files in remote server to folders in another server using FTP
• Experience with Agile practices such as Backlog Grooming, Sprint planning, Story sizing, Story Prioritizing, Standup meetings, and User Story Demos on Agile Project implementation.
• Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

TECHNICAL SKILLS

Databases: MS-SQL Server 2008, 2008R2, 2012, 2014, 2016, Azure

Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, Business Intelligence Development Studio(BIDS), Microsoft Visual Studio 2015

Languages: T-SQL, Dynamic SQL

Reporting Tools: MS SQL Server Reporting Services (SSRS), Power BI, Tableau

Change Management Tool: Team Foundation Server (TFS), SVN

SDLC: Agile, Scrum, Waterfall

Data Modeling: ER-win, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Fremont, CA

Sr. MS SQL BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems
• Created Complex Stored procedures, user defined Functions, Views and used CTE's for complex coding.
• Created SSIS Packages to import data from Excel sheets, text files, SQL server OLTP and loaded data to the SQL OLAP database
• Designed ETL packages dealing with different data sources (SQL Server, Oracle, Flat Files, OLEDB sources) and loaded the data into target areas by performing various kinds of transformations using SSIS
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules
• Implemented Slowly Changing Dimension Wizard to load the data into data warehouse
• Used CDC (change data capture) to load the data into the tables and tracked the changes
• Created XML file for package configurations and implemented parent-child package configuration in SSIS
• Expert in developing OLAP tabular cubes/multidimensional cubes using SSAS
• Made modifications and added new MDX queries to the cube
• Identified the dimension, fact tables and designed the data warehouse using star schema
• Designed Dimensional Modeling using SSAS packages for End-User and created Hierarchies
• Developed Aggregations, partitions and calculated members for cube as per business requirements
• Knowledge of developing reports from Cubes using the KPI's for decision making, also debugged data connections, data sources and Data Source Views
• Creating Ad Hoc and Parameterized Reports using SQL server Reporting Services SSRS
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Implemented security to restrict the access to users and to allow them to use only certain reports
• Have used BCP, BULK INSERT to transfer data from and to SQL server database
• Worked with Dynamic Management Views (DMV) for improving query performance
• Analyzed the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine Tuning Advisor
• Responsible for Database, Log Backups and Restoration, Backup Strategies and Scheduling Backups
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups

Environment: Microsoft SQL Server 2016, SQL Server Integration Services (SSIS) 2016, SQL Server Reporting Services (SSRS) 2016, T-SQL, Windows Server, BIDS, SSMS, T-SQL, ER-Win, Tableau, TFS, Microsoft Visual Studio 2015, SQL Profiler

Confidential, Lebanon, NJ

SR. SQL BI Developer

Responsibilities:

• Collaborated with company stakeholders, application developers, and production teams to identify business needs
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations
• Wrote complex SQL queries using joins, sub queries, and correlated sub queries to retrieve data
• Designed and implemented data integration process (ETL) with SSIS
• Created SSIS Packages to import data from oracle database, Excel sheets, text files, SQL server OLTP and loaded data to SQL OLAP database
• Used SSIS transformations, filtered data using Derived Column, Lookup, Fuzzy lookup, Conditional split
• Implemented error and event handling: precedence Constraints, Break Points, data grid and Logging Created XML file for package configurations and implemented parent-child package configuration in SSIS
• Created master-child package models for improved maintenance and performance sing SSIS
• Implemented CDC (Change Data Capture) to track the changes in database table while loading the data
• Designed SSIS package configurations (package and project deployment models) to efficiently deploy ETL packages from the development environment to the production environment
• Performed the task of data transfer from files in remote server to folders in another server using FTP
• Designed and developed an OLAP data mart following the Kimball methodology with star schema to identify dimensions / fact tables pertaining to the business process
• Worked on Data Modeling (Logical/Physical) with ER/Studio
• Created SSAS cubes using MDX query with dimensions and facts to facilitate reporting business analysis.
• DevelopedMulti-Dimensional Objects(Cubes, Dimensions) using SSAS 2014
• Analyzed multitude of cube objects such as KPI's, perspectives, translations, calculated members for faster data retrieval and improved performance of report generation
• Experience in working with Amazon Web Services (AWS in EDS, Redshift, AWS API gateway)
• Created ad-hoc, parameterized, drill down, drill through, cascading parameterized reports using SSRS.
• Designed dashboards and scorecards utilizing Power BI for improved business analysis
• Deployed reports to the report server in native mode and SharePoint Server
• Created report snapshots/caches to improve performance and deploy/schedule reports
• Scheduled reports utilizing subscriptions to generate daily, weekly, monthly, and quarterly reports
• Implemented security to restrict the access to users and grant permissions to reports
• Collaborated through TFS to synchronize data from differing sources and to communicate scripts / database objects to cross functional team environments
• Responsible for Query optimization and Performance tuning
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary
• Fine-tuning of Stored Procedures to improve performance was achieved by removing unnecessary cursors and used SQL Profiler to improve performance
• Performed tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Involved created database maintenance plan for the performance of SQL server, which covers database integrity checks, update database statistics and re-indexing
• Responsible for Backup Strategies, Database, Log Backups, Restoration, and Scheduling Backups

Environment: Microsoft SQL Server 2016/2014, SQL Server Integration Services (SSIS) 2016/2014, SQL Server Reporting Services (SSRS) 2016/2014, T-SQL, Windows Server 2008, BIDS, SSMS, SharePoint, T-SQL, ER-Win, Power BI, SharePoint, TFS

Confidential, Bloomington, IL

SQL BI Developer

Responsibilities:

• Collaborated and coordinated with business analysts to gather requirements for implementing data mart
• Created required SQL procedures, functions, triggers, and views to supports OLTP and ETL application
• Designed SSIS packages to import data from multiple sources to control upstream and downstream of data into SQL Azure database
• Worked with various SSIS control flow tasks and data transformations like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split, Aggregate transformations etc. as part of ETL
• Designed dimensional data model using star schema with multiple facts and SCD tables
• Created Event Handlers, Package Configurations, Logging, System and User-defined Variables Incorporated control for solution source control, project coordination, and task management.
• Migrated data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure data factory and experience with Data Lake
• Backed-up enterprise databases to Azure storage in block BLOBs files in Azure environment.
• Configured the cloud databases for HA solutions with Geo-replication
• Designed and developed an OLAP data mart following the Kimball methodology with star schema to identify dimensions / fact tables pertaining to the business process
• Designed and developed various analytical Dashboards from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Parameters, customized Calculations, Conditions, Groups, Sets, Bins, Context filters for various analytical reports and Dashboards
• Generated context filters and data source filters while handling huge volume of data in Tableau.
• Created Tableau dashboards with Hierarchies, interactive views, drill downs with user level security
• Experience in creating different visualizations using charts like Bars, Lines and Pies, Maps, Scatter plots
• Developed Tableau workbooks to perform year over year, quarter over quarter type of analysis
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop and published them to server
• Designed a database optimization plan like creation of table partitions and the use of appropriate Indexes
• Tuned queries by analyzing execution plans, reorganizing/rebuilding indexes

Environment: Microsoft SQL Server 2014, SQL Server Integration Services (SSIS) 2014, Microsoft SQL Server Management Studio, BIDS, T-SQL, Tableau Desktop V8/V9, TFS, Azure

Confidential

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC)
• Wrote complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement business logic and created clustered/ non-clustered indexes
• Upgraded SQL Server from SQL Server 2008 to SQL Server 2012
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in Development and Production environments
• Designed and developed SSIS Packages to import and export data from various sources
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, Fuzzy Lookups
• Implemented Event Handlers and Error Handling in SSIS packages
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also, implemented checksum SCD method to load the data into data warehouse
• Developed SSIS packages not only for Initial Data Loads but also for incremental/delta load. Created a Log table to capture the SSIS events and used it to perform debugging of packages
• Responsible for Logical /Physical Data Modeling, Database Design, analysis, Documentation and Implementation
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema
• Created several cubes in SSAS, built MDX queries to query cubes and to access cube's data
• Created partitions and designed aggregations and configured security levels for the Cubes
• Designed KPI’s in SSAS and imported them to Excel
• Calculated measures and dimension members using multi-dimensional expression (MDX)
• Defined Calculated members, named sets, and executed other script commands using MDX
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS
• Developed various reports like Drill Down, Matrix, Parameterized, Drill through, Cross tab reports in SSRS
• Involved in scheduling reports to run on daily and weekly basis in report manager, created snapshots, subscriptions for the reports
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts
• Utilized power BI desktop to design real time dashboards and scorecards for analytical decision
• Deployed reports and Power BI dashboards on the reports/SharePoint server
• Published reports/dashboards designed in Power BI and shared through Office 365
• Maintained Disaster recovery strategies for the database and fail-over methods
• Took Database Full Backup, Transaction log backup & differential backup in daily Routine
• Implemented automated jobs for Database backup on a weekly and monthly basis
• Involved created database maintenance plan for the performance of SQL server, which covers database integrity checks, update database statistics and re-indexing
• Optimized the queries by looking at Execution Plan for better tuning of the database
• Diagnosed and tuned server optimal performance using SQL Profiler and Database Engine Tuning Wizards

Environment: SQL Server 2008/2012, SQL Server Business Intelligence Development SQL Server Integration Services (SSIS) 2012, SQL Server Reporting Services (SSRS) 2008/2012, T-SQL, BIDS, SSMS, ER-Win, Power BI, SharePoint, TFS

Confidential

Jr. SQL Developer

Responsibilities:

• Wrote complex SQL statements using joins, sub queries and correlated sub queries
• Ensured data consistency, created primary/foreign keys and appropriate constraints
• Created DDL and DML triggers to maintain database integrity
• Created new database objects with T-SQL such as procedures, functions, triggers, indexes, and views
• Performed data analyses and data profiling with TSQL and data profiling tasks
• Implemented BCP utility and bulk inserts for transferring data between SQL server and flat files
• Fetched complex data from multiple tables on remote databases utilizing linked servers
• Used SSIS to extract, transform and load the data from various sources and mapped the data into destination using various transformations such as lookup, merge, derived column, data conversion, conditional split, etc.
• Designed multiple reports such as drill down, drill through, parameterized, and linked reports using SSRS
• Scheduled reports using subscriptions to generate daily, weekly, monthly, quarterly, annual reports
• Involved in creating Users, Roles, managing security/permission, managing Jobs and error logs
• Optimized performance with indexing (cluster index, non-clustered index) tables
• Analyzed complex queries and tuned the same to optimize the application and system performance
• Involved in database management and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer
• Implemented automated jobs for Database backup on a weekly and monthly basis
• Involved created database maintenance plan for the performance of SQL server, which covers database integrity checks, update database statistics and re-indexing.

Environment: Microsoft SQL Server 2008, SQL Server Integration Services (SSIS) 2008, SQL Server Reporting Services (SSRS) 2008, T-SQL, BIDS, SSDT, Windows Server, SQL Profiler