SUMMARY:

• Accomplished Enterprise Data Architect with extensive background in Big Data, Data Warehousing, Business Intelligence, and OLAP based technologies.
• Strong track record in Conceptual / Logical Data Modeling, Data Vault, Master Data Management, Enterprise Data Modeling, Physical Data Modeling, Enterprise Data Warehouse Design (Kimball/Inmon), Operational Datastore Design, Datamart Design, Metadata Management. Effective communicator, champions change and effectively manages the implementation of new ideas.
• Return client engagement reflects the capability and willingness to pick up slack in all areas of BI, EDW, Analytics space. Recent hands on experience in Hadoop, HDFS, Map/Reduce, Pig, Shell Scripting, Database tuning (Oracle, Sybase, Microsoft SQL Server, DB2, Netezza), ETL (Informatica, SSIS), BI / Reporting (SAP Business Objects, Webi, Deski, Crystal Reports), QA/Issue Tracking (Rational Test Suite), Enterprise Scheduling (CISCO Tidal), OS Scripting (Windows, Linux, Unix), Hardware, Networking, Java, Python, .NET.

TECHNICAL SKILLS:

BI Tools: Business Objects BI 4.0/XI 3.1/ XI 3.0 / XI R2 / 6.X, Salesforce, Web Intelligence BI 4.0/XI 3.1/3.0/XI R2/6.0, Crystal Reports 2011/2008/XI R1/R2, SharePoint, Informatica Power Center, SalesForce, Unica

Big Data: Hadoop, HDFS, MapReduce, Pig, Hive, Rackspace Cloud, Shell Scripting

RDBMS: Microsoft SQL Server, Oracle (9i/8i), Sybase ASE 10.x - 12.x, ASA 4.x - 9.x, IBM DB2, MYSQL

SOFTWARE: ASP.NET, C#, Java, JavaScript, J2EE, PowerBuilder, UNIX Shell Script, Perl, XML/XSL, DHTML/CSS, PowerDesigner, ERWin, UML, Rational Rose

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst / Data Architect

Responsibilities:

• Company’s first large scale Hadoop based Data Lake (1st milestone) and Confidential Management System (2nd milestone).
• Contributed to architecture and created a proof of concept demo.
• Generated Confidential specifications / mappings.
• Generated / executed test scripts.
• Created a flexible framework managing over 50 disparate data feeds.
• Utilized Unix shell scripting and Tidal Enterprise Scheduler to manage load balancing on the Informatica servers.
• Worked closely with Analytical Reporting group to ensure the Data Mining and Predictive Analytics requirement were met.

Technology: Hadoop Hive, MapReduce, Unix Shell Scripting (Bash), Rational Test Suite, Microstrategy, Cisco Tidal Enterprise scheduler.

Confidential

Technical lead

Responsibilities:

• Responsible for Design, Integration, Deployment, Legacy Data Migration.

Technology Stack: Oracle, VB.NET, Web Services, Rational Test Suite.

Confidential

Responsibilities:

• Design and Implementation of a data quality module, integrating custom and vendor solutions.
• Generated and executed Rational test cases.
• Informatica, Salesforce, CRMFusion Demandtools, Oracle, Cisco Tidal Scheduler, Rational Test Suite.

Confidential

Business Intelligence Data Architect

Responsibilities:

• Performed the analysis of the report inventory for each business unit.
• Reviewed business requirements with focus on content cleanup and consolidation.
• Managed resources and schedule and communicated the project progress with business.
• Provided leadership and technical assistance to several development teams.
• Migrated Desktop Intelligence Report to Web Intelligence utilizing the report Conversion tools and manual redesign of unsupported features.
• Generated and modified Informatica ETL data flows and mappings to accomodate data changes.
• Led the UAT effort and project sign-off.
• Production deployment planning and execution.

Technology: Oracle, Informatica PowerCenter, MS SQL Server, DB2, Business Objects XI 3.1

Confidential

Responsibilities:

• Hardware specification configuration of Development, UAT and Production environments.
• Installation and configuration of BusinessObjects XI 3.1
• Installation of the Universe and reports. Design / configuration of application and user security.
• Creation of Oracle database and associated security.
• Informatica ETL data loads and validation efforts.
• Production deployment and support.

Technology: Oracle, Business Objects XI 3.1, Informatica PowerCenter, MunichRE Allfinanz Interview Server.

Confidential

Datawarehouse Architect

Responsibilities:

• Lead the design implementation of an Enterprise wide global initiative, program and project data warehouse utilized by PMO and Finance groups across Confidential .
• Responsible for detail analysis and design of a large scale PM Tools Data Warehouse / reporting system.
• Lead the integration effort with the ASP.NET / SQL Server OLAP application.
• Multi-source Confidential consolidation Oracle Data Warehouse / Business Objects Reporting and Analysis.
• Integration of Finance Group Datamart via replication and SSIS data loads. Creation and deployment of OLAP cubes.

Technology: Oracle, MS SQL Server, .NET, SSIS, SSAS, Business Objects XI 3.1, Business Objects BI 4.0

Confidential

Business Analyst / Data Architect

Responsibilities:

• Business Analyst and Data Architect role on large scale Global Marketing Database system.
• System integrated Retail customer data from over 20 internal and vendor data sources, sent to a third party System, cleansed and consolidated in a Marketing Confidential DataMart. Extracts generated to feed the data to several internal reporting /BI systems.
• Held a role of Team Lead / Data Architect on a highly visible, mission and time critical project.
• Generated vendor Confidential requirements.
• Designed data layouts and load maps.
• Worked with infrastructure to generate the support platform compliant with security and bandwidth requirements.
• Participated in QA / Validation, coordinated deployment and production support.
• Developed and implemented data loads into Salesforce cloud platform.

Technology: Microstrategy Business Intelligence Datamart, Infomatica, SalesForce, Oracle, MS SQL Server, Responsys, SPSS, Unica, ERWin, .NET, Enterprise Service Bus and Cisco Tidal Enterprise scheduler.

Confidential

Business Intelligence Data Architect

Responsibilities:

• Consolidated Underwriter Renewal System.
• As a Data Architect for the mission critical Large Scale .NET application at the foundation of the company’s revenue stream.
• Responsible for Conceptual, Logical and Physical data model for a database containing over 250 tables and over 3500 data elements.
• Contributed to the application architecture.
• Served with a DBA to support a large local and off-shore development team and transition of the system through the development. generated requirements for ETL data mappings and data flows.
• In a Business Intelligence Architect role led the initiative stages of the project designed a Datamart, Business Objects Universe and lead the team through the development cycle of over 30 data intensive reports.

Technology: Oracle, DB2, .NET, Business Objects XI 3.1, Informatica PowerCenter.

Confidential

Senior Consultant

Responsibilities:

• Led the development of a reporting module to support Merchandize Allocation system, based on Business Objects XI R2, Crystal Reports and Oracle 10G back end.
• Responsible for full project lifecycle from analysis and design, to UAT validation and deployment.
• Facilitated requirements gathering sessions.
• Translated the requirements into design specifications.
• Lead the team through Validation and User Acceptance Testing.
• Hands on involvement in database objects generation, Query optimization, validation and deployment scripts.

Confidential

Data Architect

Responsibilities:

• Held the role of Technical PM, Lead Architect with hands on involvement in Database design, performance tuning, as well as Implementation.
• National Accounts Mobile Application
• Wholesaler Mobile Application
• Development and deployment of two mobile applications tracking sales and contact management for the national sales force.
• Managed both in-house and third party vendor development. Both applications were taken through full development lifecycle on a very aggressive schedule.
• Re-architecture of the in-house CRM, Sales Tracking, Data Warehouse and Reporting Systems
• Process re-engineering
• Implementation of external vendor sales data feeds.
• Implementation of ETL Processes
• Reporting System.
• Participated in all staged of SDLC, including hands on development and testing.

Confidential

CTO

Responsibilities:

• Managed a team of 20-40 consultants, project managers, account managers, recruiters and marketing specialists.
• Developed strategies, processes, policies and standards that helped Confidential become a solution provider.
• Created and maintained offshore selection processes and partnerships.
• Served in Strategic and Tactical advisory roles to provide value added services to several Confidential 500 clients.
• Generated Best Practices documents, White Papers. Generated training course materials for the new technology boot camps and held training seminars located both in-house and at client sites as part of marketing and sales support.
• Held both project manager and lead architect roles for several client and in-house projects.
• Managed a development team, controlled project schedules, budgets and resource assignments.
• Responsible for full application lifecycle from user requirement, analysis and design to production deployment and validation.
• Developed user requirements, design specifications and test plans. Heavy hands-on experience in system analysis and design.

Confidential

Senior Consultant

Responsibilities:

• Prepared development environment for application and database migration.
• Managed daily operations, which included application support, oversight of daily feeds from several PeopleSoft applications.
• Worked closely with HR analytical group to provide custom data extracts reports and batch data loads.

Technology: PowerBuilder 8, PowerBuilder 10.5., Oracle, PeopleSoft.

Confidential

Senior Consultant

Responsibilities:

• Managed a development team and was responsible for the full lifecycle of the Reference Standards Management System - from analysis, modeling, application design, database design, and documentation to implementation and validation.
• The system is responsible for tracking inventory, distribution and qualification of reference standards materials.
• Reference materials are used in every aspect of product development and manufacturing. This application lies at the core of every product produced by Wyeth.
• Application was developed in PowerBuilder 10 / PFC and Oracle 9.3 with interfaces to an LDAP server for user authentication. Implemented development environment based on the VSS 6.0D Source Control System. PowerDesigner 11 was used for UML model and database design. Generated Oracle triggers and stored procedures. Worked closely with a DBA group to provide deliverables in a form of a set of DDL scripts. Assisted in generation of Database Installation and Qualification protocols.
• Project was implemented in a heavily regulated environment.
• Application was designed and developed for 21 CFR - Part 11 compliance. Worked within guidelines specified by the company’s SOPs.
• Developed the Design Specification and contributed to User Requirement Specification, Functional Specification, as well as Installation Qualification, Operational Qualification, and Performance Qualification Protocols.
• Reviewed the Validation Plan and Validation Summary Report. Reviewed and executed test cases.