Nilotpal Kalita

NILOTPAL KALITA Professional with 12+yrs of work experience ABOUT ME A seasoned professional with over 12 years of diverse experience in Analytics and BI, Data Integration, Software Solutions Development and Support.-- Demonstrated ability to manage and deliver large, complex and High-ROI Projects/Programs in tune with the core business objectives. Indiranagar, Bangalore, India. Exceptionally skilled in bridging the gap between business and technology, in translating business requirements and process improvements through elegant technical solutions. Capable of formulating efficient business processes,providing insights & recommendations for improvements in business metrics. EDUCATION B.TECH in Electrical NIT Silchar (Formerly REC- MBA ICFAI Dehradun- EXPERTISE Project/Program Management Business Analysis Data Integration (Big Data) Architecture / Solution Design Resource Management Web & Marketing Analytics WORK EXPERIENCE Jun 2007 to Jun 2017 Sr. Advisor | Dell Technolgies Pvt. Ltd.,Bangalore Responsibilities: - Lead and manage projects end to end, maintain project charter and budget, plans. - Facilitating sessions with SMEs, Stakeholders, Architects and developers on business process/requirements - Understand, document requirements and create proof of concepts. - Identify and Interlock across cross-functional team for high sizing and work with stakeholders on funding - Resource utilization, release cycle planning and mentor, train resources. - Ensure all release criteria's met and co-ordinate for User Acceptance Testing. - Insourcing the development activities of multiple applications from vendors (based out Xiamen, China and Penang, Malaysia). Key Results: - Enabled Big Data project in Hadoop for website optimization decisions. - Enabled automated incremental data flow from Teradata to Hadoop using Sqoop. - Enabled Omni-channel data integration of external vendors data into Dell's systems to build Web failure and Speed/Stability metrics. - Silver award in 2016 for outstanding delivery and engagement in driving Data depot project and Hadoop adoption. - Enabled a platform integrating the data for all Dell's B2B targeting efforts - info graphics, transactional, sales makers' data, SFDC opportunities and pipeline. - Enabled a High-ROI program to increase frictionless order processing system in the DELL's e-Commerce purchase path. - Enable operational excellence to maintain DELL's Global e-Commerce web portal, a one stop shopping experience to all its enterprise customers. - VP Gold Award in 2013 for leading the programs, teams and the streamlining all the efforts successfully. KEY SKILLS Hadoop, Sqoop, Hive, Impala MS SQL, SSAS, SSIS Site-Catalyst, Insight - Adobe tools ASP.NET, C#, MVC, ASP, VB MS Visio, MS Project Dec 2004 to Jun 2007 System Analyst | Sonata Software Pvt. Ltd.,Bangalore Responsibilities: - Working closely with Business and support teams to resolve any issues. - For any new enhancements update the requirements and Technical specs. - Write code using ASP.NET with C# and backend in MS SQL and Oracle PL-SQL. - Packaging applications to be distributed across the organization. Key Results: - Ingerated various Hardware provisioning datasets for centralized view. - Enabled a user-friendly web based tool for new hire assimilation program globally