We provide IT Staff Augmentation Services!

Data Analyst And Bi Developer Resume

SUMMARY

  • Over 9+ years of experience in Information Technology, Business Analysis, Data Analysis, design, development, testing, implementation and maintenance in data warehousing environment.
  • Experience in delivering reports, metrics, and dashboard solutions against BI specifications
  • Experience in Power BI, Tableau,MicroStrategy, Python and Alteryx.
  • Worked directly wif End users to determine requirements, design and develop queries to best meet the client’s business needs.
  • Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact & Dimensional Tables. Good understanding of Star and Snowflake schemas.
  • Designing and developing reports and dashboards for various organizational metrics and indicators.
  • End - to-end implementation (requirements through support) building Enterprise Data Warehouses, Data Marts, Operational Data Stores or related Business intelligence solutions.
  • Proficient in performing data analysis, Root Cause Analysis, Impact Analysis on large volume of datasets.
  • Experienced in querying Snowflake, Oracle, Netezza, MS SQL server databases for OLTP and OLAP.
  • Solid understanding of RDBMS database concepts including performance tuning and Query optimization.
  • Experience in complete Software Development Life Cycle (SDLC) involving Analysis, Design, Development and Testing.
  • Advanced working SQL noledge and experience working wif relational databases, query optimization (SQL) as well as working familiarity wif a variety of databases.
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions.
  • Strong analytic skills related to working wif unstructured datasets.

TECHNICAL SKILLS

Programming Languages: Python, SQL

Databases: Snowflake, Oracle, MS SQL Netezza

Operating System: Mac, Windows

ETL Tools: SQL Server SSIS, Informatica, DataStage, Alteryx

Reporting Tools: MicroStrategy, Tableau, Power BI, Spotfire

PROFESSIONAL EXPERIENCE

Data Analyst and BI Developer

Confidential

Responsibilities:

  • Worked wif business requirement analysts / subject matter experts to identify and understand requirements.
  • Providing Reporting expertise using the multiple BI tolls to the Business Continuity Team.
  • Worked in designing the data model, analyzing the sources and creating the specifications.
  • Extensive work experience wif Ad hoc reporting and standard reporting environment.
  • Created data marts, aggregate tables to support the reporting needs.
  • Responsible for assessing and improving the Quality of Customer Data. Worked on end-to-end data quality process setup for entire GOCR division.
  • Streamlined the process of OCC regulatory reporting by developing a detailed process tracker in Excel and Python.
  • Reconciled monthly Audit and quarterly financial reports in order to ensure regulatory compliance
  • Worked on creating automation scripts leveraging various Python libraries to perform accuracy checks from various sources to target databases.
  • Interacting wif Financial services stakeholders delivering regulatory reports and to recommend best remediation strategies to ensure pristine quality of high priority usage data elements by building various analytical dashboards using Tableau, MicroStrategy, Power BI, excel, python plotting libraries
  • Involved in the code migration.
  • Responsible for End User Training across important Business Units, which includes both BI Tools and Web Interfaces

Environment: MicroStrategy 11, Power BI, Tableau, Spotfire, Alteryx, Windows10, MS SQL Server, Netezza, Oracle)

Business Intelligence consultant

Confidential

Responsibilities:

  • Worked wif the business analyst and executives to understand requirements for the Executive dashboard and designed the prototype.
  • Collaborate wif database architect and ETL developers to aid in the design of efficient and robust data structures for reporting and analysis.
  • Architected the Schema for the project by creating facts, attributes, and hierarchies.
  • Created the application objects metrics, filters, Prompts and Reports using MicroStrategy Desktop to meet report requirements.
  • Developed the OLAP services by creating the cubes, view filters and derived elements to improve the performance of the Executive dashboards.
  • Designed and built pixel perfect report service documents and interactive Flash dashboards.
  • Build the report builder interface for the Adhoc Analysis.
  • Created transformations using Transformations by tables for YTD (Year to date), and MTD (Month to date) for Time Series Analysis.
  • Analyzed the legacy reports and recreated in the MicroStrategy.
  • Set up the distribution services for distributing the report output to the different levels of users.
  • Involved in troubleshooting MicroStrategy Web Reports and optimizing the SQL using the VLDB properties.
  • Resolved the defects during the QA and UAT testing process.

Environment: MicroStrategy 9.3.1 (Web, Desktop, MS SQL Server, Teradata, Windows.

BI consultant

Confidential

Responsibilities:

  • Developed Dynamic Dashboards and Scorecards to deliver highly interactive solutions to end user in analyzing trends in the market.
  • Analyzed sales trends developed key performance indicators metrics and performed other commercial analysis as needed.
  • Created various Schema objects and public objects such as Attributes, Facts, Metrics, Filters, Hierarchies, Transformations, Templates, Search Objects, Prompts and Custom Groups.
  • Experience wifMicroStrategyreport services in developing ad-hoc reports using advanced filters, Level metrics, advanced subtotals, Value prompts, Derived metrics, Custom groups and Consolidations.
  • Extensive experience in creating Reports, Documents, Dashboards and Visual Insights using MicroStrategyWeb and deployed them toMicroStrategyMobile.
  • Created Intelligent Cubes and generated reports out of them for high performance & less query time and thus making use of In-memory BI wif the halp ofMicroStrategyOLAP services.
  • Revised governing and analytical settings in VLDB properties to fine tune SQL and calculation of metrics dealing wif nulls and zeroes.
  • Used Object Manager to migrate objects from development to testing and to production environment.
  • Responsible for maintaining the Intelligence Server including the Metadata repositories for different environments
  • Used System Prompts to filter data by end users based on their user login.
  • Distributed personalized information to each user by creating Subscriptions wif the halp of MicroStrategyDistribution Services.
  • IntegratedMicroStrategywif Share point 2010.
  • Involved inMicroStrategyupgradefrom Version 9.3.1 to 9.4.1, tested reports built in version 9.3.1 and worked in version 9.4.1.

Environment: MicroStrategy, Erwin, Teradata, SQL Server 2008/2012, Windows.

Software engineer

Confidential

Responsibilities:

  • Involved in gathering of business requirements from end clients and translating them into report specifications for the MicroStrategy platforms.
  • Involved in Creation of Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the MicroStrategy objects necessary for the deliverable.
  • Used several Widgets for Dashboard reporting.
  • Extensively used report services to create Dynamic Dashboards using panel stacks, selectors, widgets in flash mode.
  • Created up to seven-layer dynamic dashboard by using panel stacks and selectors which will provide information for all levels of hierarchy.
  • Created Drill down dashboards which will allow users to navigate from one dashboard to another.
  • Extensive use of dynamic dashboard and scorecard to predict the trend in market and very interactive presentation and use of data. MicroStrategy web (View, interactive, Editable and flash mode), Subscription feature to improve the performance and mobility of the group.
  • Created Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services
  • Successfully created Physical Schema, Indices including unique, secondary, join upon determining which is best in terms of performances.
  • Used pass-through functions (apply simple and apply comp) in attributes and filters definitions
  • Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
  • Created Enterprise Manager Reports for various analyses.
  • Creating & scheduling reports to multiple users via Distribution Services & Data Driven E-mail Alerts.
  • Used various apply functions like apply simple; apply comparison and case statements to support various business requirements.
  • Used free form SQL editor for complex report creation.
  • Involved in partitioning the tables, indexes and management of the schema objects.
  • Working wif MicroStrategy technical support for any critical issue resolution.

Environment: MicroStrategy 9.1.0 (Architect, Desktop, Web Server, Object Manager, Enterprise Manager, Distribution Services), Windows 7, DB2, Netezza, HTML.

Hire Now