PROFESSIONAL SUMMARY:

• As a Certified SQL developer having around 7 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2018/2017/2016 /2013/2012 in Development, Test and Production Environments with various business domains.
• Proficient experience in Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.
• Expertise in SQL Server 2017 Analysis Services (SSAS) to deliver online analytical processing (OLAP) and online analytical transactional processing (OLTP) data mining functionality for business intelligence applications
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)
• Expertise in designing SSIS packages to import and transform data between databases and externaldata sources using various transformations
• Experience in configuration and maintain report manager and reportserver for SSRS, Deployed and scheduled the reports in report manager
• Experience in generating reports using SQL Server Reporting Services (SSRS), Crystal Reports, WEBI Reports and MS Excel spreadsheets and Power Pivot.
• Experience in working with slowly changingdimensions (SCD) Type - I, Type-II and Type-III .
• Validating data files against their control files and performing technical data quality checks to certify source file usage.
• Experience in performance tuning of Informatica mappings and sessions to improve performance for the large volume projects .
• Experience in Assisting other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-dayETLprogress monitoring
• Experience in creating Views, Constraints, Triggers, Joins, Cursors, TempTable, Table Variable, Functions, Batch Scripts and numerous stored procedures consumed at various stages of migration/cleansing process, reports or data validation
• Generated Tableau visualizations and dashboards using tableau desktop. Generated Dashboards with Quick filters, parameters and sets to handle views more efficiently
• Experience in Built dashboards using techniques for guided analytics, interactivedashboard design, and visual best practices.
• Involved in troubleshooting of performance issues which were associated with Tableaureports.
• Strong Communication and Management Skills with excellent role-playing capabilities.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development.

TECHNICAL SKILL:

Databases: MS SQL Server 2018/2 /2012, Business Intelligence Development Studio, SQL Server Profiler 2017, Azure Data Studio, Oracle 12C

BI Tools: Data Transformation Services (DTS), SSIS, SSRS, SSASTableau, Microsoft Visio and Power BI

Programming: TSQL, PLSQL and Oracle Data Warehouse

Star and snow: Flake Schema Modeling, Fact and dimensions, physical and logical Data Modeling

Dev/ Reporting tools: TOAD, TFS, JIRA, MS Word, MS Excel, MS Power point, MS Outlook, MS Access

Operating Systems: Windows 2012/2008/2003 , Mac, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Woodlands, TX

SQL/Power BI Developer

Responsibilities

• Responsible for gathering business requirements, SDLC Process, designed data maps and data models. Created Functional Design Documents and Transaction Definition Documents
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema
• Documented and maintained database systemspecifications, diagrams, and connectivity charts.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS. Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets. Created the design and technical specifications for the ETL process of the project.
• Involved with Query Optimization to increase the performance of the Report.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application
• Developed Physical data models and created DML scripts to create database schema and database objects
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts
• Implemented Incremental load, used Event Handlers to clean the data from different data sources
• Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
• Responsible for creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications
• Spearheaded a project to implement company standards and establish procedures to ensure a unified data management approach.
• Created stored procedures and SQL queries to pull data into power pivot model. Worked on alltypes of transformations that are available in Power BI query editor
• Created all kind of reports such as Yearly, Quarterly, Monthly, and Daily.Expertise in writing complex DAX functions in PowerBI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler
• Wrote calculated columns , Measurequery’s in power bi desktop to show good data analysis techniques
• Experience in Performance Monitor/SQL Profiler to solve dead locks/long running queries.
• Developed Parameter files for passing values to the mappings for each type of client
• Performed day-to-day Database Maintenance tasks including Database Monitoring, Backups, Space, and Resource Utilization.

Environment: s: SQL Server Management Studio 2018/2017, JIRA, TFS, Visual Studio 2015/2013, SSIS, Reporting Services (SSRS2015/2010), MS Office 2015, Power BI tools, Azure Data Studio, SQL Profiler

Confidential, Bellevue, WA

SQL Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Reduced the timeline of individual migration projects by several months through optimization and documentation .
• Collaborated with the engineering department on improvements to the migration software .
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services SSIS environment. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created DTS packages to copy tables, schemas, views and to extract data from Excel using SSIS.
• Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers& maintaining Referential Integrity.
• Hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Experience in troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Developed a 360-business dashboard with multiple panels and parameters that became a driver for sales force team.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Environment: s: SQL Server 2017/2016, Toad Data point, Tableau, SSIS, Erwin, OLTP, OLAP,Performance Point Sever, Windows server, MS Excel2015/2013

Confidential, Irvine, CA

SQL Developer

Responsibilities:

• Designed and implemented SSIS packages to migrate data from heterogeneous data sources to staging database and load the data to data warehouse or data marts.
• Excellent report creation skills using Microsoft SQL Server 2017 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder
• Created T-SQL queries, complex Stored Procedures, User-defined Functions, designing and implementing of Database Triggers (DDL, DML), Views and designing and implementing Indexes.
• Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.
• Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Excellent report creation skills using Microsoft SQL Server 2017 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder
• Generated occasional reports in view of the factual investigation of the information utilizing SQL server Reporting services (SSRS)
• Worked on other packages of the SQL server 2017 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).

Environment: s: SQL Server-2017/2016, SSIS, SSAS, TFS, Visual Studio (2015/2013), Reporting Services (SSRS 2015/2013), T-SQL, DTS, SQL Profiler , Office-2017, MS Excel

Confidential, Morris Plains, NJ

SQL developer

Responsibilities:

• Experience in Troubleshooting Report Processing, Subscription, Delivery and ConfigurationProblems.
• Experience in T-SQL Scripts and stored procedures to implement the business needs and to support the frontend application.
• Used the SSIS Import/Export, relocated the Heterogeneous Database, for example, Oracle and Access database, level documents to SQL server 2008.
• Designed ETL SSIS packages for data migrations, alerting notifications for various processes and developing automation process for efficiency purposes
• Created user variables, property expressions, script task in SSIS. Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Migrated data from SAS environment to SQL Server 2017 with SQL Server Integrated Services (SSIS).
• Migrated DTS objects to SQL Server Integrated Services ( SSIS) environment. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications
• Hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Experience in designing dashboards and reports, parameterized reports, predictive analysis in Power BI.
• Deployed and managed users’ permissions for reports and dashboards on Power BI web portal.
• Introduced Power BI after presenting POCs to the higher management.
• Created complex Power BI reports and dashboards to show the current and historical data.
• Created DAX Queries to generated computed columns in Power BI.Generated computed tables in PowerBI by using DAX.
• Designed Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge , funnel, line better business analysis

Environment: s: SQL Server 2015/2013, SSIS, Visual Studio 2013/2010, SFTP, OLAP, OLTP , Erwin, SQL Agent Profiler, Power BI

Confidential

SQL Developer

Responsibilities:

• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Designed ETL SSIS packages for data migrations, alerting notifications for various processes and developing automation process for efficiency purposes.
• Created logs for ETLload at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Created data models with Report Builder to provide a template for end-users for creating reports by themselves with pre-selected group of relational tables
• Built SSRS project to generate reports with desired forms (Webpage, PDF, and Excel etc.) to present statistics information according to business requirement.
• Generated Sub-Reports, Cross-tab, Conditional, drill down anddrill through reports and Parameterized reports using SSRS 2008.
• Created reports using Global Variables, Expressions and Functions using SSRS 2008.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.

Environment: s: SQL Server 2012/2008, SSIS, Reporting Services (SSRS 2012/2008), Windows 2010/2008, MS Office 2010/2008.