Work History
Sep 2011 - Present

Senior Business Analyst (Business Intelligence/ Data Modeller)

AIRCOM International India Pvt. Ltd.
  • Working on AIRCOM International, Performance Management (ETL) Tool OPTIMA which enables mobile operators to manage the network performance data provided by their networks, enabling them to successfully manage and optimise network quality, plan future traffic trends and diagnose the root cause of network performance issues.
  • Documenting & reviewing Business Requirement Doc. (BRD) & Functional Specification Doc. (FRD) for prospective clients.
  • Interface with stake holders and facilitate communication between client and the Development department.
  • Involved in creating targeted questionnaires and interviews for SME’s, clients and business users to gather requirements.
  • Extensively experienced in organizing, doc’s requirements, preparing user cases, writing business docs, reports in Pre- Testing phase.
  • Developed data flow diagrams, flow of data from Legacy systems in Application DB Tables, generate checkpoints for testing/ verification.
  • Prepared use case documents and utilized MS Visio to create UML diagrams including use case, activity and class diagrams to extract business process flows and workflows, thereby assisting development and quality assurance teams in understanding the requirements.
  • Developed a user acceptance test plan and test case scenarios to guide a select group of key end-users in testing the user interface and functionality of the application. Forecasting with the help of R Tool.
  • End User customer satisfaction accountability using CEM methodologies post project delivery and also gain new prospective business.
  • Studied in-house requirements for the Data warehouse to be developed
  • Conducted one-on-one sessions with business users to gather data warehouse requirements
  • Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
  • Developed a Conceptual model using Erwin based on requirements analysis
  • Developed normalized Logical and Physical database models to design OLTP system for insurance applications
  • Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
  • Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
  • Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models
  • Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis
  • Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
  • Responsible for defining the naming standards for data warehouse
  • Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems
  • Exhaustively collected business and technical metadata and maintained naming standards
  • Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
  • Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges
  • Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
  • Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
  • Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
  • Integrated the work tasks with relevant teams for smooth transition from testing to implementation
Aug 2010 - Aug 2011

Team Leader at 1st Level Assurance in Analytics

Ericsson India Global Services Pvt Ltd, Gurgaon
  • Responding to RFP's requested from the clients to calculate Resource utilization, Man Hours Required, Competence involved, budgeting, identify scope, development layout, risk involved and prospective support. Documenting the project details in a formal contract (SOW) which includes detailed objective, pricing, timelines, terms & conditions. Project planning and management.
  • Responsible for developing and strengthening client relationships while meeting and exceeding profitability and revenue goals.
  • Working closely with the clients to understand the scope of work, feasibility and timeliness of different projects.
  • Worked with business users to define product feature requests, business requirement specifications, and change requests; documented requirements and transformed them into functional and technical requirement specifications; modelled business process flows using UML, activity and sequence diagrams.
  • Conducted one-to-one meetings and web-Conferences as well as JAD sessions with different stakeholders; analysed and came up with suggestions providing consistent process for the communication, escalation, and resolution of issues.
  • Managing schedules while working with multiple teams.
  • Documenting artefacts including, but not limited to, Functional Specifications, and the Use Case Specifications.
  • Worked on multiple projects with different business units including IT/ Telecom actuaries
  • Gather the various reporting requirement from the business analysts.
  • Gather all the Sales analysis report prototypes from the business analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.
  • Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
  • Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
  • Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.
  • Created and maintained the Data Model repository as per company standards.
  • Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
  • Ensured the feasibility of the logical and physical design models;
  • Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
  • Worked on the Snow-flaking the Dimensions to remove redundancy.
  • Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically
  • Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase
  • Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic
  • Created ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server using SSIS.
May 2009 - Jul 2010

Analyst- Performance Management at Global Network Support Centre (GNSC)

Nokia Siemens Networks, Noida, India On Payroll of Kelly Services India Pvt Ltd.
  • Daily issue handling with related to KPI degrade and smooth Deliveries as per the current agreed contract of MS for MIS Reporting.
  • Preparing weekly & monthly Dashboard for customer based on different category of issues.
  • Tracking the customer complaints on a daily basis and closing the issues by coordinating with various teams.
  • Preparing weekly & monthly Dashboard for customer based on different category of issues customer Interfacing, Emergency Support, Measurement data provisioning, Inter department Support. Daily issue handling with related to KPI degrade and smooth deliveries as per the current agreed contract of MS for Reporting.
  • Analysing the data collected from various databases, news & articles using various tools and presenting the key findings in word or power point format. Interacting with customer and gathering the requirement as per contract and implement in the tool for the same within SLA.
  • Conducted major stakeholder interviews involving SME’s, Business Analysts and other stakeholders to determine the requirements.
  • Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
  • Identified and compiled common business terms for the new health care system that become central part of communication among project stakeholders to avoid ambiguity
  • Worked at conceptual/logical/physical data model level using Erwin according to requirements.
  • Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions
  • Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use
  • Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design
  • Developed the required data warehouse model using Star schema for the generalized model
  • Used forward engineering approach for designing and creating databases for OLAP model
  • Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business
  • Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP
  • Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
  • Developed and maintained data dictionary to create metadata reports for technical and business purpose.
  • Created action plans to track identified open issues and action items related to the project.
  • Prepared analytical and status reports and updated the project plan as required.
Oct 2007 - Apr 2009

Engineer (Operations Support/ Data Modelling)

