Intelligence Developer Ssis

Ram Bala

Cell# 270-***-****

Email: *********@*****.***

Professional Summary

Around 9 years of Business Intelligence experience in Development, Client Analysis, Database Design, Reporting and Presentation using SQL Server 2008R2/2012/2014,2016, SSIS, SSAS and SSRS & Power BI

Enthusiastic IT professional in Database Design Development, creating various several reports & dashboard, ETL Implementation and support of OLAP/OLTP/Data warehouse systems using Microsoft SQL Server 2008/2005 across various SDLC environments.

Extensive experience in BI suite - using integration services (SSIS) for ETL (Extraction, Transformation and Loading), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes.

Experienced in creating complex SSIS and DTS packages for ETL purposes. Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts.

Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.

Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema.

Always Worked closely with .NET web developers to create new Stored Procedure to pass their parameters and database objects for the application functionality.

Strong experience working with SQL Server using T-SQL in constructing Tables, Stored Procedures, Triggers, Views, Indexes, Relational Database Models and Data Integrity and frequently used Joins, Sub Query, CTE, Ranking and Aggregate Functions and expert in T-SQL Programming, query optimization and performance tuning.

Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.

Always Followed the industry standard best practices for code and process design for good understanding of my code for other developers.

Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2000/2005 /2008 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.

As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.

A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.

Professional Experience

Tetra Pak, Denton, TX (October 2019- September 2021)

Role: Sr. SQL BI Developer

Created various several Power BI reports based on the requirements and deployed them to Production Successfully.

Created various tabular cubes with live connection to the SQL database and then build Power BI reports out of the Cube data.

Worked on Natural Language processing project using python to predict the top three knowledge base articles based on the subject in the Incident raised by the user. Used various several modules and libraries like pandas, numpy, nltk, textblob, pyodbc, pathlib, genism etc., in python and even used cosine functions and definitions to predict the matching percentage of the incidents based on the text used in the subject.

Generated Custom ETL scripts using SSIS 2008/2012 and unit test SSIS load processes for performance check.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as deposit interest, loan interest, service fees, and transaction fees along with slicers and dicers enabling end-user to make filters.

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Involved in creating Dynamic SQL scripts for the Daily Extracts and Transforms.

Monitoring the production jobs that will execute the reports and packages on Daily and monthly basis.

Data processing (Inbound/Outbound) from SQL to Downstream/Upstream using python scripting language.

Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Optimized the performance of various SQL scripts, stored procedures, and triggers by using embedded UDFs, CTEs and System stored procedures.

Involved in building logics to process the data for Financial Reporting.

Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.

As a lead Developer Managed offshore and onsite Team for completion of team goals and meet the project deadlines.

Environment: T-SQL, MS SQL Server 2016/2012, SQL SERVER 2012 Enterprise Edition, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Business Intelligence Development Studio (BIDS), ETL, SSAS, XML, MS Excel, C# .NET, SharePoint, TFS, MS Visio, SQL Comparison tool, Atlassian Jira, Learn Kit, Azure Data Lake, Data Factory, Python.

Service King Collision Repair, Richardson, TX (March 2019 – September 2019)

Role: Sr. SQL Server BI Developer (SSIS/SSRS/SSAS/Power BI)

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.

Maintained the database schema and all project in Team foundation server (TFS) source code control.

Worked in the complete Data Warehouse development life cycle and actively supported business users for change requests during the project development.

Involved in writing complex SQL Queries, Stored procedures, views, triggers, cursors, User Defined functions to implement business logic.

Created, maintained, and supported SSIS packages to move data in and out of a small and large database and SSRS reports for the Clients or end users.

Created complex SSIS and DTS packages for ETL purposes. Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts.

Created various several SSIS packages for the business reporting and delivered the data in Excel and CSV formats.

Worked on developing Power BI reports and dashboards from multiple sources.

Created dashboards and data visualization using Power BI desktop.

