We provide IT Staff Augmentation Services!

Sr. Application/sharepoint Architect (consultant) Resume

4.00/5 (Submit Your Rating)

New York, NY

SUMMARY

  • Complex project and architecture management and Implementation Specialist, 100+ concurrent projects, 200+ near - shore and off-shore resources, $100MM+ budgets and managing local and outsourced reports using common project management methodologies like AGILE, SCRUM, RUP, WATERFALL etc.
  • Global governance procedures and creating a PMO/Project Management Office experience with demand and portfolio management. PMI /PMP Certified and SDLC expert.
  • Experience in various facets of Enterprise Architecture including business and Business Intelligence architecture, Solution Architecture, Application Architecture, Information and Data Architecture, security architecture, and service-oriented architecture (SOA) and acting as SME on any project or business
  • Experience in hands on use and Administration of popular and latest versions of ETL tools Informatica 9.6 Big Data/Cloud editions, Ab Initio, Informatica IDS services including data profiling, MDM, IDD, IDQ and Real Time data cleansing and integration, Oracle ODI, SSIS, Ab Initio and IBM WebSphere and Legacy Systems conversions, B2B Data Exchange, B2B MFT, Websphere Message Broker and use of ACCORD xml standards.
  • Experienced in Data Profiling, Data Auditing and Data Analysis of structured and unstructured data, explicit and implicit data, content management, preparing and implementing technical roadmap and architecture to develop a Trusted Data Repository storing certified data, Dimensional and Subject Area Based Data Warehouse, developing a BI Architecture and integrating with consumer applications, reporting, data auditing and compliance systems.
  • Ability to Identify, validate and implement appropriate data audit checks and error and exception checking. Persisting audits, data audit, metadata error and exception checks and results in the Trusted Data Repository so it is accessible. Using data and metadata error and exception check results for auditing and other purposes via reports and queries. Adding process tracking audit data elements identifying the ETL or Error and Exception process that created data in the Trusted Data Foundation or the Error and Exception Repository. Adding control data elements that distinguish one version of a data from another; ensuring that when multiple perspectives are required, the distinguishing data element is part of its identifier. Design of an interim "holding tank" to house data that is not ready for Trusted Data Repository.
  • Exceptional skills in identifying talent, vendor negotiations, and working directly with business users, bridging the distance between business users and technical staff to impart a clear and common understanding of project goals
  • Ability to build a Solid QA process to maintain consistency in service delivery, built to industry standards and using best practices.
  • Use a full range of quality methodologies to improve services and products. These include, but not limited to conducting peer reviews, performing functional and physical configuration audits, root cause analysis, sampling, and time series analysis to determine trends to monitor quality and performance in terms of reliability, dependability, and uptime and customer satisfaction.
  • TEMPEffective use of IBM Rational Tools and Mercury Quality Center and Test Director tools for loading requirements, traceability metrics, creating test cases with execution steps, execution of test cases in Test Lab, Defect and bug tracking and creating Standard and Customized Reports.
  • Ability to train QA testing personnel in the TEMPeffective execution of the entire Quality Assurance Process
  • OBIEE roadmap, DAC, Analytics, including Informatica IDS and ETL tools, deployment, configuration and testing, Enterprise and OBIEE Architecture/Administration, HR, Financial and Order management Fulfillment Analytics
  • Installation, configuration, deployment and setup for Microsoft Project Server 2010, Microsoft SharePoint 2010/2013 and Team Foundation Server 2010/2013 administration and integration of Microsoft Project Server 2010/2013, Fast Search Server 2010 & 2013 (built in), collaboration, Dashboards, Business Intelligence, Visio Services and TFS (Microsoft Team Foundation Server) VSTS (Visual Studio Team System) using Agile development
  • ITG PPM modules expertise, IBM SQA and Robot, Peregrine and Remedy for Change and Release Management.
  • Oversight and management of Design, Development, Deployment and operational phases of complex business critical and high availability solutions.
  • Crisis, risk mitigation, conflict and negotiation management.
  • Preparation of PPM Management Reports using Mercury ITG; variance analysis, revenue forecasts & projections and project profitability.
  • Experienced with budget processes, and financial baskets.
  • Re-engineering complex systems, production system support and release management.
  • Customer-centric communicator, facilitator with ‘excellent’ communication skills and savvy BRM (Business Relationship Manager).
  • Knowledge in finance, financial services for large banks, ACH and AML transactions, Real estate and Mortgage business, IT auditing, insurance, workers comp, re-insurance, behavioral health, logistics, construction, use case analysis, regulatory reporting systems and elegant business solutions to complex, mission-critical, cross-functional, emergent or time-sensitive problems.

