Senior Data Analyst Resume San Diego, CA - Hire IT People

SUMMARY:

Database Architect Lead/ Business Analyst specializing in the design and development of databases, data analysis/retrieval, BI, and web applications.
Expertise constitutes information gathering, business assessment, reporting, logical and physical database modeling/design, application design, and programming. Business skills include requirement analysis and end user Confidential . Exceptional communication skills.

TECHNICAL SKILLS:

Databases: Vertica, Oracle, MySql, Mongo DB, SQL Server, Informix, DB2, Sybase, Access

Languages: SQL, PL/SQL, Transact SQL, ASP, XML, JSON, Server - side JavaScript, Visual Basic, HTML, Java, C, Python, Perl

Operating Systems: Mac OS, XP, Unix, Windows, DOS

Hardware: IBM PC compatibles, Mac

Database Tools: Erwin ERX, DB Visualizer, Pentaho, WinSQL, Data Direct Explorer, TOAD, SQL Plus, Informatica, SQL Worksheet, Data Mart Builder, Query Analyzer, Enterprise Manager (Oracle/SQL Server), Visio, SQL Developer, Talend

Software: Cognos, QlikView, BusinessObjects,Version One, Jira, Rational ClearQuest, Visual Caf, Excel, Access, Popkin System Architect, AXIO, Tableau, Confluence, Docker

TECHNICAL SKILLS:

Confidential, San Diego, CA

Senior Data Analyst

Responsibilities:

Met with clients to gather requirements for onboarding. Profiled initial data loads in Mysql and SQL Server to determine level of cleansing to be needed to have successful SEO functionality. Together with development, API’s and customer input, we constructed data cleansing plans and executed them.
Worked with development to implement client data into the SEO platform and linkage technology. Wrote reports to determine viability of success, created data models, provided the ETL logic in Talend and programing to consume customer data. Helped to digest new data feeds for existing customers using Python and Perl, add custom functionality, run regular reports in Tableau, and publish new web pages for SEO.

Confidential, San Diego, CA

Senior Data Analyst

Responsibilities:

Worked on a professional services team to procure new clients. Examined customer data to provide insight into data cleanup and data standardization. Presented data models in ErWin, data definitions and mappings in Excel, and data profiling analysis using Talend and SQL to aid in piloting in house Auto Quoting software.
After the Cisco acquisition, my role turned to one of data analyst/developer; my responsibilities included data profiling, data analytics, ETL, data governance, data definition, and reporting. Many tools were used and evaluated during our transition including the use of stored procedures, SQL, Talend for profiling and ETL, QlikView and Tableau for reporting, across several data sources accommodating Mongo DB, Oracle, SQL Server, and MySql.

Confidential, San Ramon, CA

Data Architect

Responsibilities:

Successfully completed an enterprise wide data consolidation and reporting project which managed customers, leads, sales, loans, mortgages, branches and their rankings. Created and maintained the logical and physical data model for data marts in Erwin along with overseeing the new requirements and modifications to the EDW. Wrote all the DDL's in Oracle and maintained over 20 schemas across environments.
Held JAD sessions with the business to gather requirements and daily scrum meetings to ensure successful delivery. Completed extensive data profiling and corrected data anomalies via cleanup scripts to establish a solid reporting platform. Working with an architectural team, integrated the project data marts and the EDW to cultivate a companywide homogenous data methodology. Built and preserved data standards across all schemas and environments.
Detailed technical tasks included, complex query writing to identify data discrepancies, source data mining, and reporting logic QA, creating views and stored procedures to access data in different schemas, writing etl jobs to populate sample data and testing scripts to provide accurate requirements to the ETL team.

Confidential, Cupertino, CA

Data Analyst

Responsibilities:

As part of a team, owned all manufacturing and production of unit data. Conducted in depth analysis of yields, fallout rates, fail statistics, part and vendor inquiries, fraud investigation, manufacturing line breakdowns and evaluations for all products at Confidential .
Provided BI reports and analytics, on-going adhoc requests, canned reports and detailed data analysis for both internal and external customers. We wrote scripts, functions, and procedures on SQL Developer with an Oracle backend for each of the different manufacturing sites. Created data loading jobs and ETL procedures in Pentaho. For larger and automated data pulls wrote cron jobs on the backend which would return data outputs directly to clients or would feed Tableau reports.
Worked very closely with Data Quality team, New Product Owners, and Production Confidential to help identify and tweak data structures, clean up dirty data, improve performance, and make adjustments to process to better Confidential customers requiring precise data reports.

