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.