Candidates About

Sanjeev Bajpai

Summary:

• With 8+ Years Professional experience as a Business System Analyst/Project Manager with Auto, Media and entertainment industry.

• Good knowledge of Workflows and Content Management Tools.
• Superior writing and presentation skills as per international publications and presentations.  
• In-depth knowledge of all the phases within the Software Development Life Cycle (SDLC) such as Requirements, Analysis/Design, Development and Testing.  
• Good experience in Cognos Business Intelligence reporting and Planning 
• Expertise in reviewing requirements, Business requirements gathering, Data warehousing, evaluating data sources, translating requirements into specifications and application design.
• Demonstrated leadership in identifying and implementing appropriate technology solutions, application testing, Quality Assurance, specification gathering, team co-ordination, solving business problems, supporting company strategies while maintaining personal accountability.
• Excellent Training skills, facilitation, PowerPoint presentations, maintaining performance metrics, develop training manuals, documentation & communicating to users.
• Proficient with business intelligence technologies and methods.

·         Re Competent in full understanding of the functionality of core Oracle Financial Modules (GL, AP, AR, CE, FA, I-Proc, I-Exp) and their interplay in the application set-ups and overall accounting structure of an organization with its sub organizations.

·         Excellent knowledge in Component-based Development (CBD) and Commercial Off-the-shelf (COTS).

·         Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.

·         Performed data analysis by using SQL queries using the DB Artisan tool

• Proficient at creating and transforming business requirements into Software Requirements Specification (SRS) using Rational RequisitePro and designing business models using UML diagrams such as Activity Diagrams, Sequence Diagrams and Collaboration Diagrams in Rational Rose and MS Visio thereby helping the development and QA teams in understanding the requirements.
• Experience in conducting GAP analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements, User Acceptance Testing (UAT), SWOT analysis, Cost Benefit analysis and ROI analysis.
• Experience with Web Development E commerce projects.
• Extensive knowledge of Salesforce.com implementation cycle in Sales, Marketing, Service and support modules.
• Proficient at creating and transforming business requirements into Software Requirements Specification (SRS) using Rational RequisitePro and designing business models using UML diagrams such as Activity Diagrams, Sequence Diagrams and Collaboration Diagrams in Rational Rose and MS Visio thereby helping the development and QA teams in understanding the requirements.
• Exposed to Software Engineering Processes such as Personal Software Processes (PSP) and Team Software Processes (TSP).
• Highly efficient; Demonstrated superior time management and multi-tasking skills by accomplishing cross-functional tasks.
• Proven aptitude to work independently and within a team environment to meet project deadlines.

Technical Skills:

RUP, UML, SDLC, Waterfall, QA, WAP, MS Access, SQL Server, MySQL, PL/SQL, Oracle 11i, Windows 98/2000/XP, basic UNIX, HTML, basic DHTML, basic XML, Oracle I&AM, MS Office Suite-Excel Macros, Access, Pivot tables, Project, Visio, Adobe Photoshop,Cognos, SSIS,SSRS,SSAS,Flash, TOAD, Jira, Confluence, Wrike, Crystal Reports, Clear Case, Clear Quest, DB2, C, C++, BASIC, Visual Basic , ASP .NET

Professional Experience:

Penny Mac Financial Services                                                                                                                           Feb 2018 – Present

Sr. Business System Analyst

Responsibilities include Planning and led projects for Correspondent lending/Secondry Mortage market. Analyzing client systems, processes and to working with vendors to develop custom solutions. Led design and customization of systems. Directing complete software and system development life cycles.

• Providing BDL and CDL reporting to Business using SSRS tool.
• Functional Specifications and detailed design & Managed Software Development Life Cycle.
• Using Lending Space, Encompass and Correspondent potal for Audit data analysis.
• Working on SQL Server Management Studio using T-SQL query to extract data for analysis and reporting purpose.
• Working with Software Development, Quality Assurance and Release Management teams to deliver projects.
• Experience in documentation of business requirements and system functional specifications in the form of Use Cases. Produced Use Case models based on UML methodology & business process flow diagrams.
• Helping Developers to understand the business and system requirement.

American Honda Motor                                                                                                                                     Feb 2016- Feb 2018

Sr. Business System Analyst/Project Manager

Responsibilities includes technical lead responsible for supporting the design, development and implementation of software development solutions.   Working as a Global Connected Customer Experience IT Systems Analyst worked within a software development team/ Manging Business Team in US/Canada and Japan, directly collaborating with software developers, testers and software development managers.  As a Systems Analyst, I participated in all software development phases, including requirements definition, design, development, test and production deployment support.

