SUMMARY:

6 years of database development experience with Microsoft SQL Server 2008/2012/2014. Worked with SSIS, SSRS, SSAS, Excel, and Power BI, Tableau as well as ETL and Data Extraction. Experience working with the full development cycle of a data warehouse including requirements gathering, design, implementation, and maintenance. A team player and looking for a challenging opportunity that will leverage technical background to add value on a project.

TECHNICAL SKILLS:

Languages: T - SQL, Java, C#, C/C++, CSS, HTML, PHP, MatLab

Data Warehouse Tools: SSIS, SSRS, SSAS, Business Intelligence Development Studio, DTS, SQL Profiler, Weka.

Database: MS SQL 2016/2014/2012/2008, MySQL, Visual Studio 2010,2012 and 2013, MS SharePoint 2013, TFS 2013, Power BI, Azure DB.

Reporting Tools: Excel, Power BI, Tableau, SQL Server Reporting Services 2012,2008, 2005.

Other Tools: MS Office, JIRA, Confluence, Visio, MS Excel, MS-Project, Star UML, Eclipse, Load Runner, NetBeans, Adobe Photoshop CS, Corel paint shop pro, Microsoft Photo edition 2006, Illustrator.

PROFESSIONAL EXPERIENCE:

Sr.BI Developer (ETL, SQL, PowerBI/ Tableau Report)

Confidential

• Extract data directly from various data sources (Splash Core, SAP, Data warehouse) using SSIS
• Create a (user friendly) central database which combines the various data
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks
• Create multiple kind of Power BI Reports and Dashboards.
• Build/create a UI through which we can generate sales reports, forecasting tools, etc.
• Train existing ops/tech on how to use Power BI
• Migrate Business Objects reports to Power BI
• Migrate SSRS reports to Power BI
• Designed and created different ETL packages using SSIS from various source to SQL Server as destination
• Performance Tuning the Stored Procedures used in SSIS Packages
• Wrote Stored Procedures in designing various SSIS packages
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Develop Tableau reports that provide clear visualizations of various KPIs.

Sr.BI Developer (ETL, PowerBI Report)

Confidential

• Designed and created different ETL packages using SSIS from various source to SQL Server as destination
• Mange and administer two servers (Production and User Acceptance) used by worldwide Team.
• Create SSIS package to pull all incident and programs data from database server and SharePoint lists.
• Create a staging database and apply the business logic using T-SQL scripts.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Involved in Performance tuning of ETL transformations, data validations and stored procedures
• Working with project managers, business analysts and SME to develop different kind of report.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Create Views and stored procedure to be consumed by SharePoint dashboard, Excel dashboard, and Power BI dashboard.
• Design, develop and deliver services analytics materials including back-end development of analytics services, SQL
• Reporting, delivery of automated reports & Power BI reports customization
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• The data analytics covers multiple service areas such as incident management, change management, problem management, monitoring analysis and support & service qualities
• Set-up Enterprise Gateway and SSAS Connector on Azure VM for Power BI Report Deployments.
• Developed complex reports using multiple data sources, user defined object synchronized queries.
• Publish reports into SharePoint portal site from Excel
• Coordinate with off shore team (India) to deliver projects.
• Supporting internal stakeholders by providing business reporting, analysis of results, identification of opportunities & successes and updates on progress toward goals and strategies.
• Perform database administration tasks in support of development testing and deployment tasks, troubleshooting, and physical database configuration.
• Create a Virtual Network on Windows Azure to connect all the servers.
• Subscribe SQL Server Azure Cloud Services.
• Create Database(s) on SQL AZURE
• Setting up SQL Azure Firewall
• Create, manage SQL Server AZURE Databases
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers

BI Developer (Power BI Report)

Confidential

• Created various kinds of reports using Power BI and Tableau based on the client’s needs.
• Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
• Expertise in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis.
• Migrate existing data into the Power BI.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created joins and sub-queries for complex queries involving multiple tables.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Working directly with stakeholders for requirements gathering and developing various decision making Dashboards.
• Hands on experienced developing dashboards and reporting visualization.
• Expert on creating complex CTE, Sub Queries, Joins, cumulative queries for multiple kind of reports.
• Investigates problems through to resolution or root cause/raises by pulling Data from multiple Sources and Develop Report .
• Proven experience developing and managing data integration solutions using Microsoft BI technologies.
• Designing, constructing, and testing of ETL processes. Created SSIS packages to extract data from the transactional and/or operational databases, transforming the data according to analytical / reporting business needs, and loading the data into a Data Warehouse or Data mart.
• Responsible for creating datasets using different kind of query language.
• Expert on creating Score Cards, Metrics, Power View/MAP and Pivot Tables using Office 365.
• Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Experienced with connecting multiple data sources in Tableau to implement working reports.
• Created SSIS packages to transfer data, from flat files into SQL server using different SSIS components and used dynamic configuration files and variables for production deployment

SQL Server/BI Consultant Developer

Confidential

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS)
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Tabular reports
• Generated matrix reports, drill down, drill through, multi parameterized reports using SSRS
• Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
• Created Datasets in T-SQL Stored Procedures for SSRS
• Using SSRS created well-formed web-based reports
• Troubleshoot data issues, validates result sets, recommends and implements process improvements
• Created report snapshots and cache for better performance
• Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager
• Configured SQL mail Agent for sending Automatic emails on Errors
• Designed and created different ETL packages using SSIS from various source to SQL Server as destination
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations
• Created Maintenance Plans and setup log files to monitor jobs
• Utilized several Transformations like Lookup, Fuzzy Lookup for implementing the Transformation Logic in the Packages
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more
• Wrote complex SQL scripts to avoid Informatics joiners and Look-ups to improve the performance as the volume of the data was heavy
• Design/Develop complex queries efficiently as per the given business requirements
• Develop views, sub-queries and joins for complex queries involving multiple tables
• Created joins and sub-queries for complex queries involving multiple tables
• Worked with Business Analysts to understand the requirements
• Perform data back-up and archival on regular basis
• Involved in Creation of database, tables and procedures to update and clean the old data
• Test and evaluates report’s performance and implements necessary solution
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job task by using Scheduled Jobs and Alerts using SQL Server Agent
• Produce standard monthly reports using Tableau.
• Automate monthly excel reports into Tableau Workbooks and Dashboards.
• Design and develop Tableau visualization solutions.
• Prepare Dashboards using calculations, parameters in Tableau
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.

Network Administrator

Confidential

• Managing and Maintaining the Servers, PC’s, Routers and Switches.
• Tutoring students with Networking related questions and give solutions to their technical issues.
• Configure 40 plus workstations with the virus protection and eradications.
• Provide a brief training for CISCO students how to configure routers and switches.
• Help provide setting up security administration port security on switch and IP security on Router via Access list.
• Help students get familiarized with IP addressing, sub-netting, and routing concepts.
• Worked with a team to provide technology support to students, faculty, and staff
• Solved issues related to any MS Software’s, networking, virus removal on PCs and Macs