SUMMARY

• Overall 7 Years of experience in IT with primary skills on teh Analysis, Design, Development, and Support of Client/Server application using Microsoft SQL Server 2017/ 2016/ 2014/2012/2008 .
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) with good Knowledge on SQL Server Analysis Services (SSAS).
• Experience using Microsoft SQL Server and Microsoft Business Intelligence Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Desktop, Power BI Service, Power BI Mobile App, Gateways).
• Expert in ETL (SSIS) and DTS packages to perform data transfer from different server locations and heterogeneous sources like SQl server,Oracle, Excel, CSV, XML, MS Word and Text Format Data.
• In - depth knowledge of Transact-SQL (DDL, DML, DCL), Design and normalization of teh database tables and Relational Database Management Systems.
• Experience in working with Epic Clarity, Epic Reporting Workbench.
• Hands on experience in ETL process using different ETL tools and using PL/SQL to populate teh tables in OLTP and OLAP Data warehousing environment.
• Proficient knowledge of writing, modifying, and implementing Tables, Stored Procedures, Functions, Views, Indexes, Triggers, Cursors, Joins & User Defined data types.
• Experienced in building Data Integration, Workflow Solutions, and Extract, Transform, and Load (ETL) solutions using SQL Server Integration Service (SSIS).
• Expertise in SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report Security.
• Experience in Monitored database level and server level details which includes optimizing store procedures, and top high-level resource intensive queries.
• Proficiency in creating different types of reports such as Crosstab, Conditional, Drill-down, Drill-Up, Drill-through, Form, Lists, Sub reports, Matrix Reports and formatting them.
• Expert in presenting multi platform data visualization like pie/bar/graph charts and Geo spatial maps.
• Experience with different Visualization Table, Matrix, Bar, Heatmap, Card, Bubble chart, Maps, Gauge, Slicers, DAX and KPIs in Power BI.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experienced in building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2012/2008/2005 Analysis Services Business Intelligence (SSAS, SSRS).
• Hands on experience publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers, Web pages.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL and worked on Oracle partitioned tables and queries.
• Experienced in Logical Data Modeling, ER Modeling, Data warehouse design concepts,
• Dimensional Modeling using Star/ Snowflake Schemas, Normalized and De-Normalized Schemas with respect to query and analysis requirements.
• Experience in complete Software Development Life Cycle (SDLC).

TECHNICAL SKILLS

Database: MS SQL Server 2017/2016/2014/2012 , Oracle, DB2, MySQL

BI Tools: Power BI, Tableau, SSRS, Crystal Reports

ETL Tools: SSIS, Azure Data Factory, Informatica

SQL Server Tools: SQL Server Management Studio, Visual Studio, Business Intelligence Development Studio (BIDS), SQL Server Query Analyzer.

Scripting Languages: T-SQL, PL/SQL, HTML, XML, Java

Operating Systems: Windows XP/7/8, Linux

Other Tools: MS Office Suite, Toad, PL/SQL Developer, SVN, TFS, Azure Devops, Azure.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL/SSIS Developer

Responsibilities:

• Develop database using SQL and provide reporting support across Microsoft Product Suite including SSMS, SSIS, SSRS, SSAS, Azure etc.
• Leverage Microsoft SSIS, TSQL and related expertise to provide support to data warehouse developers, data analysts, and users in teh ETL migration.
• Develop new or existing data base components, optimize stored procedures and functions using T-SQL for data migration and SSRS report.
• Develop existing or new SSIS packages to transfer data from different source to SQL Server (2012 or higher) using Microsoft Visual Studio 2019 tool set.
• Develop Complex T-SQL Scripts, Procedures which are used in Reporting Services (SSRS).
• Involved in Performance tuning, troubleshooting, debugging of T-SQL queries to minimize execution time.
• Perform Execution plan, SQL Server profiler to trace teh slow running queries and Optimize SQL queries to improve performance and availability.
• Make recommendations on best practices for SSIS packages and Data Warehouse design in conjunction with Application Engineers, DBAs and enterprise data architects.
• Participate in peer code review sessions and provide hands on assistance in data modeling, technical implementation of products and practices.
• Ensure appropriate security structures and/or policies to data and/or database objects are applied and follow change and version control procedures.
• Collaborate with team members to validate data in teh data warehouse.
• Perform activities and documentation as applicable in accordance with methodologies such as Software Development Life Cycle (SDLC), Agile Development, Enterprise Performance Life Cycle (EPLC).

