SUMMARY:

Comprehensive background designing and developing data and visualization solutions from proof of concept to development and deployment in the telecommunications, governmental, and technology industries. Leverage understanding of the software development life cycle and methodologies, as well as strong collaboration and communication skills, to act as the primary interface between the non - technical community and management, ensuring high-quality project delivery.

AREAS OF EXPERTISE:

Database Design and Programming (PL/SQL, TSQL) | System Analysis | Data Analysis |Data Architecture | Data Integration | Test Case Development Training & Mentoring | ETL Development | Tier3-Application Support Dashboards (Tableau) Reporting (Jaspersoft, Cognos)

TECHNICAL EXPERTISE:

Languages: SQL, PL/SQL, SQL, Hive, Pig, TSQL

Platforms: Unix, Linux, Windows

Databases: Oracle, SQL Server, MySQL, Microsoft Access

Tools: Control M, Tableau, Alteryx, SSIS, Oracle Report Builder, SQL Loader

Other Skills: Unix shell scripting, ETL, Data Analysis, Data Extraction and Data Correlation

PROFESSIONAL EXPERIENCE:

Confidential

Technology Architect/Developer

Responsibilities:

• Served as an Architect and a Developer in the Technology Strategy Team designing and developing data and visualization solutions from proof of concept to development and deployments.
• Alleviated service performance and assurance pain points by architecting High Quality Address consolidation solution, including vendor selection, concept solutioning, creating architect documentation, and designing and developing software application and major functionalities.
• Used Alteryx ETL Workflow solution to source Oracle Database, PL/SQL packages, SQL and used the tool for data parsing, blending and migration to HDFS
• Built database solution within few months for major fiber optic build for selected Canadian communities, enabling better planning for tactical groups and resulting in being recognized by CEO with the Champion of Broadband Leadership Award. Used a combination of Oracle SQL, PL/SQL procedures/packages, ETL - PL/SQL scripts, Configured Alteryx for ETL activities and configured Control M jobs.
• Worked on a Tableau/Jaspersoft POC which included Deployments, Configurations (data access to Netezza, HDFS and Oracle), Kerberos configurations, Dashboard development. Developed JS Reports for the business teams.
• Acted as Governance Architect for Big Data Hadoop Team by participating in vendor discussions, sandbox evaluations, developer and operations training, preparing data cataloguing, liaising between user community and Hadoop administrators and managing pilot deployments, user on-boarding, user access, and meta-data management. Written Hive SQL coding for data migration.

Environment: Hadoop, Hortonworks, Oracle, PL/SQL, SQL Loader, Tableau, BMC Control M, TOAD, UNIX, Shell scripts, Aria, Cognos, Jaspersoft, Alteryx, Knime, Scoop, Hive, Pig.

Confidential

Consultant - Application Developer / DBA / Support

Responsibilities:

• Created Control M batch jobs to consolidate service qualification data extract for multiple teams. Enhanced Oracle PL/SQL code to migrate legacy network devices to converged edge devices.
• Streamlined service qualification process by building and configuring Control M batch jobs, providing more accurate view of customer qualification process.
• Developed Service Qualification scripts using PL/SQL programming, Bulk Collects, Collections and also generated export scripts, developed shell scripts and cron jobs for daily export to various stakeholders.

Environment: Oracle AS 10g, Oracle Workflow, Oracle 9.x, 10.g, PL/SQL, SQL Loader, TOAD v9.x, J2EE, Control M, JSF, MDB, Eclipse, Clear case, UNIX.

Confidential

Consultant - Application Developer

Responsibilities:

• Developed a web portal to manage the change management system (CMS).
• Performed data extract from DB2 importing to Oracle using external tables, jobs, clean-up scripts, PL/SQL, and shell scripts.
• Built change management web toolkit to manage system changes and enable system management by the development team, helping track all system changes and updates, and generating status reports to senior management.
• Created PL/SQL packages to satisfy the change management requirements
• Developed end user data layers for business analysis teams using Oracle DW Applications, improving analysis speed and efficiency for team.

Environment: Oracle AS 10g, FORMS & REPORTS 10g, Oracle 9.x, 10.g, PLSQL-pages, PL/SQL, Oracle SQL Developer, XML Query, SQL Loader, XML DB, Oracle Discoverer, Discoverer Desktop.

