SUMMARY:

• Experienced as a Techno - Functional Business Systems Analyst with more than 8 Years of experience in Software Design and Development, Systems analysis, IT Project Management, Providing Solutions for the client, process management, business and systems requirement definition, data modelling, Salesforce, BI Reporting and Incident Management.
• Information Technology professional with more than 8 years of experience in delivering high quality systems for process improvement and technology implementation in International Payments and foreign exchange, Money Transfers, Cash Management, Consulting Services, Royalties, Media, Publishing and Entertainment, CRM business processes like Forecasting, Lead Management, Knowledge Management, Supply Chain Management and Credit Card(Banking) Services.
• Experienced in gathering Business Requirements, Data Requirements and converting them into Functional and Non-Functional Specifications and work with technical team to create, interpret and implement business rules into technical specifications/data design, data flow diagrams and data path diagrams.
• Well versed in conducting Gap analysis, Change Management, Joint Application Design (JAD) session, User Acceptance Testing (UAT) and working sessions to understand the requirements and systems design, process descriptions and workflow analysis at client’s site.
• Worked on analysing data needs, identifying relational databases and coordinating the modeling.
• Analysed critical financial data, identified trends/patterns relating to expense budget forecast, developed action plans, and implemented resolutions in a timely manner.
• Working knowledge with dimensional data modelling using ERWIN, data warehousing concepts, star schema/snowflakes schema, fact and dimension tables.
• Experienced in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Worked closely with project sponsors, program managers, project manager, business users and developers to formalize a business idea and define requirements using Rational Team Concert (IBM RTC).
• Provided the technical directions in various stages of SDLC such as Requirement Analysis, Technical Architecture, Design Specification, Development and Deployment.
• Strong in writing SQL queries and reporting the results to thebusinessteam.
• Excellent Team player to work in conjunction with testers (QA), developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects.
• Experience working with BI reporting tools like Qlikview.
• Good experience in working closely with the Architects in the Design phase to ensure the design and implementation of the solution meets the business needs.
• Functional Knowledge on ERP modules: General Ledger, Accounts Receivables and Payables, Order Management, Cash Management, Payee and Beneficiary Management, Inventory Management, Customer Service Management, Product Data Management, Consulting Services.
• Generated custom Reports, Dashboards andanalytical snapshotfor higher management and variousbusiness unitpersonnel to provide detail information on key performance indicators (KPI).
• Project schedule planning and project status tracking.
• Efficient use of Salesforce Custom Objects, Custom Fields, andFormula Fields, Field Dependencies, automated alertsandEmail templates, workflow rules, approval processes, sharing rules, validation rules as per client and application requirements.
• Hands on experience of implementing salesforce.com sharing and security model by using users, roles, profiles, public groups and permissions sets. Core experience of automating enterprise security model by using batch jobs.
• Extensive experience of automating complex business processes using salesforce declarative features such asworkflows, approval process, dynamic approval process, sharing rules, record type, custom objects, assignments rule, escalation rules validation rules.
• Created page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.
• Implemented pick lists, dependent pick lists, lookups, junction objects, master detail relationships, validation and formula fields to the custom objects.
• Possess comprehensive understanding of CRM business processes like Campaign Management, Lead Management, Account Management, Case Management, Quote, Forecasting and Call Centre.
• Skilled in customizing standard objects like Accounts, Contacts, Opportunities, Products, Cases, Leads as per client’s needs.
• Provided direct supporttoSalesForce usersduringpost-implementation issues.
• Strong programming experience inAS/400 SYON, RPG/400, RPGLE, CL/400, SQL/400 with effective High & Low Level Design, Module Design, Code- Reviews, Testing and Production Support.
• Excellent communication, negotiating, convincing and inter-personal skills and ability to address, analyse and resolve diverse and complex issues.

TECHNICAL SKILLS:

Industry Sectors: Payment Processing, Foreign Exchange, Financial Sectors, Consulting Services, General Counsel (Legal Services), Chief Financial Office, Royalties, Media, Publishing and Entertainment, Supply Chain Management and Credit Card(Banking) Services, CRM business processes like Forecasting, Lead Management, Cash Management, Beneficiary and Payee Management, Knowledge Management.

Domain: Banking, General Counsel, Royalties in Music, Publishing and Entertainment, Warehouse Management Systems, IT Consulting Services, Insurance and Credit Card Services.

: Bachelor of Technology in Electronics and Telecommunication

Operating Systems: Windows, OS/400, Linux

Data Bases: SQL Server 2012 and MySQL4.1, DB2/400, NoSql Cassandra

Tools: IBM RTC, WBS Chart Pro, SQL Server 2012, MS Visio, Igrafx, BMC Remedy, MS Project, ERWIN, Turnover, Implementer, SYNON, MS Excel, MS Powerpoint, Qlikview 11, Cherwell Service Management, BMC Remedy, Serena Business Manager, Salesforce Data Loader

