Business Intelligence Developer Resume ,Â Parsippany, NJ - Hire IT People

SUMMARY:

Over 10 years of database programming and administration experience, with emphasis on Microsoft SQLServer design and development, Business Intelligence Development, Data Warehouse Development, SQLServer Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server AnalysisServices (SSAS). Experience developing high - priority database projects and managing databaseprogrammers and end users.
Able to communicate effectively with customers and management.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Business Intelligence Developer

Confidential, Parsippany, NJ

Responsibilities:

Developed a series of SSRS reports for finance department, including an IFRS Balance Sheet and IFRS Income Statement, Statutory Balance Sheet and Statutory Income Statement, and Reconciliation reports.
Developed SSIS processes to control and balance finance department's money transfer transactions
Developed SSRS collateral and reinsurance reports sourced to the Sapiens business platform

Database Contractor

Confidential, Philadelphia, PA

Responsibilities:

SSIS data matching of marketing lists against Dunn and Bradstreet database Data deduplication and cleansing using SSIS ETL extracts from Dunn and Bradstreet database for market segmentations SSAS cube development for industry, company size and geography analysis

Business Intelligence Developer and Data Architect

Confidential, Philadelphia, PA

Responsibilities:

Built a multidimensional campaign data warehouse using SSIS and SSAS, dispositioning all accounts inall campaigns targeted during a 7 year period. Dimensions included Time, Client, Industry, Product,Multi - level Geography, Call Metrics, and Staffing Hours. Automated daily, weekly, monthly and annual production and profitability reports using SSIS and SSRS.
Built and maintained a 4.1 million record SQL Server international account marketing database using C# and SSIS that was used for list acquisitions, database inserts/updates, and market segmentations.
Conceived, developed and implemented a data mining and analysis project that scored accounts incompany's marketing database based on an account's probability to buy.

Database Administrator/Developer

Confidential, Philadelphia, PA

Responsibilities:

Developed financial reporting TSQL Stored Procedures and SSRS Reports used by Finance Team. Built staffing program using SSIS and SSRS to automate account executive campaign assignments.
Automated the routing of company sales leads to clients based on geography and lead type.
Built account executive productivity report to evaluate bonus and performance metrics.
Executed Oracle Siebel CRM and SQL Server imports and updates.
EIM programming on Siebel CRM foraccount and contact inserts and merges.
Automated SSIS lookups and account and contact data - matching and deduplication.
Performednumerous high-priority ETL projects for clients.

Database Consultant - Contract Work

Confidential, Philadelphia, PA

Responsibilities:

Database Imports and mass updates of CRM system Excel reporting, macros and VBA Populated and managed source data and for hundreds of ongoing marketing campaigns