SUMMARY:

• Senior Analyst/Consultant with a combined experience of 14+ years in Big Data - Hadoop-AWS,Visual Analytics, Digital Media, DBA, Business Intelligence, Service-Process-Infrastructure-Client Mgmt, Systems/Business Analysis & Integration, End to end Project Mgmt, Implementation & Delivery across different domains like Banking & Finance, Media & Entertainment, GPS, Mortgage, IT, Telecom, FMCG, FMCE & Industrial Engineering.
• Expertise in Big Data- Cloudera Hadoop Architecture, Storage Strategy, Data import export, Configuration, Administration, Cluster Management & end-to-end Eco System Mgmt.
• Expertise in Visual & Finance Predictive Analytics, Market Research-Brand-Media Analytics, Trend Forecasting, Social Media Sentiment Analysis integrated with Big data-Hadoop. Worked on Tableau Server & Desktop, SAS, Essbase, Microstrategy architecture, configuration & administration.
• Exposure working on AWS (Database & Analytics Services)-Architecture, configuration and implementation.
• Installation, Configuration & Administration of Oracle 9i/ 10g/ 11i/ SQL Server 2012/2008/2005 , MySQL, DB2 8.2/9.5, Microstrategy, Tableau Server & Desktop 8.2/9.1, Cognos, Informatica on Linux, Unix, Windows.
• Infrastructure, Architecture, Assessment & Management of DB servers, Application & Web servers located in different global data centers. Ongoing Data Center & Infrastructure Strategy, Capacity & Performance tuning consultation & monitoring. Disaster Recovery Planning, Documentations & Implementations between DR & Production Sites. Ongoing maintenance, troubleshooting & escalation management of servers & data center issues.
• Expertise in various Migration, Change Management & Systems Integration projects involving huge server infrastructure, heterogeneous databases, applications & ETL tools.
• Expertise in Database Design, Database Architecture, Data Modeling, Database Creation, Creation of different Database objects, Managing Database/ Object Security, User/Group Access & Permission. Managing Linked servers, Batch jobs, DB mails, Performance Tuning, Database & Query optimization, Log monitoring, Backup-Recovery strategies.
• Experienced with ITIL, Six sigma & Agile-scrum methodologies and end-to-end implementations.
• Expertise in building Centralized Data Warehouses along with Operation/360 degree Customer metrics/Dashboards. Worked on different BI tools like Cognos, BO, MicroStrategy, SSRS.
• Experienced in Business Requirement Analysis, Building Process Flow & Systems Design, Client & Technical Documentations.

TECHNICAL SKILLS:

Tools: /Methods Big Data Storage - Mining-Analytics, Cloudera Hadoop Cluster & Ecosystem (CDH4&5)- HDFS, Hive, Pig, Mapreduce, Flume, Scoop, Oozie, YARN, AWS Storage & Platform Services (Database & Analytics), Tableau Server & Desktop 8.2/9.1, SAS, Microstrategy 9.4, Cognos 8, BO XI R2, Hyperion Essbase, ORACLE 8i/9i/10g/11i, SQL SERVER 2012/2008/2005 DBMS/SSIS/SSAS/SSRS/ Visual Studio, DB 2 9.5/8.2/8.1 , MySQL, Postgres, HP Vertica, Peoplesoft, MongoDB, Informatica 8.6/9, VB/.Net, Pega BPM & Workflow 5/6, ER Studio tools, Shell Script, JAMS Job Scheduling & Mgmt, Nexus, Remedy, MS Visio, MS Project, ITSM Strategy, Operation & Change Management/CAB, BCP & DR, Oracle PeopleSoft HR Suite, Hyperion Performance Mgmt, Oracle HRMS Suite, HP UNIX, AIX, Oracle Financials, MS Project, MS Visio, Linux(Redhat/Centos/Ubuntu), Windows 2000/2003/2008/2012 Server & Active Directory, Six Sigma tools & methods, JMP, R, Minitab, ITIL/Agile/Scrum & Prince2 methods, Apache Tomcat 7/6/5, Weblogic 11g/10,IBM WebSphere 6/7,SQL.

PROFESSIONAL EXPERIENCE:

Senior Analyst

Confidential, New York

Responsibilities:

• Global Customer, Business & Market Analytics, Business Intelligence & Visualization, Forecasting &Dashboard Reportingin Consumer Banking - BankAmeriCard Domain. An Innovation initiative, Requirement Gathering, Agile Project Mgmt & Solution Architecture, Infrastructure Capacity Planning, Cloudera Hadoop Cluster & Ecosystem Installation-Configuration-Administration, Tableau Dashboard / Scorecard Design-Implementation, Trend Forecasting, Predictive Analytics.
• Architecture, Development & Implementation of a Centralized Data Warehouse & Management/ Operation Dashboard for Bank’s Mortgage System. Business & Market Analysis, Requirement & Product Scope Defining, End to end SDLC & Agile Project Mgmt., DB Architecture & Reporting Layouts, Security Mgmt., Production implementation, Documentation, Backup & DR Management, User .
• Exploring & Developing different Bigdata - Hadoop, Data Modeling, Predictive Analytics, AWS POCs / Prototypes/ Case Studies time to time and presentation/ discussion with business leaders for its use & implementation in Banking business.
• Server Remediation Project - Migration of Business Analytics & DataWarehouse Server Environment from SQL Server 2005 to SQL Server around 200 servers, Parallel maintenance / administration of old-new environment, Quality/ Riskmonitoring, Documentation, User & Final Production Delivery.

Environment: SQL Server 2005/2008/2012 , SSIS, SSAS, SSRS, Migration tools, JAMS Scheduling, Nexus, Remedy, MS Visio, MS Project, ITSM Strategy, Operation & Change Management/CAB, BCP & DR.