• Liaison with Business stakeholders and Technical teams to drive the process of gathering and documenting functional/non-functional requirements and functioInal design from discovery through stakeholder approval
• Producing all SDLC required scope and high level design documentation, which includes Business Requirements documents, functional specifications, process models, use cases, wireframes, and UX design
• Participated in high level solutions and design reviews
• Served as a subject matter expert (SME) and provide guidance and clarifications for architect, technical, and QA resources
• Supporting the design, development, and implementation of leading edge telematics systems
• Defining/maintaining/promoting the vision and direction for Telematics projects.
• Worked with Production support to triage/identify the issue and provided stable solution.

DIRECTV(through Cignium Tech), Los Angeles, CA                                                                    Apr 2014 –Jan 2016

Lead Business System Analyst/Project Manager

Responsibilities include Planning and led projects for customers of large marketing and technology services firm. Analyzed client systems and processes and worked with vendors to develop custom solutions. Led design and customization of systems. Managed the design of databases for batch processing, transactional systems, and data warehouses. Directed complete software and system development life cycles.

• Consulted with Business and IT at DIRECTV and developed Functional Requirements..
• Functional Specifications and detailed design & Managed Software Development Life Cycle.
• Worked with Software Development, Quality Assurance and Release Management teams to deliver projects.
• Experience in documentation of business requirements and system functional specifications in the form of Use Cases. Produced Use Case models based on UML methodology & business process flow diagrams.
• Helping Developers to understand the business requirements.
• Manage the online Master Data Management request tool for new requests ensuring proper decision-making on master data creation, data standardization, duplication checks, data field accuracy and completeness while meeting acceptable turn around time. Complete large database cleanup projects to insure data integrity.
• Worked as a key player role in migration from OMS (Order Management System)  to Sales Force.
• Experience working in Product Life Cycle Management tool.  
• Performed Oracle Business ERP and Quality Analyst role throughout 2011 Roadmap and implemented and upgraded releases successfully
• In-depth knowledge of SharePoint 2007 and SharePoint 2010 platforms.
• Building eCommerce application on iPhone, Blackberry and Android phones for The Home Depot.
• Demonstrated ability to synthesize business requirements into system functionality within the SharePoint framework.
• Hands-on experience with WCF(Windows Communication Foundation)and WWF(Windows Workflow Foundation).
• Build DataSync job on Windows Azure to synchronize schools data from SQL 2012 databases to SQL Azure. 
• Design and Implement WCF services layer hosted on Windows Azure. This layer is the middle tier between SQL Azure and SharePoint online external content. 
• Create Cache Memory on Windows Azure to improve the performance of data transfer between SQL Azure and WCF services. 
• Worked on Veeva CRM application for Mutual of Omaha.
• Primary role involved analyzing and evaluating enterprise e-commerce solutions provided by leading software vendors like SAP, oracle, endeca and analyzing the feasibility of porting these solutions on different mobile phone platforms including iPhone OS X, linux mobile (LiMo), symbian, windows mobile, android.
• Worked on assessing, developing, and contributing to projects involving Oracle identity and access management (I&AM) solutions, including user provisioning, access control, authentication, and authorization.
• Setup and customeized COTS integrated business information systems.
• Performed Oracle EBS Functionality Testing of business requirements for Quality Assurances
• Knowledge of Oracle WebCenter Suite and Oracle Application Development Framework
• Extensive experience working in Order Management and SAP.
• Responsible for project planning and managing a full lifecycle COTS implementation of Identity Matching (Discovery through Production) using Initiate Master Data Service as subscriber data warehouse and identity matching engine.Developed Solution Architecture pertaining to overall Enterprise and Business Architectural models.
• Worked on Identity and Access Management COTS software.
• Worked with Mutual of Omaha on call center projects and worked on Strata dialer tool.
• Worked on wireframes and mockups using for application storyboards and development.
• Worked on enhancing the OMS History page project and used wireframe and Mockup tools.
• Identify client needs and develop customized solutions; this involves understanding primary objectives and implementing solutions to established budgets.
• Used Jira and Confluence tool to write requirement and maintain WIP board in Jira.
• Managed sprint in Jira Work intake board.
• Worked with Amdocs team on Simplified Billing project.
• Involved in preparing test cases and also involved in reviewing test plans and test scripts developed by QA team to make sure that all requirements are covered in scripts and tested properly.
• Updated the organization on the advancements of Cognos techniques for business Intelligence solutions
• Extensive experience working on Sales Force/CRM projects.

Environment: SQL, Jira, Confluence, PLM, XML, Noblesystem( Strata), WFM, NICE,Star UML, Power Mockup, Visual Studio 2013, C#, .Net. , SFDC, MS Visio, Quality Center, Uxpin, CA Clarity.

DIRECTV El Segundo , Los Angeles, CA                                                                               Sep 2012- March 2014

Sr. IT Business Analyst

Responsibilities include working with Customer Care and Field Services organization to manage all IT implementations in the Operations domain. 

