We provide IT Staff Augmentation Services!

Solution Architect Resume Profile

3.00/5 (Submit Your Rating)

VA

EXPERIENCE SUMMARY

  • Leader in Analytics, Data Warehousing and Business Intelligence with demonstrated success managing DW/BI programs
  • Extensive experience in DW/BI Solutions Architecture and Design with extensive experience in multi data sources integration
  • Defined strategies and roadmaps for Data Management and Business Intelligence solutions
  • Experience in Operational Data Store, Data Governance and Master Data Management
  • Multiple end-to-end data warehouse / business intelligence implementations
  • Extensive experience with on-premise and cloud BI technologies. Extensive experience in SAP Business Objects implementations
  • Domain Expertise in Banking Financial Services BFS Electronic Payment, Banking and Bill Pay solutions, and Mortgage
  • Managed large strategic IT initiatives involving business processes re-engineering, operations, and acquired organizations
  • Led consulting engagements in a global delivery model, working with consultants in US and India. Experience leading both dedicated and shared resource model
  • Extensive experience and skills in leading full life cycle software development and support
  • Specialist / SME with technical skills and business acumen
  • Involved in sales and business development activities throughout the career

TECHNICAL EXPERTISE

  • Data Integration: DataStage, Pervasive DI, SAP Business Objects Data Services BODS
  • Business Intelligence: SAP BusinessObjects 4.0, Xcelsius, Microstrategy, Information Builders, Pehtaho, JReport
  • Report Bursting Tools: APOS Bursting Manager
  • SaaS/Cloud: Service-now.com CMDB, GoodData, BI On-Demand, Salesforce.com
  • ERP: AMS Advantage ERP
  • Programming: Java, J2EE EJB, JSP, JDBC, XML , UNIX
  • Databases: Oracle, DB2, SQL Server
  • Others: MS Project, MS Office, TOAD, PVCS, Clear Case, Clear Quest, MS Visio, Oracle Data Modeler

RELEVANT EXPERIENCE

Confidential

  • Owned the operational support and sustainment activities for Data Warehouse / Business Intelligence for Online Banking, Bill Pay, and Electronic Bill Payment and Presentment products.
  • Provided leadership and management for all development and enhancements of DW/BI solutions
  • Built close relationships with business leaders and stakeholders across the organization to understand their key informational needs, worked on requirements, and got projects delivered
  • Worked with Banking and Bill Payment Product Management and defined and executed strategies and service offering roadmaps for new data integration initiatives
  • Gathered and documented business requirements from stakeholders
  • Worked closely with Account Executives, Sales and Marketing Managers for delivery of custom reporting
  • Scoped and managed client custom development projects
  • Identified automation opportunities and automated many manual processes. Streamlined and improved existing processes
  • Created data integration and data management strategy and architected and led the multi-source data integration
  • Enhanced Operational Data Store ODS and Data mart.
  • Integrated Salesforce.com data into the data warehouse and increased automation.
  • Created master data for bill payment products
  • Led the data integration between acquired organizations
  • Delivered thousands of time sensitive daily reports to external financial institutions
  • Led the data center migration of the highly complex data warehouse and reporting system with over 9 TB of data
  • Managed performance of on-site and offshore team members including contractors
  • Evaluated Business Intelligence platforms

Confidential

Confidential

Solution Architect

  • Worked as a trusted advisor to the client finance group on the Enterprise Data Warehouse strategy phase
  • Conducted several interviews, understood client's business goals, and gathered program level requirements and translated into high level architecture
  • Ensured active involvement of business and IT throughout the project
  • Defined blue print and time-phased roadmap needed to achieve strategic goals
  • Created data governance framework

Confidential

Solution Architect

  • Worked on the strategy phase for the claims adjudication system Enterprise Data Warehouse
  • Interviewed senior management, business, and IT stakeholders for program level requirements gathering
  • Documented requirements and translated into high level system architecture
  • Presented final deliverables to client's executive management

Confidential

Business Intelligence Project Manager

  • Responsible for management and delivery of Quality and Patient Safety Data mart and Quality metrics / analytics
  • Managed the project scope, change requests, schedule, budget, resources, risks, and issues
  • Responsible for project communication, status reporting and escalation of issues to client senior management
  • Ensured strategic applications delivery with creation of flexible and robust BI architecture
  • Led the data architecture, data mart design, source to target mappings, ETL and BI development, and deployment
  • Led a team of data analyst, business analyst, data architect, ETL developers, and Business Objects developers
  • Integrated data from 8 source systems across all hospitals including unstructured data sources
  • Integrated data from Operational Data Store ODS
  • Identified, quantified, and documented data quality issues in the source systems and communicated risks to the client
  • Established data governance committee and worked with business owners for data standardization across all 3 hospitals
  • Conducted several design reviews, code reviews, and ensured client satisfaction of the deliverables

Confidential

Data Architect

  • Gathered business and technical requirements from business and IT leadership for the applications migration to the new IBM data centers. Assessed the migration scope and identified applications that are candidate for retirement and archival
  • Gathered detailed technical information on the applications in-scope for migration
  • Cleansed the data and architected and led the implementation of the Cloud based Service-now.com Configuration Management Database CMDB . Gathered the CMDB requirements from several stakeholder groups. Worked on the data model mapping and customization, UI designs and migrated the application data to Service-now Cloud CMDB. Designed and created reports in service-now. Setup the security model. Worked on the technical documentation and transitioning.
  • Researched and evaluated Cloud based Data Integration/BI platforms that integrate with Salesforce

Confidential

Business Intelligence BI Project Manager

  • Managed the implementation of mortgage risk analysis Business Intelligence system for Ginnie Mae
  • Gathered BI requirements and led the design, implementation and deployment of data mart and reporting functionality
  • Led a team of BusinessObjects, Xcelsius,.Net developers, DBAs, architects including multi company contractors.
  • Worked with the business to design reports, dashboards, searches, and integration with .Net portal
  • Involved in designing the data model, reports, data conversion activities, Business Objects universe, and single sign-on
  • Wrote technical design documents, testing strategies, test cases, and led system testing activities

Confidential

Data Warehouse/Business Intelligence DW/BI Release Manager

  • Managed the Data Warehouse/BI baseline and client customization product development and deployment for AMS Advantage Financial ERP suite of products
  • Defined release life cycle, SDLC, and version control, which improved product quality and decreased product release time
  • Planned and managed product releases, hot fixes, and led software development teams including India.
  • Drove SAP Business Objects XI platform upgrade with end-to-end ownership
  • Led data architecture, application development, data conversion, system testing, and deployment activities
  • Coordinated with cross functional teams, development teams, customer service, and implementation teams in product line
  • Streamlined the release management, software development, and defects management process
  • Met the SLA's on clients issues and enhancements that were on multiple operating systems and databases
  • Worked on Business Objects XI R2 universes, reports, security, and single sign-on functionality
  • Led the development and delivery of multiple J2EE Web development projects

We'd love your feedback!