We provide IT Staff Augmentation Services!

Data Architect / Business Analyst Resume

2.00/5 (Submit Your Rating)

Boston, MA

SUMMARY:

  • With Over 16 years of experience, Confidential is a focused and experienced professional with strong Business, Management and Technical skills that enable to effectively manage cross - functional engagements. He has experience in delivering high-impact solutions in the areas enterprise planning and CRM systems. Has established and earned good credibility with customers and delivered successful projects.
  • He has also experience in executing application maintenance engagements which includes mobility, staffing, knowledge transition management, process baseline, KPI baseline and management, SLA Management, execution, demand & utilization, Service Management Framework Design and Implementation, incident & escalation management, risk management, etc. Confidential includes experience in IT and Vendor management also.
  • Manas have experience with industries like Health & Life Sciences, Retails, Automotive, Telecommunications, Loyalty, Media, etc., with primary focus on Information Technology & Management. He has as established record of delivering technology and functional solutions with various CRM Applications such as Oracle Sales Cloud, Siebel, Oracle CRMOD, Amdocs Clarify & SFDC solutions. Manas have the ability to handle complex business challenges creating value for clients. He has experience in designing, planning & implementing technical architectures.
  • Manas is carrying CRM development experience for more than 12 years from Developer to Lead to Manager in the areas of data migrations, interfaces, configuration & development and administrations. He also expertise in the areas of ETL using Informatica, Castiron, Datastage and Oracle PL/SQL.

TECHNICAL SKILLS:

Functional & Technical: CRM Based Data Modeling (Logical & Physical), Data Conversions, Data Cleansing, Data Quality, Optimization & Tuning, Data Architecture, CRM, BI, Technical and Solution Architecture, Business Analysis, Functional Testing.

Technologies: Oracle Sales Cloud, Siebel (EIM, EAI, Admin, Config), Oracle CRMOD, Clarify, SalesForce, Informatica, IBM Castiron, Datastage, Oracle PL/SQL, Oracle BI, Power BI, Amazon Web Services. Python

Industries: Sales, Service, Marketing, Manufacturing, Pharma & Life Science, Clinical Trail, Telecom, Automotive, Retail.

Management: Service Management, Project & Program Management, Cross Communications, Client Relationship Developments, Requirement Negotiations, Vendor Management. Agile, Scrum

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Data Architect / Business Analyst

Responsibilities:

  • As a data Architect defining new data requirements, mapping to existing application design and data models, plugging into existing integrations jobs.
  • Analyze daily job failures, provide solutions and implementing for future processing.
  • Co-ordinate with the offshore team, understand issues and provide solutions where required, take inputs and escalate accordingly and responsible for deliveries.
  • Work with various Contract Research Organizations (CROs) for issues related to the daily feeds, changes required to both systems, reconciliations and adding data map changes.
  • Work with client closely to understand, capture and record requirements for new changes.
  • Worked on administrations tasks like User Management, Migrations, Reconciliations, application provisioning and initial setup for new users in CITRIX and LDAP servers.
  • Review deliverables. Schedule and walk through deliveries.
  • Work with the senior management on escalations, updates and project status.
  • As a business analyst with various business leads to understand new change requests, negotiate for feasibility, capture requirements and proceed with the development team.
  • Prepared the test cases as a business analyst. Worked with the users on UAT and coordinated the defects to closure
  • Worked on creating and managing dashboard reports using BI Publisher.
  • Worked on development and change request for Oracle BI and integration with Siebel and SalesForce.
  • Worked with mapping and application development initiatives for integrating Siebel and SalesForce.
  • Worked on migrations and deployments from environment to environment.

Confidential, Herndon, VA

Project Manager / Client Liaison / Business Analyst

