SUMMARY:

• An accomplished highly motivated and skilled enterprise data architect with complete understanding of SDLC over 23 years of comprehensive experience in the Information Technology
• Build conceptual, logical and physical data models for OLTP and OLAP systems
• Developed staging, ODS and Reporting Presentation data models
• Build snowflake, star schema data mart models
• Extensive experience in development of new solutions, process implementation, estimating, planning, applications development, design, installation, implementation, support and team management
• Developed policies, procedures, standards and processes for product delivery ensuring these are followed during SDLC
• Responsible for projects completed by development teams that are located on - site, offshore, near shore
• Ability to multitask in an effective and efficient manner and multiple time zones
• Responsible for Service Level Agreements(SLA) are met and providing Estimated Time to Complete (ETC)
• Consistently met and exceeded project goals by delivering project on time and within budget

TECHNICAL SKILLS:

Operating System: Windows, Linux, UNIX

Data Modeling: CA Erwin, CA Model Mart, Embarcadero ERStudio

Methodology: Agile and Waterfall, Data vault

Database: Oracle, SQL Server, Teradata, Btrieve, Microsoft Access

Big Data: Cloudera Hadoop

Languages: ASP, JavaScript, Java, C, HTML, Visual Basic, Cold Fusion, Power Builder, VBScript, Pascal

IDE: Visual Studio, Oracle Forms, Web logic, IntelliJ IDEA

Web & Application Servers: Microsoft IIS, Cold Fusion, Web logic

Reporting Tools: Cognos, QlikView, Business Objects Enterprise XIR2, Crystal Report, Web Intelligence, Infoview, OBIEE, Microsoft SQL Server Reporting Services SSRS, Microsoft SQL Server Integration Services SSIS, Tableau Configuration Management: Perforce, TFS, PVCS Version Manager, Requisite Pro, VSS

Framework: J2EE, COM/DCOM

Tools: Toad, PL-SQL Developer, Oracle Enterprise Manager, Quality Center, Analytix Mapping Manger, Trillium, Oracle SQL Developer/Data Modeler, XMLPAD

Others: ADO, DAO, RDO, COM, DCOM, T-SQL, ActiveX, XML, XSD, Rally

Mainframe: OS390, TSO, ISPF, VSAM, JCL, COBOL, Easytrieve, Intertest, CA11, APC, Pan-Apt

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect

Responsibilities:

• Responsible for building data models for revenue management process for flight
• Data Models build for Flight Number, Out of Balance, Availability Scheduler, Forecast, Optimization, Bid Price Curve Generation, Real time seats allocation and costing,
• Responsible for discussion with business to capture data requirement and suggesting alternatives for better processing
• Working with development team and dba for deployment of data models
• Updating data models with new changes

Technology Oracle, Oracle Exadata, Erwin, Teradata, Embarcadero ERStudio, Rally

Confidential

Senior enterprise data architect

Responsibilities:

• Developed Source to Target data mapping
• Developed Erwin models for the presentation and business layer
• Worked on RCA for production issues caused during data migration process and identifying solution

Technology Oracle, Erwin, Model Mart, SQL Server

Confidential

Senior enterprise data architect and SQL lead

Responsibilities:

• Developed Party Model for the Frequent Travel ID process
• Developed SQL code to test web service response
• Project involves onsite-offshore model

Technology Oracle, Erwin, Java, SQL Server, Tibco MDM

Confidential

Senior data architect lead

Responsibilities:

• Developed conceptual, logical and physical data model for mobility and home solutions business division
• Project involves discussions with various team members from both business unit across different states
• Conducted daily calls to gather business understanding about new data model

Technology Teradata, Erwin

Confidential

Senior data architect

Responsibilities:

• Developed domestic booking data model for passenger booking from xsd files. Data is received in xml format and then transposed into oracle database
• Developed the output xsd generation for enterprise wide model

Technology Oracle, Erwin, Java, XML, XSD, XMLPAD, PL-SQL Developer

Confidential

Senior data architect and SQL lead

Responsibilities:

• Worked as a data architect to develop solution to load data into oracle database and build KPI tables
• Developed Conceptual, Logical and Physical data model for the presentation layer
• Conducted daily calls and status update to the higher management
• Worked on data upload process from SAP system
• Developed oracle packages, views, materialized views, functions, procedures

Technology Oracle, Toad, Tableau

Confidential

Senior data architect and SQL lead

Responsibilities:

• Developed international booking data model for passenger booking from xsd files. Data is received in xml format and then transposed into oracle database
• Developed Conceptual, Logical and Physical data model for ODS
• Worked as a SQL lead to develop solution to verify Java team processed and populated data properly into the oracle database
• Trained, mentored, Lead 12+ team members
• Project involves onsite-offshore model
• Conducted daily calls and status update to the higher management
• Developed oracle packages, views, materialized views, functions, procedures
• Query tuning for performance on materialized views based on xml objects and tables

Technology Oracle, Erwin, Java, XML, XSD, PL-SQL Developer

Confidential

Data and reporting architect

