PROFESSIONAL EXPERIENCE
TRONDENT DEVELOPMENT, CORP. Barrington, Illinois
Data Analyst Apr 2014 - present
Responsible for insuring the accuracy of data
collected for internal applications and output to outside vendors as well as analyzing
problems occurring in software applications and suggesting corrective action
for the data management team.
·
Process data integration and uploads via ETL processes on
multiple platforms and from various sources (XML, flat file, Excel).
·
Perform SQL queries to analyze, troubleshoot customer
issues, data conversion and validation issues, ensure data integrity and
availability.
·
Develop and maintain stored procedures, TSQL and SQL
scripts using MS SQL Management Studio to setup synchronization processes
between systems.
·
Develop and maintain Webservices (WSO2, SOAP, XML),
background stored procedures, triggers and constraints.
·
Create ad hoc SQL queries to retrieve and update the MS
SQL Server databases per client requests.
·
Provide support, analyze problems, query databases, review
log files to identify inconsistencies and resolving application issues.
·
Create customize reports using MS SQL Server, TSQL and
Excel and Access.
·
Develop and maintain PHP codes and/or XML files that
connect and synchronize data from 3rd party providers to internal databases
and ultimately other downstream targets.
COMMUNITY SCHOOL DISTRICT 300, Illinois
Sept 2010 - Apr 2014
·
Volunteered as Fundraising Coordinator for Gilberts
Elementary School, Hampshire Middle and Hampshire High School
·
Volunteered as Treasurer for the Hampshire Middle School
Parent Volunteer Committee
·
Volunteered as member of Post Prom committee at Hampshire
High School
MOTOROLA, INC. Illinois
Home & Networks Mobility,
Worldwide Interoperability for Microwave Access (WiMAX) Engineering PMO
Project Manager,
Arlington Heights, IL May 2006 – Feb 2008
Assisted program managers and worked with other team
members, stakeholders in planning, managing and monitoring system change
requests for WiMAX subsystems. Delivered changes requests to System
Test for multiple concurrent releases with overlapped deadlines.
·
Planned, managed and monitored system changes from
requirements through system test and customer documentation.
·
Researched, tracked and monitored all product
enhancements, faults and change requests to ensure they are scheduled and
implemented per plan, identified critical issues and took appropriate
corrective action or escalated to managers. Effectively helped teams resolved
issues which resulted in a reduction of backlogs and closed 75 issues within
two months.
Jennifer VoPage Two
·
Collaborated with key stakeholders and established
automated process improvement system for managing workflow, which replaced
the manual process. New system was fully integrated with CMBP tool for
management of system changes resulted in 70% cycle time reduction.
·
Led in analyzing, resolving shortages and offering low
cost solutions to development teams to meet resource needs for multiple
concurrent projects and releases. Completed yearly forecasts for budget
roll up.
·
Helped achieve staffing needs by analyzing and
recommending a 2:1 trading strategy using outsource and low cost contractors
to optimize resources. Managed headcount to stay within budget.
·
Acted as the liaison and led the outsourcing initiatives
to increase the use of low cost engineering resources, which yielded a 50%
reduction in engineering expenditures.
MOTOROLA,
INC. Illinois
Network Enterprise, iDEN Home
Location Registry (iHLR) Organization
Sr Software Engineer/Database Project Lead, Schaumburg, IL Oct 1998 – May 2006
Led a Database development team to support 5
different components and 3 products for the iHLR Systems in the iDEN
Infrastructures with a vision in delivering high quality products and on-time
projects.
·
Worked with software developers in providing background
stored procedures and database APIs for data access methods needed for their
applications.
·
Tested to optimize the stored procedures,
constraints and triggers to be used in production.
·
Troubleshot and maintained SQL DB API,
stored procedures and SQL scripts per change requests.
·
Created the DB Migration tools to
successfully manage the ETL processes by pulling large volume of data from
various data sources, convert/map the data and load to different
destinations.
·
Used Erwin tool in reverse
engineering. redesigned the database, generated logical and physical models.
·
Read through the legacy C/embedded SQL
Informix programs to find the business rules and processes from legacy
systems. Created Business requirement and Business rules document.
·
Provided on time support and followed through iHLR field
issues. Worked with deployment and development team providing
short-term, long-term solutions and root cause analysis, created customer
write up, and planned patch deployment activities.
·
Participated in entire Software Development Lifecycle
(SDLC) from business requirements through system integration test, deployment
and support to ensure high quality deliveries.
·
Successfully led the team as SME using ETL processes to
migrate and convert the Co-located iHLR systems to Highly
Available (HA) Standalone iHLR systems to meet customer requirements of
increasing performance and system capacity to 6 million subscribers. As
a result, received Bravo and Monetary Awards from Senior Management for a
successful deployment of the DB conversion and migration tools, which
contributed to a phenomenon success of the first release of the HA Standalone
iHLR systems.
·
Developed aggressive goals and schedule to automate the
Load Manager Integration Test environment to support Agile development and
testing of the new Load Manager component for system release 15 resulted in
cycle time reduction and quality improvement. Load Manager Integration Test
yielded a 80% quality improvement.
·
Created schedule using Primavera/MS Project, assigned work
and provided oversight of team assignments.
·
Defined and implemented a DB development process tailored
to real time Embedded Database Systems and created DB naming convention document.
Software Engineer,
Schaumburg, IL May 1994 – Oct 1998
Developed and tested new features, enhancements and
defect repairs for the iDEN Dispatch Application Process (DAP) Database
Management Component.
·
Developed, enhanced and defect repaired for the DAP using
C/Embedded SQL/Informix DB/Informix 4GL/UNIX.
·
Provided testing and support to ensure high quality
deliveries.
·
Re-factored the VLRT codes and optimized SQL queries
to improve the performance of the DB upload utilities during DAP
initialization. Performance was 5x improvement, from 60 minutes to 10
minutes.
·
Configured and installed the new DB engine version for Motorola
internal clients. Performed DB administration tasks.
EDUCATION AND TRAINING
BS,
Computer Science, University of Illinois at Chicago, Chicago, IL
REFERENCES
Available
upon request.