Data Engineering

Rohit Nikam

617-***-**** *********@*****.*** www.linkedin.com/in/nikamrohit/en

EDUCATION

Master of Science in Information Systems at Northeastern University, Boston MA Aug 14 – Jul 16 Bachelor of Engineering in Computer Science at SDMCET, Dharwad, India Sep 07 – Jun 11 SKILLS

• Languages: PL/SQL, PostgreSQL, T-SQL, C/C++, C#, XML, Java, Big Query, Python.

• Cloud Services: Azure SQL Database, Azure DevOps, Azure Data Factory, Azure Synapse, Snowflake, Snow SQL, Snow Pipe, RedShift (AWS), Google Big Query (GCP), Autonomous DWH(OCI)

• Database Development/Management: MS SQL Server, Oracle SQL Developer, PostgreSQL

• Data Integration and ETL: Talend, Informatica, Boomi, SSIS, Workato

• Data Visualization and Business Intelligence: SSRS, Power BI, Tableau, Spotfire, MicroStrategy, WebFocus

EXPERIENCE

Manager, Data Engineering at Cloud Software Group. New York City, NY Dec 20 – Present

• 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 maintain CI/CD Pipelines using Azure DevOps.

• 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(Salesforce) and Finance (RevPro, Fusion, EBIZ) 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. Data Warehouse Architect at Information Builders New York City, NY Jun 18 – Dec 20

• Redesign company’s data warehouse architecture for CRM, Accounting, Billing, Revenue, Payroll.

• Handled DWH architecture of Salesforce and Workday implementation.

• Creating ETL Procedures to pull and push data between various systems.

• Continuously improving performance of data warehouse by optimizing SQL Scripts and procedures.

• Worked on various Query Optimization concepts such as Indexing, Parallelization.

• Created cloud-based procedures, functions, triggers, CTE and complex scripts using Dynamic SQL.

• Created ETL Workflows using SQL, Webfocus and I-Way DMC for data integration. Lead Database Engineer at Profit Isle, Inc, West Concord, MA Aug 16 – Jun 18

• Created, designed, developed and tested complex relational database models using MS SQL Server.

• 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.

• Designed Data Migration scripts to setup new environments for new and existing clients.

• Developed ad-hoc scripts for reports using SQL. Generated reports using SSRS, Excel and R Studio. Database Developer at Viewpoint Government Solutions, Boston, MA Jun 15 – Dec 15

• Designed, modelled and developed cloud-based database environment using MS SQL Server 2012.

• Created ETL workflows using SQL and SSIS. Created cloud based stored procedures for the BI Reports.

• Developed over 200 BI 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. Software Engineer Analyst at Accenture Services, Bangalore Jul 11 – Aug 14

• Developed and maintained over 2500 BI Microstrategy reports using dynamic MySQL 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.

• Created dynamic MySQL procedures, optimized queries using Oracle database environment.

Contact this candidate