PROFESSIONAL SUMMARY

• Proficient knowledge and experience in finance (investment management), supply chain, and retail domains.
• Experience in Database design, entity relationship, process modeling, coding stored procedures, triggers, views, functions in MS SQL Server, Sybase ASE, and Oracle, T - SQL, PL/SQL.
• Experience in development and design of business intelligence (BI) dashboard reporting solutions, enterprise data management and application integration. Experienced in various aspects of Master Data Management, Data Cleansing and Data Profiling. Experienced in migration and conversion of data to/from various data sources.
• Expertise in variety of technologies, databases (MS SQL Server, Sybase, and Oracle) and languages (PL/SQL, TSQL, J2EE, Visual Basic, JavaScript, Perl) as well as Business Intelligence tools (SSIS, SSRS, R, SPSS, and Tableau).
• Experience in software development using Java, Perl, J2EE web stack, HTML, JavaScript, etc.
• An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management across the globe and significant experience working with customers, product managers and technical teams from multiple locations.
• Expertise in data analysis and process improvements to enhance operations, increase accuracy, reduce process time, and empower people.

TECHNICAL SKILLS

Databases: Oracle 10g, MS SQL Server 2005/2008/2012, Sybase ASE 11.5/12.5/15.x, Oracle

Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Loader, Tableau, ToolsGroup SO99+, IBM SPSS, ForecastX, MS Excel, MS Project, Maven, Apache Lucene, Apache Tika, Selenium, Spring, Struts, iBatis, Maven, Apache Tomcat, FireBug, MatLab, Xvfb, CVS, SVN, GIT.

ERP: SAP, IFS.

Operating Systems: Windows 95/98/NT/2000/XP/VISTA/7, MS DOS, UNIX.

Languages: PL/SQL, Transact SQL, SQL, R, C, Perl, Core Java, J2EE, VB Script, Visual Basic 6.0, Python, Unix Shell Scripts, XML, JSP, Servlet.

Web Languages: HTML, XUL, jQuery, JavaScript, CSS, PhP

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst / Data Analyst

Environment- MS SQL Server, MS Excel, Tableau, SQL Scripts

Responsibilities:

• Development and update of the Function specification and Technical specification documents in accordance with the business requirements.
• Development and maintenance of various stored procedures, triggers, functions used for loading the data into the staging and reporting tables.
• Conduct meetings with the client’s point of contact, to collect, analyze and elaborate the requirements and expand them into a tentative design document.
• Manage the development team activity onshore as well as offshore in India, including daily monitoring, status reporting provide technical guidance and mentorship.
• Provide as point of contact between development, testing teams in India, US team and Anheuser Busch.
• Conduct weekly review meetings with Project Lead, Client and the team members to track/estimate/plan the activities for each iteration.

Confidential

usiness Analyst / Data Reporting Analyst

Environment - SQL Server, SQL Loader, MS Excel, Oracle, R, ToolsGroup SO99+, TSQL scripts

Responsibilities:

• Developed business document and data-types matching in accordance with clients and our data specifications.
• Obtained, cleaned, profiled and analyzed data from the client using MS SQL Server, Oracle, MS Excel.
• Coordinated with the off shore team to perform further analysis using ToolsGroup SO99+.
• Continued Gap Analysis process and enhanced results obtained from the off shore team using R and MS Excel.
• Developed Reporting deliverables using SQL, R, MS SQL Server and MS Excel to view and understand results easily.
• Documentation of procedures for creation, analysis and maintenance of various processes.

Confidential

Senior Data Analyst

Environment - MS SQL, R, Logility, MS Excel, TSQL

Responsibilities:

• Development business document and data-types matching in accordance with client’s data specifications.
• Performed data forecasting analysis on the sales data using various alternative forecasting techniques such as Holt Winters, Cluster Analysis, Simple smoothing, etc using R, MS Excel, IBM SPSS, Logility, Oracle and MS SQL tools.
• Benchmarked forecastibility across other clients in the same industry so as to grade demand forecasting optimization.
• Created reporting deliverables using R and MS Excel, for presenting to client’s senior management.

Confidential

Lead Developer / Analyst

Environment - HTML, Javascript, PhP, MS Excel, CSS, Open Source tools, SQLite, MSU’s Non Credit Registration System

Responsibilities:

• First point of contact between various MSU departments, external users and Asian Studies for IT related activities.
• Built and maintained Asian Studies Center website using HTML, JavaScript, PhP, CSS.
• Analyzed website data metrics so as to improve usage and popularity using Google Analytics, MS Excel and MSU internal Analytics tools.
• Analyzed data across promotional events conducted by Asian Studies so as to increase participation across the community.
• Collected, categorized and automated search and retrieval functionality of Asian Studies Center books and video library using SQLite and MS Excel.
• Studied and understood MSU’s website regulations and strived to conform to high standards.

