SUMMARY

• Highly motivated SQL Server/BI Developer with 9 Years of IT Experience in Database and Business Intelligence Technologies with expertise in SQL Server Development and Reporting using SQL Server 2014/2012/2008 , SSRS and SSIS.
• Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions, Cursors and Indexes using T - SQL.
• Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key, Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
• Experienced in Agile SDLC for Design, Development and Staging phases of the projects
• Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling.
• Expert in designing (development) and deployment of SSIS package from various sources like MS access, oracle, Excel, Microsoft SQL server, flat file, and XML.
• Uses different set of ETL tools like AWS Glue (Python/Scala), Matillion for Redshift, Informatica Power.
• Power Bi Expert with 7 years of experience in creating complex reports and dashboards using advanced DAX. Extensively using Power Bi suit for Extracting data from different sources and created attractive visualizations.
• Expertise in Power Bi Desktop and power Bi Service.
• Expertise in constructing T- SQL and Oracle PL/ SQL Tables, Stored Procedures, Views, Functions, Packages, Triggers, Cursors, Indexes, User Defined Data Types, Constraints to facilitate efficient data manipulations as per the business rule.
• Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
• Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, cleaning bad data, validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
• Working knowledge of Relational Database Management System (RDMS), Data Warehousing, OLTP, OLAP, Data Migration and Data Analysis using SQL Server Business Intelligence solutions (SSIS, SSAS, SSRS).
• Created and maintained DB on OCI platform.
• Extensively involved in design of AWS servers of test and UAT environment and designed the ETL data model based on the existing database table structures.
• Experience in debugging the SSIS packages using breakpoints and checkpoints.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SSRS and Power BI.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Conceptual/Logical/Physical Modeling using 3NormalForm (3NF), Star Schema modeling, Snowflake modeling using tools like Erwin, ER-Studio, SAP Power Designer
• Worked on creating Redux Reducers, Actions and Epics for the angular components using Ng Redux.
• Strong experience in developing parameterized, Sub Reports, Matrix Reports, Charts, Drill down, Drill Through reports, using SQL Server Reporting Services (SSRS).
• Experience in performance tuning in SSRS Report by using different methods.
• Excellent knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS).
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar Graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and Global filters according to the end user requirement.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

TECHNICAL SKILLS

Operating Systems: Windows2010, 2008, 2007, 2003R2, 2003, 2000Advanced Server, Windows NT, Unix.

RDBMS: MSSQL SERVER 2016/ 2014/2012/2008 R2/2008.

BI TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ETL, Self BI with Excel, Tableau.

Languages: C, C#, T-SQL, .Net, Dynamic SQL.

Database Query Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Visual Studio 2013/2015/2017 , SQL Profiler, DQS

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL/ BI Developer

Responsibilities:

