Objective

Extensive experience designing, developing and managing Financial, Logistics, Customer Service, and Data Warehousing projects using data modeling techniques such as Star Schemas, Snowflake Schemas. Effectively managed, coached, motivated and mentored developers onsite and offshore. Led and managed full life cycle Data warehouse projects from inception through implementation for thousands of users around the globe. Provided efficient technical designs, cost cutting initiatives and risk analysis related presentations to senior management. Developed data quality standards and security policies.

COMPETENCIES and ENTERPRISE SOFTWARE SKILLS

Core competencies: Data Mining and Analysis, Business Intelligence, Project Management - SDLC, Data profiling, Business Requirements, Data Modeling/Data marts, Transact SQL, ETL Process Flows, Financial Analysis, User Acceptance Testing, Data Validation

Databases: ORACLE 7.x - 11g, RAC, Sybase 10, 12.x, MS SQL Server 2000, 2008, DB2

Tools: Informatica 7x-9x, Erwin, Power Designer, DBArtisan, Toad, Eclipse, Together Architect, Visio, Microsoft Project, Tibco EMS, Autosys

Languages: Perl, Java, VB.Net, ASP.Net, PowerBuilder

EXPERIENCE

Confidential

Informatica Architect

• Maintaining communication with stakeholders at multiple levels such as project sponsors, downstream, senior management.
• Managing resource/cost, schedule, and performance of project, ensuring successful project implementation.
• Integrating complex data from disparate sources into a data warehouse and applying strong analytical skills for strategic implementation.
• Translating high-level requirements from the business into effective BI solutions.
• Simplifying complex requirement into efficient technical design and reviewing with solution architect team.
• Assigning, tracking development tasks, providing leadership and direction to personnel.
• Complex Metadata designing, Informatica ETL designing, and exception process designing, interacting and communicating with business analysts and technical experts.

Environment: Oracle 11g, Informatica Powercenter 9.x.

Confidential

Associate Director/Database Architect

• Directed coordination with multiple teams for implementation of multiple phases of project.
• Effectively coached, mentored and lead onsite and offshore team enabling optimum efficiency.
• Successfully coordinated Infra implementation and upgrades including Oracle RAC, improving significant application performance, reliability and reducing cost and saving firm's IT budget.
• Prepared and delivered presentations of strategies and designs to senior management, department heads, and team.
• Created test strategies for disaster recovery plans. Acted as subject matter expert for all disaster recovery questions and issues.
• Performed extensive data requirement analysis, gap analysis to implement complex business requirement.
• Designed core metadata architecture simplifying and managing complicated database application efficiently.
• Designed, developed, and performed code review of Informatica ETL mappings.
• Saved firm from large amount of penalties implementing regulatory process timely and successfully.
• Defined secured and streamlined downstream on-boarding adoption process.
• Improved performance of ever growing and constantly changing application some by more than 70 .
• Implemented reconciliation monitoring processes to effectively track, resolve issues.

Environment: Oracle 9i/10g/10g RAC Linux , Informatica Powercenter 7.x/8.x, Sybase Adaptive Server 12.5, Java, Tibco EMS, Perl 5.8.x, DBArtisan 7.x, Power Designer 10, ER-Win 4.x, Visio 2002, Microsoft Project 2000, Clearcase, Reflection, Together Architect, Eclipse, Micromuse, Autosys, Windows/2000/XP, Linux RHEL3, 5 , Unix SunOS 5.6 .

Confidential

Applications Manager/Lead Sybase Developer

• Lead and managed financial applications accounting brokerage and management fees, Decision Support System providing cost-benefit, risk analysis and valuable reports.
• Assisted senior management in their IT budgeting by furnishing technical input and carrying out buy versus build analysis.
• Analyzed, enhanced and improved application performance to achieve best overall outcome.
• Managed offshore development team and streamlined process cutting huge IT development costs.

Environment: Sybase Adaptive Server 11.9.2/12, SQL Server 2000, VB.Net, ASP.Net, PowerBuilder 6.5, 8, PFC, PowerCerv, DBArtisan 5.4, Perl, Power Designer 6.1, WS-FTP 5, Visio 2000, Microsoft Project 2000, StarTeam 5, PowerCerv PC Financials, Citrix 6.31.1051, Windows/2000/XP Pro, Unix DEC .

Confidential

Project Leader/Lead Sybase Developer

• Improved and optimized performance to its best for more than thousand concurrent users.
• Improved nightly jobs to cut down processing times from hours to seconds.
• Written ETL scripts to transfer data across the databases and servers, for data warehousing and for purging, archiving.
• Lead and Mentored developers

Environment: Perl, Sybase Adaptive Server 11.5/11.9.2/12, PowerBuilder 6.5, 7, APOL Framework Advance PowerBuilder Object Library , PowerBuilder Foundation Class Library PFC , Visio 5.0b, Account4, Erwin 3.5.2, DBArtisan 5.03, WS-FTP 4.12, Windows/NT4, Unix AIX .

Confidential

Project Leader/Lead Sybase Developer

• Designed and developed scalable and robust forecasting application for multiple levels of business users/managers.
• Added value to the business providing detailed level information providing near accurate forecast.
• Incorporated multiple level of data security.
• Designed and built logging feature to track each activity.
• Designed and developed generic Auto Download application for new releases.
• Improved application's performance by continuous monitoring and tuning.
• Lead and mentored developers, trained users.

Environment: Sybase System 10/11, Windows/NT, PowerBuilder 6.5, PowerBuilder Foundation Class Library PFC , Visio 5.0b, Microsoft Project 98, Erwin 3.5, DBArtisan 4.02, Unix.