SUMMARY:

• Over 20 years of Enterprise Data Warehousing experience using Relational and Dimensional Architectures in wide range of industries including financial, manufacturing, oil industry, healthcare and retail sales.
• Influenced key program direction through collaboration with internal stakeholders and industry experts on enterprise level IT solutions.
• Lead development of an optimization strategy for the current legacy IT environment.
• Analyzed, designed, developed, tested, installed and documented Complex Information systems for Data Warehousing, Data Migrations and Interface building projects.
• Initiated, directed and conducted Information system studies utilizing broad expertise across several engineering/information systems disciplines.
• Developed artifacts that apply enterprise analysis, design, and planning through the use of information processes and technology.
• Applied necessary technical and subject matter expertise in setting principles, policy and program goals.
• Led the evaluation of the bank’s business needs to ensure that the IT architecture plans are aligned with those needs and the planned architecture supports those needs. Based on the findings, the project was designed and developed by enhancing or optimizing the existing architecture.
• Conducted Sessions for both internal Confidential and client full time employees on various disciplines in Information Systems.
• Initiated and developed models, operational studies and tests of comparability among a wide variety of information systems and Information system component.
• Coordinated with System architects, other developers, and functional areas within companies to ensure information systems are properly integrated into the target architecture and transition plans.
• Advised experts on the project, on a variety of situations and issues that involve applying or adapting new theories, concepts, principles, standards, methods or best practices.
• Managed project financials that included reporting the health of the project.
• Strong analytical, problem - solving and communication skills with particular emphasis on clear, detailed Business Requirements and Functional Specifications, as well as reports for management.
• During the last 10 years, worked as Technical Solution Architect in the areas of strategy, consolidation and delivery of Information systems across multiples industries and has Full Life Cycle system experience in Data and Architecture.
• Team player, result-oriented, fast learner, excellent communication skills with strong research capability.
• Repeated success directing IT projects from inception to execution, strategically allocating resources and delegating tasks to achieve on-time, on-budget delivery.
• Attention to detail, Good Problem Solving, Customer Service and Communication skills.

TECHNICAL SKILLS:

Operating Systems: HP-UX, Sun Solaris, Linux and MS Windows

Databases: Oracle 11g/10g, Teradata.

Languages: SQL, Unix Confidential Scripting, Java

Oracle Tools: SQL*Plus, PL/SQL, SQL*Loader, Import/Export, Data Pump, OEM (including AWR, ADDM,etc)

Development Tools: TOAD, PL/SQL Developer

Database Modeling: Erwin

ETL Tools: Informatica Power Center, Informatica Data Quality, Informatica B2B, IBM Data Stage, Ab Initio

Business Intelligence Tools: Business Objects

Source Code Management Tools: SCCS, RTC, ClearCase, Visual SourceSafe

WORK EXPERIENCE:

Confidential, New York

Sr . Manager - Digital Data and Analytics Practice

Responsibilities:

• Served in an IT leadership role in coordinating several project activities and meetings with various team members, customers and stakeholders.
• Technical Point of Contact with oversight responsibilities of contractors including new development and production support.
• Led the gathering of business requirements. Provided oversight of design activities that ensured requirements are met and all technical designs adhere to Enterprise architecture and Enterprise data modeling standards. Provided technical guidance throughout project design, coding, testing, debugging and maintenance.
• Initiated a series of discussions with the client Executives to make sure all the functional aspects were covered. Gave a formal presentation to the upper management and executives on the new design
• Assisted in creating a strategic road map along with timelines in creating a new system with cutting edge technology to replace the old systems, clearly outlining project costs, savings and long term gains.
• Developed plans and strategies to modify the IT infrastructure architecture to support short and long-range bank goals, objectives and plans. This involved translating and interpreting functional requirements, database design and preparing technical specifications. Drafted project plans with inclusion of Software Development Life Cycle (SDLC) activities.
• Provided assistance and guidance in creating a new strategy to replace old legacy systems. Applied computer assisted software engineering (CASE) tools to the design and development process.
• Investigated, evaluated and selected tools and methods for improving productivity and software quality.
• Conducted workshops to evaluate, select, and advise others on the application of architecture modeling tool sets used to document maintain and enhance the architectural planning process.
• Lead the evaluation by Confidential of plans, programs, and business processes to develop an enterprise IT architecture plan for the bank.
• Recommended and evaluated solutions for business wide IT issues.
• Presented upper management and customers (business and technical groups) with formal IT related presentation for the project.