Ericsson India Pvt. Ltd., Gurgaon, India On Payroll of CadTech Consultants.
  • Calculating and analysing various switch KPI’s.
  • Statistical Performance Management of Radio Network using Business Objects XI.
  • Analysis of different CF (Network element related) Alarms and there solution.
  • Preparing MAPA (Management Accounting & Performance Analysis) Report, Radio, IN/ SS outage report for different circle.
  • Accurate generation of CDR reports for billing reconciliation.
  • Examine various performance Stats related to Basic traffic, ASR, No.7 link traffic, etc.
  • Provided analysis support for defects and/or incoming incidents or user requests.
  • Responsible for evaluating and understanding Business Requirements.
  • Provided application support during the build and test phases of the SDLC for their product.
  • Responsible for reporting status regarding assignments to the System Analyst Lead for their product.
  • Provided Subject Matter Expertise to System Analyst Leads, Developers and Testers.
  • Provided feedback to the System Analyst Lead on potential future improvements for the product.
  • Participated in defect resolution and coordination.
  • Provided investigation and root cause analysis support for operational issues.
  • Served as one of the authors for Integration Test Specification.
  • Handled Code reviews of the component to reduce the bug density of the component


Aug 2003 - Jul 2007

Bachelor of Technology | 2007

Specialization: Electronics and Communication Engineering


With my current skill-set and knowledge combined with regular professional training, I aspire to emerge as a successful Business/Process Data Analyst (Business Intelligence) in Enterprise IT/ Finance Domain. I would like to join an organization that gives me an opportunity to showcase my skills and also helps me gain practical exposure in business sector.


  • Date of Birth: 18th October 1983
  • Mother’s Name: Mrs An Naik
  • Father’s Name: Mr Rajeshwar Naik
  • Marital Status: Married
  • Nationality: Indian
  • Languages Known: English, Hindi.
  • Passport Number: J7837943 (Valid Till 12th Dec 2021)
  • Permanent Address: “SHAILAGAR”, Opp. SBI Officers Colony, Devi Mandap Road, Ratu Road, Ranchi -834005
  • Strengths: Good Communication- Skills ‘Can- Do’ attitude and like to do assigned tasks in systematic and organized manner.


Mar 2015 - May 2015

Successfully received and pursuing:

Inter Organisation, PMBOK, NSE
  • ACE Award for highly efficient work for the year 2010-11 in Ericsson India Global Services Pvt. Ltd., Gurgaon
  • Star Performer Award for innovative work in 2014
  • Awarded Employee of the month in 2014 for Successful release/ deployment of Optima Upgrade for AT&T/ US Cellular
  • Consistent appreciations from Managers, Clients & Immediate Seniors for outperforming work
  • Certification in Microsoft Excel for Business Professionals
  • Gained PDU’s and pursuing Certification in PMP (PMBOK Guide)
  • Pursuing Certification from National Stock Exchange on Financial Modelling. 


References are available upon Request.





Data Modelling/ ETL/ Business Analyst (Business Intelligence)

  • People Soft Version 8, Toad, Power Centre 6.0 , Case Management System, BI Tools (ETL) , XML
  • OS: MS Windows 7, DOS, UNIX, Solaris
  • RDBMS: MS Access, SQL, PL-SQL, Oracle, Informatica, Big Data- Hadoop
  • Modelling Tools: Rational Rose, Mainframes MS Visio, Erwinr7
  • Tracking Mgmt.: Test Director, Rational Clear Quest, ReqPro, CEM
  • Analytics & Reporting: JIRA, QTP CRM, R Tool, Business Objects XI
  • Telecom Tools: Citrix, ENIQ, Trouble Tickets using Remedy
  • SDLC: Rational Unified Process, Waterfall Methodology, Agile
  • S/W Tools: MS (Excel/ Word/ Power Point/ Project/Dreamweaver)


  • Excellent Communication Skills
  • Business Process Improvement
  • Forecasting and Planning
  • Advanced Excel Modelling
  • Cost Benefit Analysis
  • CA ERWIN r7
  • Budgeting & Project Mgmt.
  • Project Lifecycle & SDLC.
  • Case Management System
  • Toad, SQL Server
  • MS Visio Business Objects XI
  • JAD Sessions
  • Requisite Pro
  • R Tool
  • Solaris/ Linux
  • Mediation, XML


  • 7+ years in Information Technology with Expertise in Data modelling for Data Warehouse/Data Mart development, Data Analysis for On-line Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
  • Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management, OBIEE.
  • Involved in various projects related to Data Modelling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
  • Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
  • Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
  • Practical understanding of the Data modelling (Dimensional & Relational) concepts like Star-Schema Modelling, Snowflake Schema Modelling, Fact and Dimension tables.
  • Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
  • Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
  • Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
  • Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
  • Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
  • Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
  • Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
  • Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standard datatypes, volumetric, domain definitions, and corporate meta-data definitions.
  • Exceptional communication and presentation skills and established track record of client interactions
  • Seasoned professional, with planning, implementation, monitoring and resource balancing skills and ability to handle multiple functions and activities in high pressure, globally oriented environments.
  • Expertise in telecom Managed Services, Service Fulfilment & Service Assurance, e-TOM, MS-TOP).
  • Proficient in all phases of Requirement Management, including gathering, analysing, detailing and tracking requirements.
  • Experienced in documenting requirement using Unified Modelling Language (Use Case and Activity Diagrams) also building business Process Flow Charts using tools such as MS Visio.
  • Skilled at reviewing test cases making sure they are in accordance with requirements, and assist the overall testing process by activities such as Change and Defect Management and conducting User Acceptance Testing.
  • Strong understanding of various SDLC methodologies such as RUP, Waterfall and Agile with hands on experience in all of them.