PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Database Manager

Responsibilities:

• Maintain the operational audit database, interface with member IT staff to synchronize inventory location databases with the audit database, manage the production of release databases, development of queries and reports, the administration of remote SQL Server databases and in - house SQL Server 2012 databases
• Manage SQL 2008R2/2012/Azure Database development, QA/UAT and production environments
• Create SQL Stored Procedures, Functions, Views, Triggers, Jobs and complex queries.
• Design data warehousing processes by SQL/SSIS code for the definition, development and testing of the processes and programs necessary to extract data from the various data sources
• Develop, modify and maintain monthly and quarterly loading process
• Establish SQL Server standards for design, development and migrations
• Build inventory management system for Geo Analysts
• Provide regular / automated process status to Analyst team and management
• Work closely with Geo Analysts to understand business analysis functions and requirements

Confidential, New York, NY

Programmer Analyst

Responsibilities:

Skills: SQL programming, Informatica PowerCenter, Advanced Excel, Data Analysis

• Designed, developed and maintained of feature and processes for the Insurance Data Warehouse and related source databases with fact and dimensional model (Star schema).
• Worked in collaboration with data architects, developers, and key stakeholders to design robust, scalable database and data extraction processes, transformation and loading solutions.
• Created complex T-SQL Queries, stored procedures, functions and triggers to enhance data processes.
• Identified and analyzed data discrepancies, data quality and data process issues and any procedural improvements required to ensure systems conformance, data consistency and integrity.
• Foresaw downstream implications resulting from changes in business and technical requirements, and data infrastructure.
• Developed, modified and maintained monthly and quarterly loading process by Informatica Power Center and manual excel load using T-SQL 2008R2 as well as SSIS.
• Performed strategic adding/altering database modules in the multiple SQL databases.
• Analyzed and migrated from Excel loader and SQL system to Informatica Power Center and SQL systems.
• Participated in peer reviews of team and stakeholder work, providing feedback and suggestions.
• Reviewed developers' codes and advise to follow the best practice. Created various unit tests of A to Z.
• Developed and debugged procedures to verify logic, data quality and consistency
• Analyzed potential process failures or weaknesses, recommend and create fixes in T-SQL.
• Built SSIS packages to transfer data, database structures and to copy for creating each dev environment.
• Performed complex data aggregation and data validation; analyzed historical data in fact-dimension models for necessary clean-up and clean-up impact, create a cohesive and careful clean-up process in T-SQL
• Analyzed and determined business requirements to prepare individual premium and claims input sources for processing into the data warehouse through SQL scripts.

Confidential,New Jersey

SQL Database Developer

Responsibilities:

Skills: SQL 2008, Advanced Excel, Data Analysis, .Net, Access 2010, Reporting

• Built stored procedures, views, complex queries, Jobs for Actuarial reports
• Created automated and semi-automated reports using a combination of Access and Excel regularly scheduled basis or on demand for management and all departments.
• Created user friendly reports using a combination of Excel and SQL to help streamline the functional operations of the LIG insurance business.
• Analyzed database and found statistical formula for system migration from original system to new system.
• Maintained and enhanced company expense intranet system by ASP.net.
• Developed marketing portal intranet system by Sharepoint 2010 and Access 2010
• Latest data Reports: NY state premium tax report by zip code. California DOI report, Renewal Retention, New Business Growth, Loss Ratio (by Agent, Region, Class, Product, Line, etc), Terrorism Limit, Cancellation Reason, Underwriter Hit Ratio, Incentive plan, Budget Planning, Premium Audit Data, etc.

Confidential . Ontario, California

Web Consultant

Responsibilities:

Skills: T-SQL 2005, ASP, Advanced Excel, Marketing data analysis

• Assisted web developers with database design and modeling (SQL 2005, ASP).
• Created company specific reporting programs using Microsoft Excel.
• Updated records to maintain system performance including products, customers, and special code files.
• Analyzed, planned, and adjusted marketing policy of the company selling-website in various search engine sites, such as Google Adwords, Nextag, Yahoo Campaigns, Microsoft Adcenter, ShopZilla, Shopping.com, to ensure the optimal target-selling effect.
• Designed and maintained of eBay and Amazon product listings.
• Acted as the first technical contact for any query or database issues and assisted developers and users in query requests and enhancements. Provided technical and customer support.
• Provided customer support for any product inquiries.
• Designed automatic shipping label system.
• Prepared technical and functional documentations.