Sql Server Business Intelligence
Resume:
Meenakshi Marchetty
*******@*****.***
Summary:
•12+ years of Experience in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS)
•Experience in Software Development Life Cycle (SDLC)
•Excellent experience in design, development, implementation and administration of database systems using MS-SQL Server 2008/2005/2000 for both OLTP & Data Warehousing Systems.
•Experience in Tuning SQL queries and T-SQL queries & improving the performance of the Database
•Experience in T-SQL (DDL, DML and DCL) documentation, coding, programming and implementation of Business Intelligence solutions using Microsoft SQL Server 2000/2005/2008.
•Responsible for developing drilldown reports in SSRS using MDX, SQL
•Good understanding of Normalization /De-normalization, Normal Form and database design methodology.
•knowledge on crystal reports
•Developed in parallel to Business Requirements.
•Answer questions about a solution’s technical parameters required to provide the requested business functionality.
•The combination of Business and System Requirements provide the information needed for a project team to answer the question of How to provide a solution and How Much the solution will cost.
•Hands on experience in creating OLAP cubes and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions in SSAS.
•Strong SQL Server 2000/2005/2008 Developer Skills including writing stored procedures, user defined functions, views, query writing.
•Excellent communication, documentation and interpersonal skills with strong customer and team orientation with good client interfacing skills.
•Quick learner and good performer, oriented towards organizational process and hierarchy.
OLTP Experience
•Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
•Experience with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, restoring database using full, differential, and log backups.
•Excellent T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan.
•Involved in writing Complex Queries, heavy stored procedures, Batch Scripts, Triggers, Functions using T-SQL
•Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
•Good understanding of Normalization /De-normalization, Normal Form and database design methodology.
•Defined Indexes to implement business rules.
•Experienced in Visual SourceSafe version, TFS, control system product that delivers restore point and parallel collaboration capabilities, thus allowing application development organizations to work on several versions of software simultaneously.
•Experience in creating views to facilitate easy viewing implementation.
ETL, OLAP Experience
Integration Services (DTS/SSIS)
•Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities.
•Adept at SQL Server SSIS (Integration Service) package design, constructing, and deployment.
•Involved in migration of DTS Packages (2000) to SSIS (2005/2008) and troubleshoot migration issues.
•Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
Reporting Services (SSRS 2005/2008/2012)
•Experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports, Charts using SQL Server Reporting Services.
•Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
•Generated Dashboards, Action Items and KPIs based on business requirement.
•Experience in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts in SQL server reporting services.
•Used Report Manager to assign roles, permissions and to create report schedules.
•Experience in administrating the reports to assign permission to the valid users for executing the reports.
•Experience in Deploying reports in various sources like Web browser in XML and PDF formats.
Analysis Services (SSAS)
•Experience in building Star schema and Snow Flake schema depending on business requirements.
•Experience in creating Cell Level Security in cubes using SSAS.
•Experience in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
•Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
•Experience in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
Technical Skills:
Databases: SQL Server 2008/2012, MS Access, MySQL
Servers: Windows server 2003/2008, Windows XP
SQL Server Tools: Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Enterprise Manager, Query Analyzer, SQL Profiler, Performance Monitor
Package Tools: MS Visio, SSIS (ETL), SSAS, SSRS, Sql Server Management Studio,Power BI, Tableau
Data Modeling: Star Join Schema/Snowflake, FACT & Dimensions tables, Physical & logical data modeling
Computer Languages: C, C++, T-SQL, SQL, MDX
MS Office: MS Word, PowerPoint, Excel, MS Access
Professional Experience:
Human Health Service Feb 2020 - Present
MSBI Developer (SSRS)
•Expertise on SQL Server Management Studio (SSMS), Business Intelligent development Studio (BIDS).
•Responsible for designing and Creating Reports using SSRS in BIDS
•Designed Letters,Sub reports, Tables,Matrix, auditing reports and deployed in SSRS reporting server
•Extract files from Different Data sources CSV file, Excel, SQL Database and import them in EXCEL, Pdf
•Good exposure on GIT, Jira, ALM
•Worked on complex queries and query optimization
•Created different Power BI reports utilizing the desktop and the online service and schedule refresh
•Assist end users with problems installing the Power BI desktop,installing and configuring the personal and On –Premises gateway connecting to data sources and adding the different users
•Experienced in developing Power Bi reports and dashboards from multiple data sources using data blending
•Created Power Bi Reports using Tabular SSAS models as source data in Power BI desktop and publish reports to service
•Develop and published reports and dashboards using Power Bi and written effective DAX formulas and expression
•Troubleshoot and support reports in Power BI workspaces whenever there are issues in production
•Utilized Power Query in Power BI to pivot and Un –Pivot the data model for data cleansing and data messaging
•Created Power Bi reports by using joins in multiple fact tables and dimensions depending on the business requirements
•Experience in scheduling refresh of Power Bi reports,hourly and on -demand
•Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, grouping, live connections in tableau
•Designed,developed,tested and maintained Tableau functional reports on user requirements
•Mastered the ability to design and deploy rich Graphic Visualizations with drill down and Drop down menu option and parameters using Tableau
•Distributed Tableau reports using techniques like packaged workbooks,PDF to different user community
Environment: SQL Server 2012, SQL Server Reporting Services SSRS 2012, Windows XP, SQL Server Business Intelligence Developer (BIDS)
Ryan Specialty Group of Technology Oct 2015 – Dec 2019
MSBI Developer (SSRS)
•Expertise on SQL Server Management Studio (SSMS), Business Intelligent development Studio (BIDS).
•Responsible for designing and Creating Reports using SSRS in BIDS
•Report on risks, premiums and claims transacted under their binding authority contracts to Lloyd’s syndicates. Working on cover holder names, class of business, reference numbers of particular month
•Lloyd’s premium reporting standards are comprised of core risk information and paid premium transaction information. Where risk information has been provided in a separate submission, for example in a written risk bordereau, it is not a requirement that such information is provided again in a paid premium report
•Lloyd’s managing agents and syndicates have agreed a core set of regulatory, tax, premiums and claims information
•Designed and created SQL Database, tables, indexes, and views for Database Normalization and Security
•Identified and worked written bordereau of current month of this year and same month last year using SSRS
•Calculating Gross Premium, PD values, TIV values, BI Values in Risk Tab of each insurer and extracted from SSRS into Excel
Environment: SQL Server 2005, 2008, SQL Server Reporting Services SSRS, Windows XP, SQL Server Business Intelligence Developer (BIDS)
True Value Company, Chicago, IL Jan 2015 – Sept 2015
Retail Workbench
MSBI Developer (SSRS with MDX)/SSRS Reports Analyst)
Responsibilities:
•Expertise on SQL Server Management Studio (SSMS), Business Intelligent development Studio (BIDS).
•Developed, scheduled and generated variety of reports like List, Matrix, Chart and Sub Report and standardized company reports to provide Audit Evidence to the Auditors by using SQL Server Reporting Services (SSRS)
•Created Drill down Reports, Sub Reports, Linked Reports, Pie charts, bar graphs reports to users based on their requirements.
•Ensure database integrity, indexing, segmentation and recovery and update database design over time
•(SSRS) to generate all daily, weekly, monthly and quarterly Reports including current status.
•Identified and worked with Parameters for parameterized reports in SSRS 2010
•Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS)
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
Environment: SQL Server 2008, 2012 T-SQL, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Windows XP, SQL Server Business Intelligence Developer (BIDS)
J&R Company, New York, NY Dec 2013 – Dec 2014
Order Processing System
MSBI Developer/BI Analyst/SSRS Analyst
Responsibilities:
•Expertise on SQL Server Management Studio (SSMS), Business Intelligent development Studio (BIDS).
•Installed and maintained MS SQL Server 2008.
•Designed and created SQL Database, tables, indexes, and views for Database Normalization and Security.
•Design and develop T-SQL procedures, query performance tunings and SSIS packages
•Identify or monitor current and potential customers, using business intelligence tools.
•Design and develop data movements using SQL Server Integration Services, TSQL and Stored Procedures
•Experienced on SDLC
•Consult with the business to determine logical design for new business solutions
•Perform code reviews, analyze execution plans, and re-factor inefficient code
•Follow data standards, resolve data issues, complete unit testing and system documentation for ETL processes
•Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements
•Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
•Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
•Created User Defined Functions, Stored Procedures, and Triggers.
•Used SSIS to Implement the Slowly Changing Transformation, to maintain historical data in data warehouse.
•Developed, scheduled and generated variety of reports like List, Matrix, Chart and Sub Report and standardized company reports to provide Audit Evidence to the Auditors by using SQL Server Reporting Services (SSRS)
•Determine the impacts and costs associated with compliance of federal guideline Gain approval of stakeholders and users for selected course of action.
•Created Drill down Reports, Sub Reports, Linked Reports, Pie charts, bar graphs reports to users based on their requirements.
•(SSRS) to generate all daily, weekly, monthly and quarterly Reports including current status.
Environment: SQL Server 2005, 2008, 2012 T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Windows XP, SQL Server Business Intelligence Developer (BIDS)
Hampshire Hotels & Resort, New York, NY July 2012– Nov 2013
MS BI Developer
The company has been providing to quality customer services and company have hotel and resorts worldwide and the project is involve to maintaining and optimizing the existing database, migrating/ integrating data using SSIS and generate day to day basis reports according to business requirement using SSRS. The project also involved in transferring data from OLTP (Online Transaction Processing) to OLAP (Online Analytical Processing) and in creating cubes using SQL Server Analysis Services to analyze the business activities.
Responsibilities:
•Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
•Stored Procedures, User Defined Functions, Views, TSQL for complex business logic.
•Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases. And optimized the database by creating various clustered, non-clustered indexes and indexed views. Developed Analysis Services Project.
•Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimension
•Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
•Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Datawarehouse.
•Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
•Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
•Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
•Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS and Summary Reports, Sub Reports
•Ensure database integrity, indexing, segmentation and recovery and update database design over time
•Experience on SDLC
•Performed DBA functions, installing, configuring and supporting SQL Server based database systems
•Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
Environment: MS SQL Server 2012/2008 R2, SSIS, SSRS, DTS, T-SQL
J & R Company, New York, NY March 2011– June 2012
E-Shopping
MSBI BI Developer/BI Analyst
Project entitled Online Mobile Shopping Customer to buy mobiles or accessories from anywhere through online. This application advertises some of the products for shopping to buy products, customer from has to create an account. Those who does not have an account, they can only view the available product .They can't buy it once the customer has created account not only he can view the products ha can also add the product to the cart and also he can place an order to buy those products. This application then generates bill for that particular customer after the confirmation, the customer has to enter his credit card details to buy those products
Responsibilities:
•Responsible for creating database objects like tables, views, etc.
•Created SSIS packages to pump the data to data mart on a daily basis.
•Responsible for designing and Creating Reports using SSRS in BIDS.
•Responsible for Creating data driven and event driven subscriptions for users.
•Created SSRS reports using OLTP and OLAP data sources.
•Created complex Stored Procedures which can identify and pinpoint any biased payments made by the Bankrupt Entity.
•Created Drill down Reports, Sub Reports, Linked Reports, Pie charts, bar graphs reports to users based on their requirements. Implemented Cascading parameters, Dynamic grouping, and dynamic columns in reports. Proven track record building large scale SQL Server databases.
•Determine the broad business functions and specific activities and transactions carried out, in full or in part, by the business system
•Developing requirements for functionality for records to be included in a design specification and for evaluation purposes when building, upgrading or purchasing business system software and reviewing the functionality for records or assessing the compliance of existing business systems.
•Interact with business users on daily basis to gather and discuss the requirements.
•Responsible for deploying the reports to the Reports Server and Share point Server.
•Responsible for troubleshooting and performance tuning the T-SQL queries.
Environment: SQL Server 2008, TFS Source Control, Business Intelligence Development Studio (BIDS), SSIS, SSRS, Report Manager, SSAS.
UTI Mutual Fund - India June 2010 - Jan 2011
Investment Plan
MS BI Developer
This is an application that deals with an enterprise investments and returns. This application helps the strategic management to make key decisions to spend the budget to maximize the profits. This application would help to improve the process to outcome better results.
Responsibilities:
•Designed and implemented stylish report layouts and Looked at the reports and fixed bugs in stored procedures.
•Generated Reports using Global Variables, Expressions and Functions for the reports.
•Identified and worked with Parameters for parameterized reports in SSRS 2005.
•Responsible for scheduling the subscription reports with the subscription report wizard.
•Deployed the generated reports directly on the client’s workstation.
•Worked in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
•Executed DTS Packages for data transfer from heterogeneous data sources like MS Access and text files to SQL Server using VBScript and T-SQL Stored Procedures.
•Developed DTS packages to extract, transform and load into the Campaign database from Database using of SQL Server 2005 Integration Services (SSIS).
•Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute Task, Email Task, and Data Flow Task.
•Builds a shared understanding of expected results between the project team and users. Involves users in defining what is needed. Supports the likelihood that what is built matches what is needed and was requested.
•Reduces the chances of system rejection. Ensures projects meet budget and resource estimates.
•Extensively used Derived Column, Row Count, Data Conversion, Conditional Split and Aggregate.
•Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profile
Environment: MS SQL Server 2008 R2, Visual Studio 2008, SQL Server Integration Services (SSIS), MS Excel, SQL Server Reporting Services (SSRS)
Education:
Masters in Computer Applications (MCA), Osmania University
Bachelor in Computer Applications (BCA), Osmania University
Contact this candidate