SUMMARY:

• Technical Project Manager/Business Analyst/Solution Architect with 15+ years supporting technology solutions for Analytics, Business Intelligence, and Data Warehousing to support business operations globally.
• Project manage end - to-end delivery, risk management, change management, runbooks maintenance (documentation) and performance monitoring to implement IT projects using qualitative and quantitative methods to increase organizational efficiency.
• Implement solution activities including meetings, approvals, processes/testing, updating runbooks and documentation, training/transition of resources and delivery of the systems.
• SDLC - Planning, Analysis/Design, Development, and Testing includes creating UAT and regression tests. Solid experience gathering/analyzing business requirements to identify and understand source data architecture and systems.
• Perform Data Analysis, translate business requirements into technical specifications, document needs and liaise between PM and technical teams.
• Review metrics and key performance indicators to Identify risk, manage and escalate issues.
• Design, develop and map physical/logical data models using Erwin, performing in-depth analysis to build metadata layers.
• Develop Application Process Interface (API) - interactions between OS, protocols, document to understand software architecture systems and monitor interface stability.
• Design/deploy system scope - versions/upgrades of existing APIs. Identify/perform Gap Analysis; t feasibility studies, cost and benefit analysis, and business impact of new application on current APIs.
• SQL (scripts, stored procedures, triggers, indexes) implemented with solid working knowledge in Data Cleansing, Data Modeling for Data Staging/ Data Mart, ETL, Indexing, Quality Assurance, Data updating plan, and Data presentation to users of Oracle/SQL Server Data Warehouse.
• Coordinate and conduct JAD sessions.

TECHNICAL SKILLS

OS/DB: AIX, Unix, Sun OS, Linux 6.0

Database: Teradata, Oracle, DB SQLite3

Languages: SQL, PL/SQL, C, C++, Python 3.5, Unix Shell Scripts, DB Sqlite3

Methods: ITIL, Agile, Waterfall

Project Mgt.: MS Project, MS Excel, PowerPoint, MS Office, JIRA, Smartsheets

Other: SAS Enterprise Miner, SAS Data Integration Studio, SSIS, WebLogic, Tuxedo, WebSphere, Tivoli, BMC, SAS BI Dashboard, Web Report Studio, Enterprise Guide, SSRS, IBM Data Stage, Multi Load, Fast Load

EXPERIENCE:

Confidential, NY

Project Manager

• Creating an enterprise “data map” for IT storage management and visibility
• Enterprise-level search and analysis based on keyword, metadata, search patterns and users
• Policy-driven surveillance across files, shares and repositories
• Regulatory driven WORM archiving.
• Support CIFS or NFS file shares, SharePoint (2010, 2013), Box, Salesforce Files and Amazon S3.
• Schedule and ad-hoc reporting. eDiscovery workflows with case management, tagging and investigation.
• Data analytics through visualization and Intelligent representation.
• Develop and maintain robust test plans for QAT and integrate with Project Plan.
• Liaise between the client and Project team, communication, co-ordination of requirements, conversion of Technical requirements into Business requirements.
• Coordinate Offshore and Onshore, multiple locations, external vendors and consultants.
• Facilitate and moderate team meetings to plan for interdependencies, status awareness.
• Provide input and co-ordinate with team on QAT Test Case scenario/data generation.
• Develop/maintain structured project plan, meeting schedules, status reports, management updates.
• Monitor Key Performance Indicators (KPI) and metrics to evaluate project status, adjust and adhere to good governance and responsive action to rectify deviations and delays.
• Facilitate Time Management, team coordination, Understanding interdependencies, provide status awareness, guidance and mentorship.
• Data Generation, Data Management and Process Management.

Confidential

Tech Project Manager / Business Analyst (Consultant) - Analytics and Data Warehousing

