SUMMARY

• Experienced Business Intelligence Engineer and Data Analyst with 7 + years of experience with a demonstrated history of working in the diverse industries.
• Have profound hands - on experience in the whole cycle of BI development including Development, Test and Production. Strong information technology professional specializing in SQL, SSIS, SSRS, Power BI and Azure.

TECHNICAL SKILLS

Databases: SQL Server 2017/16/ R2, Oracle 11g/8.0i, MS Access 2000/8.0, Cosmos DB

Languages: T-SQL, PL/SQL, MDX, DAX, C#, XML, .NET Framework, C#, Python

Web Tools: C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML5, JavaScript, VB Script

Cloud: Azure Synapse, Azure Data Lake Analytics, Azure Blob storage, Logic App, Azure Data Factory, DataBricks

ETL & Reporting: SSDT 2017/16/14/12 , BIDS 2008R2/08, SQL Server Integration Services (SSIS 2017/16/ 2014/2012/2008 R2), SQL Server Reporting Services (SSRS 2016/2 R2), Power BI, SQL Server Analysis Services (SSAS)

Others: MS Office, MS Visio, SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, Crystal Reports SAP Business Objects, Micro Strategy, ER-Studio, Microsoft TFS, Microsoft GIT, MS VSS, HP Quality Center & Jira, TFS

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, California

BI Developer

Responsibilities:

• Involved in planning from the conceptual, Logical and the physical Implementation layer with other Team mates to come out with the Business specs used in the BRD.(Business Required Document)
• Creating databases and variousSQLserver objects like schemas, tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE (common table expression), Table Variables and Stored Procedures.
• Pragmatic and proactive in performance tuning on OLTP and Data Warehouse systems (OLAP) for fast and efficient data load and data retrieval
• Collaborate with team members in the Dev environment to promote all T-SQL Code, SSIS Package, Reports and all other Database Object into source control using Team Foundation Server (TFS), and GitHub.
• Design data pipelines Using SSIS to pull Data from multiple client sources and perform Data Cleansing using the various SSIS Data Flow Transformation and applying Business logic as defined in the BRD.
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Partitioned tables to handle better data comparison in staging. Worked directly with business users to get requirements and feedback on the on-going.
• Reviewed designed and coded Test and validate solutions to ensure continuous accuracy, front end ease-of-use and integration with existing resources.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Set up SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Developed, modified, and tested complex MS SQL stored procedures to validate the data after the loading from source database.
• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, Union and etc.
• Have good experience working with different data flow sources (flat file, excel, OLÉ DB source) and destinations (OLE DB, Oracle destination, SQL server destination, Flat file destination etc.).
• Extensive knowledge of using data profiling tasks for cleansing data, slowly changing dimension and optimizing long running SSIS packages.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008/2012 that maintained data.
• Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Developed Power BI dashboards and reports for data analysis and maintained the reports on a monthly basis based on the requirements.
• Created interactive reports and dashboards in Power BI sourcing from tabular cubes, excel files and SQL server database tables and views and published them to Power BI service.
• Migrated existing reports from SSRS to Power BI
• Created a number of paginated reports
• Designed and documented the entire Architecture of Power BI
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as Sql Server, Flat file, Excel, SQL Azure, tabular cubes and etc.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures in Power BI desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power BI query editor
• Created stored procedures and SQL queries to pull data into Power Pivot model.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Ingestion of Data to one or more Azure Data services (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) using Link services to the various data source
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.
• Created a number of ADF pipelines that source from the Cosmos DB and load data into on prem SQL tables.
• Created a dynamic load of tables from Cosmos to SQL tables using Lookup, Metadata as well as Foreach activities.
• Migrating on premises to Azure Synapse dedicated SQL pool and do lift and shift all existing on premises reports, ETL to the cloud.
• Created linked servers, integration runtime, datasets for ADF pipelines as well as triggers to automate the pipelines.
• Creating end to end solutions in Azure Synapse including creation of Databases in dedicated SQL pool, Notebooks in Apache spark pool and create pipelines & scheduling them.
• Created data model in Azure synapse and create power bi reports on top of it.

Confidential, Alpharetta Georgia

Data Engineer/Data Visualization Developer

Responsibilities:

• Modifying long running Jobs by wrapping all queries in stored Procedures and creating SSIS Packages using Execute SQL Tasks to improve performance.
• Analyze system data, profile, and build data flow diagrams for development team adoption.
• Develop, maintain, and support the enterprise data warehouse system and corresponding data marts.
• Analyze and review object and data models and the metadata repository in order to structure the data for better management and quicker access.
• Participates in sprint planning, scrum, Backlog Grooming and Retrospective meetings.
• Played the dual role of Analyst and Developer gathering requirements, analyzing the data, and developing SSIS packages and Power BI/ SSRS reports.
• Experience and understanding of large-scale applications in enterprise-wide environments (including migration of on-premises workloads to the cloud).
• Migration of SSRS report to Power BI
• Creation of paginated reports
• Maintain all SQL agent jobs running in UAT & production.
• Create Access DB templates to search data files for customers as needed, create SQL scripts to load users into an Oracle DB by querying the data warehouse for data.
• Extract, Transform and Load data from databases of systems like CRM, ERP and SharePoint
• Collaborated on multiple projects using Github and Devops.
• Worked extensively on system analysis, design, development, testing and implementation of projects.
• Configured SSIS packages with XML configuration file, Environment variable, Registry entry, Parent package variable and SQL Server table.
• Generated sophisticated Stored Procedures, Tables, Triggers, SQL Joins, Views, and other statements to maintain referential integrity and implement complex business logic.
• Improved the performance of packages by updating statistics and restructuring the indexes to improve the server efficiency in SQL Server 2014
• Actively participated in creating the Relational Database design. Composed T-SQL queries to help various transactions.
• Generated SSRS and Power BI reports sourcing from SSAS’s Multidimensional OLAP and Tabular model cubes with DAX and MDX.
• Supervised performance tuning of SQL queries and stored procedures using Index Tuning Wizard and SQL Profiler
• Worked extensively on system analysis, design, development, testing and implementation of projects.
• Configured SSIS packages with XML configuration file, Registry entry, Parent package variable and SQL Server table.
• Creating different types of SSRS reports along with SQL stored procedure and set up subscriptions.
• Automating csv file generation from SSRS report using power shell
• Loading data from multiple sources and Cleaning & transforming data in power query
• Creating different types of power bi report along with model in power bi desktop
• Creating measures & calculated columns using complex DAX expressions and using DAX studio to for code validation.
• Creating interactive visuals using slicers, charts, tables, decomposition tree, KPI, cards and custom visuals.
• Active usage of geographic Data mapping in dashboards and reports when needed.
• Creating pipelines to refresh the datasets through Power apps such as Power Automate.
• Publishing all power bi reports, sharing with users and setting up dataset refreshes

Confidential, Chicago, IL

Microsoft Business Intelligence Developer

Responsibilities:

• Worked with Business Users and Business analyst in gathering requirements and preparing the functional and technical documentation.
• Developed complex T-SQLcode such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Temporary tables, table variables in Stored procedures to simply complex queries
• Optimized queries by analyzing different query options and indexing strategies.
• Developed T-SQL Scripts to validate the data after the loading process. Modified and tested T-SQL stored procedures
• Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
• Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using SSIS.
• Created ETL packages that reads Product, Vendor, and Order data from an FTP server into a SQL Server database. The solution also validated incoming Data and performs notifications when jobs complete.
• Created SSIS packages to load data from Heterogeneous sources like Flat files, CSV files and Excel.
• Implemented custom logging to keep track of the packages being run automatically. Configured the packages to run on different servers using Package Configurations.
• Created packages in SSIS with error handling using Event handlers.
• Used various transformations in SSIS like Lookup, Derived Column, Union all, Merge to modify the data which is stored in various forms efficiently.
• Using C#, visual basic.Net in SSIS script tasks and script components with variables
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files and scheduled SSIS packages using SQL Server Agent, Jams.
• Created SSIS packages to clean and load data to data warehouse.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Individually authored, installed, deployed and managed reports using SSRS 2017.
• Generated drill through, drill down which projected data as per the user requirements using SSRS.
• Implemented Conditional formatting using Expressions in SSRS 2017.
• Created Parameterized reports using Text and Stored procedures as source in SSRS 2017.
• Deployed SSRS reports to share point server and used Excel services in Share point application.
• Managed subscriptions and data-driven report subscriptions to provide timely reports to the clients and end users, also created snapshots to reduce loading time.
• Converted more than 200 Tableau Maintenance, Finance, Lease reports to SSRS to support business user requirements.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
• Consumed WebAPIinto theSSISpackage using C# with script task