Summary of Qualifications

• An accomplished highly motivated and skilled software professional with understanding of complete SDLC over eighteen years of comprehensive experience in the Information Technology
• Extensive experience in development of new solutions, process implementation, estimating, planning, application development, design, installation, implementation, support and team management
• Developed policies, standards and processes for product delivery ensuring these are followed during SDLC
• Responsible for quality of the project completed by development teams that are located on-site, offshore, near shore
• Worked as technical lead for team size from 2 to 20 resources
• Mentoring/Coaching team members
• Responsible for Service Level Agreements(SLA) are met, providing Estimated Time to Complete (ETC) to client and initial Root Cause Analysis (RCA)
• Tracked record of developing systems that provide value to business and improve client satisfaction
• Consistently met and exceeded project goals by delivering project on time and within budget
• Expertise in implementing large multi-user websites and Client/Server projects
• Designing and developing Data Warehouse environment using materialized views
• Ability to multitask in an effective and efficient manner and multiple time zones
• Worked as a liaison between technical team and management team

Operating System: Windows NT, Windows, Windows XP, Windows Server, UNIX, Linux
Languages: ASP, JavaScript, Java, C, HTML, Visual Basic, Cold Fusion, Power Builder, VBScript, Pascal
IDE: Visual Studio, Oracle Forms, Web logic, IntelliJ IDEA
Database: Oracle 11g, SQL Server, Btrieve, Microsoft Access
Web & Application Servers: Microsoft IIS, Cold Fusion, Web logic
Data Warehouse Reporting Tools: Cognos, Business Objects Enterprise XIR2, Crystal Report, Crystal Enterprise, Web Intelligence, Infoview, OBIEE, Microsoft Sql Server Reporting Services SSRS, Microsoft Sql Server Integration Services SSIS, Seagate Info, Impromptu 
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 Modeller 
Data Modeling: Erwin
Others: ADO, DAO, RDO, COM, DCOM, T-SQL, ActiveX
Mainframe: OS390, TSO, ISPF, VSAM, JCL, COBOL, Easytrieve, Intertest, CA11, APC, Pan-Apt
Technical Specialization: B2C and B2B Solution Design

Education
Bachelor of Computer Engineering

Training
IBM Cognos 10
Oracle OBIEE

Automotive, TAX, Compliance, Real Estate, Insurance, Commercial, Retail, Banking

Confidential, Aug-2011 - Till Date - PwC\'s one of the client in automobile industry is Project involves designing data warehouse application for the accounting department for forecasting purpose. Worked as a database and reporting architect on the project

• Responsible for technical architecture of defining data model for staging, operational and reporting databases
• Responsible for building 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 Linux server and server access to the team
• Responsible for defining report layouts
• Responsible for creating Cognos packages using framework manager and deployment
• Responsible for creating Cognos reports using packages deployed
• Worked with other PwC teams for setting up servers

Technology Oracle,Erwin, Cognos, Cognos Framework Manager, Cognos Report Builder, DataStage, Business Objects, Crystal Reports, Weblogic

Confidential,Mar-2011 - Aug-2011 - PwC\'s one of the top client in security monitoring is Project involves defining data migration strategy for ADT\'s current acquisition of Brinks and for future acquisitions. Worked as a data architect on the project

• 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 and finding the issues related
• 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 Modeller

Confidential,Aug-2010 - Mar - 2011 - Tracker application used by PwC for their TAX practice. Project involves creation of w2 tax forms for 10 banks within USA.

• PwC and PwC India co-ordination for resources and task completion and support to offsite resources
• 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
• Lead team of PwC India developers for work assignments and delivery of the quality product
• 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,Sep-2009 - Jul-2010 - PwC has been using crystal reports for the delivery of the reports to its users who are using these systems. Project involves conversion of crystal reports to the Microsoft Sql Server Reporting Services

• PwC, PwC India, TCS Uruguay co-ordination for resources and task completion and support to offsite resources
• 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 interface and system administrator for pulling information from Business Objects for users
• 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
• Leading PwC India team to develop solution and responsible for quality of the work
• Co-coordinating with TCS Uruguay for quality control and assisting them for system test
• Participated in providing input to the internal business users for the product and functionality of new system

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

Confidential, Aug-2009 - Sep-2009 - PwC uses Tracker application for their TAX practice. Project involves creation of w2 tax forms for 10 banks within USA. Project involves reverse engineering of Power Builder and Oracle code. Reverse engineered document helped business to write requirement documentation, when new system is getting built.

• 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,Dec-2003 - Aug-2009 - PwC uses CES application for Independence & Compliance of its employees.

• Lead team of 20 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
• 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 reports on the defects resolutions
• Initiated weekly team meetings with teams and offshore teams
• Ensured code developed by team members is with specifications, reusable with standards and appropriate documentation for the same is created/updated
• Involved in planning to push database changes on the same package in non development box to ensure quality delivery
• 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 and help leads with support needed
• Validated database code deployments in production and other boxes
• Provided offshore teams software tools such as toad, pl-sql developer, change control, Mercury quality center to complete the project
• Kept DBA\'s, Project Managers and other Technical Leads informed about upcoming production deployments
• As a subject matter expert on CES data flow, from loads to the user front end
• Provided demo to the business on the product delivery and new modules development demos
• Provided alternative solutions for complex queries performances
• Provided support after deployment and within warranty period
• 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 crystal interface and 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
• Designed, implemented and supported various projects in the independence system
• Developed oracle pl-Sql procedures, packages, triggers, external tables and asp front end
• Developed offline reporting module for CES application
• Developed crystal reports and publishing via business objects server
• Provided feedbacks to different teams within firm on business objects offline reporting architecture and giving guidance, on how to build the offline reports securely
• Updated ERD and Data Dictionary for CES project in timely manner
• Responsible as a DBA backup for non production box

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