TECHNICAL SKILLS

Applications Development & Coding: COBOL, CICS, PL/1, VBScript, ASP/JSP, JavaScript, PL SQL, Microsoft.NET, MVC.NET, VB.NET, ASP.NET, Java, PHP, PERL, VB, C, C++, Oracle, Oracle Portal, LAMP

Data and Data Cloud: Oracle OBIEE/Siebel Analytics and Informatica 9.5.4, Informatica IDQ, IDS including Data Profiling, Power Center, Power Exchange, B2B Data Exchange, Informatica MDM all versions to 9.7 and Informatica Big Data and Real Time Transformations, SAP Data Integration, Informatica Configuration and Administration, ODI, SSIS, SSRS, SSAS, Ab Initio, Websphere, Message Broker, Cognos, configuring Cognos Cubes

Microsoft Products: Windows 2008 / MS Office Suite, IIS6, IIS7.5

Project Management, Architecture, Implementation and Administration: MS Project, Agile, Scrum, Project Server 2003, 2005 & MS Project Server 2010/2013, VS Team Foundation Server 2010/2013, SharePoint 2010/2013, PMP & PMI Certified, Mercury ITG PPM Tools Expert. MOSS 2007, SharePoint Migration, InfoPath 2010/2013

Change Management: Peregrine / Remedy

Statistics: SAS / COM / DCOM / SOA, MTS

Data Modeling: ERWIN, MySQL Workbench, PowerDesigner, Toad Data Modeler, OBIEE, MDM

Application Architecture and Technologies: SOA, AIA, SharePoint, MOSS, Biz-talk, EIA, CORBA, COM, DCOM,JBOSS, Oracle RAC, Oracle Data Guard, BEA WEBLOGIC installation, tuning and administration

Databases: Oracle 10g, 11g, Oracle EXADATA, RAC, DB2, UDB, Big Data, Netezza/Hadoop, Access, HP Solid, SQL Server 2008 R2, 2005, 2006, 2003, VSAM

Security: LDAP, Active Directory Administration and setup, Cisco PIX Firewalls, setup rules etc.

Platforms: VM / MVS / NT / UNIX/ LINUX / Sun Solaris, Windows 2003, 2008, 2012

Automated Testing Tools: Mercury Test Director, HP Quality Center, IBM SQA and Robot

Schedulers: Maestro, AutoSys

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Application/SharePoint Architect (Consultant)

Responsibilities:

  • Directed and integrated SharePoint 2010, Microsoft Project Server 2010, Fast Search Server 2010, collaboration, dashboards, Business Intelligence, Visio Services and TFS (Microsoft Team Foundation Server) VSTS (Visual Studio Team Server) using Agile and SCRUM methodologies.
  • Created Web Pages, setup shared folders, created reports, dashboards and maintained security with LDAP.
  • Deployed from scratch, setup, configured and provided PMO support for Microsoft Project Server 2010, Microsoft SharePoint 2010 and Team Foundation Server 2010.
  • Hands on Manager of developers, SharePoint 2010, ETL and Application Design Architecture and delivered three Enterprise-wide Conversions of Legacy Application Projects
  • Converted DataEase applications and databases to Microsoft .NET and MVC with data modeling in ERWIN and designing and implementing databases in SQL Server 2008 R2 with SSIS for ETL and SSRS for reporting
  • Provided direct support for 3 Timekeeping .NET applications and SME role

