Choksha

Certified SQL BI Developer

Email Id: ac24bp@r.postjobfree.com

Contact no: 614-***-****

PROFESSIONAL SUMMARY

Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008R2/2008/2005 in Development, Test and Production Environments with various business domains.

Around 6+ years of Experience with Microsoft SQL Server in database design, development and Microsoft Business Intelligence, ETL tool.

Extensive experience with data modeling techniques, logical and physical database design.

Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).

Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.

Reviewing Data Collection Plan, Business Requirement documents and Transmission Log.

Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000/2005 to 2005/2008/2008R2/2012/2014

Experience in creating indexed views, complex stored procedures, effective triggers and useful functions, jobs to facilitate efficient data manipulation and consistent data storage and daily run process.

Used MDX to interact with the back end OLAP Services.

Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.

Created Reports with complex formulas and to query the database for business Intelligence.

Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.

Experience in enhancing and deploying the SSIS Packages from development server to production server.

Migration of SSRS reports from SQL 2012 to SQL 2014.

Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).

Expert ETL design.

Expertise in migrating data from MS-Access, MS-EXCEL, Flat Files and other external data sources.

Scheduled run from Control-M for scheduling and PowerShell/C# for script development

Microsoft technologies including TFS, Windows 2003/2008/2013 Server family, Azure, Microsoft Office including Visio and MS Project.

Documenting the discrepancies in the documents and after fixes of issues rechecking the Data Collection Plan, Business Requirement and Procedure document.

Making use of PowerShell, Python and other tools to automate a range of tasks in an OS diverse environment.

Data Modeling Tools: Erwin r7.1/7.2, ER Studio V8.0.1

Experience in Creation and deployment of cubes on SSAS.

Good understanding in Oracle 9i/10g Database.

Strong development experience with the Microsoft BI Stack - SQL-Server, SSIS, SSRS, SSAS, Power Pivot, Power BI for Office and SharePoint.

Very Good Understanding and Experience in SQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services(SSRS)

Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.

Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.

Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.

Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.

Worked Extensively on ETL process using SSIS package.

Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.

Experience in writing complex SQL queries involving multiple tables’ inner and outer joins, stored procedures.

Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development.

CERTIFICATIONS

Microsoft Certified Professional.

Microsoft SQL Server 2008 Business Intelligence – Implementation and Maintenance

EDUCATIONAL QUALIFICATIONS

Bachelors in Engineering from JNTU (Jawaharlal Nehru Technological University) - India.

Masters in Science and Technology - Wright State University - Dayton, Ohio.

TECHNICAL SKILLS

Databases Tools

SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools

Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools

SQL Server Reporting Services (2005/2008 R2,2012,2014), MS Access, MS Excel, Tableau

Database

MS SQL Server 2014/2012/2008/2005/2000, MS Access, Oracle 9i/8i/11g

Programming

T-SQL, PL-SQL, C#

Web Technologies

HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL, VB Script, ADO.NET

Operating Systems

Windows (95/98/2000), Windows 2003/2008 Server, Windows XP, Windows Vista

Other Tools

MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.

PROFESSIONAL EXPERIENCE

WWR is the largest creditors' rights firm in the USA according to Collections & Credit Risk magazine, using revenue as a measurement in Service banks & financial institutions, real estate mortgage & lending companies, commercial creditors, government entities, insurance companies, credit unions, medical and utility companies, student lenders.

They are implementing new Data warehouse for multiple purpose like EDI, Internal Revenue, Performance monitoring of attorneys and various department. Source for the data the CSS impact collection software. They are implementing new collection software “CSS impact” and backend is oracle 11g. CSS Data Conversion project: BI /T SQL Developer for migration of master data and transaction data from old application HP Artiva.

Responsibilities:

Creating SSIS packages using proper control and data flow elements improving the performance of the package run time and unit test the developed packages as an ETL developer.

Work on ETL process using Microsoft SQL Server Integration Services (SSIS) process to provide the data quality, data cleansing, business rule transformations, and data loading, support the data loads and transformations using SSIS for the iterative conversion project.

Involved in migration from SQL Server 2008R2 to Oracle databases using SSIS on CSS Conversion Project.

Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.

Data migration from WWR legacy to the CSS Impact to support the day-to-day operation of WWR’s business model.

Develop complex Stored Procedures, Tables and useful Functions, temporary tables, Views, in SQL Server as per the requirement.

Upgraded or migrated SSIS packages from older 2005 version to 2013 version in Microsoft Visual Studio in Migration Project.

Developing the Data Flow in SSIS with all the required sources (Stored procedures, tables, Excel sheets etc.), transformation, and suitable destinations as required as per the document.

Migration involved migrating scripts developed with PowerShell also

Developed packages using variables, expressions, functions, stored procedures, parameters and also defining queries, writing complex queries in SQL involving tables, Open queries, Joins.

Worked on TFS in Developing and Staging environments.

Deployed packages, scripts, tables, stored procedures from lower to higher environments in TFS.

