EXECUTIVE PROFILE:

• 17+ years of results - oriented broad-based technology and leadership experience with background in Software Development, Data Management, Product Support and IT Operations.
• Experience Leader in establishing standards, delivering business solutions, and building solid working relationships with clients, staff and senior management.
• Innovative management over the entire product life cycle from architecture and design to implementation and support.
• By providing leadership and direction, has a proven ability to move organizations forward yielding significant benefits to the business while managing costs and delivering quality products and services.
• Recruit, develop, motivate and retain diverse staff structuring them n teams that deliver results.
• Strategically and cost effectively utilize technology in alignment with corporate goals.
• Organization & Staff Development
• Technology Architecture & Integration
• Product & Program Management
• Data Management & Integration
• Business Process Re-Engineering
• BI Implementation and Data Analytics
• Leadership & Communication
• Cost Control & Operational Excellence
• EDW, EDL, EDG Integrations
• Software Development and Global IT Delivery
• Process, Performance and Quality enhancement
• Strong expertise in creating Architecture and Strategic Planning using various principles Zachman, Gartner etc.
• Expertise in building Sales and Finance business processes for Banking, Telecom and Retail industries
• Strong Knowledge on Linear, predictive modeling techniques
• Technology expert in building EDW, EDL and EDG environments
• Expertise on R- language and Revolutionary Enterprise Analytics with BigData RevoScaleR
• Strong expertise on BIGDATA data modeling techniques
• Strong experience in Customer Master, Product Master, Sales Data Analysis, Marketing data analysis, Risk data analysis
• Expertise is designing data migration strategies, data governance and data profiling
• Skilled in managing, monitoring, estimating Project Cost and Time for large projects
• Highly proficient in creating Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Technical Detailed Design Documents
• Expertise in Data Warehouse Architecture, including Ralph Kimball and Bill Inmon approaches
• Adept at Designing Conceptual, Logical, Extended Logical and Physical data models in Oracle/Teradata database environments
• Strong expertise on Oracle Golden gate product in data replication
• Strong expertise in BIG data/Hadoop, Hive, Hbase, PIG, Sqoop, SPARK, Storm, Kafka, Flume etc..
• Hands on expertise on creating Hadoop clusters on Amazon EC2 environment
• Strong expertise in Data modeling using Star Schema, Snowflake Schema and 3NF for Data warehousing / OLTP systems
• Hands on experience with data modeling tools ER Win, IBM Data Architect and MS Visio and Designer 2000
• Strong expertise in Oracle SQL Loader, Export/Import, Data Pump and Teradata loading tools FastExport, Multiload, TPump, TPT, VIEWPOINT, TBAR, Performance tunning
• Experienced in Oracle SQL Performance Tuning with Oracle tools and Performance tuning on Teradata database
• Strong expertise in design and implementation of extraction and transformation (ETL) process
• Hands-on expertise on BI tools Oracle Business Intelligence (Siebel Analytics) and Business Objects
• Active team player and self starter with immense ability to grasp and apply new concepts
• Very strong expertise in Informatica Power Center, Mapping Designer and Workflow Manager
• Solid analytical, presentation, verbal and communication skills, and can easily establish rapport to influence management and multiple levels of the organization
• Strong expertise in Project Management methodologies with agile, scrum, waterfall etc…
• Experienced in working with global teams (off-shore / On Site model)
• Doubled the processing of transactions to 500,000 per day by architecting the host processes into a multi-threaded model.
• Built a successful global team. Designed and implemented Business-focused “Implementation Teams” responsible for end to end delivery of Software and Services. Increased output by 4 times while only doubling staff.
• Implemented a variable cost structure utilizing both SLA and staff augmentation resource models. Produced a capabilities matrix of all resources to determine global coverage and skills assessment.
• Constructed a catalog of services with descriptions and service levels for all supported products. Developed monthly scorecards with links to a continuous improvement program focused on cost reduction, quality and operational excellence.
• Innovation and Enterprise Solution Design and Implementation
• Designed an analytical module to aid in the clinical trial tracking and management.
• Implemented an effective and efficient Customer Master and built a successful customized PDA Companion application that complies with federal regulations.
• Designed and developed a Tablet PC based multi media module that help sales and marketing provide consistent message to customers.
• Designed a robust data model for clinical trial study planning and site selection that includes a database design.
• Designed and managed several Data Architecture for Data Warehouses, BI application and dashboard implementations
• Directed an aggressive program for one of the largest Financial banks using targeted service level metrics and 24x7 system availability for more than 100,000 user base.
• Provided overall Product and Program Management direction for various RFPs to win business up to 6.5 million in a fiscal year.
• Coordinated analysis and process modeling of business activities in management of CRM System integration, data management, production and support services.
• Created and implemented Standard Operating Procedures (SOP) for all SDLC activities that include from Idea conception to product design and development and to ensure seamless transition to production. SOPs and Work Instructions were created along with the templates designed for the use by Project Management, Development, Quality Assurance, and Production Control Teams.
• Initiated and secured CMMI at off shore site with in one and a half year.

