PROFESSIONAL SUMMARY:

Information Technologist with extensive experience in creating exceptional business value with software systems and automation for Fortune 100 clients. Has overseen, designed, developed, reviewed and troubleshot Data Lake and Data Warehouses on AWS RDS/Redshift, MS Azure, Oracle, Sybase, MS SqlServer, MySQL with ETL tools such as PL/SQL, Informatica and Sybase IQ ETL, AWS Redshift/Matillion with the main goal to streamline business logic, data flow and daily processing. Possess proven track records across strategic planning, outsourcing, process re - engineering, infrastructure sizing, software system development lifecycle, master data management and quality, data warehousing, data conversion, and packaged software implementations along with in-depth technology knowledge to build and design Enterprise WEB applications.

TECHNOLOGY SKILLS:

Languages: Java (Servlet, JSP, JDBC, J2EE, Struts, Spring, Hibernate, Web Services), ActionScript, MS VBScript, JavaScript, HTML & HTML5,XML, MXML, SQL, PL/SQL, Transac-SQL, Packages & Store Procedures, C, C++, SQR, MS VB, Pascal, Assembler & Cobol.

GUI’s: Powerbuilder, Visual Basic 5, Access & Gupta SQLWindows, Flex & Flash.

Reporting: SQRW, Crystal, Business Objects XI R2, Cognos, Jaspersoft Server & iReports.

Databases: Exadata, Oracle 7 - 12c, Postgres, MSSQLServer, SQLBase, HP Allbase, MS Access, DB2, Sybase & MySQL

ERPs & Business Packages: PeopleSoft HR (v3.11 - v7), PeopleTools & PeopleCode, Oracle Applications HRMS, MAS-90, QuickBooks Services, LexisNexis TimeMatters, CA Erwin and Sybase PowerDesigner.

Hardware: HP3000, IBM 4381, Sun Sparc 00, Sun Sparc, IBM Compatible & Mac.

OS: Windows 30-7, NT Server - 2010, HP-UX, SCO Unix, Solaris, RedHat Linux, Ubuntu, OS/2, VM/CMS, MVS & Mac OS X.

Mobile: Blackberry Enterprise Server & Blackberry Professional Server.

Protocols: SOAP, TCP/IP, UDP, HTTPS, HTTP, SFTP, FTP & RSS.

Other Tools: MS Project, Office, ClearCase, LoadRunner, WinRunner, TOAD, Eclipse, SQL*Plus, Informatica & Golden Gate.

PROFESSIONAL EXPERIENCE:

Confidential, Norwalk. CT

Enterprise Data Lake Solutions Architect/PM

Responsibilities:

• Responsible for Managing Discovery phase for Azure Data Lake and Hybrid Cloud Foundation enterprise-wide.
• Supplement initial Enterprise Architecture team Data Lake Design, design Enterprise Data Flow and Job stream for Azure Data Ingestion. This includes fluent interaction with AWS RDS & S3 environments.
• Run discovery workshops between Microsoft and Diageo stakeholders/subject matter experts encompassing IaaS assets such as Networking, Compute, Storage, Security and Cloud Operational Management.
• Run discovery workshops with Microsoft encompassing PaaS services such as DMG, ADF, ADLS, HDInsights, SQLServer, DocumentDB, Data Catalogue and Key Vault.
• Project management and design of Cloud Services Introduction to attain cloud services operational readiness for production environments.
• Compose and publish RFP documents for IaaS ongoing support and PaaS services on going support.
• Project Management based on Diageo’s project management rigor including project budget responsibility valued at 1,500,000 pounds.
• Responsible for interplay with Microsoft Consulting team for two work streams, Data Lake and Hybrid Cloud Foundation.

Technologies utilized: Azure Data Lake, MS HDInsights, MS SQLServer, AWS RDS & S3, Visio, Project, Visual Studio and Erwin.

Confidential, Ridgefield. CT

Senior Solutions Architect

Responsibilities:

• Responsible for DW solution design for Animal Health CRM Veeva/SalesForce. It includes data analysis and profiling, model design and creation of different DW Layers (Stage, History Repository and DataMarts) to support Sales reporting.
• Design model enhancements for existing US Animal Health DW and integration with new Global Animal Health DW initiative. This entails heavy SME interaction to gather business requirements in order to translate them to data models. Additionally, implemented conforming dimensions with sources from MDM, US BIVI DW and Veeva-RDS DW to streamline data flow and DW models.
• Ensure SQLDeveloper Modeler models contain metadata starting at field and table level.
• Responsible for generating ETL specification for Informatica PowerCenter.