Published reports and dashboards to Power BI Service through Office 365 integration.

Created data marts and load data into dimension and fact tables by creating SSIS packages.

Worked closely with application teams and be responsible for database query design.

Developed and supported SSIS ETL packages to perform data loads from distinct types of source files to SQL server database.

Created new database objects like tables, views, indexes, stored procedures using T- SQL in development as well as production environments for SQL 2008.

Handled incremental data load into staging and ODS databases.

Performed SQL code review on new procedures and report queries created by consulting team.

Created Custom Visuals and made specialized reports for Power BI dashboards that included tiles, visualization, reports and Q&A capabilities.

Trained employees in the basics of Power BI Desktop and Power BI Services to comfortably operate the software’s.

Involved in Database Deployments from Dev to QCT and did SQL comparison of Databases in visual studio between DEV and QCT.

Expertise in Analyzing and troubleshooting the deadlocks, T-SQL queries, Stored Procedures, Triggers, Cursors, User Defined Functions & Views.

Monitored daily jobs and resolved the issues that caused by production data by modifying the SSIS packages. and participated in daily Scrum as part of Agile Methodology.

Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas for developing Cubes using SSAS.

Used Azure Devops for the stories and bug tracking every day.

Worked closely with the QA team to make sure everything is tested correctly & accurately before they move it to production and provided critical support to the production by addressing the production bugs or defects immediately and resolving them on time.

Environment: SSIS, SSRS, T-SQL, MS SQL Server 2016/2012, Visual studio 2015, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Business Intelligence Development Studio (BIDS), ETL, SSAS, XML, MS Excel, C# .NET, SharePoint, TFS, MS Visio, SQL Comparison tool, VSTS

CIT, Livingston, NJ (March 2018 to March 2019)

Sr. SQL BI Developer (SSIS/SSRS/SSAS/Power BI)

Analysis/Design, Development of Databases, SSIS packages for migration, SSRS reports for auditing of migrated data.

Involved in translation of business requirements into technical design specification.

Involved in writing complex SQL Queries, Stored procedures, views, triggers, cursors, User Defined functions to implement business logic.

Created, maintained, and supported SSIS packages to move data in and out of a small and large database and SSRS reports for the Clients or end users.

Created Custom Visuals and made specialized reports for Power BI dashboards that included tiles, visualization, reports and Q&A capabilities.

Responsible for defining, designing, and leading implementation of Power BI reports and dashboards for our client

Designed & developed Power BI and for education, health, human services business groups.

Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.

Working with the business to document and develop KPIs for the calculations in the Power BI apps.

Trained employees in the basics of Power BI Desktop and Power BI Services to comfortably operate the software’s.

Extensively worked on all activities related to the development, implementation, and support of ETL processes for large-scale data warehouses using SQL Server SSIS.

Incorporating Business logic in SSIS packages while converting from MS Access and Text file to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship.

Involved in Database Deployments from Dev to QCT and did SQL comparison of Databases in visual studio between DEV and QCT.

Expertise in Analyzing and troubleshooting the deadlocks, T-SQL queries, Stored Procedures, Triggers, Cursors, User Defined Functions & Views.

Monitored daily jobs and resolved the issues that caused by production data by modifying the SSIS packages. Extensively used JIRA for story & bug tracking and participated in daily Scrum as part of Agile Methodology.

Scheduled, maintained, and supported the distribution and access to reports in Power BI Services.

Configured and maintained Report Manager and Report Server for Power BI Gateway.

Developed Proof of Concepts (POC) for various projects using Power BI.

Created quick reports for various company departments using Power Pivot to create Pivot Tables and Pivot Charts.

Centralized the list of users having access to multiple applications in Power BI such that it is easy to track which user has access to which application.

Developed business logic using DAX to provide custom functionality in Power BI Applications.

Implemented tasks to schedule Power BI Gateway and Dashboard refreshes at regular intervals and appropriate dependencies.

