SUMMARY:

I have over 17 years of extensive experience as Data Analyst working in close contact with Compliance, Marketing, Finance, Sales, Application Development (web, subscribe, billing) and CCA departments serving as a technical expert performed data evaluation, mapping, quality validation and analysis. Recommended methods to improve performance and quality of products and services, provided Database Architecture and day - to-day business support using Teradata, Hive, Vertica, Oracle, SQL Server, MySql, Access, SQL, Micro Strategy, Cognos 8.4 BI and other database tools.

TECHNICAL SKILLS:

• Expertise in developing applications in Windows
• Teradata
• Micro Strategy
• Talend
• Hadoop 2.0
• Oracle 8i
• 9i
• 10g
• MySql
• SQL Server 2005
• Cognos 8
• SQL
• Access 97-200 7
• Delphi 4-6
• Lotus Notes
• Visual Basic
• Toad
• Crystal Reports 5-10
• Visio
• Visual Source Save
• CVS
• CSV
• MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, Holmdel, NJ

Sr. Data Analyst

Responsibilities:

• Developed advanced SQL queries to identify data anomalies in high -volume subscription/transaction data-intensive based environment. (Hive, Vertica, Teradata, Oracle, Excel, Toad for Data Analysis)
• Conducted advanced data analyses in order to uncover and understand issues facing network operations.
• Performing root-cause analysis of performance and throughput degradation in the network as a result of traffic shifts and new product launches. Assisted with tracking, investigation and resolution of data issues raised from business stakeholders.
• Identified and developed primary metrics of customer experience and performance for mobile applications.
• Research and analysis of key performance indicators, trends, operating metrics, time series and traffic load.
• Analyzed datasets from several different data sources to synchronize data and determine differences between source systems. (Vertica and Teradata) .Developed and converted Verica scripts into Hive and Teradata reports.
• Developed Micro Strategy reports and dashboards in accordance with business needs across various teams.
• Designed Views and developed Micro Strategy Attributes and Metrics.

Confidential, Manhattan, NY

Sr. Data Analyst

Responsibilities:

• Collaborating with technical staff, application development and the Data Owners/Subject Matter Experts from the business to provide functional and non-functional requirement documentation, Gap Analysis and to provide a high level design.
• Migrated datasets from several different data sources (SQL Server, Oracle) into a common schema to perform investigative Data Analysis, Data Profiling (Compared Reference Data from Bloomberg Securities Feed with Actimize / CTI provided Brokers employee traded securities Feeds). Developed reports (SQL Server, Oracle, SQL, Excel) and metrics for data quality evaluation, queries to be used for data migration.
• Prepared Data Mapping, Data Flow diagrams and documentation for vendor to vendor data model migration.
• Migrating financial Oracle AML Hyperion based reports to a Cognos 8 platform. Converted Oracle Views and applied Hyperion based transformations/filters developing SQL scripts. Created “roadmap” documentation for Infrastructure and Cognos administration teams.

Confidential, Brooklyn, NY

Sr. Data Analyst

Responsibilities:

• Conducted Data Governance (DG) including availability, integrity, usability of the data employed in an enterprise.
• Analyzed datasets from several different data sources to synchronize data and determine differences between source systems and SQL Server/ Oracle / Access databases. Developed data feeds, data mapping (data sources) for vendor requests. Collaborated with SMEs from businesses. Assisted QA team writing testing procedures.
• Reverse engineered, developed and migrated an SQL based data collection system originally written for SQL Server (examined SQL code written by somebody else and understood what the intended output should be, wrote Oracle matching Business rules script ) to Oracle data model. Trained ETL developers on ETL design implementation.
• Participated in design and development of complex enterprise-level ODS (SQL Server) and Oracle Data Core database. Created documentation (data dictionary), data flow diagrams and assisted in Data Modeling. Designed Reports (SQL Server, Oracle, SQL, Excel) for internal and external clients.
• Conducted MDM Business Analysis, performed investigative Data Analysis, Data Profiling, Gap Analysis, Data Mining on raw data (SQL Server, Oracle, SQL) including Ad-Hoc analysis and queries for proactive issue resolution.

Confidential, Ft. Monmouth, NJ

Sr. Data Analyst

Responsibilities:

• Liaised with Army and civilian contacts to understand informatics requirements, recommend measures to improve data quality, define technical solutions and partner with other informatics teams to deliver Data Products and technical documentation.
• Conducted Data Analysis on raw data (Access, Oracle, SQL, Toad, Excel) including Ad-Hoc analysis and queries, proactive issue resolution. Performed data migrations (Access 2007, Oracle). Recommended measures to improve the quality of the data processing.
• Analyzed results from several different data sources to synchronize data, determine differences between paired data products and performed data validation, data mining and data cleansing.

Confidential, South Brunswick, NJ

