Zahida Sharief Email & Phone Number

Los Angeles, Ca, Us

Irvine, Ca

•Created business requirements document outlining the multiple phases of project. Phase I, included the conversion of Access 97 database. Phase II, covered the normalized database and re-architecture of tables.•Converted MS Access 97 database to SQL Server 2008•Normalized database to third normal form•Installed and configured SQL 2008 SSAS, SSIS, and SSRS on development and production severs•Designed and developed data integration packages using SSIS to load data from flat files and Excel spreadsheets into SQL 2008 database.•Created system for capturing and reporting data errors.•Designed Cubes with Star Schema using SSAS. Created several Dashboards and Scorecards with Key Performance Indicators (KPI).•Designed and scheduled SQL jobs to refresh data for SSAS cubes and OLTP database twice daily•Managed and monitored Web site redesign project•Worked with developers on design and implementation of new features

Corona

Data analyst and business intelligence consultant.

Irvine, Ca

• Provided enterprise level oversight to multiple servicing systems• Vendor system implementation, support and reporting• Managed and mentored team of developers and report writers.• Managed and maintained cloud environment for business critical systems and applications.• Enterprise level day to day operations support• Installed and configured SQL 2008 SSIS and SSRS. • Created and implemented SSIS packages to automate ETL processes using Microsoft BIDS 2008.• Technical lead and project manager of corporate data warehouse implementation. Assisting DBA and data analysts with implementing data marts and star schema. • Technical lead and project manager for corporate financial reporting system, developed in SSRS 2008 and ASP .NET MVC 4. System is currently in Production supporting more than 100 concurrent users.• Implemented 3rd party products. Building bridge and data synchronization between existing systems.• Carried out data analysis and management exercises to offer the management with highly critical information • Improved business processes with systematic analysis of data with regard to the organization's historical performances and identification of key areas of improvement• Liaison between internal users and vendors to communicate technical issues and problems.

Anaheim Hills, Ca

• Managed, monitored and coordinated the work assignments of 12 quality personnel for more than 7 ongoing projects to ensure efficient manpower utilization.• Worked on all phases of corporate data warehouse project. Participated in complete system development lifecycle, from gathering requirements to testing, implementation, and support. Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP using SQL 2008 Analysis Services (SSAS). Designed and developed data integration packages using SQL 2008 Integration Services (SSIS) to load data from AS/400 and other servicing applications into SQL 2008 database.• Lead the efforts to redesign and convert existing crystal reports in SQL 2005 reporting services (SSRS). • Supported accounting and HR end-users on Oracle eBusiness11i on a variety of functional areas such as HR benefits, GL, AP, fixed assets, iProcurement, and 1099 vendor/supplier processing.• Served as project coordinator and facilitated operations by serving as essential communication liaison between Corporate Management and Functional Teams on acquisition and merger projects for Retail Bank and Commercial division.• Performed SWOT Analysis on development team and implemented procedures to rectify the issues within the team to offer excellent customer service and on-time delivery of projects.• Project Manager/coordinator for Oracle eBusiness R12 upgrade and migration to AWS cloud.• Served as project manager for database and application server consolidation. Consolidated all physical servers to VMWare Infrastructure virtual machines with shared storage across EMC Clariion.• Managed and coordinated the historical data archive and backup project. Worked with contractors to copy historical data to external NAS and remove EMC to reduce operational and maintenance cost.

Diamond Bar, Ca

• Reengineered existing processes for managing software requirements, created systems models, and developed project documentation suite. • Implemented internationalization and localization strategies for products.• Created project documentation suite, designed logical data model and implemented relational database (SQL, ODBC), developed and implemented internationalization strategies (Visual C++, MFC), and developed and executed test scenarios.• Developed and managed software requirements, conducted site visits, produced prototype designs, developed and executed test scenarios, and launched product to market.• Involved in troubleshooting and assisting junior developers in day-to-day issues and problems reported by clients. Member of Design Team that makes architectural and design decisions for the products.• Worked with BSA on developing requirements. Initiated the use of test plans and technical documentation with development group. Interacted with quality assurance during testing.• Implemented an application that populates PDF forms using the data from database tables and saving the generated forms into database for other applications. The application was developed in C# using ActivePDF Toolkit version 4.0 and Oracle 9i• Worked on industry initiative project of Common Record Common line (CRC) for student loan systems. Designed the application and database architecture. The project is developed using latest technologies C#, PL/SQL, VB6, XML and XSL 1.1. XML features from Oracle 9.2 were used to ease XML data processing

Covina, Ca

• Developed company’s internal portal as well as a portal for customers utilizing Microsoft SharePoint Portal 2003. Developed a prototype for internal executives to show functionality and features of Share Point. • Lead the Extranet Operating Measurements Reporting project. Developed DTS packages with the DBA to transform data into SQL. Designed and developed SQL database, Star schema, and cubes with the DBA using Microsoft SQL Server 2000 and Microsoft Analysis Server 2000. Developed MDX queries to retrieve data from the cubes. Worked with the contractor on application design and architecture using ASP.NET, C#, COM+ and ADO MD 1.0. • Technical lead on the Amazon Replacement project. Interfaced with users and business analyst to gather requirements. Project involved BizTalk Server 2002, SQL Server 2000 and Visual Studio .NET 2002. All AICs were developed using C#. The system was developed to offer ecommerce solutions to different clients. The orders sent by the customers were added to Mainframe using COMTI components and web service. The system is in production, accepting 1,500 orders a day.• Member of the team of 3 programmers to upgrade LERETANET Tax application to Crystal Report 8.5. The application was using Brio 5.0, CGI and Pro C. The upgrade changed front end of the application to JSP and HTML. The data and business layers were developed using Java; JDK 1.1.8. Designed and developed reports in Crystal Report 8.5. The outputs of the reports were produced in PDF. The links were provided on the JSP to pull the PDF report. The system is in production used by approximately 300 customers. • Technical Lead of the team of three programmers on the LERETANET Flood Phase II Ordering and Reporting System. Responsible for upgrading application to the newer release of Weblogic Server 4.5. Identified and performed application enhancements to accommodate server upgrade.

Downey, Ca

• Technical Lead on Automated Time Card System and Automated Travel Process. Worked with a team of three programmers. Coordinated programming and testing tasks with the team. Interfaced with users for requirement analysis, unit testing and system implementation. • Interfaced with operations for implementation plan. Worked closely with operations during the implementation phase. • Trained users on the application(s). • Worked with help desk and technicians during the installation and configuration process. • Assisted technical staff in troubleshooting compatibility problems. Designed, developed and successfully implemented various Accounting and Financial Applications using Visual Basic 4.0/5.0, Power Builder 4.0/5.0 and Oracle 7.3.

Master Of Business Administration - Mba, Information Technology

Bachelor Of Science - Bs, Computer Information System

Activities and Societies: Activities organizer Pakistani Student Association