Coordinated with DBA in creating and managing Tables, Indexes, Triggers, DB links and Privileges.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using SSAS.

Maintained Industry Standard Best Practices for coding and for the process design.

Used SQL SERVER Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: T-SQL, MS SQL Server 2016/2012, SQL SERVER 2012 Enterprise Edition, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Business Intelligence Development Studio (BIDS), ETL, SSAS, XML, MS Excel, C# .NET, SharePoint, TFS, MS Visio, SQL Comparison tool, Atlassian Jira.

National Bankruptcy Services, Addison, TX (June 2017 to February 2018)

Sr. SQL BI Developer

Developed SSIS Packages to migrate data from OLTP, Access, flat files, and Excel into Repository for further Data Analysis and Reporting using multiple transformations.

Responsible for developing, monitoring and deploying SSIS packages.

Created complex SSIS packages using proper control and data flow elements.

Created, developed and maintained several SSIS Packages that includes large amount of data In and Out between the sources and destinations.

Involved in SSAS Cubes design by creating measure groups, facts, dimensions, aggregations from huge dataset using SQL Server 2008 Analysis Services (SSAS).

Created complex SQL queries, stored procedures, functions, joins and SSIS packages.

Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.

Custom logging using script tasks and event handlers in SSIS packages. Active part in building Star schema and Snowflake schema based on the business requirements.

Configured and managed data sources, data source views, cubes, dimensions, roles and hierarchies.

Created SSRS reports from Analysis Services using MDX and DMX Queries.

Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.

Deployed the SSIS Packages from development server to production server using package configurations.

Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.

Created Scripts in SSIS Packages by using C# and VB.Net in Script tasks.

Developed Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS)

Created, Developed, Maintained, and supported both the new and existing reports.

Developed reports in SSRS using Analysis services as data source.

Maintained developed source code in the repository for all databases and kept all build programs up to Date.

Maintained best practices in coding and process design as per the Industry Standards.

Provided critical support to Production Environment.

Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent.

Environment: Windows Server 2008R2, SQL Server 2008R2/2016, SSIS, SSAS, SSRS, T-SQL, TFS, JIRA, VB.NET, C#, ETL, MS Access, CSV, Excel, XML.

Bank of America, Plano, TX (February 2015 to May 2017)

Business Intelligence Developer (SSIS/SSRS/SSAS)

Environment: MS SQL Server 2012, MS SQL Server 2008 R2, SQL Server Reporting Service 2008 R2, TFS, MS SQL Server Integration Services 2008 R2, BIDS, T-SQL, VB.NET, C#, Windows 2007 Server.

Ness Technologies (March 2013 to July 2014)

Business Intelligence Developer (SSIS/SSRS/SSAS/ETL)

Environment: T-SQL, MS SQL Server 2008 /2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), ETL, SSAS, XML, MS Excel, C# .NET, SharePoint, TFS, MS Visio.

Technical Summary

Operating Systems: Windows 98/2000/2003/XP/NT/Vista/7/8.1/10, Windows Server 2003/2003 R2/2008/2008 R2/2012/2014/2016, UNIX.

Database Tools: SQL Server Management Studio (SSMS), SQL Profiler, Query Analyzer, DTS Designer, Index Tuning Wizard.

GUI Tools: SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2005/2008/2010, SQL Comparison Tool, Tableau.

Languages: T-SQL, MySQL, Python, .Net, C#

OLAP Tools: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Power BI

Source Control Tools: Visual Source Safe 2005, Team Foundation Server 2010, JIRA

ETL Tools: SQL Server Integration Services (SSIS), DTS, Import/Export Wizard.

Education and Certification

Microsoft® Certified Technology Specialist: SQL Server®, Business Intelligence Developer.

Python Data Structures by University of Michigan on Coursera.

Master of Science in Applied Engineering & Technology Management

Bachelor of technology in Electronics & Communication Engineering

Contact this candidate