Technology: MS BI, AS/400, RPG/400, CL/400, SQL/400, DB2/400, SYNON, PL/SQL, STRISDB, Salesforce, HADOOP, PIG, HIVE

Methodologies: Agile Scrum, Waterfall.

PROFESSIONAL EXPERIENCE:

Software Engineer

Confidential

Responsibilities:

• Act as business liaison to the markets group by collaborating with the analytics team to determine data and technology challenges and with Technology service providers to define and deliver appropriate solutions.
• Exceled as liaison between the trading desk and developers to expose informational, analytical, and workflow-optimizing needs.
• Involved in the creation and maintenance of the workflow plans and worked with portfolio managers to resolve issues encountered with the Order Management module of Global Pay..
• Solving production support bugs and solutioning.
• Good communication around issues and opportunities - get things done, make things happen
• Collaborating with senior management on client account management and growth
• Resolving deployment issues and coordination with Operations for deploying services in production.
• Preparing and sending out the weekly status report to the client and HCL managers.
• Communicating across organisational boundaries - from engineers through to senior managers
• Analysing the leads, cases and helping business users understand new implementation in salesforce.
• Working on the all new Bulk Payments Program using salesforce platform. The purpose of this program allows WUBS to provide a new product offering, tailored to pension and payroll payments. The ultimate goal is to deliver scalable and robust file upload and processing capabilities in CCT to support upto 15000 payments per file per client. This includes salesforce service cloud implementation of features like Order Initiation, enabling file level approval, submitting payments for approval on file level, approving payments using salesforce approval process, committing payments, file level summary, scheduled file level approval notifications and file upload failure notification.

BI Systems Analyst

Confidential

Responsibilities:

• Assist in the development, design and implementation of Qlikvew Applications. Serve as member of a project team or as an individual contributor when assigned.
• Involved in interacting with business users for requirements gathering and analyzing source data for enterprise reporting
• Assist in design of complex, global or strategic development projects using Qlikview as the reporting tool and SQL or Oracle as the databases.
• Analyzed data flow and business requirements to create High Level Design and Low Level Design document.
• Perform JAD sessions and get requirements for the BI reports to be built in Qlikview.
• Coordinate development activities, evaluate and report performance of project.
• Provide technical analysis and solutions to issues and technical direction.
• Utilize technical expertise to manage multiple assignments, including large and critical projects to assure timely and cost-effect objectives delivery.
• Schedule and prioritize work and plan a sequence of development activities that accomplish the planned targets. Set priorities and provide reports to the management.
• Mentor team members in design and analysis activities.

Business Systems Analyst

Confidential

Responsibilities:

• Organizing and driving RAC/JAD sessions which involves all business users, architects, testers, QA team, developers and performance testing team partners to map project requirements with Salesforce.com service cloud.
• Working closely with Confidential architecture team to gain an understanding of the vendor requirement and infrastructure, vendor portfolio/landscape.
• Work with change management team to deploy solutions to different environments (Test, QA and Prod), responsible for deployment of salesforce components.
• Work with architect, tech leads in analysis and design phase to come up with CDR (Critical Design Review)
• Work with Confidential Business SME to identify the cost benefit analysis of this framework installation.
• Mapping tables to integrate between workday and salesforce.com.
• Gather data requirements to integration between salesforce and Certain EMS system.
• Help Business Identify scope of work, streamline business requirements and help client project manager to finalise project budget by giving the WBS prior to 60days of project start.
• Convert business requirements to systems requirements and help developers, QA team understand the business problem so that they come up with coding task that meets the business requirements.
• Managing business and systems requirements for multiple projects simultaneously.
• Documenting the high level design decisions, prototype and transferring the functional and technical requirements to offshore development team.
• Regular interaction with offshore technical leads as well as Confidential architecture team, system administrative experts and Quality assurance team.
• Responsible for timely delivery of quality deliverables to Confidential .
• Derive and review of implementation rollout plan as well as rollback plan for emergency situations with key stakeholders.
• Preparing and sending out the weekly status report, dashboard and performance charts to various stakeholders.
• ConfiguredSalesforce roles/profiles, accounts, contacts, viewsandaccount planning.
• Organized review sessions with key stakeholders/development group to clarify on Business Requirements / Technical Requirements.
• Prepare Business Requirement Document & Project Functional and Non-Functional Specification Document and preparing the workflow diagrams, SIPOC, As-Is, To-Be and VOC.
• Prepare Project Plan, track the same with the team for percentage completion and report status to the Client Business Manager.
• Conduct UAT KICK-OFF calls with the users to ensure UAT is performed and Signoff are received from the respective business users
• Ensure UAT issues are resolved at the earliest by the development team and signoff are achieved from the UAT LEADS as per scheduled timelines
• Giving solution for automation of CRM processes like forecasting and planning.

