Data Microsoft Office

Karnith Umashankar

SAS Programmer/Analyst

*************@*****.*** / 626-***-****

SUMMARY

• Resourceful and Research Oriented SAS Analytics professional, with around 3 years of experience in application development, database design, data validation, manipulation, data analysis, process optimization and root cause analysis.

• Well versed with Descriptive, Inquisitive, and prescriptive analytics techniques. Strong abilities in problem solving, data analysis and complex reports generation.

• Proficientin SAS [SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/Reports, SAS/ODS, SAS/ Stored Procedures, AS/Web Report Studio, AS Dashboard, AS Management Console] and ETL Operations and managing software quality/functionality testing.

• Proficient in Requirement elicitation, refining requirements and data mapping.

• Proficient in inferring results and writing analytical reports.

• Strong fundamentals in Business Statistics, Mathematical Statistical Analysis, Linear Algebra and financial mathematics concepts.

• Skilled at data modeling, database design, views, normalization, stored procedure, triggers and functions.

• Strong programming, analytical and problem solving skills.

• Experience in programming for generating graphs, data listings and tables using data steps, procedures, SQL and SAS macros.

• Experience in developing application for data updates, data cleansing and reporting.

• Proficient in Microsoft Office Suite (Word, Excel, Outlook and PowerPoint).

• Exceptionally well organized, strong work ethics, and mindset to work hard to achieve client's objectives on time.

• Skilled in extracting, manipulating data, and creating Data Sets from various sources like Excel, flat files, Oracle database, Access database using PROC IMPORT techniques and SQL pass through facility. SKILLS:

Language: SAS, R, SQL.

Tools: Tableau, MS EXCEL, MS project, Marketing Excel, Microsoft office suite. Statistical Techniques: Regression, Seasonal forecasting, Time series forecasting. PROFESSIONAL EXPERIENCE

Allegro Development Corporation, Dallas, Texas Jul’2017- Present SAS Programmer:

• Interacting extensively with end users on requirement gathering, analysis and documentation.

• Involved with key departments to analyze areas and discuss the primary model requirements for the project.

• Documented methodology, data reports and model results and communicated with the Project Team / Manager to share the knowledge.

• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time.

• Imported Data from relational database into SAS files per detailed specifications.

• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA.

• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE and Data _Null_ for producing ad-hoc and customized reports and external files.

• Wrote SAS programs in UNIX platform.

• Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide.

• Developed Income statements & Balance sheets in MS Excel.

• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Integration Studio, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.

• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis.

• Designing SAS Visual Analytics (VA) reports using VA Data builder, VA Explorer, VA Designer, VA Viewer and creating custom reports in SAS VA.

• Performed the Rate Sheet QC and automated the QC validation by creating macros for each purpose.

• Move the data from development to the production side and schedule to run the process over Control- M and SAS management console.

• Performed Consumer profiling, Sales forecasting and testing of financial and business models.

• Effectively prepared and published various performance reports and presentations. Dialexa, Dallas, Texas Sep’2016- May’17

SAS Programmer:

• Imported raw data files into new datasets using PROC IMPORT and modified existing datasets using PROC SORT, SET, MERGE, INFORMAT, FORMAT and condition statements.

• Performed tests on import programs, analyze results, and modify programs.

• Provided daily progress reports and holds progress meetings.

• Used SAS data steps, procedures and functions to create analysis datasets, tabulation datasets and listing datasets as per BRD.

• Proficiency in importing different types of external files (Excel, CSV, txt, etc.) into SAS library and exporting SAS data sets as external files using Import/Export Wizard, PROC IMPORT, PROC EXPORT, and SAS DATA steps.

• Provided summary reports and do statistical analysis using macros.

• Sorting, printing and summarizing the SAS data and modifying and combining SAS datasets (sort, set, merge).

• Successfully published monthly data and claims trend reports using SAS ODS (Output Delivery System).

• Invoked several previous written SAS macros to create tables, and listings.

• Verified the accuracy and completeness of work in order to deliver quality solutions that improve of operations Ganesh Gears, India May’16-Aug’16

Financial Analyst:

• Analyze and develop efficient operational budget, plan work flow, manage multiple priorities and meet daily production targets by reducing downtime, verifying that the output meets the quality requirements.

• Prepare ROI reports for business activities, including new store opportunities, marketing initiatives and other key investments, Bridge and explain any variances between the strategic plan, the annual budget and actual results, become a key business partner in developing the annual budgets, re-forecast and strategic plans.

• Analyze financial and operational information to assess, interpret, and predict business performance to support management decisions. Tracked investment performance and prepare periodic investment performance / risk / economic data reports.

Shree Karthik Papers Ltd, India June ’14 - June’15 Financial Analyst:

• Assisted the senior project manager in handling queries and problems, Cost of Goods analytics and reporting, P&L, balance sheets, and income statements review, collaborating with various departments for budget usage and reporting, Provide monthly cash flow analysis.

• Duties included creating, updating and modifying spreadsheets for setting objectives for project team, setting project budgets, estimating labor costs, managing project timelines, tracking progress, and communicating the status of project, and managing risks and mitigating their impact on projects.

• Analyzing cost and pricing to provide a quantitative, data-driven perspective to help management decisions. Worked cross functionally with Central Forecast Team, Product Marketing Team, Business Operations Team & Ops Finance Team to understand product cost issues and customer rebate calculation EDUCATION

Master in Engineering Management

Southern Methodist University

Bachelor of Technology in Electronics and Communication Kumaraguru college of technology, Anna University

References available on request

Contact this candidate