Colorado State University Global

Data Analytics  -  Data Engineering  -  Machine Learning  -  BI  -  ETL

San Francisco, California, United States

Autodesk

Lead Data Engineer

Cloud Pro AI is an end to end solution provider for AI, DL, ML and BI solution implemented on cloud. We are working towards becoming implementation partner for Snowflake, DataBricks and Tableau. Also, we are working with AWS, Microsoft Azure and GCP cloud vendors to become their certified implementation partner. Our goal is to understand your business need, provide end to end solution and management service from data acquisition, to selecting a right data storage, build data warehouse and proposing the right analytical solution, either it be simple BI report to complicated ML, DL or AI solution putting that into CI/CD pipeline for production.Website: <a href="http://www.cloudpro.aiContact">www.cloudpro.aiContact</a>: 415-523-0199email: <a href="mailto:nimesh@cloudpro.ai">nimesh@cloudpro.ai</a>

Cloud Pro AI

CEO/Founder

- Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.•	Worked with Finance Team, Marketing Team, Customer Service Team, Alarm System Supervisors and Payroll team in identifying data related issues and solving their reporting needs.•	Analyzed the business pain points and Converted the business requirements into technical specifications.•	Performed data cleaning and feature extraction of the customer daily Alarm and Video Alarm Signals •	Leverage clustering and logistic regression techniques to build a predictive model pipeline on Marketing Data. The pipeline includes data-preprocessing, feature selection, hyper-parameter tuning, model training, and model validation. •	 Improved operational efficiency by saving time and resources by identifying relevant areas of improvement.•	Worked on models to improve customer support and customer retention by analyzing the underlying customer communication data.•	Used Matplotlib and Seaborn packages and identified interesting patterns in the data to optimize productivity.•       Used Python with libraries such as Sklearn, Numpy, Pandas, Power BI for Data Visualization, Keras, Tensorflow

Bay Alarm Company

Lead BI/ML/Data Engineer

- Support team projects with technical expertise with all aspects of the solution design and implementation, including requirements definition, data acquisition processes, data modeling, process automation, escalation procedures, construction, and deployment.•	Automate the current SQL processes and work with Vistaar software support•	Responsible for the end-to-end design, development and testing on the Vistaar Reimbursement Project. •	Extract insights from aggregated wine sales regional data using regression techniques and help Sales Team for their reporting needs per region using python visualization libraries •	Worked on Wine Sales Data and promotion materials data to build a model based on the historical figures to predict correct promotional scheme using Python libraries like Sickit-learn, pandas and numpy.•	Manages data and data requests to improve the accuracy of data and decisions made from data analysis.

Trinchero Family Estates

Sr. ML/Data Engineer

- Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel, CSV, Flat file, Delimited) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformations constraints.•Define metrics for Machine Learning models feature evaluation and model performance•Debugging Server/Client related experience•Explore and investigate different model types and techniques to improve machine learning performance•Participate in feature engineering and defining data requirements for different Machine Learning models•Improved the accessibility of multi-sourced data across the team by designing and building a high-performance data warehouse on AWS to ingest data from various data sources.•Worked with Data Scientists to extract data from AWS redshift  and build the prediction models based upon the requirements using Python libraries. •Assisted senior Unix programmers in conducting detailed analysis of system specifications as well as creating block diagrams, prototypes, flowcharts, algorithms and program logic for developing and executing reliable and efficient C, C++ or Java code with clean system interfaces and Unix scripts as required.•Wrote Custom Script to consume the Web API to do various tasks, like updating the database table based on Service response and process the data.•Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.•Work with infrastructure team to deploy the reports/dashboards.•Define and implement the migration (existing reports to Power BI) and deployment strategy leveraging industry best practices.•Creating report user groups, setting up RBAC (Role based access control) for users.•Created rich graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key areas.•Created side by side bars, scatter plots, stacked bars, heat maps, filled maps and symbol maps according to deliverable specifications.

University of California Office of the President

Sr. Data Engineer / Data Scientist

- Involved in finalizing database design, producing logical and physical models using ER/Studio, and implementation of database objects as per the data model.•Worked with Data Scientists to implement Machine learning models to Azure cloud environment.•Debug Machine learning models and perform optimization by implementing various python libraries working with Data Scientists.•Involved in implementation of database objects such as Tables, Indexes, Functions, Stored Procedures, Triggers, Constraints and Views to support the Matter Management application.•Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.•Design and Implement Database Schema, Import data and build stored procedures on SQL Azure.•Involved in analysis and redesign of existing procedures to improve performance and reduce the load run time.•Design and Implement WCF services layer hosted on Windows Azure.•This layer is the middle tier between SQL Azure and SharePoint online external content.•Involved in creating DB Schemas and ODBC connection for Local, Central and Profiler Repository.•Worked with customers on Application rollouts and server migrations.•Created project in TFS to implement source control for database objects and for offshore knowledge sharing.•Used Entity framework to combine data from more than one table in view or page.•Used the Entity Framework to merge table data together to present to the presentation layer in an editable forms.•Involved in troubleshooting, deploying and refreshing data extract to ensure data correctness in Tableau and Micro-strategy reports.•Involved in sprint planning, scrum meetings and retrospective sessions as part of Agile project development.

E. & J. Gallo Winery

Sr. BI/Data Engineer

Worked on various projects from different domains as a contractor for Adaptive Dream Solutions.While at Adaptive Dream Solutions, I worked for Navient, Otto Engineering, Universal McCann and Lincoln Financial group.•	Formulate designs and/or design recommendations which meet various requirements; balancing the goals and constraints of existing solutions.•	Convert business requirements into actionable technical requirements for the project.•	Worked on 3 terabytes of data warehousing storage, with multiple years of historical data.•	Provide technical solutions within BI team in the design process for the project.•	Designed and Built ETL packages to migrate data from different source systems using Data vault modeling concept.  •	Design and build reporting and analysis tools that help streamline the business and make reporting, analyzing, planning, and forecasting more efficient.•	Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and Snow Flake schema) using SQL Server Analysis Services (SSAS).•	Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension. •	Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse. •	Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.

Nimesh Kuinkel