Business Process Designer

• Telecom Consulting, Requirements Gathering, Business Analysis, Post-Implementation Support for Orange, Belgium Telecom• Ensuring delivery of E2E BSS functional and non-functional solution designs timely and in close alignment with Business scope, network and process design, systems/platform and portfolio architecture. • As a design assurance, ensuring the designs are up to standard and in line with strategic systems solutions for cross-products/LOBs.• Providing solution in the field of End-to-end Telecom stack (BSS/OSS - CRM, Middleware, Billing and Provisioning system) and its integration with network (Charging system, Mediation)•Advising business in an End-to-End scenario stretching across the functional domains of BSS & OSS in Telco Space and have very good understanding of Order Management (Lead to Cash) and T2R (Trouble to Resolve) processes. •Knowledge of Greenfield and Brownfield sites in telecom (BSS/OSS)•End-to-End Knowledge of Telecom Systems Integration which covers Service Assurance and Service Fulfilment area•Have experience on Ericsson products like BSCS and Ericsson charging System•Modelled BPMN, Sequence diagrams in Microsoft Visio 2013

• Focus on meeting project commitments, including communications with sponsors, stakeholders.• Deliver project outcomes to meet the defined success criteria• Have good understanding of project delivery and quality gate acceptance processes within a fast paced, Agile Business environment.• Solution designing of Russian Authority Traffic using Encrypted Flat File. • Solution designing of new CRs on Web-VPN and iWAN (Internet Wireless Access Network)• Model product based frameworks in Oracle BPA. • Model Quote to Order Journey in IBM RSA tool• Perform Detailed Discussion on component & process design• Create Design Summary as per requirements• Update Microsoft Share-point for Design Deliverables• Component and Test LLD Review and Approval• Perform Early Life Design Review• Accomplish OSS Design (creation & review comments incorporate)• Clear understanding of NGOSSbusiness solution framework - New Generation OSS/BSS solutions, NFV (Network functions virtualization) network architecture, SDN (Software Defined Network)• Determine system architecture requirements to achieve business goals.• Formulate strategic plans for component development to sustain future project objectives.• Gather detailed business requirements and use cases, and translate technical specifications into product requirements.• Create team strategies and establish project scopes of work; communicate project deliverable time-frames and benchmarks to clients. • Develop data architecture design to facilitate targeted customer analysis.• Suggest architectural improvements, design and integration solutions, and formulate methodologies to optimize object-oriented software and database development.

I have Experience in eTOM process and ITIL practice for process mapping, gap analysis for enhancing Operational Excellence. • Involved in QMG activities• Involved in PMO activities• Involved in monthly Resource and Audit related activities• Monitor progress against agreed milestones and provide regular updates to all stakeholders.• Lead the development of project plans to identify project tasks, deliverables, milestones, and resourcing requirements for internal and external teams• Carrying out gap analysis for various source systems which is the first step of any new work package. I am also, involved in creating LLD for Change Requests and new Work Packages. I have been working on Agile SDLC since joining the project.• Knowledge of Telecommunication modeling and OSS implementation process.• Experience in interacting with clients and end users for requirement gathering, system analysis, feasibility study and application enhancement and conducting system study and coordinating with team members for System Design & Integration, Application Maintenance, etc.• Performed extensive GAP analysis in the project as there numerous ‘As-Is’ and ‘To-Be ‘conditions.•Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently•Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Server•Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.•Restricted data for particular users using Row level security and User filters.•Developed Tableau visualizations and dashboards using Tableau Desktop•Developed Tableau workbooks from multiple data sources using Data Blending

• Used project scheduling and control tools to monitor projects plans, work hours, budgets and expenditures • Performed Business analysis for ensuring data rules are properly maintained. • Work with customer business users and the software development team to identify, document and correct data quality issues. • Involved in Master Data Management and ETL Migration.• Recommend enhancements to the data acquisition processes to improve accuracy of the data model. • Develop, document and maintain data quality goals, standards, and processes. • Contribute to the tracking and resolution of bugs • Assist in maintaining the customer relationship by aiding in the investigation and resolution of customer specific issues.•Built BI reports, models, dashboards and templates for inventory optimization•Created metadata models, used data extracted from multiple DBs, created joins and cardinality, created filters, calculations, conditions and layouts, developed imports/exports to deploy reports and implemented access management.•Designed Drill-through reports• Extensively worked on Cognos 8.4 (Query Studio and Report Studio) as report developer• Defined Prompt Page and maintained Report Studio of the projects

• Great customer interfacing skills and customer orientation.• Co-ordinating with cross-functional teams in different locations for quality Business analysis

• Assuring the integrity of project data, including data extraction, storage, manipulation, processing and analysis. • Discussing business intelligence needs or information with external clients and internal designers and participating in ongoing decisions concerning data collections, study design, methodology, and data analysis. • Coding accurately variables from original information or data and completing statistical analyses as required.• Responsible for all activities related to the development, implementation, administration and support of ETL process for large scale data warehouses using Informatica Power Center.• Strong experience in Data Warehousing and ETL using Informatica Power Center 8.6.• Experience in data modelling using Star Schema Modelling, and Snowflake modelling, FACT and Dimensions tables, physical and logical modelling.• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.• Worked with filter transformations and flat files to identify source and target bottlenecks• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modelling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.•Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.

• Handled Client escalations and reduced customer expenses due to order failures, hence ensuring the overall annual budget• Making changes in the existing stored procedures for change in business rules and tuning Sql queries for faster bulk loading• Coordinating with BT management for understanding of requirement• Create ETL IBM-Datastage parallel jobs to extract and reformat the source data so it can be loaded into the new data warehouse schema• Worked with objects in IBM Information Server Repository like jobs, sequences, parameter sets, routines, shared containers and table definitions.• Extensively Used Datastage (ETL Tool) , Oracle PL/SQL, UNIX, MS Products to Extract, Cleanse, Transform and load data to target systems with right format and level of detail.• Architect, Design and Develop all ETL components including using IBM Information Server, Web Services components, InfoSphere Datastage and QualityStage.• Create all the extract jobs to pull the data from the webservices by understanding the limitations of the service links.• Architect and design the whole ETL process from end to end.• Created process and data lineage diagrams.• Designed and Developed DataStage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse Databases.• Worked with Metadata Definitions, Import and Export of Datastage jobs using DataStage Manager.

I am currently engaged in Business Consulting, Requirement Gathering, Business Analysis and Solution Designing of projects for Tech Mahindra Ltd. I have over eleven years of Telecom experience in the analysis, design, implementation, planning, development and deployment of full life cycle of software applications. I constitute proven project management competences and demonstrable knowledge of project management principles, tools and techniques leading to successful project delivery.

• Implementation of data sync component's deliveries between tactical & strategic route. • Involved as an implementer in different phases of Data migration: analysis of source data, extraction and transformation of data, validation and repair of data, and use of data in the new program. • Making changes in the existing stored procedures for change in business rules• Co-ordinating with BT management for understanding of requirement