SUMMARY

• An effective IT Project Manager / Business and Data Analyst / Technical Specialist with over 20 years of extensive experience in financial fields with high level of expertise in business and data analysis; driving cross functional initiatives and BI data warehouse; design, implementation and maintenance of complicated environments and databases for variety of business applications.
• Proven track record of full project life cycle, management and implementation of highly visible projects on time and within budget.
• Dedicated self - started team player with “Can Do” attitude and excellent interpersonal skills used to working with business users, various teams and stakeholders across the company, and successfully working under pressure.

TECHNICAL SKILLS

• MVS/ESA, MS Windows, IBM 3090
• SQL, T-SQL, COBOL, CICS, JCL, SAS, HTML, Visual Basic
• SQL Server, DB2, UDB, Sybase, Oracle, NoSQL
• TSO/ISPF, VSAM, SPUFI/QMF, IBM Utilities, MoveDB2
• FILE-AID, Endevor, Strobe, API, CATS, Cognos
• APPTIO, VMWare, QlikView, ServiceNow, Visio
• SDLC, ETL, Waterfall, Agile / Scrum
• MS Office, Access, Excel, PowerPoint, SharePoint, Project

PROFESSIONAL EXPERIENCE

Confidential

IT Project Manager / Business and Data Analyst

Responsibilities:

• Communicating with upper management and various financial, corporate, datacenter, application and business teams to gather requirements and providing meaningful data to support business decision making; conducting JAD sessions and conference calls; liaison between users and IT technical teams
• Lead application onshore and offshore project team, driving planned activities, managing project execution, budget and costs, schedule, change requests, scope and resources
• Preparing BRD, project plan and documentation; designing system business logic, allocation methodology and define metrics, screens and reports; UAT testing and production implementation
• Translating high level business requirements into functional specifications, preparing detail business/data analysis, resolving data discrepancies, performing impact analysis, defining SLA and priorities
• Coding SQL scripts and stored procedures; design and maintain SQL server database, reports and ETL process; consolidating data feeds into one data warehouse repository; extra-large data extraction and transformation; data mapping and cleansing
• Managing and coordinating work related to various projects between cross-functional teams, track resource utilization and financial reporting, implementing and customizing vendor software
• Led in identifying, coordinating and implementing infrastructure savings opportunities across a company for the Americas’ region, resulting in $56M in savings over 12 years, driving planned activities
• Tuning high cost jobs and transactions (using Strobe and API tools) for all applications and companies and preparing written recommendations for application teams - 2016 total savings $4M
• Designing process to analyze mainframe MICS data (codding SAS and batch jobs) and developing data warehouse and the self-help cost reporting utilization website (ASP web pages and SQL server warehouse database) for the user community
• Preparing the annual Confidential America’s infrastructure budget of over $150M based on usage trends, rate card changes, application growth, SIO initiatives, and new charge categories, including variance reporting to explain growth drivers. Presenting it to finance, management and datacenter
• Gathered requirements, prepared the BRD and functional specifications; designed system process, databases and coded stored procedures; communicated with stakeholders.
• Automated the IT Finance and Comptroller’s allocation process, dashboard report generation and virtualization, upgraded web pages. Supported interface with other financial systems and actual/budget allocation processes. Owner and gate-keeper of the actual and budget allocation methodology
• Enhanced financial month-end processes by automating data input and developing the Data Warehouse tool. This reduced processing time by 70% and decreased support team request numbers by 40%
• Incorporated $150M infrastructure datacenter cost into the FIT process.

Confidential

Project Lead / Senior Programmer Analyst - Consultant

Responsibilities:

• Tuning SQL statements, physical databases and program processing logic to achieve optimum performance through use of BMC, File Aid for DB2, QMF, SPUFI, TMON for DB2 and STROBE
• Outlined performance recommendations for implementation by application teams, which resulted in over $5M in annual processing cost savings for 37 optimized jobs
• DBA support for the AISTART application including: creation of DB2 databases and tables in the pre-prod environment, tuning database objects, setup reorg, recovery and runstats jobs, along with load/unload of data
• Functioned as a DBA: creating DB2 databases and tables in DB2 development and Y2K environments, preparing DASD requirements. Performed actual unloads/loads data and tuned the database objects using DB2 and BMC utilities
• Designed and developed tools for automated data migration of thousands of DB2 tables and files to new environments. The tools significantly reduced requests processing time, allowed the analysis of user requirements and DB2 and Master Catalogs info retrieval, generated unload/load JCL jobs and reports
• Set-up CICS/DB2 regions using CATS (to define tables entry in CICS) and DB2 utilities. Created and loaded data in VSAM files using GVExport/GVRestor
• Resolved DB2 related problems like Bind, Grant/Revoke and performance DB2 applications in CICS and Batch using TMON for DB2
• Developed, coded and tested various programs which extracted data from production DB2 database and VSAM files and loaded it with updated private information. Post implementation support and problems resolution
• Designed front and back-end of LMD utilizing Visual Basic, Crystal Report and Access in client server
• Prepared program specifications, coding, maintaining and testing various programs, which updates DB2 databases and VSAM files, provided various reports and data conversion from VSAM files to DB2 database
• Prepared front-end of the AD-HOC Reporting Module: screen design using Visual Basic, creating ACCESS and SQL Server databases, preparing reports for management using Crystal Report. System was written in COBOL II/CICS/Visual Basic using SQL to access DB2 database under OS/MVS/XA and SQL Server, Crystal Report