SUMMARY:

I am an experienced Data Analyst with a demonstrated history of working in the industry and also in the academic field. I am skilled in SQL, Database Design and Development, Data Analysis, Data Visualization and Agile Methodologies. I am a detail - oriented person who enjoys resolving complex problems, working with data, and mentoring others. I consider my analytical skills, leadership skills, customer service and communications skills as my greatest advantage. I am determined to work hard by providing my analytical skills along with the knowledge of Microsoft products and Internet Application skills up to best.

SKILLS:

Quantitative Methods, Data Warehousing, Advanced Data Mining, Business Intelligence, Data Structures, Regression Analysis, Six Sigma, Data Visualization, Data Technologies, Data Science Research Methods, Research Data Management, Statistical Computing Methods, Experimental Design & Analysis.

Proficient in SharePoint, SAP, SPSD and other Business Systems software applications.

Advanced Expert in MS Office (Access, Word, Excel, Project, and PowerPoint), Adobe and Visio

Experienced with Spotfire, Jira, BO, ASP.Net, VB, Business Management, C, C++, CSS, CSS3, XML, FDS, GUI, HTML, HTML5, IDE, javaScript, jQuery, team leader, C#, Microsoft SQL,TeamSite, Sequel, MySQL,RMS, MS Project, Primavera, Jira, Scrum, Agile, SDLC.

Kaizen Events, Value stream mapping, Knowledge Management Tools, Lean methodology.

Expert in IBM SPSS, Pivot Tables, Macros, Visual Basic, Tableau, SAS, BI Tools (SAP, BO), SQL, Strong analytical and quantitative skills, Programming (HTML5, C++, Java) .

Software: Oracle SQL, Tableau, Cognos BI, Telerik Reporting, Mercury, RMS, Actuate, SPSS, TeamSite, SAS Enterprise Miner, Google Analytics, RStudio, SQL Server Management Studio, Crystal Reports.

HOGAN, BETA, WISDOM, Smart Station, MDX, e-Brokerage, Client-Link.

PROFESSIONAL EXPERIENCE:

Confidential, Saint Louis, MO

Business Data Operations Analyst

Responsibilities:

• Run daily, weekly and monthly reports for STL & GENPACT teams.
• Run Performance Analysis for both teams daily, weekly and monthly along with the Capacity Reporting.
• Conduct business analyses and identify opportunities to maximize operational efficiency, quality and compliance. Findings are then recommended through presentations to managers.
• Work with manages to apply data to business goals and analytical requirements, which includes capacity planning, volume forecasting and unit costing.
• Manage vendor relationships, defining user requirements and performing user acceptance testing. Manage small projects requiring some coordination, and participate on task forces or project teams.
• Identify, develop and implement policies, procedures and training materials to assure compliance with government regulations and to maximize efficiency and customer service.
• Monitored and pulled error data from SharePoint, Wisdom (and other applications), tracked and organized it using Access Databases, SQL queries also using macros, excel filters and various other functions to delegate to the Onshore and Offshore associates.
• Manage two main SharePoint sites (Onshore & OffShore) and tools, developing the process.
• Identify glitches and design strategies to overcome those using new tools & technologies along with my analytic expertise. Logged and tracked the volume of error reports on a daily basis.
• Assisted in the VDA project to Research, analyze and document important financial information and other data for internal employees and Financial Advisors.
• Performing monthly KRI (Key Risk Indicating) Tables, Performance Summary, Activity Data Tracking projects for the upper management.
• Performed multiple projects simultaneously by adapting to changing business priorities, applied new concepts to solve complex business & technology problems and unexpected challenges.
• Created visually impactful dashboards/Metrics in Excel and Tableau for the purpose of data reporting using pivot tables and VLOOKUP. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
• As a new tool, use Six Sigma and trim unnecessary operations and processes within the department.

Confidential, Cape Girardeau, MO

Data Analyst & Information Technology Graduate Assistant

Responsibilities:

• Launched a new housing portal using ASP.Net, Mercury templates, HTML5, CSS, CSS3, AJAX, XML programming languages and created a database using Microsoft SQL (Microsoft Access).
• Created and updated campus housing database using Microsoft SQL.
• Created a new Microsoft access database for Mercury templates. (Mercury 2 & Mercury 3)
• Created and updated all Daily, Annual, Semester Reports using Cristal reports, SSRS and Telerik reports and implemented using Excel charts and Spotfire. Created SSIS packages
• Created new template and mapped all the buildings using Mercury template designer.
• Created new web pages using HTML, JQuery and JavaScript. Utilized SPSS and statistical software to track and analyze data. Conducted reports for implementation of strategies, leading to the growth in student housing. Maintain all the sites, data, software’s and tools needed.
• Optimized data collection procedures and generated reports on a daily, weekly, monthly, and quarterly basis. Used advanced Microsoft Excel to create pivot tables, used VLOOKUP, and other Excel functions.
• Create process flow charts to plot residence activities using Visio and other editing soft wares. (Photoshop)

