SUMMARY: Overall 18 years of experience in Technology Strategy, Data Architecture and Application Architecture which includes IT system architecture, data management, system analysis and process design implementation using relational, data warehousing, and object-oriented methodologies.

EXPERIENCE

Data Architecture

• Directed core architecture group to facilitate and guide design and model, relational OLTP OLAP data marts, enterprise data warehouse EDW , data quality management, data integrity management, data consolidation, meta-data management, migration, transformation.
• Established Data Governance policies for airline domain business intelligence data. This includes data quality integration which had entity change notification/logging/audit, documentation of data dictionary, domain metadata and hierarchy, security for key data fields, and corresponding impact analysis/risk management.
• Architected Airline domain BI platform, technical design and overseeing development of Informatica based solutions.
• Defined and implemented data warehousing architecture for airlines enterprise. Designed ETL, data cleansing and enrichment strategy for each data mart.
• Modeled and developed enterprise data warehouse consisted of staging databases, Business grouped based datamarts and P L, risk consolidated Enterprise Datawarehouse.
• Designed OLAP data warehousing databases using Fact and Dimensional modeling techniques of Star and Snow Flake models.
• Developed extraction, transformation, and loading ETL using SSIS packages, PL/SQL procedures, Pentaho ETL to populate P L and risk data all the capital markets business.
• Mentored DBAs/developers to enhance performance through ETL techniques with materialized views, range and composite table partitioning. Assisted developers in SQL queries and data processing techniques.
• Designed and maintained cubes for what-if travel search patterns with generation of monthly and incremental cubes.
• Designed a draft design proposal for implementation of value-at-risk VAR calculation through Hadoop and Hive in noSQL architecture. Mapped RiskML data to value-pair sets to facilitate map-reduce pattern of Hadoop. A initial pilot technology tester implementation was done of Amazon Elastic MapReduce with a small subset of risk data. Hive tables were created on Hadoop HDFS for initial BI Analysis through hive created map-reduce jobs.
• Developed Database change control process for applying database changes of applications in Test and Production databases.
• Mentored developers to develop and publish Impromptu reports, power play cubes, power play reports and Cognos visualizer.
• Installed and configured Cognos servers in test and production servers.
• Installed and configured Netscape directory server LDAP for user login authentication and security. Created users and user classes for access control of Cognos applications.
• Installed and configured Apache web server for intranet access of Cognos reports and cubes. Installed object store database as a respository of Cognos package data.

Database Management:

• Logical design of database entities and relationships with ER diagram representation. OLAP fact and dimensional design using star and snow flake models. Physical design of schema of databases and schema objects.
• Backup and recovery of the database using RMAN hot backups cold OS backups.
• Configuring replication of Oracle, SQL Server databases from/to homogeneous and heterogeneous sources
• Data migration and loading using SSIS, DTS, BCP and SQL Loader.
• Maintaining ETL process and CUBE generation for reporting.
• Managed production databases regarding space management, memory management, performance tuning, and redo log, archive log management
• Monitored database availability and application sessions connectivity
• Audit database logs, error logs and trace logs for abnormal activity
• Replication to Reporting databases and performance tuning
• Oracle patch management and backup management
• Managed Oracle high availability through dataguard physical logical standby databases.
• Managed development of Code for the user objects such as tables, triggers, packages, views, indexes, stored procedures, and constraints using PL/SQL TSQL.
• Developed backup and restore procedures for SQL Server.
• Developed space management and memory tuning parameters for SQL Databases.
• Configured homogeneous and heterogeneous replication.
• Developed SSIS DTS packages for data transfer and BCP for loading huge datasets.

Object Oriented Design and Implementation

• Design application frameworks for J2EE, J2SE projects.
• Design and implement data loading RMI servers using XML data formats
• Design and construct XML DTDs for data interchange.
• Development of Code for the Java Swing GUI Forms.
• Implement extraction and loading applications based on Swing and JDBC.
• Deploying Systems of Client/Server and Distributed Applications.

IT Management

• Managed Wall Street trading applications with annual revenue of 300-400M.
• Responsible for overall IT strategy by providing future state vision and road map for technology processes and applications' enhancement.
• Directed and assigned resources, estimated costs of hardware and software for project proposals budget recommendations.
• Managed IT teams sized 25-40 in US and outsourcing team size of 50 technical and managerial resources. Actively involved intalent acquisition, recruitment and retention of IT personnel.
• Directed and managed IT outsourcing engagement with Indian operations for staff augmentation, production support, QA activities and application feature enhancement defect resolution.
• Developed and maintained relationships to business and IT administration.
• Gained efficiencies in project implementation through six-sigma initiatives by iterative process change and elimination of defects.
• Developed models for system architecture and project design development.
• Formulation of project proposals and compilation of stake holder requirements. Managed Joint application Design JAD sessions for project requirement and phase planning.
• Managed successful conversion and up gradation of financial trading applications within the project deadlines and under budget.
• Analyzed legacy systems' processes to design new system procedures with RDBMS and OOD methodologies..
• Implemented, Coordinated and refined change management/control processes.

SKILLS SET

• Technology: RDBMS, .NET, J2EE, OOA D, OOP, OLTP, OLAP, Data Warehousing Design ETL, XML, UML, ASP .NET, Servlets, JSP, SWING, RMI, TCP/IP.
• Languages: SQL, PL/SQL, TSQL, Java, C, C , XML, HTML, Unix shell scripting.
• Databases: Oracle, SQL Server, MySQL, Access.
• Software: Oracle 8i/9i/10g, SQL Server 2000/2005, SQL Server Reporting Server, SUN JDK 1.5, TOMCAT , Apache Web Server, IIS, TSQL, DTS, BCP, PL/SQL, PRO C, SQL Loader, Visual Basic, BMC Patrol unix/NT/oracle/sqlserver, Legato backup.
• Tools: MS Project, Project Server, Visio, Sun JDK, CVS, PVCS, IBM Visual Age JAVA, Eclipse, SQL Navigator, TOAD, Oracle Enterprise Manager, SQL Analyzer, Oracle GRID Control, Power Pivot, Erwin data modeler, DB XRay, Cognos Power play , Visualizer, Pentaho ETL, Jasper Reports.
• Platforms: Windows XP/7, Solaris 8/9/10, MacOS, UNIX.
• Knowledge of: Cassandra, Hadoop, Hive, .NET , EJB, SOAP, SOA, REST, Web Services.