Sql Server Data

Hussain Lokhandwala Email: ***********@*****.***

BI Specialist /Data Visualizer Tel: 470-***-****

PROFESSIONAL SUMMARY

4+ years of broad experience as a Business Intelligence Specialist (solution-oriented) in Financial Domain and Services industry having expertise in requirement eliciting, analyzing and documentation of business

Extensive experience in database development with Microsoft SQL Server 2012 and Microsoft’s suite of products like SSIS, SSRS and Power BI

Knowledgeable work through Tableau

Strong Transact-SQL Query writing skills (DDL- data definition language and DML- data manipulation language).

Strong SQL Server developer skills including writing stored procedures, user defined functions, views, triggers, CTE (Common Table Expressions).

Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.).

Experience in managing Alerts, notifications and Jobs through SQL Server Agent.

Extensive experience on SQL Server Management Studio, and Business Intelligence Development Studio.

Good understanding of RDBMS and design of database architecture.

Good working knowledge of Performance tuning of Stored Procedures and T-SQL Queries.

Good working knowledge with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Facts and Dimensional tables and Operational Data Store (ODS).

Proficient in generating diverse types of reports such as Drill through reports, parameterized reports, tabular and matrix reports using SSRS.

Expert understanding of best design principles and practices in showcasing data using tables, graphs and dashboards using Power BI, SSRS and OBI (Oracle Business Intelligence).

Expertise in designing and implementing ETL & BI solutions using SQL Server 2012/2008/2005 SSIS, SSRS.

Utilized Access, Excel and SSRS to create, modify, run, export, print, distribute, deploy, and troubleshoot reports.

Excellent in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Experience in migration of data using BCP Utility, Bulk Insert command, SSIS and DTS Packages and Import/Export Wizard.

Overall database design, such as creating normalized databases, query tuning, assigning proper indexes, partitioned views, creation of triggers and stored procedures.

Effectively can work individually or as a team to accomplish the assigned tasks at allocated time.

Experience in working with various source controls such as TFS and Jira.

WORK EXPERIENCE

UPS (United Parcel Service) Atlanta, GA

Business Intelligence Specialist Aug 2016 – Sept 2017

Extracted data from internal data warehouse system implemented in SQL server 2012 to SSRS using data tools for Visual Studio 2012.

Designed and developed stored procedures, queries and views necessary to support SSRS reports.

Developed Stored Procedures and queries using SQL server management studio to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports in SSRS.

Analyzed data models, data relationships, and dependencies for greatest optimization.

Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports, graphs and dashboards.

Created ad-hoc reports in OBI (Oracle Business Intelligence)

Used best design practices for various data visualizations such as tables, graphs and dashboards.

Used Microsoft Power BI for dashboards and mapping US states and cities to various data points.

Performed functional and performance QA testing of all reports.

Created data mapping and sourcing documents of various fields and tables used in reports.

MFG.com Atlanta, GA

MFG.com is a manufacturing marketplace where contract manufacturing companies and procurement professionals connect and do business.

SQL Server BI Developer Feb 2014 – Dec 2015

Worked with Business Analyst & Users to understand the requirements. Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact & Dimension tables

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL, Triggers Scripting and Jobs.

Managed the migration of SQL Server 2008 databases to SQL Server 2012.

Expertise in writing and debugging Stored Procedures, Triggers, Cursors and T-SQL coding.

Used Execution Plan, SQL Profiler and Database Tuning Advisor to optimize queries and enhance the performance of databases.

Optimized the performance of queries by modifying and rebuilding indexes.

Created SSIS packages to transfer data from heterogeneous sources to SQL server using different SSIS components and used configuration files and variables for production deployment.

Created master ETL packages which include various packages in them and scheduled them to execute based on the given requirement time.

Created SQL Server Reports using SSRS 2008.

Designed various reports using different reporting features such as group by, drilldowns and drill through.

Used various types of report layout options like charts, images, sub reports, hyperlinks etc. to make them more attractive and understandable.

Created report models for Ad-hoc reporting. Created Ad Hoc reports in Report Builder.

Created weekly and monthly reports as per requirement using SSRS.

Scheduled Reports to be delivered to User on demand Basis in SSRS report Manager.

Helped the users to test the reports created and optimized the performance of the end reports getting data from SQL server Databases.

Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles.

LiveSource.com Atlanta, GA LiveSource is the MFG.com cloud-based sourcing tool that combines the power of advanced supplier management with the global reach of the world’s largest manufacturing marketplace.

SQL Server ETL Developer Sept 2013 – Feb 2014

Involved in gathering requirements for Database creation, scheduling status review meetings, documents and code review.

Good exposure in creating and managing conceptual, physical and logical data models.

Involved in designing and implementing relational database (RDBMS) model as per business needs. Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server 2012 integration services.

Extracting data from IMS/DB2, MS Access, and SQL Server 2005/2008 for migration and performing various transformations in SSIS (ETL) per business rules.

Used change data capture (CDC) to simplify ETL in data warehouse applications.

Experience in creating jobs, alerts, SQL mail agent and schedule SSIS (ETL) packages.

Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server.

Experience in configuration of report server and report manager scheduling, give permission to different level of users in SQL server reporting services (SSRS).

Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL server reporting services.

Coordinating with offshore team for on time delivery of products and query resolution activities.

Atlanta Retailers Association Atlanta, GA

SQL Developer June 2013 – Jan 2014

Designed unified dimension model based on the business requirement.

Designed SSIS packages to migrate data from multiple data sources for data analysis, deployment and dynamic configuration of SSIS packages.

Extensively used Control Flow Elements like For Each Loop, Sequence Container, Execute SQL Task, Execute package Task, Script Task, File System Task, Send mail Task, process Task.

Created Stored Procedures which generated the necessary fact and dimension tables and functions that allowed to perform necessary calculations depending upon the requirement.

Created various database objects such as Tables, Indexes, and Views for the generation of Star Schema.

Defined roles and security levels for different information users.

Designed and developed SSIS packages in automating the process of processing the cubes as well as executing other tasks like running the stored procedures.

EDUCATION

New Jersey Institute of Technology (NJIT) - M.S. in Business and Information Systems

Major: Management of Technology

Contact this candidate