Automated Engineering

Microsoft Certified Technology Specialist certification (MCTS) on Database development

SOFTWARE ENGINEER

Responsible for building and maintaining online dashboard for clients includes summarizing millions of record sets. Development SSIS package(s) to move data from client servers and verse versa. Development of processes to streamline database and enhance performance. Build monitoring tools for SQL server maintenance and indexing. Created replication across multiple servers, including MySQL. Creation of store procedures and processes to send alerting to clients. Development of training videos for non-technical users to aid in better comprehension of sales software. Development of processes to assist clients in gaining better understanding of how much they are paying for the cost(s) and presenting better options.

SOLUTIONS ARCHITECT

Successful delivery of the Move Platform to new customers, including managing customer technical engagement through the full delivery process. Engaged with customers and gathered technical requirements directly from customers while assisting product managers in planning and implementation. Lead technical presentations, online webinars, and various other features, benefits, and Travel and interface with customers, establishing relationships at all levels of customer organization. Ensuring data models are aligned with the overall Enterprise Information Management Architecture. Analyzing and profiling large and complex data sets to discover and/or validate data quality issues and business rules. Actively researching philosophical and technological changes in data management and pursuing an understanding of the organization's business plans and strategies. Providing data modeling and other data-related consulting services to less experienced associates.

BUSINESS INTELLIGENCE SPECIALIST

Lead application and technical architecture analysis, design and implementation, and ensure product delivery fulfills user requirements. Assessed system operations to implement solutions for performance optimization. Defined and documented business requirements while providing recommendations solutions. Coordinated with other technical teams to ensure compatibility with other modules and applications. Developed Stored procedures and SQL jobs to fully automate processes and reduced cost. Data analysis on potential source systems including data profiling. Assist the team with the translation of business requirements to system configuration specifications and ensure test plans address traceability to requirements.

SENIOR SOFTWARE ENGINEER / DATABASE DEVELOPER

Reviewed SQL code for security, standards and optimization. Resolution of production Issues and conduct routine maintenance. Performed SQL profiler to debug processes running from Webserver/App. Ran execution plan to determine query optimizations to improve performance. Automated Fusion Chart using Dynamic SQL. Development of store procedures to capture caching information. Creation of store procedures to populated geo data from Bing and Google Map. Partnered with Engineering to design solutions, software patches, and integration methods solve customer issues.

SQL SERVER DEVELOPER/BUSINESS ANALYST

Design and implement complex T-SQL query modifications including stored procedures, functions, triggers, cursers and looping logic. Use SQL Server Integration Services for data extraction from Oracle, web servers and Excel to transfer and load data into SQL Server 2008. Progress through complex logic and translating to well-documented design using Visio. Performed systems analysis and design according to business requirements. Coding enhancements, client-site installations, and technical support for several different business units. Automated web application input for validation testing. Coordination with other team leads and managers for major application changes.