Home

Abhishek - SQL/BI Developer

[email protected]

Location: Gibbsboro, New Jersey, USA

Relocation: Yes

Visa:

Abhishek Cherukupalli BI Developer | SQL Developer | Data Analyst [email protected] | (678-400-7211) Professional Summary: Around 9 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2016/2017/2019/2022 in Development, Staging and Production Environments Experience in Data Modeling, Database Design, SQL Scripting, Business Systems Analysis & Design, Database Development and Implementation of Client-Server & Business Intelligence (SSIS, SSAS, SSRS) applications. Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers. Expertise in writing and debugging Stored Procedures and Triggers in SQL Server Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML). Expert in creating SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server. Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Extensive experience in Schema design, Indexing, Integration Services (SSIS), Reporting Services (SSRS) Good understanding and hands-on experience with Analysis Services (SSAS) and Power BI. Expertise in designing complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service. Knowledge on working with various services in Azure like Data Lake to store and analyze the data. Theoretical knowledge of various Azure data services like Cosmos DB, Synapse Analytics, Blob storage. Conceptual understanding of Designing and implementing an Azure Data solution. Experienced in generating Drilldown reports, Parameterized reports, Linked reports, Ad-Hoc reports, Sub reports and filters, charts. Good knowledge on data visualization and dashboard designing using Power BI. Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment. Experience in producing requirements documents, systems architecture and interfaces, data model diagrams, configuration management documents, and procedural manuals. Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures. Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes. Technical Skills: Operating Systems Windows, Linux, Mac OS Database Tools SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Analysis Service (SSAS) ETL Tools Data Transformation Services (DTS) Export/Import, SQL Server Integration Service (SSIS), DataStage Reporting Tools SQL Server Reporting Services (2016/2017/2019), Power Pivot, Power BI Programming T-SQL, C, C#, LINUX (Shell Scripting), .NET, Python Database MS SQL Server 2016/2017/2019 , MS Access, Oracle 11g/10g/9i/8i Professional Experience: Client: Travelers Insurance, Boston, MA May 2023 to Current Role: SQL/BI Developer Responsibilities: Involved in collecting requirements, transforming them into logical and physical database designs. Design, Implement and maintain Database Schema, Entity Relationship Diagrams, Data modeling, Tables, Stored procedures, Functions, Triggers, Constraints, Indexes, Functions, Views and complex SQL statements. Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc. Designed Table, matrix, sub reports and linked reports by using SQL server reporting services (SSRS) and deployed in production server. Generated reports from the cubes by connecting to Analysis server from SSRS. Works with data modelers to prepare logical and physical data models, adds and deletes necessary fields using Erwin. Created packages that transfers databases from one SQL Server instance to another instance and scheduled the SSIS package for migration of data from old system to MS SQL 2016. Migrated data from heterogeneous data sources (Data mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints. Automated and enhanced daily administrative tasks, including space management, backup and Recovery and performance monitoring. Performed ETL operations to support the data loads and transformations using SSIS and used SSRS for generating reports to end-users. Develop multidimensional data marts for financial analysis and reporting Created data warehouse objects, such as dimension tables, views and stored procedures. Developed SSIS packages for the data migration. Developed and implemented SSRS reports with multi-parameter, chart, sub-reports, and interactive capability Implemented role-based access control model to secure the reporting system. Wrote T-SQL queries and stored procedures for ad hoc reports to access data from internal and external applications. Worked on all the new updated features Conditional formatting, multi-select data points across multiple pages in Power BI. Developed custom calculated measures using DAX in Power BI to satisfy business needs. Assisted in gathering business and technical requirements for data warehouse architecture, Data models, Stored Procedures, SSRS and Power BI reporting and working on the development of transformation of data from the relational database to the data warehouse. Experienced working on Star and Snowflake Schemas and used the fact and dimension tables to build the cubes, perform processing and deployed them to SSAS database Scheduling the jobs for executing the stored SSIS packages, which were developed to update the database on daily basis using SQL server agent. Assisting Analytics team with various Data Modeling tasks Developed Database Triggers to enforce Data integrity. Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables. Participated in the end-to-end implementation planning including project management, issue management, communication and change management. Environment: SQL Server 2016, Power BI, Excel, Power Pivot, T-SQL, SSIS, SSAS, SSRS, Visual Studio Client: Legal & General Investment Management America, Chicago, IL August 2022 April 2023 Role: Sr. ETL/SQL Server/BI Developer Responsibilities: Created tableau reports for in-house applications to facilitate accurate prices for clients. Involved in gathering requirements from business and translating them into technical requirements for development. Developed SSIS packages to load data from various sources and automated them for daily retrieval using One Automation (UC4 Scheduler). Maintained and modified existing SSIS packages to resolve performance issues. Developed packages to load historic data from different formatted files into tables and created reports using SSRS and Tableau. Worked on collaborating code with peers for code review using source control technologies like SVN and TFS. Developed SSIS packages to automatically retrieve data from various sources Involved in migrating Access applications to SQL server backend tables. Involved in creating generic packages to load the data from similar sources which are parameterized driven. Worked on documenting the workflow of an existing process for IT Application Support team. Developed wpf application using C# Telerik UI services including documentation and supporting. Environnent: SQL Server 2012/2008R2, SSIS, SSRS, SSAS,C#,Tableau. Client: HCSC / Accenture, India November 2018 June 2022 Role: MSBI Developer Responsibilities: Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task. Migrated data from heterogeneous data sources (Data mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints. Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations Worked with various SSIS packages which involve Transactions, restart ability and roll back techniques. Extracted data from various sources like MS SQL Server 2008, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the oracle database. Developed User Defined Functions for giving Scores and views for the Electronic health record applications. Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database. Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS. Wrote various Stored Procedures for application development. Tuned SQL statements (e.g.: using Indexes) and Stored Procedures Worked on replication of data (Transactional method used) Designed and implemented data access stored procedures and triggers for automating tasks. Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails. Excellent report creation skills using Microsoft SQL Server 2016/2012 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder and MS SharePoint. Created calculated fields and Key Performance Indicators (KPIs), perspectives and partitions with existing SSAS cube objects for better analysis. Implemented report manager to set up roles, security, and subscripts (data driven/standard) on the existing SSRS reports. Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard utilizing Power BI. Created Power BI Report which involves Schema Import, Implementing the business logic by customization. Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement. Created complex reports which involve a greater number of groupings and multi-value parameters. Experience in understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture. Created multiple reports with drop down menu option having complex groupings within the report. Environment: MS SQL Server 2008 Enterprise Edition, SSIS, SSRS, T-SQL, SQL Profiler, Erwin, OLAP, OLTP, Erwin, C#.NET, MS SharePoint, Visual Studio. Client: Sementic Information Technology Pvt Ltd, Bangalore, IND August 2014 October 2018 Role: SQL/Database Developer Responsibilities: Worked on ER Studio with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design. Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development. Created cubes and dimensions and measures and calculated measures according to the business requirements. Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database. Worked on T-SQL programming, reverse engineering, stored procedures development, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases. Developed various reports using SSRS, which included writing complex stored procedures for datasets. Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for several types of reports. Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables. Browsing the cube for analysis and validation of the data. Processing the cubes and dimensions daily using the SSIS tasks Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation, and implementation. Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server. Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS. Involved in deploying, configuring, and managing reports using Report Manager and Report Builder Formatted the reports using the Global variables and expressions. Performed job scheduling and alerts. Designed and implemented user log in and security. Resolved any deadlocks issues with the databases/servers on a real-time basis. Extracting the data from the various sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool. Scheduled the Reports to run on daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet. Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc. Environment: MS SQL Server 2005, SSIS, SSRS, DTS, SQL Management Studio, and SQL Server Business Intelligence tools, Windows 2003, SQL Server Query Analyzer, SQL Profiler, and Crystal Reports. Keywords: cprogramm csharp user interface business intelligence database active directory information technology microsoft Illinois Massachusetts