Enterprise Application Analyst Resume San Diego, CA - Hire IT People

SUMMARY:

Software professional having 7 years of experience in Database Technologies like Oracle, SQL server, ETL, Reporting and Confidential .

TECHNICAL SKILLS:

Database, ETL: Oracle PL/SQL, SQL server, SSIS, Confidential ETL, Mongo DB.

Reporting Tools: Oracle Forms and Reports, Tableau, Power BI, SSRS, YSR report.

Programming: Visual Basic 6, Python, HTML, CSS

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

Enterprise Application Analyst

Responsibilities:

Single point of technical contact for business to analyze issues, requirements, specification using Database technologies.
Creating in - house SQL, SSRS reports and custom SQL queries to debug issues to save $250K annually.
Perform ETL operations in system to save around 40 hours of manual work every week.
Configure, test and implement modules, plugins, user, menus following change management for SOX compliance.
Setting up Task scheduler and report scheduler within the application to automate number of processes.
Migrated data from Alchemy file server to Microsoft SharePoint.

Confidential

Technical Analyst, Santa Barbara, CA

Responsibilities:

Worked with 14 clients to fix technical, performance issues with Confidential products using Oracle PL/SQL and SQL Server.
Develop and test reports, to extract business critical insights using technologies like SSRS, YSR, SQL report etc.
Executed data and report conversion projects to convert client data to Confidential Voyager using ETL during client implementation
Resolved technical cases / Customization Requests - which involve fixing data, core functionality and reports.
Improved performance of slow reports and screens by 40% using Kibana, Grafana and SQL tuning.

Confidential

Software Developer

Responsibilities:

Migrated Application from Oracle 10g to 11g platform which was followed by configuring Weblogic application server.
Designed, developed, tested and customized changes in the PLSQL Stored Procedure, Forms and Reports.
Achieved about 20% time and memory optimization of SQL, PLSQL tuning, using TKPROF, Explain plan.
Automation of data driven systems.
Also debug diagnosis and correcting bugs in SQL code.
Awarded by Larsen &Toubro’s - “Achiever of the Month”.

Confidential

Intern

Responsibilities:

Automated the testing process of Pressure Transmitter calibration thereby using Visual Basic 6(Visual Studio), SQL, and Hardware Protocols to interact with device drivers.