We provide IT Staff Augmentation Services!

Sr. Software Engineer/data Analyst Resume

5.00/5 (Submit Your Rating)

Atlanta, GA

SUMMARY

  • 7+ years of experience in the IT industry and specialized experience in Business Intelligence - Expertise includes mainly in MicroStrategy 10.1/9.4.1/9.2.1/9.02/9.0/8.1.2/7.5.3/ and its components (Architect, Desktop, Web, Narrowcast Server, and other utilities), Informatica, Ab initio, Oracle 10g and MS SQL Server 2008, 2005, and 2000, Teradata 12.
  • Experience in planning, architecture, and design of data warehousing and SQL optimization.
  • Experience in designing, building and deploying MicroStrategy reports using different database based Data warehouses.
  • Very strong in Data Warehousing Concepts and good knowledge in ETL process.
  • Experience in developing Schema objects and Application objects.
  • Experience in creating and integrating MicroStrategy reports and objects like (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups).
  • Developed reports related to Market Basket Analysis. Have also worked on reports for design & modeling of Supply Chain, Resource Planning, and Project Cost Estimation.
  • Excellent experience with performance tuning, normalization and De-normalization, partitioning of data and indexing of partitioned tables.
  • Expert in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
  • Expertise in developing Scorecards & Dynamic Dashboards and good experience in using Report Services.
  • Experience in developing Delivery Reports using MicroStrategy Narrowcast Server.
  • Experience using Object Manager, Enterprise Manager, Command Manager, Integrity Manager.
  • Experience in using VLDB properties for performance tuning and also worked with DBA in troubleshooting.
  • Good Experience in using SQL query analyzer for validation of report data.
  • Experience in gathering report requirements, from the business users and translating Business needs into end-user Reports.
  • Strong hands on experience developing Mobile (IOS & Android) applications.
  • Experience in leading the team with excellent managerial skills.
  • Worked closely with the QA team, Administrators and Project Manager for resolving complex issues as required.
  • Involved in complete Administration tasks on Unix/Linux (SUN Solaris, Red Hat Linux) and documentation for the projects executed
  • Strong experience working on Visual Insight

TECHNICAL SKILLS

OLAP Tools: MicroStrategy 10.4/9.x/8.X/7.X (Architect, Desktop, Web, SDK, Narrowcast Server, Object Manager, Enterprise Manager, command manager)

ETL Tools: Informatica, SQL Server DTS, SSIS

Reporting Tools: MicroStrategy, Hyperion, OBIEE, Business objects, Datameer, Tableau and SSRS.

Data Modeling: Erwin 4.0/3.5.2

RDBMS: Hadoop, Oracle 10g/9i/8i, Teradata 12 and 13, Netezza 4.0, SQL Server 2000/2005/2008 , Amazon Redshift

Languages: R, Python, SQL, PL/SQL, C, C++, VB Script, HTML, XML and DHTML

GUI: Developer 2000 (Forms, Graphics, Reports), Visual Basic 6.0.

Environment: Windows NT/2000/XP/ME/95/98, XP, UNIX - Solaris

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Software Engineer/Data Analyst

