Sr. Software Engineer/data Analyst Resume
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
