Post Job Free

Resume

Sign in

Data Conversion Analyst

Location:
Naples, FL
Salary:
90000
Posted:
February 26, 2018

Contact this candidate

Resume:

Sreejaya B. Godfrey (Olga)

ac4mf3@r.postjobfree.com * (239) 571- 4555

PROFILE

Proven history of Sales, Management, Information Technology knowledge and result-oriented Marketing strategies. Excellent business development and financial management skills that result in optimization of both national and international clients and team experience both in the Unites States and Overseas.

SUMMARY OF QUAIFICATIONS

23+ years of sales, business operation experience including export, international client relationship, auction houses, warehousing, packing, budgets, reporting, and project management.

21+ years of Information Technology industry experience

Proficient in Windows & Macintosh Platforms: Applications including PowerPoint, Excel, SQL, Business Intelligence, SharePoint, PeopleSoft

WORK EXPERIENCE

SBG Consulting May 2013 -Present

Independent IT Consultant

Analyzed user workflow, user requirements, wrote system specifications, enhance current applications in use by clients to reduce costs & increase efficiency

Designed new application and supervised contracted programmer work, deployed new applications

Developed, implemented, maintained web-based software programs and SSRS reports

Created and maintained documentation for system functionality and end user workflow procedures

Wrote system and procedural documentation and provided end user training and support

Documented guidelines for system uses, end user training and support as needed on all software enhancement and modification updates and projects

Wrote proposals for project, generated business leads

Analyzed county data and created client specific Florida property database, for solicitation, marketing list for sales and lead generation, prepared reports on current market trends

Designed brochure for mailing, created portfolio with investment information for international clients

Installed SQL server, software applications and configured third party cloud backup environment as needed

Applied Media Technologies Corporation June 2011 – February 2013

Project Lead / Sr. Database Developer/Application Systems Administrator

Manage the project and supervised a team of 5 programmers, 1 DBA and a network admin.

Re-design a new system and data structure for sale, service and management of devices for music and messaging for Businesses

SQL Server 2005-2008: Scrub, Import data from the old system and CRM to the new. Created new databases and table with keys, indexes and constraint

Create Ad-hoc reports for Sales manager, Creative services and Accounting

Applications used: SQL 2005 - 2008, MS Project, Visio, Team Foundation Server (TFS), Reporting Services (SSRS)

eMason, Inc. August 2010 – May 2011

Database Administrator

Lead DBA for Client FNMA & backup for STI, GreenTree, Bank of America

SQL Server 2005-2008: Created new databases and table with keys, indexes and constraint.

Automated BPO data, Mortgage data, Client Invoicing files related raw (Excel, Text, XML) files, to be imported into the system using SQL Server SSIS packages with Stored Procedures as well as re-architect other existing data import packages for efficiency

Monitoring and debugged database server performance using SQL Server Profiler for complex stored procedures and codes response issues

Wrote client specific and generic SQL scripts to scrub personal client related data from the UAT, QA and Dev databases

Created and deployed Service Pack using Visual Studio and Team Foundation Server (TFS) for Production

Debugged and enhanced Developers stored procedures for more efficient use of system resources.

Created Ad-Hoc Reports for client requests and database server performance

Used RED GATE tools to do database compare, scripting, documented processes for user reference

Trained and implemented AGILE software development on the Scrum methodology

Hillsborough County Sheriff's Office April 2008 – July 2010 Project Lead/Application Systems Administrator

Project Lead for the CourtNotify, web based subpoena management systems which changed the process of the agency (HCSO) witnesses receiving paper subpoena through process servers to electronic notification within hours of case being schedule by the different courts. The application also helps in time tracking of Court appearance, to maximize agency performance

Created detail Project Plans with timelines of different phases and maintained aggressive deadline from Beta testing to Production rollout

Coordinated inter-agency meetings with Public Defenders Office (PDO) and Tampa Police Department (TPD) to make this project a success

Trained 1500+ deputies and HCSO employees to use CourtNotify and acknowledge electronic notification

Analyzed end user requirements and worked with vendor to modify the product to meet the Agency specification and requirements

Test the rollouts by vendor for bugs; update end users with new enhancements and specific of utilizing it

Monitoring database server for Health and Tuning for performance using SolarWinds

Made SSIS packages to routine updates and relate info back and forth between agencies, Extracted the subpoena related records from inter-agency data share

Debug code in Visual Studio as well as SQL Server Profiler for complex stored procedures

Provide management ad-hoc Reports, using SQL Queries and exporting the reports to Excel

Maintain and modify existing SQL Server 2005 and MS-Access Databases dependent on external vendor Application

Saving updated codes, Stored Procedures, SSIS packages in Visual SourceSafe and SourceGear Vault

Maintained PeopleSoft- HR/Payroll system, implemented SharePoint server, created library, users with profile and rights

Mortgage Data Resources, INC August 2006 – March 2008

IT / Database Analyst

Created Project Plans (MS Project 2007) and developer specs (MS Visio) for system redesign

Initiated JAD sessions with end users and management to enhance the existing system to its optimum

Designed and maintained Reports in SQL Reporting Services (2005) with Charts

Developed AD-HOC Model based on Production Data for management

Migrated Visual Studio 2005 project to VS 2008(.net 3.5)

Developed ETL (Extract, Transform & Load) process to SQL 2005 from .CSV and .XSL to update Server tables

Wrote Triggers and Stored Procedures to validate the data and business rules. The process updates tables hourly and email user on successful update

Migrated the Access 2003 database to SQL 2005; which involves making new tables, views, stored procedures, normalizing the tables and setting relationships

Made new SSIS packages for daily updates and Backup tables

Merging both ASP and ASPX environment. New development in Visual Studio 2005- 2008(C# & VB.net), to enhance the existing web application, which involves creating Webpages, Custom web controls. Phase-wise transition of Classic ASP pages developed in Code Charge Studio (2) to ASP.Net 2.0 -3.5

Setup Security groups and issue user Rights in SQL Server 2005

Debugging and maintaining the existing system, troubleshooting end-user’s issues

Education & Certifications

Bachelor's Degree, double majors Information Systems & Business Management, Eckerd College May 2000

EDI (Electronic Data Exchange) Certification, ECRC, Largo December 1999

AGILE software development on the Scrum methodology February 2011

Oracle Certification, Advance PL/SQL Oracle Education, Oracle University, Tampa March 2001

Advance Diploma in Software Technology & Systems Management, NIIT, Guwahati, Assam, India July 1997

State Certified Real Estate Sales Associate, SL3230523 January 2010

TRC (Transnational Referral Certification) Certification, Pinellas Realtor Organization September 2014

ILHM (Institute of Luxury Home Marketing) Certification, Pinellas Realtor Organization February 2015

Mike Ferry Sales System Trained November 2013

Languages

English, Hindi, Assamese, Bengali

Personal Interests

I enjoy travelling, nature photography, gardening and creating art. Spending quality time with my boys and husband. I unwind by cooking, learning and sharing global cuisines. Additionally, I am an active member of TIE Tampa Bay and SOIKOT, the Indian/American groups in Tampa Bay, past Vice -President of Belleair Garden Club (2015-2016)



Contact this candidate