SONIA RAHMAN

646-***-****, ady1bs@r.postjobfree.com

BUSINESS INTELLIGENCE DEVELOPER, DATA ENGINEER AND ANALYTICS EXPERT

5+ years of BI and Data Warehousing Experience: Expert in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) along with extensive Data Warehousing knowledge.

7+ years of Database Programming Experience: Expert in writing T-SQL stored Procedures, Triggers, Constraints and Indexes using various DDL and DML commands. Experience in Power BI Desktop and Power BI report server. Proficient in designing and developing MS-Access database, and RDBMS with SQL, Extensive experience on REST Web Service API for remotely interacting with RDBMS databases. Developed Python Functions and Arguments and worked with Python Modules and packages.

DB Migration Experience to Microsoft Azure: Developed tools to deploy, manage, monitor and troubleshoot database systems on-premises or in public cloud. Migrated databases to Azure and worked with Azure Data Factory, Synapse and Data Bricks. Mentored team members on Cloud Technologies.

Business Development and Client Relationship: Significant experience in Client Relationship and business development for small businesses and customer support for various organizations including a bank. Earned “Customer Relation Experience” for customer leadership program.

Problem Solving and Project Management: Excellent trouble shooting abilities and have the capabilities to solve problems correctly and effectively. Managed multiple technical projects through phases from inception to completion.

WORK EXPERIENCE

Enterprise Data Engineer and Analytics, Envision, June 2022- Current

Datawarehouse and SQL Developer: Support development and maintenance of SQL Server Analysis Services data cubes. Evaluate and improve existing BI systems. Design, Build and deploy BI solutions. Develop SQL views and stored procedures as requested by business users. Writing DAX queries and MDX queries

Data Analysis and Solution: perform root cause analysis on data and processes to answer specific business questions and identify opportunities for improvement. Regularly audit data to ensure accuracy and identify discrepancies between sources. Conduct unit testing and troubleshooting. Translate business needs to technical specifications. Develop and update technical documentation and Users guides using Confluence.

Power BI/SSRS Report Developer: Create, maintain, and administer reporting dashboards using Power BI/SSRS.

Maintain user’s roles and security to provide access for different ad groups.

Collibra Application: Work with business and technical teams to implement Collibra Data Governance and Data Quality in enterprise level. Created Rules, Alerts and Schedules for DQ jobs. Support cross functional company initiatives

ADF/Synapse/ Databricks: Azure Data Factory integration with Azure Databricks - Accessing a Databricks Notebook with Input and Output Parameters. Read and write data from SQL database table in data bricks. Reading and writing snowflake data from Azure Databricks. Reading and Writing AWS S3 data from Azure data bricks using mount point.

Data Engineer and Analytics, The Leading Hotel of the World, November 2021- May 2022 (6 months Contract)

Analyzed /Processed and developed business logics working in Amazon, Redshift Environment / Used DBeaver SQL Client Software App and My SQL Relational Database Management System (RDMS) to process data.

Improve quality of data to achieve revenue accounting accuracy for all business segments. Develop logic by doing deep analysis to increase data accuracy by 50% instantly.

Generated Tableau dashboards using parameters, calculated fields, groups, sets and hierarchies etc. that allowed to track business for accurate revenue calculation by 12% within a month.

Improved business decision making by optimizing data warehouse. Remove data warehouse redundancy by 80%

Sr Developer/Architect, SQL Server/Business Intelligence, Archdiocese of New York, 2013 – 2020

SSRS: Designed, developed and maintained company’s business intelligence solution using SSRS reports, dashboards, analytics and charts for internal customers. Interacted with staffs, vendors, and partners to determine business needs, and support decision making. Created and maintained SSRS reports that align data from multiple data sources to meet business requirements. Configured and maintained Report Manager and Report Server for SSRS

SSIS: Designed and Implemented data Loading (ETL) and publishing processes within the DW/BI environment. Extensively involved in designing the SSIS packages to export data of multiple sources to SQL Server database. Worked on all types of reports like Parameterized, Matrix, Charts, Sub Quires, Drill Down, Drill Through, Gauge Control and more. Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.

SSAS: Designed and implemented multi-dimensional models, including the construction of Data View, Dimensions, and Cube. Expert in writing MDX quires with extensive experience in creating and customizing Cubes using SQL Server Analysis Services 2017/2019

