Nitesh Shankarlal Lohar

Role: BI and Data Architect

• Consulted and provided "value-added" insights in the form of analysis, interpretation, and advice on campaign reporting.
• Designed, executed, and measured high-impact direct-marketing experiments
• Continuously improved the campaign design and delivery by leveraging analytical tools and techniques.

Role: Data Analyst

• Worked with business users and business analysts for requirements gathering and business analysis.
• Designed and customized data models for a data warehouse supporting data from multiple sources in real-time.
• Integrated various sources into the staging area in a data warehouse to integrate and cleanse data.
• Contributed to the build of a data warehouse which included the design of a datamart using star schema.
• Designed and developed CAC, LTV, and executive dashboards.
• Developed daily, monthly, and yearly data models and dashboards for reviewing day-to-day campaigns and optimizing campaign costs.

Role: Database Administrator (DBA)

• Administered and managed the entire development, QA, and production environment.
• Increased database performance by utilizing MySQL config changes, multiple instances, and hardware upgrades.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades, and security including other administrative functions as part of the profiling plan.
• Ensured that the production data was being replicated into a data warehouse without any data anomalies from the processing databases.
• Worked with the engineering team to implement new design systems of databases used by the company.
• Created data extracts as part of data analysis and exchanged them with internal staff.
• Performed a MySQL replication setup and administration on Master-Slave and Master-Master.
• Documented all servers and databases.

Role: ETL/BI Developer

In a load webshop data project, the client had his own system called front-controller which passed data in a flat-file. It also required an ETL job to read these files and transfer the data as per the business requirement before inserting it in a database.

In the load product/category project, the front-controller system uploaded product/category related information in a CVS file and an ETL job reads these files and stores data in a database after applying the business rules.

For housekeeping, I created an ETL job to clean the data from the database based on business rules.

Role: BI/Big Data Developer

• Worked with business users and business analysts for requirements gathering and business analysis.
• Customized Saiku to export to Excel in an optimized way and implement access management for users.
• Optimized Mondrian for a large number of users in Pentaho.
• Cached the Saiku reports using an ETL and Saiku APIs for performance tunning.
• Optimized cubes and redesigned it for better maintenance and performance.
• Implemented CDC on a Pentaho Application Server cluster.
• Created the design architecture of the system.
• Implemented an SSO and customized Saiku.

Role: Oracle Database Adminstrator and Developer

• Analyzed, designed, and developed database objects and interfaces.
• Understood the business needs and implemented the same into a functional database design.
• Wrote PL/SQL procedures for processing business logic in the database.
• Tuned SQL queries for better performance.
• Composed Unix scripts to perform various routine tasks.
• Handled release preparations and customer communications on the help-desk system.
• Developed technical design documents and test cases.
• Provided customer support for various issues and change tickets.

Zoom is a retail industry product which has an interactive back office reports to analyze sales, forecasting sales, product demands and region sales, performing salesman and area wise sale, and more.

• Contributed to the requirements gathering and business analysis.
• Developed standard reports, cross-tab reports charts, and drill through Pentaho reports and dashboards.
• Generated and updated documentation of processes and systems.
• Performed unit testing and tuned for better performance.
• Was involved in user acceptance testing.

• Worked with business users and business analysts for requirements gathering and business analysis.
• Converted business requirements into high-level and low-level designs.
• Designed and customized data models for data warehouse supporting data from multiple sources in real-time.
• Integrated various sources into the staging area in a data warehouse to integrate and for cleansing data.
• Contributed to the building of a data warehouse which included a datamart design using star schema.
• Extracted data from different XML files, flat files, MS Excel, and web services.
• Transformed the data based on user requirements using Pentaho Kettle and loaded the data into the target by scheduling jobs.
• Worked on Pentaho Kettle, data warehouse design, transformations, and jobs.
• Developed Pentaho Kettle jobs and tuned the transformation for better performance.

• Gathered business requirements.
• Defined and designed the data sourcing and data flows.
• Analyzed data quality.
• Worked in conjunction with the data warehouse architect on the development of logical data models.
• Connected heterogeneous data sources like Google Analytics.
• Worked with the operational database, affiliate sites, and populated data to a centralized data warehouse using Talend Integration.
• Developed advanced analytics reports, e.g., customer lifetime values, churn rate, marketing dashboards, affiliate performance reports, and resource dashboards.