IT Support

Naga Lakshmi Nimishakavi

***********@*****.***

(917) 436 – 9800

Summary

Around 7 years of experience in full life cycle of software development in design, development of Enterprise Data Warehouse development using Talend, Informatica, DataStage.

Strong analytical and conceptual knowledge in database design and development using Oracle 11g/12c, SQL, PL/SQL, Developer/2000 and UNIX Shell Scripting.

Extensive knowledge of business process and functioning of Heath Care, Manufacturing, Mortgage, Financial, Retail and Insurance sectors.

Experience and knowledge in business requirements, functional requirements and technical requirements/specifications.

Experience in multitasking and working at a fast-paced service desk as well.

Working knowledge of Microsoft Office 365 and Active Directory and strong ability to troubleshoot issues.

Experience in building dashboards and maintain project summary reports and all.

Experience in ITSM requests like incidents, request items, change requests and all.

Schedule and coordinate staff and other meetings and update and communicate project status and all.

Committed to continuous improvement and excellent communications. Self-disciplined, focused, solid teamwork and good team player.

Proficient in querying, reporting and analytics tools and have experience with system support.

Define, develop and implement quality assurance practices and procedures, test plans, and other QA assessments for applications and databases.

Experience in programming languages such as SQL, Python, and R for data manipulation and analysis.

Knowledgeable about Highway Safety process.

Experienced with data-support process.

Knowledgeable with generating Vulnerable reports using various security tools, Tableau, Power BI, etc.

Quick learner and ready to take new opportunities.

Excellent analytical, problem-solving skills. Ease of working within a team and independently. Good communication and presentation skills.

Software Skills

Operating Systems : Windows XP/2000/NT, MS DOS, UNIX

MS Office tools : MS Word, MS Excel, MS PowerPoint, MS Access, Smartsheet’s, OneNote, MS Outlook

ETL tools : Informatica Power Center 9.x/8.x, DataStage, Talend

BI Tools : Qlik view, Qlik sense, Tableau, Cognos Report

Database Access Tools : TOAD, SQL*Plus, SQL developer, SQL Server, Peoplesoft, PL/SQL

Programming Languages : C, C++, Python

Documentation : MS Office, Open Office, KTA

Networking : Cisco routers and switches, TCP/IP protocols, BGP, OSPF, EIGRP, LAN and WAN, Wireless networking, etc.

Courses completed

Introduction to Large Language Models

SQL 2016 Tables Certificate

SQL Basics Certificate

Structured Query Language Advanced Certificate

Data Analysis Certificate

Technical Support Fundamentals Certificate

Oracle Database Foundations Certificate

Getting Started in Excel 2016 for Windows

Introduction to SQL Bootcamp

Education

Master’s in computer science from Andhra University, India, passed in 2004

M.S. in Digital Forensics & Cybersecurity from SUNY, Albany, New York, passed in 2026

Research project: Forensic Traces in LLMs, Independent Study in Digital Forensics: Explainable AI for forensics analysis

Experience

Department of Labor, New York State, Albany, New York Oct 2020 - till date

Responsibilities:

Designed and developed ETL data pipelines for multiple data sources to create a centralized data platform.

Assist in producing conceptual documentation describing how the data will be transformed and what new data structures will be populated.

Assist in data analysis and visualization tools such as Tableau, Power BI and Excel.

Created DataStage jobs to copy the files from one environment to another and validate that data transformation is correct.

Assist in UISIM tasks, including column length increase analysis and data refreshes for multiple projects.

Assist in large datasets through data cleaning, preprocessing, and transformation techniques.

Assist in transforming data from SQL Server or Mainframe data sources into the Oracle environment.

Created complex mappings in DataStage and working on sequence jobs and all.

Implemented Stored Procedures and PL/SQL Development and provided UAT Support and Production Support.

Record work in Quality Center/ALM and JIRA.

Responsible for maintaining database security procedures.

Department of Taxation and Finance, Albany, NY Feb 2020 - May 2020

Responsibilities:

Interfaced with other technology teams to extract, transform and load data from a wide variety of data sources using SQL

Develop Stored Procedures in SQL to bring data from on premises

Developed SQL queries/scripts, stored procedures, SQL

Troubleshoot, diagnose and resolve Level 0 and Level 1 incidents

Designed and implemented scalable infrastructure and platform for large amounts of data ingestion, aggregation, integration and analytics