T-SQL: Created and maintained databases, tables, views, indexes, check constraints, and business rules using T-SQL. Involved in Migration of databases of SQL Server 2000 to SQL Server 2017. Wrote stored procedures, views, and functions. Addressed potential blocking and deadlocking situations.

Power BI: Designed and developed Power BI solutions with Dashboards/Reports & Power Bi Visualizations writing Data Analysis Expressions (DAX). Prepared interactive Dashboards with fully dynamic charts using calculations, parameters which delivers deep insights on the data. Imported data to Power BI from other services using REST APIs and automate Power BI dashboard by scheduling a refresh data. Connected and fetched JSON data to Power BI using REST API, Used Rest API for custom applications to automate some configurations for a Power BI service solution and extend the solution to another level.

Azure: Manage Azure AD objects and role-based access control (RBAC). Automate deployment and configuration of VMs. Read and write data from data lake storage Gen2. Manage data in Azure Storage, Loaded data from different Rest API ' to ADLS Gen 2 with For Each loop. Developed function to read and write to Synapse DW from data bricks using polybase.

Data Warehouse Developer, SETFOCUS, 2012 – 2013

Translated business requirements into technical design specifications using Visio to design ERD schema.

Normalized data fields to meet the business requirements and specifications to build a data mart for various departments into a metadata.

Improved data quality by up to ninety five-percent on most measures as defined by Business Reporting unit.

Designed and Implemented cubes. Analyzed multidimensional cube data through MDX Scripting in SSAS.

Developer, Databases/Applications, NYU Langone Medical Center, 2011 – 2012

Database Developer: Developed a New Grant Database system which automated day-to-day processes, reduced administration costs, increased user productivity and accuracy. Handled database tables, queries and reports, store-procedures, functions, triggers, and other SQL database objects that assist in the implementation of business logic.

Applications Development: Created, administered, and analyzed custom applications, forms and electronic surveys that saved countless administrative hours and designer’s/developer’s cost. Documented all maintenance actions, process changes, configurations, and troubleshooting procedures.

Custom Reporting: Designed, developed, and supported standardized and customized reports that are easy to use, scalable and manageable across the organization. Increased accuracy of the report by 50% compared to previous SPA Report System and saved millions of dollars instantly

IT Support and Maintenance: Supported internal and external clients. Managed IT maintenance, software updates and system integrity. Identified, analyzed, and implemented process improvement measures. Administered third party application, users, groups and security. Communicated to executives and customers.

Database Admin, Special Funds Conservation Committee, 2009 – 2011

Administered Oracle based Star system, managed users, role-based security and access policies. Managed system design and functions required by various team members.

Created new technical documentations and helped improve company’s process and operational efficiency and achieve its corporate objectives.

Improved productivity of end users by conducting technical trainings in 4 locations on database system, advanced Excel/PowerPoint/Outlook

Designed and created custom reports using SQL based on business and clients’ needs. Downloaded daily exceptions, handled encryptions, uploaded information in the databases.

Data Specialist, Michael C. Fina, 2008 – 2009

Performed data analysis, created reports with metrics, and helped executives make investment decisions

Captured requirements and translate them into design documents.

Created multiple dashboard and automated reporting to increase operational effectiveness.

IT Analyst Intern, Baruch College Technical Center, 2008

Administered Active Directory, Windows DHCP and DNS

Designed project requirements based on relational database system.

Configured Applications Track-it, Microsoft SharePoint etc. to track assets & work orders

EDUCATION

BBA, Computer Information Systems, Baruch College, CUNY, New York, 2008

MS, Business Intelligence, Set Focus, Parsippany, NJ, 2012

SKILLS

SQL Server Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), SQL Server Profiler, SQL Server Configuration Manager, Database Engine Tuning, Dynamic Management Views and Functions, RDBMS/ Normalizations. ETL: SQL Server Integration services, Power BI: Power BI Desktop, Power BI Report Server, Power BI Service. Power BI Data Gateway, Power BI Mobile Apps, Dax Data Analytics Expression. Programming Languages: C, C++, Python, SQL, TSQL, PL/SQL, MS Project, Applications: MS Word, MS Excel, MS Access Certification, Networking: LAN/WAN, T1/T3, TCP/IP, Ethernet, Fiber Optics, cable modem, Switches, Routers, hubs, DNS, FTP servers.

Contact this candidate