SUMMARY

• Have 9+ years of experience in MS SQL Server Database Design and Programming using Transact SQL
• Have 3+ years of experience in Power BI.
• T - SQL (DDL, DML, and DCL) developer and extensive experience in analyzing, designing, implementing, and debugging T-SQL and creating DB Objects.
• Proficient in designing/building complex stunning reports/dashboards using Filters (Slicers), Drill-down Reports and Ad Hoc reports inPower BI Desktop.
• Good in writing DAX queries/expressions in Power BI Desktop.
• Sound knowledge on Creating Calculations, Advanced Calculations, Parameters, slicer, and interactions in Power BI.
• Experience in BI Development and Deployment of SSIS packages.
• Worked on Huge data migrations, transfers using utilities likeData Transformation Services (DTS), and SSIS.
• Implementation of logging, configurations and Error handling, Checkpoint, Transactions in SSIS packages.
• Working with SQL Server Job scheduling to execute Integration Services packages and to send reports to the client.
• Experience in Importing/Exporting Data from various heterogeneous data sources to SQL server using transformation of OLTP data to the Data Warehouse using SSIS.
• Experts in generating drill through reports, drill down reports, parameterized reports, linked reports, sub reports, table, matrix, charts in SSRS.
• DesigningandDeployment of Reportsfor the End-User requests usingSSRS.
• Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in Power BI server.
• Creating interactions of Highlight Action, Filter Action add interactivity to the visualizations.
• Extensive experience on building dashboards, advanced dashboards using Power BI Expertise in creating Storyboard with all the Dashboards.
• Proficient in Product Integration, Systems Migration, Process and Performance Tuning & Query Optimization.
• Result driven professional with hands on experience of development and maintenance of RDBMS systems.
• Strong Communication & Management skills with Excellent Role-playing capabilities.
• Capable to handle workload and work pressure effectively and passionate towards Application Development.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2014/2019 , MySQL, MS Access.

ETL Tool: BIDS, Microsoft Visual Studio.NET 2016/2014/2012/2008 , SSIS

Reporting: Power BI, SSRS, MS-Excel

PROFESSIONAL EXPERIENCE

Confidential

Senior Software Developer

Responsibilities:

• Involved in requirements gathering from the Scratch.
• Extensively worked on designing DB objects keeping in view of future needs as well as performance and written complex queries that meet the business needs. (Adhoc Queries, Types, Rules, Tables, Constraints, Indexes, Functions, Views, SP, Triggers, Logins, Users, Roles etc…)
• Created Business-Crucial stored procedures, views and functions to support efficient data storage and manipulation.
• Worked on Creation, Development and Deployment of SSIS packages in SQL Server.
• Scheduling the daily maintance actives in SQL Agents Jobs.
• Responsible for Designing, Creating and Managing DB objects and identifying the performance bottlenecks and involved in re-engineering efforts.
• Handled the issues in existing system and ensured a stable state is maintained and handled the re-architect of certain DB Objects for efficient data storage and manipulation.
• Responsible Create stunning reports and visualizations designing/building complex stunning reports/dashboards using Filters (Slicers), Drill-down Reports and AdHoc reports inPower BI
• Responsible Import, reshape and model the data.
• Responsible for schedule the dashboards according to frequency (daily, weekly).
• Involved in database design of Integrated demand tracker tool.
• Created Forms using Microsoft Access for Integrated Demand Tracker.
• Created Initiatives,Stories and Tasks in JIRA.
• As per the requirements, Updated the projects in JIRA.
• Generating Planview reports.
• Created Clocker Report of resources and their projects.
• Working on Global Weekly Report on Weekly Basis.
• Generating different types of reports for Individual Sectors.

Confidential

Senior Database Developer

Responsibilities:

• Involved in data migration activities from different data sources.
• Involved in analyzing the data and creating scripts to make the source data fit into destination schema.
• Involved in DB Designing for new enhancements of Products.
• Worked on Creating Stored Procedures and other DB objects that fits into Business Model.
• Generated the Drilldown Reports, Drill through reports and Sub reports.
• Worked on Creation, Development and Deployment of SSIS packages in SQL Server.
• Scheduling the daily maintance actives in SQL Agents Jobs.
• Developing parameterized reports including multi-parameters.
• Database tuning and performance monitoring.
• Efficient use of Event Handlers and Custom Logging.
• Publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in Power BI server.
• Developing and deploying of Power BI reports.
• Creating Calculations, Advanced Calculations, Parameters, slicer and interactions in Power BI.
• Responsible Create stunning reports and visualizations.
• Responsible for providing the securities for reports/dashboards by assigning roles.
• Scheduled backups and restore operations in Maintenance plans.

Confidential, Michigan

Senior Developer

Responsibilities:

• Created reports, simple and complex including conditional formatting, prompts, and reports.
• Extensively working in Data Extraction Transformation and loading from source to target system using SQL Server 2008 Integration Services.
• Importing source/target tables from the respective data base by using execute package task using control flow tasks in SQL Server 2008.
• Gathering data from diverse groups and converting them into detailed logical flow Charts and specifications for business solution.
• Generated the Drilldown Reports, Drill through reports and Sub reports.
• Generated the Reports weekly, monthly, Quarterly and yearly basis as per the client requirements.
• Preparing dashboards and matrices reports from various sources.
• Worked on Creation, Development and Deployment of SSIS packages in SQL Server.
• Importing source/target tables from the respective database by using execute package task using control flow tasks in SQL Server Integration Services.
• Developing parameterized reports including multi-parameters.
• Database tuning and performance monitoring.
• Efficient use of Event Handlers and Custom Logging.
• Extensive knowledge on Report Manager Properties.
• Scheduled backups and restore operations in Maintenance plans.

Environment: SQL server, SSIS, SSRS, and Import/Export tools, SQL Server Agent, T-SQL.

Confidential

Senior Developer

Responsibilities:

• Extracted data from various sources like SQL Server, DB2, and Text file from Client servers and through FTP.
• The packages created included a variety of transformations like Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Generated the Drilldown Reports, Drill through reports and Sub reports.
• Generated the Reports weekly, monthly, Quarterly and yearly basis as per the client requirements.
• Worked on Creation, Development and Deployment of SSIS packages in SQL Server.
• Importing source/target tables from the respective database by using execute package task using control flow tasks in SQL Server Integration Services.
• Developing parameterized reports including multi-parameters.
• Database tuning and performance monitoring.
• Efficient use of Event Handlers and Custom Logging.
• Extensive knowledge on Report Manager Properties.
• Scheduled backups and restore operations in Maintenance plans.

Environment: SQL server, SSIS, SSRS, and Import/Export tools, SQL Server Agent, T-SQL.