Responsibilities:

• Responsible for technical architecture of defining data model for staging, operational and reporting databases
• Responsible for building conceptual, logical and physical data model using Erwin
• Responsible for reporting architecture for defining reporting architecture, reporting model, report structures
• Responsible for understanding requirements and discussion with client
• Responsible for installation and configuration of software on the server and server access to the team
• Responsible for defining report layouts
• Worked with other PwC teams for setting up servers

Technology Oracle, Erwin, Cognos, DataStage, Business Objects, Crystal Reports, Weblogic

Confidential

Data architect

Responsibilities:

• Responsible for technical architecture of data migration strategy defined spoke & hub model of migration
• Responsible for data architecture for defining target model, comparison of source and target model
• Responsible for technical architecture of interfaces with different systems after sun setting source applications
• Responsible for data profiling and data cleansing activity
• Responsible for leading client teams for data analysis and data cleansing activities
• Worked with external vendors for acquiring Analytix Mapping Manager Software for the client

Technology Oracle, Erwin, Microsoft SQL Server, Business Objects, Crystal Reports, Analytix Mapping Manager, Trillium, Oracle SQL Developer/Data Modeler

Confidential

Data architect

Responsibilities:

• Team Lead of PwC and PwC India resources and responsible for task completion
• Responsible for technical architecture of report delivery for each bank with less modification to the report files
• Responsible for delivery of 600+ reports for banks with customization
• Responsible for discussions with internal/external users of the project to gather requirement

Technology Oracle, Erwin, Microsoft SQL Server, SQL Server Reporting Service, SQL Server Integration Services, Business Objects, Crystal Reports

Confidential

Responsibilities:

• Worked as a data and reporting architect
• PwC, PwC India, TCS Uruguay co-ordination for resources, quality control and task completion
• As a lead of 5 developers to assign work, discuss with testing team and business analyst to resolve defects
• Gathering requirement from business analysts, business solution manager for evaluation of the technology and building solution
• Responsible for Business Objects Scheduled reports information to be converted to the SSRS
• Understanding Business Objects security and configuration so that it can be implemented in SSRS
• Participated in providing input to the internal business users for the product and functionality of new system

Technology Oracle, Erwin, Microsoft SQL Server, SRS, SSIS, Business Objects, Crystal Reports

Confidential

Responsibilities:

• PwC and PwC India co-ordination for resources and task completion and support to offsite resources
• Generated reverse engineering documents and helped business analysts to make them understand business process, which helped them to discuss with the business owners
• Lead PwC India team of 3 developers to build the reverse engineering documents
• Responsible for the produced deliverables and discussions with business analysts

Technology Oracle, Power Builder

Confidential

Responsibilities:

• Worked as a data and reporting architect on the project
• Lead team of 15 developers of PwC and PwC India for project completion and support to offsite resources and co-ordination of project delivery
• As a lead on defect resolution, participated in meetings for acceptance, rejection of the defect from the testing team, assigning priority and getting issue resolved and deployment for the same
• As a functional and technical expert on CES project participate with offshore teams and leads on knowledge transfer and providing feedback
• Developed Conceptual, Logical and Physical data model for staging, ODS and reporting schema
• Responsible for gathering requirement and discussion within firm-wide users about the product and support
• Participated in providing estimation, solution and alternative solutions
• Implemented and suggested new process to overcome the issues with data and performance improvement
• Implemented code review process and made sure process is followed for CES deployments
• Implemented code check-in deployment process and made sure process is followed for CES deployments
• Interacted with different teams/organizations within the firm for the project needs
• As a subject matter expert provide coaching and mentoring to the team and new team members on the process and application, by providing welcome to the CES document. This document helped on boarding new resources easily on project and become productive faster
• Provided technical input on different product evaluation and suggesting to the firm along with pros and cons on the product
• Provided weekly status report for defect resolutions by initiating weekly team meetings for onsite and offshore
• Ensured code developed by team members is with specifications, reusable with standards and appropriate documentation for the same is created/updated
• Escalated the issue to the management if additional help is needed on resourcing and/or any other conflicts related issues within team
• Performed Code Reviews & deployments via change control process and support during deployment
• Provided technical and analysis support to the project leads for enhancements and maintenance
• Participated in Change Request, Defect Review meetings for upcoming tasks
• Initial support for the production defects to do the research and finding out the root cause, suggesting work around, till the solution is decided and provided
• Responsible for Business Objects architecture and implementation, applying patches and keeping system update with latest patches
• Responsible for defining Business Objects Security, report processing using WEBI interface
• Worked as a Business Objects Server administrator for updating code/users/support
• Responsible for delivery of crystal reports automation using FTP, shared folder or email distribution
• Developed oracle procedures, packages, triggers and asp front end
• Developed crystal reports and publishing via business objects server for offline reporting module
• Provided feedbacks to different teams within firm on business objects offline reporting architecture and giving guidance, on how to build the offline reports securely

Technology Oracle, Erwin, Web Logic, Business Objects Crystal Reports, UNIX