Microsoft Office Information Technology

Prakshal Shah

**** **** ***** *****, **** Worth TX 761**-***-*** 0694 ********.*@*****.*** https://www.linkedin.com/in/prakshal-shah-2882a549/

EDUCATION

THAKUR COLLEGE OF ENGINEERING AND TECHNOLOGY, MUMBAI, INDIA SEPTEMBER 2013

Bachelors in Information Technology

Relevant Coursework: GUI and Database Management, Operating systems, Object oriented analysis and design, Middleware and enterprise integration technology, Information technology for Enterprise management, Software engineering, Data warehousing Mining and Business Intelligence, Software project management.

SKILLS

Languages: Oracle PL/SQL, Oracle SQL, Shell script, Core Java

Platforms: Windows, UNIX/Linux

Technology: Oracle 10g, 11g, 12 c, Oracle SQL, HTML, XML, JSP, Javascript, Salesforce.com

Tools: PL/SQL Developer, Oracle SQL Developer, Oracle Forms & Reports Builder, Toad, SQL*Plus, Unix Putty / mPutty, WinSCP, FTP clients, SOAP UI, IBM Cognos PowerPlay, Control M job scheduler, Autosys Batch job scheduler, Eclipse IDE, Informatica Powercenter 9.5.1,APEX Data Loader, SDLC, Agile (Rally), BMC Remedy;

Microsoft Office: Excel, Visio, Access

EXPERIENCE AND PROJECTS

ACCENTURE L.L.P APPLICATION DEVELOPMENT SENIOR ANALYST NOV 2013 – PRESENT

NOVARTIS FEB 2016 – PRESENT

Generation of different Database Objects - Materialized Views, Synonyms and Sequences, Cursors, PL/SQL procedures, packages.

Transforming data from core to target systems using ETL over pentaho and Informatica Powercenter.

Optimizing queries, Performance Tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints.

Extracting complex queries from Cognos BI reporting and back tracking to root cause through DB objects.

Partitioning large Tables using range partition technique.

Pumping data from flat files into database tables using oracle utilities like SQL*Loader and control files.

Automating data loads using SQL*Loaders and batch scripts for manual loads, enhancing 100% efficiency.

Salesforce data integration with exposure to Apex data loader for bulk upsert operations.

Performing FTP, SCP using SSH protocols and generating shell scripts to automate loads.

Tracing back to Database objects from a JSP, Javascript web source code, shell scripts.

Understanding and exposure of EDI services and interface.

Delivering fixes for Production Support Issues and Intermediate defect fixes in PL/SQL code.

Collaborating directly with the Business Team On-Site to minimize gap in functional requirements, and leading a team offshore.

Executing user requests from DB stand point, providing root cause analysis, quick work around solutions for P1 situations.

Enhancing, maintaining and updating Database.

Incident management, problem management, change management and adhering to defined SLAs.

DEXMEDIA DEC 2013 – FEB 2016

Performed DBA activities like granting and revoking privileges on database objects, creating synonyms and database links.

Devised SQL loader control files for bulk loads.

Upgraded processes using shell scripts to reduce 80% time/efforts utilization.

Worked on SQL over UNIX/LINUX platform with understanding of UNIX commands, Vi editor, shell scripts.

Built and executed dynamic SQL using Execute Immediate.

Analyzed shell scripts, back tracking them to corresponding tables/procedures/functions in DB.

Implemented UNIX shell scripts to invoke and execute Oracle PL/SQL and ETL code based on requirement.

Exposure to Oracle Forms and reports builder, Cognos BI reporting platform at the business layer.

Addressed L2/L3 support from database standpoint, analyzed data issues/code issues and offered data fixes.

Headed applications as primary and supported them with no onshore support.

PROFILE SUMMARY

Proficient in Data warehousing, Data Analysis, Reporting, ETL – multi-TB size.

Application manager of a Data warehousing application which supports 400 users.

Chaired, trained, mentored analysts, and successfully oversaw offshore team from onshore.

Achieved 95% customer satisfaction by automating data loads for every BI Cognos Cube build.

Optimized client satisfaction by providing onsite demos and trainings in deliverables and database systems.

Excellent analytical, debugging, documentation, verbal and communication skills with ability to work individually as well as in a team.

A strategic thinker, detail-oriented energetic team player, motivated with multi-tasking capabilities, with client/customer relation skills.

A quick learner to new concepts, applications & also flexible to learn new technologies in database paradigm.

ACTIVITIES

Accenture Recognition Awards: Awarded by Managing Director of Accenture – September 2016.

2 years of Social Service in National Service Scheme.

Event Head for CSI-TCET Chapter – Event: Throttle up.

Contact this candidate