• Expertise in Informatica ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools • Extensive experience in the Data Warehousing implementations, Data Migration and ETL for finance • Very good understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows and UNIX Specialties • Date Warehousing with Business Intelligence and Data Mining • ETL Tools: SQL Server Integration Services (SSIS), Informatica Cloud Security Agent,SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS),Informatica, Talend, Pentaho Kettle, QlickView, TIBCO Databases / Application Server: AWS (S3, Redshift, RDS), MS SQL Server 2008,Oracle 11g(SQL, PL/SQL)

Data Warehouse Consultant @ • Working extensively on Amazon Redshift and Talend ETL to build scalable/optimized metadata DW layer • Working on robust, scalable Data Warehouse platform to suffice the Tableau dashboards as well as the ad-hoc reporting needs from multiple sources • Building a scalable Data extraction framework on Talend to pull data from multiple sources such as MySQL, Stripe API and ActiveMQ Working directly with Senior Sales executives to understand and deliver their reporting / KPI needs From March 2015 to Present (6 months) Campbell CaliforniaData Warehouse Developer @ • Developed various mappings, reusable transformation and validate ETL logic coded into mappings • Developed the mapping to pull the information from different tables and used SQL override to join the tables instead of joiner transformation to improve the performance using Informatica • Designed and developed complex Informatica mapping, mapplets, reusable transformations, workflows and worklets using various task to facilitate daily, weekly and monthly loading of data • Implemented lookups and different transformations in the mappings • Created various documentation for process, mapping, test cases etc. • Facilitate scrum ceremonies (sprint planning, retrospective, daily stand-ups, etc.) • Collaborating with teams globally, building relationship to coordinate project objectives and goals From September 2013 to February 2015 (1 year 6 months) San JoseGraduate Student @ Masters in Information Systems From September 2011 to August 2013 (2 years) Greater Boston AreaDatabase Intern @ • Participated in Product design meetings with the client PCA • Designed plan for a MS-SQL Server 2008 database and wrote queries • Data analysis for Refractor PreBeta tools and reported bugs using PCA Central tool • Tested and installed, developed application to production • Analyzed and generated results reports for various component using SQL queries • Worked on background reports for various Cisco products • Worked on Dashboard for releasing reports of various projects From August 2012 to June 2013 (11 months) Tewksbury, MA 01876AV Tech Assistant @ • Assisting with installation, troubleshooting of Audio and Video Equipment in the University Campus. • Reporting to the in charge member about the major issues and generated tickets From May 2012 to August 2012 (4 months) Greater Boston AreaSoftware Developer @ • Collaborated with business client (Crompton Greaves) to analyze current system performance and formulated the best approach to improve the efficiency of the application without impacting the dependent interfaces • Analyzed business needs and created detailed technical document based upon business requirement • Developed web based application using ASP.NET with VB, Oracle 9i and JavaScript • Implemented 3rd party tool DevExpress in projects which helps clients for Grouping, Filtering, Group footer summary and Column swap in grid view control. • Contribution to database design in Oracle 9i(Created tables, constraints, stored procedures) • Performed under minimal supervision, met deadlines as an individual contributor From June 2009 to January 2011 (1 year 8 months) Nasik Area, IndiaSoftware Developer @ • Studied and analyzed software requirements specification (SRS) for client • Designed and developed the web application for employees work order details for making daily time sheet entries. • Developed web based application using ASP.NET with C#, MS-Access and JavaScript • Implemented Crystal reports as per requirements of clients • Tested and deployed the developed application to client, also provide support after delivery • Reporting to Project Manager about the daily and weekly status From November 2008 to May 2009 (7 months) Nasik Area, India

MS, Information Systems @ Northeastern University From 2011 to 2013 B.E., Computer Engineering @ University of Mumbai Amit Sonavane is skilled in: JavaScript, ASP.NET, SQL Server, .NET, Programming, Data Warehousing, ETL, Oracle 11g, Java, SSIS, Informatica, SSAS, Talend, ADO.NET, Crystal Reports, Oracle, Analysis Services, Microsoft SQL Server, DevExpress Controls, Visual Studio, VB.NET, PL/SQL, Visio, MySQL, Objective-C, Cocoa, Xcode