SUMMARY

• Around 7+ years of IT experience in analysis, design & implementation of Business intelligence solutions with Microsoft SQL server in development, Testing & production environment. Well versed and Experienced in both OLTP and OLAP (Data warehousing) environments, Business admin Intelligence (BI) Project Development.
• Experience in Agile Scrum methodologies, spring planning, grooming, reviewing and retrospectives.
• Good noledge of Data warehousing, Bottom - Up and Top-Down Design methodologies, Operational Data Store (ODS), OLAP, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using Analysis Services.
• Experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints, Indexes and Batch Scripts using various DDL and DML commands.
• Experience in SQL Optimization by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor and Query Execution Plans.
• Involved in data migrations, transfers using utilities like Data Transformation Services (DTS), SSIS, Bulk Copy Program (BCP) Bulk Insert and providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Understanding of SnowFlake cloud technology
• Involved with Business Analysts to understand the Business Requirement Specifications and implemented the ETL jobs in Data Stage
• Proficient in designing reports using SSRS and Excel Power Pivot table based on OLAP cubes.
• Working noledge of Azure Services IaaS, PaaS, and SaaS
• Data Warehouse migration from on premise to Azure cloud.
• Expertise in configuring report manager for creating report subscriptions, snapshots, and caching.
• Experience in various integration options using Tableau Desktop, Tableau Server and Tableau Reader to minimize overall end user licensing requirements .
• Understanding the Apache Spark-based analytics service in Azure Databricks
• noledge of Object-Oriented programming (OOP) concepts using Python.
• Understanding Microsoft Azure robust ecosystem that customers no and use, and many want the flexibility to buildhybrid solutions that span cloudsas needed.
• Experience in designing Database Models using MS Visio and ERWIN for both Relational and Dimensional modeling.
• Expert in implementing star and snowflake schema methodologies for design cubes and applying dimensional modeling using SSAS.

TECHNICAL SUMMARY:

Tools & Packages: SQL Server Management studio,SQL Profiler,BIDS, SQL Server Data tools, Microsoft TFS, Report Builder, Crystal Reports, SharePoint, Ad Hoc Reporting, Visual Studio,pgadmin 4, Dbeaver

Reporting Tools: SSRS,Crsytal Reports,Power BI,Tableau 10

ETL Tools: SSIS,Azure Data Factory

Database: MS SQL Server 2019/2016/2012/2008R2/2008,Oracle,PostgreSQL,MS Access

Cloud Platforms: Microsost Azure, AWS

Language: T-SQL, MDX, XML, C#,Python

Scripting: Unix, Powershelll

Application Packages: MS Office Suite, MS Outlook, MS Excel, Windows SharePoint Services

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio,TX

Azure SQL Developer / Data Engineer

Responsibilities:

• Created a linked services in Azure Data Factory and parameterize a linked service and pass dynamic values at run time.
• Used Azure Logic Apps in a cloud service for schedule, and workflows to ETL integrate data and send an email notification.
• Worked on Copy activity, CustomAzure Data FactoryPipeline Activities for On-cloud ETL processing
• Worked on Creating Pull Request
• Strong noledge of Azure Storage Accounts, Containers, Blob Storage, Azure Data Lake, Azure data factory, Azure SQL data warehouse
• As a PostgreSQL Developer, me work on
• Good Knowledge onCloud computing architecture,implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS)
• Small,Collaborative and resourceful dev team, working together to build an enterprise level platform.
• Used Jira,Bitbucket for creating the stories and updating the issues
• Install,configure, test, monitor, upgrade, andtune new and existingPostgreSQL databases.
• Understanding data architecture using AWS Aurora PostgreSQL
• Connecting to PostgreSQL using Command Line Interface .
• Used AWS schema Conversion Tool and Ora2pg tool for migrating oracle to postgresql database
• Writing the queries in PL/pgSQL using DBeaver and pgadmin.
• Connected to Oracle Database and understanding the storedprocedures which are written in PL/SQL and convert into
• Involved in implemented Postgresql database solution in AWS (Amazon Web Services) EC2 & RDS environments.
• Involved in testing the stored procedures to make sure everything works good.
• Copied Data from Amazon S3 to Azure Data Lake with ADF Templates .
• Understanding Kubernetesfor the runtime environment of theCI/CDsystem to build, test deploy.
• Knowledge on AWSsolutions using EC2, S3, RDS, EBS, Elastic Load Balancer, Auto scaling groups.

