Constance Rogers Email & Phone Number

San Francisco Bay Area

I help organizations plan, build and deploy Salesforce solutions.

San Francisco Bay Area

As part of a team in charge of attributing products for macys.com, responsibilities include: • Working with users to build new and update existing programs to attribute product data used by ecommerce site for searching, filtering and other user experience elements.• Update DataFlux jobs to retrieve product attribute key-value pairs from Oracle database rather than proprietary SAS Quality Knowledge Base.• Using Oracle 11g, create, update and maintain scripts, stored procedures, and packages used by the programs that attribute products available through macys.com ecommerce site.

135 Main Street, San Francisco, Ca 94104

• Responsible for loading and maintaining enterprise data and for ensuring data integrity. Help to develop standards and best practices to meet data goals.• Design and implement SSIS packages to consolidate and extract data from disparate sources by cleaning, repairing, matching and deduping data.• Design and create complex reports based on user requirements from enterprise and data warehouse sources using SSRS, Tableau and other tools. Perform analysis to maintain data quality and ongoing integrity of delivered reports.• Collaborate with various-functional teams and IT to achieve business results. Assist in maintaining and enhancing data and databases to further business goals and objectives.

• Designed, developed and maintained SQL Server database schemas, stored procedures, functions and other database objects to support applications and reporting.• Developed weekly, monthly and ad hoc reports using SQL Reporting Services, including reports of case statistics and trends for delivery to firm personnel and outside clients.• Developed and enhanced data validation processes including creating exception reports and other consistency checks to improve overall data quality.

• Working mainly with SQL Server, created, maintained and extended existing and new reports from FiberTower databases. Coordinated testing and implemented new code into production database.• Worked with internal customers to review and understand reporting requirements and to extend or create new reports to meet customer expectations.• Groomed, reviewed and imported data from a variety of external sources and identified and resolved conflicting data and ensured integrity of the data and processes.

San Francisco Bay Area

• Maintained database schemas, modified and created databases and database objects and created migration scripts and migrated data and database changes. • Collected, cleansed and loaded data using MS Excel, SQL Server Stored Procedures, DTS and other tools. Built, loaded and enhanced SQL Server tables and databases to support electronic catalogs.• Created, tested and implemented SQL Stored Procedures and triggers to support OpsTechnology’s web-based applications and create queries to provide analysis and scheduled and ad hoc reporting.

San Francisco Bay Area

• Working at Capitol LLC, a litigation support company was responsible loading data into databases and database manipulation, creating and executing queries and for post-processing of legal documents, organizing and analyzing data; and document and data collection.• Working as a self-employed contractor/volunteer at various companies, including volunteer work at Shanti, World Affairs Council and others, provided database support (MS Access, FileMarker Pro, etc.) for data management and analysis, data collection and manipulation, and general user support.

Walnut Creek, Ca

• Designed, coded, tested and implemented a supply-chain, web-based application, as part of a project team, which is estimated to save Safeway nearly $4 million yearly. Used SQL, HTML, JavaScript, Java, JSPs, and other tools to retrieve data from multiple sources and to publish data on internal web pages.• Automated the conversion of data from a chain of retail stores purchased by Safeway into Safeway’s proprietary systems, saving Safeway hundreds of hours of manual data entry; wrote programs to run complex queries and cleanse, manipulate and load data.• Supported Safeway’s marketing programs as the single point of contact for all Safeway divisions; used MS Access and Excel and other tools to generate weekly and monthly reports; checked data integrity, wrote and ran ad hoc queries and created ad hoc reports, posted reports to web and maintained web pages, responded to users’ requests for ad hoc information and data.