Resume

Sign in

SQL/BI Developer

Location:
Austin, TX
Posted:
October 10, 2019

Contact this candidate

Resume:

Ashish

Email: adaj7r@r.postjobfree.com

Phone: 585-***-****

Certified SQL BI (SSIS/SSRS/SSAS/Power BI) Consultant

Summary:

Around 6+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008/2012 in Development, Test and Production Environments.

Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSRS) including MS solutions like MS EXCEL, Microsoft Office SharePoint server 2007/2010/2013 Performance Point Server and ProClarity analysis server.

Experience in Developing and Tuning T-SQL, PL/SQL Complex Queries, Stored Procedures, UDF’S, triggers, views, Indexed views and error handling using Try-Catch blocks

Experience in supporting Very Large databases (VLDB) and Very large tables with millions of rows and troubleshooting the problems

Implemented Normalization, Transactional, Snapshot replication and Performed log shipping as Disaster recovery solutions.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008/2008 R2/2012,2014,2015,2016).

Thorough understanding of Kimball’s’ theory, KPIs, Perspectives, Translations and SQL 2008 Architecture.

Experience with data modeling, logical and physical database design using Erwin.

Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2012/2014.

Experience in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008R2/2012/2014, Powerpivot(Excel 2010)

Designed and built complex cubes using Multidimensional Expressions (MDX) of SQL Server and manipulating the multidimensional data stored in OLAP cubes.

Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Generated Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008/2012.

Experienced in using Power Shell / Power BI.

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

Developed data interface layer using ASP.NET and C# for data access.

Worked in performance tuning, query optimization, client/server connectivity and Database Consistency Checks using DBCC utilities.

Developing reports on SSAS & SSRS on SQL Server (2000/2005/2008/2008 R2/2012/2014/2016). Experience and understanding of SSAS, OLAP cube and Architecture.

Experience in using recursive CTEs, CTE, temporary tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.

Expertise in Using DMVs, DMFs, DTA, ITW, Performance dash board and database snapshot.

Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.

Expertise in Dashboard design with a working knowledge of Performance Point Server including the ability to design and develop scorecards and dashboards using ProClarity.

Experience in developing Life Cycle using Agile Methodology.

Excellent communication skills, analytical skills, understand business requirements in various Domains.

Education:

Masters in Mechanical Engineering from Rochester Institute of Technology, Rochester, NY

Bachelor of Mechanical Engineering from GGS Indraprastha University, New Delhi, India

Skills:

Databases

SQL Server 2014/2012/2008/2008R2/2005, Oracle 8i/9i/10g/11g, MYSQL

Database Tools

SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio (BIDS), SQL CMD.

Reporting Tools

SSRS, Report Builder, Focus, Power BI.

Languages

T-SQL, MDX, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA

OLAP

SQL Server Reporting Services (SSRS), SSIS, Crystal Reports 9.0/8.5, OLAP, Erwin, Tableau, Power BI

Change Management Tool

Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems

Windows Server 2000/2003/2008/2012, MS DOS, Unix, Linux.

Experience:

FirstCare Health Plans, Austin, TX Oct 2018 – Till date

Power BI Developer

Responsibilities:

Deliver high quality, innovative BI solutions in a fast-paced environment

Data mining and modeling, regression analysis, process documentation, profitability analysis, lead/list generation, customer attrition and direct mail campaign analysis

Responding to requests from partners for customer information reports, lists etc.

Identifying/recommending potential data sources.

Responsible for performing assigned database-related analyses and projects.

Ensures adherence to compliance regulations and policies.

Design and develop ETL solutions for multiple source systems

Design, develop, and support BI-related database applications spanning multiple lines of business

Evaluate operation of production BI applications/environments and perform appropriate troubleshooting as necessary

Perform complex data analysis to identify trends, patterns, and opportunities

Collaborate effectively with Engineers, Product Managers, and Project Managers to implement project deliverables

Effectively work with business users to determine project requirements and issues

Create and maintain technical documents

Configure and maintain test environments.

Execute software test plans.

Performed the testing of Web methods in J Unit and Testing framework using Selenium. Executed the test scripts using Selenium validate the actual and expected results Responsible for Automation Scripts & library functions maintenance.

Log and report defects.

High-priority issue handling (hot-fixes).

Application, functionality and product sign-offs for release and release tracking.

Create and maintain system documentation.

Performed regression testing for fixes using QTP and closed the defects in Test Manager. Involved in the end-to-end test using QTP and responsible for the Quality-Assurance of this application to complete in record time.

Attend Project/Daily-Scrum meetings.

Plan and execute system end-to-end tests for all existing and new applications.

Participate in system integration testing with other teams.

Participate in integration testing with clients/3rd party vendors.

Build regression test suite and plan/execute regression tests as needed.

Environment: SQL Server 2016/2014/2012, OLTP, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Power BI, Windows Server 2008, VS 2010/2012, Power BI, T-SQL, QTP, J Unit, Selenium and Excel.

Thomson Reuters, Rochester, NY April-2018 – Oct 2018

SSRS Developer

Thomson Reuters is one of the world’s most trusted provider of answers, helping professionals make confident decisions and run better businesses.

Responsibilities:

Responsible for SQL Server Reporting Services Planning, Architecture, Training, Support and Administration in Development, Test and Production Environments.

Extracting and transforming data within Business Intelligence environment.

Worked with Microsoft SQL Server, including SQL Agent jobs, SSIS packages.

Designed and developed SQL programming objects, including stored procedures, user defined functions, and common table expressions

Used Performance Point Server (PPS)to create interactive reports with an ability to drill down into details

Perform unit level analysis on all work done before handing over to the testing team

Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic

Create SSRS reports according to user requirements and technical standards