Technical Environment: Oracle 11g (SQL*Plus, PL/SQL, SQL Loader, Import/Export, Data Pump, OEM Grid Control), Unix Confidential scripts,Informatica Power 9.5, Rational Team Concert (RTC), ErWin, visual source safe (source control)

Confidential, NewYork

Solution Architect / Delivery Lead

Responsibilities:

• Served as a key technical resource to identify drawbacks in the existing system and propose alternate approaches that improved the IT system design to the Bank Managing Director and Stakeholders. As a result Confidential won the contract to make major changes within the existing system and correct the defects.
• Lead Architect, responsible for technical development and oversight of the new solution to merge and store Master Data, report Data Quality issues and establish a process to correct data within the bank.
• Served as an IT mentor/IT Subject Matter Expert (SME) to peers and coworkers. Assisted and trained team members while completing multiple assignments with competing deadlines.
• Developed and refined existing guidelines for implementing broad bank wide directives.
• Conducted continuing evaluations of the bank business need to ensure that IT architecture plans are aligned with those needs and that the current and planned IT infrastructure supports the architecture plan.
• Created a Data Quality Reporting Solution, for profiling, consolidating and reporting data issues.
• Defined a Data Governance process to take corrective action of the data quality issues present in the Master Data.
• Developed an IT process improvement methodology that tracked the business requirements/enhancements to the working system. Consulted with senior specialists and IT managers for a bank-wide implementation of process improvement methods and concepts to improve the quality of software products.
• Conducted research, in-depth analysis on the existing process. Formulated recommendations on enterprise-level issues.
• Served as the principle advocate within the bank for the application of process improvement concepts and practices.
• Consulted with senior specialists and IT managers throughout the bank in the implementation of process improvement practices.
• Managed resources for development and defect fixes of the new system.
• Successfully rolled out the solution and addressed key issues like performance, defects addressed by the QA team and met the business SLA’s.
• Primary technical expert/liaison responsible for interaction and resolution of conflicts with supporting departments within the organization.

Technical Environment: Oracle 11g(SQL*Plus, PL/SQL, OEM Grid Control), UNIX Confidential scripts, Informatica Power 9.5, ERWIN, ClearCase

Confidential, NewYork

ETL Architect / Integration Lead

Responsibilities:

• Played an instrumental role in companywide migration from legacy financial compliance system to custom developed system by providing end-user and support.
• Responsible for technical leadership, direction and project planning for a team of 20 contractors and employees.
• Created a high-level design of an end-to-end integration solution for DOI (Disclosure of Interest- Global Position and Aggregation System for Legal Compliance).
• Outlined and designed a strategy MDM (master data management) module to store Instrument Master Data, report Data quality issues and create a supportive Governance process to rectify errors.
• Defined the flow of data between the applications that must be integrated, mapping business process activities to the applications that support them and drafting a data object. Helped to develop a Proof of concept using Ab Initio and Oracle to aid the business envision the final product.
• Participated in discussions with business to strategize ETL load module structure.
• Part of the team which presented the DOI(Disclosure of Interest) proof of concept framework to Business for acceptance to the next actual project phase.
• Data Architecture and Technical Lead for the Analytics Enablement data warehouse solution meant to provide Retail with reliable and actionable information so that better business decisions can be made to improve marketing and service performance.
• Managed a team of developers to build the module for the data warehouse using IBM’s Data stage as the ETL Tool and the Oracle Database.
• Worked closely with business stakeholders, evaluated functional requirements, provided LOE, defined schedules and milestones, monitored progress of the project.

Technical Environment: Oracle 11g (SQL*Plus, PL/SQL, dbpump, SQL*loader, OEM), UNIX Confidential scripts, Informatica Power 9.5, Ab Initio, ClearCase

Confidential, Florida

Project Manager / Technical Architect

Responsibilities:

