SUMMARY

• 4 years of experience in e - commerce, healthcare and IT organizations.
• Experience in business intelligence and data analysis, Reporting, Data Preparation, Data warehousing, Visualizations, software and predictive model design and development using Tableau, RDBMS tools, IBM Cognos, Power BI, Excel, python.
• Solid Knowledge in SDLC, Water Fall Model, Spiral Model and Agile Scrum Methodologies from the organizations. Knowledge in SDLC, Water Fall Model, Spiral Model and Agile Scrum Methodologies from the organizations.
• Experience in Documentation tools like MS Visio, MS Project, and MS Office to create reports required for the projects and client submissions.
• Extensive knowledge in Machine learning, Data mining, SQL Queries and Databases.
• Proficient in writing queries and sub queries to retrieve the data using SQL from various servers including Microsoft SQL, Oracle and MySQL.
• Deep knowledge in Linux environments and hands on experience in Terminal and UNIX commands.
• Interacted with several SMEs, Stakeholders, Clients and Vendors from different regions around the world over the years for better understanding of their business processes and expertise in gathering business requirements and Scrum methodology.
• Worked on generating ad hoc report and analyzing the data for fixing the errors and expert taking initiatives in taking Business decisions.

TECHNICAL SKILLS

• Tableau
• Power BI
• SQL
• Python
• GRETL
• R
• Microsoft Visio
• Microsoft Project
• Excel
• Access
• HTML
• XML
• MySQL
• SQL
• Microsoft SQL Server
• UNIX
• Microsoft BI Tools (SSAS
• SSRS)
• Java
• QlikView
• Logisim
• OpenGL
• CISCO Packet Tracer
• NS2
• Mini Tab
• TASM
• XLSTAT
• RapidMiner for Data Mining

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Round Lake, Illinois

Responsibilities:

• Worked for Global Technical Services Team at Confidential International Health care corporation.
• Generated Monthly Global Metric/ KPI reports for the Global Service Performance to US, CA, Europe and Asian Regions.
• Worked on weekly GSP BI reports and supported Ad-hoc reports with request by Users/Engineers using Cognos 11.
• Generated Product Performance KPI Dashboards using Tableau.
• Worked on SQL queries to generate reports and create ODBC connections using Oracle GSP.
• Updated/Managed data and queries using PLSQL and retrieved data related to equipment’s performance and quality reports.
• Converted Excel spreadsheets into automated MS Access 2013 Database for KPI tracking tools.
• Worked parallelly on different regions using Oracle PLSQL and gained knowledge on various domains in databases
• Generated Monthly Product Performance Reports using GSP BI.
• Automated tasks for Ad-Hoc, metric reports and excel spreadsheets to reduce the work load, quality and to enhance time redundancy
• Performed weekly and bi weekly team meetings with team
• Automated Access with Excel to extract information from various Excel files and imported them into MS Access.
• Held Walk throughs with QA, BA, SMEs and Stake holders for better understanding of Data Analysis with Reports.
• Created Dashboards using IBM Cognos 11.0 and Tableau.
• Worked in Sales Data & Insights team. Performed Data mining, clustering and regression testing using RapidMiner and R.
• Assisted on creating algorithm to detect anomaly detection on abnormal events for the month to month sales of medical devices to prime distributors.
• Worked extensively on trials to analyze the sales data production for predictive models using Machine Learning techniques like KNN and distance algorithms.

Data Analyst

Confidential, Rockville, Maryland

Responsibilities:

• Worked on a federal project for DAIDS Regulatory support (NAIDS division) as a consultant for health Informatics Company.
• Generated weekly, monthly ad-hoc reports and clinical trial reports.
• Responsible for checking the daily inbound, outbound data activities and update appropriate EMR data in the back end of the production server.
• Extensively worked on MS SQL server to retrieve, validate and generate the clinical data using SQL queries.
• Worked with senior programmers and QA personnel in performing unit and user acceptance tests to ensure best performance and compatibility of MS Access database or applications on various platforms as well as provided regular system updates as required
• Worked closely with manager, vendors(sub-contractors) and held status meetings on the project
• Assisted production support for the project and took actions by providing appropriate resolutions.
• Used SSRS to generate vendor related requirement reports on request.
• Involved and worked on data manipulation for different data sets.
• Performed data clean ups on a regular basis using SQL scripts.

Data Analyst

Confidential

Responsibilities:

• Worked on resolving tickets as a team member in Retail Business Services.
• Responsible for writing SQL scripts which analyze the aggregated business data.
• Developed KPI, Quality and financial reports and visualizations using Tableau.
• Developed weekly predictive models for competitive pricing and limiting of products.
• Used Pivot tables, VLOOKUP, Index, Match and charts extensively using Excel for the business requirement.
• Created visualizations to present analysis findings to the internal team and prime vendors.
• Performed data collation, interpretation and visualization using Excel, SQL and Tableau.
• Worked extensively on writing SQL queries to retrieve vendor related business data.
• Responsible for data management of products’ inventory, lifecycle management and procurement using varied vendor management tools such as Procurement Portals, YUMA and Agile.
• Held walkthroughs with the developers and QA teams to create a better understanding of the system requirements.

Business Intelligence Analyst

Confidential

Responsibilities:

• Created and formatted clinical reports from hospital clientele to assess performance and supply chain statistics using IBM Cognos.
• Responsible for optimizing SQL queries to get data results which are accurate and validated accuracy of data to ensure database integrity.
• Used IBM Cognos Framework Manager for importing and retrieving Meta data from database and Query Studio for Meta data manipulation and leveraging client queries and requirements.
• Generated Dashboards using Microsoft Power BI.
• Responsible for data collection and assessment to optimize and store data.
• Used IBM Cognos 8 to generate prompt & burst reports and various charts (Pie Charts, Bar Charts, Colum Charts, etc.) For data analysis.
• Created schedules to run reports at specific time in client environment.

Intern

Confidential

Responsibilities:

• Worked as a Java Developer
• Worked on an E- Commerce Computer Sales and Management project to design databases and to retrieve the data with the help of SQL scripting using SQL server
• Designed web pages for company using HTML and Apache Tomcat
• Worked on localhost and Admin Console.