Worked with all almost all the transformations and control flow components in SSIS like SCD, Pivots, FTP, Lookups, OLE DB sources, OLE DB Command, ODBC sources, Script Task(using VB Script), For each Loop Containers, Sequence containers etc., along with few other users designed transformations Regular Expressions.

Worked on creating Fact, Dimensions Tables with required transformations, Stored procedure sources and moving to different locations using FTP task.

Created SSIS package using Script Component using C# and VB.NET.

Involved in designing, developing, debugging and testing of SSIS packages.

Worked on creating and executing complex T-Sql queries using SQL Server Management studio for back end data validation testing.

Worked on PL-SQL queries to check and validate data if all the requirements have met.

Worked on child and parent packages.

Created Cache Memory on Windows Azure to improve the performance of data transfer between SQL Azure and WCF services.

Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships.

Performed software reverse engineering to disassemble and debug unknown code.

Create PowerPivot models and PowerPivot reports, stored them onto SharePoint, and deploy models into SQL Server SSAS instance.

Followed business enhancements for migration during the project with Project

Developed Packages to Load data from MS SQL server to Oracle Destinations and in the flow created new SSIS packages according to the requirement for the fields.

Troubleshooting the issues on the SSIS packages.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Using Tableau server versions (7.0 and 8.2) as a front-end BI tool and MS SQL Server 2012.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Developed Tableau visualizations and dashboards using Tableau Desktop.

Developed Tableau workbooks from multiple data sources using Data Blending.

Provided production support for Tableau users.

Working on tuning SQL queries and T-SQL according to the desired output.

Worked on ETL process in SSIS packages and also improved the progress time. Used all different transformations required

Worked at conceptual/logical/physical data model level using Erwin according to requirements.

Created a database model from an existing database as a reverse engineering process

Made sure while coding to check the datatypes using the reverse engineering wizard.

By using cached mode in Tabular Models, integrate data from multiple sources including relational databases, data feeds; excel files and flat text files.

Generated parameterized reports, sub reports, tabular reports using SSRS 2012.

Create reports in Power BI preview portal.

Developed PowerShell modules in C# to interface with, SQL. Automated system utilizing PowerShell and BMC’s Control-M schedule of Jobs running.

Created database maintenance plans and deleting of history data using SSIS packages

Scheduling the SSIS packages and Jobs.

Created, Uploaded, Modified SharePoint accounts as directed and in compliance with all standard operating procedures

Actively participated in interacting with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: MS SQL Server 2012, SSRS 2012 -MS SQL Server Reporting Services (SSRS)

T-SQL, PL-SQL, Oracle SQL Server, SQL Server Integration Services (SSIS), Tabular Models, Data Modeling, SharePoint 2013, Tableau, DTS, VB SCRIPT, OLAP, OLTP, Office-2007, MS Excel, C#.NET. Excel, PowerPivot, Power BI, Erwin

Responsibilities:

Report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Created SQL Server Reports based on the requirements using SSRS 2012,2014

Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.

Migrated DTS packages from SQL Server 2008R2 to SQL Server 2012 as SSIS packages.

Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008R2/2008 (SSAS)

Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).

Troubleshooting performance issues and fine-tuning queries and stored procedures

Worked on OLAP Data warehouse, Model, Design, and Implementation.

Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.

Created complex reports which involve more number of groupings and multi-value parameters

Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.

Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining, Data modeling and Architecture.

Created multiple reports with drop down menu option having complex groupings within the report.

Created sub reports, bar charts and matrix reports, Triggers to enforce data and referential integrity, Check constraints, Business Rules, Indexes, and Views, Configured Server for sending automatic mails to the respective people when a DTS process failure or success.

Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

Performed reverse engineering of physical data models from databases and SQL scripts

Import data from multiple sources, and then enrich the model by adding relationships, calculated columns, measures, KPIs, and hierarchies by using Tabular Models.

Experience in creating complex SSIS packages using proper control and data flow elements.

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Load, refresh, and extract directory data using Windows forms programs (MS VS, VB script), MS SQL Server (stored procedures, views, DTS), Visual FoxPro, MS Access, and MS Excel.

Managing the Deployed models in SQL Server Management Studio just like multidimensional models by Tabular models

Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Chart diagrams.

Scripting in various languages like PowerShell, Pearl for the most rely integration services like application servers, database service, build systems.

Created different reports based on the requirements, and retrieve data using stored procedures that accept parameters using SSRS.

Used reverse engineering wizard for creating the new required mapping documentation creation.

Constructed multiple sub-sites, pages, and libraries with the deployment of the new SharePoint sites for better listing.

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Designing data model from scratch to aid team in data collection to be used for Tableau visuals

Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool.

Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.

Trained on works based on Erwin technology solutions.

Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database

Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.

Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers

Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Scheduling the SSIS packages and Jobs.

Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2012, MS SQL Server 2012, SSRS 2014 SQL Server Analysis services (SSAS), MS SQL Server Reporting Services (SSRS) T-SQL, SQL Server Integration Services (SSIS), Power BI, SharePoint, Tabular Models, Data Modeling DTS, SQL Profiler, Erwin VB SCRIPT, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET,VB Script ProClarity Analysis, Power Pivot, Erwin, Tableau.

