Resume - Charul Gupta - External
Download as doc, pdf1 like450 views
Charul Gupta has over 6.8 years of experience in the software industry working with business intelligence tools like Tableau and WebFOCUS to design and develop reports, dashboards, and databases. She has experience gathering requirements, designing, developing, and deploying complex BI solutions for clients in various industries including logistics, manufacturing, and lighting. Currently, she works as an Associate Lead focusing on BI and databases.
![Curriculum Vitae
Charul Gupta
Associate Lead (BI and database)
Active US H1B visa
charulgupta.himcs [at] rediffmail [dot] com
+91-9899966114
E-4/88, First floor, Sector 16, Rohini, New Delhi -110089, India
Experience summary
Over 6.8 years of Experience in the software industry.
? Experience in industries such as Logistics, Manufacturing, Lightning.
? 4 + years of experience in all the Latest BI Tools like Tableau, WebFOCUS Dashboard and Report
Design and Databases.
? Experience in complex BI Reports, Dashboards, Module Management, Change/Incident
Management, Maintenance, Upgrade, Fix pack installations, and Root cause analysis, Resolution
Methods.
? Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types,
visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data
Interoperability, Analytics and BI and Production Support issue resolution.
? Designed, developed and supported BI solutions, involved in Debugging and monitoring, and
troubleshooting issues/tickets.
? Experience in Developing Performance Dashboards, Score cards, Metrics, what if analysis,
Prompts, Drills, Reports/Dashboards for all the functional areas including Finance, Change
Management, Order Management, Purchasing, HR, Demand Planning, Discrete Manufacturing,
Quality, Inventory Warehouse Management, Equipment, Fleets, IT activities, Variable Objects
with formulas.
? Experience in performance tuning of SQL Server queries, involved in creating database objects
like tables, views, procedures and functions using T-SQL to provide definition, structure and to
maintain data efficiently.
? Experience in FOCUS language and HTML programming.
? Experience in requirement gathering, design, development, and deployment of
report/dashboard development.
? Possesses effective analytical and communication skills. Having onsite experience of 6 weeks,
wherein performed end to end activities.
Visa Information
? Active US H1B starting from Oct,2016 and B1 visa starting from May,2015.
Trainings and certifications
? Trained in HTML 5 under Nagarro Training Program
? Sun Certified Java Programmer (SCJP) with 90%
? Training Experience of 6 months in B.H.E.L., HARIDWAR (UTTRANCHAL).](https://image.slidesharecdn.com/9219a3bd-1fb7-4e47-aed6-102eb535b730-161109100406/85/Resume-Charul-Gupta-External-1-320.jpg)
Resume - Charul Gupta - External
- 1. Curriculum Vitae Charul Gupta Associate Lead (BI and database) Active US H1B visa charulgupta.himcs [at] rediffmail [dot] com +91-9899966114 E-4/88, First floor, Sector 16, Rohini, New Delhi -110089, India Experience summary Over 6.8 years of Experience in the software industry. ? Experience in industries such as Logistics, Manufacturing, Lightning. ? 4 + years of experience in all the Latest BI Tools like Tableau, WebFOCUS Dashboard and Report Design and Databases. ? Experience in complex BI Reports, Dashboards, Module Management, Change/Incident Management, Maintenance, Upgrade, Fix pack installations, and Root cause analysis, Resolution Methods. ? Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution. ? Designed, developed and supported BI solutions, involved in Debugging and monitoring, and troubleshooting issues/tickets. ? Experience in Developing Performance Dashboards, Score cards, Metrics, what if analysis, Prompts, Drills, Reports/Dashboards for all the functional areas including Finance, Change Management, Order Management, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Equipment, Fleets, IT activities, Variable Objects with formulas. ? Experience in performance tuning of SQL Server queries, involved in creating database objects like tables, views, procedures and functions using T-SQL to provide definition, structure and to maintain data efficiently. ? Experience in FOCUS language and HTML programming. ? Experience in requirement gathering, design, development, and deployment of report/dashboard development. ? Possesses effective analytical and communication skills. Having onsite experience of 6 weeks, wherein performed end to end activities. Visa Information ? Active US H1B starting from Oct,2016 and B1 visa starting from May,2015. Trainings and certifications ? Trained in HTML 5 under Nagarro Training Program ? Sun Certified Java Programmer (SCJP) with 90% ? Training Experience of 6 months in B.H.E.L., HARIDWAR (UTTRANCHAL).
- 2. Curriculum Vitae Skill set Operating System Windows family. Languages SQL, FOCUS, C# Technologies Business Intelligence tools like WebFOCUS and Tableau. Creation of Report Caster jobs to schedule Reports in WebFOCUS. Administration SharePoint 2010 Administration, Migration of Lotus Notes to Moss and Moss on SP2010. Scripting Languages HTML, JavaScript and CSS Data Base SQL Server 2014, SQL Server 2008 R2 Application Tools Visual Studio 2010, basic knowledge of Microsoft SharePoint 2010, Notes Migrator for SharePoint, InfoPath 2010 DBW Tools Tableau, WebFocus, SSIS Version Control Tools SVN and TFS Change Management IPCenter, Service Manager Education ? Master of Computer Application, Hindustan Institute of Management and Computer Studies, Farah, Matura, India ? Bachelor of Science (Mathematics, Statistics), St. John¡¯s College, Agra, Dr. Bhim Rao Ambedkar University, India Honors and awards ? Orion Award for best BI team of the quarter in Nagarro. ? Old is Gold Award for serving 5 years in Nagarro.
- 3. Curriculum Vitae ? Pat on the Back Award. Recent projects Development Reports/Dashboards in Tableau and database objects in SQL Server. Client: Client is America's leading provider of railcars and related freight car and freight rail management services to the North American rail industry. Project overview: Using Tableau server as a front-end BI tool and Microsoft SQL Server 2012 as a back-end database designed to developed workbooks, dashboards, global filter page, and complex parameters based calculations. Role: Sr. Tableau Developer Responsibilities: ? Functioned as Onsite/Offshore Coordinator / Project Lead ? Acted as a liaison between the client and offshore team ? Served as Quality Consultant for the client and took part in daily scrum meetings ? Coordinated with the development and testing team and other stakeholders of the project to meet desired business objectives ? Prepared and reviewed the RFP (Request for Proposal) for new client change requests ? Performed root cause analysis. ? Used excel sheet, flat files, CSV files to generated Tableau ad hoc reports. ? Prepared use cases, analysis document which got reviewed with client. ? Designed dash boards for actionable, non-actionable complaints from Multidimensional database. ? Generated dashboards to compare the expected weekly sales vs projected sales used dual axis for comparison. ? Generated Dashboards by joining multiple complex tables. ? Generated dashboard for Finance team, provided security by using user filters and Row level security. ? Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart ? Developed donut charts and implemented complex features in charts like creating bar charts in tooltip. ? Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's. ? Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis. ? Utilized Tableau server to publish and share the reports with
- 4. Curriculum Vitae the business users. ? Creation of T-SQL statements for querying database and integrating with components. Development Reports/Dashboards in WebFOCUS (BI tool) and database objects in SQL Server. Client: Client is America's leading provider of railcars and related freight car and freight rail management services to the North American rail industry. Project overview: Using WebFOCUS as a front-end BI tool and Microsoft SQL Server 2008 R2 as a back-end database to designed and developed reports and dashboards. Project Server and InfoAsist are the various featured tools available in WebFOCUS to create Managed Reporting, Transactional and operational reports, ad-hoc, drilldown reports. Report caster jobs is to schedule reports. Using HTML Composer, created rich internet interfaces to generate reports filter by passing parameter value. Preparing data by developing Stored Procedures and Views in SQL Server while for dashboards we use multidimensional database. Role: BI Lead Responsibilities: WebFOCUS: ? Functioned as Onsite/Offshore Coordinator / Project Lead ? Acted as a liaison between the client and offshore team ? Ensured allocation of tasks to offshore team ? Served as Quality Consultant for the client and took part in daily scrum meetings ? Coordinated with the development and testing team and other stakeholders of the project to meet desired business objectives ? Prepared and reviewed the RFP (Request for Proposal) for new client change requests ? Performed root cause analysis. ? Involved in creating Views and Procedures in database (SQL Server 2008 R2) and using those data objects in developing reports in Dev Server and Managed Reporting as per requirement. ? Developed reports in InfoAsist, Dev Server and Managed Reporting. ? Using HTML Composer, created rich internet interfaces to generate reports filter by passing parameter value. ? Worked on various Dashboards which is used by clients for their Business Analysis like managing Equipment, Fleets, IT activities. ? Worked on Condition based maintenance and Car billing
- 5. Curriculum Vitae projects where developed reports and handle end to end activities in the project. ? Modified/Troubleshoot existing reports that have been developed in WebFOCUS to fix issues and provided extended solution. ? Helped in analysis leading to requirements and specifications, estimates, and system designs. ? Performed functional analysis. ? Develop ad-hoc reports using Crystal/Business Objects and use HTML pages. ? Create Report Caster jobs. ? Handled report and RC job Deployments in QA/PRD Environment. ? Developed Reports for different format PDF, EXL2k, HTML, AHTML. SQL Server: ? Stored Procedures creation and verification for optimal performance. ? Index Creation and Maintenance. ? View creation and verification for optimal performance. ? SP and View used for representing date in the Reports and cubes for Dashboard. ? Optimization of existing database objects which has poor performance by using DMV and dynamic management functions. Database performance tuning and query optimization Client: Client is America's leading provider of Statistical Process Control (SPC) software and services to manufacturers worldwide. Project overview: Analyze and fix long running queries to optimize application and system performance. Role: SQL Server Database Developer/admin Responsibilities: ? Using DMV and dynamic management functions for finding out long running queries. ? Troubleshoot performance problems, fine-tuning of databases and index Analysis. ? Restructuring the stored procedure, designing, coding and developing the same using the T-SQL Programming. ? Monitoring SQL server performance using SQL Profiler to find performance and dead locks. ? Created and troubleshot stored procedures and queries performances using Performance Monitor and DBCC
- 6. Curriculum Vitae Commands. ? Rebuilding the indexes at regular intervals for better performance. Installation and Configuration Client: Client is a leading wind power solutions provider. Project overview: Project involved: ? Central farm installation and configuration by using AutoSPInstaller (Scripts of PowerShell) ? Regional farm installation and configuration by using AutoSPInstaller (Scripts of PowerShell) It involved auto installation and configuration of SP2010 at multiple locations within the country and outside the country by using PowerShell Script programming and handling action required in Kerberos authentication such as set SPN commands, AAM for various web applications, etc. It also involved configuration of shared services where producer server had two shared service (User profile and meta data service) and other services. Project involved consuming these two services on different consumer servers. Role: Sr. Developer/Administrator Responsibilities: ? Automated farm deployment of SharePoint 2010 on central and regional farms by using PowerShell Script.
- 7. Curriculum Vitae Commands. ? Rebuilding the indexes at regular intervals for better performance. Installation and Configuration Client: Client is a leading wind power solutions provider. Project overview: Project involved: ? Central farm installation and configuration by using AutoSPInstaller (Scripts of PowerShell) ? Regional farm installation and configuration by using AutoSPInstaller (Scripts of PowerShell) It involved auto installation and configuration of SP2010 at multiple locations within the country and outside the country by using PowerShell Script programming and handling action required in Kerberos authentication such as set SPN commands, AAM for various web applications, etc. It also involved configuration of shared services where producer server had two shared service (User profile and meta data service) and other services. Project involved consuming these two services on different consumer servers. Role: Sr. Developer/Administrator Responsibilities: ? Automated farm deployment of SharePoint 2010 on central and regional farms by using PowerShell Script.