Internal project to convert candidate tracking reporting from Google sheets to Azure SQL database and Power BiWorked with business owners to define the objectives for the project.Analyzed available data and developed a data model for reporting.Migrated existing Power BI reports data source from a Google Sheet extract to Azure SQL database.

Credit and Collections Analyst Monthly reporting automation. Utilized SQL Server and Datawatch software to capture data from mainframe reports. Used Powershell to automate the process to extract and load data into SQL Server database. Created Power Bi Dashboards that were published to Powerbi.com for end users to consume. Assisted in a marketing project to identify the “Next best offer” for customers contacting the call centers for power service.

Reported to senior management with monthly snapshots for the Wireless, U-Verse, and DTV diverse subscribers; the diverse segments, Hispanic, African American, and Asian, were identified using internal data as well as third-party demographic data. Produced monthly analyses of customer activity; this included gross adds, porting information, churn, and penetration rates. Conducted ad hoc reporting for business partners upon request; analysis was performed using SQL to pull data from the Teradata eCDW data warehouse.Provided retail operations group with daily and monthly KPI metrics for company-owned retail and agent store locations; reports were generated using BusinessObjects Universe and created on the OPUS retail point-of-sale system.Utilized Geoscape GIS tool to identify potential Hispanic and Asian intensive traffic locations for company and dealer store locations.

Contract position with ASAP ConsultingProject management. Responsible for technical leadership for enhancements to the OPUS retail point of sale application.

Contract position with ASAP ConsultingManage production support team responsible for daily updates for the corporate reporting data warehouse - Business Inelegance Database (BID). Define work schedules to ensure that all processes will be covered. This team is on call 24x7.Work with end users to define service level agreements (SLA). Communicate to management when SLAs are not met.Assist with determining root cause of failures and ensure that appropriate action is taken to correct errors.Coordinate code migration from development to production. Ensure that code meets standards and is documented. Manage code review sessions with the developers and production support staff when new code is moved into production.Provide daily production reports to management outlining runtimes and issues.

• Interacted with the Marketing Department to gather business requirements, and coordinated efforts with technical design team to develop solutions. Tracked progress by developing timelines with key milestones and deliverables using MS Project.• Managed a staff of software developers designing and implementing a Data Warehouse. Set priorities and communicated expectations. Development was done using Oracle 8i, Sybase 11.9, Syncsort, UNIX shell scripts and Informatica.• Assisted team with the development and debugging of UNIX shell scripts and Oracle P/L SQL code.• Worked with QA group to develop test scripts and resolve data issues.• Assisted Database Administrator (DBA) team with Oracle, Sybase and Redbrick issues.• Responsible for monthly loads, table modifications and multi-load scripts on a Teradata database.

• Managed a group of nine report writers, ensuring that the requirements were documented and clearly understood. Interacted with the user community to document report requirements.• Automated all report delivery using UNIX shell scripts and IQ software job scheduler. Reports were either formatted for MS Excel and emailed to users or posted on a web site. • Member of development team that created a prepaid call system that rated call records real time. Responsible for the development of PL/SQL code and stored procedures that updated the billing system.• Developed several MS Access applications that assisted the Finance Department with posting journal entries.

• Technical liaison between the Marketing Department and IT for the MkIS Data Warehouse.• Responsible for ensuring that data was loaded into the Marketing Data Warehouse in a timely manner.• Assisted the regional marketing departments with extracting and analyzing billing system data from the Warehouse.

• Responsible for Financial reporting systems.• Supervised four programmers, performing reviews and job evaluations.• Developed client server software using Power Builder to offload the cost of mainframe reporting.

• Responsible for installation and implementation of MSA Accounts Payable system.• Worked with end users and outside consultants to establish policies and procedures.• Provided 24 hour on call technical support for Accounts Payable/Fixed Assets applications.• Developed ad hoc reports using EZtrieve for Accounting Department.