Data Modeling, Oracle, PL/SQL, Performance Tuning, Project Manager
Resume:
Profile Summary
Bachelor's degree in Computer Engineering with rich experience in delivering optimal results in database arena, project delivery & coordination, and business value in high-growth environments. Over 13 years in client-facing roles in USA, Canada and Ireland. Experience working with clients like Credit Suisse, CNN, KPMG, Delloitte and Touche, Tyson Foods, CNN, IBM and SeeBeyond Inc in Financial Services, Insurance, eLearning and Food Manufacturing domains. Results driven and focused with immaculate work habits, people-management, time management and leadership skills. Actively involved in architecting databases, map-gap analysis, mentoring junior teammates, development, analysis and estimations, and project management. Very good knowledge of project SDLC. Played various roles as Database Architect, Technical Consultant, Rollout, L3 Support and Implementation. Education
B. S. ( Computer Engineering ), University of Pune, India. Certifications
CEB Global (BrainBench) certified Data Modeler
Wipro Technologies Certified Project Manager
Certified MongoDB Developer
Certified Associate DB2 Developer
Certified Associate PowerBuilder Developer
Citizenship: USA
Technical Skills:
Data Modeling : ERwin
Language : SQL, PL/SQL, Shell
Database : Oracle, DB2
Management : Software Project Management, Project Delivery, Agile Methodologies IDE : Eclipse
Source Control & Build Tools : SVN, CVS
Anil Patil
* Sunnyvale, CA 94089 ) 408-***-**** : ************@*****.*** Page 2 of 3
CAREER GLIMPSE
Wipro Technologies, Pune, India. Since March 2007
Database Architect / Technical Project Manager
Ê Conceptualizing and architecting the database in ERwin to suit business needs. Ê Developing data acquisition strategy to source data from heterogeneous sources for common consumption by management and regulatory reporting engines.
Ê Coordinating with the customers for business requirement analysis and understanding technical & functional specifications to come up with an optimum database design. Ê Collaborating with major stakeholders and business analysts/SMEs to understand data requirements and conduct data- model walk-throughs.
Ê Work closely with the ETL, UI and BI teams to make sure all relevant data is acquired, captured and reported as necessary to management.
Ê Map and Gap analysis for data demand attributes
Ê Maintain organizational naming standards
Ê Performance tuning of critical batch modules.
Ê Mentoring the team and set out performance parameters/deadlines, hold review meetings and monitor the progress of the deliverables as per schedule.
Ê Carrying out analysis, development, and implementation of strategic business plans & policies. Ê Collaborating with major stakeholders.
Ê Estimation for all technical streams and planning for new projects Projects
Sep-2015 till Date (Non-Genesis Data Modeling – Citibank, FL) Wipro Technologies, Pune, India Data Architect
The goal of this engagement is to create a unified data source to provision all data used by key regulatory and management reports from strategic data repositories via DataBridge. In cases where data is not yet in a strategic repository, define target records and create data models for acquiring the data from sources. When data is already available in a strategic repository, build a data model and provide the necessary metadata to DataBridge so they can source the data from the repository. This enables a unified subscription to external sources and presents a single consolidated data view to the consumer reports thus preventing data duplication.
Enhance RegInsight which continues to transform the Citi legal reporting landscape. It has increased accuracy, consistency and timeliness in filings and replaces decade old processes, thereby reducing costs and driving standardization. Responsibility:
Ê Requirement analysis and estimation for new data demand requests Ê Map and Gap analysis for the data demand
Ê Data modelling for the data demand using ERwin, and preparing DataBridge metadata to create subscriptions. Ê Deploying data model to development database to test data subscriptions. Ê Data modeling for Rule Automation to process Enrichment Rules Ê Managing Weekly deployments using RLM and Service Now Sep-2010 to July-2015 (Strive Sustenance – Credit Suisse, NY) Wipro Technologies, Pune, India Database Architect / Technical Project Manager
Page 3 of 3
STRIVE (CLIENT VALUATION) is a system being developed for Credit Suisse for providing indicative valuations of financial instruments requested by the client. The purpose of this project is to further strengthen controls around Indicative Client Valuations business process by building a new technology platform that provides reduction in manually performed functions, enhanced workflow automation based on new organizational structure, and superior reporting capability. The new platform is expected to fully replace existing technology solution, e-Valuate. The STRIVE project involves the building of a standardized process driven IT application for generation of Client Valuation reports, based on requests received from various clients of Credit Suisse.
Responsibility:
Ê Experience covers entire SDLC from requirement specifications, systems analysis, database design, construction, unit/module/integration testing and delivery in Waterfall/Iterative and Agile set-up. Support QA and UAT operations. Ê Extensive Data modeling using Erwin to capture all data requirements and reporting needs. Ê Performance tuning and continuous batch improvement. Ê Mentor junior team members on efficient PL/SQL coding. Ê Liaise with the onsite team to capture data requirements and clarify doubts on behalf of the offshore team. Ê Delegate development assignments to individual team members and review their code. Provide design details to team members and explain required functionality before assigning any development task. Ê Manage the project team. Track all KPIs, generate monthly time-sheets, invoicing and monthly reports. Mar-2007 - Aug-2010 (HiPLUS, Ireland) Wipro Technologies, Pune, India Database Architect
Hibernian Personal Lines Underwriting System is an insurance product for Home, Motor and Travel insurance for Aviva, Ireland. This system was developed to replace the existing Vulcan system which was plagued with maintenance and enhancement issues.
Responsibility:
Ê Work with the SMEs to understand the functional requirements and implement them in the data model. Ê Estimate effort required for modeling the requirements and model the database in ERwin. Ê Delegate modeling work to team members.
Ê Perform requirement and impact analysis for change requests. Ê Coordination and interaction with customer and business user community. Ê Guide the Tactical MI team to extract data from HiPLUS for MI reporting. IBM (OutStart, Inc acquired by IBM), Orlando, FL May 2002 to July 2006 Senior Consultant
Design, develop and maintain various modules of the Evolution LCMS application. Manage the data-movement module that helps exchange data between Evolution servers. Work with Support and QA to research issues reported by clients. Develop stored procedures and/or triggers for mass data updates as a one-time solution for various clients. Perform code optimization.
Sun Microsystems (SeeBeyond Technology Corp acquired by Sun), LA, CA April 2000 to May 2002 Tech Lead
Design, develop and maintain various modules of the DataDental application. Worked extensively on creating the GUI screens using PowerBuilder 5.04. Maintain various modules in the Informix 4gl character based Unix interface. Research issues reported by clients and offer a feasible solution. Perform debugging, code optimization and documentation.
Contact this candidate