Responsibilities:

  • Interacted with Data Architect in building Views and Table structures.
  • Was part of the MARB (Microstrategy Architectural Review Board) to track the effectiveness of the new projects and BI Tools.
  • Worked on Architect to map physical data structure to MicroStrategy Objects
  • Developed Attributes, Facts, Hierarchies and other schema objects
  • Created few reports using Visual Insights to train the users on how to build a dashboard directly from the cube.
  • Involved in conversion of Corporate Data Model into a Warehouse Star and Snowflake Model.
  • Created Data Mappings using Informatica Powercenter 9.5.1 and Powercenter BDE from source system (Hadoop - PUB) to Netezza DAQ.
  • Created users & user groups, Creating Security roles, Applying ACLs, Web Administration, uploading images, Starting, Stopping I-Servers in Unix/Linux Environment using Putty etc.
  • Created Metadata, History List and Statistics Repository Table using MicroStrategy Configuration wizard.
  • Provided User guide on Google DFP and Ad Banner Assessment to the business users in order to assess the new products introduced by Google.
  • Worked on Unix using Putty and Winscp to unzip Gunzip files and load them as flat files to Informatica BDE.
  • Presented Parallel Log processing results to the business stake holders with the variance and the reasoning between the existing Netezza and the proposed Hadoop system.
  • Analyzed data gaps using analysis tools such as Hive and Impala (SQL interface for Hadoop), beyond compare tool and ETL Validator.
  • Created reports using Datameer utilizing the new Hadoop database.
  • Was the developer for the Google and ESRI map widget and solved issues related to the Google map during the upgrades for both web and Mobile.
  • Fixed defects on 10.1 upgrade in sandbox environment to validate any discrepancies on the highly visible projects.
  • Worked on ESRI maps (9.4.1) to replace Google Flash Maps.
  • Worked on converting Ipad Footer menu from Static Text to Dynamic grid to link out the dashboards with the help of Logical table.
  • Worked on HTML Tags for the AMP Home page.
  • Worked on the DAR cube maintenance by maintaining every Performance Logging while running the cubes.
  • Build IM scripts using Integrity Manager before 9.2.1 and 9.3 Upgrade to validate for any discrepancies.
  • Performed the statistics software R, SPSS, SASto graph the plots for the visual analysis.
  • Built Usage reporting to monitor the stats on the usage for all the dashboards in every project using Enterprise Manager.
  • Imported views into Warehouse Catalog and assigned Table Prefix to attain Logical
  • Wrote Command Manager Scripts for the new cubes moved into production for automatic refresh.
  • Built schema objects for Limited Availability and for Enterprise Reporting.
  • Built metrics, Derived metric, derived elements, Filters, Prompts and cubes.
  • Created Hyper-link reports from Text, image and attributes.
  • Built Proto types for Business in order to make decision on which look and feel they preferred.
  • Worked with Business analyst and QA Team to resolve some On-support defects.
  • Migrated objects from Dev to QA by creating Packages through object manager.
  • Worked on creating dashboards with security filters for the Regional manager, District Manager, sales people.
  • Worked with team on delivering projects using LeanKit schedule manager by focusing on things to work on, Execution of plan, reviewing what has been done and delivery.
  • Had to set the table schema prefixes in the database instance for Amazon Redshift.
  • Have built and delivered reports off of AWS Cloud infrastructure i.e. EC2 & Amazon Redshift.
  • Effectively used the VLDB settings for reducing the SQL passes and other join issues.
  • Created Info Window for web and Mobile Dashboards.
  • Used manage views for Android systems (Acer) and created some dashboards for IOS.
  • Used OBIEE reporting for some of the reports.
  • Configured Intelligent Server using Configuration wizard
  • Created configuration packages and migrated configuration objects using Object Manger
  • Created multiple users and added to user group, using Command Manager scripts.
  • Created deployment documents for Production and User Guide for the business.
  • Created Data dictionary for QA and Business analysts.
  • Worked on creating sample reports using Tableau and Datameer.
  • Worked with Agile team and had cross training.

Environment: MicroStrategy 10.4/9.4.1, 9.3/9.2.1/9.0.2 Product Suite (Architect, Desktop, Web, Object Manager, Integrity Manager, Command Manager and Enterprise Manager), Oracle 12, Netezza, Hadoop, Amazon Redshift, Informatica BDE.

Confidential, Atlanta, GA

MicroStrategy Onsite Lead

Responsibilities:

  • Planned, Estimated, Assigned, Tracked, Status Reporting for Onsite and Offshore Tasks.
  • Worked with the project manager to add the BI efforts and time required to the project plan.
  • Prepared the required Mock up and documentation to get the business signed off of requirements.
  • Worked on the End to end Management and Coordination of all phases (Requirements to Release to production) from Onsite.
  • Created MS Excel reports using the pivot function and also created reports from flat files for the business.
  • Created Hyper-link reports using HTML container.
  • Prepared Design documents, Metric catalogs, UTPs and UTRs for the QA team.
  • Involved in the installation of MicroStrategy suite and later involved in the version up gradations from 9.0 to 9.2.
  • Worked with the EDW and QA team to fix most of the ETL issues.
  • Worked on the Hyperion retirement fixes.
  • Raised RFCs to implement the reports to production and also worked with the portal team to create links accessed by the store users on the My apron web portal.
  • Worked on raising AD and LDAP groups for the business and offshore developers to access reports.
  • Involved in normalizing the data from source systems by identifying columns in the table, which came in as fully De-normalized flat file.
  • Migrated objects from Dev to QA by creating Packages through object manager.
  • Created mock up data as per logic provided by business and had them updated on the aggregate tables for testing.
  • Worked on Adhoc reporting based on Time, location, product and vendor attributes and sales and inventory metrics.
  • Create reusable queries using Teradata SQL Assistant to validate content of normalized table structures, and denormalized materialized views following ETL loading.
  • Created metrics using pass through functions such as apply simple and derived metrics with IF functionality.
  • Worked onTransaction Services,developed transaction reports updating, inserting, deleting table values usingstored procedures.
  • Designed and developed Store Survey dashboard using write back functionality out of the boxTransactional Services.
  • Created Transaction Reports using freeform SQL for Survey Page.
  • Worked on dashboards using Map, Cylinder and Fish eye selector widgets.
  • Was involved in the creation of the I Pad/Android/I phone sales dashboard.
  • Used the evaluation order functionality to set the totals of reports.
  • Developed Work load management test cases for the adhoc reports to analyze the impact of the various time, product, vendor and location level combinations on Teradata.
  • Created intelligent cubes and cube based reports for better performance of dashboards.
  • Created Base formulas & Templates as a best practice.
  • Created freeform SQL reports.
  • Created On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2008/2005 (SSRS).
  • Worked with the performance team to complete their load and stress testing for the reports.
  • Effectively used the VLDB settings for reducing the SQL passes and other join issues.
  • Worked on creating security filters for the store users and vendors in two projects.