Confidential

Enterprise Architect (Consultant)

Responsibilities:

  • Led iPhone, Palm, Android, Blackberry, Windows Mobile 7 and feature phone development team
  • Middleware Development, Data Architecture and data modeling for the Data Warehouse, ETL design and Enterprise architecture for over 175 individual data sources using Oracle ODI with data checks and error reporting systems
  • Technical and business SME for process and application design and deployment
  • Maintained SQL Server Databases for LDAP and Active Directory
  • Provided OBIEE and BI Applications configuration and administration, Dimensional and Relational Modeling development, Enterprise Architecture, Solution Architecture, Designing and creating Databases, Dashboards and Reporting environments
  • Led Disaster Recovery Planning, IT Infrastructure with hands on Cisco PIX firewall, Tape Backup, Active Directory management, VPN, Oracle Data Guard,
  • Recruiting and Interviewing, Capacity Planning, Project Planning, Implementation planning and advisory role to Senior Management. Environment is LAMP, Oracle 10G, Red Hat Linux, Brew, Objective C++, Java, J2EE, XML and custom protocols.
  • Used Agile and SCRUM methodologies for dis group
  • Responsible for 24x7 Production up time

Confidential

Enterprise Data Architect and BI Consultant

Responsibilities:

  • Reconfigured and setup SharePoint Server, SQL Server 2008 with SSIS and halped complete a SharePoint Document Management project in record time and received an award (normally reserved for employees).
  • With an IT staff of at least 95, managing at least 100 concurrent projects, the year’s project portfolio was $39m.
  • Having set up a complete PMO in less TEMPthan a month, led the Rational and Primavera teams to develop custom Project Planning Templates, Project Submission, Issue Management and Tracking tools.
  • Excellent communication skills resulted in an unequivocal acceptance of project management principles. As hands on PMO, my goals were to lead all IT projects to success with 100% successful delivery on time, under or within budget with zero failure rates. Used Primavera for Project Management and Rational CQ for Project Tracking and acted as personal mentor to all Project Management Directors, Project Mangers and Team Leads.
  • Technical and business SME for applications, BI systems, Oracle integration, application design and deployment
  • Developed Data Warehouse/Information Factory Project using ERWIN, Developed Meta Data Model, Informatica Configuration, Data Profiling, built data audits and checks with error reporting and handling systems, Power Center, Informatica/ODI for ETL and OBIEE HR, Financial and Order management Fulfillment Analytics and Reporting on Oracle 10G.
  • As hands on OBIEE Architect and Developer, engaged in multiple OBIEE Installations and configurations, Requirements gathering, OBIEE Dimensional and Relational Modeling.
  • Defined Informatica ETL Specs and Mapping, Informatica Power Center, Informatica IDS Data Profiling and Real Time Transformations, Creating Physical, Business and Presentation Layers in OBIEE Repository, Answers, creating Custom and Complex Write back XML Templates.
  • Created reports and reporting cubes in OBIEE Answers, exceptional JavaScript and HTML functions for real time validation leading to fantastic OBIEE Dashboards and functionality.

Confidential, NJ

Senior Technical Project Manager (Consultant)

Responsibilities:

  • Delivered on time, under budget with 100% agreed functionality.
  • As technical manager of application development, also hands on supported existing systems, was engaged in the IT governance process, in hands on development and management of Ab Initio ETL, JAVA J2EE, WebSphere and Cognos reports and configuring Cognos Cubes, operations management, implementing data validation and data audit rules
  • Mainframe data conversion to Oracle and DB2; environment Cobol, CICS, VSAM, PL/1
  • Maintained weekly & monthly financials and status reports on Mercury ITG, was responsible for the review of vendors’ SOWS, contracts & invoices for 6 external and outsourced vendor groups.
  • Delivered weekly status reports for activities of all groups and monthly project and budget reports to PMO. Engaged in Strategic and resource planning.

