Brian Colety Email & Phone Number

San Francisco, Ca, Us

San Francisco Bay Area

Data Architect for Salesforce data migrations and integrations.

San Francisco Bay Area

Data Architect for Salesforce data migrations and integrations. Skilled in SQL, SOQL, data mapping, Tibco Scribe, and Dataloader

- Tutored 5th grade to high school students in math including middle school math, algebra, geometry, advanced algebra, precalculus, and statistics- Students tutored showed fundamental improvement in their math skills, often moving from failing grades to solid passing grades- Supported students with homework, studying for tests, enrichment activities, and SSAT/SAT/ACT preparation

San Francisco

- Built process to load business intake requests using stored procedures and SQL for validation. New process allowed customer to load 10,000+ new business requests into their intake system and saved countless hours over inputting the requests manually- Mapped client source conflicts data to iManage Conflicts Manage and modified stored procedures to migrate data. Created validation scripts to ensure data quality. Over 2 million records migrated without error- Developed Conflicts report for client using Microsoft SSRS. Stored procedures modified to meet client requirements and reports created to visually format and represent the data

Bay Area

- Provided visibility to Service Request and Defect Trends through generating bi-monthly Hardware and Software Review Slides. Slides presented to VP and used to gauged the product quality and service responsiveness of the many product teams within the organization- Created customer SR reports for Vice President for customer meetings which enabled VP to directly address customer concerns and facilitate future orders- Developed team based reports for product quality and bug backlogs using Oracle Business Intelligence. Team based reports were used by Lead Engineers to quickly see the team backlog trends and any current high priority customer issues that needed attention- Created Tech Review dashboard for Technology leads used to product presentations for VP. Time required to product presentations was reduced by 50% and saved company $20000

Bay Area

- Converted over a million defect records from Sun defect tracking system to Oracle’s defect system over a weekend which resulted in minimal downtime and negligible impact to the business- Performed data mapping and data cleansing activities on Service Request conversion to Oracle’s MyOracleSupport system. Conversion was successfully completed and ensured continuity of service- Served as data model expert for migration planning by performing gap analysis. Presented high level differences between Sun and Oracle’s defect systems to business units- Worked collaboratively with business users and migration teams to ensure successful completion of data conversions

Santa Clara, California, United States

- Performed data administration and data cleansing tasks for business teams- Executed defect system account audit in order to reduce Siebel license fees by 25% by removing users who no longer needed an account- Worked with acquired software teams to identify gaps between source defect systems and Sun’s defect system and assist in data mapping by serving as data model expert

- Ensured on time delivery of project by developing task estimates and accurately managing timelines. - Delivered data accuracy via performing data verification and testing for the migration - Developed and tested conversion scripts used for migration of over 30 million records from legacy application to multiple Siebel environments by employing Siebel’s Enterprise Integration Manager, UNIX shell scripts, PL/SQL scripts, C shell scripts, Perl scripts, and Oracle’s SQL loader - Slashed downtime for conversion by 75% by rewriting conversion process from one time conversion to nightly batch data sync batch process. - Created tables, appropriate indexes, and managed Oracle ETL database used in conversion process

- Trouble-shot a wide variety of OS and application issues on Windows 98, NT 4.0 Workstation, and NT 4.0 Server on desktops, laptops, and servers for 350 employees - Responsible for configuration of all new computer hardware for rapidly growing technology integration firm - Developed and updated Ghost hard drive images for 12 different laptop models - Performed user and group administration, data backups, and share administration for NT 4.0 network - Administered Inter-Tel phone system for 350 employees - Member of infrastructure team responsible for moving computers, data network, and phone system to new office location - Developed training materials and best practices for laptop usage, email policy, and anti-virus policy

Master Of Arts - Ma, Mathematics Education

California Single Subject Credential in Mathematics

Bachelor Of Science - Bs, Mechanical Engineering