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.