Data Developer

Madhulatha Bollineni Sai

# 470-***-**** email: **************@*****.***

SUMMARY

9+ years of experience in IT and Analytics industries with extensive experience in visualization tools and web analytics.

Domain experience includes Financial services, IT and Telecom.

Experience in designing data visualizations using Qliksense/Qlikview and Tableau and publishing to server.

Mastered the ability to design and deploy graphic visualization with drill down and drop down menu options using Tableau.

Experience in creating different visualizations using bars, lines and pies, tree maps, scatter plots and bubbles.

Extensive knowledge in various reporting objects like Hierarchies, filters, calculated fields, sets, groups and parameters in Tableau.

Having knowledge on Tableau server connection to database and scheduling the reports.

Developed Qlikview/Qliksense dashboards using charts (drill down & cyclic grouping), list box, input field, table box and Calendar & Date.

Hands on experience in implementing pivot tables, KPI object and PDF printing.

Experience in using Qlikview functions (Date and time, keep, join, mapping, string & input fields.

Implemented the 3-tier architecture (Data extraction, Data modeling and Application development) as recommended in Qlikview best practices guide.

Familiar with data architecture and data modeling concepts of STAR and Snowflake schema

Experience in design & development of applications using Visual Basic, PLSQL, Shell scripting, Excel VBA.

Experience in Big data analytical tools to access data from Hadoop.

Involved in creating data sets, loading data and writing hive queries that runs internally.

Experience in database design of tables, views and stored procedures with Relational databases.

Proficient in Adobe Analytics and responsible for gathering, structuring, analyzing and reporting on web performances and marketing channels.

Increase the lead generation by optimizing user onsite behaviour. Drive insights to support online acquisition strategic initiatives.

Strong analytical skills providing insights as well as recommendations for changes convincing decision makers of business benefits.

Hands on experience in Report automation and Process Improvement.

Experience in client coordination, requirements gathering, training, analyzing and implementing new tools and technologies.

Experience in Agile and Scrum methodologies.

Excellent communication, interpersonal, team player, self-motivated, hardworking and result oriented skills.

Highly capable to learn new technology and quickly adapt to new environment.

TECHNICAL SKILLS

Data Warehouse Tools: SQL Developer, Hyperion

Languages: VBScript, PL/SQL, Python.

Databases: Oracle, MS-Access, GreenPlum

Microsoft Applications: MS Excel, MS Word, PowerPoint

Operating Systems: UNIX, Microsoft Windows

Visualization Tools: Tableau, Qlikview and Qlik Sense

Analytics tools: SiteCatalyst, Opinion lab, Clicktale

EDUCATION

B-Tech in Electrical and Electronics Engineering from Jawaharlal Nehru Technological University.

EXPERIENCE

Worked as Senior Analyst in Fidelity Investments, Smithfield, Rhode Island from Apr 2013 to Dec 2017.

Worked as Senior developer in NTTDATA, Bangalore from Mar 2008 to Apr 2013.

CERTIFICATION

Qliksense certified from Udemy.

Basic SQL trainer at Fidelity BAR Team.

PROJECT EXPERIENCE:

Project details in Fidelity Investments Apr 2013 to Dec 2017

Title: Senior Analyst

Responsibilities

Designing the reports by accessing data from Oracle using Tableau and Qliksense/Qlikview.

Created complex reports utilizing features like calculated columns, drill down functionality, tables, graphs, line and bar charts.

Extensive knowledge in various reporting objects like attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups and parameters

Experienced in scheduling the auto authenticated reports on the Tableau server.

Developed dashboards using Qlikview/Qliksense components like list box, buttons, charts (pie, bar and line) and bookmarks.

Created QVD’s from different types of sources (Oracle and Excel files) for Qliksense/Qlikview dashboards.

Worked on exporting and printing data in Qlikview.

Implemented three layered architecture which involves extraction from database, build QVDs and finally developing dashboard.

Connected to multiple databases like Oracle and Hadoop from Qliksense/Qlikview.

Automation of the legacy process/dashboards using Python, Visual basic scripting and Excel VBA.

Used shell scripting to automate/schedule jobs on daily, weekly and monthly basis and to rum jobs in parallel to improve performance.

Worked on designing product specific dashboards/reports for partners and was responsible for providing regular analysis on the product performance.

Accessed web services using Python scripting to extract the data from Clicktale server.

Web analytics reporting, building dashboards & ad-hoc analysis using Omniture SiteCatalyst/Discover.

Created an efficient reporting process with Adobe report builder & Qliksense/Qlikview.

As a lead of offshore team, involved in deep dive analysis of web usage data to answer strategic questions and built effective reports to convey the same.

Experience in digital analytics with knowledge in multiple channels (SEO, Site traffic, Mobile Apps and Social Media).

Tracked and reported key performance metrics, traffic behaviors and campaign performance using Omniture SiteCatalyst.

Increase the lead generation by optimizing user onsite behaviour. Drive insights to support online acquisition strategic initiatives.

Managed measurement and analysis of the performance of Marketing Programs, Campaigns and Landing Zones that helped drive acquisition.

Measure & analyze the impact of site-redesign on website experience and conversions.

Consulting with web team to resolve tagging errors and improve data quality.

Reduced web analytics reporting hours by 25% by creating report templates & automation.

Worked on the analysis that focuses on the improvement of Fidelity.com website.

Developed hive queries for the web data analysis and visualizing.

Importing and exporting data into Hadoop using Sqoop from Oracle database.

Collaborate with partners to create scheduled reports with which business financial decisions are made.

Identified gaps in current metrics and data capture strategies.

Worked on adhoc requests and extracted data for the end users using PL SQL.

Effectively presented analysis and insights to varying audiences in person and over call.

Used JIRA for data issues tracking.

Used Collibra for data governance.

Environment: PL/SQL, SQL, Qlikview, QlikSense and Tableau, Hive, Excel, UNIX, VB script, Hyperion,WINSCP, SiteCatalyst/Discover, Report Builder, Opinion Lab, Bazaar Voice and Clicktale

Project details in NTTDATA Inc Aug 2008 to Apr 2013

Title: Senior developer

Responsibilities

Understanding client requirement, design and develop dashboards.

Developed Qlikview dashboards using charts (drill down, drill up & cyclic grouping), list box, input box and buttons.

Experience in Qlikview functions (Date and Time, Join, Mapping, String and Input fields).

Involved in designing the data model, extract and transform the data from data sources like QVD files, excel in creating the dashboards.

Involved in supporting other Qlikview applications which includes creation and cosmetic changes of different charts.

Gathered and loaded data in Qlikview from various data sources (CSV and Excel files).

Implemented three layered architecture which involves extraction from database, build QVDs and finally creating dashboard.

Worked with variables and aggregate functions.

Implemented incremental loads using created QVD files.

Automation of the legacy process/dashboards using Excel VBA, Visual basic and shell scripting.

Used shell scripting to automate/schedule jobs on daily, weekly and monthly basis and to rum jobs in parallel to improve performance.

Involved in creating tables, views, stored procedures in Oracle database.

Support to release testing team at the time of code movement and deployment to production.

Involved in complete Software development life cycle of the project including requirements gathering, preparing technical documents, develop, test, deploy, communicating with assignment clerks and external teams.

Developed new screens to offer repair service for the handsets and create the warranty period for handsets using visual basic for applications.

Worked in L3 development support team.

Preparation of low level design of the changes to be made as part of impact analysis.

Preparation of test cases for the areas impacted due to the issues.

Worked on adhoc requests and extracted data for the end users using PL SQL.

Environment: Vantive tools and Designer, UNIX, PL/SQL, SQL, Qlikview and Excel

Contact this candidate