Confidential, Philadelphia, PA

Technical Director IT and PMO(Consultant)

Responsibilities:

  • Deployed and maintained an TEMPeffective project management process on Microsoft Project Server 2003 and Microsoft SharePoint 2003 and trained existing and new employees in TEMPeffective use of the same.
  • Negotiated and managed vendor and software purchase contracts. Directly trained Six Sigma Black Belts in project management and tracking techniques. Managed smooth operations of production and mission critical systems.
  • Managed the implementation of XPEDION Platform using G-Log software a J2EE and Oracle based system.
  • ETL Architecture lead and implemented using ERWIN on Oracle and SQL Server databases
  • Technical and business SME for business applications, Global Data Hub design and Architecture
  • Introduced Siebel Analytics development and deployment of reports and dashboards
  • Successfully developed and implemented a dual global portal in Oracle 10g, merging and converting an acquired company’s systems with systems previously in Oracle 9i.
  • Successfully developed and implemented IT Request System: A complete IT solution to project management, prioritizing and tracking system reducing project count from 700 projects to a manageable 50, in less TEMPthan three months.
  • Rebuilt and restructured a deteriorating vendor relationship affecting a major strategic and global IT project.
  • Developed best practices, techniques, and tools for project planning, execution, project management, ongoing milestone/deliverable tracking, communication, and key performance metrics.
  • CRM: Developed all internal and external IT communications tools and processes.
  • Managed system performance and automated tools testing team.
  • Oversight and management of the design, development, deployment and operational phases of complex business critical and high availability solutions.

Confidential, Philadelphia, PA

Director IT and Business Systems (Consultant)

Responsibilities:

  • Recruited to calm chaotic Property and Casualty IT development department in disarray due to 200-project backlog. Determined technology solutions in line with business needs and corporate long-term strategy.
  • Managed all aspects of disability management clinical cost management platform including management and development of application developer staff.
  • SME for healthcare bill review platform in J2EE environment
  • Executed P&L management of healthcare bill review platform, including budget planning, project and systems recommendations
  • Mainframe Legacy Applications and Data maintenance using Cobol, CICS, PL/1. Data on VSAM and DB2 databases
  • ETL, Data Warehouse and Reporting Architecture design using ERWIN and deployment
  • Successfully merged 2 bill review applications into single, unified application in J2EE, lowering costs by 50%.
  • Assumed project management of failing project <25% complete despite being in development for over 30 months. Brought project to 75% completion level within 3 months.
  • Initiated restructuring of new project management and prioritization process.

Confidential, Wyncote, PA

Director of Technology (Consultant)

Responsibilities:

  • Managed software process and programmers in delivering projects unit tested to QA, and overhauled QA and test software test processes. Worked with customers to define customer requirements, translate requirements into a statement of work, prepare quotes and, secure contracts. Reported progress and status to CEO and VP of deliveries.
  • Maintained 99.99% level of service across platform.
  • Process 360: Defined software development life cycle and standards as applied to IDP and implemented in development environment.
  • Software Movement Process: Defined software movement processes and applied to production environment. Slashed failure rate to <5% in 2 months.

Confidential, Mount Laurel, NJ

Senior Technical Manager (Consultant)

Responsibilities:

  • Recruited into critical, hands-on data modeler, application and ETL architect, program designer and coder role, responsible for managing teams of up to 50.
  • Instrumental to generating over $8MM in revenue through contract negotiations.
  • Energy Insurance Mutual: Developed enterprise architecture to implement a new property policy and financial reporting system for excess insurance liability carrier. .
  • AIG NY (Reinsurance and Personal Lines Systems): Reengineered mainframe and Java-based loss management system to DB2 data architecture. Reinsurance Systems SME
  • MIIX NJ (Medical Malpractice Insurance Systems): Developed new Enterprise Database and Application Architecture to manage Medical Malpractice Policy, Endorsement System, Policy DEC Forms and Reporting Systems using SQL Server Database and ERWIN for Data Modeling
  • Prudential Insurance Company (Property and Casualty Insurance): Developed credit card and check payment processing systems integrated with COTS products.
  • CIGNA P&C Insurance: Built reinsurance policy contract systems; performed Worker’s Compensation Claims feed analysis; designed/built claim data warehouse; and, designed/developed risk management system. Risk management systems SME. All conversion from Mainframe Legacy applications and DB2 and VSAM databases using Cobol, CICS, PL/1

Confidential

Technical Manager

Responsibilities:

  • Team building & Business Architecture
  • Business & IT Alignment by Enterprise Architecture by producing enterprise blueprints and IT roadmaps
  • Business Simplification & IT Cost Containment
  • Service-Oriented Architecture & Modeling; Metadata management
  • Legacy systems’ Re-architecture, Modernization, Consolidation, & Retirement
  • IT Governance, Standards & Best Practices
  • MDM Master Data Management, IDD, identifying Authoritative data sources, building single version of the truth, conformed dimensions
  • Informatica Data Profiling and IDQ for data cleansing including real time, Power Center
  • Informatica Installation, Configuration and Administration
  • Infrastructure design and support.
  • Product development and team management experience in mobile arena using Oracle 10G, Red Hat Linux, Brew, Objective C++, Java, J2EE, XML and custom protocols.
  • Informatica IDQ, IDS, IDE, PowerCenter, B2B, MFT B2B, Informatica Big Data Edition, Informatica Cloud Edition, Big Data Integration, Informatica IDS Performance Tuning
  • Performance tuning, automated QA testing tools.
  • Oracle OBIEE/Siebel Analytics: Extensive experience in OBIEE setup and Administration, Oracle BI Server, HR, Financial and Order management Fulfillment Analytics, BI Data Modeling, BI Presentation Service, BI Answers, BI Interactive Dashboard, BI Publisher, BI Briefing Books, BI Delivers and Disconnected analytics including heavy Java scripting and customizations
  • Oracle EXADATA: Planning, implementation, migration to and setup of test cases
  • Deploying and configuring OBIEE on Windows 2003 and 2008/2010 servers
  • Deploying and configuring OBIEE on UNIX Servers
  • Deploying and configuring Oracle RAC environments
  • Deploying and configuring Informatica 8.6, 9.1, 9.5 HF1-HF3 on Windows and Unix Servers
  • Deploying, setup, configuration and administration of Oracle Data Guard on LINUX Servers
  • Process re-engineering.
  • Disaster recovery management.
  • SOA and BI and Web services architecture, design & development.
  • ERP, EAI and EIA architecture design & development.
  • Data warehousing, data mining, data conversion and integration.
  • MIS management information systems.
  • Compliance, SOX & regulatory systems, workers comp systems.
  • Customer relationship management CRM
  • Data center management
  • Supply chain management Oracle OTM & G-Log suite of applications.
  • ETL EDI on Ab Initio, Informatica and IBM Websphere
  • MDM Informatica with IDQ Data Quality, Data Profiling, Meta Data Manager, Informatica Web Services, anything Informatica and anything IBM
  • SDLC, AGILE, SCRUM, PDLC, RUP & CMM methodologies.
  • Microsoft Project Server 2010/2013, SharePoint 2010/2013, TFS 2010/2013 Agile platform deployment, integration and support
  • Oracle portal development.
  • Complex project management 100+ concurrent projects, 400+ resources, $100MM+ budgets and managing local and outsourced reports.
  • Experienced in all web technologies/services.
  • P&L and strategic thinker and visionary.
  • Defining and documenting company policies and standards, contract management, total vendor management and negotiation for sale and purchase of software and managing RFPs.
  • Keen to take up challenging opportunities.

We'd love your feedback!