• Facilitated end-to-end management and delivery of Analytics and BI projects and Service Delivery Model for Planning, Problem Identification and solution defining,
• Integration, Implementation, 24x7 support on critical systems, communication and relationship management and ensured adequate resource availability to meet project needs
• Provided technical oversight reviewing architectural designs, offering alternative solution approaches.
• Understand/support business requirements/inquiries, in corporate into SDLC to interface with APIs.
• Collaborate with business team to redesign key business processes using Use Cases, Workflow Diagrams, and Data Flow Diagrams.
• Designed/deployed scope of new system, versions, upgrades as per existing APIs, to identify and perform Gap Analysis between current and future applications.
• Conducted Feasibility Studies, Cost & Benefit Analysis, and Business Impact of new application on current APIs.
• Coordinated and provided Application Support Process - Change Management for smooth process flow, to produce incident reports and risk assessment, solution and documentation.
• Scheduled/planned testing (UAT, regression testing) process to manage delivery of application migration, version control, System upgrades. Managed SLAs for applications in support and maintenance phases
• Data Management and provision for new cross-product reporting requirements for the data warehouse.
• Produced Business Intelligence Predictive model , extract data from repositories, cleanse, transform for report generation and for business support systems.
• Provided Functional specifications for conversions, interfaces, enhancements and generated ad hoc reports.
• Provided functional data support to various modules like Accounts Payable (AP), Auto-loan Purchasing (PO), General Ledger (GL), P&L systems and reports, Asset Management (AM), Inventory Projects within Data Warehouse environment.

Confidential

Business Analyst/Project Manager / Technology Delivery & DW / Middleware Integration

• Integrated IBM middleware technologies with databases/applications to meet project needs, SLA’s.
• Analyzed cost data and assessed risk to identify business growth opportunities
• Managed delivery of project milestones, upgrading, change management procedures, critical support (on call), communication and documentation (Maintaining run books).
• Analyzed/understood API structure and performed Gap Analysis between current and future applications; conducted feasibility studies, cost and benefit analysis, and business impact of new application.
• Created detailed requirements documentation, including data flows, work flows, use cases, business rule assumptions, report samples, logical data models and other details required to translate business needs into high-level technical specifications to be implemented by the development team.
• Utilized project/program management metrics in achieving SLAs.
• Provided account leadership to the delivery teams.
• Directed functional and technical teams to provide cost effective development and support services globally.

Confidential

Data Warehouse/Middleware Integration/ Project Delivery

• Managed the delivery and management of Data Warehouse and BI Projects
• Managed service delivery including day-to-day operations, budget management, supplier management, service level agreements, and issues management
• Managed a team of system administrators and database administrators to support a number of Telecom applications for Windows/UNIX platforms
• Provided support for Sales and Marketing, and Corporate Center applications for midrange (UNIX / NT) and mainframe platforms
• Participated in strategic and technology planning sessions with client executives
• Managed the responsibility for meeting systems performance, availability, and capacity targets
• Managed SLA metrics, problem identification and resolution
• Worked cross-functionally and influenced strategic decision-making
• Led technology selection process effort
• Sales & Marketing application - built/delivered a Sales & Marketing application to allow cross-selling and up-selling of their portfolio of products.
• Led a project team selection process to put together a qualified high-performance team

Confidential, NJ

Tech Program Lead - Data warehouse + OLTP + Middleware Integration

• Managed client relationship and program management responsibilities leading multi-functional teams to deliver data warehousing and analytics solutions. Acted as the internal marketing champion of the solution and sold the solution to C-level management.
• Supported mission-critical applications (servers/databases) - OLTP (production) databases, development databases, highly accessed and Enterprise Data Warehouse for business analytics, sales incentive programs, sales analysis, and business trend analysis
• Designed, ported, supported, monitored and administered systems including, OS, applications, middleware, and databases to meet client’s critical business needs
• Monitored and supported high availability systems and applications to meet SLAs.
• Coordinated with teams both domestic and international for system development and support

Confidential, NJ

Lead DBA - Administration of OLTB Databases

• Lead Oracle/DBA for OLTP/development databases for the telecom giant.
• Designed, planned, configured and created DW databases.
• Performed day-to-day administration, monitoring, enhancing performance, report generation, and testing for databases for mission-critical applications.
• Coordinated with other teams in system test, user test configuration and system performance enhancements
• Automated application systems for operational efficiency, reduction downtime and errors

Confidential

Developer /Programmer for banking sector

• Developed programs as per business requirements, implemented and supported the application after deploying them into production
• Enhanced the implemented code as per new business requirements
• Debugged, diagnosed and fixed existing code on an on-going basis