Responsibilities:

Extracting and Loading data into SQL Server Database using SSIS.

Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.

Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008/2005(SSAS)

Created SSIS Packages to migrate slowly changing dimensions

Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

Experience in creating complex SSIS packages using proper control and data flow elements.

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).

Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.

Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.

Implemented PowerShell remoting and script execution.

Developed interactive web-based reports and forms with VB Scripts and ADO.NET and html

Performed the task of data transfer from files in remote server to folders in another server using FTP.

Create a Tabular models based on an existing model already in SQL Server Data Tools and by extracting the metadata and data from a PowerPivot for Excel file (.xlsx).

Developed different types of Tabular models, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)

Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.

By using cached mode in Tabular Models, integrate data from multiple sources including relational databases, data feeds, and flat text files.

Generated parameterized reports, sub reports, tabular reports using SSRS 2012.

Created database maintenance plans and deleting of history data using SSIS packages.

Scheduling the SSIS packages and Jobs.

Worked with Power BI to pull data from SQL Server and add those data elements to a report.

Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, etc.

Excellent report creation skills using Microsoft SQL Server 2012/2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Created SQL Server Reports based on the requirements using SSRS 2008.

Highly responsible for development and management of PPS, SSAS, SSRS and SSIS projects.

Building KPI reports for the cubes and optimizing the reports.

Worked on Power BI Direct Querying with

Performed business and system analysis, designed application and database structure, converted existing data into SQL Server using Data Transformation Services (DTS) and VB Script

Learned to Designed cubes with star schema using SQL Server Analysis Services (SSAS).

Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Designed and built OLAP cubes to meet reporting needs.

Responsible for identifying and defining Data Source and Data Source views.

Created cubes and defined the dimensions.

Responsible for defining calculated members.

Implemented business logic as .NET Framework assemblies (C#, VB.NET)

Defined attribute properties in a Parent Child Dimensions.

Used Joins to write queries that retrieve data from more than one table.

Responsible for hiding and disabling attributes and attribute hierarchies.

Developed reports that deliver data from cubes.

Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.

Created complex reports which involve more number of groupings and multi-value parameters

Using Sql server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.

Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.

Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2008/R2, IIS 6.0, MS SQL Server 2008 SSAS, SSRS, SSIS, Tabular Data models, Microsoft Business Intelligence Development Studio (BIDS), T-SQL, DTS, OLAP, OLTP, VB Script,C#.NET, Microsoft Excel, SQL Server Agent, TFS 2010, Office-2008, MS Excel.

Responsibilities:

Analyzed all the Database Structure and prepared a reference guide to understand the existing system better.

Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.

Created SSIS packages to Oracle and other SQL Server instances and used configuration files and variables for production deployment.

Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task.

Scheduled SSIS Packages for loading Facts and Dimensions.

Created packages in SSIS with error handling.

Worked with different methods of logging in SSIS.

Experience in creating complex SSIS packages using proper control and data flow elements

Involved in updating slowly changing dimensions strategies.

Created and managed subscriptions for the reports.

Responsible for ongoing maintenance and change management to existing reports and optimize report performance.

Created stored procedures to calculate pension and annuity information, when called will give the details for an employee on the website.

Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).

Created Indexes to get the high level performance.

Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules

Responsible for tuning T-SQL procedures, triggers and other database objects

Fine-tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them

Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.

Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.

Scheduled SSIS Packages for loading Facts and Dimensions.

Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project

Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i

Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.

Designed and developed DTS packages for transferring data from flat files and Access files

Created linked servers between different SQL Servers and also created linked server with different access files used across various departments.

Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server. Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.

Performing the ETL operations to support the data loads and transformations using SSIS.

Involved in migration from Oracle to SQL Server 2005 using SSIS.

Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.

Generation of reports from the cubes by connecting to Analysis server from SSRS.

Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.

Maintained databases, performed software installations and upgrades, monitored Database Performance.

Learned to Designed cubes with star schema using SQL Server Analysis Services (SSAS).

Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Designed and built OLAP cubes to meet reporting needs.

Responsible for identifying and defining Data Source and Data Source views.

Created cubes and defined the dimensions.

Responsible for defining calculated members.

Implemented business logic as .NET Framework assemblies (C#, VB.NET)

Defined attribute properties in a Parent Child Dimensions.

Used Joins to write queries that retrieve data from more than one table.

Responsible for hiding and disabling attributes and attribute hierarchies.

Developed reports that deliver data from cubes.

Implemented automated backup and database maintenance / cleanup jobs.

Managing Logins, Users, Roles and User permissions.

Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.

Designed numerous ad-hoc and custom reports using SQL Reporting Services.

Created various Tabular and Matrix Reports using SSRS.

Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.

Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: Windows 2003/XP, SQL Server 2005 BI Suite, SSIS, SSRS-2005,T-SQL, ETL, OLAP, OLTP, ASP.NET, ProClarity, C#, VB Script, MDX, T-SQL, MS Visual Studio 2005, Tabular Models, Windows 2000/2003, Crystal Reports 10,Visual Studio 2005, MS Office 2003, SQL Profiler.

Contact this candidate