Environment: MS SQL Server 2017, SQL Server Integration Services (SSIS), SSMS, SSDT, Visual Studio 2019, T-SQL, MS Excel, Team Foundation Server (TFS).

Confidential, San Jose, CA

SSIS Developer

Responsibilities:

• Involved in (ETL) development requirements analyzing and documenting.
• Developed SSIS packages, used BIML code to generate packages using Microsoft Visual studio 2019 tool set.
• Extracted data from different sources like Epic Clarity, Oracle, MS Excel, Flat Files.
• Involved in creating complex T-SQL queries in ETL migration code.
• Migrated SSIS packages to server, Configured and Scheduled jobs for full load, delta load in DEV, TST and PRD Environment.
• Develop views, functions, stored procedures, and packages using T-SQL to transform data between source staging area to target staging area.
• Imported data from SQL Server DB toPowerBIto generate report with different kind of visualizations from In-built visualizations and from Market place.
• Created multiple kinds ofPower BIReports and Dashboards according to teh requirement.
• Created different visualization, custom visuals inPower BIaccording to teh requirements.
• Extensively used visual filters, page filters, report filters and drill through filters Power BI reports.
• Creating and developingPower BI Dashboards into rich look and configuring data gateways to have automatic refresh of teh dataset.
• Used SQL Compare to migrated required objects involved in ETL Migration from DEV to TST to PRD Environment.
• Involved in Capacity planning, Performance tuning, Disaster recovery, troubleshooting backup /restore procedures.
• Experience in handling in large data base including T-SQL coding, Full-text indexing, stored procedures.
• Involved in working extensively on SQL queries, stored procedures and functions.
• Generated HTML reports from SSIS server to validate daily ETL load and made necessary changes accordingly.
• Involved in code review sessions, collaborated with team members and provided valuable suggestions to improve performance of daily ETL.
• Involved in Troubleshooting, debugging, error handling using Microsoft Visual studio 2019 to reduce teh performance issue.
• Reviewed existing T-SQL, PL/SQL code, to identify issues and improved T-SQL process.
• Perform necessary QA testing and validation of SSIS processes, T-SQL and database objects.
• Experience in SSIS packages tuning techniques and methods.
• Involved in Writing ETL unit test case, execution and documenting.

Environment: MS SQL Server 2017, SQL Server Integration Services (SSIS), SSMS, Tableau, SSDT, Visual Studio 2019/2017, T-SQL, BIML Code, MS Excel, Redgate, Azure Devops.

Confidential, Portland, OR

Business Intelligence Developer

Responsibilities:

• Analyze Epic Data Sources such as Clarity and Caboodle to develop requirements for extracting data.
• Analyze and Develop Oracle PL/SQL Procedures and related database objects in teh ETL migration and support of teh Research Data Warehouse environment.
• Develop Complex T-SQL scripts in teh ETL migration for daily Incremental Tables.
• Build and migrate SSIS projects, T-SQL and database objects.
• Participate in peer code review sessions and provided suggestions dat improve performance, maintainability, and best practice in ETL.
• Developed High level reports and dashboards using Power BI from various sources like Excel, Web, Clarity Data base.
• Worked on calculated fields, DAX, KPI’s which are required in Power BI reports.
• Worked on view orientation, Sizing, layout, Color, Fonts, Tooltips, for building Interactive dashboards/reports.
• Publishes reports/dashboards on Power BI Service.
• Review and troubleshoot SSIS packages and T-SQL queries to address errors dat occur during nightly and ad hoc processing.
• Apply updates and ensure dat data are loaded into teh data warehouse according to defined requirements.
• Work with Research Data Analysts to establish test plans dat evaluate ETL performance and data quality of deliverables.
• Perform necessary QA testing and validation of SSIS processes, T-SQL and database objects.
• Assume responsibility for mitigating all issues discovered during teh QA process.
• Performed query and process tuning and optimization.
• Involved in code reviews, troubleshoot packages and resolved teh issues.
• Worked with other team members to implement data strategies, build data flows and develop data models.
• Collaborate with team members and analysts to validate data in teh data warehouse.
• Provided recommendations to team members on designing teh elements in reports and dashboards.
• Investigated and report on problems and work to ensure teh validity of teh data warehouse.

