SUMMARY:

• Information Technology professional with 18 years of experience in strategizing and implementing data management applications in multiple industries including financial service, media/publishing, pharmaceutical, Enterprise Mobility, Insurance, Manufacturing, E - commerce and Tele-communication. My expertise has been in consulting engagement and full-time role involving development of data platform across Data Warehouse, Data Mart, ETL, Analytics and reporting. My core strength is in Data Modeling, Data Quality, Data Integration, Master Data Management, Data Governance, etc. My specialty is in
• ERWin, MS SQL Server technologies, Oracle, OBI, Talend DI & MDM, Business Object, Tableau, QlikView. Specialties: Application Design, Development, Integration and Support, Data Warehouse Design, Development and Support, Reporting Solution Design, Development and Support, Management of Application, Data Warehouse and Reporting teams, and Business Intelligence Development.

TECHNICAL SKILLS:

Operation Data Store (ODS): SQL Server 2008 R, 2000, 7, 6.5 and Oracle 10g, 9i, 8i

Data Warehouse Methodology: Ralph Kimball, Bill Inmon, Star Schema, Snowflake Schema

Data Governance: MS Master Data Service (MDM), Data Recycle Plan (DRP), Data Federation.

Data Warehouse Tool: SQL Server 20008, 2005, 2000, 7, 6.5 and Oracle 10g, 9i, 8i

Database Systems: Oracle 10g, 9i, 8i, SQL Server 2008, 2005, 2k, 7, MS Access 2007, FoxPro, DB2.

Database Languages: PL/SQL, Transact SQL, Access SQL, MySQL

Database Tools: SQL Query Analyzer, SQL Compare, TOAD, SQL Plus, Stored Procedure, UDF, BCP

Data Modeling Tool: Erwin ModelMart 7.2, Erwin Process Modeler 7.2, Microsoft Visio.NET, MS SQL Diagram

Data Analysis Tool: MS SQL Server 2008/2005 Analysis Service (SSAS), MDX, MS Excel 2010 Pivot

Master Data Management: IBM InfoShere, Microsoft Data Service (MDS) 2.0

ETL Tool: SQL Server 2008/2005 Integration Service (SSIS), SQL Server 200 DTS, SQL Server 2000 BCP Utility.

Reporting Methodology: OLAP, OLTP, QBE, Cube, OBIEE

Report Writers: MS Reporting Service, QlikView, SpotFire, Tablue, Business Object

Intranet Site: Microsoft Sharepoint, Custom Departmental Site, Web Application Interface site.

Operating Systems: Windows Server 2003, Windows XP, Win 2000, Win NT, Vax VMS, AS400 iSeries.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Data Architect

Responsibilities:

• Upgraded Master Data Management system from Talend MDM version 5.1.2 to 5.3.1
• Managed Application development and support through vendor to provide accurate and timely delivery of Companies and Customer Mastering
• Managed an ETL Re-engineering project for EDM processes to replace an existing Vendor based technologies with In-house technologies stacks.
• Assisted in hiring Technical resources to build an Enterprise Data team as part of Corporate Technology group
• Delivered Key Performance Indicator (KPI) Metrics to Finance and Comptroller using the EDM system
• Re-designed the system platform to establish sole Staging layer to achieve scalability and performance of ETL processes using SQL Server, SSIS, .NET etc.
• Worked with Off-shore development team on a daily basis to manage on-going projects and tasks
• Co-ordinated with multiple business groups to automate customer Opt Out process globally across all application and Enterprise Data Mart.
• Participated in Vendor selection process to replace existing Spot Fire reports with self-service BI tool such as QlikView, Tableau.
• Established an automated process vertically across EDM layers (ETL, Stage, MDM, Warehouse and Mart) to ensure optimal data quality in reports delivered.
• Initiated a process to establish Data Governance across the organization to maintain information quality across EDM, CRM, CMS, Conference and Campaign Management systems.
• Replaced OpenSource based technologies with Microsoft product suites within Enterprise Data Management system.

Confidential, New York, NY

Senior Data Architect

Responsibilities:

• Performed an assessment of Recruiting Metrics Data Mart for the largest Hedge Fund manager to improve analytics
• Developed ETL process in SSIS to feed baseline data from ORACLE 11g Warehouse to SQL Mart to generate metrics utilizing PL/SQL.
• Assessed current state with gap analysis of MDM and Information Architecture and provided a future state with recommendation

Confidential, Commack, NY

Lead Data Systems Analyst

Responsibilities:

• Designed a Data Migration solution from eRed and ProMat systems to BI Data Warehouse and ProRed system using ORACLE 11g, PL/SQL and T.O.A.D.
• Managed projects to deliver requested functions by various Marketing groups and external Marketing agencies
• Developed reporting process for Document Management Systems and Work flow management solution.

Confidential, New York, NY

Senior Data Architect/Strategist

Responsibilities:

• Assessed current SDLC process at client and provided GAP analysis, impact and Recommendation
• Developed a road map to address the issues through new SDLC policy and procedure
• Assessed current Disaster Recovery Plan (DRP) at client and provided GAP analysis, impact and Recommendation
• Developed a road map to address the issues by revising the existing DRP/BC plan.
• Performed and IT Staffing requirement Analysis for CIO to structure his strategy
• Assessed the current Enterprise Data Architecture at Confidential as per Chief Data Officer.
• Created Physical Data Model in ERWin and forward engineered to DDL to implement in ORACLE 11g database
• Reviewed strategic projects for alignment with Enterprise Data Architecture (EDA) guidelines.

Confidential, New York, NY

Sr. ETL/DW Architect

Responsibilities:

• Designed IPM analytics Data Warehouse consisting of over 20 sources and integrated ETL applications with Microsoft products.
• Developed an end-to-end ETL process using ORACLE Data Loader to move data from sources to Data Warehouse having Ralph Kimball star schema
• Created Project plan to enhance an existing OBIEE reporting solution to deliver new analytics for Equity group
• Optimized and fine-tuned ETL and PL/SQL procedures to meet strict time-line for mandatory OBI reporting.
• Provided 24/7 technical support to Data Warehouse, ETL and reporting to support Business Intelligence domain.

Confidential, New York, NY

Senior BI/ETL Architect

Responsibilities:

• Re-designed architecture for Vantage Data sourcing and integration platform for Asset management, Alternate Investment, Investment banking and Private Equity line of business.
• Developed new Data Model using ERWIN ModelMart for Data Extraction, Transformation and Load to be integrated with Data Warehouse in SQL Server 2008 R2, Sharepoint sites and other source systems and application.
• Provided creative solution to Data integration challenges, User Interface design, End-User reporting and Database administration.
• Created functional and technical documentations on vantage data integration and reporting platform
• Reviewed a DW physical data model (PDM) to enhance performance on ORACLE EXADATA server.

Confidential, New York, NY

Sr. Data Waraehouse Administrator

Responsibilities:

• Developed, documented and maintained physical and logical data model in ERWIN 7.2 to hold Ad. Sales data in Star schema
• Documented Enterprise RASCO Data Warehouse in Ralph paradigm currently in the process of development in SQL Server 2008 R2.
• Reviewed existing ETL process build in PL/SQL and ORACLE loader for efficiency, performance and recommendation.
• Developed Technical Data Documents to perform data mapping from source systems to Cube analytical reports.
• Updated already existing documentation on Extract and ETL process for linear systems such as Eclipse, Novar, etc.
• Performed maintenance and optimization of Data Warehouse, Data Marts and Databases build in SQL Server 2008

Confidential, New York, NY

Lead Data Analyst

Responsibilities:

• Analyzed enterprise and application logic and physical data models using ERWIN of an ODS leveraging a Data Warehouse.
• Developed a high performance transactional database in SQL Server 2005 and 2008.
• Designed an ETL process in SSIS to upload mobile data to Data Warehouse in SQL Server 2009/2005
• Created a reporting platform in SSRS providing business analytics to management team.
• Deliver analytics report using Google Analytics and custom reports built-in SSRS and SQL Server databases.

Confidential, Ronkonkoma, NY

Senior DBA/Architect

Responsibilities:

• Developed Data retention plan for ecommerce application suite supporting an ODS mart for direct response group.
• Upgraded eCommerce application’s Data Model from SQL Server 2000 to SQL Server 2008.
• Converted data from flat files (TXT, CSV, XML, SOAP and fixed width) into normalized Database in SQL Server 2008.
• Developed ETL process using SQL Server 2008 Integration Services (SSIS) to populate Warehouse Data Model.
• Integrated current SQL Server ecommerce platform with AS400 DB2 mainframe to provide enterprise solution.
• Upgraded a Data Warehouse Model using ERWIN from SQL Server 2005 to SQL Server 2008 to a STAR schema.
• Migrated Business Intelligence platform to MS Reporting Service (SSRS) 2008, OLAP in SSAS cube using MDX.
• Migrated billing and customer data from AS400 system to SQL Server 2008 databases using strategy.
• Recreated an existing SQL Server 2000 ODS repository with SQL Server 2008 version to support technology upgrade.

Confidential, Lyndhurst, NJ

Sr. Data Architect

Responsibilities:

• Supported and applied data standardization policies for an ODS, Enterprise Data Warehouse, reporting platform.
• Replaced an ORACLE 10g ODS mart with SQL Server 2008 based Ralph DW from the scratch to align with EDW rollout.
• Converted data from flat files (TXT, CSV, XML and fixed width) into normalized Database in SQL Server 2008.
• Built Reporting Cube with SSA, MDX, SSRS and SQL Server 2008 data warehouse.
• Created Logical and Physical Data Model using ERWIN ModelMart and MS Visio based on a ORACLE 10g data warehouse
• Developed ETL process in and PL/SQL Integration Services (SSIS) to populate Warehouse DATA MODEL.
• Designed Data Model in SQL Server 2008 database to leverage eligibility information in Crystal Reports 10.
• Upgraded SQL Server 2005 Database to SQL Server 2008 using script, Stored Procedure, UDF and export/import and SSIS.

Confidential, New York, NY

Senior Business Intelligence Architect

Responsibilities:

• Coordinated across global organizations as required to support data integration efforts to populate a clinical reporting ODS.
• Designed a Data Model for the End-to-End Procurement Application for New York City Contract Service Agency to be developed in SQL Server 2005 database.
• Developed a Data Quality Management process from EDC front-end to CRD Data Warehouse for Clinical Management system using VB.NET 2005 and SQL Server 2005 for Confidential & Co.
• Managed a Data Warehouse team of developers, analyst and engineers and coordinated with client middle management team.
• Designed ETL process in SSIS to populate an ERP Data Warehouse built in ORACLE 10g to support mandatory FDA reporting.
• Developed a Master Data Architecture (MDA) to track Clinical Study management and reporting.
• Converted DTS to SSIS to import vendor information from VendorSource into E2E DATA WAREHOUSE to BAM Reports.
• Created Logical and Physical Data Process using ERWIN Process Modeler and MS Visio to implement with PL/SQL.

Confidential, New York, NY

Manager of Business Intelligence

Responsibilities:

• Provided creative solution to handle faster querying of historical data facing internal ODS, Data Warehouse and BI team.
• Built a team of four to meet ever-growing reporting needs from Marketing, Advertising, Finance, Sales and Service Center in six months.
• Managed a reporting team of four to deliver statistical reports to marketing, advertising, financial, mobile content and service center group.
• Automated a manual reporting process to deliver accurate statistics to Marketing and Advertising timely with Crystal Enterprise.
• Converted data from flat files (TXT, CSV and fixed width) into normalized database in SQL Server 2008.
• Worked with a DBA to migrate a SQL Server 2000 DW and ODS to SQL Server 2005 and a Crystal Reports to MS Reporting Services 2005.
• Supervised an application developer with ETL, Data Matching and Reporting System (SSRS) to track royalty payment to business partners.
• Developed new data service process using ERWIN Process Modeler, 3rd party tools, SQL Compare, Stored Procedure’s, User Defined Functions .NET components
• Collected requirements from end users to develop reports through technical team, QA reports and deliver it to end users.
• Coordinated between multiple technical teams to manage ETL, DATA WAREHOUSE and Reporting Application.
• Managed a DATA WAREHOUSE and ETL built-in SQL Server SSIS 2005 to support a reporting Intranet for Marketing, Financial and Sales Reports.
• Converted SQL Server 2000 DTS packages to SQL Server 2005 SSIS as a part of enterprise migration.
• Developed ETL process using SQL Server 2008 Integration Services (SSIS).
• Modified MDX Cube’s backend to use Analysis Services in SQL Server 2005 to meet same deliverables.
• Supported team members in data modeling and simulation activities using ERWIN ModelMart.
• Designed and implemented Logical and Physical data model on on-going base to accommodate reporting needs.
• Integrated two systems through data mapping and two-way data transfer method using SQL Server 2005, ORACLE 9i and VB.Net 2005.
• Upgraded an Advertising Web-Site as per system specifications in ASP.NET.
• Developed an ETL tool in VB.Net and SQL Server 2005 to exchange data between applications