• Working with business partners and IT stakeholders to elicit and document business processes and functional requirements 
• Perform Initial Assessments to IT initiatives to determine functional and IT impacts that becomes the basis for estimating ROM and ROI 
• Lead the effort to select a visualization tool to integrate visualization as a technique to validate requirements with the business stakeholders and explain requirements to the IT DEV teams 
• Lead analyst/manager responsible for implementing a new scheduling and routing software that would enable DTV to increase service levels to end customers, optimal use of technician availability based on skills and meet on time guarantee for end customers.
• Developed functional specifications and configured CRM to meet requirements.
• Proficient in all phases of Software Development Life Cycle (SDLC), which involves requirement gathering, requirement analysis, functional design, implementation and enhancement of projects on Salesforce.
• Presented to executive steering committee on a bi-weekly basis on the status of the scheduling and routing project 
• Migrate Marketing/Sales process to SFDC from the existing OMS system
• Responsible for the creation, reviewing and soliciting approval for the Solution Analysis Specification document Familiar with Syntellect Phonelink CTI salesforce application which is used to provide agents with click-to-dial and screen pop capabilities.
• Acted as a liaison between system users, client managers and software development team to gather requirements and document workflows and results of Business Analysis into the Business Requirement Document (BRD).
• Worked with SharePoint configuration through the web UI.
• Worked extensively in building models, projects and packages using Framework Manager. Created various kinds of Adhoc and Standard reports as per user requirements using Query studio and Report Studio.
• Responsible for triaging all production tickets to the appropriate business analyst within the BA organization and ensure production tickets are closed based on pre-defined SLA's. 
• Leading a team of Business Analysts in creating a Center of Excellence for adopting iRise as a requirements visualization tool in the IT lifecycle.
• Investigated business needs and underlined processes to gather and interpret data.

Environment:  MS Visio, MS Project, Cognos ,UML,SQL Server, PL/SQL,File manager, Sales CRM, CA Clarity,Quality Center.

Viacom Media Networks, New York, NY                                                                                                       Feb 12 –Sep 12

Lead Functional Business Analyst

Viacom is leading global entertainment company and includes popular brands like MTV, VH1, and Nickelodeon etc. The Media & Technology Services (MTS) group in Viacom is rolling out ITSM program which aims at re-designing the current processes based on ITIL framework and replacing multitude of applications currently in use with a single application “ServiceNow”. I work as a Business Analyst at Viacom

Responsibilities:

• Involved in requirements gathering and analysis in support of data warehousing efforts and data quality analysis for cleansing and developed ETL specifications.
• Design process flows using MS Visio
• Prepare Business Requirements Document (BRD), get respective sign offs
• Involved understanding the current business process, defining scope of the project along with position statement.
• Strong in Document Management, Record Management, Excel Services.
• Identify technical needs of the organization and accordingly develop Cognos based software applications

·         Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.

• Performed extensive Requirement Analysis including data analysis and gap analysis
• Acted as a liaison between the offshore development team and onsite business team
• Established Off-shore Project teams within PMO
• Used Jira to write reuirement and test cases.
• Administered and supported reporting tools to provide reporting, ad-hoc query and dashboard solutions and capabilities to end users. 

·         Prepared and documented System Requirements and workflows for the Content Management Application tool Interwoven.

·         Used Wrike to manage Project at a enterprise level.

·         Deployed UNIX, Windows NT, J2EE packages to servers located at HQ and stores.

·         Troubleshoot development and production failed packages and communicate offline end-points to appropriate support teams and developers.

·         Developed and prepared new and enhance existing Cognos applications.

·         Supported and assisted existing production Cognos Planning applications.

·         Developed and created procedures to administer Cognos Planning applications.

• Did data analysis, created data mapping and data interface documents and kept the documents updated with changes in requirements and functional specifications.
• Responsible for writing of SQL queries as procedures/functions at the back end which are called from front end form.
• Registering Reports, PL/SQL Procedures, Packages and creating executables.
• Worked with Oracle Support to resolve application issues, bugs and TAR/SR management

·         Assisted developers with website support in regards to Content Management to take control of the Web pages by managing the content as distinct from the design.

·         Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.

·         Perform Business Process Modeling using Visio. Perform customer data analysis.

·         Planned and conducted requirements elicitation meetings with the business to collect functional and non-functional requirements relating to client's Salesforce technology enhancement and initiatives.

·         Created various Standard and Custom Reports / Dashboards (summary reports, matrix reports, pie charts, dashboards and graphics) and Report Folders to assist managers to better utilize Salesforce.com and configured various Reports and for different user profiles

• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Created screen-mockups using iRise to review the requirements and provide feedback on the screen design. Also used Microsoft Paint to create ad-hoc screen mock-up to review with the users.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.

