PROFESSIONAL SUMMARY:

• Award winning process oriented business intelligence analyst with 5 years of experience in analyzing business intelligence, creating detailed, summary reports to increase sales revenue and in the reduction of costs by analyzing perational data.
• Strong hands on experience in querying(SQL), creating reports, dashboards, performing data analysis and data visualization using SAS, SSIS, SSRS, Excel and Tableau.
• Developed predictive models and statistical analysis for capstone project and data mining project to predict the future events.
• Achieved Silver and On the Spot excellence awards at Confidential .
• Exceptionally well organized, reliable, self - motivated, committed to continual learning and self-development.

SKILL:

Languages & Tools: SAS/Base, T-SQL, C, XML, DOT NET(C#), JAVA, Python, HTML, JavaScript

Database: SQL Server 2005/2008-R2, 2012, Teradata, Access

ETL, Reporting and Analysis Tools: SSIS, SSRS, SSAS, Tableau, Power BI Desktop

Environment: s: MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Project, Visio, TFS

PROFESSIONAL EXPERIENCE:

SAS Data Analyst Intern

Confidential, Columbus, Ohio

Responsibilities:

• Carried out Data analysis, Statistical analysis using SAS methods to decrease the backorder of the stock availability and to improve the sales of products.
• Assisted in investigating and applying SAS programming techniques to enhance current system by using various SAS Macros and Standard programming procedures.
• Developed SAS Programs using SAS Pass Through and LIBNAME methods to extract the data from different data sources and created SAS datasets for report generation.
• Performing data extracting and data manipulation using PROC SQL, PROC SORT, PROC REPORT and created customer list and ad-hoc reports as per business requirements.
• Responsible for generating yearly sales reports and business reports using SAS Enterprise Guide.
• Extensively used SAS Output Delivery System to create Customized reports in PDF, HTML and RTF.
• Carried out Data analysis, Statistical analysis using SAS tools to decrease the backorder of the stock availability and to improve the sales of products.
• Developed complex SAS Macros to simplify SAS Code and effectively reducing coding time.
• Involved in the documentation and knowledge transfer of the methodologies, model reports and data reports.
• Extensively used regression techniques ANOVA, PROC FREQ and PROC Means to analyze the data and making business decisions.
• Documented the developed macros explaining the functionality of the macro and the macro parameters defined for future reference

Business Intelligence Analyst

Confidential

Responsibilities:

• Designed databases for different client needs and maintained a group of 40 databases of Confidential Order Management System. Analyzed massive, highly complex data sets and performing ad-hoc analysis.
• Managed the planning and development of design and procedures of metrics reports and reporting findings of quarterly projections analysis to executive level to use in making business decisions.
• Developed reports to Stakeholders improving the demand forecasting resulting in the reduction of back orders for various vendors by 2%.
• Analyzed the promotional data during black Friday and peak seasons to implement personalized locker banners and email campaigns to target audience and to attract new customers.
• Created complex Stored Procedures, Triggers, Cursors, other SQL Joins and Statements for Applications by using T-SQL. Ensured 10% less breach of risk by updating and enforcing security procedures.
• Wrote and automated tools and scripts to increase channel efficiency and automate repeatable tasks saving 2 hours/month of programmer time and increasing the efficiency.
• Revised standard operational procedures that improved 8 functional areas by converting the legacy reports to tableau dashboards and monitoring the Key Performance indicators of sales associates. This helps in meeting the SLA’s and improving the publisher sales.
• Worked with managing leadership in prioritizing business, data requirements, process improvements and to verify the accuracy of the data.
• Create and maintain methods of cleaning and extraction of data from various data sources including raw data files for use within the Enterprise Wide Data Warehouse Systems to provide a centralized location.
• Created systems for capturing error data, sending the error data to the corresponding teams stating that the prod/dev/stag is down and requires attention to improve the health of the production servers.
• Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items, group data and refreshed, formatted the pivot tables.
• Facilitate monthly meeting with clients to document requirements and explore potential solutions.

SSIS Developer (Intern)

Confidential

Responsibilities:

• Designed SSIS Packages to transfer data from flat files to SQL Server. Assisted in mining data from the SQL database that was used in several significant presentations.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases. Assisted in creating SQL database maintenance logs and presenting any issues to the database architects. Worked with Pivot tables and V-lookups.
• Created ETL packages using SSIS to extract the data from the staging environment to partitioned tables with incremental load.