Skills

Please use this table to list the skills noted in the Required/Desired section of the requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Skill

Years Used

Last Used

Data integration and/or data warehousing technologies and methodologies

10 Years

2013

Experience working with large heterogeneous enterprise environments

12 Years

2013

Experience as a data warehousing project manager, team leader, or architect

8 Years

2013

Experience on projects within large heterogeneous enterprise environments

8 Years

2013

Understanding of database technology, Oracle preferred

10 Years

2013

Understanding of ETL technology, Oracle preferred

8 Years

2013

Understanding of data normalization and logical data modeling

10 Years

2013

Strong analytical skills, with the ability to develop effective logical system designs

8 Years

2013

Proficient in MS Office productivity tools

10 Years

2013

Strong interpersonal skills, with the ability to convey complex tasks to technical staff effectively

8 Years

2013

Employment History

Confidential

Sr. Data Architect

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

Confidential

Sr. Data Systems Analyst

• Designed a Data Migration solution from eRed and ProMat systems to BI Data Warehouse and ProRed system using SQL Server and Oracle, 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

Sr. Data Architect

• 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 Fannie Mae as per Chief Data Officer.
• Developed contents and statistics for the final presentation to client.
• Co - ordinated data collection efforts with client staff to deliver final content.
• Worked with project team members to analyze, propose recommendations
• Reviewed strategic projects for alignment with Enterprise Data Architecture EDA guidelines.

Confidential

Sr. ETL/DW Architect

• Designed IPM analytics Data Warehouse consisting of over 20 sources and integrated ETL applications with Microsoft products.
• Developed an end-to-end ETL process to load data from sources to Data Warehouse having Ralph Kimball star schema
• Incorporated data source into existing ETL architecture and Data Mart repository.
• Optimized and fine-tuned ETL processes 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

Senior BI/ETL Architect

• 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 Model Mart 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
• Performed troubleshooting, maintenance and 24/7 support to mission critical reporting application.

Confidential

Sr. Data Warehouse

• 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 SSIS 2008 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

Lead Data Analyst

• 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

Senior DBA/Architect

• 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

Sr. Data Architect

• 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 T-SQL 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

Senior Business Intelligence Architect

• 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 HYPERLINK/ n blankVB.NET 2005 and SQL Server 2005 for Merck 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 Vendor Source 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

Manager of Business Intelligence

• 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.
• Confidential
• 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 HYPERLINK / n blankASP.Net.
• Developed an ETL tool in VB.Net and SQL Server 2005 to exchange data between applications
• 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 Repair system, 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.