SUMMARY:

• Over 5 Years of Business Intelligence /SQL Developer and Data Analyst experience with Bachelor of Computer Science and Information Systems.
• Extensive background and knowledge in Power BI, Tableau, T - SQL, SSIS, SSRS and many more reporting tools.
• 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, C#, C/C++, CSS, HTML, PHP, Mat Lab

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

Database: MS SQL 2014/2012/2008, MySQL

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

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

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst/BI Developer

Responsibilities:

• Currently working as a lead Power BI developer creating various kinds of AD HOC reports based on client’s needs.
• Participated in require gathering meetings and data mapping sessions to understand business needs
• Most of my projects requires me to pull in raw data, validate it, transform that data and come up with the necessary calculations and visuals.
• Gathered and analyzed business requirements from non-technical users and translated into detailed functional requirements that met business needs. Designed, tested, and refined operations databases.
• Highly experienced in Data Validation and manipulation. I use Power Query to connect all kinds of data sources like JSON, XML, SQL, CSV, Azure Blob Storage and Excel.
• Expertise in creating highly complex measures using Data Analysis Expression (DAX) formulas.
• Created high level dashboards that enables stakeholders to focus on performance and efficiency.
• Expertise in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis.
• Working directly with stakeholders for requirements gathering and developing various decision-making Dashboards.
• Created real-time dashboards and reporting capabilities of KPI metrics to senior management.
• Extensively analyzed existing data models and provides insights for future projects.
• Hands on experienced developing dashboards and reporting visualization.
• Published multiple interactive Dashboards on PowerBI.com and managed access for individual users using roles.
• I’ve scheduled refresh on the daily, weekly and monthly basis by setting up Gateways.
• 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.

Confidential

BI Developer

Responsibilities:

• 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.
• 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.
• 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.
• 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

Confidential

BI Consultant Developer (ETL, Power BI Report, Tableau)

Responsibilities:

• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created new and modified multiple database objects like Tables, Views, Functions, and Triggers to meet the requirements
• 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
• Prepare Source to Target Mapping Documents, Design Document, etc.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power Point. Slicer, Pivot chart, Pie Chart, Macros.
• Expertise in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis.
• Wrote stored procedure and function used in SSIS package and SSRS reports.
• Created and deployed Matrix, Grid, Chart, and Gauge Reports utilizing SSRS. Created parameters for SSRS reports as well as drill-down and interactive sorting capability. Implemented subscriptions and snapshots in the SSRS Report Manager.
• Investigates problems through to resolution or root cause/raises by pulling Data from multiple Sources and Develop Report.
• Create SSIS package to pull all Events and programs data from database server and SharePoint lists.
• Perform database administration tasks in support of development testing and deployment tasks, troubleshooting, and physical database configuration.
• Create pivot tables for users.
• Worked with Business Analysts to understand the requirements.

Confidential

Network Administrator/CISCO

Responsibilities:

• 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.
• 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
• Promoted Technician III, the highest-level technicians could achieve