Business Analyst

Confidential

Responsibilities:

• Liaison with customers to gather and define business requirements
• Organized review sessions with key stakeholders/development group to clarify on Business Requirements / Technical Requirements.
• Prepare Business Requirement Document & Project Functional and Non-Functional Specification Document.
• Defined the Primary Keys (PKs) and Foreign Keys (FKs) for the Entities, created dimensions model star and snowflake schemas.
• Prepare Project Plan, track the same with the team for percentage completion and report status to the Client Business Manager.
• Work with ETL team to make sure data is modelled & available in the DW tables that can be used by the SSIS Development team for developing reports
• Analyzing data sourced from other upstream system in ETL tables and doing data mapping of the data using SQL.
• Created Conceptual/Logical/Physical Data Models, with emphasis on Optimization techniques and Data Management for high volume transactions.
• Interact with technical team to provide clarifications of the requirements to ensure the data is captured correctly in ETL tables and reports and reports are developed as per the business requirement
• Testing the developed ETL tables and reports to make sure initial testing of the reports done before they are send for User Acceptance Testing.
• Conduct UAT KICK-OFF calls with the users to ensure UAT is performed and Signoff are received from the respective business users
• Ensure UAT issues are resolved at the earliest by the development team and signoff are achieved from the UAT LEADS as per scheduled timelines
• Prepare/Distribute Release Notes which mentions the status (SUCCESS/FAIL) of the various releases and brief the s releases.

Systems Analyst

Confidential

Responsibilities:

• Performing role of Software Engineer/Consultant/Domain Specialist (Royalties)/Requirements Analyst, Requirements Management, Consulting, Project Management, technical analysis, debugging, data management, testing, peer review, Incident Management, Risk Analysis and Quality Assurance.
• Gathered requirements from the business and worked with business team to plan and prioritize changes, Enhancements and implementation.
• Preparing business process maps and functional specifications for music - royalty business processes.
• Strong skill set in running a dispersed team includes communication, and analysis skills.
• Directed offshore application team for both US and UK Royalties Systems, for support issues, code changes, Quality Control and Release implementation.
• Led the transition of entire ERP maintenance and enhancement operations from existing EMI team to HCL Technologies in New York, USA and help the company realize a multimillion dollar engagement.
• Performed the process of creating data element mapping between two distinct data models for the purpose of data integration, data consolidation and data masking projects.
• Controlled change management, user setup and authority to ensure Audit compliancy using SBM tool.
• Work closely with the global IT teams regarding implementation, support and enhancements.
• Adhere to and develop change management processes to synchronize with the SDLC process.
• Conducted Impact analysis of different change requests.
• Production Support and Developed Code using AS/400 SYNON technologies. ed Live Wire and Innovation from EMI by saving time in overnight, weekly and Monthly batch job schedules, by redesigning and directing efficiency changes for UK Royalties batch. This service improvement brought 66 % more efficiency to the batch job process.
• Led a two day workshop to Business and IT Heads of EMI Music on existing business flows and future use of innovative IT Royalties Solutions for their business at New York, USA. Received appreciation from CTO of EMI Music and Vice President of HCL Tech. on Successful completion of the business workshop.
• Received numerous Client Accolades because of dedicated, sincere and focused work

Software Engineer

Confidential

Responsibilities:

• Data Analysis, Solution Design and ensuring sign offs by business and other project stakeholders.
• Accountable for controlling and maintaining inventory levels and system transactions for the NIKE warehouse distribution facility.
• Involved in the process improvement of inventory control and warehouse operations which includes 20 million units and over 75,000 SKU’s.
• Implemented barcode technology and automatic picking systems which credited with increasing inventory accuracy rates from 90% to 99.5%.
• Directed workflow and financial warehouse operations from scheduling daily workshops to planning and managing inventory control functions pertaining to material receiving, stocking, picking and shipping. Responsible for the tracking and reporting of cost forecasting, planning and budgeting.
• Reduced order fulfillment time by 50%, increased monthly warehouse productivity levels from 90% to 99%.
• Managing the requirements right from Requirement Gathering phase till roll out of changes to LIVE environment.
• Managed data requirements and process developments with business units and outside consultants.
• Participating daily triage calls on the defects resolution based on severity levels.
• Assign defects & remedies to development at offshore.
• Organizing meetings (Status Reporting) between clients, different stakeholders and vendors.
• Doing the impact analysis using the SYNON case tool.
• Helping the development team in fixing issues using batch and interactive debugging with the help of STRISDB tool.
• Tracking the remedy tickets and monitoring the tickets SLA.