Aileen Mae Lopez

Garden Grove, California ac669j@r.postjobfree.com 818-***-****

PROFILE

An IT professional who can lead a development team and provide directions and resolution for complex application problems to ensure the availability, integrity and performance of the application.

Has 13 years of experience in Microsoft SQL Server, T-SQL, PL/SQL, Business Intelligence (SSIS, SSRS, SSAS) Data Modelling, Operational Data Store and Data Warehouse. Has experience working with large datasets.

Has DevOps exposure and project management experience.

Successfully completed Bachelor of Science in Computer Science from Mapua Institute of Technology in Philippines.

Has a sense of commitment and focus on the priorities to develop solutions in a timely manner.

I am authorized to work in the US and will not need a sponsorship. I am willing to relocate.

WORK EXPERIENCE

Fidelity Information Services (FIS) May 2016 – July 2018

Senior Programmer Analyst

oLed the Data Warehouse team(4 developers) in building Planview Data Warehouse.

oWorked as Data Architect and created the data model for Planview Data Warehouse using Enterprise Architect and Sybase Power Designer.

oServed as Team lead for Philippine Planview Reporting team. Distributes the work amongst the team to best utilize the broad sets of skills they possess. Consolidate communications from the team globally to mitigate the risk of competing priorities or ambiguities.

oAssistant ETL lead for Planview. Created ETL design and SSIS packages to transfer millions of data from Oracle to SQL.

oCreated complex T-SQL scripts and ETL packages for PSA Project to automatically pull data from Oracle and generates csv files for the client.

oCreated new SSRS reports and performance tune of existing SSRS reports for Planview application.

Accenture Inc. September 2015- May 2016

Software Engineering Associate Manager

oData Architect and Development lead for the SQL 2014 Fortification project.

oParticipated in Database High-Availability Solutions for the project.

oHandled the Development team (7 developers and 2 testers). Created the timeline and work plan for agile development to upgrade 500 SSIS packages version 2008 to 2014

oReviewed codes and designs of the SSIS packages with T-SQL scripts to decrease the overall load time.

oCoordinated with global team to ensure proper and on-time implementation of tasks assigned.

oManages ticket assignments using BMC tool.

Accenture Inc. September 2012 – August 2015

Software Engineering Team Lead

oServed as Subject Matter Expert on SSIS, Enterprise ODS and Enterprise Data Warehouse. Worked on several complex issues and served as the Information and Data Architect for the different customers

oServed as Data Governance Lead and handled resources in Buenos Aires and Cebu.

oResponsible for providing technical leadership and resolution of

complex application problems to ensure the availability, integrity and performance.

oProvided architectural leadership to the Enterprise ODS and Enterprise DW, ensuring defined standards and guidelines are enforced.

oReviewed and provided approval to the application team requests.

oProvided data warehousing consulting services to different application teams, who will need to build a reporting solution in the Enterprise ODS and/or Enterprise DW.

oMonitor tickets assigned to the team using BMC.

Accenture Inc. September 2010 – August 2012

Senior Software Engineer

oActed as sub-lead and responsible in performing knowledge transition to several people in our team for several skills.

oInvolved in the analysis and design of the project.

oResponsible for maintaining the global team’s monthly metrics

oActed as Information Architect of different application teams. Reviewed the codes and requests of the clients. Involved in analysis, design and development,

oCreated test scenarios document. Performed component and assembly test

oTroubleshoot and created solutions for the production and staging fixes.

Accenture Inc. November 2007 – August 2010

Software Engineer

oDeveloped technical design and program specifications

oPerformed component and assembly test

oInvolved in the development of the reports and several interfaces

oInvolved in database administration.

oParticipated in data modelling design

oActed as operations support for different applications. Stabilized daily operations and smooth transition with operations support counterparts in Buenos Aires and US.

DataOne Philippines Inc. March 2005 – November 2007

Programmer

oParticipated in data gathering for a monitoring system

oDeveloped design and program specifications

oCreated test scenarios document

oParticipated in the database design and creation

oInvolved in the development of the entire module of the system (such as function for emailing, printing, reports generation.)

oCreated installer and users manual. Involved also in installing the application in the users' machine.

oInvolved in database administration and support phase.

TECHNICAL SKILLS

Microsoft-SQL Server 2014

Microsoft-SQL Server 2012

Microsoft-SQL Server 2008 R2

Microsoft-SQL Server 2005

T-SQL

PL/SQL

Oracle SQL Developer

Enterprise Operational Data Store (Enterprise ODS)

Enterprise Data Warehouse (EDW)

Microsoft Visual Studio 2012,2013,2015

SQL Server Data Tools 2015

Microsoft-SQL Server Integration Services 2010 -2012

Microsoft-SQL Server-Optimization & Tuning

Microsoft Team Foundation Server 2012

Microsoft Team Foundation Server 2010

SQL Server Reporting Services

SQL Server Analysis Services

Enterprise Architect Tool

Sysbase Power Designer

Visual Basic 6

CERTIFICATIONS

Microsoft Certified Professional (MCP)

Microsoft Certified Solutions Associate (MCSA)

EDUCATION

Mapua Institute of Technology

Bachelor of Science in Computer Science (Elective: Oracle) – 2004

Contact this candidate