• Expertise in analysis, design, and development of end to end business intelligence solutions using the MSBI suites such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) & SQL Server Reporting Services (SSRS).
• Implemented and enhanced existing reports like Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multi-Value Parameters in SSRS.
• Perform database development that includes Schema development, Stored Procedures that could be used by different Windows Services.
• Responsible for Creating and maintaining various database objects like stored procedures, Triggers, Tables, views and user defined functions using SSMS.
• Documented technical requirements and project templates based on agile methodology
• Used SSIS variables, parameters, & expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Send Mail, Row Count, Script tasks, etc.
• Monitored and maintained existing ETL packages and Reports to fix issues and bugs and troubleshooting.
• Published reports into Power BI publisher and schedule the data sets, providing row level security.
• Created Dashboards with different style using Power BI components like Pie charts, Bar charts, Line charts, KPI Visuals, Custom visuals, etc.
• Creating Row level security with power bi and integration with power bi service portal.
• Created and maintained DB on OCI platform.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle DB etc.)
• Maintained Data warehouse, Created ETL Jobs, Created new database objects and SSIS Packages.
• Developed the PL/ SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Worked on data modeling using SAP Power designer and Erwin modeling tools.
• Expertise in using Cloud based managed services for data warehousing in Microsoft Azure ( Azure DataFactory, Azure Table Storage, Azure Blob storage etc.)
• Created reports, dashboards, line charts using Tableau Desktop 2018/2019 live and extract data modes.
• Designed Informatica transformations for loading data from various sources like flat files/ OCI/ODBC sources.
• Developing SSRS reports on SQL Server and have very good understanding of SSAS, OLAP cube and Architecture.
• Responsible installation and configuration of SQL Server 2017, SQL Server Management Studio ( SSMS), Microsoft Visual Studio 2017 and SQL Server Data Tools
• Managed security groups on AWS, focusing on high-availability, fault-tolerance, and auto scaling using Terraform templates.
• Maintained SQL Script for creation of Database Objects.
• Implemented the business rules in writing Oracle PL/SQL functions and procedures
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Creation of Matillion Jobs for Redshift to process multiple source systems data into S3, to process all S3
• Construct a powerful and modern front-end architecture involving ReactJS, React-Router, Redux, ES2015, Webpack, and Babel that is supported by APIs
• Provided application support to reports development across Business Intelligence which includes MSBI,SAP BW / BPC and Tableau
• Develop and maintain a real-time streaming pipeline in the Microsoft Azure platform to schedule, monitor and manage copy and transform activities via VS-2015/2016, Azure portal.
• Created various MSBI(SSIS) packages using data transformations like Merge, Aggregate, Sort, Multicasting, Lookup, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, transformation of XML based on XSD File Experience with designing the ETL process, including data read/write, data transformations, error handling, process design, logging, and Development.
• MDX Coding and MDX object modeling using analysis services.
• Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS
• Creation of ETL packages to load data from files into database by performing different kinds of transformations using SSIS.
• Created Apache Directory Server for local network and Integrating RHEL instance with Active Directory in AWS VPC.
• ETL for loading data from azure Data Lake to Azure DW using Data factory and SSIS.
• Utilized the Agile Scrum methodology to analyze the requirements to create stories
• Active participation in designing dashboards including the design of the data warehouse tables, Source to Target ETL logic and dashboard development.
• Monitor and recommend changes if required, to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
• Built, published and customized interactive reports and dashboards, report scheduling using Tableau server.
• Interpret data, Visualization and analyze results using statistical techniques and provide ongoing SSRS reports.
• Involved in performance tuning of T- SQL queries and PL- SQL blocks.
• Extract Data into SQL server and Hadoop environment to Azure warehouse using Azure data factory and to on-premise SQL data warehouses.
• Developing customized reports by using SAP Crystal reports 2013 tool and publishing to Bobj and maintaining the reports.
• Used latest web technologies ECMAScript 6, Redux, Babel, and Web-Pack to create a SPA.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Involved in writing SQL batch scripts. Write T-SQL statements for retrieval of data and involved in performance tuning of T SQL queries and stored Procedures.
• Performance tuning and optimization of procedures and queries and Involved in the tuning of the existing Database Objects.
• Created highly Complex Reports using OLAP CUBES as Data Source for Multi-Dimensional Analysis.
• Used Matillion ETL connects to data sources,
• Designed ETL packages to load the data from staging server to Data marts on Data warehouse.
• T-SQL development included queries using joins, sub queries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, constraints, and Database triggers.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query), Web Trends to Power BI and generate reports with different visualizations.
• Involved in development & amp; Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in Tabular Datawarehouse and DAX operations for SSAS OLAP databases.
• Involved in code review and preparing unit test cases.
• Generated Custom ETL scripts using SSIS 2005 and develops and unit test SSIS load processes for performance check.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Creating SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Responsible for building complex reports in PowerBI from the Scratch and migrating from SAPBO.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Extensive reporting skills using SQL Server Reporting (SSRS).
• Created Data Models for each module of the current OLTP system and participating in the brain storming session to nail possible design challenges.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Worked on TFS for performing tasks.

Environment: Windows Server 2012 Operating System, AWS, OLAP, MS SQL Server 2016, SQL Server Data Tools for Visual Studio 2015 (SSIS), SSMS, PL/SQL, Tableau Desktop 2018.1/2019.1 , Redux, Azure, SSRS, Matillion, Agile, .Net Framework, Azure Data Factory, SAP Power, C#, Oracle, Scrum DAX, TFS, FTP, SharePoint, MS Visio, Excel PowerPivot, MS Excel 2010/2013.

Confidential, Newark, DE

Sr. SQL/ BI Developer

Responsibilities:

• Performed fine tuning of stored procedures and SSIS packages.
• Generated SQL queries for the reporting team.
• Written stored procedures which are used in the source for SSIS packages.
• Created extracts which generate file names dynamically using SSIS.
• Created complex Stored Procedures, Tables, Views, SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Using azure data factory to design logic app for processing analysis service cubes
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Experience in report writing using SQL Server Reporting Services ( SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional Table, Matrix, Chart and Sub Reports.
• Developed mappings in Informatica using BAPI and ABAP function calls in SAP Power.
• Hands on experience on Matillion ETL tool in building data pipelines
• Created Terraform modules to create instances in AWS & automated process of creation of resources is AWS using terraform.
• Developed Ad hoc reports using SQL, PL/ SQL, and UNIX to fulfill business analysts, Operations Analysts, and Financial analyst's data requests
• Responsible for Creating and maintaining various database objects like stored procedures, Triggers, Tables, views and user defined functions using SSMS.
• Drill through features for reporting from source data which created the OLAP data.
• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.
• Experienced in slowly changing dimension in SSIS packages.
• Worked on the performance tuning of the data warehouse and modified the procedures and tables to enhance the performance of the data warehouse.
• Created and maintained DB on OCI platform.
• Wrote SQL scripts to Insert, Update and Delete data in MS SQL database.
• Followed the AGILE methodology for the entire "SDLC".
• Involved in performance tuning of T- SQL queries and PL- SQL blocks.
• Created highly Complex Reports using OLAP CUBES as Data Source for Multi-Dimensional Analysis.
• Performed Tableau Server admin duties; added users/groups from Active Directory; and scheduled instances in Tableau Server including weekly data dump.
• Loaded fact and dimension tables as part of modified data warehouse solution.
• Expertise in constructing T-SQL and Oracle PL/SQL Tables
• Deployed SSRS reports into Report Server and managed reports subscriptions, delivery, generation, rendering in Report Manager.
• Working with Marketing Automation Team to provide clean and quality data using Matillion
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Was involved in the Design of Data Modelling and Implementation of database design.
• Created SSIS Packages to load data from sources like Excel (.xls, .xlsx), Flat Files, .csv files.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards.
• Extraction of data from multiple sources like Flat files, CSV, XML, SAS, TEARADATA, SAP and SQL databases and Sales force using REST API.
• Extensively used DAX functions like SUM, MIN, AVG, COUNTROWS, DISTINCTCOUNT, IF, OR, SWITCH, ISFILETERD, ISCROSSFILTERED, CALCULATE, CALULATETABLE, ALL, VALUES, SUMMARIZE, ADDCOLUMNS, ROW in Power BI and Tabular reports.
• Created various Documents such as Source-to-Target Data mapping Document, and Unit Test Cases Document.
• Scheduling the SSIS packages by creating a Job using SQL Agent in SSMS.
• Generated Dynamic Reports from Cubes (SSAS) using SSRS 2012.
• Performed Unit Testing and tuned for better performance.
• Automated data warehouse build including AWS infrastructure and Matillion process flows.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically.
• Extensively used custom R-Visuals, Clustered Bar Charts, Clustered Column charts, Donut Charts, Hierarchy slicers, Waterfall charts, Scatter charts, Area charts in power BI reports.
• Involved in creating robust complex power BI models, writing complex DAX logics involving rank, filters and data massaging.
• Worked with visual filters, page filters, report filters and drill through filters in power BI reports.

Environment: MS SQL Server 2014/2012/2008 , SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), OLAP, PL/SQL, SSMS, .Net Framework, C#, Azure, Tableau, AWS, Matillion, Oracle, Business Intelligence Development Studio (BIDS), SAP Power, Azure Data Factory, MS Excel, Windows XP, Power BI, DAX.

Confidential, TX

SQL BI Developer

Responsibilities:

• Collaborated and coordinated with business analysts to gather requirements for implementing data mart.
• Created required SQL procedures, functions, triggers, and views to supports OLTP and ETL application.
• Worked with various SSIS control flow tasks and data transformations like Data conversion, Derived, Column, Look-up, Fuzzy Look-up, Conditional Split, Aggregate transformations etc. as part of ETL.
• Created Event Handlers, Package Configurations, Logging, System and User-defined Variables Incorporated control for solution source control, project coordination, and task management.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS.
• Wrote various reporting queries for Billing, Accounts Payable, Claims, and Customer Service.
• BI team is responsible for development, enhancement & maintenance of various internal and external reports/applications to support claims, members, providers, compliance related processes.
• Review and conversion of existing SAP BW code and implement in Azure Database using SQL and stored procedures.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Migrated data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure data factory and experience with Data Lake.
• Developing SSRS reports on SQL Server and have very good understanding of SSAS, OLAP cube and Architecture.
• Migrated SAP BW Metadata to Azure Database systems.
• Configured the cloud databases for HA solutions with Geo-replication.
• Designed and developed various analytical Dashboards from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Parameters, customized Calculations, Conditions, Groups, Sets, Bins, Context filters for various analytical reports and Dashboards.
• Generated context filters and data source filters while handling huge volume of data in Tableau.
• Created Tableau dashboards with Hierarchies, interactive views, drill downs with user level security.
• Experience in creating different visualizations using charts like Bars, Lines and Pies, Maps, Scatter plots.
• Developed Tableau workbooks to perform year over year, quarter over quarter type of analysis.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop and published them to server.
• Designed a database optimization plan like creation of table partitions and the use of appropriate Indexes.

Environment: Microsoft SQL Server 2012, SSRS, SQL Server Integration Services (SSIS) 2012, Microsoft SQL Server Management Studio, BIDS, T-SQL, SAP, C#, Azure Data Factory, Tableau Desktop V8/V9, TFS, Azure