Senior Database & Bi Architect
Waltham, Massachusetts, Us
Implemented and designed hundreds of customized databases with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.Implemented the company Data Warehouse to combine all historical and ongoing data. Also designed an Enterprise ETL (extraction, transformation, and loading) system using SSIS (SQL Server Integration Service). Transformation includes standardizing, matching and finding duplicates using standard SSIS fuzzy matching and fuzzy grouping algorithms and also using custom code developed over the years. This includes transferring millions of rows of data to and from heterogeneous data sources ( mySQL, Salesforce, Eloqua, XML files, xls, csv and web posts). This also involved utilizing web services like Salesforce API and Eloqua API using .Net 3.5 scripts within the SSIS packages.Implemented high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering. Extensive experience with Monitor, tune and analyze db performance and allocate server resources to achieve optimum db performance.Performed few migrations of SQL Server 2000 databases to SQL Server 2005. Also SQL Server 2005 to SQL Server 2008 migrations.Customize, manage and maintain the company’s salesforce and also do the same for other clients as a consultant. This includes user administration, view customization, security settings, customer portals, reports, apex triggers, force-to-force, web-to-lead, s-controls, visual force pages and data transfer. Integrate Salesforce with internal applications and other marketing automation applications like ELOQUA.Implmeneted Data management solutions for clients like Microsoft, Adobe, ORACLE, SAP, Novell and Kalido. Most of these solutions build to receive marketing leads from different destinations and perform advanced cleansing, deduping and matching routines against them.