• Designed and Performed standard QA process to include creation and streamlining of new and existing Test Plans / Suites; Maintained DevTrack bug database.
• Designed financial reporting packages with Hyperion Reports and Hyperion Analyzer.
• Assisted PM with project planning, estimating, budgeting, resource allocation, collaboration and time capture using CA Clarity Project Manager
• Gathered requirements and helped design the GUI using IRise

• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application.
• Designed, developed and managed Hyperion system 9.3, 7.x applications - Essbase, Shared Services (security matrix
• Creating and managing site in Vignette application portal.
• Designed the UI (web interface) of the application, along with prototyping.
• Working with the architect, developers on business and technical issues, helping in designing of the system; and testers to ensure all requirements are correctly translated.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Creation of VCM Site, Channels and associated hierarchy
• Updated and modified progress and resources allocation in MS project for the team.  
• Created test plans, scripts and facilitated user acceptance testing.
• Ensured that the application met user and management expectations.
• Provided advanced functional knowledge of the GRC tool to business users and subject matter experts in the business teams in response to Internal Controls and SOX Compliance.

Environment:  MS Visio, MS Project, UML, Vignette Content management Tool ,JDE,CRM, Cognos ,SQL Server, PL/SQL, .NET, File manager, Filenet, Clear Case, CA Clarity.

Intelsat, Ltd Atlanta, GA                                                                                                                                   Jun 09 – Jan 12
Business Analyst

Responsible for identifying and documenting business/systems requirements for Intelsat, Ltd., a large provider of fixed satellite services with a global fleet of 53 satellites and seven owned teleports and terrestrial facilities. The system initiatives Ive worked on have enhanced the network provisioning process and streamlined the flow of information between Intelsats Network Engineering, Provisioning, Teleport Operations and Terrestrial Deployment Planning areas.  Ive been responsible for eliciting and analyzing functional and technical requirements of each group and to correlate them into Intelsats Big Picture application framework.  This framework greatly enhances Intelsats ability to provide superior customer service for its global customers, which include the world’s leading media and communications companies, multinational corporations, internet service providers and government/military organizations.

Responsibilities:

• Worked in all aspects of online advertising sales including lead generation, RFP responses, creation of account specific opportunity proposals, deal negotiations to campaigns delivery.
• Worked closely with team members to ensure that monthly runs ran smoothly and carried collaborate research efforts when there are exceptions or issue.
• Conducted meetings and invited System Analyst, Business Representative and Prototyper to allow different stakeholders to communicate their perspectives with each other, and thereafter documented Business Requirements using iRise Manager for final approval or for future discussion.
• Managed multi-million interactive advertising businesses with site-specific ad sales rep.
• Estimated and calculated company budgets, assessed sales forecasting and maintained sales records. 
• Supervised sales representatives and overlooked/delegated work to designers and web/software developers.
• Worked on a SQL Server 2008 Management/Development Studios to perform the data transformation and ETL procedures.
• Helped IT team to design, implement and deliver key file systm capabilities including indexed data stores,deduplications, compression,consistency checker and data recovery on failure.
• Involed in gather requirements ,analysis,design and development of filenet eprocess solution utilizing the Busienss Process Framework.

·         Managed and traced requirements iRise

·         Creating content type definitions and writing XML, SHTML and XSL for its rendering on to VCM Preview and Site

• Designed and developed Framework manager models, packages, metric packages, cubes, joined fact and master data sources by using schema concepts based on business needs.
• Extensively worked with CA Clarity PPM to communicate project status to the PMO and Directors
• Conducted customer service duties which included market forecasting, cost estimation, responding to clients inquires. 
• Worked extensively in Data Analysis, Data Reconciliation and Data Mapping for ETL process

·         Assigned tasks among development team monitored and tracked progress of project following agile methodology.

• Designed and developed project document templates based on SDLC methodology.
• Administrated work by recording, tabulating and filing sales transactions 
• Wrote the business requirements for reports and developed user-friendly templates to be loaded to Retained Portfolio Reporting Tool, a online report generation and viewing tool
• Worked closely with team members and project managers to ensure smooth progress of the project
• Involved in creating reports for the end users using Crystal reports from the gathered requirements.
• Used various modeling and documentation tools to facilitate efficiency and productivity in work.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the db2 database.
• Updated and modified progress and resources allocation in MS project for the team.  
• Suggested process and product improvements for the application.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Assumed ownership of Use Case Diagrams, Use Case narratives and other various artifacts

Environment: UML 2.0, Rational Rose, MS-Visio, Clear Case, CA Clarity,Clear Quest, Requisite Pro, Vignette Content management Tool,JDE, DB2, SQL

Education:

• B. S in Computer Science from Uttar Pradesh Technical University, Uttar Pradesh, India
• MS in Computer Science from New York Institute of Technology, New York, USA
• Cleared CFA Level 1