Developed complex Talend ETL jobs to migrate the data from flat files to database. Implemented custom error handling in Talend jobs and worked on different methods of logging. Created ETL/Talend jobs both design and code to process data to target databases.

General Electric, Schenectady, New York October 2019 - Dec 2019

Responsibilities:

Created DDLs for new tables and updated DDLs for existing tables in the target systems.

Created SQL statements and working with relational databases design, SQL and complex queries, views, and stored procedures.

Used Informatica Power Centre 9.1.for extraction, loading and transformation (ETL) of data in DataMart

Participate in the maintenance and support of PeopleSoft and oracle and other tools to facilitate systems integration across applications.

Working on tracking issues and risks, communicate status and all.

Ability to do multitask and work in a fast-paced service desk as well.

Working on requests/incident tickets as well as triage with help desk staff to resolve issues.

Responsible for maintaining database security procedures, application security procedures.

Create and share reference documentation using word/excel/Visio.

Gathering Requirements from respectives, doing gap analysis and then proceeding with development.

Developing several complex mappings in Informatica a variety of Power enter Transformations, Mapping Parameters, Mapping Variables, Mapplets& Parameter files in Mapping Designer using Informatica Power Centre.

Troubleshoot, diagnose and resolve Level 0 and Level 1 incidents

Answering support requests via phone, email or through tickets.

Quick learner and ready to take new opportunities.

Working on SQL, PL/SQL stored procedures, triggers and views using the Oracle RDBMS platform.

Developing programs using People soft ( PSP1 ) database management system and KTA document management system and Smartsheet’s.

Assist with all levels of analysis and incident response.

Assist with all types of documentation including standard operating procedures, incident reports, common email responses, RITM’s, standard change requests, change controls etc.

New York State Information Technology Services, Albany, New York Apr 2018 - Feb 2019

Responsibilities:

Maintains accurate record keeping of all Service requests.

Working on database applications while also utilizing reporting and integration tools and providing design, analytical, troubleshooting and solution development support.

Configuring routers, switches and hub drawings and T1 cutovers and update those in Visio’s.

Troubleshoot, diagnose and resolve Level 0 and Level 1 incidents.

Responsible for maintaining infrastructure, Network security procedures.

Ability to do multitask and work at a fast-paced service desk as well.

Working on Microsoft Office 365 and Active Directory and ServiceNow Ticketing System

Gathering Requirements from respective, doing gap analysis and then proceeding with development.

Querying, reporting and analytics tools and have experience with system support.

Analysis and troubleshoot for network equipment, assist the network and server group with phone support for the installation of network and server components

Participating in meetings and working with management, consultants and IT staff to discuss IT solution options and to assist in recommending appropriate system platforms for meeting program requirements.

Design, coordination and implementation of Cisco devices.

Miranda College of education June 2010 – June 2013

Computer Science and Mathematics Instructor

Responsibilities:

Assist in requirement gathering and design sessions for development of required functionality.

Taught students in using MS Office suite and other software applications for C, C++, Object Oriented Programming, Java Basics, Internet Applications, Networking, Databases, Visual Basic, Microsoft .Net framework, etc.

Ability to do multitask and work at a fast-paced service desk as well.

Knowledge in translating user requirements into technical designs for Application developers.

Troubleshoot, diagnose and resolve Level 0 and Level 1 incidents

Assist in Microsoft Office 365 and Active Directory and strong ability to troubleshoot issues.

Support the application through the testing and implementation phases using SQL/SQL*Plus, TOAD and all.

Develop and maintain web pages based on project criteria.

Attend meetings regularly to discuss day-to-day progress of the project.

Working on the design and structure of databases and maintenance of database systems.

Create test scripts and use cases to support product test activities and all.

Maintaining computers, Operating computers, scanner, printer, copiers, and other software applications.

Coordinated with IT Network Services for all software upgrades/patches and escalated/resolved equipment issues.

Working on creating tables, Indexes, procedures, functions, triggers and all based on requirements.

Working on tracking issues and risks, communicate status and all.

Answering support requests via phone, email or through tickets.

Quick learner and ready to take new opportunities.

Assist with all types of documentation including standard operating procedures, incident reports, common email responses, RITM’s, standard change requests, change controls etc.

Analysis and troubleshoot for network problems and assist the network and server group with phone support.

Contact this candidate