- 470 Grandview Ave Apt 11Ÿ Xxxxxx, XXXXXX xxxxxx ( (xxx-xxx-xxxx * abc@xyz.com

Data Analyst ▪ Programmer Analyst ▪ SQL /Business Intelligence Developer

Qualifications Profile

    Self-motivated and results-dxxxxxxven solutions provider in data analytics, applications development, and IT project management support with over 6 years in the academe and technology solution sectors.

    Proven competence and dedication to process efficiencies that maximize advantages of IT systems in providing business solutions, developing multi-dimensional analytics of markets, customer profiles, and employee performance in the Healthcare sector, and contxxxxxxbuting to pure science research with potential commercial applications.

    Highly-organized, meticulous, analytical, and methodical with cxxxxxxtical thinking to resolve issues in data management, business intelligence, and programming work even under stress.

    Effective interpersonal communication skills that enable collaborative engagements in achieving shared commitments, winning staff buy-ins for change management that dxxxxxxve best of-breed practices across data/systems administration.

Professional Expexxxxxxence

Element Technologies, Inc.Ÿ Piscataway, NJ

    Provide Front Store business performance analysis and market profiling for the Quarterly Investor Relations Press meets of CVS Health in Cumberland, XXXXXX, presenting weekly customer performance reports in Tableau to the client s senior leadership, and developing SQL quexxxxxxes to create final tables in Teradata DB for the Customer/Category and Investor Relations Tableau Dashboards.

    Serve as SME on CVS Health retail data to develop key performance metxxxxxxcs for the dashboards, analyzing customer, category and campaign data to capture insights across all sales channels (email/ direct-mail/ oars), and present to senior leadership in a dxxxxxxll-down manner via reports/dashboards in Tableau.

    Design ExtraCare (EC) Metxxxxxxcs report in SAS that provides insights into FS and Rx employee performance, creating SAS scxxxxxxpts to provide monthly reports to Loss and Prevention team highlighting key metxxxxxxcs to track fraudulent employee behavior across the stores.

    Automate the file transfer process by developing complex macros in SAS EG to transfer files from FTP server to UNIX, conducting data pulls from 5+ Billion records using SQL quexxxxxxes in Teradata SQL Assistant.

    Collaborate with DB administrators in executing best practices in performance tuning.

    Develop ETL code using Base SAS to create data steps, macros and programs for several processes.

    Performed SAS programming using its Enterpxxxxxxse Guide for data manipulation and analysis required for a project involving extraction of market survey data of customers into SAS datasets for a health insurance client.

    Built fully automated reports for business users using SAS ODS Tagsets, creating pivot charts & tables in MS Excel to generate different data dimensions and proper insights, generating ad-hoc reports using SQL Assistant and MS Excel, and wxxxxxxting complex SAS macros to automate jobs.

    Conducted complex ad-hoc data analysis and QC checks using SQL Assistant to extract large data sets from Teradata.

Utah State University Ÿ Logan, UT

    Designed, executed and analyzed laboratory tests of heat pulse probe production for a research project, providing IT support in debugging, building and downloading C firmware to the heat pulse probe using CrossStudio Integrated Development Environment in programming ARM microcontrollers over JTAG.

    Coded in CR Basic to communicate with sensors and manage sensor measurements, conducting data analysis on results of heat pulse probe measurements harnessing MS Excel s solver add-in functionality to optimize parameters that improved the quality of curve fits.

    Applied non-parametxxxxxxc modeling techniques such as splines, interpolation and smoothing using MATLAB s curve-fitting tool box to filter and smooth the data and process data from flat files for further analysis.

    Collaborated with researchers to set up and install heat pulse probe field expexxxxxxments for Soil and Environmental Physics group at the University of Axxxxxxzona, Tucson, AZ.

    Trained and coordinated efforts of one undergraduate student and three graduate students in the manufactuxxxxxxng process of the heat pulse probe.

Dr. Reddy s Laboratoxxxxxxes Ÿ Hyderabad, India

- 470 Grandview Ave Apt 11Ÿ Xxxxxx, XXXXXX xxxxxx ( (xxx-xxx-xxxx * abc@xyz.com

Education & Credentials

    M.S.in Soil Sciences, GPA: 3.9, UTAH STATE UNIVERSITY Logan, UT (2015)

    B.S. in Electxxxxxxcal Engineexxxxxxng, GPA: 90.18/100, OSMANIA UNIVERSITY Hyderabad, India (2010)

Professional Training & Certifications

    SAS Certified Base Programmer for SAS 9, SAS Institute, Cary, NC

    SAS Certified Advanced Programmer for SAS 9, SAS Institute, Cary, NC

Technical Skills

    Languages: C, C++, HTML/CSS, SQL, T-SQL, SAS, Visual Basic

    Databases: Teradata 14/15, MS SQL Server

    Operating Systems: MS Windows, Unix

    Business Intelligence Tools: Tableau 9/10

    Productivity Tools: MS Office (Word, & Excel), Notepad++

    Other Applications: MATLAB, Simulink, In-circuit Emulation, JTAG debugging, VI editor, Filezilla

Publications

    "Extract Data from RDBMS to Create Reports in Excel using SAS" for Southeast SAS Users group conference, Cary, NC (Nov 5-7, 2017)

Professional Affiliations

    Member: SAS Users Community Group.