Sr. Data Analyst (Project Lead. / Consultant)

Responsibilities:

• Liaised with marketing contacts within Dow Jones organization to understand informatics requirements, define technical solutions and partner with other informatics teams to deliver projects.
• Conducted Data Analysis on raw and processed data (Oracle, SQL, Toad) for Marketing and Sales and Finance departments including Ad-Hoc reports and queries for business analysis and proactive issue resolution.
• Proofread customer facing reports for visual aesthetics and presentation.
• Performed data migrations (exports) from Access to Oracle using ODBC/Oracle drivers. Customized Ad-Hoc reports, Data Profiling, Data Mapping, validation, recovery, Data Mining and Data Cleansing.
• Developed and enhanced database structures for billing and fulfillment systems for WSJ.com and Barrons.com customer subscribe and account management applications.
• Developed and managed reporting inventory of Data Warehouse Integration system of over 100 data feeds (Oracle, SQL), which gathered information on new sales, marketing campaigns, and customer subscription patterns.

Confidential, Holmdel, NJ

Technical Manager

Responsibilities:

• Conducted MDM solutions including data source identification, data collection, data transformation, normalization, rule administration, error detection and correction, data consolidation, data distribution, schema mapping, data enrichment and data governance.
• Conducted Data Analysis on raw and processed data (Oracle, MySQL, SQL, Toad) for Finance, Marketing and Sales departments.
• Developed and implemented Promotional Rebate validation Retail Commissions Reconciliation system (Oracle, Access, SQL) for internal and third party vendors validation analysis.
• Developed custom Ad-Hoc reports (Oracle, MySQL, SQL, Crystal Reports, Toad, Excel Pivot Tables) and queries for business analysis and proactive issue resolution. Performed data mapping, mining and data cleansing.
• Developed testing procedures for QA team.
• Provided all financial and auditing control reports for SOX compliance.
• Managed reporting inventory of 125 reports that delivered daily, weekly, quarterly and annual reports.
• Developed marketing metrics that gathered information on new sales, campaigns, services and customer usage patterns. Resulted in the redirection of over $75 million in marketing funds into more productive channels.
• Developed reporting framework that standardized all reports within Confidential and reduced maintenance and new development costs by 56%.
• Implemented in-sourcing strategy that replaced costly consultants with Confidential employees for dba and reporting functions, reduced reporting budget by 72%.
• Responsible for new Team building, interviewing and hiring new employees.
• Restructured 600GB database that reduced redundant data and resolved performance issues, this effort resulted in significant performance enhancements and hardware savings.
• Responsible for Business Analysis, Project Management and Development of database related projects.
• Supported Application Development, Sales, Marketing, Finance, Capacity planning and CCA depts. providing data evaluation and analysis, Database Architecture and day-to-day business support.

Confidential, Feasterville, Pennsylvania

Database/Reporting/Application Developer

Responsibilities:

• Developed Order Tracking application that gathered and monitored vendors/customers information and product delivery cycle.
• Developed Inventory Stock application that tracked optical instruments and products using Delphi 5 (GUI, ADO) and Access 2000.

Confidential, West Trenton, NJ

Programmer Analyst / Project Leader

Responsibilities:

• Created and maintained full life-cycle developed applications in Windows 98/NT/2000 environment using Delphi 4-5-6, Oracle 8i, SQL (Stored Procedures) and Access 97-200 0 within a software development group. Applications and reports were developed for high level in-house and client needs in clinical research and healthcare fields.
• Created Pharmaceutical Monitor application, using Delphi 4-5 (GUI, BDE to ADO) and Oracle 8i (SQL, Stored Procedures) that kept track of pharmaceutical industry's corporations, companies and divisions, as well as company's various products.
• Created Business Cards Collector application, using Delphi 5-6 (GUI, ADO) and Oracle 8i (SQL), that gathered sales representatives' information and products they advertise.
• Maintained Oracle 8i and Access 2000 databases through Pharmaceutical Maintenance application created with Delphi 5. Created reports for clients needs.
• Worked in close contact with Market Research department and end users on desktop support, installation and testing of programs.
• Designed Teleforms applications and supervised the full cycle of data evaluation and gathering. Managed a team of four (4) people.

Confidential, East Hanover, NJ

Database Developer

Responsibilities:

• Developed database inventory of Network Servers for Year 2K compliance for quick disaster recovery procedures.
• Developed and implemented change management database for Network Servers and Year 2K compliance, using Access 97 (Forms, Reports, SQL).
• Worked with several languages and databases including Visual Basic 5.0, Visual Basic for Applications, Access 97, Crystal Reports and HTML.

Confidential, Brooklyn, NY

Helpdesk Consultant

Responsibilities:

• Help Desk /Installation of hardware, software, and operating system at the library and other College facilities.