GAURAV KUMAR

• The project was on reports related to Bank, Healthcare, Oil, Aviation, Digital data and data on server
• Batch processing via Oracle and Memsql and analysis via Tibco Spotfire platform and Tableau reporting were the key features of the project
• Database locks for bank lender & borrower, employee details, last data generated, summarize data, grand total expenses were some of the key data attributes
• Python, JAVA, SQL and R were the key environment also including Oracle, DB Visualizer, MS Excel, XML,
• Created BI specifications for clinical trials database lock metrics - LDG (last data generated), FPLV (first patient last visits), Interim database locks, Interim Data Cut Offs and more
• Created Job file (in XML module) to automate the reporting tasks
• Created Information Links with prompts, on-demand loads, transformations, joins, parameterizations connecting to data sources and files
• Designed folders in Spotfire Library, administered users/groups, analyzed back-end spotfire database, tracked memory/CPU usages of Spotfire Server and Web-Player Server
• Used d3.js (Data-Driven Documents) for interactive and appealing visuals utilizing HTML Text Area features - JAVASCRIPT, HTML, CSS and IronPython
• Designed specifications for custom functionalities and dynamic visualizations within DXP's
• Manipulated data tables, columns, rows, cell values, document properties, document metadata, filters, markings using IronPython to achieve interactions
• Created specifications for data transformation - information links, custom expressions, calculated columns, data wrangling with python, advanced custom expressions (THEN/OVER).
• Proved successful working within tight deadlines and a fast-paced environment.
• Delivered services to customer locations within specific timeframes.

• The analytics project involved financial data relevant to auditing and accounting
• Analytics platform involved Tibco Spotfire with Python/SQL customization and Information Links import
• The key metrics involved financial data entities
• Other sources included Sql Server relational data plus various file formats incoming from external clients
• Tracked data quality issues and reporting requirements in Quality Center
• Modified the existing database models for both relational and dimensional databases
• Created conceptual, logical and physical data models to depict the level of granularity of measures and distribution of dimensions
• Created specifications for real-time streaming processing
• Created Information Links to load data on demand controlled by document properties, expressions, limiting and parameterization
• Created Map charts comprising of Map Layers, Feature Layers based on Geo-coding tables and Co-ordinate Matrix Systems
• Used HTML and CSS along with JavaScript features to design Text Areas
• Used Web Player Configuration to control initial state of dashboards
• Used Marking and Filtering selection via Iron Python scripts to automate the functionalities of dashboards
• Transition:
• I have transition level experience while providing and arranging KT in last 2.5years
• Also including shadow and providing documentation & access.
• Skilled at working independently and collaboratively in a team environment.
• Delivered services to customer locations within specific timeframes.

• HVO SFT Dashboard Drilldown, Alteryx ETL, SFT Dashboard Drilldown
• Tools & Technologies: Alteryx ETL Tool and SQL
• Description:
• It aims to generate the reports through automation process and time efficient
• Data sources are imported through Alteryx Input Tool
• It is designed and mapped by using join transformation to different source files and different format using Alteryx designer
• In this project report development is done for 100% complete view of the business
• Generated different reports in Alteryx by connecting to the database in which the source tables are created.
• Tools & Technologies: Alteryx ETL Tool and SQL
• Description:
• This report is basically run quarterly, So here we had use dynamic Date () and some complex mapping as per requirement.
• Data sources are imported through Alteryx input tool
• It aims to generate the reports through automation process and time efficient that can reduce the manual effort by 90%.
• As earlier client was generating these reports by doing manual process
• It is designed and mapped by using join transformation to different source files and different format using Alteryx designer
• Generated different reports in Alteryx by connecting to the database in which the source tables are created
• In these development report I come across the analysis phase, requirement gathering phase and many calculation & transformations has been done based on the project requirement
• After all transformation and development complete then I generate different reports in Alteryx based on the output result after transformation
• I have the expertise to transform data into valuable insights that drive business success.
• From data blending and cleansing to predictive modeling and reporting,
  I have the skills to create custom solutions that meet your unique business needs.
• Planned, designed, and scheduled phases for large projects.

• SFT Dashboard
• Tools & Technologies: Alteryx ETL Tool and SQL
• Description:
• It aims to generate the reports through automation process and time efficient
• As earlier client was generating these reports by doing manual process
• Data sources are imported through Alteryx Input Tool
• It is designed and mapped by using join transformation to different source files and different format using Alteryx designer
• In these development report I come across the analysis phase, requirement gathering phase and many calculation & transformations has been done based on the project requirement
• After all transformation and development complete then I generate different reports in Alteryx based on the output result after transformation.
• Developed and maintained courteous and effective working relationships.
• Acted as a team leader in group projects, delegating tasks and providing feedback.
• Proven ability to learn quickly and adapt to new situations.
• Used critical thinking to break down problems, evaluate solutions and make decisions.

• Census Reporting System
• Tools & Technologies: Oracle (Database), ETL Tool ( Informatica, Teradata), Data Visualization (Tableau)
• Description:
• It aims to generate the reports to gather information about member of given population
• Designed the mapping for different given source files using informatica power center designer
• Generated different reports in Tableau by connecting to the oracle database in which the source tables are created.
• Tested data prediction algorithms based on historical data.
• Utilized data visualization tools to effectively communicate business insights.
• Used statistical methods to analyze data and generate useful business reports.
• Analyzed data to identify root causes of problems and recommend corrective actions.
• Designed and developed data pipelines to acquire, clean and process data.
• Deployed predictive analytics models to forecast future trends.

• US Cancer Analysis
• Tools &Technologies: Oracle (Database), ETL Tool (Informatica, Teradata), Data Visualization (Tableau)
• Description:
• The theme of the Project is to evaluate a type of Cancer on a specific Race of a US citizen
• Designed the mapping for different given source files using informatica power center designer
• Generated different reports in Tableau by connecting to the oracle database in which the source tables are created.
• Produced monthly reports using advanced Excel spreadsheet functions.
• Tested data prediction algorithms based on historical data.
• Developed required policies and procedures that reflected actual goals, tasks and workflows, while meeting all regulatory compliance requirements.
• Used statistical methods to analyze data and generate useful business reports.
• Provided technical support for troubleshooting analytics and reporting issues.
• Developed data mining algorithms to identify and classify patterns in data.

• Awarded 2nd Position in Coding Hackathon.
• Completed professional development in Data Science.

GPA: 72.4

• Completed professional development in Computer Science.

GPA: 70.1

• Elected Captain of Inter School Cricket Team captain.