Nimesh Deepak Rajal
- 1. Nimesh Deepak Rajal 24 Hamilton rd, Apt 3, Brookline, MA 02446 | (857)-218-0755 | rajal.n@husky.neu.edu PROFESSIONAL EXPERIENCE NantHealth (Business Intelligence Engineer) Sep 2015 - Present Built procedures and Jobs to perform ETL process using SQL Server 2008 & 2012 Developed reusable Power Shell scripts to schedule all ETL and reporting Jobs. Fulfilled specific requirements of different department, in and outside the organization by generating adhoc queries. Improved performance of Database by implementing partitioning and Indexing techniques. Used Tableau to generate static and interactive reports and dashboards. Enhanced Existing ETL process to reduce the execution time by half. Worked with Data Architect for designing new MDM infrastructure. Responsible for researching and implementation of best data loading practices to consume different format data files from Clients Generated Modular and Generic scripts to load Incremental data from file using Python. Used dynamically configurable approach to customize rule implementation and execution strategy Dun & Bradstreet Credibility Corp (Java Intern) Sep 2014 - Dec 2014 Working on Companys Website development using Spring MVC and Hibernate. Refactored Web Flows for the efficient execution of different functionalities and brought down the load time of website. Improved existing code to increase usability and performance to 30%. Accenture (Associate Software Engineer) Jul 2012 - Jul 2013 Applied business logic on data by developing Informatica mappings handling around 20 GB of data. Received client appreciation for improving performance by 40 percent by optimizing the existing code. Constructed web services using Informatica to obtain real time data from user. Initiated training program for teaching Informatica Web Service to 50 colleagues. TECHNOLOGY SKILLS Big Data Technology: Hadoop, Hbase, Mongo DB, Pig, Hive, Cassandra, Mahout Languages: T SQL, Java, J2SE, J2EE, SQL,Python,Powershell and Spring MVC Database and BI Tools: Informatica (ETL), MS SQL Server 2008/12/14, Teradata, MySQL, Micro Strategy, SSIS, PETL, Tableau, Talend, QlikView & Qlik Sense, Microsoft BI and Pentaho EDUCATION Northeastern University Boston, MA Masters of Science in Information System Aug 2015 Relevant Courses: Application Engineering and Development, Advance Database, Web Tools, Business Analysis, Data Warehouse and Business Intelligence, Big Data. University of Mumbai Mumbai, India K. J. Somaiya College of Engineering Jul 2012 Bachelor of Engineering in Information Technology Relevant Courses: Computer Networks, Algorithms, Data Structures, Computer Graphics, Web-Engineering, Software Project Management and Database Management Systems. ACADEMIC PROJECTS Data Warehouse and Business Intelligence Project Jan 2015- May 2015 Worked with different data sources like SQL Server, MySQL, text and excel files having a data set of 4 million records. Modeled a Data Warehouse using Dimensional Modeling techniques with ETL tools SSIS and Talend. Used transformations to implement business rules while building Data warehouse and also collected error data in log tables. Performed analysis using Tableau 8.2 and generated reports and dashboard. Big Data Project Jan 2015- May 2015 Used Components of Hadoop Framework like Hive, Mahout, Hbase, HDFS and Pig on Airlines data set that had 38 Million records and size of 4 Giga Bytes. Performed Analysis on Hive, Pig and Hbase regarding different scenarios and provided useful information to users. Implemented map reduce code to give future prediction. Provided Graphical representation of analysis using Tableau. Real Time Bidding Sep 2013 - Dec 2013 Designed and implemented an application for real time advertisement bidding on website. Bidding is done using an algorithm, which compares predefined amounts, set by those companies.