SUMMARY

• A dedicated, customer - focused and articulate technology profession with more 12 years of hand-on experience in Data Architecture and Project Management, focusing mainly on Finance Industry
• Expertise in Data Architecture, Data Warehousing, Business Intelligence, Enterprise Information Management, Data Upgrade and Migration, Data Integration, Metadata management, Data Quality and Data Governance
• Proven business acumen and ability to meet fiscal and deadline commitments. Other competencies include Project Planning, Interdepartmental Coordination, Re-engineering, Change Management, Risk Management and Scope Management
• In-depth knowledge of applying technology to meet changing business needs, delivering flexible and robust information architecture, formulating technology roadmap, defining technology upgrades/migration and application consolidation plus centralization strategy
• Extremely competent in managing full system development life cycle, from requirements gathering to final implementation as well as user training
• Sound knowledge of various database disciplines, including, data retention period, performance tuning. data quality, data integration
• Demonstrates leadership experience in Project Execution plus Delivery of large scale complex IT Projects, working effectively with key stakeholders and coordinating On-shore/offshore team

TECHNICAL SKILLS

Software

Project Proposal, Estimation, Planning, Executionand Delivery

• Architecture
• Scope Management, Risk Management, Quality Management
• Consolidation and Centralization of the application landscape, Technology Improvements
• Application Re-engineering and decommissioning strategy
• Interdepartmental and onshore-offshore team co-ordination
• Management
• Business Architecture, Data Architecture, Application Architecture
• Logical Physical Design for ER/Dimensional Modeling
• Capacity Planning, Space Management, Enterprise Data Management
• Security Design, Performance Design, Audit and Log Design
• Tools
• Data Pump Utility, SQL Loader, RMAN, DBA Studio
• Erwin 8.3, TOAD, PL/SQL Developer 8
• MS Project 2007, MS Visio 2003, CA Clarity 12.1
• Informatica, Business Object, Cognos, Crystal Report
• Technologies
• Data Warehouse, ETL, OLAP
• Database Backup Recovery, Data Replication
• RDBMS
• Oracle 7.3 and higher, MS SQL Server 7.0, 2000
• Languages
• SQL, PL/SQL, TSQL, Unix Script
• Operating Systems
• Linux, Solaris, HP-UX, Win NT 4.0, Win2000, Win9x, Win XP

RESPONSIBILITIES:

• Responsible for data architecture, Enterprise Information Management, Data Upgrade and Migration, Data Integration, Metadata management, Data Quality and Data Governance
• Implementation of Conceptual, Logical Physical Design of ER Modeling and Dimension Modeling Review quality of deliverables to identify improvement areas and mentor guide technical resources
• Collaborate with client project managers and technical directors to compose a high level of solution plan and effort estimation
• Ensure Information Systems Architectural artifacts are aligned with the enterprise direction
• Work with a respective Group Owner to define strategy like Integration Strategy, Security Approach, Configuration Management, Production Support
• Lead the research of emerging technologies and directions and identifies opportunities for the use of specific products for the benefit of a client.
• Setting up coding and design standards for the project and closely drive the team to implement highly complex requirement as well as meet performance criteria
• Manage aspects of the project life cycle, from the initial kickoff through the environments setup and requirements analysis to implementation for projects and end user training within solution area
• Partner with clients to understand requirements and domain knowledge, develop a project plan and delivered flexible and robust information application system architecture
• Provide the highest level of quality assurance for services within solution area by overseeing the development and testing of application that provide sufficient coverage to ensure a quality solution
• Interface and coordinate tasks with on-shore and off-shore technical team

PROFESSIONAL EXPERIENCE

Client: confidential

Mar-2012 to till date

Group:

CitiDIrect

Role:

Senior Data Architect / Technical Manager

Environment: Oracle 10g, Oracle 9i, Erwin 8.3, MS Windows 2000, Informatica 8.6, Business Object XI 3.1, Actuate, Java, .Net, PL-SQL, SQL LOADER, SQL Plus, MS Project 2007, MS Visio 2003, IBM Optim