Confidential, MO

Data Analyst Lead

Responsibilities:

• Managed, directed, and prioritized Carpe Diem Annual operational budget of 10K+.
• Provided custom reports and queries (Excel XLT, pivot tables, Excel Charts, and Spotfire).
• Manage, monitor, and evaluate the performance of all related ORL Staff, total staff of 125+. Directed the hiring, training, and scheduling of all Carpe Diem Event Associates by an intermediary, totaling 50+.
• Used Business Intelligence software platforms such as SAP, BO & etc.
• Used SharePoint, SAP, BO software platforms to interpret data with the use of HTML
• Supported & resolved data mapping and configuration issues with the use of ETL, SQL, XML, etc.
• Used statistical techniques for hypothesis testing to validate data and interpretations
• Jira software development tool was used to plan, track and release the final outcome of the project.
• Presented findings and data to team to improve strategies and operations in Residence Life, SEMO
• Conducted major six sigma improvement projects and makes predictions using the outcomes.
• Used Six Sigma concepts to improve quality and reduce defects within the department, while also learning Lean principles.
• Created visually impactful dashboards/Metrics in Excel and Tableau for the purpose of data reporting using pivot tables and VLOOKUP.
• Used SAP, to make sure it helps enforce financial, process and legal controls & facilitates the effective use of resources, including manpower, and production capacities.

Confidential, MO

Technology Assistant/ Data Analyst

Responsibilities:

• Database/system administrator for RMS- Residential Management System generating reports, managing student housing portal. (Mercury2 and Mercury 3)
• Update the residence life housing portal with day to day changes.
• Creating pages and fixing issues & monitor, maintain waitlist for room reassignment.
• Analyzed and corrected incoming data through communication with the residents.
• Coordinate and facilitate the early arrival check-in process for international students.
• Manage the planning and development of design and procedures for metrics reports
• Develop new reports and delegated tasks to team members (Adobe Captivate, Excel Charts, and Spotfire).
• Investigate and conducted study, forecast on student housing portal for Residents who live On Campus.

Confidential, MO

Data Analyst/ IT Consultant

Responsibilities:

• Analyzed and corrected incoming data through communication with campus wide offices.
• Created templates and reports to aid. Created visually impactful dashboards/Metrics in Excel and Tableau for the purpose of data reporting using pivot tables and VLOOKUP.
• Supported and resolved data mapping and configuration issues (ETL, SQL, XML, etc.).
• Provided custom reports and queries (Excel XLT, pivot tables, Excel Charts, and Spotfire).
• Provided information analysis on advanced and complex datasets (SQL, XML, etc.).
• Provided technical support for data mapping issues and performed ETL to migrate data.
• Used Six Sigma concepts to improve quality and reduce defects within the IES Department.

Confidential

System Data Analyst / SQL Developer

Responsibilities:

• GUI application implemented using C# (Microsoft Visual Studio 2008 IDE) programming language and created a database using Microsoft SQL.
• Include Room Reservation, Customer Details, Employee Details, Taxi Reservation, Accounting, Reports etc. Created Daily, Monthly and Annual reports using Cristal Reports, SSRS and Excel.
• Created SSIS packages. Maintained and updated the student Database. Analyzed and Documented customer requirements. Managed and maintained project knowledge database and supported production applications. Assisted area coordinator with planning and estimation of the project.
• Used Six Sigma concepts to improve quality and reduce defects within the firm.
• Provided custom reports and queries (Adobe Captivate, Excel Charts, and Spotfire).

Confidential

System Data Analyst

Responsibilities:

• Worked directly with users to identify and resolve all data related issues in their day-to-day workflows.
• Worked with technicians to review and validate data quality. Assisted with Data Integrators by providing scripts and queries. Tracked and Documented client requirements for gap analysis work relating to the Data Warehouse. Provided results to the Data Architect and ETL Analysts to customize the Data Warehouse.
• Created data maps for all data sources being loaded to the Data Warehouse.
• Used Six Sigma concepts to improve quality and reduce defects within the firm.