Aileen Mae Lopez
Garden Grove, California email@example.com 818-***-****
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.
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
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
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.
Microsoft-SQL Server 2014
Microsoft-SQL Server 2012
Microsoft-SQL Server 2008 R2
Microsoft-SQL Server 2005
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
Microsoft Certified Professional (MCP)
Microsoft Certified Solutions Associate (MCSA)
Mapua Institute of Technology
Bachelor of Science in Computer Science (Elective: Oracle) – 2004