CitiDirect is the innovative award winning application providing financial services to clients in over 95 countries. It is a fully integrated platform allowing clients with a single log-on access for numerous applications to address both their local and global banking needs with services in Payments, Reporting, Receivables, Trade, Netting, Liquidity Management and Investments. It supports 100 currencies in 95 countries and 22 different languages. In order to facilitate different capabilities, CitiDirect is built upon a large distributed environment with multiple channel end points like Web, Mobile, and Tablet to receive requests from clients. It has multiple transport streams to format downstream to inter-operate with the multiple product processors and clearing houses. Corporate customers access CitiDirect over the internet using either CitiDirect Classic or CitiDirect Portal . In addition to the internet access provided by the portals, there is a third portal tailoring to the mobile platform. For outbound services to clearing houses and product platforms, CitiDirect provides MQ Series services and NDM for file transport serviced via CitiDirect's SOA Bus running on the TIBCO Shared Technology Environment.

Strategic accomplishments:

• Retained all required business functionality while separating CitiDirect Data Mart from their data warehouse
• Advised for Data Archive and Data Purge strategy using IBM Optim for effective data management and reducing total cost of ownership TCO
• Developed comprehensive guideline on Procedure and Standards for clearer understanding and easy maintenance Suggested effective Partition and Compression strategy to improve performance and reduce the regular database maintenance like index re-build.
• Initiated documentation of data model and data dictionary which helped in communication between team members and is used as a plan for developing applications, specifically how data are stored and accessed

Client: confidential

Nov-2011 to Feb-2012

Group:

Finance Data Repository

Role:

Data Architect / Technical Manager

Environment: Oracle 10g, Oracle 9i, Erwin 8.3, .Net, Solaris, MS Windows 2000, Java, PL-SQL, SQL LOADER, SQL Plus, MS Visio 2003

• Finance Data Repository provides a comprehensive and consolidated data repository of Accounting, Associated Reference and Third party data that is flexible, scalable, and consistent with the accounting books of record . To be the single source of data in support of Accounting Information Delivery and all other downstream application and client needs: FDR as the TRUSTED Source of MCH accounting data. The system architecture design of FDR leverages the existing near real time'
• Interchange infrastructure and the client server application. The architecture design options determined as each subject area was designed De-normalized table containing data from multiple tables consolidated into one. Views and Data Access Layer DAL have been created on top of the de-normalized tables for user access, which contains all the data from the various underlying Oracle tables joined using SQL unions, functions etc.
• Strategic accomplishments:
• Managed critical project directing 30-members team including resources on-boarding and training
• Documented all required business functionality for Finance Data Repository which enhance team productivity and helped to identifying process gaps
• Received good reviews on training and accompanying documentation.
• Team Members possessed an expert level of understanding of all of the business processes of the FDR functionality.

Client: confidential

Apr-2011 to Aug-2011

Group:

BPRO

Role:

IT Architect / Technical Manager

Environment: Oracle 10g, ClearForest Text Analytics Suite 6.1, .Net, Java, Linux, Solaris, PL-SQL, IBM Web Sphere Studio, SQL LOADER, SQL Plus, SQL Developer

BPRO is a BDAP application used for processing Profile information contained in a variety of company releases Def 14As, 10K, Annual Reports, etc. as well as news stories. The source documents are passed though ClearForest application for Text Analytics to extracts profiles data in XML format. Profiles data team reviews the XML data returned by the ClearForest and updates it in profile database using BPRO application. The project had automated the manual pattern matching process.

Strategic accomplishments:

• Designed and managed semantic data analysis requirement
• Successfully completed architecture deliverable on-time and in accordance with requirements Directed team for developing reusable components to minimize enhancement and support effort
• Designed and Managed automated profiling task helped to reduce the headcount of data profiling team by 50

Client: confidential

Jul-2009 to Feb-2011

Group:

IT4IT

Role:

IT Architect / Technical Manager

Environment: Oracle 10g, Oracle 9i, CA Clarity 12.1, Erwin 4, .Net, Linux, Solaris, MS Windows 2000, Java, PL-SQL, IBM Web Sphere Studio, SQL LOADER, SQL Plus, MS Project 2003, MS Visio 2003

IT4IT is a group within Credit Suisse that caters to projects applications used by IT Business Management. It manages IT Resource, IT Products, IT Projects and IT Services using applications namely, SDLC Time Management Tool, IT Enterprise Manager, Vendor Invoice Processing System. Albeit, the group came up with new IT Project Portfolio Management PPM tool, named OnePPM, which is the customization of CA Clarity tool to support management in the activity of choosing the optimal portfolio of IT projects and then monitor ongoing delivery of the chosen portfolio. The long term vision is to reduce complexity and develop agility to enable business success. The strategic OnePPM toolset will provide the Business with the ability to align planned IT spends to business priorities and provide IT with the tools and capabilities needed to react to changing priorities.

Strategic accomplishments:

• Implemented robust and flexible Data integration architecture to integrate existing system with the new CA Clarity tool, which could adopt future requirement changes with minimal or no impact
• Identified and translated the configuration changes on Oracle database that contributed to achieve 100 performance improvement for all applications plus enhanced relationship with client business
• Formulated consolidation strategy which decommissioned production databases and trimmed down regular databases operation cost by around 25
• Streamlined EOL technology upgrade project plan that saved significant amount of allocated budget plus time Successfully completed architecture deliverable on-time and in accordance with requirements

Client: confidential

May-2008 to May-2009

Group:

Legal and Compliance

Role:

IT Architect

Environment: Oracle 10g, Oracle 9i, Informatica 8.1, Business Object XI, Linux, Solaris, MS Windows 2000, Java, PL-SQL, IBM Web Sphere Studio, Perl, SQL LOADER, SQL Plus, MS Project 2003, MS Visio 2003

Legal Compliance IT LCIT, the group of United Bank of Switzerland, has Compliance Monitoring program and Compliance Advice Training program focusing on integrating the business systems and feeds for monitoring and reporting purpose and to present services to business respectively. The group manages Employee trade monitoring, Trade surveillance, Anti-money laundering, Regulatory reporting, Control Room. It primarily has warehouse applications with a variety of interfaces BO, Actimize, Web to ensure that the L C is able to monitor and report activities to ensure better regulatory and risk management. The data was provided to compliance department in order to file the regulatory shareholding reports within the different jurisdictions around the globe.

Strategic accomplishments:

• Designed dimension modeling to incorporate enhancement which seamlessly fit with the existing environment.
• Researched and utilized data archive and purge strategy to reduce 8 Terabytes VLDB by 50 to significantly cut the Total cost of ownership
• Recommended to implement compression strategy, database defragmentation and index rebuild for improving application performance and trimming down maintenance cost
• Designed and implemented strategy to collect database object statistic that improved the performance of ETL Jobs BO Reports, effectively reduced the regular maintenance cost
• Lead an infrastructure upgrade project to upgrade four technologies simultaneously that completed successfully without any post-production issue.

Client: confidential Apr-2006 to Mar-2008

Group: CEFS Web Administration

Role: Oracle Consultant

Environment: Oracle 8i, Sybase, Actuate Reporting Server, Linux, Solaris, MS Windows 2000, Java, PL-SQL, IBM Web Sphere Studio, Perl, SQL LOADER, SQL Plus

United Bank of Switzerland is one of the world's leading financial firms and CEFS web administration platform is the part of its wealth management. It consists of several applications that make organizing and reporting on various kind of employee stock option, named ESOP, SAR, RSA and Performance Award. It provides vital information like option available for exercise, vesting schedule and the maturity of the options, current status of transactions, tax and compliance reporting to the participates.

Strategic accomplishments:

• Employed the ER-modeling design changes in the Oracle database which helped to reduce enhance effort as well as improved the performance.
• Redesigned application modules to increase performance resulted in stronger relationship with client business Developed reusable components to minimize enhancement and support effort
• Implemented V-model for project execution, re-delegated tasks along with redesign of technical specifications which resulted into error free deployments