Technologies utilized: Oracle, SQLDeveloper Modeler, Informatica PowerCenter 9.6.

Confidential, San Francisco. CA

Solutions Architect and Board Member (Technology Advisor)

Responsibilities:

• Define a scalable architecture for building Confidential customer facing applications which in turn will become the revenue generating engines for Confidential .
• The product should resemble a talent predictive engine which will allow clients to assess top candidates based on job requirements and suggest a plausible learning path.
• Land and finalize business requirements while strategizing an information systems solution with best of breath technologies to satisfy hybrid presentation (web, tablet and mobile) user consumption.
• Ensure flawless and smooth data integration, security and performance with third parties such as LinkedIn, recruitment job boards and internal data sources.
• Responsible for design of the middle tier web application, OLTP data modeling and dimensional models for reporting.
• Produce Application and Reporting Architectural specifications, Use Case documentation and Technical specifications with technology prototypes with AWS MS SQLServer, SSIS & SSRS, JBoss, Web Services and Ionic/Angular.js front end. Also, targeted future Big Data analytics conceptual design using Redshift and Matillion ETL.
• Define development timeline with MS Project and estimate associated cost along with dev. team resource make up.

Technologies: AWS MS SQLServer, SSIS, SSRS, AWS RedShift, Matillion and S3, JBoss, Java, Ionic/Angular.js, REST, Power Designer, MS Visio & Project.

Confidential, Bridgeport. CT

Lead Data Architect/Project Lead

Responsibilities:

• Responsible for designing the banks overall User Id attestation and user access provisioning process database model. It entailed assessing and surveying the banks’ OLTP applications security access approach in order to design a reusable and scalable model. Also, lead system owners and users’ interviews as part of the projects discovery phase in order to firm up business requirements of the process and reporting. Reinforced and validated requirements with manual data element tracing in systems within scope.
• Responsible for solution design, model design and creation and composing ETL specifications for future implementation.
• Design model enhancements for Loan Quest DW interface model to collect feed audit data and job execution statistics.
• Ensure Erwin and Power Designer models contain fully documentation with metadata starting at the field level, table level and overall ETL solution layer in order to ensure natural data lineage conforming to the Data Warehouse guidelines.
• Responsible for planning, scheduling, overseeing implementation and delivery of solution.

Technologies utilized: Sybase, MS Sql Server, Oracle, Erwin, Power Designer, AQT and Sybase IQ ETL.

Confidential, Stamford. CT

Bus & System Integrator

Responsibilities:

• Responsible for technical assessment, code review and troubleshooting of the existing Data Warehouse Informatica data flow with the main goal to streamline business logic and reduce daily processing. This effort entailed performing metadata and lineage tracing for impacted data elements in order to effectively fine-tune Informatica mappings and Mapping sources’ queries.
• Traced data issues originating in Micro Strategy reporting solution, DataMart source, Staging Schema, to Oracle’s Golden Gate replicated schema from CRM Siebel application, all within an Exadata Database.
• In charge of constructing a Informatica Job Stream with time execution matrix to better manage resolution of poor performing mappings in a workflow. It included periodically extracting job execution metadata from Informatica back-end and visualization using Excel. This effort also entailed a POC utilizing Metadata Manager sourced with Erwin ERDs and Power Center Repositories to attained data lineage to supplement the job stream global view.
• Perform model design on tables to expedite Architect resolution and approval.
• Responsible for coordinating Siebel upgrade activities and system impact as it relates to the Data Warehouse Domain.

Confidential, Stamford. CT

Solutions Architect/Program Manager/Technology Partner

Responsibilities:

• Program Manager escalation point for support team with level 1 for user facing interaction & level 2 for technical support.
• Synchronized production database with DR database and remediation of defective log shipping update to DR db.

Confidential, NY. NY

PMO Project Manager/Data Architect

Responsibilities:

• PMO Project manager tasked to bring PM rigor to existing program. It includes performing Risk Assessment on all program projects and advising on remediation action items.
• Fully responsible for orchestrating outsourced system-to-system communication from the data perspective. It entailed liaising w/ various IT vendors & creating a consolidated dataflow map to integrate all systems in the project solution.
• Responsible for system-to-system Data Mapping to ensure cohesive system integration as it relates to internal dataflow. This included building a data dictionary to set the ground work for future MDM strategy and implementation.
• Project Manager for Strategic Confidential Term Insurance High Risk Class offering. Responsible for getting new product implemented on Confidential ’s Direct Business Customer-Facing Internet framework while bringing together a variety of business functions, VPs and third party partners.
• Tasked to perform requirements discovery, functional requirements, through IT Build to product market release with a very aggressive timeline. It entailed channeling stakeholders requirement inputs to engineer optimal business process flows, interactions between processes and process execution orchestration. Functional focus on Social Media, Public Relations, Product Marketing, Data Analytics & Metrics, Data Mapping, Application In-take, Underwriting, Case Management and Finance/Accounting and Legal and Compliance work streams.
• Responsible to update Steering Committee and project sponsors. Project signified a first-year revenue of $7 million on 10 to 15-year terms.

Confidential, Stamford. CT

Chief Data Architect/Project Manager

Responsibilities:

• Responsible for business-wide database architecture direction, data flow design & database stabilization
• Assessed and stabilized core MySQL database application by implementing 2 node-replication & 1 reporting instance.
• Suggested database technology enhancements to attain enterprise-like system scalability. It entailed a proof of concept tracking a click streams and using Hadoop as backend with Hbase and Pentaho for reporting.
• Analyzed and designed data model for Entitle’s Insurance pricing module for 40 states in the US. Entitle’s pricing module represents the heart of a $20 million yearly revenue stream from direct internet customer sales for the company.
• Performed functional process walkthroughs of Underwriting, Policy Administration and Finance & Accounting producing re-engineered business processes to facilitate automation and process design and data governance.
• Design new feeds for General Ledger periodic bookings, A/P disbursements and monthly funds reconciliations.

Technologies utilized: UML, Erwin, MS Visio, MS Office, JasperSoft, iReport, MySQL Workbench, and Agile/Scrum methodology. MySQL, MS SqlServer, SQL, Store Proc, triggers, Cron, J2EE, JavaScript, Struts, Ajax & Tomcat.

Confidential, Raleigh. NC

Advanced Application Architect and Sr. Project Manager

Responsibilities:

• Managed project planning for Poultry Merit tool and PD Fish Calculator. It entailed requirements refinement, system design, front and back-end development and testing using Agile methodology.
• Prepared technology stack for GAM Internet-facing systems for Swine, Bovine, Ruminants, Poultry and Fish species.
• Responsible for Data Architecture as it relates to On-line application modeling including interaction with Hibernate.
• Led transition effort to absorb applications from Intervet Acquisition in Netherlands.
• Defined a 3-year Architecture Roadmap to integrate existing systems, leverage acquisition applications, and development of new modules to complete the full road map vision. Overall design includes: Internet Single Sign on; Animal Population Tracking; Vaccine and Product Inventory; Standard Operating Procedures Tracking; Health Survey Model; Remediation Tracking and Economical Calculation and Analytics.
• Managed and designed Web Automation of the Pancreas Disease Economic Model. It entails dissecting the spreadsheet implementation of the model and designing a multi-lingual web front-end.
• Yearly resource allocation budget for above eCommerce undertakings was $1,000,000.

Technologies utilized: UML based systems analysis templates, MS Visio, Bugzilla, Rally Agile Software, MS Office and Agile methodology. SQL and PL/SQL, Cron, J2EE, JavaScript, Struts, Ajax, JBoss Cluster, Apache, Erwin & tomcat.

Confidential, Stamford, CT

Solutions Architect/Program Manager/Technology Partner

Responsibilities:

• Prepared solution presentations and technology offers for clients in the areas of Human Resources, Legal and Compliance, Risk Financing and IT. It entailed producing: marketing materials for new Service Offering, Solution Showcasing presentations and stream-lined sample Service Level Agreements.
• Managed client bidding and project execution process many times for “concurrent projects”. This entailed:
• Structured Customer Service support operations with appropriate SLA levels, SOPs and Case Metrics reporting.
• Researched and Development of potential new products/technologies and niche market assessments.
• Managed monthly operations and project budgeting for $1.5 - 2 million per year with projects impact of $5-10 million.
• Managed on-going multiple project activities versus available resources and technical expertise.
• Set technology direction and build out related R&D infrastructure. Staff development and intellectual capital development.
• Project planning for ongoing support and new functionality development with Corporate’s Single Sign-on web integration. New development effort cost of $150k.
• Lead and perform gap analysis of TeamMate Audit package versus PepsiCo’s requirements.
• Guided BAs and developers generating requirements document, technical specs., ETLs and code artifacts.
• Systems architecture validation and technology selection for optimal performance and ease of maintenance.
• Responsible for designing data flow and replication from Audit Package, modelling OLTP store, transformation using PL/SQL and Informatica, dimensional modelling for Business Object Universe.
• Assists development/support teams with functional and technical ongoing challenges in Java and BO XRI2&3.
• Prepare help desk SOP and case/metric reporting for internal as well as external use.

