SUMMARY:

• 10 Years experience working in large - scale data environments
• Expert-level experience in Oracle Database and Extract Transform and Load (ETL)
• Expert-level SQL Development Skills
• Expert-level Tableau Developer
• Expert SSIS, SSAS, SSRS
• Experience with statistical and data analytical principles and best practices
• Oracle Database Administrator
• High experience level with IT Performance Data Analytics and reporting
• Experience with many Open Source tools
• Data mining and quality assessment skills
• Experience with data modeling with tools such as SQL Developer Data Modeler
• Experience with data visualization and tools such as Oracle Apex and Tableau
• IT Infrastructure, Computing, and Big Data Experience
• Good communication and People/Collaboration skills

TECHNICAL SKILLS:

Oracle 11g, 10g, 9i: Oracle Developer 2000; Oracle Forms 6i, 10g. 11g, Oracle SQL*Plus and Report Writer, Oracle Data Modeling, TOAD (7.4, 7.6, 8.0, and 8.5)/ SQL Navigator for Oracle, Designer 2.1, 6I, 9I CASE Tool

Database languages & App. tools: Db3, MS Access, IBM DB2, Oracle Database, Crystal Report, Toad, SQL Navigator, PowerDesigner, ERwin, Oracle DW Builder, Oracle APEX, Oracle Discover, Knowledge of Hadoop, Big data, Netezza, SAS, Expert-level Tableau Developer

Other Programming languages: Pascal, COBOL/Pro COBOL, C/Pro C, Visual Basic (VB)

Internet and Tools: HTML FrontPage, Java Script, Java, Visual Basic Script, Lotus Notes, Internet Information Server IIS

Testing Tools: Advent Net Engine Testing, e-TEST suite Testing Tool

Reporting tool: Crystal Report, Microsoft Access Report, Oracle Report

