Harsh Sutaria

Long Island Hicksville, NY, ***** 704-***-**** ade8g4@r.postjobfree.com

www.linkedin.com/in/sutariaharsh/

I AM:

Proven ability to rapidly design, estimate, prototype and implement complex systems in an atmosphere of evolving project requirements using AGILE SCRUM methodologies and followed SDLC Methodology.

Highly analytical and skilled Business Intelligence (BI) professional with experience in BI systems design, planning and strategy implementation.

Demonstrated ability to work independently and work within a team to accomplish tasks under minimal direction and supervision.

Experienced in ETL Tools and Software Development

A highly motivated engineer with acumen to solve complex business and technical problems

Liaison between the Business unit and Technology team to ensure communication while resolving technical issues

Expert in areas of requirements gathering, project architecture, design and development

Proficient in Informatica 86/91, Teradata 131, Datastage 87 and HP ServiceCenter based software development

Experienced to bridge gaps between technical specifications and customer requirements

Proficient in leading and mentoring individuals while forming cohesive team environments

SKILLS:

Technical: Java, Python, JSP, SQL, HTML, Informatica 86/91, Data Stage 87, Github, Crucible, Jira, Jenkins, JavaScript, Maven, Unix Shell script, XML, CSS, Microsoft SQL Server2005/ 2012,MySQL, Puppet Scripting, EC2, DB2, Teradata 13.1, Oracle, BO ( Business Object),Star Uml, WinSCP, Putty, Weka, Rapid Miner, Mozenda, Visio, Unix, HP ServiceCenter 628,Tomcat, Android SDK, Linux, Windows, Eclipse, MS Visual Studio, Excel Macros, Perl, VBA, Alteryx, Micro Strategy

Management: IT Service Management, Requirements Gathering and Analysis, Visio, Data Flow Diagrams, E Commerce,

Troubleshooting, Team-oriented, Communication, Collaboration, agile development, SCRUM

Methodologies, CMS tools. HIPAA Compliance, ERP, E- Commerce, ICD 9/10 codes, BRD.

ACHIEVEMENTS & CERTIFICATIONS:

Certificate of Appreciation for optimizing their legacy system and created good repo for Business Analyst role of gathering requirements. Liberty Hardware – 2014

WORK EXPERIENCE:

Information Resources Inc(IRI) Long Island,New York Technical Project Manager June 2018 – Present

Leading team of 9. Managing several clients like Pfizer, Dr Pepper, Altria, Anheuser Busch, Costco, Spins, Uilever and so on.

Doing Data Analysis and providing data/reports according to the client needs is my forte.

Working on different scope for different client deliverable, managing client expectations, managing timings in order to create a smooth process.

Working with Cross function team with developers in US as well as in India, along with working on few important client deliverables myself since those are reported to Executives

Providing training, guidance and clarity to the developers when need and being the bridge between several teams.

Responsible for timely deliverables of all the clients along with managing new request

Managing huge data extracts and implementing code to process the data as per requirement.

Information Resources Inc(IRI) White Plains, New York Business Intelligence Developer/Analyst July 2016 – June 2018

Client: Dannon

Project Management, requirement scoping, report development, time management, working on multiple projects is my day to day work.

Working with cross functional team like marketing, sales, operations, development and media.

Working onsite and doing 4 to 5 projects and multiples roles as per client needs using visualization tool Unify.

Creating offline reports in excel using Lookups, Macro and VBA and online liquid data reports in Unify. Leading a support call for clients with their report building and tools.

Creating dashboard, charts, and stories. Automating the reports.

Leading the call for support offered to the client for our solutions.

Being the lone developer on the team and being the go to guy for the clients and the IRI team at Dannon.

Handling multiple databases coming from IRI POS, Panel, Shopper Sights and Clients data and incorporating into the reports as per client’s needs.

Using Alteryx for QC purposes.

Driving the client with their business needs and providing them healthy solutions and managing the India team to do some of the development work.

Cerner Healthcare Corporation, Kansas City, Kansas Software Engineer Feb 2015 – July 2016

Project: Add Appointments Revenue Cycle

A brand new workflow to schedule patients in order to replace the existing scheduling workflow.

