Rohit Nikam Email & Phone Number

Radnor, Pennsylvania, Us

Fort Lauderdale, Fl, Us

Managing a team of data engineers, providing guidance, mentoring, and performance feedback. • Proficient in Technology leadership, architecture, strategy planning, project management, customer/partner management and budget planning etc.• Establishing partnerships with key IT partners and liaise with strategic vendors in support of data warehousing initiatives• Work closely with data scientists, analysts, and other stakeholders to understand their data needs and provide solutions that meet those needs.• Develop and implement data quality checks and data governance policies to ensure the accuracy and consistency of data.• Design and Implement End to End data solutions in Azure(Storage, Integration, Processing).• Proficient in orchestrating seamless migration of Enterprise CRM and ERP Data Warehouses, transitioning them from on-prem Oracle systems to the Azure cloud infrastructure. • Pivotal role in design and development of Corporate Bookings, ARR, Forecast, Pipeline and other Sales Data Models on Azure.• Involved as primary DWH/ETL developer during the analysis, planning, design, development, and implementation stage for Salesforce and Revpro Enterprise Data using Talend Studio/Azure Data Factory and Oracle SQL/Azure SQL Data Warehouse. • Responsible for migration of Oracle SQL Server from 11g to 19c and Talend Server migration. • Managed over 200 ETL jobs on Talend Administrative Console and was responsible for scheduling, monitoring, fixing production issues and migration/deployments of all Talend and Oracle SQL changes. • Identify and resolve database, workflows, mappings, source, and target to find out the bottlenecks to ensure timely and efficient data delivery• Participated in requirement gathering, analyzing, creating the technical design specifications based on client functional specs.• Create and maintain comprehensive documentation for data engineering processes, systems, and tools to ensure knowledge transfer and continuity.

Fort Lauderdale, Florida, Us

• Build complex stored procedures, functions, ETL Scripts on SQL Server.• Design dimensional data models to optimize the use of the company’s data assets to improve business capabilities.• Analyze potential data quality issues to determine root cause and enact effective solutions• Determine business requirements from various executives and business units• Work closely with BI team to enable them to quickly write efficient, effective reports• Manage ETL collections from disparate data sources across multiple platforms• Establish standards and clearly document models• Create business views to empower end users for self-service options• Ensure data designs support best performance standards• Innovate new views via data discovery tools

Cambridge, Ma, Us

• Created, designed, developed and tested complex relational database models using MS SQL Server.• Created, designed, developed and test Business Intelligence and Enterprise Data Warehouse solutions. • Created ETL Workflows using SQL, Informatica and SSIS for data integration.• Created, designed and developed data models and data warehouses on Google Big Query and Hadoop.• Created cloud-based procedures, functions, triggers, CTE and complex scripts using Dynamic SQL.• Designed Data Migration scripts to setup new environments for new and existing clients.• Developed code to clean, extract, transform and load (ETL) client data into Profit Isle’s data model.• Worked on various Query Optimization concepts such as Indexing, Parallelization. • Created a system administration plan for SQL Servers by setting up complex test scripts, failover clustering and replication for disaster recovery. • Developed ad-hoc scripts for reports using SQL. Also generated reports using SSRS, Excel and R Studio.• Used statistical analysis tools such as R and Python to identify correlations and run regressions to look for trends and forecasting.• Recommended product changes to the development team to make importing or manipulating data easier, faster and less error prone.• Understanding clients’ business model to learn how they handle retail, distribution, selling and supply chain management to generate cost functions to build the most efficient model for each client.

Boston, Ma, Us

• Designed, modelled and developed cloud based database environment using MS SQL Server 2012.• Designed and developed UI for ViewPointCloud Web Application with HTML5, CSS3 and Javascript using the Bootstrap framework to build responsive websites.• Created cloud based stored procedures for the reports using Dynamic SQL.• Developed over 200 reports and provided maintenance and support using SSRS.• Single-handedly managed and maintained database of over 120 clients.• Created data migration scripts to setup database environments for new clients using MS SQL Server.

Dublin 2, Ie

• Developed, maintained and tested the Customer Support module of a Hospitality Service using Core Java, J2EE, JDBC, Servlets, HTML, XML and JSP. • Developed and maintained over 2500 Microstrategy reports using PL/SQL queries, views, functions and procedures and provided application support for the Microstrategy Reporting Tool. • Designed workflows, mappings, sessions and transformations using SSIS and Informatica for ETL team.• Managed and mentored five junior Business Intelligence resources on PL/SQL and Reporting Analysis. • Trained 800 people on Business Intelligence architecture and Microstrategy Tool administration. • Primary point of contact (POC) and Subject Matter Expert (SME) for Microstrategy Reporting Tool. • Awarded the ‘Star Award’ for team work and ‘Employee of the Month’, Accenture Services Pvt. Ltd. • To interact and understand the client requirements as per the Onsite and Client feedbacks.• Development of new reports based on new requirements individually and/or in teams. Giving technical sessions to new resources joining the project. • Rendering 24/7 support to the system by fixing the customer reported defects.• Recognized for effective development testing which saves several man hours in the testing team.• Managing the office cultural club to take initiatives and conduct events to make it a better place to work.

Bangalore, Karnataka, In

• Developed a Banking Management application using Java, JavaScript, HTML, JSP and Servlets. • Developed a backend database using MySQL and used JDBC to connect the application. • Implemented multiple account handling and transaction management for various customers.

Master Of Science (M.S.), Management Information Systems, General

Bachelor'S Degree, Computer Science