SUMMARY:

• Senior IT professional with 15+ years of strong consulting, product development and product management experience, 8 years in key technical roles in BI & Data Analytics groups for Confidential . Expert in Data Analytics, BI, DW, Oracle, Reporting, Database Administration, Architecture, Performance Tuning, SQL. Strong interest in emerging technologies in Big Data, Cloud, Predictive & Prescriptive Analytics.
• Successful and varied consulting experience with clients in different domains
• Worked with executive management in improving operational efficiencies of the software applications group by increased automation of repetitive work, migration to the Agile methodology and Cloud
• Experienced in technical architecture, functional & technical gap analyses; recommended architectural & technical changes resulting in 200+% improvement in performance of key modules.
• Recommended, designed and implemented a new Billing and Claiming system resulting in a phenomenal improvement in data quality and clearing out of all audit issues
• Key player in winning several new projects and bids for the consulting business. Experienced in pre - sales activities such as proposal development, sales presentations, giving demos to C-level executives, developing pilots etc.
• Experienced in managing offshore teams and providing strong technical leadership. Successfully led a global (offshore, local) group of engineers developing Oracle Business Intelligence applications; responsible for product designs, resource planning,, product delivery, product management.
• M.S. in Engineering, University of Massachusetts, Amherst
• B. Tech. in Engineering, Indian Institute of Technology (I.I.T) - B.H.U, Varanasi, India

TECHNICAL SKILLS:

Programming: SQL, PL/SQL, Hive, JAVA, Python, UNIX Shell Scripting

Database: Oracle 12c/11g/10g/9i/8i/7, SQL Server, MySQL, NoSQL, Greenplum

OS: Windows, UNIX, Linux

ERP: Oracle Applications R11, R12

Miscellaneous: BI Publisher, OBIEE, Sisense, Hadoop, TOAD, Informatica, ETL, Oracle Warehouse Builder, Cloudera, Tableau, DataStage, Cognos, Agile

PROFESSIONAL EXPERIENCE:

Independent Consultant

Confidential

Responsibilities:

• Provide consulting services to City of New York DHS working as a Consultant Oracle Data Architect, Database Administrator, BI & DW, PL/SQL Developer. Key technical role spanning all BI and Analytics projects for the company. Managed all aspects of data including analytics, reporting, data modelling, star schemas, system architecture, capacity planning, performance tuning
• Developed a Predictive Analytical methodology and program to determine the clients who are likely to become chronically homeless in the next fiscal year
• Started work on ongoing project which uses Data Analytics using 5 year history from the data warehouse to predict which clients are likely to become violent offenders in the future
• Recommended several performance improvement enhancements and led the technical team in implementing them to the legacy Oracle system, resulting in significant performance improvements - with improvement by as much as 200%
• Regularly work with the business program executives to successfully design and implement the technical aspects of new policies and programs
• Automated batch jobs and ETL jobs using Batch Scheduler
• Key player in designing and developing a new methodology which would save the agency millions of dollars using a graded payment system based on duration of shelter stays
• Work closely with the Finance teams to design and implement a brand new system for performing the agency’s Billing and Claiming activities - the new system reduces redundancy, eliminates errors and eases the tasks that Finance personnel need to perform
• Successfully led consulting business development efforts by forecasting and identifying new client needs, resulting in 3 new projects from the client.
• Served as the secondary Oracle DBA assisting the primary DBA team - responsible for performance tuning, space management, user provisioning, disaster recovery
• Provided consulting services on various technologies including Business Intelligence, Data Warehousing, ETL, Oracle PL/SQL, Informatica, Cognos, DataStage, Sisense, Cloudera, Hadoop

Confidential

BI & DW Project Leader

Responsibilities:

• Provided technical leadership to a global group of Data Analytics engineers involved in Oracle’s next generation of Business Intelligence applications for Interaction Center and Service Contracts (Fusion) - led both the US based local team as well as the off-shore based India team
• Consolidated and led BI and reporting solutions across various CRM and Supply Chain modules including Call Center Management, Email Center Management, Service Contracts etc.
• Managed projects across multiple technologies including OBIEE, Daily Business Intelligence, Oracle Warehouse Builder, Oracle Discoverer, Oracle Apps R11, R12
• Subject matter expert for Performance Tuning, Data Warehouse Design
• Actively researched and implemented new ideas to improve, streamline and automate development processes, improving delivery efficiency by emphasizing on automation and reuse concepts
• Utilized Oracle Portal, HTML, JavaScript, Oracle OA Framework to develop and customize data rich web pages, portlets, web reports
• Responsible for meeting with Product Managers to gather business requirements and translating them into technical specifications

Confidential

Senior Consultant

Responsibilities:

• Actively involved in pre-sales activities to win new business opportunities for Oracle Consulting by identifying gaps where Oracle can provide expertise with resources or tools
• Offered technical consulting services at various customer sites all around the USA - some notable clients include Alside Inc., Polk Company, Comdisco Corp, Follett Software, Telxon Inc.
• Involved primarily in designing, developing and rolling out complex data warehouse systems for clients using state of the art Oracle tools and techniques
• In-house performance tuning expert - the “go-to guy” for the whole division for SQL tuning matters
• Key player in a large scale data warehouse implementation project for Procter & Gamble Inc -involved in entire end-to-end process, using Oracle PL/SQL, Oracle Reports, SQL
• Involved in account growth activities by identifying new opportunities at client site for Keane