Andy Sword Email & Phone Number

Norcross, Ga, Us

Carrollton, Ga, Us

Alpharetta, Ga, Us

Developed an entire dashboard reporting framework centered around utility industry metrics. This included interfaces to client systems, a backend data warehouse and the front end user interface. I personally handled custom implementations and training at client sites. Additional dashboards were created with the Power BI framework which in turn required me to create a custom Power BI map component for use in our offerings. Integration of spatial metrics into our data warehouse for vegetation analysis played a pivotal role in product differentiation. Additionally, I provided legacy software support for a major utility client through various storm outages.

I created a LLC to develop a number of personal software projects to investigate new technologies and keep my skillset up to date.The latest product was an iPhone app that used the phone's accelerometer to map the contours of a golf green. Integrating that with the Unity development environment allowed me render a map of the green in augmented reality and place it over the surface of the green. This would allow a golfer the ability to simulate their putt prior to making it or potentially allowing a broadcast medium the ability to include it in their stream.Another product was an iPhone application that allowed users to record voice messages and have them sent to specified people (or groups of people) at a specific time or at repeated intervals. The backend of the application utilized Microsoft's Azure platform as well as integration with telephony web APIs.One of my first projects was a simple iPhone game based on testing a person's ability to touch type on the iPhone keyboard.Demonstrations of all these software applications can be found at trivialsystems.com

Duluth, Ga, Us

● Client: ConisusAudited and patched a live production system that was encountering numerous technical and design issues. Importance was placed on speed of delivery and understanding prior requirements with little or no background information.● Client: SPANXCreated a production order data mart that interfaced with a larger inventory and tracking data warehouse. Specific responsibilities included design, testing and implementation of ETL as well as integration of data into Excel pivot tables. ● Client: GoodCentsLed a development initiative to migrate customer data from existing databases onto a newer platform. An emphasis on accuracy and data integrity proved critical to ensure that all customer processes were unaffected by the transition. ● Client: Protective InsuranceHelped implement an enterprise data warehouse that assimilated data from over fifteen different data sources using SQL Server Integration Services. Focused on creating packages for migration in addition to writing a framework used to manage configuration settings for the data.● Client: AHCAWorked with a team to create a background check screening application for use nationally in the healthcare industry. Gathering requirements and developing the system for use by several different states dictated a thorough understanding of the overall process and the communication necessary between the various entities.

Worked with a Atlanta police detective to create a website that would train police officers in the correct implementation of investigative procedure. I performed all technical responsibilities including the database design, user interface and reports used throughout the system.

Worked as a product manager, responsible for requirements gathering, design, construction and implementation for various utility focused data warehousing applications including automated metering, work management, energy efficiency and field force management. Technical requirements included web based front end and high level database back end experience. Numerous face to face meetings with customers and project management responsibilities further enhanced my abilities to deliver successful and timely products. Personally supported customers during product implementation and provided additional support thereafter. Guided development and direction of the various products as well as designed them for interoperability. Demonstrated flexibility by managing multiple projects and successfully responding to unplanned work.

Guided the planning and development of a SQL Server 2005 and C# .NET executive level reporting tool that collected and analyzed data from internal and third party systems. Worked directly with customers to create a product plan that guided future development efforts. Managed other junior level developers, acting as both a technical mentor and project manager. Also performed architect and developer roles throughout the project lifecycle. Was chosen to head the Quality Assurance department of the company which entailed managing a staff of twelve testers responsible for five different products. Attention to detail and managing customer expectations led to a higher quality product with fewer defects and an easier implementation process.

Client: Carter’sCoordinated efforts of a four member development team that successfully delivered modifications to an existing marketing system. Was relied upon to communicate with the customer and external vendors, manage client expectations, resolve problems and maintain a project schedule. Client: John Harland CompanyWorked closely with owners of internal systems and outside customers to develop a business interface for exchanging financial transaction data. Testing the application’s functional and non-functional requirements was a critical step to ensuring data integrity and authentication. Helped junior level developers setup and maintain a development methodology to deliver quicker results.Client: MCIWorldcomWorked with a team of software engineers and end-users to develop business requirements, manage customer demands and design and build a large-scale Internet reporting application. Facets of this project included interviewing users, process analysis and design as well as coding.Client: John Harland CompanyHelped develop a mass-marketing application for use by small financial institutions and regional banks. Strong knowledge of object oriented design techniques and low level component creation helped speed completion of work assignments. Client: MCIConstructed a revenue tracking system for use by financial analysts alongside four other developers. System requirements dictated portability and time based reporting views on a multidimensional database. Areas of responsibility included rigorous system testing as well as component design and creation. Client: SouthwireBuilt an in house reporting application for senior level management which inventoried metal related financial quotes.

Client: Coca-ColaProduce an application to process IT personnel information. Exposure to application infrastructure and performance tuning proved invaluable.

Client: Federated Systems GroupDesigned and developed reporting tools that modeled and forecasted seasonal retail expenses.

Client: American President Lines (APL)Used client server technology to transfer, adjust and report mainframe data into a bill of lading system.

Bba

Bachelor Of Business Administration - Bba, Business/Office Automation/Technology/Data Entry