SUMMARY:

• Process oriented Business/Data Analyst with 4 years of experience. Experienced in interpreting and analyzing data, seeking to leverage data analytical skills to improve corporate performance as a data analyst.
• Involved in Statistical analysis , Created and modified statistical models, noting their efficacy and the limits of the data provided. Handles tasks with accuracy and efficiency
• Used advanced Microsoft Excel to create pivot tables, used VLOOKUP, and other Excel functions .
• Proficient in Microsoft Office Suite - Word, PowerPoint, Excel, Outlook, Access, Project and Visio.
• Used Python to automate the operations that are used in data cleaning, data ingestion etc.
• Hands on experience on Tableau , produced impactful visualizations and dashboards to convey the data.
• Experienced in all areas of project life cycle in a highly structured change management environment using proprietary methodologies such as Agile Techniques.
• Experienced in acquiring data from primary or secondary data sources and external or internal files; extract and analyze data to generate reports.
• Visualize data insights using data visualization tool Tableau.
• Proficient in creating Use Case Diagrams, Data Flow Diagrams (DFDs), Activity Diagrams, Deployment Views and wireframes/screen mock ups using MS Visio.

TECHNICAL SKILLS:

Programming languages: R, Oracle, HTML

Operating Systems: Windows 2008, Linux SQL

System Tools: SharePoint2010, MS Access, MS Excel, MS Visio, Tableau 9.0, MS Office

Issue tracking Tools: Jira, Service Now

PROFESSIONAL EXPERIENCE:

Confidential Bridgeport, WV

Data Analyst

• Providing technical support, analyzing and evaluating systems, equipment, process improvements.
• Involved in SharePoint development, Design and implement team site(s) and folder structure or file plan based on team’s needs.
• Determine and create custom content types (metadata). Apply permissions to content and manage permissions within the site.
• Coordinating with other internal departments including Quality Assurance, Product Operations, and Production Support.
• Retrieving data from massive and complex data sets using statistical techniques and conducted data integration.
• Perform initial analysis to assess the quality of the data and conducting further analysis to determine the meaning of the data.
• Perform final analysis to provide additional data screening and setting up with the calculations based on analysis and presenting to management.
• Participated and facilitated different levels of discussions through JAD sessions, conference calls and business workshops held to plan business strategy.
• Built Databases, Stored Procedures, Packages, Table structures and Views, writing queries using SQL Server.
• Provided end user training and extensive go-live assistance.

Environment: Microsoft Project 2000, MS Excel, MS PowerPoint, MS Visio and MS Outlook, JIRA, SQL Server 2012/2014. SharePoint2010.

Confidential Princeton, NJ

Data Analyst

• Participated on the risk management teams to onboard tranche 1- 10 departments.
• Responsible for data validation across the risk management systems.
• Created requirements document with end-to-end traceability.
• Generating responsiveness, turnaround time related metrics and performance dashboards to the management on a weekly basis.
• Weekly project status reporting, tracking milestones, issues, risks and action items.
• Experience in Data Modelling, Integration, Analysis, Reporting and Visualization.
• Visualize data insights using data visualization tool Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop Down menu option and Parameters using Tableau.
• Conducting Data Mining and Data Modelling . Collecting, cleansing and providing data modelling and analyzing the structured and unstructured data.
• Applying Software Development Lifecycle and methodologies like Waterfall, Agile and Scrum approach.
• Coordinated with team members to create impactful analyses and forward-thinking strategies.
• Communicate with executives and managerial staff regarding data findings and potential new-technologies . Data entry, data auditing, creating data reports & monitoring all data for accuracy.
• Demonstrate exposure/experience in data profiling, cleansing and data wrangling techniques.
• Excellence in data structures, programming and Demonstrated experience in understanding of complex data. Solid understanding of big data ecosystem and ability to acquire/ingest data
• Strong Analytical problem-solving skills and involved in SWOT analysis.
• Involved in creating various documents such as Use case, Business and Functional Requirement Specifications. Well versed in Project Management skills like MS Project for project planning and scheduling. Able to process new data quickly and communicate it effectively to lay individuals.

Environment: Tableau 9.0, SQL Server 2012/2014, Windows XP, Microsoft Project 2000, HTML, R, Linear Regression, MS Excel, MS PowerPoint, MS Visio and MS Outlook.

Confidential

Data Analyst

• Used MS Excel to maintain the research database and generated spreadsheets, pivot tables and dashboards, developed and initiated more efficient data collection procedures.
• Designed UML diagrams and work flow diagrams by using MS Visio.
• Involved in creating database objects like tables, procedures, triggers and functions to maintain data efficiently. Participated and facilitated discussions through JAD sessions, conference calls and business workshops held to plan business strategy.
• Hands on experience in using project management, modelling tools such as MS Project, MS Visio, Microsoft Office Suite.
• Conducted research tests and performed analysis to determine best solutions to improve product quality.
• Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables.
• Responsible for extracting, compiling and tracking data for making reports weekly & monthly basis.

Environment: MS Excel, MS Office 2007, SQL Server 2012/2008R2, Visual Studio 2010.