Senior Business Analyst Resume San Ramon, CA - Hire IT People

SUMMARY

Business and Technology leader with abilities to manage and market a service or product through its lifecycle .
Planning, analysis, design, project management and implementation phases with strong development and technical project management skills.

TECHNICAL SKILLS

Databases: Oracle, DB2, IMS, Sql Server, MySql, Postgres

DB Tools: SQL*Plus, SQL*Loader, TOAD

Programming: SQL, PL/SQL, Unix Shell Scripting, HTML, Cold Fusion, COBOL, Control - M, JCL, SYNCSORT, SPUFI, QMF, FILEAID, XPEDITOR, PACBASE.

ETL, Data Modeling Tools: Erwin, DbSchema

OS: Windows, MVS, Unix, Linux

Tools: Oracle Grid Control, Golden Gate, MS Office, Visio, TeamSite Content Manager, RequisitePro, Jira, Rally, Jenkins, Tableau, Quality Center

Big Data Tools: Tableau, Python, Mongodb, Cassandra, Hadoop, Spark

PROFESSIONAL EXPERIENCE

Senior Business Analyst

Confidential

Responsibilities:

PeopleTools- Component Interface, Process Scheduler, PS Query and Data Mover.
Worked as Sr. Business Analyst on PS (ver 9.2) for Benefit Admin support team Confidential Confidential Permanente. Provided application support for the Employee Benefits. Created solutions by reviewing and analyzing existing systems and processes. Defined functional business requirements and translated them solution design and CIs for updates to the system. Conducted gap analysis to document discrepancies between business requirements and system capabilities. Developed project tasks plans and ensured time line adherence. Report development and interfaces validations, and coordinated and conducted System Test and UAT. Served as the liaison between the business clients and the KPIT organization.
Mainframe Data analysis to integrate client requirements into real time data analysis. vStorm Enterprise software tool brings near-real-time access to z/OS data to integrate data across IT infrastructure.
Mapping mainframe data into MongoDB.

Confidential, San Ramon, CA

Lead Operations DBA

Responsibilities:

Managed 50 plus database instances across multiple business critical applications.
Dashboard DB Design - It keeps transactional summary of API usage for statistics and audit analysis and reporting.
DB Migration Unix to Linux and upgrade to Oracle 11g on Confidential &T Cloud. Project Managed tasks using Jira.
Automation of Database deployments using open source Jenkins.
Data modeling ERWIN9.5, Logical, Physical database design and Normalization.
PLSQL-DDL-DML Development for maintenance and enhancements projects in both Agile and Waterfall methodology - Creating Packages-Procedures-Tables-Indexes-MViews-Partitions. Optimized and wrote SQLs, Stored Procedures.
Database Refresh in Performance and Dev-QC-Test-UAT environments and Load testing during iPhone launches.

Confidential, San Ramon, CA

Lead Database Architect

Responsibilities:

Enterprise Data Modeling, Star/Snowflake schema, based on requirements gathered from multiple stake holders for new and existing products its features, content and pricing.
Managed Master data for all Products - Pricing, Promotions and Market.
PLSQL-DDL-DML Development for maintenance and enhancements projects in both Agile and Waterfall methodology - Creating Packages-Procedures-Tables-Indexes-MViews-Partitions. Optimized and wrote SQLs, Stored Procedures.
Designed Rapid Deployment - Increased RD delivery every year. RDs allow for quicker delivery of crucial marketing promotions, campaigns and competitive introduction of new products, price changes and content management. POC and pilots presented to leadership and business teams.
Dev Lead on major release. Managing projects and its estimation and prioritization. Allocation of work to onshore and offshore contractors and tracking progress till implementation.

Confidential, San Ramon, CA

Lead Analyst

Responsibilities:

Automatic Directory Extraction and Scheduling Process: Lead in Requirements, Design, Development, Testing and Implementation of Listing Services upgrade from second generation software (Cobol, C-List, JCL) to a web-based system. ADESP directory extraction automation using Cold Fusion and Oracle, dramatically decreased system failures by 75% enabled reporting delivery via email and reduced enterprise expenses. In all company is saving $1.3 million every year on book extraction and repository for enterprise customer listing information.