Confidential

Consultant - Application Developer Analyst

Responsibilities:

• Reviewed business requirements and participated in discussions with Assessment Review Board members.
• Configured end user layer and business work area for property assessments complaints management system using Oracle Discoverer.
• Developed end user data layers for property assessment teams using Oracle DW Applications, helping teams produce faster and efficient property assessment analysis.
• Mentored and trained end users and developer in creating drill down reports and troubleshooting, resulting in efficient application support.

Confidential

Consultant - Developer / DBA / Support

Responsibilities:

• Managed end-to-end implementation of 4 projects across TV Provisioning and Activation and projects related to Network Topology / Inventory.
• Focused on developing activation layer for TELUSTV ordering system, middleware, and network access systems.
• Planned and redesigned TV activation workflow system using Oracle application solutions,
• Significantly reducing customer on-boarding.
• Developed Oracle Solutions (PL/SQL, SQL Loader, External Tables, Shell scripting) to migrate customers from legacy middleware platform, providing stable platform and efficient TV service with more features. Parsed Oracle XML Query and used Oracle XML functions to retrieve data.
• Provided Application support (Tier3) workflow systems and provided expert level troubleshooting. Part of the issue and triage resolution team.

Confidential

Consultant - Data Analyst

Responsibilities:

• Consolidated various data sources to Oracle systems to help with the application growth and sustainment.
• Utilized SQL Server Integration Services (SSIS) DTS packages to move data from various data sources to Oracle.
• Created reports using SQL Reporting Service leveraging migrated databases.
• Developed, monitored, and deployed SSIS packages for data uploading of multiple data sources as part of data migration.
• Designed and implemented Reporting Services reports, leveraging capabilities like parameterized, drill down, ad hoc and sub-reports, enabling efficient decision making for analysts to decide on managing affordable housing occupancy.

Environment: Oracle 10g, PL/SQL, SQL Loader, Data Pump, TOAD v8.0+, Visual Studio 2005 (Analysis, Integration and Reporting), .NET, WebLogic, SQL Server 2005, Visual Source Safe.

Confidential

Consultant - Data Analyst

Responsibilities:

• Managed Re engineering of the Decision Support Environment to enable Data Warehousing.
• System Analysis, discussions and estimates in co-ordination with the Business Analysts.
• Modified existing PL/SQL Packages to comply with the new business model include Quick Tax, QuickBooks, and Will Expert. Overhauling legacy accounting systems including AP and AR data migration.
• Simulated a Production Environment-Test Bed in Oracle 10g to test historic data conversion.
• Leveraging Oracle Bulk feature to handle large data performance issues.
• Configured Report Server parameters and Setup of Report queues and job scheduling using Queue Manager.
• Created SQL Server DTS packages (Purchase, Sales, Revenue, and Trial Balance) which extract data from Great Plains. Also used SQL Server EM, Query Analyzer.

Environment: Linux (Debian-2.6.7), Oracle 10g, PL/SQL,SQL Loader, CYGWIN, CRONTAB, Oracle AS 10g (Portal & Reports Builder), TOAD v8.0, Great Plains, Crystal Reports 8.0, SQL Server2000

Confidential

Consultant - Oracle Developer

Responsibilities:

• I was given the responsibility to develop an online tool for the CRM users to process the Distribution and Transmission data.

Environment: Siebel 2000 V6.3, Oracle 8i,9i, SQL, PL/SQL, TOAD v7.6

Confidential

System Analyst/ Developer

Responsibilities:

• System Analysis, discussions and estimates and co-ordinating with the clients.
• Developed front end screens (in all ERP Modules) are Designed and Developed using Developer Forms 4. 5 and Reports 2.5 for the business activities.
• Modified existing system and reengineered to fit manufacturing and production requirements.
• Responsible for training the end users.

Environment: Oracle Server 8i on Sun Solaris and WinNT .The Client machines are Windows NT workstation version 4.x. Oracle Developer (Forms 4.5 & Reports 2.5), Utilities includes Enterprise Manager, TOAD & SQL* LAB to administer the Databases.