Kiran Rpuri
Sr Aws Data Engineer @Array Technologies
Signup · Get unlimited contacts
WORK HISTORY
Sr Aws Data Engineer @Array Technologies
Albuquerque, NM, US
Extracted, transformed, and loaded ETL datasets with basic modeling variables for each segment type using Proc Import and SQL queries.• Developed new or modified existing SAS programs to load data from the source and create study specific datasets.• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time• Imported Data from relational database into SAS files per detailed specifications• Imported data using LIBNAME and PROC SQL Pass -Thru facility to reduce processing time• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA.• Involved in data manipulations and stored the updated data into corresponding data marts in Oracle warehouse.• Acquired raw data from Oracle tables and loaded the data into datasets for further analysis and reporting.• Manipulated and updated the tables as per specifications.• Performed data cleaning by analyzing and eliminating duplicate and inaccurate data using Proc Freq, Proc Comp, Proc Univariate, and Macros.• Formulated action plans and presented key information regarding profit dynamics to the senior management in the Bank.• Used regression techniques ANOVA, CORR, Proc Means and Proc Freq to analyze the data.• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.• Created reports in SAS and exported to Excel spreadsheets, created web reports using Web Report Studio.
EDUCATION
IIIT - Andhra Pradesh
Bachelor's degree
ABOUT KIRAN RPURI
Motivated and results-driven Analyst with a proven track record in data analytics and process mapping for nearly 7+ years of experience. • Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency. • Highly analytical and detailed with a documented track record in full software development life cycle (SDLC) methodologies and Agile techniques. • Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server 2008, and Teradata. • Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments. • Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database. • Strong hands-on experience implementing dash boarding, data visualizations and analytics using Tableau desktop and server. • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata. • Excellent knowledge in preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders. • Excellent experience in Data mining with querying and mining large datasets to discover transition patterns and examine financial data. • Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects. • Proven background translating cell formulas in Excel into VBA code. • Create VBA macros to automate reports into required template formats. • Excellent knowledge on creating DML statements for underlying statements. • An excellent team player & technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project. You can reach me @ K••••••••@gmail.com
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.