OBJECTIVE

• To achieve an opportunity that utilizes my communication and analytical skills.
• My objectives can be summarized: to obtain a challenging management, or technical position as deemed suitable to my educational experience, and backgrounds, to help a successful organization or company expand further and to help myself grow further professionally, and technically, to become an effective team player in a progressive organization or company.
• I am multi - cultured, hardworking, confident, mature, self-motivated, responsible, reliable, friendly, outgoing, open-minded, and flexible person.

TECHNICAL SKILLS

Programming Languages: Python, R, PowerShell

Computer hardware and software: Troubleshooting, upgrade, installation, and desktop support

Networking: DNS, DHCP, Email, HTTP, SSL, TCP/IP, UNIX and STACK

Database: MSSQL, Snowflake, Teradata, T-SQL, Google BigQuery

Cloud: AWS, Azure Data Factory, Databricks, Data Warehouse, Blobs, Storage Container

Data: Power BI, Power Automate, Paginated Reports, SSRS, SSAS

Active: Directory, VPN, RDP, ICA remote access services

POS system: Kaseya, Remedy, CRM, Service Now

PROFESSIONAL EXPERIENCE

Confidential

Power BI Engineer

Responsibilities:

• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generate calculated columns and Measures in Power BI.
• Managed Power BI Tenant and Capacity to ensure optimal experience for reports and their users in Power BI Service.
• Created Deployment Pipelines for version control of reports within the Power BI Service.
• Involved in creating new stored procedures and optimizing existing queries and Stored Procedure.
• Assisted other developers when having issues with building Power BI reports.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Installed Organization wide Power BI Gateways to keep the dashboards and reports up to date.
• Developed Up-selling and Cross-selling reports using DAX functions.
• Creating Row level security with power bi and integration with power bi service portal.
• Managed access to user groups, Power BI workspaces and reports by liaising with authorized personnel.
• Ensured reports were up to date by setting up scheduled refreshes and used Power BI rest APIs to keep report up to date as required.
• Worked on all types of transformations that are available in Power bi query editor.
• Created reports using time intelligence calculations and functions.
• Provided data analysis and data quality validation, managing report approval process, distributing, and storing reports to provide a meaningful and efficient summary.
• Collaborate with managers to gather requirements from business stakeholders and perform process analysis.

Confidential

Power BI Developer

Responsibilities:

• Created Power BI Visualizations and Dashboards as per requirements.
• Write SQL queries using joins, Views, Stored procedures, and user defined functions to verify the data from the database based on the business requirement.
• Work with business partners to understand business objectives and develop value-added reporting and provide ad-hoc data extracts and analysis.
• Work effectively as a member of a team, as well independently.
• Contribute to the improvement and efficiency of new and existing application functions.
• Contribute to the development of automated reporting solutions.
• Create and maintain detailed documentation on all projects/requests.
• Conducted independent statistical analysis, descriptive analysis.
• Perform data formatting and cleaning criteria from various data sources.
• Generated database reports, presentation, and documentation of analytical methods.
• Performed ad hoc analysis of data sources for all external and internal customers.
• Coordinated with clients for management of data mining and recovery projects.
• Worked with team members on technologies such as SSAS, Microsoft Excel and SQL server.

Confidential

Data Analyst

Responsibilities:

• Updated reports based on new requirements and system changes, captured report requirements from end-users, and documented requirements.
• Modified existing reports in SSRS and Excel using charts, graphs, tables, and matrices.
• Performed ad-hoc analysis, translated results into clear and concise reporting, and created job aids for report generation.
• Migrated data from various sources into SQL Server 2012 and Archives using ETL tool - SQL Server Integration Services (SSIS).
• Used SQL to analyze, query, sort and manipulate data according to defined business rules and procedures.
• Used various data transformations like, conditional Split, derived column transformations to move data to/from various sources to different destinations.
• Used Joins to combine multiple tables and use as a dataset +to create reports in SSRS.
• Gathered and analyzed data; developed and built SSRS reports in support of the business.
• Interpreted business needs and translated them into easy-to-follow written documentation.
• Translated customer needs into application requirements, documented details of the project.
• Worked with the project stakeholders to elicit, improve, document and record business requirements.
• Developed and published dynamic Financial and Sales Reports in SSRS.

Confidential

Tableau and SSRS Developer

Responsibilities:

• Liaise with end users to understand the business requirements and develop data models accordingly.
• Create various SSIS packages to populate the data from Oracle and flat files into ODS (SQL Server).
• Developed ETL, testing, implementation, and support of integration solutions
• Implemented centralized data warehouse and built de-normalized structures based on the requirements to improve the query performance.
• Work on building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Responsible to tuning ETL procedures and star schemas to optimize load and query performance.
• Create actions, parameters, filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Worked on creating Extract Views, Summary Views, Copy Input Views in SAFR ETL tool.
• Create ETL design specifications, performed unit testing, data validations, integration testing and UAT and deployed SSIS packages to development and test environments.

Confidential

IT Support

Responsibilities:

• Diagnose and resolve incidents including PCs, laptops, printers, network equipment, and applications.
• Troubleshoots problems quickly to determine the appropriate resolution path.
• Documents issues within the problem management system with clear, concise, and accurate information; documents troubleshooting process and procedure for each issue.

Confidential

Technical Support Engineer

Responsibilities:

• Installing, configuring, administering, and securing our as well as client’s production servers
• Upgrading and upsizing databases from earlier versions to the latest versions
• Successfully resolving SQL server problems in conformance with SLAs, which involves in-depth knowledge of SQL server architecture, connectivity, replication, DTS, backup/restore, database corruption, security, programming etc.