SUMMARY

• Min 15+ year IT experience including experience building and optimizing ‘big data’ data pipelines, architectures and data sets.
• Experience migrating on - based offerings such as Amazon's AWS.
• Working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and find opportunities for improvement.
• Strong analytic skills related to working with unstructured datasets.
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• Responsible for handling customers to better understand their requirements, problems, queries and troubleshooting and solving those problems.
• Experience in SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services), PL-SQL and Crystal reports.
• Assisted in creating jobs, alerts and schedules SSIS packages using SQL agent.
• Involved in importing data from various source systems into Microsoft Excel using ODBC and ADO VBA programming.
• Analyzes, designs and implements computer-based information systems to include electronic email, telecommunications, filing.
• Expertise in handling, management of clients, analyzing situations and recommending plans and programs for improvement.
• Possess excellent time and work management skills, superior communication, presentation, analytical and problem-solving skills.
• Always proactive to check on Error/jobs monitoring to zero on potential issues and take necessary action to avoid outage.
• Excellent analytical and communication skills, team Player, hardworking and a fast learner.
• Received employee recognition award for Outstanding Customer Maintenance.

TECHNICAL SKILLS

Operating Systems: Windows 95, 98, NT, 2000, RTOS, MS-DOS

Languages & Tools: Microsoft Office, C, C++, Java, Visual Basic, Oracle, COBOL, Python

RDBMS: FoxPro, MS Access2000, Microsoft SQL SERVER 2000/05/08/12 , PL-SQL

Web Technologies: HTML, CSS, ASP.NET, VB.NET, Classic ASP, VB Scripts, WEB SERVICES, Apache Airflow

Scrum: Jira/ Confluence

Distributed Storage: Redshift, SQL DW, S3,NO SQL and SAP Interactive IQ

PROFESSIONAL EXPERIENCE

Lead Application Programmer Analyst

Responsibilities:

• Learn and maintain in-depth knowledge of all aspects of database products and clients.
• Provide technical expertise to operations with process and client recommendations
• Pursue, guide, and lead product development to ensure on-going competitive edge
• Be proactive in staying current and knowledgeable of industry needs.
• Integrate database products within various other product lines.
• Act as a communication liaison between IT and Client Services
• Train client services staff on database issues.
• Keep documentation current.
• Formulate SQL Queries to debug the root cause.
• Monitoring Daily Queues, Software testing, monitoring Scheduled tasks, Research, analyze, Resolution of user Tickets using isupport.

Confidential, Connecticut

Data base Administrator (Project Consultant)

Responsibilities:

• Oversees the performance, integrity and security of Greenwich Public Schools educational Database and services.
• Handles GPS digital learning environment by creating enrollment and rostering files, and/or automated file exchanges for elementary and middle school DLE products.
• Responds to user id and password inquiries and resets from K-12 staff, students, and parents.
• Performs duties associated with beings the district Google account administrator for all K-12 students.
• Handles maintenance and integrity of GPS Student Information System and all associated exports, including state required reporting (PSIS).
• Oversees public student information system (CT state database) including student registrations, deletions to registrations, changes, and syncing PSIS with Aspen.
• Supports teaching and learning, including student information system, learning management systems and district online teaching tools and products.

Confidential

Application/Associate Consultant

Responsibilities:

• Provided Multiple systems offered dedicated support in Month End closing process and Electronic Statement of Account, e-SOA generated for all the members of clubs every month.
• Interacted with development team to determine the release of maintenance releases and emergency patches.
• Performed Database Physical Design, Database upgrades & related activities such as Database Backup, Restore Operations, Troubleshooting Issues, Performance Tuning, monitoring error logs.
• Responsible for creating SQL Agent Jobs to push data from POS outlet to Server.
• Updated membership subscription files, applying payments and making necessary changes, additions and deletions.
• Performed installment billing, auto renewal, donation processing and running customer online reports.

Confidential

Data Administrator

Responsibilities:

• Created and maintained the Microsoft Small Business Server system updating the company Web, assigning faxes using and report to the management.
• Uploaded items to the company web ensuring Data consistency.
• Troubleshoot basic Network problems, Router configuration, Mail Box clean up.
• Simple Programming using Excel Control Box Buttons, V Look ups in Excel, maintain their Data base of Stock/Inventory list, Refreshing handling Macro Security Issues.
• Data Migration from their existing system to the new system.
• Perform extensive customer communication. Oversee servicing of a range of equipment including but not limited to workstations, servers & networks.
• Provide customer training on all company supported applications.