Senior Data Solutions Architect - Enterprise Data Services Team. Lead the enhancement of data capabilities within a modern cloud architecture. Develop data-driven solutions, ensuring they align with enterprise strategy and business objectives. Define common business vocabularies, recommending architectural solutions, and collaborating with cross-functional teams. Drive data best practices to drive innovation with data architecture and cloud technologies.

Design, architecture and solutions implementation for small and medium businesses. Specialization in web application design, 3rd party integration (appointment scheduling, payment processing, e-commerce), AWS cloud, social media and AI solution implementation for hybrid and cloud solutions.

Responsibilities:• Deliver world class instructor-led training to end-user customers and partners on a regular schedule.• Mentor and train internal and external authorized trainers as part of a train the trainer program.• Help shape the ongoing strategy and mission of the AWS training program.• Assist in the development of a formalized Train-the-Trainer program for our Authorized Training Center partners and Contractors.• Assist in developing & maintaining technical training content, lab exercises, presentations, and accompanying materials.• Constantly learn and master the most innovative technologies related to cloud computing using AWS product and services.

Front End Development, AngularJS, NodeJS, TypeScript, PHP, QAT, Automated Testing, AWS Cloud Infrastructure, DynamoDB.

Business Intelligence, Database Design, Development, ETL. Cloud Infrastructure Design, SQL Server, AWS RedShift, AWS Neptune, AWS Step Functions, AWS Lambda, AWS Kinesis, Json, Python.

(Maintain data warehouse, analyze and approve SEC enterprise data model designs, ETL)• Design, Maintain, monitor and troubleshoot the data ware house, ETL processes and data integrity. Analyze database models and design of various SEC applications • Program and implement data load processes in UNIX while following the official SEC SDLC lifecycle• Provide feedback for proper usage of data types, indexes, keys, constraints, triggers, values and naming • Create and maintain data guidelines and standards while following ISO standards• Audit data models periodically against development and staging databases• Conduct research and collect and analyze data to provide analytical advice and decision support• Compare physical models to document, report and resolve any variances.• Designed, audited and implemented logical and physical data models for various databases.• Update SEC Contracting Officer’s Technical Representative on periodic basis on task updates• Work with Oracle, SQL Server, Sybase ASE and Sybase IQ databases to retrieve data for data analysis

(Business Intelligence Data Warehouse for Reports and Dashboards)• Data architecture, design and implementation of the SC DOR Business Intelligence database• Develop schemata for financial, transactional, operational and informational data sets• Design and create tables, views, data marts, indexes, functions, custom functions and stored procedures• Design and implement normalized and de-normalized entity relationship models• Design Business Objects Universes using contexts, alias tables, derived tables complex SQL objects and filters• Create static, drill down, cross tab and ad-hoc Web Intelligence reports• Program custom reports based on freehand SQL involving complex joins and sub queries• Create complex reports with ad-hoc filters, prompts, sorting, ranking, cumulative calculations and sections• Use Query as a Web Service (QAAWS) Business Objects tool for creating dynamics and complex dashboards• Design star and snowflake schema for OLAP cubes • Program triggers, cursors, load/performance testing and maintain data integrity with constraints• Write custom SQL scripts for data extraction, data testing and implementing data checks• Design, test, deploy and monitor ETL/SSIS/DTS processes for data loading and refreshing• Utilize SOAP Web Services( WSDL and XML) and ETL processes to consume and load data• Creation of agency wide operational, performance, trending, analytical and financial dashboards• Develop high profile time critical reports with extensive data checks, notifications and rollback options• Design dynamic SSIS packages with checks and standards in place to prevent and fix data issues promptly• Analyze business requirements, make data decisions and resolve data issues• Data integrity, consistency and unit testing against source files and mainframe systems• SQL Server job scheduling, monitoring, support, troubleshooting and communication for more than 50 jobs

• Supervised and trained a team of 12 student workers for the START program.• Managed the program, monitored student training workshops, administered program advertising, • Conducted training workshops and organized weekly meetings with the trainers and the Program Director• In charge of scheduling workshops, website design, promotional videos and brochures. • Taught Classes on ASP, ASP.net, PHP, Microsoft Access, Adobe Flash, Adobe Dreamweaver, Adobe Photoshop, Adobe Premier, Microsoft Office suite

• Supervised a team of 18 student workers for the maintenance of computer labs. • Responsible for maintaining computer servers and developing database driven web applications. • Re-designed the program’s website, developed multimedia web applications and maintained existing web applications.• Lead and trained student workers in computer hardware maintenance, troubleshooting and networking. • Trained students and faculty members in web designing and multimedia editing. • Utilized ASP, ASP.net, VB.net, Adobe Dreamweaver, Adobe Photoshop, Adobe Premier and SQL Server database technologies.

The project involved development of an online web based educational portal and creation of Multimedia Educational CD’s.• Managed a team of developers for the creation of educational multimedia content. • Envisioned and developed a new process in-house to develop multimedia content that was previously being outsourced. • Trained a team for multimedia development and developed a workflow process for cost estimation, scheduling and project tracking. • Utilized Macromedia Flash, ASP.net, SQL Server and Macromedia Director technologies.

Member of the development team tasked with developing Credit Dimensions – an online credit rating system. The project involved designing a system to rate credit worthiness of entities by using historical data and mathematical algorithms • Designed and developed the front end user interface modules and backend database scheme.• Responsibilities also included testing software modules and making web pages cross-browser compatible. • Re-designed the company’s website, promotional material and newsletters. • Utilized HTML, CSS, ASP, JAVA, JSP, Tomcat Server, IIS Server, SQL Server, Adobe Flash, Adobe Photoshop, Adobe Dreamweaver technologies for this job.