Confidential, San Francisco, CA

Data Architect

Responsibilities:

Created the logical and physical data models in Visio for a CMDB project. Met with Cloud Operation business owners to identify and analyze data sources determine a single source of truth, and conventionalize data. Conducted business review meetings to solidify company wide standards.
Created data mapping documents, a data glossary, and data regulations. Wrote ETL requirements and manifested a loaded database in MySql.
Gathered financial forecasting data to create predictive models, automate reporting, and regulate sources.
Reviewed several BI tools to determine a best option and POC for the company. Included were Domo, Tableau, Adaptive Planning, and Piktochart.

Confidential, Palo Alto, CA

Data Analyst

Responsibilities:

Supported a Data Quality program focused on validating an integrated core database consisting of multiple sources to provide analysis, and to Confidential diverse companywide functions - including sales, service and product integrity.
Using several in house applications, developed test scripts for a complex Vertica enterprise data warehouse and identified test data requirements. Coordinated user testing, documented test results, created data quality scorecards, metrics and operational reports. Reported progress of defect resolution. Analyzed quality of data sources feeding the enterprise data warehouse, identified and resolved anomalies amongst systems.

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

Worked for the Wholesale Marketing Department for all communications regarding a Fraud Prevention effort. Conducted in depth meetings with the Fraud Prevention Team to determine audience for effort. Continuously modified target lists based on input and ever changing Company attributes. Successfully sent out over 10k communications over a four month period.
Provided detailed ad hoc reports on current migration statuses, effort progress, and customer attributes. Created and maintained baseline and conversion rate analysis reports. Updated and modified ETL scripts, reporting scripts, and analysis scripts based on a shifting source system.

Confidential, San Diego, CA

Systems Analyst

Responsibilities:

Managed over 20 projects at this engagement; successfully preformed the role of Scrum Master, Project Manager, Business Analyst, Data Architect, Data Modeler, Spec Writer, Quality Assurance, Data Analyst, Informatica ETL writer/manager, Trainer and Presentation Facilitator. These projects spanned several different internal departments including; Defect Resolution for hardware and software (different teams), Engineering, Budgeting, Build Management, Quality Assurance, and Human Resources.
Utilized several different software programs to collect requirements from customers(Jira, VersionOne, In house applications). Facilitated daily scrum meetings with appropriate parties and worked closely with the development teams to ensure specifications were being met with customer approval.
Designed logical and physical data models for transactional databases, data stores, and data warehouses. Created specs, managed production, and helped create jobs to load environments. Worked around the clock with off shore resources to ensure jobs were successfully run and that projected timetables were met.
Created specifications for Dashboards and Reports, and supported development to establish successful outcomes. On several occasions, dashboards and reports were rewritten in different tools based on required and new cutting edge technology (Cognos to BO to QlikView). The outcome was a tremendous aid to directors and business teams for more efficient defect resolution amongst Confidential . Forecasts and system build understanding was greatly improved.

Confidential, San Diego, CA

Data Architect

Responsibilities:

Succeeded in the completion of several key initiatives for the Internet Property Tax System of San Diego County.
Working with a team of architects, created and maintained the logical (Erwin) and physical (Oracle) Data Warehouse Model. Was the sole creator of ETL logic, including the initial loading plan, regular scheduled jobs, and data validation for the DW environment. Transformation and data massaging was conducted in Sql Server 2005.
Headed the transactional database and data warehousing data validation initiatives - Accomplished these tasks by thorough data analysis writing queries against the environments, using profiling tools such as Axio and producing scores of comparative reports.
Acted as the primary point of contact regarding data needs for Quality Assurance. Supported the QA teams in providing test data by means of retrieval, manipulation, and creation for complicated testing scenarios. Taught and tutored QA team in PL/SQL, procedure writing, and data analysis. Served as a SME for several subject areas to the QA team and aided in creating test scripts.
Hired and trained several contractors on the DW team. Aided lead developers in legacy to transactional system conversion mapping and scripting. Worked with third party vendors to in corporate data into DW and the DB through table, trigger, and ETL creation.
Inherited the role of business analyst/technical lead for the reporting team. Conducted extensive interviews with employees from San Diego County for requirements gathering on over 1000 reports. Managed reporting progress and all related project status documents to be given to upper management. Wrote and maintained backend views. Supported developers in understanding business logic to write front end reports (JReports).
Worked with a team of project specialists to secure funding for future development through the successful walkthroughs of key subject areas of the application to county employees. These comprehensive meetings with the county demanded weeks of preparation as true application functionality was to be demonstrated. Application specifications were reviewed and rewritten, data was mocked up and manipulated for presentation, and thorough testing was conducted. After a dozen of these meetings spanning several months, the green light was given.