Tools: PgAdmin4, AWS schema Conversion Tool, Ora2pg, Jira,Bitbucket,Azure, Dbeaver

Confidential, San Antonio,TX

Azure Data Engineer/Developer

Responsibilities:

• Setup and Maintained LogShipping between various environments.
• Implement data models, database designs, data access, table maintenance.
• Developed jobs using Data Stage Designer to extract data from different resources and involved in cleansing data.
• Created a Data Factory pipeline that copies data from Azure Blob Storage to Azure Database for PostgreSQL
• Configuring log analyzation tools like pgbadger etc.
• Taking backup, recovery, and upgrading of all of the PostgreSQL databases.
• Deciding whether clustering,log shipping,mirroring,replication etcare the right fit to solve a business problem.
• Create mapping artefacts to map each field in the XML to the columns in the table.
• Understanding Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics
• Scheduled JobsinFlowsandADF Pipelines
• Designing a data transformation job in the data flow designer by constructing a series of transformations
• Created a schedule trigger that runs a Data Factory pipeline
• Orchestrating Azure Databricks Notebooks with Azure Data Factory
• Worked in assigning AzurePolicy andAzureRole Based Access Controls.
• Worked on python scripting to automate generation of scripts
• Understanding the flow of Hierarchy of management groups and subscriptions.
• Experience in Understanding Microsoft Azure Service Bus Concepts which is a fully managed enterprise message broker with message queues and publish-subscribe topics.
• Created and configured function app to host the execution of your functions.
• Deployed to msdb and created daily Jobs for execution of the SSIS packages.
• Worked on Event Grid by connecting to data sources and event handlers
• Understand the architectures of Azure Event Grid that allows you to easily build applications with event-based
• Installing PowerBI Desktop and navigating to office 365 admin center.
• Created Custom visualizations and developing Power BI Dashboards.
• Experience in DAX Functions in Power BI
• Involved in Building Power BI dashboards and reports by connecting to Tabular Models.
• Deployed the packages in the Azure Data Lake Environment
• Scheduling Automatic refresh in POWER BI Service.
• Configured SQL Mail Agent for sending Automatic emails to required team using SSIS Packages.
• Used Zendesk for ticketing and defects status tracking.
• Using Rest Source and Rest Destination task from Task Factory and being returned from the REST endpoints in JSON
• Worked onCosmosscripts for retrieving the data and move into SQL Server
• Pull raw XML files from SAP system and transform the data using BizTalk Server and push the data to SQL Server.
• Build WCF services using C# to communicate between Nexus Server and SAP.
• Experience in writing VB scripts for user defines functions in SSRS.

Tools:SQL Server Management Studio 2014, T-SQL,BIDS, pgAdmin, pgStudio,Visual Studio 2017,SSRS, PowerBI, SSIS,MS Azure,AWS,Azure Synapse,cosmos

Confidential, Louisville,KY

Azure Developer/SQL Developer

Responsibilities:

• As a Azure Architect /Developer, me work on
• Designing, developing and maintaining business intelligence solutions.
• Executing queries upon request for data.
• Presenting information through reports and visualization
• Created ad-hoc Report from connecting to Azure Sql database .
• Experience inMoving Data in and out of Windows Azure SQL Databases and Blob Storage
• Having good noledge in Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks.
• Import a Transformationnotebook to your Databricks workspace.
• Wroked on Snowpipe for continuous data load from SQLServer
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities and Logic Apps.
• Assisted in designing and management of PostgreSQL database schemas and tables
• Design and implement disaster recovery for the PostgreSQL Database.
• Installing and Configuring PostgreSQL from source or packages on Linux machines.
• Diagnosed and addressed operational data issues.
• Developed Reports with trending data by using demographic charts with drill down functions that displays a breakdown of Region/States sales,utilizing data aggregation from SQL Statements.
• SSIS Migration from on premise to Azure Iaas server
• Implementing PowerBI gateway to access data from on-premise network.
• Experience in creating notebooks for moving raw data to stage using azure databricks.
• Design the data factory pipelines ti move the data from on-premise to Azure Data Lake Store.
• Recreated logic for various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
• Working experience with Agile planning under TFS environment.
• Created Reports using Data Analysis Expression language (DAX)

