OBJECTIVE

• Seeking an opportunity to provide Technical guidance in defining the Data Architecture strategy for the Enterprise

SUMMARY

• More than 17 years of experience in IT field in various domains like Investment Banking, Manufacturing, Retail B2B, Healthcare, Telecom, Education
• Worked for Fortune 50 organizations and market leaders providing IT and Data Solutions
• Architect for large initiatives like firm wide EDW architecture, upgrade, database and platform migration, ETL, security (SOx compliance), performance etc.
• Management and implementation of database models, data flow diagrams, database schemas, db scripts, DTD schemas, structures and data standards to support a robust data management infrastructure
• Delivered Data Management vision, goals, priorities, design principles and operating policies as per the business goals of the organization
• Experienced in translating Business Requirements into Conceptual, Logical and Physical data models, used Erwin for over 6 years
• Database auditing for access and privileges and remedial action
• Designed and implemented Metadata for mapping FIX and XML tags to tables and columns between Sybase and DB2 databases.
• Implemented best practices and methodologies in Data Analysis, design and modeling, enterprise wide CMDB and SCCM implementation using Service Now.
• Experience in Extraction, Transformation and Loading (ETL) using both scripts and tools like MSBI SSIS, Informatica.
• Adept at both homogenous as well as heterogeneous Data migration
• Have lead large teams and trained newcomers
• Complete SDLC experience using Iterative development processes like RUP, Agile and Waterfall models, Object Oriented development techniques and Service Oriented Architecture (SOA).
• Handled database and query performance issues while migrating from Sybase to SQL Server.
• Have working knowledge of Hibernate, Websphere, Weblogic, JBoss, TIBCO, Tivoli etc.
• Seasoned professional, with outstanding project planning, execution, monitoring and resource balancing skills with ability to support multiple simultaneous projects in a matrix organizational structure.
• Confidential Internal Auditor for TBEM (TataBusiness Excellence Model) created by using theMalcolm Baldrige National Quality Award model, Six Sigma and CMMi/PCMM standards

TECHNICAL SKILLS

Enterprise Data Architect: Involved in both H/W and S/W aspects of Enterprise Data Design, Data Modeling, MDM, ETLs, Reports, Replication, Disaster recovery, Backup, Merger of Data flows etc

Project Management Tools and Techniques: Software Development Life Cycle Methodology (SDLC), Six Sigma, PCMM/CMMI, Waterfall, VersionOne for Agile and Scrum, MS Project, MS Visio, MS Excel, Clarity PPM, Daptiv

Languages/Technologies: Service Oriented Architecture (SOA), C/C++, JDE, Java, JavaScript, J2EE, XML, Perl, Shell, VC++, PL/SQL, HTML, Message Queues like MS MQ and TIBCO, JBOSS

Design Tools/Methodology: OOP/OOAD, IBM Rational Unified Modeling Language (UML), Use Cases, Rational Unified Process (RUP), ITUP, Rational Clear Case, Microsoft Visio, Embarcadero ER/Studio, Erwin 8.2/9.1

Development Tools: MSBI SSMS, SSIS, SSMA (SQL Server Migration Assistant), DBArtisan, TOAD, Sun Workshop, Visual Studio, Eclipse, SQL - Programmer

Databases: Teradata, Sybase 12.5/15, Sybase IQ, DB2UDB, Oracle, SQL Server 2005/2008/2012

Quality Assurance and Change Management: CMDB, SCCM, Jira, Netcool, Service Now, HPSC, Subversion, Teamcity, VSS, CVS, RCS

Operating Systems: Windows XP/NT, DOS, Sun Solaris, Linux, HP-UX, SGI Unix, SCO Unix

PROFESSIONAL EXPERIENCE

Confidential

Enterprise Data Architect

Responsibilities:

• Assessment of current Data Architecture, defining Goal State and Gap Analysis with 10 year horizon for data and reporting requirements including Big Data analytics
• Technical and Functional feasibility assessment for future requirements
• Building Reporting Architecture with MicroStrategy as primary BI tool
• Designing Teradata Databases for all layers and building utilities for security, data profiling, data auditing, data masking etc
• Creating Erwin Data Models health care subject areas like HIX, Regulatory Compliance like HEDIS reporting, predictive analytics.
• Providing Data Mapping for BTEQ and Informatica ETL Team for various data flows like Facets, CareAdvance, CareAnalyzer, Dell FMS etc from SQL Server 2008 to Teradata ODS (Operational Data Store) layer, DW layer(3NF) and Datamart layers (Dimensional)
• Designing and developing reconciliation utility for data certification between SQL Server and Teradata and also between flat files and tables.
• Defining MDM strategy and helping the client in choosing third party MDM tool.
• SQL Server performance tuning, optimization, backup and replication.
• Managed successfully technical team consisting of Business Analyst, ETL developers, Data Analysts, BI developers and Quality Assessment with challenging deadlines
• Care Management Report development for Business Users and Compliance using SAS and Microstrategy
• Maintaining updated Service Now based CMDB.
• Preparing short term and long term deliverable plans and Daily status reporting to Director

