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 Warehouses on Oracle, Sybase, MS SqlServer, MySQL with ETL tools such as PL/SQL, Informatica and Sybase IQ ETL 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 2000 - E5000, 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 EXPERIENCES

Confidential, Ridgefield, CT 

Senior Solutions Architect

• Responsible for DW solution design for Animal Health CRM Veeva/SalesForce. It includes data analysis and profiling, MDM definitions, 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.
• Define, create and maintain PowerDesigner’s Business Glossary to enforce naming conventions in the ongoing modeling process as it relates to Veeva source as well as applying Naming Conventions conversion table.
• Created new and modified existing physical data models housed within the PowerDesigner environment. It entails ensuring appropriate metadata is applied to all new and modified artifacts.
• Ensure SQLDeveloper Modeler models contain metadata starting at field and table level.
• Responsible for generating ETL specification for Informatica PowerCenter.

Technologies utilized at Boehringer: Oracle, Power Designer, SQLDeveloper Modeler, Informatica PowerCenter 9.6.

Solutions Architect and Board Member 

• Define a scalable architecture for building AAOFT customer facing applications which in turn will become the revenue generating engines for AAOFT. 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. 99
• 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 Snowflake.
• Define development timeline with MS Project and estimate associated cost along with dev. team resource make up.

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

Title: Lead Data Architect/Project Lead

• 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. Also, it included implementing and improving Bank’s MDM rules & strategy.
• 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 at Peoples: Sybase, MS Sql Server, Oracle, Erwin, Power Designer, AQT and Sybase IQ ETL.

Bus & System Integrator

• 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.
• Participated as contributor to define Master Data Management strategy to ensure consistent master information across transactional ad analytic systems.
• 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.

PMO Project Manager/Data Architect

• 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 MetLife Term Insurance High Risk Class offering. Responsible for getting new product implemented on MetLife’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.

Chief Data Architect/Project Manager

• 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.

Advanced Application Architect and Sr. Project Manager

Main 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.

Solutions Architect/Program Manager/Technology Partner

Main 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.

Solutions Architect/PM

• 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, modeling OLTP store

Sr. Systems Architect

• 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 GE Capital 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.

Solutions Architect

• Assisted in project cost/benefit analysis, defining scope, identifying resources and risk, constructing project plans, incorporating integration and implementation strategies. New development budget/cost of $400k over 2.5 years.
• 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. Designed features included: 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 GE Re-organizations, new structural enhancements, server and storage migrations, ETL processes, technology stack upgrades and rollouts to sizable user-base organizations.

Project Manager

• 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 GE Capital and GE 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.
• Managed wing-to-wing development and support life cycle for the following Web Applications: United Way Pledging system, Course Nomination, Salary and Bonus planning/data gathering, eWorkforce (Employee headcount), OHR Data Completeness, Audit Push (Data Audit with participant notifications), Share the Success Bonus system, eStir (Succession Planning like app), My Six Sigma, Session C (Executive reviews), Payroll Sync (Dynamic feeds to payroll providers around the world), Goals and Objectives, OHR eTransaction tool (dynamic alternate front to Oracle HR ERP), Childcare Subsidy, M1 (employee emergency alerts), ETL OHR Sub-business Standard Extract splitter and others.
• 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.

Solutions Architect

• 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 GE Capital HRIT 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 GE 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.

Application Architect/PM

Responsibilities entailed:

• Led and managed multi-year technical ongoing support for Risk Finance home-grown applications, OpVantage package and incoming data feeds. It included generating SOWs, SLAs, infrastructure sizing requirements, defining technology stack and technical documentation.
• Designed and managed development lifecycle for the Capital Allocation data collection application. This included: Designing Data model with General Ledger feeds and sub-business spreadsheet data uploads; managed online and batch development and UAT testing.
• Designed and managed the Credit Risk application with Excel upload capabilities for GE Money sub businesses around the world and a batch process to aggregate financing product-line performance data by month, quarter, yearly and multi-year. It entailed working very closely with Fitch Ratings on risk modeling calculations.
• Provided web reporting capability on calculated risk probability by default, exposure at default, expected loss, Basel Tier I/Tier II capital calculation, aggregation by product, product line, country, global, adjustment for capital parameters such as Default Correlation (Rho-D), Capital Multiplier, Operational Risk Cap/Total & Basel II confidence level.
• Defined and implemented support service practices and case response timings for SLA results and sigma scores to Risk Finance clients.
• Hands-on SQL coding for financial model aggregator during development phase.