Environment: MS SQL Server 2017/2012, SQL Server Integration Services (SSIS), SSMS, SSDT, Visual Studio 2017/2015, Oracle PL/SQL, T-SQL, Power BI, MS Excel, Toad, PL/SQL developer, SVN, Team Foundation Server (TFS).

Confidential, Nashville, TN

SQL BI Developer

Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering,Technical Design, Testing and implementation of BI Analytics needs.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Designed high level ETL architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse.
• Extensive understanding of managing and automating Control flow, Data flow, Events and Logging for SSIS packages using Microsoft .NET framework.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance.
• Performed tuning of SQL queries and rewriting queries to improve teh performance of database.
• Develop views, functions, stored procedures, and packages using PL/SQL & T-SQL to transform data between source staging area to target staging area.
• Have migrated data from complex databases into power pivot add on in Microsoft excel and generated reports from them.
• Define best practices for Power BI report development.
• Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Power BI Server.
• Created multiple kinds ofPowerBIReports and Dashboards.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually.
• Configuredpackage logging, error loggingandevent handlingto redirect error rows and fix teh errors in SSIS.
• Generated reports using SSRS, Power Pivot, and Power BI dat could be used to send information to diverse group of users, clients, and managers.
• Involved in data base Architecture and models which are used in Power BI Model.
• Developed several detail summary reports including line and pie charts, trend analysis reports and pivot tables according to business requirements using Power BI, Excel and SQL Server.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Used third party tools like Pyramid to create Dashboards and ad hoc reports built on data from Cubes
• Developed teh New columns & Measures using Power Query and developed dashboards with different charts and published them in Power BI.
• Published reports and dashboards designed in Power BI by utilizing Power Bi Services and used Gateways for Scheduling dataset to refresh for upcoming data in Power BI server.
• Responsible for building Power BI Dashboards using Tabular Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• PublishedPowerBIreports fromPowerBIdesktop toPowerBIservice.

Environment: MS SQL Server 2016/2012, MS SQL Integration Services 2016/2012, Power BI, Reporting Services 2012/2008, Oracle PL/SQL, T-SQL, MS Excel, IBM DB2, SQL Server Agent, Visual Studio, Team Foundation Server (TFS).

Confidential, St Louis, MO

SQL BI Developer/SSIS/Power BI

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins.
• Involved in mentoring teh developers to follow teh guidelines of performance optimization.
• Scheduled SSIS Packages for loading Facts and Dimensions.
• Involved in making mappings and transformations using DTS Transform Data Task, Data driven query task.
• Worked with Epic Cogito Data Warehouse, Slicer Dicer and Health Catalyst Warehouse.
• Epic Clarity report in hospital and clinical data analysts and designs/testing.
• Dealt with huge amount of data and used SSAS in order to retrieve teh data.
• Worked with data extraction using SSIS and Data Warehouse staging, and loading.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing teh calculations to aggregate physical measures.
• Developed reports dat deliver data from cubes also created and managed subscriptions for teh reports.
• Defined specific read/process permissions for teh users in SSAS instance.
• Implemented user based security in SSRS reports to limit teh access of reports.
• Responsible for identifying and defining Data Source and Data Source views.
• Created SSIS packages to move data from oracle to SQL Server which involved using.
• Various transformations, developing SQL queries.
• Designed and deployed monthly sales reports for teh business users using SSRS.
• Design and develop reports and dashboards from Epic Clarity using SQL/SAS/Power BI.
• Created Epic Clarity Crystal and Reporting Workbench reports forTime users.
• Developed various Reports and Sub reports for Crystal Reports according to Business Requirements.
• Created Dynamic prompts and cascading list of Vales using BVM (Business View Manager) and used these dynamic parameters in various Crystal Reports.
• Involved in project planning sessions with project managers, business analysts, and team members to analyze business.
• Used report level filters, URL reporting using parameters passed by hyper links and report variables.