Responsibilities:

  • As a Project Manager driving the project from discovery through deployment and supporting the warranty period.
  • As a liaison co-ordinate with the offshore team, track the development along with the schedule and responsible for deliveries.
  • Work with client closely to understand, capture and record requirements.
  • Worked on application provisioning and initial setup.
  • Review deliverables. Schedule and walk through deliveries.
  • Work with the senior management on escalations, updates and project status.
  • Worked with client on different stages including different CRPs.
  • As a trainer, trained the end user with the application.
  • Prepared the test cases as a business analyst. Worked with the users on UAT and coordinated the defects, consolidated the enhancements, etc.
  • Worked on migration and deployments.
  • Configured users and application for the production deployment.
  • Carried out post implementation support.
  • Worked on change orders for additional features.

Confidential, Canton, OH

Project Manager / Client Liaison / Business Analyst

Responsibilities:

  • As a Project Manager executed the project from discovery through deployment and supporting the warranty period.
  • As a liaison co-ordinate with the client and offshore team, track the development along with the schedule and responsible for deliveries.
  • Understand current process and applications, capture and record requirements.
  • Worked on application provisioning and initial setup.
  • Worked with Oracle on provisioning issues based on the environment.
  • Review deliverables. Schedule and walk through deliveries.
  • Work with the senior management on escalations, updates and project status.
  • Worked with client on different stages including different CRPs.
  • As a trainer, trained the end user with the application.
  • Prepared the test cases as a business analyst. Worked with the users on UAT and coordinated the defects, consolidated the enhancements, etc.
  • Worked on migration and deployments.
  • Configured users and application for the production deployment.
  • Carried out post implementation support.
  • Managing enhancements and release as patch.

Confidential

Technical Architect

Responsibilities:

  • To design and develop interfaces (both inbound and outbound) for Siebel with other home grown applications.
  • Use SSIS packages in Microsoft SQL server to configure these interfaces.
  • Design & Develop PL/SQL for stages that process data and design the business logics.
  • Worked on creating reports using Microsoft Power BI.
  • Design & Develop interfaces between SFDC and MS SQL Server which will further transform and process data to other applications such as finance, HR, credit check, ETC.
  • Part of the SFDC roadmap defining team and working the prototyping.
  • Working with the Business team and the technical team to understand the current infrastructure to migrate entities from Siebel to SFDC and to accommodate the additional functionalities and interfaces with SFDC
  • Design Development with respect to SFDC support includes:
  • Setting up profiles
  • Setting up users and licenses.
  • Working with declarative objects - Applications, tabs, page layouts, etc.
  • Working with declarative logics - workflows, validation rules, assignment rules.
  • Building data models - Objects, fields, setting up relations, etc.
  • Working with custom objects and creating different type of relationships.

Confidential, CA

SME & Technical Architect

Responsibilities:

  • This was a short term project. Client was existing customer and there were several engagements going on. The client team and Perficient technical team were working on various applications and wanted to do a performance analysis for the Siebel applications, interfaces and the integrated applications. My responsibilities was the do a study of the enterprise and provide recommendations and re-design / re-built some or the applications.
  • Provided recommendations on the WSDL designs.
  • Suggested batch interfaces of Siebel, SFDC with Oracle and SQL Server.
  • Recommended third party solutions, purchased and re-build interfaces using these tools.
  • Re-design PL/SQL procedures, test and deployments.
  • Performance tuning of Siebel applications.
  • Developed Python scripts to integrate open source systems with Siebel.
  • Developing SFDC interfaces and Data model programs using Web Services API and Metadata.

Confidential Houston, TX

Business Analyst & Technical Architect