Operating Systems: DOS 6.22, UNIX Shell scripts, Window 95, 98, 2000, NT, XP, Windows Server, Windows Advanced server Microsoft Access Developer 2.0, 97, 2000, XP, 2000, 2003(Tables, Relationships, Queries, Forms, Reports, Macros, Microsoft Visual Basic 2.0- 6.0

Microsoft Office: WinWord, Excel, Access, PowerPoint, Visio

EXPERIENCE:

Sr Tableau Developer

Confidential

Responsibilities:

• Designing/Build/Integration complex dashboards taking advantage of all tableau functions including data blending, actions, parameters,Filters etc.
• Develop dashboard as ( Executive Dashboard, Retail Sales Performance Dashboard,Pricing Dashboard, Risk management …..etc).
• Troubleshooting and Fix Performance and capacity issue in tableau Server
• Monitoring worker and maintained batch in Tableau server
• Creation of complex BI Visualizations in Worksheets and Dashboards across multiple data sources(DBs, Excel, Hadoop…..Etc)
• Build Solution Plan to increase Performance tuning of workbooks, data sources, and providing best practices for user community. troubleshooting system issues
• Monitoring query and fix troubleshooting .
• Build Complex Query for Table Dashboards from Multiple Resources .
• Develop/Admin will obtain a thorough understanding of the infrastructure and configuration of existing Tableau environments.
• Developer/Admin will lead the design and development of BI solutions using Tableau.
• Development activities will include configuration updates to existing software and/or developing new programs to address a particular business need.
• This includes a feasibility review of the development effort for new requirements, identification of risks, and time estimation of development effort.
• Design, create and extend application layer to manage the CMS data repository
• Informatica / ETL(Extract, Transform, and Load) feeds from multiple sources
• Develop, support and maintain application / database system on backend (Query ) including procedure, function, as well as the front end
• Designing, developing, building, implementation and testing Tableau Dashboard .
• Very Strong SQL skills, including query tuning and data modeling and design

Sr Software Engineer

Confidential

Responsibilities:

• Install and Configuration Tableau admin based on Window Server. troubleshooting, performance tuning, and general systems maintenance
• Create complex formulas and calculations within Tableau to meet the needs of complex business logic
• Setup of sites, projects, group,users,workbooks, views and data sources on Tableau Server .
• Strong SQL skills, including query tuning and data modeling and design
• Create dashboards, data analysis, visualization, report Using apex,
• Develop, Maintain, Test using Oracle SQL, PL-SQL including Program Unit According to Business Analyst and Function Requirements.
• Apex development lifecycle from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment
• Creation of complex BI Visualizations in Worksheets and Dashboards across multiple data sources(DBs, Excel, Hadoop…..Etc) Using Oracle apex
• Design, create and extend application layer to manage the CMS data repository and ETL(Extract, Transform, and Load) feeds from multiple sources
• Develop and calculate Risk Management
• Design, develop and support Performance and Capacity Application Dashboard using APEX
• Design, develop and support complex performance and capacity charts and reports using APEX, Tableau, Business Objects and other tools
• Expertise with data architecture, data interoperability and data analytics using Tableau and SQLs
• Assist Confidential DBAs and Application Developers with Oracle SQL troubleshooting, performance tuning and enhancements
• Identify and validate quality for new CMS input data from multiple sources including HP Operations Manager, Confio Ignite, IBM HMC (Hardware Management Console), VMware, ADDM, and Solarwinds Storage Manager

Sr. Oracle Developer

Confidential

Responsibilities:

• Design, perform data modeling and data structure for relational diagram RDBMS, developing life cycle analysis
• Develop, support, maintain, test and administrate document database and application systems using Oracle 11G/10G
• Support application and database system through trouble shooting, enhancing the data model, fixing defects using Oracle 10G/11G including SQL/PL-SQL, Program Unit (Functions, Procedures, Packages, DB Triggers,..) as well as Oracle 10G/11G (Forms, Report)
• Develop Dashboard on both front and backend Oracle 11G/10G, Oracle 11G/10G PL/SQL also procedure, function, trigger, cursor frontend Oracle 11G/10G (Forms/Report)
• Tableau develop/Reports Dashboard, a trouble shooting, analyst problem solving, data modeling, and fixing defects
• Verify the business rules, functional requirements and aspects for developing scripts and batches according to functional business application and DB rules using Oracle 11G/10G including program unit functions, procedures, packages, and DB triggers as well as coding in the Oracle 11G/10G (Forms/Report)
• Develop, support and maintain application / database system on backend Oracle (Pl/SQL/SQL) including procedure, function, trigger package, and cursor as well as the front end Designing, developing, building, implementation and testing Oracle 10G/11G (Forms/Report)
• Develop, support, maintain, and test Credit Risk, Market Risk, Operational Risk while participating in development and implementation of DB system

Sr. Oracle Developer

Confidential

Responsibilities:

• Analyses, Design, Develop, Support, Maintain and Test Database & Application Systems using Oracle 6I/10G DB and Oracle Developer 6I/10G Suite (Forms, Reports)
• Develop, support, and maintain application / database system on both side backend and frontend Oracle (Pl/SQL/SQL) including (procedure, function, trigger package, cursor). Designing, developing, building, implementing and testing Oracle 6IG/9I forms and reports
• Involved in Oracle 11g database development creating Oracle PL/SQL functions, procedures, triggers and packages
• Develop, maintain and test Oracle codes, scripts, batches according to functional requirements and business application/DB Rules using Oracle 6I/9I including Program Unit (Functions, Procedures, Packages, DB Triggers) as well as Oracle 6I/9I (Forms/Report)
• Support, Maintain and Administer Windows and Network
• Developed Data Conversion tool using SQL, PLSQL and Shell Scripts

Jr. Oracle Developer

Confidential

Responsibilities:

• Developed a new Application/Database systems using Oracle 8i/9i Database and Oracle SQL, PL/SQL, Program Units (i.e. Functions, Procedures, Packages, DB Triggers) as well as Oracle Developer Suite 6i/9i(Forms/Reports)
• Developed, Supported, Maintained, Tested, migrated and integrated the new and old Database system/applications that have been developed Oracle DB 8/8i, Oracle DB 9i and Oracle Developer Suite 2000/6I/9I (forms, report)
• Developing the business rules According to functional requirements - code scripting using Oracle DB, SQL, PL/SQL, Program Unit (Functions, Procedures, Packages, DB Triggers)
• Migrated Oracle database and data/application from Oracle 8i to Oracle 9i backend and from Oracle Developer Suite 2000 (Form/Report) 2.5 to Oracle Developer Suite 6i (Form/Report) 6I and from Oracle Developer Suite 6i (Form/Report) to Oracle 9i Developer 9i Suite (Forms/Report)