Environment: Teradata 14.0, BTEQ, Erwin, SQL Server 2008, Svn, Anyconnect, Informatica with MDM, Linux, Visio, Daptiv, Tidal

Confidential

Separation Data Architect

Responsibilities:

• Identifying client requirements and Separation scope, technologies and versions
• Defining, designing and deploying infrastructure and application hosting solutions
• Network design for new topology - multilayered architecture and Firewalls shrunk to 2 layered architecture, implementing new firewall and partnernet rules
• SME for technology competencies including Apache, WebLogic, IIS, Unix System Administration, Wintel System Administration, DMZ Hosting and related technologies.
• Admin, backup network setup while moving to new data center
• VM migration using lift and shift, build or VMotion, SAN migration
• Verification and modification of the Data Models under new regulations
• Testing and Performance optimization on new network and Oracle database
• Updating changes to Salesforce based CMDB.

Environment: VMWare, Oracle LDOMs, Shell, Cygwin, Solaris, Linux, SalesForce

Confidential, Plano TX

Database Design and Migration Architect

Responsibilities:

• Identifying client requirements and Application scope, technologies and versions
• Study of competitive products in the market, their suitability for our needs
• Study of known issues and strategies to find them in the Applications
• Collating all U2L migration issues and designing the Data Model - LDM and PDM
• Making the data self-learning using iterative processing
• Keyword replacement and environment changes to the code by using database tables
• Optimization and performance tuning for Sybase, SQL Server 2008/2012 and Oracle databases.
• Utilities for analyzing the modified code and automated testing, data migration using SSIS etc
• Making the application run at a single button click and do end to end processing

Environment: MS Project, Visio, PL/SQL, PowerBuilder, Sybase ASE 12.5/15, SQL-Server 2012, Oracle, Erwin, SSMS, SQL-Programmer, MS Visual Studio, SSMA, SSIS-SSRS, RUP, UML, TOAD, Mingle

Confidential

Solution Architect and Program Manager

Responsibilities:

• Solution Design to migrate Sybase ASE 15 Database to SQL server 2012 keeping the look and feel of the Application intact.
• Using SSMA (SQL Server Migration Assistant) for migration, reconciliation and testing
• Designed and implemented Solution for Windows Authentication
• Generating the current Data Model and database design diagrams - LDM and PDM
• Creating a Data model for sharing common data (funds and accounts) across the whole firm
• Central repository for Change Documentation and Knowledge Transfer
• Utilities for analyzing data validation and automated testing.
• General Ledger (GL) accounting server migration with special security utilities
• Query and sproc performance tuning of Sybase, SQL Server 2005/2008.2012 and Oracle
• Generating MDM Data Model for future development
• Using SSIS automation for migrating large data, incremental data
• Designed decom strategy and successfully decommissioned the old servers and SAN space after the databases were migrated
• Agile Epic and Sprint planning with Senior Management

Environment: MS Project, Visio, PL/SQL, PowerBuilder, Sybase ASE 15, SQL-Server 2012, Oracle, Erwin, SSMS, SQL-Programmer, MS Visual Studio, SSMA, SSIS-SSRS, VersionOne

Confidential

Project Lead and Data Architect

Responsibilities:

• Database redesign merge or move Lehman and Confidential applications so that the applications are not affected
• Finding areas of improvement, new Exchange/broker implementation,
• Redesigned Logical and Physical databases and defined metadata to map old and new tables and columns so that minimal code changes are needed
• Designed and implemented Solution for Access Control eg Database admin rights were given to dev team members or those who were no longer in the project.
• Central repository for Change Documentation and Knowledge Transfer
• Query and sproc performance tuning of Sybase, DB2 and SQL Server.
• Batch and report rescheduling for Oracle database performance issues
• Moving users to LDAP/Active Directory Authentication
• Moving Unix based configuration to Windows SCCM, keeping the CMDB updated after all the changes
• Replacing XML based Data Exchange to JSON scripts
• Approvals for Capital expenditures like SAN and NAS storage space