TECHNICAL KNOWLEDGE:

Data Management: Databases Oracle 10G/11G with RAC, Teradata 13/14/15,MS Sql Server, Knowledge of Hadoop eco system

Data Management and BI Tools: Datastage, Informatica, Pentaho, QlikView, Business Objects, Cognos, Golden Gate

BigData: Hadoop/HDFS Architecture, Cluster Build, Hive, MYSQL, Sqoop, PIG, Pentaho, Hbase, Cloudera CDH3 &4, Cluster Performance tuning with MapReduce, R Language, RevoScaleR, SPARK, Storm, Flume, OOzie, Kafka

Program Management: Requirement Analysis, Project planning from inception to delivery and ongoing support, project portfolio tracking, controlling, cost and budget analysis, P&L management, variance analysis.

Frameworks: Web application framework, Enterprise Architecture framework.

Subject Matter Expertise & Other Skills: Customer Relationship Management (CRM), Business Intelligence (BI), Master/ Data Management Systems (MDM) for Customer and products. Program Management, Business Analysis, Requirements Definition, Vendor Evaluation and Management, Data Analysis, Data Architecture and Data Warehousing.

Software Tools:

Unix: Make, Awk, SCCS, Ksh, and Oracle SQL Loader, CA ERwin, Rational Rose, SVN

Windows: CA Erwin 4.0, Rational Rose, Datastage, Office 2010, Project 2010.

Hardware: iPad, HP iPaq, Palm, Tablet PC, IBM PCs, AT&T Star Server E, Sun 3/90, Sun 6/90, HP V Class.

Methodologies & Standards: PMI Methodology, Software Development Lifecycle (SDLC), ITIL, RUP, IDEO, Agile, Scrum and Iterative methodologies.

Special: User Centric Design by IDEO University, Oracle DBA, PDMA Compliance.

Programming Languages: Programming Languages C, C++,Perl, Oracle PL/SQL, Sql Loader, Fastload, Multiload, Tpump, TD ViewPoint, TD Performance Tools

Operating Systems: Windows XP, Windows 2000 Server, Windows CE, Palm OS, Unix System V Rel. 4, SunOS 4.1 HP UNIX, Red Hat Enterprise Linux 5, Knowledge of iOS

PROFESSIONAL EXPERIENCE:

Confidential, New Brunswick, NJ

Lead EBS Architect/Data Modeler

Responsibilities:

• Work with SMEs, Business Leaders to consolidate the business requirements
• Create Logical and Physical Data Models/Architecture for Confidential Business Capabilities (Legal, Portfolio Management, Enterprise Facility Management, Human Resources Data Models using ERWin
• Creating and Building the EDL/EDW integrations checklist and best practices
• Create Analytics models for Risk analytics, Portfolio Management Forecasting, Budget Analytics
• Design and develop text analytics to identify the key words for Risk Identification
• Working on Pentaho and ETL mappings for data extraction from different sources
• Work with teams on data exploration, data analysis, data volumes, data challenges
• Work with Data Architecture team to review the data models and getting approvals
• Work with Development team to implement the data models on GDW Teradata environment
• Knowledge and practical experiences implementing Kerberos and LADP
• Configuring Apache Hadoop echo system Hive, Pig, Sqoop, Storm, Kafka, Impala, CDH5
• Working with Developers to Stream data using STORM for near real time from twitter
• System administration of Apache cluster, storage capacity, and performance tuning
• Creating the Apache cluster on Cloud environment and design DATA LAKE requirements
• Creating interface between TERADATA/Oracle and EDL Apache Hadoop environment’s using SQOOP/Talend
• Creating architecture and design documents for above mentioned domains
• Extensively working on Teradata GDW and Data Lake
• Creating best practices on Data Lake and Oracle/Teradata environment
• Design and development of new standards for Performance monitoring and provide suggestion and manage the implementation of performance suggestion
• Working with Sales teams, Sales systems to collect Customer and Order details for descriptive geographical analytics
• Designing and Developing the Sales Model for EDL and EDW to generate the analytics
• Very strong hands on experience on Oracle DB, Teradata env., Unix based systems, job scheduling tools etc..
• Strong hands on experience in data migration and data replications
• Design the data flows from sources systems to Teradata and data lake environments
• Working with Tableau/Qlikview Analytics team develop dashboards, visualizations
• Work with QA, UAT and Production teams to production rollouts and GO/NO Decisions

Confidential, Jersey City

Sr. Data Architect / Data Modeler

Responsibilities:

• Conducted interviews/JAD with subject matter experts and document the features to be included in the system.
• Implement a proof of concept for the system to be developed and manage the development of the product using an existing framework built using J2EE, Oracle databases 10G/11i with RAC
• Performance tunning of application queries using TKPROF and Explain plan
• Analyzing AWR reports for performance and providing suggestions on memory and CPU usage
• Designing and implementation of Performance alters using AWR and DB SQLs which runs more than 2 sec SLA
• Designing Conceptual, Logical, Extended Logical and Physical data models in Oracle/Teradata database environments
• Architecture and designing the Marts for reporting and managing the Marts
• Managed the design and development of new data models for Unified Payments model which can be extendable to other service providers
• Design and development of new standards for Performance monitoring and provide suggestion and manage the implementation of performance suggestion
• Manage Production support team and provide solutions for production issues
• Manage and development of Change Management DB and prioritize the issues based on its severity, client impact etc..
• Manage ETL team for data processing, migrations
• Creating cluster for GTS to store the payment transaction data sets
• Designing the Cluster parameters, roles, users access privileges
• Building EDL Cluster to archive the Payment data
• Very strong hands on experience on Oracle DB, Teradata env., Unix based systems, job scheduling tools etc..
• Strong hands on experience in data migration and data replications using replication tools like Golden gate
• Participation in Bigdata evolution tools with HDFS, Hive and HBase, Pig and SQOOP
• Design and analysis of payment transactions conversions to Hadoop(Oracle to Hadoop file system)
• Creating batch process to push the dimensions to Hadoop clusters

Confidential, Long Islands, NY

Teradata Architect/ Data Modeler

Responsibilities:

• Lead a team that developed data repository architecture to capture and organize data between spend sources,
• Employee Incentive System to provide dashboards and scorecards.
• Provided overall project management at the client site, coordinating design and developmental activities.
• Organized meetings between different groups responsible for collection of cost center based employee and incentive details to summarize the data sources and develop an efficient source to destination Incentive data mart process.
• Interfaced with the client business, finance and legal teams and vendors to accelerate the project delivery.
• Provided the data architecture for the data repository and all the integration points with Informatica as an ETL tool, Teradata utilities.
• Designing Conceptual, Logical, Extended Logical and Physical data models in Oracle/Teradata database environments
• Established Teradata performance tuning procedures for data migration and ongoing reporting activities; synchronized function of the QA and Development Team to ensure 100% success in implementing the process
• Designed views in Teradata that mirror BI Application requirements
• Led the implementation of custom-built End-to-End ETL solutions from sources to TDW environment

Confidential

Solution Architect

Responsibilities:

• Meet with Product marketing people to collect the product details
• Setting up JAD sessions/ participating in JAD
• Performance tunning of long running sqls and working with offshore team for implementation
• Creating SRS, Analysis and Design documents, ETL mappings documents for global development teams
• Data modeling of the product details based on the Ordering and quoting systems
• Working with marketing teams to design product bundles, packages
• Designing Conceptual, Logical, Extended Logical and Physical data models in Oracle/Teradata database environments
• Design and develop interface between source systems, provisioning and billing systems
• Design and develop the automation process to keep the product details in sync with the sources
• Design Catalog Interchange Format(CIF) to support product enablement in Platform
• Design and implementation of Punch in and Punch Out mechanisms
• Working with QA teams to get the scenarios created and implemented
• Resource allocation and monitoring the development process in different GEO locations (offshore/onsite model)
• Working with business teams to get the User acceptance
• Participating in GO/NO GO calls
• Help the team in production deployment and production sanity check with business and QA community

Confidential, San Jose, CA

Data Architect

Responsibilities:

• Collect the Business Requirements from the Stake Holders and Partners
• Creating Project estimations (Cost and Time estimates) and Project Plans
• Creating Conceptual model to represent the high level entities required for this requirements
• Design of Operational Data Store to fit to the data synchronization
• Create Logical and Physical data models with Star / Snowflake models
• Create Analysis and design documents with data model, ETL Mappings, transformation rules, dimension and fact table population criteria and sequencing
• Work with DBA and Development team in creating the data mart
• Work with Infrastructure groups with data space requirements and BI portal requirements
• Working with Business Intelligence (BI) team to create metadata for OBIEE physical, logical and presentation layers
• Work with Business objects team to create universe using the data mart
• Help BI teams to debug issues, provide queries for standard reports and performance tuning
• Monitoring Project Development and provide suggestions to development team
• Design the Database and Application Security and Implementation
• Production support and enhancements required based on the business requirements
• Data Modeler and Developer working with EDW team on migration strategies and analyzing the existing EDW Teradata platform
• Gap analysis of data model from existing Oracle environment to proposed teradata model 3NF
• Analysis of BI impacts based on teradata implimentation
• Creating Logical(LDM), Extended Logical (ELDM) and Physical Data Model (PDM) with respect to Teradata based on the existing data model
• Creating Analysis and design documents with data models and approaches required to get the data population
• Creating ETL Mappings with Source systems Ordering, Customer profiles, Partner Profiles etc… to the destination data mart
• Creating Database Objects and PL/SQL scripts for preparation of data according to the Business requirements
• Extensively used SQL Loader, Export and Import utilities and Teradata FastExport, MultiLoad, Tpump in Data Migration with Informatica Power Center
• Develop Views/indexing strategies for Tables / Materialized Views in Teradata environment

Environment: Oracle 9i, Teradata 6.0, Informatica 7.x,, CVS

Confidential

Data Modeler

Responsibilities:

• Work with requirements team to collect the enhancements
• Create design and analysis documents with the changes required for existing data model and additional report requirements
• Design and Implementations of ETL Logic and Batch Job Scheduling for extraction of Dimensions and Facts with minimum downtime to the Reporting Tool
• Creating Database Objects and PL/SQL scripts for preparation of data according to the Business requirements
• Performance tuning of Queries, Database using Explain Plan and TKPROF Oracle Utilities
• Design and develop the indexing strategies for Oracle Tables / Materialized Views
• Work with BO team to implementation BO Universes changes and BO Reports

Environment: Oracle 9i, BO 6.5, Informatica 7.1

Confidential

Technical Lead

Responsibilities:

• Design and implement Logical and Physical data model with Star / Snowflake models/schemas
• Design and Implementations of ETL Logic and Batch Job Scheduling for extraction of Dimensions and Facts with minimum downtime to the Reporting Tool
• Helping Development in Performance Tuning and any changes in the process of implementation
• Creating Database Objects and PL/SQL scripts for preparation of data according to the Business requirements
• Performance tuning of Queries, Database using Explain Plan and TKPROF Oracle Utilities
• Design and develop the indexing strategies for Oracle Tables / Materialized Views
• Design the data population or preparation with minimum/no downtime of the application
• Design Application Security and Implementation with BO Supervisor
• Design and implementation BO Universes with BO Designer
• As Technical Lead, responsible for interacting with Business team to collect the requirements and template for compensation plan
• Design and develop the Oracle schema to implement the requirements
• Developed PL/SQL packages to populate the data required and to interface utilities required for UI
• Extensively used CLOB, DBMS XMLGEN, XMLTransform utilities to provide the xml, xslt formats to UI
• Preparation of data migration procedures and working on deployment of objects on SIT, UAT and Production
• Working with QA team to get the testing scenarios done and executing. Working on issues raised by QA team
• Served as Tech Lead on this project and was responsible for gathering requirements from the Business Users
• GAP Analysis of Current system with respect to the TCA Model
• Design Data flow diagrams and database structures according to the TCA model
• Extensively used the Oracle 11i TCA APIs like Create Party, Create Organization, Create Relationships, etc.
• Performance Tuning
• Design of Concurrent Programs and implementation for every day Change Management
• Extensively used Oracle Tools SQL Loader, Export and Imports
• As Senior Programmer/Analyst, collected and analyzed the user requirements
• Design database schema based on the requirements
• Create Informatica mappings from source to targets
• Design the Batch Job Schedules and implement using Autosys Scheduler

Environment: Oracle 8i, Informatica

Confidential

Sr. Programmer Analyst - MIS Reporting

Responsibilities:

• Design and implementation of Database Objects
• Design and Implementation of extraction of file extraction and Load to current database
• Design the Batch process for every day extraction of files from other Servers
• Create Objects required for the User Interface
• Performance Tuning

Environment: Oracle 8i, Pro C, PL/SQL, Perl