We provide IT Staff Augmentation Services!

Business Intelligence Developer Resume

3.00 Rating

OH

SUMMARY

  • Expert in SAS, SAS BI tools, SQL
  • Expertise with SAS/BASE, SAS/MACRO, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT and SAS/ODS procedures.
  • Strong noledge of BTEQ (Teradata) Language, Achieved significant time reduction by migrating SAS process to BTEQ.
  • Experience in writing SQL Queries (Proc SQL, SQL, BTEQ and PL/SQL).
  • Extensive working experience in creating visualizations and Dashboards using Tableau Server, Tableau Desktop and Tableau Public
  • Worked in all phases of project and provided technical support in building various complex business logics. Involved throughout ETL process and having thorough technical and business noledge on commercial data.
  • Frequent debugging and implementation of reporting process
  • Experience in gathering requirements, analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
  • Developed datamart using SAS and teradata DB for Business Intelligence tools.
  • Performed UAT on testing server and migrated to production server.
  • Expert in evaluating data models to design Tableau solutions.
  • Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using normalization, Business Process Analysis, Dimensional Data modelling, fact and dimensions tables, physical and logical data modeling
  • Experience in creating Documents, reports and dashboards for various business environments.
  • Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure

TECHNICAL SKILLS

Programming Languages: SAS, SQL, KSH, C++,C,C#, Java, SQL,PL/SQL, Visual basic, R, Python, Matlab

SAS Skills: SAS/BASE - MACRO /SQL, SAS/STAT, SAS/ETS, SAS/ACCESS, SAS/ETL, SAS/EM, SAS/GRAPH, SAS/INSIGHT, SAS ENTERPRISE MINER, SAS Data Integration Studio (SAS/DI), SAS ENTERPRISE GUIDE (EG), SAS Info Map, SAS Business Intelligence platform (SAS /BI), Info Delivery Portal (IDP)

Business Intelligence Tools: Tableau, SAS Visual Analytics, Business Objects, Qlik View, Microstrategy, Excel Pivot tables.

RDBMS: Teradata, Sql-Server, Oracle, Sybase

Operating System: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, OH

Business Intelligence Developer

Responsibilities

  • Involved in reviewing business requirements and analyzing data sources from Teradata for design, development, testing, and production of ETL processes.
  • Developed SAS Processes in SAS BI suite using SAS EG, Info Map, Info Delivery Portal and also worked on DI studio to design processes.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Extensively used Tableau to build Dashboards.
  • Experienced dealing efficiently with 100+ MM records data. Worked on large Fat datasets using different SAS features to avoid any space usage issue.
  • Extensively handled MACROS and SAS BASE procedures such as PROC (PRINT, TABULATE, REPORT, SUMMARY, SQL, MEANS, FREQ, etc.).
  • Worked throughout ETL process and Reporting Automation
  • Provided detailed documentation of the process and written SAS code with optimum comments to make SAS process simple and easily understandable.
  • Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Integration Studio, SAS Enterprise Guide, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
  • Tested dashboards to ensure data was matching as per the business requirements and if their were any changes in underlying data.

Confidential, VA

Business Intelligence Developer/ Analyst

Responsibilities

  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.
  • Served as a liaison between the business and the IT department by conducting weekly calls/meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to SAS-Teradata ETL as needed.
  • Extracting the data tables using custom generated queries from Teradata, Oracle database and providing exacted data as an input to frontend BI tools.
  • Modifies macros for report generation using SAS/Macros as per the requirements
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
  • Coordinated database middleware issues with DBA's, system performance with System Architects.
  • Created SQL Queries for UAT testing.
  • Optimized queries by looking at Execution Plan for better tuning of the database.
  • Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Confidential, NY

BI Developer

Responsibilities

  • Worked on developing ETL processes using SAS, Teradata-SQL, UNIX and Excel.
  • Responsible for code changes, maintenance and ad-hoc requests from business partners.
  • Responsible to create new KPI generation for Scorecards.
  • Extensively handled MACROS and SAS BASE procedures such as PROC (PRINT, TABULATE, REPORT, SUMMARY, SQL, MEANS, FREQ, etc.).
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Executed complex SQL queries to validate data differences between legacy system and new integrated framework source.
  • Executed and tested required queries and reports before publishing.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.

We'd love your feedback!