Implemented a new workflow to schedule which increases the efficiency by 25 % with the expected realized savings of 30%.

In addition to that the new workflow is allowed to schedule multiple orders without experiencing any performance and technical issues.

Analysis and Design

There were too many controller calls going from a single controller and so I suggested having multiple controllers to make the call in order to make efficient workflow.

Hand-on Technical Skills

Developed UI in HTML, CSS, Javascript, jQuery, Terra

Wrote unit tests using JUnits, Qunits, Mockito, Clover

Wrote delegates using JSON-RPC protocol in Java to interact with XML request replies from the server

Mentored new engineers and performed code reviews using Crucible

Following Agile development with daily Scrum along with Iteration process

Project: Registration/Scheduling Enhancements

Worked on accomplishing and delivering multiple Java based enhancements on the Patient Scheduling and Registration solutions of Cerner

Developed for all layers of the solution from UI to Services

Enhanced the existing scheduling UI layer by adding new interaction features in HTML, JS, jQuery

Added business logic to the model layer in an MVC architecture to support new features to the solution

Worked in teams following Agile management methodology with daily SCRUM

Applied continuous integration using Jenkins and Hudson

Managed dependencies using Maven

Used tools like Findbugs and Clover to write maintainable code and reduce technical debt

Internship: Liberty Hardware, Masco Company, Winston-Salem Business Intelligence/Analyst Jun 2014 – Aug 2014

Project: Liberty Hardware Database

Optimized the legacy system for Liberty’s database which use to take really long time to get loaded.

Worked on SSIS and query optimization, which lead to 40% faster response for the data to get loaded for legacy systems

Analysis and Design

There were many redundant tables and data used. I suggested a way to remove redundancy using joins and fix their database.

Hand-on Technical Skills

Gathering requirements for E-Commerce website and contributed with the project management aspects creating DFD using Microsoft Visio and CMS tools

Created Business Requirement Document for E-commerce project and worked on SSIS and Sql Server 2012

Implemented performance tuning and Query optimization to create efficient SQL views and procedures

Accenture Services Pvt Ltd, Mumbai/Pune Associate Software Engineer May 2012 – Jun2013

Client: TD-FINANCIAL GROUP, CANADA

Data conversion from legacy MBNA to new TD BANK systems conversion of 9 Million accounts in short period of 10 months.

Created Jobs using Datastage an ETL tool and converted data from DB2 to Unix and DB2, built various models and performed

Extractions and load on Datastage

Implemented Transformation Logic, creating LLD, Interacted with clients via calls, made test case scenarios, Unit testing of

Jobs, defect fixing

Client: KOHLS US RETAILS,USA

Created a community data warehouse for the EDW Store

Created a Datamart using Informatica PowerCenter, an ETL tool

Created SCD type1 and SCD type2 mappings, which required complex queries in SQL, Created Jobs and Events on

ESP Server Built mart for various departments (eg Finance,HR etc), utilizing Unix and Winscp Tools known for

Secure and volatile environments.

ACADEMIC PROJECTS:

Developed Event Manager for UNC Charlotte, a mobile Android application that reminds students of events, seminars

happening on campus or other events of student’s interest according to students class schedule and will also help

students to manage their other activities. Was a SCUM Master during the project and created high level designs using

Visio, UML tools and VB. Also leaded the team mates to meet the deadlines and the approach of doing the project

Developed Flight Reservation System, a website with facilities of searching flights, booking tickets, adding to cart

and flight cancellation Implemented using JSP, Servlet, Sessions Beans, Cookies and Javascirpt

Developed Online Book Store, a website which includes book search, adding books to cart, buying books and order

cancellation Implemented using HTML, CSS, JSP and Servlets, Database used MySQL.

EDUCATION:

MS in Information Technology, University of North Carolina Charlotte, Charlotte Dec 2014

Courses: IT Project Management, Software System Design and Implementation, Big Data Analytics, Network Based Application Development, Knowledge Discovery in Database, Web Mining, Applied Database, System Integration

BTech in Computer Engineering, Narsee Monjee Institute of Management and Higher Studies, Mumbai, India April 2012

Contact this candidate