SUMMARY

• Creative, responsible and self - taught professional with excellent problem-solving and communication and documentation skills who has about 6 Years of immense experience in Business Intelligence tools like Tableau, Microstrategy
• Looker and in big data technologies like HP Vertica and in relational databases like Oracle, MySql, MS SQL Server 2008/2012 and have programming experience in Python and has Master’s in Information Systems Management and Technology.

TECHNICAL SKILLS

Business Intelligence tools: Tableau, Microstrategy, Logi Analytics, Looker.

ETL: Alteryx

Operating System: Windows (98, 2000, XP Professional, Vista, 7, 8)

Programming Languages: Python (beginner), SQL (Advanced)

Databases: MS Access 2007 to 2013(Proficient), Oracle, MSSQL server

Big Data Technologies: HP Vertica, Cassandra, Hive

Web Technologies: JavaScript, JQuery, CSS, HTML, XML.

Build Tools: Rational Rose 2003, Adobe Photoshop, MS Visio.

CRM tools: SalesForce

Packages: Microsoft Office (all versions) - Microsoft Word, Microsoft Excel, Microsoft Powerpoint, Microsoft Access, Microsoft Visio.

SDLC: Waterfall, Agile

PROFESSIONAL EXPERIENCE

Senior Data Analyst

Confidential

Responsibilities:

• Strong knowledge on the data quality/ETL migration testing tool ICEDQ that is heavily used by the company to measure quality of the data flowing through various data-warehouses.
• Work with the Data Quality Assurance team to understand the 3 core metrics used to determine the quality of data - Completeness, Consistency and Conformity.
• Immense analysis on ICEDQ DB (Microsoft SQL Server) to know the data tables that were feeding the Tableau dashboard.
• Created several Tableau dashboards that to show all the 3 metrics across all the important data attributes like time on visit, time on video, recognized customers, unique visitors etc.
• Created a rules execution dashboard to show all the details of every rule being executed on ICEDQ about the status of the rule.
• Created many complex calculated fields on Tableau that are used in the dashboard to measure Accuracy% for every rule being executed on ICEDQ.
• Created several dimensions to slice and dice the data like rule execution date, rule status, on-time/delayed filter etc.
• Worked very closely with the DQA team to investigate if a rule failed or not executed on-time.
• Created a worksheet that shows how many rules exist per area of business on ICEDQ and the rules description.

Senior Business Intelligence

Confidential

Responsibilities:

• Work with business users in 110 councils all over the US to gather business requirements.
• Create Looks and Dashboards on Looker.
• Create SQL queries to query data from the database.
• Created reports on Salesforce using different fields and measures.
• Create measure and dimensions on Looker based on the data and the business requirements.
• Participated in QA in POC project for data migration from SQL Server to SnowFlake.
• Created reports in Excel to perform demographic analysis on Leads data (Girls and Adults).

Lead BI Analyst/ Developer/ Senior Data Analyst

Confidential

Responsibilities:

• Self-started a Tableau project creating proof of concept, with demo Trade data.
• Creating demo dashboards and presenting to Business Stakeholders.
• Exploring features of Tableau and perform comparison analysis between Tableau and Microstrategy.
• Train other BI developers on Tableau.
• Created user documentation on Tableau features and do requirement analysis.
• Created multiple worksheets and dashboards with different kinds of visualizations like bar charts, pie charts, maps, dual-axis charts, line charts, and bubble chart.
• Extensive experience in creating maps with multiple metrics, also worked on changing the map’s background using WMS server URLs.
• Extensive experience in creating calculated fields, working on different kinds of dimensions, parameters.
• Highly experienced in creating dashboard actions to perform different kinds of analysis by drilling down the data.
• Performed data analysis and well experienced in knowing what kind of visualization would represent the data in the best way possible.
• Created multiple Microstrategy documents based on user requirements.
• Performed data analysis on HR data and worked on different metrics like open reqs, filled positions, and responsible for getting pre-hire data from tools like Taleo, Avature.
• Co-ordinated different teams in terms of data analysis and gathered requirements
• Developed several datasets, documents according to the requirements.
• Responsible for the entire lifecycle for the project - Development, Co-ordinating UAT and Production
• Worked on different kinds of HR related data like Lateral and Campus recruitment.
• Agile development methodology has been followed in this project.
• Have immense experience in creating objects like attributes, metrics, filters, consolidations, custom groups, transformations, hierarchies.
• Worked on enhancing performance by creating Intelligence cubes, enabling cache on the project.
• Provided creative work-around solutions according to the user requirements when there was no in-built solution in the tool
• Oracle Database was used for this project - Created SQL scripts to build Materialized views and created procedures for data loads.

Confidential

Database and BI developer

Responsibilities:

• Worked on an internal project to create a proof of concept using Microstrategy and Oracle.
• Performed data analysis on demo data.
• Created different VI dashboards on the desktop and documents.
• Created different dashboards that included pie charts, bar charts, heat maps according to the business requirement.
• Created Metadata Repository and Statistical tables, Intelligence Server and Project on MicroStrategy Desktop using the Configuration Wizard
• Created datasets based on the demo data.
• Created various objects like attributes, metrics, filters, consolidations, custom groups.
• Performed demos to client on the mocked-up dashboards and documents.

Confidential, Reston, VA

Software and Business Intelligence Analyst/Developer

Responsibilities:

• Analyzed the user requirements for the project and worked on collecting the data needed for the reports.
• Demonstrated excellent crisis management.
• In-charge of documentation during scrum calls and communicate the requirements to the dev team.
• Worked also a developer and created reports in Tableau for the project called “Sprint Performance Tool” which focuses on network performance. Created connections between dashboards, created charts with dual axis, multiple KPIs. Worked on manipulation queries based on the customer’s requirements and did data testing. Agile development methodology has been followed in this project.
• Developed Ad-hoc reports/dashboards and conducted data analysis and data manipulation according to the business requirements.
• Created more than 200 various reports like bars, trends, line, bubble for the client which was about segmentations of customers across the country and performance of networks and handsets.
• Load data into databases and write queries according to the visualizations needed in Tableau.
• Worked with publishing dashboards and extracts on the Tableau server.
• Expertise with administrative functions in Tableau like granting use rights, setting up the application on a server and security.
• Fine \tuned SQL Queries for maximum efficiency and performance.
• Developed Tableau workbooks from multiple data sources using Data Blending.