Manager - Technology

Confidential

Responsibilities:

• Part of Corporate Strategy team for New Product Initiatives, Market Research, Competitor Analysis, KPI/ ROI Analysis, Marketing / Positioning Strategies, Application Architecture, Data Warehouse, Analytics, Data Management & Reporting Architecture & Strategies. Development & Implementation of Centralized Data Warehouse & Reporting Framework, Online and Digital Media Analytics.
• Installation, Configuration, Administration, Database Cloning & Designing, Patch Upgrade, DR & BCP, Replication, Backup-Recovery, RMAN, Tivoli & DATA GUARD Implementation, Performance Tuning & Optimizations for Oracle 11G, 10G RAC / Single Instance on Redhat Linux For Production, Development & Testing Environments.
• Search Engine Architecture, Development & Optimization, GPS, Business & POI Analytics.

Environment: Oracle 11G,10G RAC,10G Spatial, 9i, UMN Map Server, Oracle APPS Server, Hibernate, JSP, SERVLET, Python, Lucene search engine, MyEclipse, Jasper Reports, Business Objects, OBI, SQL Server 2005, SSRS, SSIS, SSAS, Visual Studio, Cognos 8, Oracle BI, Redhat Linux Enterprise Server, Ubuntu Linux, Windows 2003 Active Directory, ERP, CRM.

Senior Database Consultant

Confidential

Responsibilities:

• Installation, Configuration & Administration of Oracle 9i/ 10g/ 11i/ SQL Server 2012/2008/2005 on Linux, Unix, Windows.
• Business analysis, Requirement specifications & Project Scope, Capacity planning for DB & Applications, Database design, modelling, normalizations & architecture, Performance tuning, Backup-Restore, DR, Shell Script, Cron/Batch jobs, Database cloning, Data Guard.
• Data Analysis, Cube building, Data Filtration, ETL & Report generation in Oracle BI.

Environment: Oracle 10G, 10G Spatial, 9i, AIX, Redhat Linux Enterprise Server, Map Server, and JBOSS Application Server, Hibernate, JSP, SERVLET, JAVABEAN, MyEclipse, Jasper Reports, Oracle BI.

Database Consultant

Confidential

Responsibilities:

• End to end management of Analytics, ETL, Business Intelligence & Database administration for Distributed Production databases.
• Systems Analysis & Integration, Client Requirement Analysis, Onshore offshore coordination.
• Strategy & Architecture for Enterprise Dashboards, Scorecards & Real time Reporting. Market & Competitor analysis - US Broadcast, Media & Advertising Industry for Business & Technology trends to in corporate in all delivered projects.
• Installation, Configuration & Administration of Oracle & SQL Server Production, Development &
• Analysis Services Cubes, FACT & Dimensions Creation, Modification, Linking & Processing in Production DB using Oracle BI Warehouse Builder, Oracle OLAP Analytic Workspace Manager & SQL Server Analysis Services. Presentation on Datasets, Data Models, Various Analysis & Business Scorecards to USA Clients.

Environment: Oracle 10G /9i, SQL Server 2005/2000, Oracle Forms & Reports, Windows 2000 Server/ XP, MS Sharepoint, Windows Terminal Services, Oracle BI Tools (Warehouse Builder, Analysis, Discoverer), SQL Server 2005 DB,SSIS,SSRS,SSAS,Visual Studio 2005, Cognos 8, ERP & CRM, TOAD.

Database Administrator

Confidential

Responsibilities:

• Data Structure, Design & Data Migration from a 90 schema Oracle environment to DB2 environment for Calcutta Municipal Corporation’s Tax Management Application incorporating migration tools, scripting, DB cloning, Export-import & in house ETL tools.
• Installation, Configuration, Cataloging, Troubleshooting & Administration of Oracle & DB2 servers & Clients & integration between their interfaces on Production, Development & UAT environments.

Environment: DB2 8.2, Oracle 7, Linux Enterprise Server, Solaris, Windows, and Struts Framework (JSP, SERVLET,JAVABEAN), IBM Rational Application Developer (RAD), IBM WebSphere Application Server 6.0, Embarcadero Migration Tool, TOAD.

Systems Analyst

Confidential

Responsibilities:

• Business & Systems Analysis, Mapping business processes into Data Models; Architecture & Design of Database & Applications to implement Organization wide customized ERP application with separate modules like Inventory, Sales, Payroll, and Finance & CRM.
• Coordinate with different Branch offices & Head Office in Overall Systems, Database & Operations Mgmt.
• Installation, Configuration, Optimization & Tuning of Oracle 9i database (Memory, Disk Usage, Index) across all ERP modules on both UNIX & Windows. UNIX shell scripting, Backup-Recovery, DR, BCP & Audit Management.
• Monitor Inventory Management Module & Invoice generation module for effective demand Supply Chain.

Environment: Oracle 10G /9i, SQL Server 2005/2000, Oracle Forms & Reports, Windows 2000 Server/ XP, Customized Oracle ERP & CRM applications, TOAD.

Information Service Executive

Confidential

Responsibilities:

• Mapping the business processes & the End User Requirements to design and test Billing Application of Cargo Division Database in Oracle 9i - VB6.
• Monitor IP Addressing, Users Quota, Lotus Notes Mail Server & proper Routing & Replication of data.
• Installation, Configuration, Optimization & Tuning of Oracle 9i database on UNIX & Windows.
• Installation, Configuration, Upgradation, Troubleshooting & Maintenance of Windows NT/2000 server, Windows Users and Groups configurations, File Sharing & LAN administration & maintenance.

Environment: Oracle 9i, VB6, Foxpro, IBM Lotus Notes, SQL Server 2000, Oracle Forms & Reports, Windows 2000 Server/ XP.