Oracle Pl-SQL,Crystal Reports

Tushar Panchal

** **** ****** **., ********, Ontario L6X4W5

Objective:

Seeking challenging assignments to design & develop the state of the art software solutions in demanding and complex business environments.

Profile Highlights:

Senior Software Developer, Technical & Functional Consultant with more than 10 years’ commercial experience producing solutions in a wide range of environments including 4.5 years of financial domain experience.

4+ years of experience in using .Net Platform, Visual Studio 2010/2008, Framework 3.5/3.0/2.0, Win Forms, Windows Services, Web Services, Windows Controls, VB.NET, Visual Basic 6.0, XML, XSLT, XSD.

8+ years of Extensive experience in the System Design & Development on GUI, Intranet, Client-Server, RDBMS like Oracle 10g,9i and SQL Server 2008,2005/2000.

Extensive experience in T-SQL, PL-SQL developing related numerous simple to complex queries involving joins, sub-queries with Views, Stored Procedures, Packages, UDFs, Triggers, Tables, Cursors, DTS Packages.

6+Experienced in Crystal Reports Development and have expert knowledge with Crystal Reports including experience creating linked sub reports, drill down, SQL expressions, advanced formulas, formula driven dynamic layout, parameter prompts, and more using Crystal Reports 8.0,8.5,9.0.

Intermediate expertise using ETL processes to manage and transform data via flat batch files, XML files and data migration scripts.

Drawing on Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions)

Database Development and Analysis: 7 years of experience in Database Development using mainly Oracle database. Experience with Data Cleansing, Data Profiling and Data analysis. UNIX Shell Scripting, SQL and PL/SQL coding.

Database / ETL Performance Tuning: Broad Experience in Database Development including effective use of Database objects, SQL Trace, Explain Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views, Global Temporary tables, Autonomous Transitions, Bulk Binds, Capabilities of using Oracle Built-in Functions.

Data Modeling: 5years of Dimensional Data Modeling experience OLAP, FACT & Dimensions tables, Physical & Logical data modeling, and Data Modeling Tools Visio

6+ years of experience in MS Office 2010/2007/2003 (Word, Excel, Visio) to document functional & technical specifications, to Import/Export Data, to create Pivot Table reports.

Strong troubleshooting, installation and configuration skills.

Professional Experience:

IT Analyst – Tata Consultancy Services – Toronto, Canada, May-2013 - present

"Migration of data from XIP to Multifonds"- Great West Life Information Services Division - Winnipeg, Canada

Responsibilities:

Participate in the creation of program specifications, project meetings, and all design aspects of program, testing and implementing systems.

Wrote simple to complex SQL statements involving joins, correlated sub-queries with Views, Stored Procedures, UDFs, Triggers, and Cursors to

Manipulate and analyze data, interpreting data and information from corresponding transfer of data performed using Ab Initio.

Developed reports to identify rejection/success of data transferred for audit purpose.

Environment: .Net 2010, SQL Server 2008 R2, Oracle 10g, MS Office, Toad, PL / SQL, T-SQL, Windows, Ab Initio.

"Migration of Batch Jobs from Tidal to Autosys & Feeds Migration from FeedHub 2.0 to FeedHub 2.2"- CIBC Application Support Department - Toronto, Canada

Responsibilities:

Responsible for the development and testing of jils on Development Environment, User Acceptance Test and Production implementation.

Responsible for testing migration of feeds from Feed Hub 2.0 to Feed Hub 2.2 Server on Development Environment.

Wrote simple to complex SQL statements involving joins, correlated sub-queries with Views, Stored Procedures, UDFs, Triggers, and Cursors to

Extract details, cleansing, manipulating and analyzing data, interpreting data and information from Tidal masters to aid requirements gathering and solution.

Develop reports to identify owners for migrating feeds and to aid requirements gathering and solution.

Authorized and modified existing shell scripts to work with Autosys scheduler, example script generating Autosys run status reports, loading data to oracle.

Undergone training for Informatica PowerCenter 8.x as part of workflow jobs management.

Environment: Autosys R11 Scheduler, Feed Hub 2.2 File Transfer server, Tidal Scheduler, MS Office, Toad, PL / SQL, Oracle 9i, Windows, Unix.

Software Consultant (Contract) - CIBC – Toronto, Canada, Aug-2012 - Nov-2012

"Migration of Batch Jobs from Tidal to Autosys"- Application Support Department - Toronto, Canada

Responsibilities:

Work as "one team" with Quality Assurance, Systems Support, and other teams.

Responsible for the Database Design & Development, Data Integration.

Wrote simple to complex SQL statements involving joins, correlated sub-queries with Views, Stored Procedures, UDFs, Triggers, and Cursors to

Extract details, cleansing, manipulating and analyzing data, interpreting data and information from Tidal masters corresponding to each functional gap

Determine weighted average complexity based on the complexity categorization methodology

Identify file transfers performed using jobs

Developed reports to identify owners for orphan jobs and to aid requirements gathering and solution.

Enhance existing CIBC built Tidal to Autosys Migration tool.

Environment: MS Office, Toad, PL / SQL, Oracle 9i, Windows.

Senior Software Consultant - DDB Mudra Group - Ahmedabad, India, March-2010 – Jun-2012

Involved in the major project of Human Resource Management System Integration as functional/technical consultant.

Worked as technical consultant for preparing gap analysis, gathering requirements, performing customizations and configuration to suite to the organization.

Responsible for the Implementation, development & technical support.