Environment: MS Project, Visio, PL/SQL, Perl, Shell, Asset Control, JDK 1.6, JSP, Servlets, JDBC with Eclipse as IDE, IBM WAS as app-server, JUnit, PowerBuilder, DB2-UDB, Sybase, SQL-Server 2008, Oracle with SQL, MySQL

Confidential

Solution and Data Architect

Responsibilities:

• Providing technical expertise for Design and Development of the Sybase Database Migration Program.
• Building tools to help Migration of Database Schema and data, verification of data, testing the application etc
• Estimating cost, effort, manpower, resources for database migration
• Contacting the Application owners and convincing them to undertake migration
• Utilities to compare the Application Performance before and after Database migration.
• Automation of large archive tables Data migration from Sybase to SQL Server or Oracle using Informatica and specialized solutions
• Adhoc technical issues in Migration eg slow queries, incorrect resultset, resultset order not being the same etc
• Migrated Sybase IQ Data Warehouse to SQL Server 2012 by creating a new data model, data mapping and migration, ETL scripts, compliance reports and analytics wherein the performance was much better than Sybase IQ.
• Tested and approved of Third Party Tools used for migration, database monitoring etc eg Freebcp, freeTDS, iWatch
• Liaising with SQL Server and Oracle teams for Advanced Migration solutions as their migration utilities were in infant stage
• Using SSIS for migration of large data with minor transformations like data format changes
• Setting up Authentication using LDAP/Active Directory on the new systems and migrating the users to them
• Merging and enhancing MDM utilities from 2 different organizations into Informatica MDM.
• Provided infrastructure for Business Object reporting using the new SQL Server or Oracle db.
• Upgraded and kept updated Service Now based CMDB with latest configuration.
• Approvals for Capital expenditures like SAN and NAS storage space, no. of servers for target database server and Sybase Replication server, Oracle Golden Gate
• Server Decommissioning after all the databases and related applications were migrated and returning the SAN space to the network
• In charge of the Program’s adherence to TBEM standards (Includes Six Sigma and CMMi/PCMM standards)
• Project budget estimation as per Confidential standards and monitoring and controlling the cost

Environment: MS Project, Visio, Sun Solaris, Linux, Java/J2EE (JDK 1.6, JSP, Servlets, JDBC), Sybase, Sybase IQ, Oracle, SQL Server, C/C++, Perl, Shell, Autosys, Business Object XI, TIBCO, MQ, MSBI SSIS, SSMA, SQL Ways, SQL Advantage, Crystal Reports, PowerBuilder, Informatica with MDM, SAS, Microstrategy, BOXI, FreeTDS, Freebcp etc, SQL Developer, SQL Ways, iWatch

Confidential

Database Audit Architect and Project Lead

Responsibilities:

• Designed SoD solution suite for over 75000 databases - Sybase and DB2UDB
• Provided technical expertise for data extraction like logins and users, last access, permission etc.
• Designed and got approved criteria to classify a database into ‘Well Maintained” or not
• Got approved special considerations with senior management like common login to all databases for data extraction
• Designed LDM and create the PDM database to store this data from where reports are generated
• Suggested remedial action to the database owners
• Trained Team members on the SoD aspects, Prioritization, distribution and follow-up of tasks
• Designed and maintained the data warehouse to store and process all this data and reports.
• Provided senior management with automated weekly reports of non-compliant databases using Business Objects reporting tool.
• Sending the correct ownership data to Service Now based SCCM and CMDB teams.
• Followed TBEM standards (Includes Six Sigma and CMMi/PCMM standards)

Environment: PPM,Visio, Linux, Sybase, DB2, Perl, Shell scripts, Business Objects XI, Erwin, Autosys, MySQL, T-Sql, isql, fsql, wsql

Confidential

Data Architect

Responsibilities:

• Providing technical expertise for re-designing of the existing ETSDB.
• Designing Metadata Architecture to map columns from old Sybase and the new DB2 database.
• Study on feasibility of using IBM Metadata Workbench instead of CGI Perl
• Parallel flow setup so that both Sybase and DB2 databases received the trading messages
• Data warehouse updates, maintenance and keeping CMDB updated
• Design scripts to reconcile data between the Sybase and DB2 databases.
• Testing replication and performance optimization techniques for this high availability database eg runtime archiving
• Comparison of XML and FIX messages for speed and space.
• Mapping FIX message fields to proper table and columns
• Perl scripts and DB2 sprocs for matching between the Orders and Trades coming from Front Office and Exchange
• Data masking using Informatica APIs
• Conducted PoC for DB2 vs. Oracle 11g database for similar load.
• The whole Oracle setup was done in 2 weeks under extreme programming.
• Adhered to TBEM standards (Includes Six Sigma and CMMi/PCMM standards)

