Shashank Sharda

Junglee Games is online game development company, providing platform to play popular casual and real money games like Rummy, Teen Patti, Fantasy Team (Howzat), Pool, Carrom and EatMe.io.

• Generated customised architecture specifically optimised for several database technologies, including SQL, NoSQL and Big Data clients.
• Designed flows and ETL packages to combine data from multiple, varied data sources.
• Proposed and Implemented Standard BMD template with basic data schema architecture which could be used and applied for all upcoming games, this reduced time and effort to 2 days to build standard reporting, dashboards and data analytics for all new games.
• Introduced and Implemented Qubole as data lake platform for JG which helped in empowering team members across departments to use it as ad-hoc querying platform and platform for data science models
• Analysed existing SQL queries across products to identify opportunities for improvements, worked along with DBAs to bring down cost by half and time by 80% for all SQL Server based ETL solutions.
• Collaborated with Data engineering team on ETL tasks, maintaining data integrity and verifying pipeline stability.
• Gathered, defined and refined requirements, led project design and oversaw implementation.

• Created Data Models which involved creation of ETL pipelines for extracting data from multiple data SQL and NoSQL DBs for seamless integration to form data layer which can be used be used for data analytics, visualisation and reporting using python packages and SQL queries and SPs.
• Created automated Business alerting mechanism and reporting for analysis and insights about key revenue performance metrics to support business analytics and marketing.
• Created and deployed automated solution via Python and Tableau for Release impact summary.
• Implemented, administered and maintained Tableau server and desktop as BI solution framework for entire organisation.
• Migrated and updated Tableau from Windows based setup to Linux for cost efficient infrastructure solution.
• Analysed complex data and identified anomalies, trends and risks to provide useful insights to improve internal systems. Also led micro-project of retrospective fix for all data anomalies and data issues to have clean data auditing processes
• Monitored and troubleshot data source systems for data flaws and errors and upstream data issues.
• Supported multiple concurrent game projects like Rummy, Howzat, Pool and Carrom etc enabling delivery efficiencies and technical resolution.
• Built library of models and reusable knowledge-base SQL assets to produce consistent and streamlined business intelligence results.
• Trained employees on Tableau to remove dependency on BI team for their usual data needs and analysis, enabling them in self-serve mode.

• Designed and developed new functionalities and enhancements and maintaining the admin portal of Junglee Rummy, which configures the entire aspects of game, creating operational and analytics reports.
• Designed and implemented TSQL queries for reporting and complex solution development.
• Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
• Communicating and Supporting Development, Testing and Data Analysis Team
• Addressed ad hoc analytics requests and facilitated data acquisitions to support internal projects, special projects and investigations.

EPM with their flagship product Ovation provide product and services for precision control, monitoring and asset optimization of plants that produce power or that process such items as oil, natural gas and petrochemicals and other like industries.

• Created Ovation sync tool to sync all files/folders and even online Oracle DB across remote geolocation, so that ovation systems could be replicated from production to test lab site and vice versa.
• Converted the code into PowerShell scripting so that it could be easily configured in future by other developers
• Analyzed and optimized the legacy code based on the feedback sessions with the remote EU team
  

Cloudchowk was a provider of premium cloud based software products and mobile applications for medical diagnostic laboratories with the core idea being the improvement in their operational efficiency and to facilitate better patient-lab relationships.

• Created flows and low level design via use cases and user flow diagram, class diagrams and relationships, followed by implementing it by writing efficient code.
• Created the entire patient lab report module following the medical reporting standards of that time.
• Wrote and maintained complex SQL queries and procedures.
• Created a Data migration tool for clinical labs MIS (labmate) to our system
  

Nivio, a startup that looks to reinvent computing by providing a virtual computer (windows desktop) streamed over the internet to any internet connective device with applications on demand.

• Contributed to the application development using ASP.Net/Classic ASP 3.0, JavaScript and MS SQL Server 200/2005
• Participated in requirement gathering (Business and Functional) and analysis, and designing the approach of technical implementation
• Wrote SQL Queries and Stored Procedures for various modules within the app framework
• Responsible for addition of new enhancements emphasizing: maintainability, reliability, scalability and performance
• Interacted with Internal UK Teams and Application Support for clients