Krishna. Marella

E-mail: adagnw@r.postjobfree.com Mobile: +1-405-***-****

Summary:

Strong experience in writing Complex SQL queries, stored procedures, User defined functions, Joins and triggers using PL/SQL Programming.

Proficient in Extraction Transformation and Loading (ETL) process by pulling very large volumes of data (VLDB) from various data sources.

Knowledge in creating reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Tableau.

Proficiency in all phases of SDLC life cycle (Requirement analysis, Design, Testing, Implementation, Maintenance & Deployment).

Good knowledge on C#, HTML, CSS, XML, Core Java.

Good knowledge on creating reports with shell scripting using Oracle DB as a data source.

Experience in tuning complex PL/SQL stored procedures, indexes and triggers.

Good understanding of infrastructure and Applications for L2 and L1 support on Production environments.

Experience working on Onsite/Offshore Model, Production Support, Release management, documentation.

Knowledge on frameworks like IBM Struts, Spring, Hibernate etc.

Knowledge about Agile, Scrum & Software Quality Assurance (SQA), Software Testing.

Able to work with a team or individually with excellent communication skills, and ability to meet deadlines in a fast-paced work environment.

Education:

Master of Science Electrical & Computer Engineering.

Cleveland State University- (Ohio) Graduated: Dec 2016.

Bachelor of Technology Electronics and Communication Engineering.

Jawaharlal Nehru Technology University- (India) Graduated: May 2015.

Technical Skills:

Programming Languages:

C, C#, Java, SQL, T-SQL, PL/SQL.

Database:

SQL Server2016, MS Access, Oracle.

Web Technologies:

HTML5, CSS3, Java Script, AJAX,

SOAP UI, XML, JSON.

IDE:

Reporting Tools:

Visual Studio, Eclipse, IBM-RAD.

Tableau Desktop 10.1/9.x / Server, Informatica Power Center.

Frameworks:

ASP.NET, MVC, WCF, Struts 2, Hybris.

Computer Skills:

Photoshop, Microsoft Office.

Operating Systems:

Windows, Linux.

Work Experience:

SQL Developer/ J2ee Developer Nov 17 – Present

Emerald Consulting Group. Akron, Ohio

Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Created reports to customer care rep’s with guest’s data on required orders using PL/SQL using shell scripting for email campaigns.

Responsible for Query optimization and Performance tuning. Fine-tuned the performance of queries, stored procedures, triggers and cursors.

Diagnosed and resolved issues with SIGNET E-commerce websites (Kay, Jared, Kay outlet), databases and back-end order management systems researching Linux server logs.

Supported team members in implementation of software systems and technical documentation in the E-commerce order fixing process.

Built several Standard Operation Procedures (SOP’s) to fix the failed orders due to bad data load issues/ bugs in back end systems using SQL scripts.

Diagnosed issues in JSP web applications and implemented code fixes to resolve them.

Responsible to build complex SQL queries using joins, stored procedures, and user defined functions that team requires for bug fixes and major issues.

Hands on experience on migrating the sensitive production data using Shell scripts.

Developed several Business layer applications such as JavaServerPages, servlets, EJB’s using IBM Rational Application Developer Studio and presentation layer screens using HTML5, XSL, CSS and validations using Java Script.

Extensively used SOAP and REST to access web services to post or get the required information to process the orders.

Resolved bad data issues by procedural analysis, troubleshooting and identification of root cause and fixed them through writing the SQL scripts.

Responsible to broadcast the Daily E-comm Health Monitor report to all other E-commerce teams on various activities our team performed, and the progress made by our team on regular basis by extracting data from various sources.

Used to gather the total number of E-comm orders placed from all the sterling sites, analyzed the order trend on daily basis and published the Graphical Dashboards to all the Business and IT teams.

Involved in ETL code using PL/SQL to meet requirements for Extract, Transformation and Loading of data from source to target data structures.

Developed mappings/sessions using Informatica powercenter 9.6 for data loading.

Involved in building the technical debt log and further made good progress on it by analyzing and building strategies with our development team for the monthly deployments.

Managed day to day order fixing activities to solve the key issues that affects the performance of the order fulfilment process.

Experience in monitoring Infrastructure and Page Performances of the sites as a part of 24/7 On- Call Production Support.

Automated the report generation process through VB Macros and other reporting tools.

Jr. SQL Developer Feb 17 – Oct 17

Tekgence, Inc. Irving, Texas

Involved in creating Stored Procedures, views, tables, constraints for HR database.

Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.

Wrote complex stored procedures to process employee’s requirement and generating required interfaces.

Provided technical guidance and support to end-users by developing documentations required.

Monitor performance and managing parameters to provide fast responses to front-end users considering back-end organization of data.

Tested coding modifications and assisted with application and system testing to minimize errors and downtime.

Database Assistant Aug 16 – Dec 16

Cleveland State University Cleveland, Ohio

Assisted to maintain the Database of the Cleveland State Library by building queries, executing DDL's to create tables, programming Trigger events and updating the Library catalog.

Maintained the security, integrity and availability of SQL Server.

Tuned and Optimized complex SQL Queries and indexes and assigned database access privileges for different users and user groups.

Designed and implemented database maintenance plan and performed optimization and normalization of database.

Have extensive knowledge of network operating systems including Linux, and Windows.

Profound understanding of LAN and WAN management and maintenance protocols.

Involved in setting up accounts and passwords for specific users with authorization to access networks.

Established customized software infrastructures and installed server hardware’s and periodically assisted with help desk operations.

Internship at Nuclear Fuel Complex (NFC) on Micro controller programming and RDBMS database.

Internship at Electronics Corporation of India Ltd. (ECIL) on C language programming and PIR- LDR sensor design.

Contact this candidate