Confidential

Sr. Systems Architect

Responsibilities:

• Designed a roadmap to leverage the eTransaction application functionality in a SOA environment. It entailed proposing a technology stack which will allow sharing the applications business functionality with other sub-businesses IT organizations and other applications within Confidential HQ.
• Evaluated JESS and Drools rule engines while contrasting implementation approaches for eTransaction system.
• Defined project toll-gates, detailed respective project activities, required resources and a price estimate. Rule Engine solutions required structural changes yielding to a home-grown rule engine and rule editor solution.
• Designed a home-grown rule engine and authoring tool with integration with the existing eTransaction application.
• Authored extensive rules and rules execution testing while trained application administrators on new functionality.

Confidential

Solutions Architect

Responsibilities:

• Assisted in project cost/benefit analysis, defining scope, identifying resources and risk, constructing project plans, incorporating integration and implementation strategies.
• Grounded client requirements to articulate HR business processes to compile a Business Process Repository.
• Generated main SOW and Change Orders defining project duration, approach, resource requirements and cost.
• Designed and led development and enhancements of the application while implementing 24x7 uptime.
• Code-free Form Editor to create transaction processes; On-the-fly multi-lingual screen/look-and-feel support; HR event notification and workflow orchestration and execution support; multilingual data-entry support; multi-record and multi-row OHR record type support; and global security features.
• Develop environment sizing based on application functionality, user session information, peak and off-peak application usability metrics and 24x7 uptime requirement.
• Responsible for assessing system impact analysis for Confidential Re-organizations, new structural enhancements, server and storage migrations, ETL processes, technology stack upgrades and rollouts to sizable user-base organizations.

Confidential

Project Manager

Responsibilities:

• Generated various responses to RFPs and Statement of Work for single and multi-year support agreements, new system development, Re-organizations and re-architecture projects. Proposals entailed pricing and project planning for wing-to-wing technology stack support, applications support/development, and help desk for end-users and owners.
• Project planning and budget/completion control, assessment/preparation of global system architecture, impact analysis, and implementation methodologies for a fast-changing HR organization. Budge/cost over 8 years of $2.5 million.
• Maintained environment architecture composed of virtualized SUN servers configured with clustered web and application servers, and various Oracle databases to accommodate Confidential and Confidential changing needs.
• Managed Global HRIT support teams responsible for ensuring 24x7 proper functioning of 20+ different HR Applications with Siteminder Netegrity integration, Data Warehouse ETLs and 200+ incoming and outgoing data feeds, various Oracle DB installs, first level user help desk and minor system enhancements.
• Managed and guided business analysts and technical team in day-to-day support activities, generation of SOP, business and system level requirements, gap analysis, technical specifications, unit, UAT and deployment plans.
• Performed product evaluation of EnterpriseDB/Postgres Plus as an alternative/replacement of Oracle DB. It entailed evaluating EnterpriseDB support for PL/SQL, conversion strategy, implementation and tunning.
• Personnel mentoring, performance reviewed and setting team members’ objectives in order to drive SLA fulfillment.
• Assigning resources, establishing budgets, project change management, issue resolution and escalation management.

Confidential

Solutions Architect

Responsibilities:

• Developed project implementation strategy and project plan, identified methods and approaches to ensure successful project delivery within aggressive timelines.
• Provided project estimates for build-out, application/DW/ETL processes/feeds migration from respective converging businesses, participated in the business analysis, and created technical design for new Confidential platform.
• Worked and liaised with onshore/offshore third parties such as Infrastructure & UNIX administration team, Global networking team, Storage team, Security & Single Sign-on team, Software vendors and Confidential Corp. technical teams.
• Project planning and control, preparing hardware sizing documentation and environment architectural specification.
• Designed data store environment, MDM, Data Quality & modeling for OLTP systems, Staging Area, Data Warehouse model, ETL, data loading flow approach and prepared supporting architectural diagrams and documentation.
• Change management, directed analyst to compose technical documentation, testing and deployment plans.