PROFESSIONAL SUMMARY:

• A talented Business Intelligence professional with data analysis and reporting skills with 8+ years of work experience.
• Quick Learner of new technology and proficient in wide range of programming languages, tools and computer systems.
• Analyzing problems and come up with creative solutions provide business decisions support to the organization.
• IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2014/2012/2008 R2/2005 in Production, QA and Development Environments.
• Experience in installing, configuring, managing, upgrading, migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2014/2012/2008 R2/2005.
• Experience in Managing Security of SQL Server 2014/2008/2005/2000 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Strong experience with T - SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in SQL Server 2005/2008/2012 Reporting Services (SSRS), SQL Server 20052008/2012 Integration Services (SSIS) in Business Intelligence (BI).
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits, Event Handlers and Error Handlers etc
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) ( 2005/2008/2012 ).
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Expertise in Reporting tool Tableau and Analytical tool Datameer.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports. Create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in configuring and maintaining Report Manager and Report Server for SSRS. Also Deployed and Scheduled the Reports in Report Manager.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Experience in C# application development environment to use SQL Server Databases.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology. Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Worked with Business Analysts, Web development team and users on database solutions.

TECHNICAL SKILL:

Languages: C#, SQL, T-SQL, Python, MDX & DAX, JavaScript, HTML, CSS Framework” Entity Framework, Dapper Framework

Tools: Microsoft BI Stack SSIS, SSAS, SSRS, Visual Studio 2013 & 2015, MS Visio, MS Office 365, MS Access, MS Azure cloud services

Database: My SQL, Microsoft SQL Server 2014 and 2016, MS Access

Operating systems: Windows 7, windows 10, Windows Server 2012 R2 Windows NT 4.0,Windows 2000 Enterprise/Advance Server,Windows2003Enterprise/Datacenter ServerXP Professional and Windows 2000, UNIX.

Data Visualizations: Power BI, Tableau

Key concepts: Extract, Transform and Load (ETL), SSAS, SSRS Reporting, Kimball’s Data Warehouse Lifecycle, Power Query, Power Power Pivot KPI/Dashboards, Agile and waterfall methodology, Relational Database design, Dimensional and tabular Modelling, OLAP and Cubes, Star Schema, Snowflake Schema

Other Skills: Writing queries, stored procedure, triggers statements

Business Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL

Database Tools: Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer, SQL Client Utility.

Reporting Tools: Reporting Service (SSRS) 2005/2008 R2, Tableau and Datameer

ETL Tools: DTS, SSIS

Data Modeling: Erwin v 4.0, Visio 5.0

MS Tools: Management Studio, Visual Studio.

Internet Tools: Internet Information Server (IIS 5.0 / 6.0), FTP,TCP/IP

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer

Responsibilities:

• Setting up the Backend database for the charitable lotteries.
• Managing & maintaining SQL Server 2016 backup and restoring processes.
• Provided analysis for the customer purchasing Behavior pattern, financial & accounting reports.
• Used T-SQL for querying database using joins, stored procedure, Triggers.
• Query optimization for improving the query performance.
• Used MS Power BI for creating various data visualizations charts, dashboards, KPI and reports.
• Performed Extract, Transform and loading for processing the data into the Datawarehouse.
• Presenting the outcomes to the Senior Management, clients and Stakeholders based on the reports.
• Performed ad-hoc SQL Queries when immediate access to data was required,
• Developed, maintained & Managed all analytical & project-critical reports.
• Participate in application design and project planning sessions with developers and users
• Establishes and implements standards and strategies for data management, lifecycle, and quality
• Designs and monitors construction of an enterprise data warehouse, working with a team of engineers
• Continuously improves upon existing approaches by seeking opportunity to creatively transform current business practices into fresh alternative solutions

Environment: SQL Server 2016 Enterprise Edition, T-SQL, SSIS, MY SQL Workbench, DB Visualizer, BigQuery, Apache Hive, Jira, GitHub, SVN Tortoise, Eloqua, Datameer, Tableau.

Confidential

BI Developer

Responsibilities:

• Used ETL in SAP environment to extract, transform and load useful data into the data warehouse.
• Updated pricing list based in the database system
• Optimizing promotions process for the weekly and exclusive offers/deals by regions of the country.
• Created calculated columns and Measures using DAX. Also, used M language for data sorting, cleaning, importing processes.
• Used drill down reporting and Visualization charts like maps, line, predictive feature in MS Power BI
• Maintained data integrity and data authenticity across all Confidential and their subsidiaries.
• Performed validation checks on the products/items description, prices, stock, promotions.
• Reported the errors and pricing inaccuracies to the Senior Manager and Category Managers of the related products.
• Query optimization using SQL related to performance, retrieving & process data from the Database system
• Used MS Power BI for designing the Reports and dashboards for the Optimization process department.
• Used MS Excel pivot tables, V-lookups and power query for analyzing data, creating reports, updating the merchandising product list for Canada wide store promotions

Environment: SQL Server 2014 Enterprise Edition, T-SQL, SSIS, MY SQL Workbench, DB Visualizer, BigQuery, Apache Hive, Jira, GitHub, SVN Tortoise, Eloqua, Datameer, Tableau.

Confidential

Business Intelligence Analyst/Developer

Responsibilities:

• Build centralized data warehouse/data repository for all 11 retail stores.
• Replaced old MS excel based reporting infrastructure by MS Power BI for dashboards, KPI’s, reporting and data visualization.
• Imported CSV files from the sales data sources into MS SQL database system using MS SSIS in visual Studio
• Used DAX for the calculated measures and columns.
• Data cleaning, data integration, data mapping (ETL) using SSIS, SSAS, MS Power BI and SQL server environment using MS AZURE cloud services
• Generating Weekly, Monthly Sales, Inventory report by store.
• Reported all the activities related to operations to the Chief Executive Officer.
• Provided the useful information to the Manager and CEO based of the data analysis performed.
• Automated the reporting platform for generating daily, weekly and monthly reports using python scripting and selenium.
• Identified the business performance in sales, purchase of particular product.

Environment: MS AZURE, T-SQL, SSIS, MY SQL Workbench, ETL, DB Visualizer, BigQuery, Apache Hive, Jira, GitHub, SVN Tortoise, Eloqua, Datameer, SQL Server 2016 Enterprise Edition

Confidential

SQL Server Developer

Responsibilities:

• Involved in various stages like development, system Analysis &design, and creating stored Procedures.
• Designed and developed Interfaces which were used for connecting to SQL Server database.
• Validated and coded the application using VB.
• Debugged and fixed the bugs.
• Designed the Logical and Physical databases of SQL Server.
• Performed database testing & maintaining the data by using the procedures.
• Designed and validated the forms according to client requirement by using VB.
• Imported and Exported database using DTS utility.
• Wrote SQL stored procedures to implement business logic.
• Developed and coded applications in T-SQL.
• Maintained SQL Script for creation of Database Objects.

Environment: SQL Server 2000, SQL Enterprise Manager, Windows 2000/ NT, MS Access, MS Excel, VBScript.