OBJECTIVE:

• I am looking for a career where I can maximize and implement my analytical, management and Interpersonal skills and add value to organisation as well as my work/personal portfolio.

PROFESSIONAL EXPERIENCE:

Confidential

Co - Founder / Programmer

Responsibilities:

• All development work including (back-end, front-end, database architecture and design, server configuration settings, hosting website, iPhone and android app development, Web Analytics, Web Master tools, Search engine optimization and social media presence were performed by myself.

Technologies Used: Combination of following technologies was used in development of Confidential .com; (Java/ J2EE, Struts, Hibernate, MySQL, JQuery, JavaScript, HTML5, JSP, RestFul webservices, Apache TomCat Server, Eclipse)

Confidential

Co-Founder / Programmer

Responsibilities:

• All development work including (back-end, front-end, database architecture and design, server configuration settings, hosting website, iPhone and android app development, Web Analytics, Web Master tools, Search engine optimization and social media presence were performed by myself.

Technologies Used: (Java/ J2EE, Struts, Hibernate, MySQL, JQuery, JavaScript, HTML5, JSP, RestFul webservices, Apache TomCat Server, Eclipse;

Confidential

Data Manager / Application Manager

Responsibilities:

• Extract Load and Transform data from various health data sources using SAS and SQL Server tools to Centre for Health Record Linkage (CHeReL) data warehouse.
• Develop and maintain applications (java/j2EE) to aid in data quality and integrity.
• Work with developers and contractors towards design specification, ER models, technical specifications, product backlog, scrum sprints, development and testing of CHeReL applications such as DMS for data management and PMS (Project Management System).
• Manage projects throughout the life of the project using SCRUM and Agile methodologies for CHeReL application development and enhancement.
• Perform data linkages among various data cohorts based on project requirements.
• Manage and update CHeRel Masterkey data for periodic data updates from various data sources of Confidential and NSW government registries.
• Perform adhoc data linkages to master data.
• Perform Deterministic and probabilistic data linkages.
• Produce data reports using SQL Server Reporting Services (SSRS).
• Perform data integrity checks and cleanse data from anomalies.
• Create and update database objects as per project need and as per best standards.
• Manage data linkage projects from start to finish.
• Manage resources for projects and determine task priorities and timelines.
• Manage team of record linkage officers and assign them record linkage tasks.
• Participate in ISMS (Information Security Management System) meetings and briefings and work towards implementing and incorporating them in CHeReL team.
• Imported/ extracted data from various data health sources and in various formats into CheReL’s databases.
• Performed Data linkage projects by linking data from many data sources using SAS, SQL and Java. Wrote SAS and SQL optimized scripts to perform various checks on data and link data as per project requirements. Wrote java programs to perform various checks on data to check for linkage correctness and data integrity.
• Designed and developed Data Quality System (J2EE - JSP, STRUTS, HIBERNATE) to implement data quality checks and business logic at the end of each linkage project.
• Worked with programmers towards enhancements to Data Management System (DMS) and performed documentation, requirement documents, briefings, product backlog and UAT testing.
• Participated and managed project for the development of workflow management system (WMS) for CHeReL and managed work from contract developers through various phases of project.

Confidential

Analyst Programmer (Contract)

Responsibilities:

• Writing Java programs to compare & analyse data between data sources and destination directories to automate tasks which makes data analysis and resolution process more robust.
• Write Programs using java, j2ee, jsp, javascript and other latest technologies to provide data managing and provisioning applications.
• Ensuring Data quality and integrity for NSW Schools, TAFE and DET Staff data.
• Over see provisioning engines and making sure transaction processing from source system to destination directories is as per business rules and expected.
• Writing optimized SQL queries on ORACLE databases, using oracle TOAD and extract, manipulate, analysis and issues resolution.
• Producing reports for Management, Regional units, Stakeholders and other ITD teams.
• Performing extensive data comparisons between data directories such as Novell eDirectory and Active Directories.
• Writing LDAP queries to extract data and perform operations on data.
• Performing analysis of existing business rules and provisioning procedures and suggest improvements.
• Liaising with other application programmers and advising them on application issues and planning for application improvements.

Confidential

Data Analyst (Contract)

Responsibilities:

• Working with SQL server to generate reports for management and analyse data.
• Performed data cleansing & migration by writing optimized queries to analyse data, find anomalies and resolve data issues.
• Set up stored procedures to perform tasks on data.
• Creating accounts, managing user accounts, resetting passwords and assigning permissions on in-house CIMS software
• Provided weekly, monthly and ad-hoc data reports to management and regional offices.
• Cleaned department’s data from anomalies and duplicate records from various databases and tables.
• Performed data migration of clean data from SQL Server to ORACLE environment.
• Managed department’s staff data.

Confidential

Information Analyst (Contract)

Responsibilities:

• Import Data from various data servers throughout Confidential framework.
• Write complex queries to obtain reports from various tables and data sources.
• Analyse data and prepare various managerial reports using sql, vb and other data management tools.
• Developed some in-house Database solutions using VbA, SQL and Access 2002.
• Analysed procedures and designed optimized solution.
• Set up Point and click reporting options solution.
• Planned, developed and implemented Reporting tool that extracted, analysed data and produced analysed reports from department’s CITRIX and MS-ACCESS databases using SQL and Visual Basic for MS-Access (VBA)
• Analysed large amounts of data and provided reports to management.

Confidential

Technical Support Officer

Responsibilities:

• Providing technical phone support to canon customers on various canon products i.e. digital cameras, scanners, printers, multifunction machines, business calculators, video cameras and business machines.
• Working on Oracle based customer’s database, Windows XP, Lotus Notes and Novell network to perform day to day operations.
• Logging and analysis of customer’s data to provide effective and efficient technical support to canon customers across Asia-pacific region.
• Provided 2nd level support to Canon’s customers for canon devices.
• Produced reports on customer’s data to the management.
• Analysed customer’s data and produced reports.

Confidential

Reporting & Assessment Analyst.

Responsibilities:

• Assessing applications based on provided information.
• Analysing applicant Data.
• Querying and assessing housing queues.
• Querying department's database (IHS) system and preparing weekly arrears, visits and transfer report.
• Preparing Management reports on daily and weekly basis using SQL and Crystal reports.
• Prepared documentation of various business processes for future to DoH employees and management.
• Produced reports for DOH applicants and residents.
• Analysed databases and resolved data issues.
• Set up automated reports for the management.

Confidential

Data Analyst (Contract)

Responsibilities:

• Preparing daily reports.
• Data cleansing and formatting it for managerial tasks.
• Preparing staff news letters and e-mail them.
• Providing phone support to Clients.
• Provided daily, monthly and quarterly reports to the management on staff data, staff leave and entitlements.
• Identified and resolved data anomalies and improved data quality.
• Provided technical support to staff for data related issues.

Confidential

Data Analyst and Admin (Full Time)

Responsibilities:

• Database Analysis and management.
• Report Generation, Market Trend analysis.
• Day to day database operations ( queries, stored procedures, triggers, data cleansing, backups and restore, log checking)
• Development and management of their website.
• Designed database solution and implemented it.
• Provided reports to the management and managed data.
• Provided data quality and cleansed data.
• Provided reports on market trends on real-estate.

Confidential

Database Developer. (Contract)

Responsibilities:

• Analysed business procedures and logics and designed a model for better-improved software solution.
• Developed feasibility and budgeting reports for new system and designed Entity models and process models.
• Converted those models into database solution using SQL server, SQL and visual basic.