Environment: Windows XP, Clarity, SQL Server 2005 BI Suite, SSAS, SSIS, SSRS, Power BIT-SQL, MS Visual Studio 2005, and Crystal Reports.

Confidential, Woodbury, MN

SQL BI Developer

Responsibilities:

• Extensive T-SQL Development on SQL Server 2012 for evolving business requirements, enhancement to existing procedures.
• Wrote T-SQL code for creating cursor and handling teh data validations.
• Designed and implemented stored procedures and triggers for automating tasks.
• Migration of databases from SQL Server 2008 to SQL Server 2012.
• Also involved in working with Epic Clarity Database, to get in unlimited number of data which can be used in reporting.
• Created SSIS package to load data from Flat File, Excel and OLEDB to SQL Server 2012 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used custom .NET assemblies for Script Task in SSIS.
• Worked on Software Development Life Cycle (SDLC) involved in all stages of development Created different types of reports in SSRS such as parameterized and cascaded parameterized reports.
• Developed Slice and Dice Reports using Drill Downs and Drill Through, Sub Reports, Charts, Table.
• Created Reporting Framework for developing dynamic Sorts, filters, Optional Sorts, Sorts, and reporting Format option.
• Experience with teh Share point 2007 to upload teh SSRS reports into Web portal.
• Involved in analyzing Business requirement and System Requirement Documents to Design test plan.
• Participated in requirement gathering of teh cube design using SSAS.
• Used Analyzing Services to build teh data cubes using SSAS.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying teh data with MDX script.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: MS SQL Server 2014/2012/2008 , SSIS, SSAS, SSRS, Windows XP, SQL Profiler, T-SQL, PL/SQL, MS Office, Clarity, C#.NET, XML, MDX, Visual studio, Excel, SharePoint, Access, Team Foundation Server (TFS).

Confidential

SQL BI Developer

Responsibilities:

• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL and PL/SQL to provide definition, stricture and maintain data efficiently.
• Involved in rebuilding indexes to reduce apparent database complexity for end user and filtering bad data accordingly.
• Performance tuning of existing database objects including stored procedures.
• Designed SQL Server Integration Services (SSIS) packages to extract data from different sources to SQL Server Data Warehouse.
• Created SSIS packages for migration of database to MS SQL Server database from other database and source like Sybase, MS Access MS Excel, tetra data and Flat Files.
• Performing tasks of data conversions, lookups, adding derived columns, sending results in mails is done by making use of various tasks in SSIS for data cleansing and Auditing.
• Creating reports for users in different departments in organization using SSRS.
• Designed report models based on user requirements, explain and train users to use report builder to generate their own personalized reports.
• Scheduled reports for Daily, Weekly, Monthly Reports for various categories and regions based on business needs using Reporting Services (SSRS)
• Worked on various Visualizations by Utilizing Tree map, Slicer, Card, maps, pie, bar charts, Created KPI, Gauge, Clustered column chart, Slicers for a better understanding of teh report.
• Created and Modified Views, Stored Procedures and Functions for creating reports.
• Formatted reports using global variables and expressions in SSRS deployed generated reports on to Reporting server.
• Developed reports using complex formulas and to query database to generate different types of ad-hoc reports using SSRS.
• Support issues with reports on enterprise environments (Development, Test & Production).

Environment: SQL Server 2008 Enterprise edition, Oracle10g, PL/SQL, Power BI, SSDT, SSRS, SSIS, SSAS, SQL Server Profiler, MS Office 2010, MS Access and MS Windows Server 2008.