Bi Developer Resume
Murray Hill, NJ
SUMMARY
- Around 3+yrs of IT experience Health and Finance environments with primary skill on the Analysis, Design, and Development and Implementing Client/server application using Microsoft SQL Server and BI suite for both OLTP & OLAP.
- Worked on Business Intelligence technologies like SSIS, SSRS, SSAS of MS SQL server 2005/2008/R2/2012, 2014.
- Good understanding in Normalization and Relational Database Management Systems.
- Hands on Experience in installing, configuring, version upgrades, data migrations, data modeling, production support and various other tasks such as performance tuning, monitoring, back & recovery, capacity planning, high availability, fail over, disk, storage and memory management.
- Experienced in creating Tables, Views, Indexes and other SQL joins and query writing.
- Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
- Transformed data from various data sources using OLE DB connection by creating various DTS packages.
- Created Reports with complex formulas and to query the database for Business Intelligence.
- Experience in ETL implementation using SSIS/Data Services for loading the data from Various Data sources to using Variables, Parameters and Configurations to Other destinations
- Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements & tools like Import & Export Wizard for developing the Packages.
- Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS
- Proficient in creating different types of reports such as drill down, sub reports, parameterized reports, interactive reports, ad - hoc reports, custom reports and formatting them using SSRS/Business Objects.
- Involved in creating stored procedures, triggers, functions, Indexes, tables, views and other T-SQL code and SQL joins for applications by maintaining best standards to perform efficiently.
- Experience in using tools like Index Tuning Wizard, Database Engine Tuning Advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance.
- Handled huge financial data, expert level Query optimization and Performance tuning experience
- Experience in creating Jobs, Alerts, setting up SQL server mail agent for SSIS packages.
- Experience working with different SSIS Configuration options and Deployment Methods for different environments use.
- Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining)
- Experience in working with SAP Data Services and their Business Objects.
- Experience in database reporting using tools such as SQL Reporting Services (SSRS).
- Experience in Developing, Deploying Power BI reports/Dashboards.
- Prepared Power Pivot reports for smaller data-sets and refreshed the Power-Pivots in SharePoint.
- Experience in Deploying and Configuring packages, Error handling and Batch logging, check points and troubleshooting Reports using SSRS.
- Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
TECHNICAL SKILLS
Platforms: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP
Database/Data warehousing: MS SQL Server 2014/2012/2008 R2/2008/2005 & 2000/, SSMS, T-SQL, PL/SQL, OLEDB, MySQL, Oracle 12/11g/10g/9i/8i, Installation, Upgrade, & Migration, Performance TuningBI Tools SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS) and web,Visual Studio, Power BI
Applications: C/C++, C#, Java, HTML, CSS, Java Script, XML, XSLT, PHP, ASP.Net, VB.NET, UNIX, LINUX Visual Studio 2010/2013.
Desktop: MS Office Suite, Word, Excel, Access, PowerPoint, Outlook, Dreamweaver, Fire Fox, Power BI
Methodologies: Agile, Water Fall, Scrum, SDLC.
Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Erwin
Operating Systems: Windows Server 2008R 2/2008/2003/2000 , UNIX, LINUX, DOS
PROFESSIONAL EXPERIENCE
Confidential, Murray Hill, NJ
BI Developer
Responsibilities:
- Designed ETL processes for extracting, transforming and loading of OLTP data into a central data warehouse.
- Integrated new systems with existing data warehouse structure and refined system performance and functionality.
- Performed daily checks for job monitors, user sessions and Cache monitor to keep the system stable.
- Maintenance of Metadata using Micro Strategy DSS Architect.
- Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
- Developed reports and deployed them on server to generate all daily, weekly, monthly and quarterly Reports including current status.
- Created a DB instance for Micro Strategy and added all the tables, table prefixes and updated the table structure required for the project.
- Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
- Created numerous Micro Strategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions.
- Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
- Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
- Backup and Recovery of Production Databases and Tuning them for better Performance.
- Created Linked servers accordingly in between the different servers based on the requirement.
- Generated Sub-Reports, Drill down reports, and Drill through reports and parameterized reports using Micro strategy Developer and Generated Reports using Global Variables, Expressions and Functions for the reports.
- Worked with the Micro Strategy object manager to move objects among the development, testing and production environments
- Created ad-hoc reports with incorporated filters, sorting etc. and presented them at the client side to note the changes they may need.
Environment: Micro Strategy 10.2/9.4.1 Desktop & Web/Oracle Data base, Data Visualization/Visual Insight, Dashboards, Drill Map Editors, Object Manager, Intelligent Server, SQL server Management studio 2014, Erwin 7.3
Confidential
Micro strategy Developer
Responsibilities:
- Created Micro strategy objects like Reports, Ad-hock reports, Documents, Prompts, Filters, Metrics, Facts, Consolidations, Custom Groups, Attributes Transformations and Hierarchies.
- Created Schema Objects like Attributes, Facts and Hierarchies that map to the physical warehouse.
- Created several base formulas (mathematical expressions) using existing facts in Micro strategy Agent 7.x that can be re-used to build any number of Metrics.
- Thorough understanding of the business requirements via reports creation.
- Customized Reports, Documents and Deployed them to Micro strategy Web.
- Experienced administrative capabilities; Project Setup (Installing, configuring, managing and controlling) and Project Lifecycle Management.
- Define/Create system hierarchy/user-defined hierarchy and controlling (lock, limit and filter out) the attribute elements in hierarchy.
- Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts
- Set up Metadata repository in MS Access to develop a prototype, during phase 1.
- Moved the prototype Metadata Repository from MS Access to Oracle 10g production DataMart during phase2.
- Created the intelligent Cubes and shared to reduce the database load and decrease the report execution time by using the cube services.
- Actively participated in developing the report delivery schedules.
- Created reports with various object prompts to generate various Ad hoc reports.
- Created various monthly dynamic dashboard documents for fields marketing people with multiple panel stacks, selectors and customized widgets.
- Closely worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup tables for finding the Gap analysis.
- Upgraded the Micro Strategy 8.0.1 version on Windows to the 9.0.1 Version on UNIX.
Environment: Micro Strategy 9.0.1/8.x (Desktop, Architect, Report Services Document, Web, Narrowcast Server), Oracle 10g, DTS, SQL Server 2012.