SUMMARY:

• Over 20 years of extensive experience in the complete software development life cycle (SDLC) involved in requirement analysis, architecture and design, development, testing and deployment of internet and business applications in industries such as financial (Risk and Margin), banking, pharmaceutical and manufacturing.
• Have managed database teams of size 5, comprising of application DBA’s and developers
• Managing 2 risk applications with 40 terabytes of database size in equity prime brokerage and global wealth management business.
• Strong expertise in designing Data Architecture, Data Analysis, Oracle PL/SQL programming
• Expert level of technology in product development, implementation and data management.
• Experienced in partnering with business and technology stakeholders and cross - functional teams to manage the exceptions and timely delivery of the projects.
• Domain knowledge in reference data, data warehouse, data mining, ETL processes, data modelling and regulatory reporting.
• Experience in database design, data modeling models like ER model, dimensional star schema and snowflakes schema methodologies using Erwin modeler.
• Hands on experience in design, development and implementation of large-scale database systems using Oracle.
• Extensive experience with ORACLE database version(s) 8i/9i/10g/11g and extensive PL/SQL development, development of stored procedures, functions, triggers, views, materlized views and UNIX shell scripting.
• Expert knowledge of Oracle partitioning and performance related design.
• Exposure to Agile Methodology.
• Demonstrated competence in interfacing with clients for ascertaining requirements and delivering appropriate product solutions.
• Resolve support/operational issues in liaison with project managers & business group.
• Experience in leading geographically dispersed teams.

TECHNICAL SKILLS:

• RDBMS Oracle 11g (RAC)
• Data Modeling Erwin
• Power Designer and Oracle Designer
• OLAP Tools Tableau 9
• Business Objects 6x
• ETL Tools Informatica
• Ascential Datastage
• C
• Java
• Visual Basic
• Unix Shell Scripting
• HTML
• ASP 3.0
• PL/SQL
• Pro*C
• Click View
• SQL Loader
• Oracle Export/Import
• Pl/SQL Developer
• DBArtisan
• Big Data Ecosystems Hadoop
• Impala
• Hive
• Sqoop

PROFESSIONAL EXPERIENCE:

Confidential, Whippany, NJ

Data Architect/ Technical Team Lead

Responsibilities:

• Lead/Manage database development team in risk system
• Managing 3 lines of business applications with 60 terabytes of space
• Architected and designed risk system for Global Wealth Management clients
• In-depth Oracle experience writing PL/SQL packages, stored procedures, SQL Loader scripts, familiar with optimization techniques, and developed high-volume, time-critical systems with Oracle RAC 11g.
• Extensively used Table Partitioning/Sub-Partitions, Local Indexes
• Performance tuning of the entire risk system.
• Data architect using Erwin design tools for Oracle database.
• Designed and architected the dashboard reports using Tableau.
• Doing POC using impala/tableau to measure reporting performance

Confidential, Warren, NJ

Data Architect/Technical Design Analyst

Responsibilities:

• PlanView Enterprise Portfolio Management creates enterprise-wide visibility allowing decision makers to analyze and manage business risk, prioritize strategies and use scenario planning to prepare for change and uncertainty.
• Plan View Project Portfolio Management provides the tools to effectively estimate and plan project work.
• This robust software package allows users at all levels to identify and mitigate project risks, collaborate on work and manage project lifecycles from request to closure.
• Plan View Service Portfolio Management collects and manages the total cost of labor, software, hardware, infrastructure and outsourcing involved in business systems delivery.

Confidential, Bedminster, NJ

Senior Developer

Responsibilities:

• This Project captured pharmaceutical sales representative's data (maintained on Laptops and hand held devices) to an operational database.
• The data is transferred to a data mart via a data warehouse before it is sent to Confidential ’s Sales force.
• There is a regular exchange of data between the Laptop and the Dendrite centralized database and finally replicated these data to Confidential ’s database.

Confidential

System Analyst

Responsibilities:

• This system was developed to automate the warehouse system of all sites of Confidential, a wholly subsidy of Confidential located in United Kingdom.
• Upon receiving customer consignments, each site deals with their own job processing like - sorting, packaging, wrapping, pick & pack, mailing, shipping and forwarding to regular mail service providers and also doing fleet management operations

Confidential

Developer

Responsibilities:

• This project was executed for Confidential
• This package is an integrated family of manufacturing, distribution and financial applications consisting of 12 modules - Inventory Management, Order Entry, Purchasing, Shop Floor Control, Bill of Material, Material Requirement Planning, Master Scheduling, Capacity Requirement Planning at Rough Cut and Detailed levels, Accounts Receivable, Account Payable and General Ledger.
• Along with these modules a number of other modules, namely Plant Maintenance, Tool Management and Quality Assurance were developed.
• Also developed number of transition systems to gather requisite data to meet AVALON specifications.
• A process Bill of Material to structure demand dependency has also been developed for the first time.