Environment: MS Project, Visio, Linux, Sybase, DB2, Perl, Shell scripts, Erwin, Oracle 11g, Autosys, Microsoft MQ, IBM Metadata Workbench

Confidential

Project Lead and Data Architect

Responsibilities:

• Getting the Business requirements from the Users
• Collecting the raw data for evaluating Greeks from various trading systems like Fidessa, Summit, Passport and excel based tools.
• Design the reconciliation Applications, planning and executing
• Designing the database to collect risk parameters from various trading systems and storing them
• Prioritization and distribution of the tasks
• Perl scripts to reconcile Risk between various Trading systems
• Performance monitoring and tuning of the queries and sprocs
• Prepared project plan to move to Informatica as ETL
• In charge of the Program’s adherence to TBEM standards (Includes Six Sigma and CMMi/PCMM standards)

Environment: MS Project, Visio, Linux, Sybase, Perl, Shell scripts, Autosys, Informatica, T-Sql, isql, fsql, wsql

Confidential

Solution Architect

Responsibilities:

• Planning the Datacenter movement for over 3000 databases
• As the ownership of many databases was not clear, a survey across the firm was taken for which Web Survey tool was developed. The feedback was taken from hundreds of Application owners.
• A crack team of 12 people was setup and tasks were prioritized, distributed and followed up. All activities were completed within 3 months.
• Designed and deployed the architecture to collect Server and database parameters like type and version. Database was designed to store all this data and reporting infrastructure deployed so that the senior management had all the figures at their fingertips.
• Keeping the progress of all 12 team members well coordinated as time was critical
• Designed framework for Performance optimization techniques during the migration,
• Designed the framework for Quality Testing and release
• Developed CMDB utilities to keep the migration data updated
• Developed Database and server deco strategy for old server decommissioning
• Developed policies to maintain the centralized CMDB after migration
• Audited the Project for TBEM standards (Includes Six Sigma and CMMi/PCMM standards)

Environment: MS Project, Visio, Linux, Sybase, Perl CGI, Shell scripts, Autosys, Sybmon, T-Sql, isql, fsql, wsql

Confidential

Tech and Domain Lead

Responsibilities:

• Design, build and deploying tools to monitor batch jobs which loaded the data into Quantum Database
• Monitoring mechanism using Perl scripts for batch jobs
• Built and deployed Sybase utilities to monitor the database health like tempdb space usage.
• Provided improvement suggestions to the dev teams
• Conducted adhoc tasks like server migration or upgrade
• Acted as Accounting Data flow SME for trades, ABS and MBS, Mutual funds etc
• Release coordination

Environment: Visio, Linux, Sybase, Perl, Shell scripts, MQ, Autosys, T-Sql, isql, fsql, wsql

Confidential

Business Analyst

Responsibilities:

• With inputs from Business users, design, build and deploy utilities load feeds coming from new exchanges, brokers or Clearing Corps into the database.
• Design and implement infrastructure using Perl scripts to monitor the batch jobs and their status
• Sybase utilities to process loaded data and monitor the database health
• Find areas of improvement, plan and implement the enhancements
• Design and deploy Reporting Architecture
• Build and Release coordination with CMDB responsibility.
• Made the project TBEM compliant

Environment: MS Project, Linux, Sybase, Perl, Shell scripts, Autosys, T-Sql, isql, fsql, wsql

Confidential

Senior Developer

Responsibilities:

• Conversion of the old UI to the dashboard UI using the Dashboard Layer
• Researching for all possible scenarios to define a hole.
• Collate Hole related Bugs reported by users all over the world, prioritize them and then provide release dates to Sales people.
• Implement the enhancements and fixes
• Run regression tests on all test cases
• Release the changes

Environment: Sun Solaris, C, FORTRAN, Workshop

Confidential

Developer and Release Coordinator

Responsibilities:

• Coordinating the Release with all the 10 team members and keeping the Senior Management and Sales people updated on the progress
• Comparing the AutoCAD and DDN Solid Models and identify areas of improvement.
• Move the systems from Cisco to Solaris Networks
• Prioritize the requirements/bugs and schedule the release
• Implement the enhancements and fixes
• Regression tests on all test cases
• Release the changes, Cut the CD and ship it to US office.

Environment: Sun Solaris, HP, SGI, C, FORTRAN, Workshop