Responsibilities:

  • Responsible for the integration project of various CRM (Oracle Siebel, SFDC, Siebel CRMOD on Fusion) data integration with Oracle EBS which was part of the Oracle EBS implementation, which will drive the Sales, Marketing and all the back office operations.
  • This data conversion effort was from multiple source systems to one unified target system from where they will be source to Oracle EBS.
  • As SME, drive and support the team with all the functional knowledge for various CRMs, data warehousing and OBIEE reports.
  • Responsible for establishing scope, timeline, estimates, statement of work, staffing, execution & change management.
  • Worked closely with the various back office support teams to understand the current business requirements and for defining the new requirements.
  • Worked closely with DBA teams on designing of databases and capacity planning.
  • Designed interface layouts using Oracle PL/SQL & SQL server, Siebel, SFDC, CRMOD, Informatica & some third party tools.
  • In Siebel worked on Configurations, Administrations, EIM, eAI. Worked extensively in EIM or Enterprise Integration Manager.
  • In SFDC worked on Building Data models, building user interfaces, building business logics. Also worked on integrations using web services. Worked on various admin activities as well.
  • Review and integrate all application requirements, including functional, security, integration, performance, quality and operations requirements.
  • Review and integrate the technical architecture requirements
  • Create and provide weekly status reports to the higher management and escalate & resolve the issues and open cases in these status meetings.
  • Worked with SFDC APEX Data loader. Also created interfaces that work with different databases using JDBC connectors.
  • Worked with building SFDC applications using - Applications, Tabs, Page layouts, Record Types, etc. Also worked with workflows, validation & assignment rules. Worked on declaratives like - objects, fields and relationships.
  • Created inbound and outbound batch interfaces for SFDC using third party tools ForceAMP - DBAMP.
  • Created SFDC dashboard reports using report wizards.
  • Managed admin activities like creating and managing roles, relationships, approval process, etc. These are above managing users, profiles, security controls and data mangements.
  • Performed as SFDC admin and performed activities like accommodating multiple user, managing user experiences, controlling access to record level, automating business process, etc.
  • Worked with data management tools for SFDC - the import wizard and the web service API based tools.

Confidential, San Jose, CA

Technical Architect & Project Manager

Responsibilities:

  • Responsible for data conversion of the CRM migration project from Amdocs Clarify to Oracle Siebel for the Sales and Service applications and the development of interfaces from Siebel CRM to Oracle EBS & OBIEE and from various existing applications in the organization.
  • The data conversion effort was primarily from Clarify and deriving dependent data from various systems and the technologies used are Oracle Siebel Enterprise Integration Manager, Oracle PL/SQL and UNIX.
  • The real time interface effort was from various applications and involves Oracle Siebel eAI, web services using WSDL.
  • The reporting effort was from Oracle EBS to OBIEE and reports were generated from OBIEE.
  • Led a team of 22 people which includes EIM, eAI and BI. This includes onsite and offshore team members.
  • Worked with the DBA team on allocating servers, designing the database schemas and capacity planning for databases.
  • Worked with the various business teams to understand the business requirements and defining the scope & used cases.
  • In Siebel worked on Configurations, Administrations, Workflows, EIM, eAI. Worked extensively in EIM or Enterprise Integration Manager.
  • Designed the complete data migration frameworks for all the entities. Hands on including development on the complex entities including product configurations, Assets, etc.
  • Managed the coordination between customer, various field teams and 3rd party venders during major deployment activities.
  • Planned, and executed detailed service upgrade plan and procedures to ensure seamless transition and minimum customer service interruptions
  • Establish and maintain client relationship at the senior director and director level.

Confidential, Nashville, TN

SME

Responsibilities:

  • Responsible for the performance improvements, business process improvements for the existing Siebel Clinical applications.
  • Responsible for understanding the existing system architecture in place which the client was using Oracle Siebel eClinical, and providing solutions for the concerns they were facing for their business and optimizing the existing functionalities and improving performance.
  • Working on the PDQs and other areas in the Siebel CRM for fine tuning the performance of the application.
  • Work with the IT team and the business to understand the requirements.
  • Solution design includes new Confidential and database clustering for load balancing and introducing to new functionalities.
  • Designing various EIM schedule jobs in order to fulfill the requirements without changing the existing functionalities in the applications.
  • The new jobs include EIM jobs, PL/SQL procedure scripts, control files & IFB files.
  • Worked with the QA team to define validations.

We'd love your feedback!