Systems Technical Intern Resume CA - Hire IT People

SUMMARY:

Seeking a competitive working environment in an organization, to learn Data Analytics, Business Intelligence and Engineering applications from it, give back to the company and the community to live a fruitful career for myself.

TECHNICAL SKILLS:

WORK EXPERIENCE:

Confidential, CA

Systems Technical Intern

Responsibilities:

Application QA and customer centric review for the in - house Application projects and the Hardware kits(Synergy Platform) used for various IoT devices. Worked on an Error Logger used in all existing applications for error reporting using C++.
Reported and Rectified issues in existing application programs using JIRA based on Agile Methodology.

Confidential, CA

Data Analytics Intern

Responsibilities:

Automated Payroll system for HR team that handles > 600 employees over 5 countries, using Kronos(SQL), VBA and UNIX.
Estimated to reduce a week's effort per month to a single day. Worked on Business Intelligence Reporting tool - QlikView and Tableau, to develop HR reports and dashboards.

Confidential

Systems Engineer

Responsibilities:

Constructed the control process framework using ETL to trail data flow from multiple data sources to a unified database.
Validated a large volume of data files and loaded the structured data to Teradata EDW using Bash Scripts reducing load time from 6 hours to 1 hour. Worked on performance tuning using pushdown optimization & SQL queries.
Used SSIS/SSRS for development and reporting of OLAP data marts. Created TSQL queries and stored procedures for ETL.
Worked with development and deployment of monthly production runs using mainframe systems and Unix scripts.
Constructed datamarts using Snowflake and hybrid schemas to in corporate many fact and dimension tables.