Functional Design owner and ETL Solution Developer Resume Basking Ridge, NJ - Hire IT People

SUMMARY:

Enterprising, enthusiastic, dedicated, self - motivated professional with excellent analytical and inter-personnel skills.
Over 12 years of experience with database, Client Server, data warehousing technologies to provide solutions in varied industries.
An eager enthusiast to learn more on data analytics in open source technologies like Python and R.

TECHNICAL SKILLS:

BI Reporting: Tableau 9.2, Oracle Sales AnalyzerOracle ExpressQlikview.

Database: Oracle, MS SQL SERVER.

Query Tools: Toad, SQL Developer.

ETL Tools: Informatica Powercenter, Aptitude ETL tool (Telecom).

Scripting Tools: Python.

Oracle Tools: Oracle Forms Oracle Reports.

OLAP Tools: Microsoft SSAS, MDX Query.

PROFESSIONAL AND INDUSTRY EXPERIENCE:

Confidential, Basking Ridge, NJ

Functional Design owner and ETL Solution Developer

Responsibilities:

Created functional designed documents for the outbound Data processing layer architecture.
Attended 10 days training for learning Aptitude ETL Development tool along with the Aptitude Revenue Recognition Engine training.
Provided solutions to Confidential IT developers on the approach to be taken for developing the solution for outbound data processing layer.
Co-ordinated between numbers of team like Confidential IT team, technical accounting team, Aptitude team which was a 3rd party team which was implementing actual revenue recognition engine solution in Confidential .
Provided development solution in Aptitude ETL to the Confidential IT developers.
Core member of the functional design team.

Environment: Aptitude ETL, Tableau (9.2), Oracle.

Confidential, Philadelphia, PA

Tableau Developer

Responsibilities:

Extensively worked on Tableau reporting tool for building popular reports like X1 Activation and Scorecard for Confidential which is extremely important for day-today use for viewing the activation % across US.
Provided solution to automate reports and come up with a tableau dashboard. The users performed manual task of working in MS-Excel sheet to crunch the inventory reports numbers.
Participated in designing & developing of Inventory Reports.
Performed supporting activities to the Confidential team to resolve reporting errors.
Worked extensively on SSDT, building inventory reports in tableau by extracting data from cubes and MS SQL Server database.
Extensively used ETL tool to consolidate data from nine sources and loading into one single database for further analysis to be done by building Tableau reports for users.

Environment: Tableau (9.2), Microsoft SSAS cube, MS SQL Server.

Confidential, Wayne, PA

Tableau Developer

Responsibilities:

Consolidated 224 forms to just 60 forms for ease of use for business SME’s.
Converted legacy system from Oracle forms older versions to Oracle forms 10G.
Involved in identifying requirements, and handling task assignments

Environment: Oracle Forms 10G, TOAD, SQL Tuning, Oracle PL/SQL, Unix Shell Scripting, Control - M, SAP Crystal Reports.

Confidential, Philadelphia, PA

Tableau Developer

Responsibilities:

Worked Off-shore to develop Oracle backend procedures and packages
Developed more performance enhancing code from PL/SQL procedures
Involved in providing support to the onsite development team at onsite to identify and tackle debugging mechanism of the backend code

Environment: TOAD, SQL Tuning, Oracle PL/SQL.

Confidential

Tableau Developer

Responsibilities:

Build a PL/SQL stored procedure for Stakeholders reports.
The report states about the number of failed and a success count which comes from different pharmacies which will be used by management for further analysis in Tableau.
Worked as a data analyst.
Worked extensively on SQL Tuning for building materialized views.
Constructed Dimensions and Measures for Tableau dashboard.
Extensively used oracle analytical functions.

Environment: Tableau, TOAD, SQL Tuning, Oracle PL/SQL, Informatica Powercenter, Unix Shell Scripting.

Confidential

Tableau Developer

Responsibilities:

Developed code using advanced PL/SQL concepts such as collections, complex queries, procedures, functions and packages.
Performed code reviews and peer testing of the objects before release.
Converted SQR reporting packages to native PL/SQL in Oracle.
Involved in complex Oracle reports design and development.

Environment: TOAD, SQL Tuning, PL/SQL, SQR Reports, Oracle Reports

Confidential

Tableau Developer

Responsibilities:

Core Team Member in application development and maintenance of Order Processing System (OPS)
Worked more closely with users and documented the Functional and Technical specification for the team to understand the requirements more clearly.

Environment: Oracle Forms 10G, Oracle Reports, TOAD, Oracle Discoverer, MS- VISIO Oracle PL/SQL.

We provide IT Staff Augmentation Services!

Functional Design Owner And Etl Solution Developer Resume

Basking Ridge, NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship