Sql Server Data Factory

Dallas, TX 347-***-**** ad5xpn@r.postjobfree.com https://www.linkedin.com/in/asifv

Skills & Abilities

· PowerBI/ Datasets and Server/ DAX Studio

· Oracle/ SQL Server/ Teradata/ Snowflake/ DBT

· SSRS/ Paginated Reports/ SSAS/ Cubes

· Informatica/ Alteryx/ SSIS/ Control M

· Tableau Desktop/ Repository and Server

· Azure DevOps/ CHGIT/ TFS/ Confluence/ JIRA

· Business Objects Universe/ WEBI

· MicroStrategy/ Crystal Reports

· Azure Data factory/Azure SQL Database/ Databricks/ Data Factory/ Visual Studio Code Experience

BI DEVELOPER III SIGNIFY HEALTH DALLAS, TX APRIL 2019 – TILL DATE

· Converted Various SSRS Reports to Paginated/PowerBI by limiting its Data size in front-end/back end to reduce time during refresh frequency and Published to PowerBI Server with PowerBI Premium.

· Created new Reports pointing to Snowflake using Views, Tables, etc. in the process by creating temp tables such as Transient/Temporary/etc.

· Assisted in Production OLAP Multi-Dimensional Cubes by composing queries to produce reports using SQL Server 2018, Analysis Services (SSAS) and Reporting service (SSRS)

· Created, Monitored, and debugged ADF Processing Pipeline/Trigger Runs for back-end Data Processing including Historical and NRT (near real time) runs/load in Snowflake.

· Check in Code/Procs/Reports/Views/etc. in CHGit (Previously used TFS) for version control and Backup Failure process before deploying the Changes to Production.

· Followed protocols for company by checking in Codes/RDL’s/PBIT/.SQL files to Azure Devops by creating branches and merging the repository to Master.

· Transitioned from Snowflake/Snowsight Server to Visual Studio Code Interface since it is feasible to regularly Checking in codes and keeping things up to date on the server.

· Regularly rotated Production Support duties with team members by fixing failure alerts for Data loads, Report refresh timeouts, pipeline failures through Opsginie integrated in Slack.

· Migrated several SSAS Tabular Models and redesigned the Data in PowerBI Datasets by optimizing codes for better performance for end users.

· Configured .yaml files in DPT to set up source tables by defining its Database/schemas/etc. as a single source of truth for source lineage to be pointed to views/procs/etc.

· Performed Code Reviews, QA and Deployed Ad-Hoc Jira requests to production to meet Quarterly Goals.

· Administered PowerBI and Tableau Servers by giving Access to users/handling Gateway connects, Query Caching, Scheduling Refreshes and DS Credentials.

· Performed data quality analysis using advanced SQL skills, Dimensional Analysis and Data Quality Validation in Data Migration from SQL Server to Snowflake.

· Created Custom Dropdown for Todays Date and Date range using custom Parameter in Tableau Desktop by using visuals in container to show Data based on the selection. SENIOR BI DEVELOPER CITI GROUP IRVING, TX JAN 2018 – MARCH 2019

· Application Manager for Production Support Applications such as CSIM, WEMS, ITRDR, etc. on Archer Platform and POC for App Maintenance/Critical Issues/Rebooting/etc.

· Monitored Server Activities/ Managed Sites, Permissions, Users /Scheduled Extracts Refresh /etc. as Tableau Server Site Admin Lead for BI Analytics Team for Citi Commercial Banking Domain. Asif Virani

· Created a Complex Dashboard with Data from 25+ Countries from APAC, EMEA, USA, RUSSIA, CHINA for Citi Commercial Banking for Onboarding Customer Dashboard Showing Turnaround Time, Case Sub-Process, Tasks in the Case, Case Status, In Progress Cases, Case Manager names, rework, etc.

· Implemented Region Level Security with Tableau’s "Create User Filter" by giving users access to regions they belonged to.

· Performed and signed off on SIT TESTING for Various Dashboard for Different Regions RM, L1 and L2.

· Worked End to End in Designing/Building/Testing Phases from POC to Prod Environment.

· Prototyped a Scorecard report from Excel in Tableau by Using complex LOD Calculations for Total/Color Condition Requirements.

TABLEAU DEVELOPER TRINITY HEALTH LIVONIA, MI FEB 2014 – DEC 2017

· Primary Person responsible for Tableau Connection for Creating ODBC and Variables to your local, installing Drivers, Connection Properties, etc. to help connect Developers across the organization to their corresponding Database roles.

· Experience includes technical support, troubleshooting, report design and monitoring of system usage.

· Created Row Level Security using (users) function to grant them access to View/Compare Doctors within their R.H.M's.

· Mastered the ability to design and deploy rich Graphic visualizations with Drill Thru, Drill Down and Drop-down menu option and Parameterized using Tableau.

· Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau Desktop.

· Built dashboards with floating objects and capitalizing the various dashboard actions features like URL, images, web integrations, etc.

· Developed various Metrics, Filters, Consolidations, Custom Groups and Prompts to give decision makers a handy tool to choose criteria for reports and view information in different perspectives.

· Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, SAP BW, MS Access, and client/server applications.

· Imported over 100 million records (.csv file) from Unix Server into Teradata manually using Informatica for Yearly Medicare Data.

· Exported Large Files from Queries (up to 30 Gigs) from MS SQL Server to Teradata using Fast Load process by using TPT Maintenance Store Procedure in Informatica.

· Created conversion, Distinct Keys, look up functions for Data coming from (.csv and .txt) files in Expression transformation, Sequence generator transformation, etc. to exporting into Teradata.

· Embedded "No Tabs" in Tableau server through URL Parameters for Actions using Drill.

· Configured data extraction by schedule, every business day at 6 am to enhance performance.

· Relegated older Tableau Versions such as 9.1, 9.3 to 9.0 and 10.2, 10.3 to 10.0 by manipulating HTML files in recovering older versions of .twb files which were not compatible for the upgraded servers. Education

BACHELOR OF ARTS IN ACCOUNTING AND ECONOMICS C.U.N.Y, QUEENS COLLEGE Certification

TABLEAU DESKTOP QUALIFIED ASSOCIATE OCTOBER 2018 (CANDIDATE ID: 988356)

Contact this candidate