Confidential, Pleasanton, CA

Business Assessment Analyst

Responsibilities:

Delivered an extensive assessment of the current IT environment and provided a step by step systematic solution to remedy the company’s current maladies.
Conducted thorough interviews with the CEO, CIO, CFO, CTO, and other key VP’s to discuss current world vs. ideal world which led to the basis of the business assessment deliverables. Researched databases, engaged in data analysis (via SQL), reviewed technical documentation, current models, and practices to aid in the technical assessments.
Designed a logical, high level, enterprise data model in Erwin for the future normalized world. Presented in detail; descriptions, definitions, and explanations of relationships and subject areas. Wrote up a formalized evaluation based on a compilation of previously conducted interviews. Delivered a power point final environment assessment describing, in detail the current problems and steps to undergo change for best possible ROI.

Confidential, San Francisco, CA

Data Analyst / ETL Programmer

Responsibilities:

Developed an ETL program to de-duplicate and cleanse customer data for a major system upgrade effort.
Conducted extensive data analysis to locate dirty data - this was done using TOAD against a SQL Server database environment. Researched current systems to identify sources of bad data and determine which processes were correct. Wrote several procedures, triggers, and ad hoc queries to clean data both on a one-time and an on going basis.

Confidential, Walnut Creek, CA

Data Quality BI Analyst

Responsibilities:

Developed new tools, processes, validations, metrics, controls, and analysis to improve Enterprise Data Warehouse mortgage insurance data quality. Conducted trending on data quality metrics and analyzed actual vs. expected results.
Performed research to resolve data anomalies and issues found in the EDW. This included analyzing data in different transaction systems. Identifying and communicating important issues to management, EDW customers and internal resources for discussion & resolution.
As a data quality representative, contributed to the team for each project. Created project documentation and developed expected results based on business rules and specifications to ensure EDW transformation rules are implemented correctly.
Mentored others on data quality topics and metrics, acted as a team leader as needed. Determined and recommended improvements on current standards and implementation of system changes.

Confidential

Data Warehouse Designer/Builder/ETL Programmer

Responsibilities:

Designed and created Data Warehouse for small software solutions firm. The DW managed the distribution and sales of alcoholic beverages, nation wide, for reporting purposes to major manufactures and government agencies.
Worked closely with CEO to define business requirements and reporting needs. Created the logical and physical database design, which was built in SQL Server. Identified data mapping, created staging area, and wrote all ETL scripts and error handling using DTS. Working with software developers created views, summary tables, wrote stored procedures, developed jobs and formulated excellent maintenance routines for ongoing Confidential of data.

Confidential, San Francisco, CA

Data Warehouse Consultant

Responsibilities:

Consulted Confidential on the merging of Geography, Global, Group, Medical Claim, Practitioner, and Product data from several internal and external sources into a third party data warehouse. Reviewed the data warehouse model, data loading processes, and business needs to determine if requirements were technically implemented.
Ensured the reliability of Confidential data to be loaded into 3rd party data warehouse environment. This included attending Data Acquisition and Disposition Documentation reviews held with business to review and ensure data loading process, transformation, and source to target execution.
Aided in the enhancement of current data warehouse model. Reported on areas of potential weakness for maintaining RI and made recommendations for model changes. Helped to create and complete the data dictionary. Analyzed detailed profiling reports to identify faulty source data and critical breeches of data integrity.
Designed an application for ongoing manual file updates to data warehouse. The application included data cleansing, data transformation, error handling, and profiling logic.
Created flow charts to outline application and business processes for Problem/Issue Resolution, Production Confidential, Metrics and Performance, and Change Management.

Confidential, San Francisco, CA

Data Modeler/Architect

Responsibilities:

Designed the Customer Data Model for the tri brand merge of Confidential Inc. online website. Conducted extensive business requirement gathering to ensure architecture supported key corporate goals and needs. Reconciled differences amongst The Confidential, Old Navy, and Banana Republic brand SQL Server databases and created a structure for Oracle, which supported a more manageable, knowledgeable, and flexible customer base.
The model design, data dictionary, standards, and data definitions were created and maintained in Erwin 4.14. Established, through comprehensive data and system evaluation, best means of data transformation from all SQL Server databases into new Oracle environment and created the data projections. With the use of primary and foreign keys for a strong model, intensive data analysis, and documentation of business process, ensured a clean and efficient data load transition.
Worked with team of database architects to design and implement physical schemas across several instances of Oracle databases. Helped to ensure data accuracy across schemas by documenting needs and aiding in the creation of application scripts and database jobs.
Conducted meetings with project managers, team leads, and technical architects to produce load logic and data mappings for data load and transformation amongst scores of corporate applications. Tracked the changes and progress with Excel spreadsheets.

Confidential, Walnut Creek, CA

Data Analyst/Data Warehouse Architect

Responsibilities:

Through the analysis of business process and by defining marketing needs, helped client to kick-start a data warehousing project while supporting current sales inquiries. Interviewed key employees to develop most profitable business questions. Determined if data was reliable and complete for supporting answers through intense data checking and querying. Created reports on data integrity and reliability for management to analyze project needs.
Helped to outline, define, and present business processes using Visio and Power Point. Worked with marketing team to ensure proper business representation. Also provided team with any immediate data analysis/reporting needs on their customers. Developed several routines to measure clients for potential sales and to meet future advertising goals.
Designed a logical data warehouse that implemented both future and current business plans and needs. Created scripts and jobs for data cleanup, massaging, and migration into the data warehouse. Provided reports to discover missing and incomplete data.

Confidential, Palo Alto, CA

Database Architect Lead

Responsibilities:

Designed an enterprise data model in ERwin for The Graduate School of Business at Confidential University. Met with team members and business users to gather database and application requirements. Conducted extensive business analysis to provide a thorough data dictionary, detailed application summarizations, and definitions for the major applications to be supported by the database.
Wrote data loading scripts and jobs to populate the SQL Server database on a nightly basis. Created stored procedures and functions for event driven processes to update tables intraday on a row-by-row basis. Wrote data validation scripts to ensure data accuracy. Sources included Peoplesoft, Oracle, LDAP directories, in house SQL Server Databases, manually entered data, and various Excel spreadsheets.
Created reports and report templates for presenting database definitions, data types, relationships, constraints, and detailed metadata. These reports were used for documentation as well as templates for ongoing of the new database environment. Trained employees in effective database design methods and efficient programming basics. Provided company with design and coding standards to adhere to in future projects.

Confidential, Del Mar, CA

Database Architect Lead

Responsibilities:

Headed the architectural design, development, implementation, and data cleanup efforts for the back end of a 50B trading application. The application generated trades and maintained data for accounts, issuers, securities and the trade orders through their life cycle.
Aided in the creation and maintenance of an enterprise data warehouse in Oracle. Helped to write data migration scripts to and from the data warehouse. Created report templates and SQL scripts to aid in ongoing business analysis. Used DTS jobs to pull aggregated and summarized data from the Oracle data warehouse into SQL Server cubes to be used for the trading application business logic.
Completed extensive requirements gathering with end users and conducted data/business analysis to develop a logical and physical data model for the trading application. Designed a data model to Confidential security control and data access for company applications. Provided a successful strategy for conducting a massive data cleanup effort within several applications. Created data validation scripts to ensure accuracy within firm wide systems going forward. Took part in project coordination efforts and created company standards for database processes and design.
Wrote stored procedures for data migration and application logic in SQL Server. Created/Maintained DTS jobs for the migration of data and to keep data in sync within several applications. Enhanced performance by tracing procedures, modifying them, creating indexes and making appropriate changes to the physical model when necessary. Maintained data integrity with the creation of primary and foreign keys, and the implementation of necessary triggers.

Confidential, Redwood City, CA

Database Architect/Developer

Responsibilities:

Designed database architecture for web based IT Confidential software. Gathered information from managers and developers to implement a normalized flexible database to enforce business requirements requested from customers. Remodeled previous database to enforce data integrity through use of relational constraints, keys, and introduced database standards. Customized database structure and functionality for customer deployment. The new structure was implemented in SQL Server, Oracle, and DB2.
Wrote all database object creation scripts for installation of product. Enhanced performance by creating indexes and used them in writing new and rewriting all old db calls (procedures, functions, and packages). Wrote Data Access API for use within ASP and JavaScript applications. Worked closely with all teams in development to maintain data flow logic, and rectified all database errors. Managed personal database environments for all in house developers and maintained a working Oracle and SS environment for product demos and testing.