Confidential

Senior Data Analyst / Supply Chain Analyst

Environment - IFS ERP, MS SSRS, MS SSIS, MS SQL Server, Data Warehouse, MS Excel.

Responsibilities:

• Developed an automated Master Planning and Scheduling tool collaborating with IT and six supply chain teams using real-time IFS ERP data, MS SQL, PL/SQL, MS SQL Reporting Services (MS SSRS), SQL Loader.
• Designed and built Key Performance Indicators (KPI) dashboard using data warehouse and MS SQL Reporting Services to measure and track operational performance metrics for production and fulfillment teams.
• Simplified data migration to Microsoft Dynamics ERP by cleaning and simplifying data by executing SKU rationalization based on global customer preferences and sales, using MS Excel and MS SQL.
• Analyzed sales data across 13 plants in USA and created a dashboard using MS SSRS and MS SQL for senior management to track marketing team performance.
• Built MS Excel Macro based tools to analyze and track performance of the inventory in the warehouse.

Confidential

Senior Analyst / Senior Software Developer

Environment - MVC - J2EE stack, JavaScript, jQuery, HTML, CSS, Struts, Spring, JSP, iBatis, MS SQL, Apache Lucene, Shindig Framework, Maven, MS Excel, Mail Parsing, python, Unix, Apache Tika, SOAP wrapper and parser, Grid Processing, SFTP

Responsibilities:

• Gate keeper for the application coordinating with senior management, investment management teams (users), software developers, designers, and testers.
• Managed the complete SDLC project life cycle of the applications to help investment managers in their daily operations.
• Developed critical parts of all three layers of the MVC based web application using Java, HTML, Struts, Spring, JSP, iBatis, MS SQL, JavaScript and jQuery.
• Performed data indexing operation using Apache Lucene to reduce data access times.
• Obtained XML specifications from external data vendors and created java based SOAP wrappers so as to extract information.
• Setup a SFTP based data retrieval, and archival system to obtain data from external vendors.
• Parsed received data using Apache Tika and indexed them using Apache Lucene. This processing was done using Grid based distributed computing so as to eliminate time lag between data collection and data availability for users.
• Analyzed financial data providers’ performance using MS Excel, MS SQL so as to choose high quality providers.
• Built business requirements, functional specification, technical specification, design and operational documentations, wiki pages and presentations regularly during the course of the project.
• Implemented the Agile Project methodology implementing iterations quickly so as to implement features quickly.
• Conducted weekly project review meetings with Project Lead and the team members to track/estimate/plan activities for each iteration.

Confidential

Environment - jQuery, Google Shindig framework, OpenSocial API, Java, Maven, Struts, Spring, iBatis, SQL, XML, Unix

Responsibilities:

• Conduct meetings with the users to collect requirements and to analyze and elaborate the requirements and expand them into a tentative design document.
• Conduct regular review of the Function and Technical Specifications to reflect the latest changes and enhancements.
• Manage the development team activity onshore as well as offshore in India, including daily monitoring, status reporting provide technical guidance and mentorship.
• Provide as point of contact between development/testing team in India and U.S. team.
• Involved in resolving day-to-day issues and worked with the users and testing team towards resolution of issues.
• Help design and plan new feature addition and functionality to the existing applications and reports.
• Conduct weekly review meetings with Lead and the team members to track/estimate/plan the activities for each iteration.

Confidential

Environment - Mail Parsing, Pattern Matching, Pubsub protocol, Comet, Java, Maildir, HTML, JavaScript, iBatis, JSP

Responsibilities:

• Built a web interface and mail parser to obtain discussion details and store in the back end - a proprietary request management system using Java Maildir, Pubsub, and J2EE web stack.
• Implement permission based access to discussions so as to limit display of discussions to levels of seniority, teams, etc.
• Created automated reports to summarize discussions to Senior Management and Vice Presidents.
• Analyzed and built data extraction modules in Perl to obtain information from a lot of news websites such as Reuters.
• Designed data extraction modules in Perl for analyzing and extracting data from alerts and subscriptions.
• Developed engine to obtain, store, retrieve and use user specified keywords from Sybase database to extract news based on the keywords.
• Built reporting modules in Perl to create a report with latest news articles and send it out to the users as a newsletter in user defined format and at user defined time.
• Researched and analyzed plenty of existing data extraction / web scraping modules in Perl, Java, Python, etc. to obtain updated content from Ajax enabled websites
• Built a complete web content retrieval framework by invoking a Firefox browser instance from Perl using Selenium, capturing the complete website and obtaining the complete web source page.
• Solved the problem of lack of display terminal for running a browser instance in remote server by using an in-memory display through Xvfb (X Terminal Virtual Frame Buffer)
• Created data parsing modules in Perl to obtain needed information from the website html obtained from the above framework.