Vishalakshi Krishnan

An energetic, results-driven and qualified Senior Business Analyst with nearly 12 years of rich experience in the banking, telecommunication, retail and health and life science spheres. Consistently demonstrated prowess in various areas including Reporting Qlik, Data modeling, ETL, DB, Data Integration and Architecture. Showcases profound experience in design, development, implementation, testing of applications and providing end-to-end support to the customers. Proven skills in Business Intelligence, Data Management, Asset Management, Administrations, Operations Support, Procurement and Documentation. Being a self-motivated and excellent communicator, possesses the ability to liaise across cross-functional teams. Strong ability to learn systems and processes at a fast pace and work independently. Proven skills in liaising with on-shore/off-shore teams whilst adhering to organizational process standards, regulations and compliance. Perceptive Senior Business Analyst with [Number] years driving successful business processes for [Type] companies. Dedicated to maximizing impact of key performance metrics to enhance and expand business operations. Known for leveraging both macro and micro-scale analyses to generate holistic images of ongoing business operations for immediate actionability.

• At Wipro Technologies, received the ‘Feather in My Cap Award’ and the ‘Archimedes Award’ for outstanding contribution in Shire Pharmaceuticals project
• Significantly reduced man hours taken to perform routine tasks by automating the complete process
• KEY AREAS OF EXPERTISE
• Business Analysis
• Collaborated with various users and stakeholders to collate the business requirements and translated them into technical specifications
• Acquired domain knowledge and subject matter expertise
• Implemented various Proof of Concept (POC) projects using various technical strands, singled the best approach to optimize costs and generated new business opportunities
• Project Management
• Established a safe working environment by implementing the projects in compliance with the application standards, policies and regulating guidelines followed by the organization
• Efficiently prioritized the implementation tasks to accomplish the desired results within the stipulated time
• Data Visualization
• Spearheaded the implementation of various data modeling, dashboards, visualization and reporting techniques using Qlik Sense and QlikView
• Effectively created qvd and qvf files using source systems such as Oracle, SAP and Excel and generated ad hoc reports
• Testing
• Performed integration, acceptance, dry run, performance and application testing within stipulated time and conducted verification checks to ensure that applications met the business requirements
• Ensured quality assurance prior to delivery to the end-users
• QlikView Business Analyst, Qlik - 2021
• ThoughtSpot Professional, ThoughtSpot - 2021
• Efficiently extracted, transformed and loaded data from multiple sources into QlikSense applications
• Exhibited documenting skills by fabricating various technical architecture/design documents
• Leveraged technical solution for QlikSense BI platform and orchestrated architecture/design sessions
• Mentored team members on project management and provided empirical training on technical scope
• Steered infrastructure activities such as server and data load configuration, granting access to end-users and designing authorization process
• Skillfully resolved technical issues faced by customers
• Optimized expertise in mobile implementation and firewalls, designing self-service processes, defining library of reusable objects like fields, KPI, and calculations
• Wipro, Netherlands, Hague Oct 2019 – Dec 2020
• Senior BI Consultant Client: T- Mobile Technologies
• Project Name: Data Architecture
• Key Responsibilities:
• Acquired expertise in handling various phases including architecture design, development, testing, deployment and maintenance using Qlik Sense and QlikView
• Scrutinized different data sources, reports and sub queries to analyze the requirements and subsequently created data models
• Effectively used Yarn for resource utilization
• Devised different framework managers to build queries, create users, schedulers and joins
• Responsible for end-to-end application design including architecture design, data modeling and data transformation
• Administered planning and development activities related to the dashboard and report implementation globally using QlikView Reports
• Methodically distributed data across multiple sources by implementing QlickView Load scripts
• Conceptualized new processes and procedures and improvised the existing processes for the smooth execution of the project
• Developed optimized scripts and proficiently used different kinds of filters, list reports, cross tab, subqueries and complex QlikView functions based on the project needs
• Identified the scripts that caused high consumption of resources and effectively altered them
• Administered the installation and setting up of QlikView servers and regularly monitored its performance
• Effectively created qvd and qvf files using source systems such as Oracle, SAP and Excel and generated ad hoc reports
• Utilized different QlikView components including List Box, Slider, Buttons, Multi-Box, Charts and
• Bookmarks to implement a dashboard with more visual and pictorial representations
• Used star schema and snowflake schema with appropriate dimensions to define the structure of Data
• Warehouse schema
• Extracted data from various data sources including SQL Server 2005, Oracle 10G, Excel and .csv files and loaded into QlikView applications by using linked tables and concatenation methods
• Monitored different Informatica administrative tasks including Cloud Services, Big Data Management
• Data Quality and PowerCenter
• Administered various software-related activities including development, deployment, enhancement, troubleshooting and service improvements
• Proficiently designed and implemented Data Recovery (DR) and Gluster FS in Informatica Linux servers in AWS
• Showcased expertise in designing, building and configuring Hadoop, Yarn and Hive
• Skillfully used Automic to develop predefined jobs, and automated schedules
• Also, implemented automatic restart of Automic agents and services on Unix servers
• Streamlined the upgradation of Automic applications and implemented disaster recovery setup
• Systematically configured Business Objects (BO) RA agent and utilized REST full API to create BO connections from Automic
• Triggered Informatica jobs from Automic after configuring the Informatica RA agent
• Maintained the database, fixed the identified defects and provided support for production and nonproduction environments while re-platforming
• FTPed files between systems and loaded data from files to the database by creating shell scripts in KSH
• Developed shell scripts and oracle procedures to perform extraction, transformation and loading of the data into the application database
• Proficiently utilized SAP BODS transforms such as Query, Validation, Merge, Case transforms to create queries and data flows within BODS
• Skillfully configured BODS components
• Deployed and upgraded applications built on Azure HDInsight
• Efficiently gathered requirements and implemented dashboards consisting three layers using QVD
• Trained, mentored and provided support to the end users
• Senior BI Consultant
• Vishalakshi Krishnan
• Senior BI Consultant
• Wipro, Bengaluru, Karnataka Oct 2015 – Sep 2019
• Role: BI Consultant Client: Shire Pharmaceuticals
• Project Name: Business Intelligence and Data Analytics
• Key Responsibilities:
• Orchestrated 3 executive dashboards development to represent sales and inventory data and systematically handled huge amount of data with volumes ranging from 20 to 50 million records
• Provided access to users, scheduled document refreshment jobs and deployed completed applications by efficiently handling QlikView Server
• Devised
• Publisher 9 to create PDF push reports and to set up email distribution
• Fine-tuned the performance of QlikView dashboards to minimize the response time to less than 5 seconds and redefined appropriate server sizing to achieve optimal performance
• Tata Consultancy Services, Bengaluru, Karnataka Dec 2013 – Sep 2015
• Role: Project Engineer Client: Gartner Technologies
• Project Name: Telecom Insights
• Company Description: Tata Consultancy Services (TCS) is an Indian multinational information technology (IT) services and consulting company, headquartered in Mumbai, India
• TCS is a global leader in the IT services, consulting and business solutions with a large network of innovation and delivery centers having a workforce of over 469,261 employees representing 147 nationalities across 46 countries
• Project Description: Telecom Insights is an Integrated campaign management application that provides telecom marketers the opportunity to deliver personalized marketing content and promotional offers to create dedicated experiences for Subscribers
• The application is intended to cater the campaign lifecycle
• Key Responsibilities:
• Spearheaded the development of 3 executive dashboards to represent sales and inventory data and handled huge amount of data with volumes ranging fromto 50 million records
• Provided access to users, scheduled document refreshment jobs and deployed completed applications by efficiently handling QlikView Server
• Devised
• Publisher 9 to create PDF push reports and to set up email distribution
• Refined QlikView dashboards performance to minimize the response time to less than 5 seconds and redefined server sizing to achieve optimal performance
• Proficiently designed and implemented Data Recovery (DR) and Gluster FS in Informatica Linux servers in AWS
• Created shell scripts to push or pull source files into the server, load files to landing area tables using SQL loader and populate metadata tables for proper data flow maintenance
• Ran campaign, performed scrubbing on the target list and broadcasted the campaign by executing scripts
• Implemented PL/SQL scripts/ procedures to load data from landing area tables to base tables
• Efficiently extracted, transformed and loaded data from multiple sources into QlikSense applications
• Implemented shell scripts to process ETL and extracted close to 2 million records per file data received from the client
• Skillfully fixed occurred ETL failures
• Infosys Technologies, Bengaluru, Karnataka Jun 2011 – Nov 2013
• Role: Project Engineer Client: ANZ Technologies
• Project: ANZ PeopleSoft
• Company Description: Established in 1981, Infosys is a NYSE listed global consulting and IT services company with more than 249k employees and clients across 46 countries
• Being India's second largest IT company, Infosys is using technologies such as machine learning, big data and analytics and artificial intelligence to map the learning ability of the employees and suggest training programs that best suit them
• Project Description: The scope was to merge New Zealand instance of PeopleSoft financials with the global instance, platform migration and technical upgrade of ANZ
• PeopleSoft instances from SQL Server to Oracle 11g, PeopleSoft Tools and application upgrade of Financials - eProcurement, Purchasing, Accounts Payable, Asset
• Management, General Ledger, Services Procurement, from 8.47.11/8.9 to 8.53/9.2 version
• Key Responsibilities:
• Technically upgraded the PeopleSoft instances (DB) from SQL Server to Oracle 11 G and steered the platform migration
• Provided warranty support for 90 days period from the date of go-live
• Created shell scripts/ PL-SQL scripts to automate data reconciliation and enhance data load plan for telecommunication campaign management
• Skillfully maintained maximum up-time and functionality by regularly monitoring servers, network connections, firewalls and corporate filters
• Prepared a detailed support document that enabled users to understand the system features and resolve issues themselves without support team intervention
• Established a healthy relationship with customers by providing effective solutions to the issues and also promptly escalated major issues to top management
• CONSENT STATEMENT
• I hereby give consent for my personal data included in my application to be processed for the purposes of the recruitment process under the Personal Data Protection
• Act as of 29 August 1997, consolidated text: Journal of Laws 2015, item 2135 as amended.

• Certified Product Owner ( CSPO® )
• Certified Scrum Master (CSM®)
• Study for the Certified Business Analysis Professional (CBAP®)