Responsible for Code Improvement, Code Review, numerous simple to complex SQL queries involving joins, correlated sub-queries with Views, Stored Procedures, UDFs, Triggers, and Cursors, and Bug Fixing of desktop & web applications modules.

Data migration using DTS Packages, SQL Queries, SQL Cursors.

Developed Customized reports within HRMS using Crystal Reports (As per client requirements).

Developed Stored Procedures to integrate modules like Recruitment, Time Sheet management, Salary, Finance and Budget modules.

Responsible for Integration development of Third Party Software.

Maintaining confidentiality with regards to the information being processed stored or accessed.

Worked with regional and/or country representatives to scope requirements, clarify requirements, and test required reports.

Provided regular consultation and technical support to end-users.

Environment: MS Office, Toad, PL / SQL, Oracle 10g,9i, SQL Server 2005,Visual Basic 6.0, VB.Net, Crystal Reports 8.5, Inet Crystal Clear, java 1.6, Linux, Windows

Senior Developer – Cimcon Software, Inc. - Ahmedabad, India, Oct-2007 – Feb-2010

"Enterprise Risk and Compliance Management Solutions" - Spreadsheet Management and Controls

Responsible for the development, technical support & Interaction with QA team.

Responsible for Coding, Code Improvement, Code Review, numerous simple to complex SQL queries involving joins, correlated sub-queries with Views, Stored Procedures, UDFs, Triggers, and Cursors, and Bug Fixing of desktop & web applications modules from Visual Basic 6.0 & .net 3.5.

Developing logics for auditing spreadsheets based on number of formulas, external links, errors, warnings and similar criteria using VBA code to name a few.

Developing logics to collect information regarding excel files across the networks and handling exceptions.

Developed Customized reports using Crystal Reports.

Code version maintenance using Visual SourseSafe.

Active Directory Domain Group user LDAP (Lightweight Directory Access Protocol) has been used to get Logged-In user s Domain Group & its Role Information.

Collaborated on solution architecture and coordinated test cycle runs in intensive testing environment.

Environment: MS Office, Toad, PL / SQL, Oracle 10g,9i, SQL Server 2005, LDAP,Visual Basic 6.0, VB.Net, Crystal Reports 8.5, Windows, Active Directory, IIS 6.0, Visual SourseSafe.

Team Lead - AcTax Solutions - Vadodara, India, Aug-2006 – Sep-2007

"TaxExact Professional Application" - caters Federal and State Income Tax Preparation

Interacted with Project Manager and subject matter experts to develop and document technical specification.

Responsible for the System Analysis, System Design, Database Design & Development, Data Integration and Implementation.

Led development team of 3 developers for Customized development.

Environment: MS Office, T-SQL, SQL Server 2000, Visual Basic 6.0, VB.Net, XML, Windows.

Software Analyst / Developer- Frontline Information Technology - Dubai, UAE, Dec-2005 – May-2006

"Customize ERP ( Horizon EBS)" Responsible for technical consultation, customization & support.

Environment: Report Writer, Dexterity, Modifiers with Visual Basic 6.0, VB.NET, Crystal Reports, SQL Server.

Developed/Customized Reports using Visual Basic 6.0, Crystal Reports & VB.NET.

Provided consultation and technical support to end-users.

Troubleshoots data issues, Installation & Configurations.

Responsible for Database Design and wrote SQL statements with Views, Stored Procedures, UDFs, Triggers, Table, and Indexes.

Data migration using DTS Packages, SQL Queries, SQL Cursors.

IT Executive - Transpek – Silox Industries Limited (TSIL) - Vadodara, India, June-2005 - Dec-2005

"Customize ERP (Manufacturing Industry)" Responsible for technical consultation, customization & support.

Responsible for installation, and database configuration of the system.

Integrated historical data in the system using Integration Manager & Excel.

Responsible for Migration (FoxPro to VB6), Code Improvement, Code Review, numerous simple to complex SQL queries involving joins, correlated sub-queries with Views, Stored Procedures, UDFs, Triggers, and Cursors, and Bug Fixing of ERP (Multi-Company Multi-Location ERP Solution) applications modules from FoxPro to Visual Basic 6.0.

Developed, modules like Inventory, AR, AP, GL using Visual Basic 6.0, SQL Server 2000 & Crystal Reports (developed 300+ reports).

Provide regular functional, technical support to end-users.

Environment: Visual Basic 6.0, SQL Server 2000, Crystal Reports 8.5, Windows

Software Consultant – DDB Mudra Group - Ahmedabad, India, Dec-2002 – May-2005

Involved in the major project of Mudra Branch operations Support System Integration as functional/technical consultant.

Interacted with Project Manager and subject matter experts to develop and document technical specifications.

Responsible for Database Design and wrote SQL statements with Views, Stored Procedures, UDFs, Triggers, Table, and Indexes.

Developed Customized reports using Crystal Reports (developed 500+ reports).

Developed Stored Procedures to integrate modules like Financial and Operations modules.

Provide regular consultation and technical support to end-users.

Environment: MS Office, Toad, PL / SQL, Oracle 10g,9i, Crystal Reports 8.5, Inet Crystal Clear, java 1.6, Linux, Windows

Education & Certifications:

Pursuing Oracle Certified Professional (DBA) for Oracle 11g

Oracle University

.Net Bridging Program

Humber College, Toronto (Canada)

Oracle Certified Associate

Oracle University

B.Sc. in Instrumentation

Maharaja Sayaji Rao University, Vadodara (India)

References available on request

Contact this candidate