Data Power
Resume:
Ashish B. Patel
************@*****.***
PROFSESSIONAL SUMMARY
●Senior SQL Developer specialized in database design, development and maintenance in a SQL Server environment (2008/2005/2000).
●Strong background in E-R modeling and Relational & Object Relational Database concepts.
●Hands on experience creating TSQL queries with Joins, Cursors and Triggers.
●Advanced experience writing stored procedures, functions, Cursors, views, DDL and DML.
●In depth SQL Server Reporting Services (SSRS) experience, leveraging to create, deploy, and manage reports.
●Proficiency with SSIS (SQL Server Integration Services), DTS (Data Transformation Services) as well as some exposure to Ab Initio.
●Hands on experience developing and deploying OLAP Cubes.
●Intermediate TSQL experience, including creating queries with Joins, Cursors and Triggers
●Full SDLC (Software Development Lifecycle) project experience, requiring detailed cross functional team collaboration throughout all phases, including: analysis, design, development, testing, implementation, production support.
●Results oriented team player, able to manage multiple tasks by priority to ensure the timely satisfaction of required project deliverables.
●Effective communicator, able to clearly articulate pertinent project information to technical and non-technical audiences.
●Proficient in creating, maintaining and scheduling Power BI Reports and Dashboard including tabular reports.
●Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI and SSAS. Thereby migrate existing data into the Power BI.
●Establishing trust as a go-to resource for clients
●Utilizes data visualization tools to make clear and concise visual representations of data
●Provides more complex research and analysis to support business operations and presents findings to management or project leader
●Collaborates with internal and/or external stakeholders to assess, select and recommend more complex solutions and/or alternative approaches that will achieve business goals
●Provide advanced insights / suggestions to the clients
●Meet the client expectations of the visualization request provided in the reports
●Manages to established firm standards for quality, service, and delivery i.e. delivering regular reports within time, checking mailbox to ensure timely delivery etc.
●Managed day to day activities and long term projects using Agile.
●Responsible for handling a high volume of inbound customer requests.
●Sound knowledge of Software Development Life Cycle (SDLC) and Project management
●Create Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports
●Create Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes
●Publish and schedule the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application
TECHNICAL SUMMARY
ETL Tools: SQL Server 2000-DTS, SQL Server 2005/2008 R2-SSIS, Ab-Initio.
OLAP Tools: SSRS, SSAS, Power BI.
Databases: Oracle 8i/9i/10g, MS SQL Server 2000/2005/2008/2008 R2, DB2, MS Access
Others: VSS, TFS, RED GATE, SQL-Navigator, Test Director, Win Runner
Database Skills: Stored Procedures, Cursors, functions, Database Triggers and packages
Languages: VB 6.0, Visual Studio.NET, SQL, PL/SQL, C, C++, UNIX shell scripts,
XML, HTML, .NET Framework 2.0/3.5
Operating Systems: Windows NT, Windows Server 2003/2008/2008 R2, Windows 2000, XP, Windows 7, UNIX
EDUCATION:
Bachelor of Commerce:
Citizens Property Insurance, Jacksonville, FL June 2019 - Present
Role: SQL Data Designer and Power BI
Description: Citizens property Insurance corporation is a not-for-profit, tax-exempt, government entity. Its mission is to provide insurance protection to Florida policyholders, who are entitled to but are unable to find property insurance coverage.
Responsibilities:
●Establishing trust as a go-to resource for clients
●Utilizes data visualization tools to make clear and concise visual representations of data
●Provides more complex research and analysis to support business operations and presents findings to management or project leader
●Collaborates with internal and/or external stakeholders to assess, select and recommend more complex solutions and/or alternative approaches that will achieve business goals
●Provide advanced insights / suggestions to the clients
●Meet the client expectations of the visualization request provided in the reports
●Manages to establishe firm standards for quality, service, and delivery i.e. delivering regular reports within time, checking mailbox to ensure timely delivery etc.
●Coordinating with business users in analyzing business requirements and translating them to technical specifications.
●Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
●Preparing Scom Report for All the Critical and non-critical application using Power BI.
●Preparing IT metrics report for TSC, UAM, and My Services using Power BI and SharePoint as source and creating dashboard for Business Analyst for their presentation.
●Spend Lots of time completing the ad-hoc request from the Business side for the clients using Sql server in a timely manner.
●Monitor the Rally to make sure there they are allocated, and designated person is working on it and check the progress.
●Collaborated with cross functional team and with users throughout to fully understand the impact of the requirements on the system.
●Worked with data flow from source files like Excel and flat files into SQL server with proper mapping and high volume of data.
●Developed complex T-SQL queries using DDL, DML, DQL and designed SSIS packages to load the data into warehouse.
●Designed SSIS Packages to perform Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
●Utilized several transformations in Data Flow and control flow including Derived-Column, Script, Slowly Changing Dimension, Data Conversion, and Conditional-Split for implementing the Transformation Logic in the Packages.
●Developed, deployed and monitored SSIS Packages on daily, weekly and monthly basis in Development, Staging and Production environments.
●Created and maintained setup log files and email notifications to monitor jobs in a real time production and Staging environments.
●Scheduled Packages using SQL Server Management Studio for the daily, weekly and monthly Load.
W.S Badcock Home Furniture& More, Mulberry, FL Jan 2016 – June 2019
Role: Sr. SQL BI DEVELOPER And Power BI
Description: W.S.Badcock Home Furniture & more is a 112 years old and one of the largest family
owned home furniture retailer with 4 Distribution centers in 4 different states with more than 300 retail stores including 75 corporate stores and 240 dealer stores. Badcock furniture & more serves more than 2 million customers in 7 different states with 300 suppliers.
Responsibilities:
●Coordinating with business users in analyzing business requirements and translating them to technical specifications.
●Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
●Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2016 and used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
●Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
●Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
●Using SSIS Package identified the Up-streams and imported the required tables into intake-database, Store Procedures are created in staging database using the intake-database tables & views.
●Checking the code into TFS (Store Procedures, Views, Tables, Schema) for the deployment process for the production environment.
●Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.
●Designed and implemented Row Level Security & Roles for SSAS Tabular Model. And deployed into SQL SERVER ANALYSIS SERVER 2016.
●Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
●Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
●Create reports in Power BI preview portal utilizing the SSAS Tabular Model via Analysis connector.
●Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
●Created Page Level Filters, Report Level Filters, and Visual Level Filters in Power BI according to the requirements.
●Used One Drive for storing different versions of Power BI report.
●Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
●Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports. And added the refresh time for each tile in the dashboard.
●Used JIRA for Version Control needs, task check-ins.
●Responsible for complete maintenance and delivery of scheduled releases.
Ship Express Jacksonville, Florida April 2011 – December 2015
SQL Developer
Responsibilities:
●Collaborated with cross functional team and with users throughout to fully understand the impact of the requirements on the system.
●Worked with data flow from source files like Excel and flat files into SQL server with proper mapping and high volume of data.
●Developed complex T-SQL queries using DDL, DML, DQL and designed SSIS packages to load the data into warehouse.
●Designed SSIS Packages to perform Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
●Utilized several transformations in Data Flow and control flow including Derived-Column, Script, Slowly Changing Dimension, Data Conversion, and Conditional-Split for implementing the Transformation Logic in the Packages.
●Scheduled Packages using SQL Server Management Studio for the daily, weekly and monthly Load.
●Created SSIS packages with package configurations, error handling and logging.
●Developed, deployed and monitored SSIS Packages on daily, weekly and monthly basis in Development, Staging and Production environments.
●Created and maintained setup log files and email notifications to monitor jobs in a real time production and Staging environments.
●Used SSIS to import, export and transform the data between the linked servers and Involved in day-to-day database maintenance operations.
●Migrated SSIS 2005 packages to SSIS 2008R2.
●Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
●Created complex Stored Procedures, Triggers, User Defined Functions, CTE’s, Cursors, Views using TSQL to implement complex business logic.
●Created tables, indexes and constraints using TSQL.
●Tuned complex SQL Queries using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
●Wrote Joins and sub-queries for complex queries involving multiple tables from different databases.
●Developed report specifications, creating and modifying reports using SSRS 2005/2008R2.
●Migrated SSRS2005 reports to 2008R2 reports using SSRS.
●Migrated Crystal reports to 2008R2 reports using SSRS.
●Created reports subscriptions using SSRS to send data in PDF, Word and Excel format on Daily, weekly, monthly and yearly basis via emails and sending to shared folders.
Bank of America Jacksonville, Florida July 2007 – March 2011
SQL Server Developer
Responsibilities:
●Used SSIS for data flow from source files like Excel, flat files, Tables and External Database Servers with mapping of data by using multiple transformations.
●Wrote SSIS Packages to transform daily, weekly and monthly jobs, to transfer data from SQL server to different files and external databases.
●Created master and child packages, package configurations, error handling and logging.
●Participated in the development, implementation, administration and Support of ETL processes for Data Warehouses using SQL Server 2008 SSIS on daily, weekly and monthly basis.
●Used SSIS to import, export and transform the data between the linked servers.
●Involved in troubleshooting and fixing the loading issues with ETL packages and files.
●Creating and maintaining databases, tables, views, Indexes, check constraints, and business rules using T-SQL. Responsible for Performance tuning the queries, stored procedures and tables by using SQL Profiler, Execution Plans and Index Tuning Wizard.
●Wrote complex SQL queries using joins, sub queries, common table expressions (CTEs) and Functions in T-SQL to retrieve data from multiple tables.
●Developed stored procedures as well as created variables and expressions using VB script.
●Created and Modified Triggers and Cursors in T-SQL for maintaining SQL server databases.
●Involved in data capture and slowly changing dimensions to modify and insert data into existing tables and capturing the corresponding changes in History tables.
●Developed Custom Reports using SSRS.
●Involved in Creating Datasets, stored procedures in T-SQL for SSRS.
●Worked on Developing, Deploying and Scheduling Complex Reports using Sal server reporting Services (SSRS) to generate daily, weekly, monthly and quarterly Reports.
●Designed and Deployed Tabular, Matrix, List and Chart reports with Drill Down, Interactive sort, Drop down menu option, Parameterized and Sub reports.
●Scheduled and deployed reports and uploaded files to a share point and report servers.
●Created standard report Subscriptions to export report into required formats and placing them on shared folders to load again into Database using SSIS packages.
Contact this candidate