Environment: MicroStrategy 9.0.2/9.0.1/9.0 Product Suite (Architect, Desktop, Web, Object Manager), Teradata 12, DB 2 SQL Server 2008, Ab initio, Hyperion 9i.

Confidential, Columbus, Ohio

Sr. MicroStrategy Consultant

Responsibilities:

  • Involved inthe “E-rewards program, Top and bottom N skus and stores and Merchandise dashboards”.
  • Documented the business process by identifying the requirements from business users.
  • Implemented ACL’S for the dashboards to restrict 23 roles within the application to control the dashboards.
  • Involved in the setting up of security system including creating users and security filters for the system.
  • Created complex and compound metrics to get the required result as per the business requirements.
  • Created links on attributes to open up a new detailed reports when clicked on it.
  • Used conditional formatting to hide and unhide objects.
  • Extensively used thresholds to highlight the top customers and sales by them
  • Implemented the Object prompts to pass attributes dynamically through the dashboards depending on the level of the user.
  • Effectively used the VLDB settings for Join types, Max rows, Query optimization etc.
  • Created reports and added report filters using MicroStrategy web.
  • Involved in Upgrade from version 8.1.2 to 9
  • Used panels within the dashboards to show different trend graphs using Radio buttons.
  • Used analytical and governing settings in VLDB properties to tune the SQL
  • Created Custom groups within the datasets to group the entire company level in the customer dashboards.
  • Involved in performing administration tasks like Caching and specifying Report governing thresholds.
  • Used apply functions to execute the database specific function in the metrics and filters.
  • Developed, Tested and Implemented Narrowcast server objects like Documents and Schedules necessary for the generation of Narrowcast Services.
  • Generated reports using freeform SQL.
  • Involved in Testing and Tuning of Reports and Documentation of MicroStrategy Objects Process flow.
  • Provided the initial support after the project roll-out to the junior developers and end users in Production.

Environment: MicroStrategy 9.0.1/9.0/8.1.2 Product Suite (Architect, Desktop, Web, SDK, Narrowcast Server, Object Manager, Enterprise Manager), Teradata, SQL Server 2008, Informatica power center, Windows NT.

Confidential, Plymouth Meeting, PA

Sr. MicroStrategy Consultant

Responsibilities:

  • Created reports based onPatient database, Diagnostics & Case History, Stores, Billing& Occupancy
  • Involved in developing “Inpatient hospital dashboard” and created total inpatient volume, DRG and inpatient dollar reports for the same.
  • Used bubble charts and bar graphs to display nation’s top DRG by fiscal year and inpatient payment by state.
  • Was involved in creating logical view for some reports and created schema objects such as attributes and hierarchies.
  • Assisted Administration team during the project migrations to various environments using the MicroStrategy Object Manager.
  • Changed the subtotals and also added links in the snapshot view (Grid view) using web.
  • Extensively worked in designing and developing “Claim for diagnosis and procedure dashboard” which was part of the “Health management dashboard”
  • Prepared personalized reports to end-users by including page-by and thresholds.

Environment: MicroStrategy 8.0/7.5.3 (Architect, Desktop, Narrowcast Server, Object Manager) Informatica, Netezza 4.0, Unix- solaris.

Confidential, Cleveland, Ohio

SQL Developer/Mstr Dev

Responsibilities:

  • Created accounts payable and receivable reports, profit and loss income statement reports and financial budgeting and forecasting.
  • Involved in developing Metrics related to gross profit margin, income, operating margin, accounts receivable turnover ratio.
  • Developed Consolidations for WTD, QTD, YTD and other time slices.
  • Used banding on the Top 5 and bottom 5 business units exceeding plans, and thresholds for the top 5 sales people by forecasted revenue.
  • Optimized query performance by changing VLDB properties at project level and report level.
  • Written complex SQL queries against the database while Unit testing.
  • Used drill maps in “Balance Sheet Reporting and Analysis “for the drilling of attributes to the templates.
  • Developed Logical and physical data model using ERWIN and mapped the data into database objects.
  • Created new Database with objects such as tables, views, indexes, triggers etc.
  • Wrote Complex queries and stored procedures to get the updates data from other servers.
  • Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
  • Performing query plans and making sure every query is using appropriate useful indexes.
  • Translated requirements into physical database structures that integrate with existing or proposed database structures.
  • Rebuilding Indexes and Tables as part of performance tuning exercise.
  • Participated in developing triggers to ensure referential integrity.
  • Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional Modeling principles in SSAS.
  • Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.
  • Generated Dynamic reports from Cubes (SSAS) using SSRS-2000.
  • Performed database consistency checks, migration of data from Excel to SQL Server databases.

Environment: MicroStrategy 8.1.2 (Architect, Desktop, Web, MDX Adapter) SQL Server 2000, SSIS, Erwin 4.0, XSL, HTML & DHTML, Windows NT

We'd love your feedback!