Personal details

Sunil K. - Remote data engineer

Sunil K.

Based in: 🇮🇳 India
Timezone: New Delhi (UTC+5.5)

Summary

• Over 8+ years of experience in Analysis, Design, Development, Testing
and Implementation of Business requirements.
• Experience in all phases of Software Development Life Cycle SDLC
including Requirements, Analysis/Design, Development and Testing.
• Data warehouse, ETL- Extraction/Transformation/Loading, data
analysis, data migration, data preparation, graphical presentation,
statistical analysis, reporting, validation and documentation.
• Experience in SAS model building and validation
• Efficient usage of SAS tools such as SAS/Base, SAS/Access,
SAS/Connect, SAS/SQL, SAS/STAT, SAS/Graph and SAS Macro.
• Expertise in Tableau Data Visualization Tool to Analyze and obtain
insights into large Datasets, Create visually powerful and actionable
Interactive Reports and Dashboards.

Work Experience

Manager
Accenture | Jun 2015 - Present
Python
SQL
SAS
Tableau
• Extract data from the database using SAS/Access, SAS SQL procedures and create SAS data sets • Maintaining large datasets, combining data from various sources in varying formats to create SAS datasets by using set and merge for generating Reports and Graphs • Prepare new datasets from raw data files using Import techniques and modified existing datasets using Set, Merge, Sort and Update, Formats, Functions and conditional statements • Perform extraction, transformation and loading from large Oracle tables using PROC/SQL insert into statement • Perform statistical data analysis, generated reports, listings and graphs using SAS/Base, SAS/Macros, SAS/SQL and SAS/Access • Create reports in the style format RTF, PDF and HTML using ODS statements • Create the SAS job to run constantly to create the updated SAS datasets using SAS/data Integration studio • Revise and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies

Personal Projects

Marketing Analytics
2020
SQL
Excel
SAS
Tableau
• Gather, Analyze and document business and technical requirements. • Data cleaning by analyzing and eliminating duplicate and inaccurate data. • Data mining to uncover trends and insights. • Write Optimized SAS Code for the development as per business plan • Maintain consistency of SAS variables attributes like length, datatype, length, formats and in-formats • Create data reconciliation reports to verify the reports data, with standard report • Develop complex SAS macros to simplify SAS code and effectively reduce coding time and manual work • Implement the techniques for optimizing I/O to improve the performance of a SAS job • Perform complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE • Use SQL and PROC SQL, data _Null_ and SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY and TRANSPOSE for ad-hoc report programming and creation of the ad-hoc reports for finance research data • Generate high quality reports in the form of listing, HTML, CSV and PDF formats using SAS ODS