• Managed delivery of Informatica B2B component for generating HIPAA standard files to be sent to the states.
• Provided Informatica and ETL expertise in the current and other project to Offshore and Onshore team members.
• Led a large team onshore/offshore developers for the B2B solution. Managed the team to build an enterprise data warehouse and data mart used for Data mining and reporting.
• Technical Architect and Lead for creating an enterprise data warehouse for mining data and reporting patterns of consumer healthcare.
• Managed a 6 person team of developers to build a enterprise data warehouse and data mart used for Data mining and reporting.
• Architected and implemented an automated testing solution and Audit, Balance and Control used for Enterprise Data Warehouse testing and support.
• Identified root cause analysis for recurring process failures and slow run times to ensure resolution. This lead to re-designing and simplifying the process by using the latest oracle and informatica features to bring down the runtimes of millions of rows of data from 18 hours to 3 hours.

Technical Environment: Oracle 10g/11g, UNIX Confidential scripts, Informatica Power Center 9.5, Sybase

Confidential, Houston

ETL Technical Architect / Integration Lead

Responsibilities:

• Created a Data Quality Reporting Solution to profile, consolidate and report Master data attributes across SAP and other OLTP systems for Data Governance.
• Led a team of 4 onshore, 6 offshore developers to build and implement a Data Mart for reporting and implementation of Conversion needs using Oracle and Informatica as the ETL tool.
• Architected Cross Data Model for master data across various OLTP systems.
• Daily activities supported the full lifecycle of development including the development, deployment and production support.

Technical Environment: Oracle 10g, UNIX Confidential scripts, Informatica Power 9.5, Informatica IDQ, Informatica MDM, SAP-manufacturing module, VSS (Visual SouceSafe)

Confidential, NC

Technical Team Lead

Responsibilities:

• Designed and implemented a Data mart for the Financial Reengineering Migration Solution.
• Managed a 5 person offshore team of developers to build and test the data mart.
• Assisted in fine tuning the data extracts in Informatica by partitioning the data and database related queries in Oracle.
• Gather information on IT commercial off the shelf (COTS) products / services.

Technical Environment: Oracle 10g, UNIX Confidential scripts, Informatica Power 9.5

Confidential, CA

Sr . Consultant / ETL Lead/System Analyst / Applications DBA

Responsibilities:

• Ensured that Daily Data Loads to the Data Mart were accurate and on time. The process interacted with 2 data warehouses of SCHWAB and UBS to make sure good clean data is received.
• Analyzed and resolved complex database issues, including security, configurations and performance. Simplified the process, reducing downtimes, improving performance and making it easy to maintain.
• Wrote complex queries using analytical functions for data retrieval and reporting. Evaluated existing processes and identified new processes, techniques and procedures to enhance and improve the quality of systems for storing, mining, retrieving, displaying and purging data.
• Partitioned tables, re-organized index columns, gathered statistics and tuned SQL queries to improve database performance greatly for reporting and data loads. The load times improved significantly from 15 hours to a few minutes.
• Helped modify reports in Crystal 11.
• Responsible for building migration scripts to transfer data from Oracle to Teradata and Upgrade Informatica Power Center 6.2 to 7.1.

Technical Environment: Oracle 10g, UNIX Confidential scripts, Informatica Power Center 6.2/7.1, Teradata, Business Objects, Crystal Reports 11

Confidential, CA

Project Lead

Responsibilities:

• Designed Collection Process for the data coming from the Internal SUN Manufacturing Shop Floor Database and External Suppliers XML/ Flat Files using WEB SERVICE exchange of XML with SOAP, DOM, SAX, XSLT.
• Integrated Pre/Post Shipment Configurations and linked them to failures and accessory Data.
• Established Supplier Quality and Efficiency by Centralizing Serial /Part Numbers built into the system, to easily identify defective part numbers, so that they can be recalled.
• Designed, Implemented and tested the ETL logic for bookings, backlogs, shipments and returns.
• Streamlined the Historical Reprocessing Module which could run on demand. It synchronized the subject areas to the changes done in the Item Master with Bill of Materials and recalculated the consumption.
• Specified and defined nature of project deliverables. Actively sought out and received support and collaboration from other data management reporting groups within the organization.
• Suggested improvements in the process thereby improving Data Quality.
• Influenced and Trained cross-departmental teams to develop and execute new changes with maximum efficiency and effectiveness. Provided assistance to Developers during all phases of Implementation.

Technical Environment: ER- Studio 5.1, Informatica Power Mart 5.1, Java, XML, SOAP, XSLT, Tri Fox Trim PL, PL/SQL, Korn Confidential scripts, Oracle 8i/9i, Oracle ERP, Informatica Power Center 7.1