Customize output formats from SSRS to Excel, PDF, and CSV.

Creating Report-Models for ad-hoc reporting and analysis.

Developed Query for generating drill down reports in SSRS 2008 R2

SQL Server 2008 Reports Writer and performed complex SQL report writing and design.

Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.

Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.

Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,

Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Sql Server Reporting Services 2012.

Environment: SQL Server 2016/2014/2012, OLTP, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Power BI, Windows Server 2008, VS 2010/2012, Power BI, T-SQL, and Excel.

Immense Analytics. Rochester, NY Sept 2017- Mar 2018

SQL BI (SSIS) Developer

Immense Analytics has partnered with DataGravity to bring their data-aware storage platform to clients. Immense Analytics offers installation, configuration and maintenance of their award-winning products.

Responsibilities:

Delivered high quality, innovative BI solutions in a fast-paced environment

Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application.

Designed and developed ETL solutions for multiple source systems

Designed, developed and supported BI-related database applications spanning multiple lines of business with loan and leasing applications.

Performed complex data analysis to identify trends, patterns, and opportunities

Created SSIS packages to extract, load and transform the data from flat files to database tables, API to database

Extensively for the Pre-Prime product team

Strong SQL Server Development skills including writing Transact-SQL (T-SQL) Queries, Stored Procedures, User Defined Functions (UDF), Views, Calculation Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default.

Experience in performance tuning, query optimization, Database Maintenance plans

Performed Unit & IT testing& conducted UAT sessions with end users.

Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.

Use Cosmos products in developing internal applications and presentations.

Experiences in developing Normalization, Stored Procedures, Views, ETL processes, relational database theory and Complex Queries on SQL Server 2012/2014.

Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.

Created several SSIS Packages from different data sources like CSV Files, Excel Files, Oracle DB, SQL DB, MS Azure.

Used multiple transformations in SSIS to meet the business requirements by extracting data from transactional source systems, transform and finally load into the Staging Data base.

Worked in designing Cubes in OLAP and identifying the Fact and Dimension tables.

Used SQL Server Profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.

Excellent in creating reports with SQL Server Reporting Services (SSRS) and Power BI

Used SSRS and power BI to create reports, Parameterized Reports, Drill down & Drill through Reports, Ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Experience in creating Parameterized Reports using Dynamic SQL i.e. Stored Procedures.

Provided reporting and analytic solutions to the organization in the form of Reporting Services reports and Analysis Services cubes.

Using the above query results from Cosmos, creating reports in PowerBI, Ads pulse to show the metrics by server and procedure name, by server etc.

Managed complex issues quickly using problem solving techniques such as problem (KT), process and data analysis

Developed the T-SQL programs and Involved in performance tuning of SQL queries and stored procedures using SQL techniques and queries for faster retrieval.

Involved in performance tuning of SSIS Packages.

Environment: SQL Server 2016/2014/2012, OLTP, Informatica 9.1, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Power Shell, Power BI, Windows Server 2008, VS 2010/2012, Power BI, T-SQL, and Excel.

Kartrocket (Shiprocket 360), Gurgaon, India July 2015- July 2017

SQL Developer

Shiprocket 360 is an end to end commerce enablement solution which helps offline and online retailers build their omnichannel solution. Shiprocket 360 helps to create a seamless journey for customers across all sales channels based on their interest, reaction, and past interactions.

Responsibilities:

Involved in migration of SQL Server 2008 to 2012/2014.

SQL Server 2008 Reports Writer and performed complex SQL report writing and design.

Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.

Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.

Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,

Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Sql Server Reporting Services 2012.

Designed SSIS Packages to transfer data from various sources of the Company into the database that was modeled and designed.

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Defined best practices for Tableau report development.

Defined best practices for Tableau report development and effectively used data blending feature in tableau.

Create Master Package to run different other ETL in one Master package.

Developed complex T-SQL queries, common table expressions (CTE), stored procedures, and functions used for designing SSIS packages.

Bug fixes in SSIS, SSRS and stored procedures as necessary.

Perform T-SQL tuning and optimizing queries for and SSIS packages.

Created SSIS process design architecting the flow of data from various sources to target.

Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS

Environment: SQL Server 2014/2012/2008R2/2005 Enterprise Edition, SQL BI Suite (SSIS, SSRS), VB Script, Tableau, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle.

Zostel, New Delhi, India Aug 2013 – June 2015

Jr. Developer (SSIS, SSRS)

Zostel is one of the largest networks of backpackers' hostels founded in India, and one of the country's first. The chain of hostels has presence across 36 locations in India and Nepal

Responsibilities:

Involved in complete Software Development Life Cycle (SDLC).

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.

Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.

Implemented Event Handlers and Error Handling in SSIS packages.

Created SSIS packages for Data Conversion using data conversion transformation.

Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.

Wrote T-SQL queries using inner join, outer join, and self joins, merge join. And also implemented functionality for removing duplicate records like using CTE and ranking function.

Use Window azure to deploy the application on cloud and managing the session. Worked on Azure Data Factory for Extract & Load data.

Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.

Experience on extracting data from Azure HDInsight and publish the transformed data into AzureSQL Data Warehouse and build reports on BI platform.

Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.

Calculated measures and dimension members using multi-dimensional expression (MDX).

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

Created reports using stored procedure and Experience in building Reports on Analysis Services cubes.

Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).

Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).

Developed a High level dashboard using SSRS 2008.

Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.

Involved in upgrading from SQL Server 2005 to SQL Server 2008.

Responsible for writing T-SQL code for creating cursor and handling data validations.

Environment: SQL Server 2008/2005 Enterprise Edition, T-SQL, SQL Server Business Intelligence Development Studio (SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.



Contact this candidate