SUMMARY:

• A results driven Financial Services Information Technologist and Operations Leader with over 20+ years of hands - on experience in managing and leading on-shore and off-shore development teams, trainings, timelines, estimates,
• I have successfully managed all phases of the projects right from inception to delivery including the definition of scope, estimation, forecasting, budgeting, kickoff, planning, analysis, risk management, design, development, quality assurance, implementation, client on-boarding, user guides, training and post-production.
• Expert in designing Datamarts and Data Warehouses and integrating heterogeneous legacy applications, Data Architecture, Relational and Dimensional Database Design.

EXPERTISE AREA:

• Strategic Planning & Leadership Process Improvement Change Management
• Team Leadership/Motivation Vendor Management Client Relations
• Strategic Sourcing Budgeting and forecasting Software Development Life Cycle Management
• Data Architecture Deployment/Migrations
• On/Offshore Resource\ Management

TECHNICAL SKILLS:

Data Warehousing : Informatica Power Center 9.5/9.1/8.6.1/8.5/8.1.1, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling,Snowflake Modeling,Physical and Logical Data Modeling using ERWIN.

Reporting Tools: Business Objects XI R2, Qlikview

Databases: Oracle10g/9i, Sybase 12.5/15, DB2 9.x/10.x, MS Access, SQL, PL/SQL, SQL*Plus and SQL Server 2010

Languages: SQL, C, PL/SQL

Version Control: Perforce,CVS

Operating Systems: MS Windows 98/NT/2000/XP, UNIX, IBM-AIX, Sun Solaris and Linux

Tracking Tools: HP Quality Center, ServiceNow

Scripting: Unix Shell Scripting, Korn shell scripting.,Perl,Python,XML

Schedulers : Autosys

Others: Microsoft Office Suite,Visio

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior IT Operations Project Manager/ Development Manager

Responsibilities:

• Manage, identify, assess, categorize, remedy and rectify Incidents and Problems in a timely fashion, supported by HP Quality Center system.
• Run daily Operation meetings, highlight Incidents (IM), Changes (CM) and Problems (PM) in the Production environment, review goals, strategies, Define the SLAs
• Responsible for driving Project Bulletproof Road map activities designed and devised to improve Data Quality at different levels (Source,Staging,Reporting)
• As the team matured, it took over the responsibility of code migrations, building the environments for developers, automation of any Manual tasks reducing the possibility of any issue.
• To prevent loss of knowledge due to attrition I organized trainings for the team from the Subject matter experts (SMES) and had them recorded.
• Responsible for driving the company Mandated Hygiene Program for our group. This involved Identify/Analyze/Remediate activities which needed to be coordinated within our team and the Confidential Infrastructure teams. Few examples are Db2 Upgrades to 10.x versions for 8+ servers (Production and Non Prod), Linux Upgrades for 10+servers.
• Responsible for all the Incoming/Outgoing Financial Interfaces Stability / Enhancements coordinating with the Financial BAs
• Created and facilitated Incident Management Escalation Matrix and status notification to senior management.
• Instilled standard reusable processes and established change management procedures.
• Established the Best Practices for development, Migration and deployment processes within the group

Environment: Informatica 9.x,Business Objects R3/XI/4.0,Linux,DBArtisan 8.5,HP Confidential, HP Quality Center, Microsoft SAS Cubes,Qlikview.,Autosys R4.,DB2 10.1,Perforce (for versioncontol)

Confidential

Business Intelligence/Data Warehouse Lead

Responsibilities:

• Drove the strategic vision, architectural design and creation of a centralized data warehouse in partnership with the stakeholders.
• Interviewed business users individually and in-group sessions in order to surface data requirements and planning activities.
• Responsible for the scope, plan, budget, staffing requirements, server evaluation, database designs, capacity planning and security levels.
• Responsible for the complete SDLC and deliverable deadlines for this project
• Successfully delivered the first version of Confidential warehouse on time and on budget.
• Post deployment responsible for Support processes

Environment: MS Visio, Erwin, INFORMATICA 8.6.1, Sybase 12.5 /15.x, ESP, Oracle, Linux, Business Objects XI R3

Confidential

Risk Officer

Responsibilities:

• Getting all the applications certified under ILM ( Information Life Cycle guidelines) from the compliance department
• Coordinate all the Software upgrade activities
• BCP Testing planning for all applications within our group

Confidential

Senior DB Analyst /ETL Developer

Responsibilities:

• Responsible to data mappings between the Source (Flat Files) and Target Sybase Schema) and also the Informatica Mappings to load/transform and report on the data.
• Design the test strategy with the QA Team Lead for validating the data flow.

Confidential

Senior Database developer

Responsibilities:

• Developed the application using CGI/Perl and Sybase DB Libraries
• Few years into the product I was responsible along with a team of 2 ETL developers to transform all the ETL business logic from Perl and Sybase stored Procedures into Informatica
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and
• Lookup, Update strategy and Sequence generator and Stored Procedure.

Environment: Informatica 7.x,Business Objects R3,Linus,DBArtisan,HP Confidential Sybase 12.5.

Senior Programmer/Analyst

Confidential, NY

Senior Database developer

Confidential, McLennan, NY

Team Lead /Developer/DBA

Confidential

Database Developer

Confidential