Confidential, Garden City, NY

Responsibilities:

• Developed Business Objects for election process to distribute across application using VB.Net, MS Enterprise Library and SQL Server 2005.Upgraded database from SQL Server 2000 to SQL Server 2005 for new development.
• Developed a Data Export/Import utility for SQL Server 2000 using VB.Net, ADO.Net, SOAP and XML.
• Designed Email Blast and Parsing program VB.Net, SQL Server 2000 using MS Enterprise Library.
• Developed Voting Web Site using classic ASP, VB6 and SQL Server 2000.
• Developed a Data Quality Assurance process for a Clinical Study Tracking system.
• Created Master Data Architecture (MDA) for the real-time Clinical Reporting application.
• Integrated ClinRep system to ERP system by creating Data Model (DM) for end-to-end reporting process.
• Designed and maintained DATA MODEL of applications using ERWIN tool.
• Performed Data Profiling (DP) using off-the-shelf and custom utility to facilitate ETL load to Data Warehouse (DW)
• Created functional and technical documents to meet requirements.
• Extracted data from various source systems to populate and ORACLE 9i ODS using PL/SQL Server 2K DTS Packages.
• Developed a DATA WAREHOUSE with multiple Data Marts in SQL Server 2000.
• Integrated Clientele (a CRM Application) running in two sites through customizations in VB.Net and SQL Server 2k, SOAP.
• Designed an interface application in VB.Net to bridge a CRM system and AS400 Billing System.
• Performed Data mapping between multiples ODS build for different business function.

Confidential, Holtsville, NY

Sr. Systems Analyst

Responsibilities:

• Designed a Product Repair Tracking System in Visual Basic 6, SQL Server 2000, Crystal Reports 8 and Active Reports.
• Prepared documentation such as data flow diagrams, system specifications and user documentation in VISIO and MS Word.
• Designed the appropriate database layouts in MS SQL Server, data entry screens in Visual Basic 6 and reports in Active Reports.
• Programmed necessary code in Visual Basic 6 and SQL Server 2000 according to specifications.
• Designed an Enterprise Data Warehouse in SQL Server 2000 for OLAP reporting.
• Created a reporting Data Model in SQL 2000 data mart for OLAP and canned reports.
• Developed Interfaces between Rep Confidential, Clarify and SAP in Visual Basic 6, SQL Server 2000.
• Upgraded systems from SQL Server 7 to SQL Server 2000 and Crystal Reports 7 to 8.

Confidential

Systems Analyst

Responsibilities:

• Created a tracking utility in Visual Basic and SQL Server to monitor declined financial transaction and send report to management team on a daily basis.
• Supported an in-house Windows application that tracks repair of VeriFone terminal that are handed to retail stores nationally.
• Deployed a client-server application with Visual Basic and Crystal reports to capture POS transaction at corporate retails stores and general consolidated detailed report to executive team.

Confidential, NYC

Programmer Analyst

Responsibilities:

• Developed a re-insurance application in Visual Basic, MS Access and SQL Server to replace an existing claims module of an application.
• Created data model for an enterprise application to support underwriting, claims, re-insurance and accounting processes for the new system.
• Designed multiple claim reports in Crystal to work with back-end MS SQL and Access database.

Confidential, FLUSHING, NY

Application Developer

Responsibilities:

• Developed Pay-Per-View tracking application for the Customer Service group using MS Access and Visual Basic on Windows platform
• Designed a data interchange interface with Enterprise Data Warehouse using MS Access and SQL Server technologies.
• Built a reporting application with MS Access and Crystal Report to provide consolidate metrics from mainframe data warehouse and a proprietary CRM application