Developer Teradata
Resume:
Lavanya Kotaru
linkedin.com/in/LavanyaKotaru
************@*****.***
PROFESSIONAL SUMMARY:
8+ years of IT experience in software development, documentation, designing, and requirement gathering with major focus around Business Intelligence, Data Warehousing and Database Applications.
Good domain knowledge on Banking and Finance industry.
Expert in MicroStrategy and hands on experience on Abinitio, QlikView, Tableau.
Work on designing, developing and implementing Enterprise Management application throughout the lifecycle of the project using MicroStrategy Suite 11.x, MicroStrategy Desktop, MicroStrategy Web and Teradata.
Extensively worked on Desktop to create Applications Objects, Reports and Dossiers (Documents & Dashboards)
Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
Generated reports using Advanced Metric objects, Filters, Prompts and created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
Expert at Planning, analysis, design and development of complex reports and scorecards for several business units.
Hands on Experience in Creating Dashboards and Dossiers from multiple Datasets like Grid and Graph.
Heavily worked with the end users to finalize the Dashboard layouts and worked on fine detail formatting for a desired look and feel on dashboard layouts.
Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
Experience in designing, developing, debugging and enhancing reports by following business rules using MicroStrategy desktop and MicroStrategy web.
Worked on MicroStrategy administration including intelligence server administration, configuration of memory settings, performance monitoring and VLDB settings.
Experienced in working with different databases like Teradata, SQL Server, Oracle and Toad.
Good knowledge and understanding in translating business needs into end-user reports.
Ability to rapidly learn new concepts together with excellent interpersonal skills. Very flexible and can work independently as well as in a team environment.
Management skills include Team Management, Leading projects, Project Planning, Monitoring, and self-starter with good communication skills and ability to work independently and as part of a team.
TECHNICAL SKILLS:
Business Intelligence Tools: MicroStrategy 11.1x, 2019, Tableau, QlikView
MicroStrategy Components: MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Web and Admin
Databases: Oracle 11g/10g/9i, Teradata, DB2, SQL Server
Operating Systems: Windows Servers, UNIX and Linux
CERTIFICATIONS:
MicroStrategy 2020 Certified Architect (MCA)
MicroStrategy 2020 Certified Analyst (ANL)
EDUCATION:
Pursuing Master of Information Technology from Westcliff University since Aug 2019 to till date
Completed Master of Business Administration (MBA) from Vels University in 2010
PROFESSIONAL EXPERIENCE:
Employer: Infoyuga Technologies Inc
Client: AT&T Oct 20– Till Date
Role: ETL Developer
Responsibilities:
Performed the building Teradata Scripts
Performed Data validation in Teradata
Performed Autosys Job triggers
Performed Informatica Workflow Design and Worklet Design
Performed Data unloads and loads from Prod to UAT and UAT to DEV by using Unix commands
Performed File placements and executing Insert/Delete statements in PROD environment by using Unix
Involved on identifying Root Cause analysis for Job failures
Involved extensively in the overall life cycle of the Data Warehouse integration project
Employer: IBM India Pvt Ltd
Client: Citi Bank Jan 17– May 19
Role: Application Developer/L2 Support
Responsibilities:
Performed Intelligent Cube Manual triggers
Performed Batch file creations
Performed Autosys Job triggers
Performed Manual cube loads from developer
Performed data validations in Sybase
Performed Data unloads and loads from Prod to UAT and UAT to DEV by using nohup commands in Unix.
Performed File placements and executing Insert/Delete statements in PROD environment by using Unix.
Involved on identifying Root Cause analysis for Job failures.
Responsible for efficient design and usage of various attribute dimensions like Spend Visibility, Vendors, Contracts and Time dimensions, and integrating them into reports displaying Invoice and PO metrics.
Develop new change requests, fixing defects in and enhancements from the business
Preparation of Test Cases, Unit testing of report and Support UAT & Production environments
Performed quality assurance for the design, development, and testing of system enhancements
Environment: MicroStrategy 11.1, MicroStrategy 2019, Unix,
Employer: Cognizant Technology solutions India Pvt Ltd, Bangalore, India.
Client: CCC Information Services Inc., U.S.A. Jan 15 – Dec 16
Role: MicroStrategy Developer
Responsibilities:
Design, develop, debug and enhance reports using MicroStrategy Desktop and MicroStrategy web.
Performed QA and Production Testing.
Performed Integrity Manager Testing
Performed Data Validation by writing the SQL queries
Created MicroStrategy Views and Map them to Metadata
Design source to target mapping in compliance with all business rules, create schema objects (attributes, facts, hierarchies, transformations), Create applications objects - filters, metrics, prompts, reports, report services documents, templates.
Develop Reports and business intelligence solutions on the web using MicroStrategy Distribution Services.
Perform code reviews and guiding the developers for quality and timely Deliverables.
Quality assurance for the design, development, and testing of system enhancements.
Extensively worked using MicroStrategy web environment and created VI dashboards and Documents.
Responsible for gathering and refining business requirements from the Business Analyst for Overall performance dashboard.
Designed Schema and Public Objects as per the report and Dashboard requirements.
Developed reports and Dynamic Dashboards to support the client in decision-making.
Creating all kinds of metrics, filters, reports, custom groups and consolidations.
Performed Detailed analysis on queries to find out the data mismatch and Extra records in reports.
Monitor the Dashboards the execution time in Production, Stage and web environments.
Prepared detailed document on dashboards and Supporting Grids execution startup and End time.
Prepared the test cases for conducting unit testing of the reports and documents.
Performed unit tests of all reports in DB2 and Teradata SQL Assistant.
Performed quality assurance for the design, development, and testing of system enhancements.
Environment: MicroStrategy 10.7, MicroStrategy Web, SQL Server, DB2, Teradata
Employer: L&T Infotech Pvt Ltd, Chennai, India.
Client: Citi Bank, U.S.A. Jan 14 – Dec 14
Role: MicroStrategy Consultant
Responsibilities:
Extensively worked using MicroStrategy web environment and created VI dashboards and Documents.
Responsible for gathering and refining business requirements from the Business Analyst for People planning dashboard
Tested the reports in the UAT environment along with the power users.
Analyzing the change request and preparing the impact analysis document
Involved in the complete Life cycle of the Project from development, testing, pre- production and production environments.
Improving the performance of the reports by modifying schema objects and removing unused Metrics from reports
Extensively worked on creating Dynamic Dashboards with multiple panel’s stacks and along with widgets and
Different graphs.
Developed Intelligent Cubes and used as datasets for dash boarding and extensively used data import functionality.
Prepare Artifacts like Best practices, Estimation templates, timelines, test cases and Server Architecture Documents
Worked in the development team on the new change requests, fixing defects in MicroStrategy reports and enhancements from the business.
Designed Schema and Public Objects as per the report and Dashboard requirements.
Developed reports and Dynamic Dashboards to support the client in decision-making.
Creating all kinds of metrics, filters, reports, custom groups and consolidations.
Preparing Migration list and sending list of objects to deployment team to make on time migrations.
Provided technical support, responded to error reports, problems or questions, and adhered to defined SLA's for project delivery.
Environment: MicroStrategy 10.2, MicroStrategy Web, SQL Server
Employer: CGI India Pvt Ltd, Bangalore, India.
Client: Deutsche Bank., U.S.A. Apr 13 – Dec 13
Role: MicroStrategy Developer
Responsibilities:
Extensively worked using MicroStrategy Developer, Administration tools.
Involved in the complete Dashboard development, testing, pre- production and production environments.
Report development
Design, development, testing and deployment of dashboard.
Preparing the test cases for conducting unit testing of the reports and Dashboard developed
Interacted with business users (Customers on regular basis to know the business requirements and provide technical assistance regarding problems and giving them training about the tool.
Monitored the performance of reports and reporting applications after implementation
Participated in the end user meetings to obtain the business requirements for creating the Dashboards
Participate in daily status and weekly planning meetings.
As per business requirement, designed developed and maintained MicroStrategy based reports.
Daily Status updates to the respective Application Owners. Along with the development, always need to make sure no issues will occur from the production servers.
Weekly status review with client. Identify potential development opportunities and propose innovative solutions. Efficiently handle and Manage production support activities through Incident Management.
Expert in creating Public Objects like (Metrics, Filters, Consolidations, Prompts, ICUBES, Documents, Drill Maps), Hands on Experience working with Schema Objects like (Attributes, Facts, For the Report Development Using MicroStrategy Desktop.
Involved in user/groups creation, Objects migration using object manager.
Involved in Unit, Integration, Performance and Regression testing, worked on configuration settings on MicroStrategy Web and MicroStrategy Intelligent server.
Worked on Time based, and Event based Schedules and subscribed different reports.
Environment: MicroStrategy 9.4, Oracle 11g, Redhat Linux Server, MicroStrategy Desktop & Admin.
Employer: Altisource Business Solutions India Pvt Ltd, Bangalore, India.
Client: Ocwen Financial Corporation, U.S.A. Sep 10 – Dec 12 Role: MicroStrategy Developer
Responsibilities:
Interacted with the users extensively and gathered the requirements and analyzed the needs of the end users.
Perform necessary design enhancements on existing dashboards that were performing poorly. Some of the existing dashboards were extremely heavy as there were a lot of panels and reports embedded in the dashboards. All of these were redesigned to give better performance. Default prompt and filter values were introduced to reduce data load on dashboards
Provide resolution to existing issues as part of the support track
Created weekly, monthly reports for the management team and field operation managers using MicroStrategy.
Improving the performance of the reports by modifying VLDB properties and removing unused Metrics from reports.
Generated and implemented MicroStrategy reports by creating projects, metrics, filters, and templates using MicroStrategy Desktop and MicroStrategy web.
Extensively working in troubleshooting MicroStrategy prompts, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
Creating the ACL list on every month using command manger tool.
.
Environment: MicroStrategy 9.0.1, Oracle 8i, 9i, UNIX, MicroStrategy Desktop
Contact this candidate