Environment:VisualStudio 2017,SSMS 17.0,pgAdmin,PgPool,PgBouncer,T-SQL,SSAS,SSIS,SSRS, Power BI,MS Azure

Confidential, Tracy, CA

SQL BI Developer

Responsibilities:

• As a SQL BI Developer, me work on
• Developing and maintaining systems to store, organize, and access data.
• Writes and optimizes SQL statements for data access and retention.
• Regular database management duties including backups and audits.
• Experience working withAzure SQL Database Import and Export Service.
• Experience indeploying SQL Databases in AZURE.
• Experience inMoving Data in and out of Windows Azure SQL Databases and Blob Storage
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Collaborate to development of main Web Application and Responsible of web application deployments over cloud services on Azure, using VS and PowerShell
• Designdata loadsfrom variousrelationalandnon-relational data sources.
• Dimension modelingfor multiple data marts following Kimball methodology.
• Involved in creation of Dimensions using Star and Snowflake Schema.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Develop multi-phase Talend ETL processes to clean and load enterprise data warehouse.
• Experience using Talend Data Integration/Big Data Integration
• Createdcomplex Stored Procedures, Functions, and Indexes, Tables, Viewsand otherT-SQLcode.
• BuildingSSAS cubesto expose detail level data in the data warehouse to the business users.
• BuildingSSRS Reportsand Dashboards pointing to the Data Warehouse for reporting summarized data.
• Involved in Performance Tuning on Production, Staging and Test Servers.
• Involved with maintenance of ACTIVE/PASSIVE Cluster Environments.
• Implemented Database mirroring for High Availability.
• Maintained various databases for Production and Testing usingSQLServer 2012.
• Understanding Snowflake Virtual Warehouses and building snowpipe .
• Worked in creatingComplex Crystal ReportsAd Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports
• Involved in Schedulingthe report using Schedule Managerin Crystal Management Consoleto run every day on a periodic basis.
• VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS packages.
• Created Different Graphs and Charts for analyzing related Information using Power BI Features. (Power Query, PowerPivot and Power view).
• Analysis for all the Data Marts and Data Warehouse for regular Releases and Projects, which requires frequent interaction with the Business Users.
• Developed Client applications to consume the web services based on both SOAP and REST.
• Experience in Excel VBA Macros and MS Access VBA Macros

Tools:Visual Studio 2013,SSMS 2012,Talend OS ETL, T-SQL,SSAS,SSIS,SSRS, Power BI,MS Azure

Confidential, Colegeville, PA

SQL/BI Developer

Responsibilities:

• As a SQL BI Developer, me work on
• Researching and planning solutions for existing problems within the company.
• Create management methods and systems to access efficiently to information stored indatabases.
• BIdevelopersalso are responsible for building OLAP, or online analytical processing
• Created Sub-Reports, Drill Down Reports, and Cross Tab Reports using SSRS.
• Created Reports using Power BI tool.
• Participated in creating and modifying Crystal Reports.
• Installed, configured and maintained SSIS,SSRS.
• CreatingAzure Blob, Azure Storage account
• Developed OLAP Cubes, Dimensions, Data Source View, Partitions and Aggregations.
• Responsible for creating complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP reporting needs.
• Knowledge in creating calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Converted and redesigned existing DTS packages to SSIS Packages.
• Configuring Microsoft SQL server with TFS server
• Created Enterprise reports in TFS using Multi-Dimensional Query MDX and SQL
• Created Indexes and proper re-indexing for intensive OLTP system to ensure best performance.
• Created SSIS Packages according to the requirements.