SUMMARY

• Around 9 years of IT Experience in Database Design, Development and business intelligence of Confidential SQL Server 2016/2014/2012/2008 in Development, Staging and Production Environments on various business domains like Financial, Insurance, Manufacturing and Healthcare.
• Experience in Data Modeling, Database Design, SQL Scripting, Development and Implementation of Client - Server & Business Intelligence (SSIS, SSAS, SSRS) applications.
• Hands - on experience in Azure Cloud Services (PaaS & IaaS), Azure Synapse Analytics, SQL Azure, Data Factory, Azure Monitoring, Key Vault, Azure Data Lake, Cosmos DB.
• 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.
• Experienced in managing and automating Control flow, Data flow, Events.
• 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.
• Hands on working knowledge with various AWS services like EC2, S3, VPC, Aurora, DynamoDB.
• Hands on technical understanding about various Azure core services like Compute, Networking, Storage, Database etc.
• 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.
• 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 (2014/2012/2008 ), Power Pivot, Power BI

Programming: T-SQL, C, C#, LINUX (Shell Scripting), .NET, Python

Database: MS SQL Server 2016/2012/2008 , MS Access, Oracle 11g/10g/9i/8i

PROFESSIONAL EXPERIENCE

Confidential

Azure/SQL BI Developer

Responsibilities:

• As part of Data Platform team, was responsible for developing and optimizing standard data operations related to Office 365 and other Confidential services.
• Created and Modified SQL Server stored procedures, views, ad-hoc queries for handling business logic.
• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions
• Involved in migrating existing SSRS reports to Power BI for Partner business teams, to provide visible data for reporting.
• Actively worked on auditing and back tacking existing data flow related to FastTrack Services in production databases to make the flow more dynamic.
• Identified unused objects in production databases and moved them to back up schema before deleting them, which helped mitigate space constraint.
• Designed, and developed interactive dashboards and other automated reporting in Power BI
• Worked on POC and implementation of a new process related new Office 365 sub metrics, to automate data loading process in a database, with the help of metadata table.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Monitored, produced and consumed various datasets of Azure Data Factory for various transformational activities.
• Created Triggers, linked services and Integration runtimes related to ADF pipelines.
• Interactively analyzed logs using Kusto in Log Analytics workspace.
• Performed optimization analysis and created a process to identify the unused objects from various databases. This job runs daily to capture updated metrics of the objects and the results are displayed using a PBI dashboard.
• Created staging objects required to load FY21 Office Metrics.

Environment: T-SQL, Azure Data Factory, Cosmos DB, Azure SQL, Azure Synapse Analytics, Blob Storage, Azure Data Lake, PolyBase, Log Analytics, Visual Studio, SSMS, TFS, Power BI, SSRS.

Confidential, Phoenix, AZ

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.
• Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code.
• Performed ETL operations to support the data loads and transformations using SSIS and used SSRS for generating reports to end-users.
• 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.
• 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.

Environment: SQL Server 2016, Power BI, Excel, Power Pivot, T-SQL, SSIS, SSAS, SSRS, Visual Studio

Confidential, Chicago, IL

T-SQL/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.
• Excellent report creation skills using Confidential 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 PowerBI.
• 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- 2016/2012/2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, SQL Profiler, Power BI, Erwin, OLAP, OLTP, Erwin, C#.NET, MS SharePoint, Visual Studio.

Confidential, Houston, TX

SQL BI Developer

Responsibilities:

• Worked 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, stored procedures, 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.
• 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: SQL Server 2014/2012, Business Intelligence Studio (SSAS, SSIS, SSRS), MS SharePoint, T SQL, Erwin, TFS, Oracle 10g, MS Excel.

Confidential, Green Wood, CO

SQL Server/SSIS/SSRS Developer

Responsibilities:

• 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.
• Participated in theend-to-end implementation planning including project management, issue management, communication and change management.
• Wrote T-SQL queries and stored procedures for ad hoc reports to access data from internal and external applications.
• Assisted in gathering requirement for reporting and working on the development of transformation of data from the relational database to the data warehouse.
• Scheduling the jobs for executing the stored SSIS packages, which were developed to update the database on daily basis using SQL server agent.

Environment: SQL Server 2008 R2, SSIS, SSRS, Management Studio, DTS, MS Excel, T-SQL, Power Point

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Developed User Defined Functions for giving Scores and views for the application.
• 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.
• 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.

Environment: SQL Server 2008 R2, SSIS, SSRS, Management Studio, DTS, MS Excel, T-SQL, Power Point