Resume

Sign in

Sql Server Developer

Location:
Naperville, Illinois, United States
Posted:
November 22, 2018

Contact this candidate

Resume:

Meenakshi Marchetty

216-***-****

ac7rqa@r.postjobfree.com

Summary:

* ***** ** ********** ** 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, and PL/SQL in Oracle.

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, Oracle, 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, Toad, Sql Developer, tsql Sql Server Management Studio

Data Modeling: Star Join Schema/Snowflake, FACT & Dimensions tables, Physical & logical data modeling

Computer Languages: C, C++, T-SQL, SQL, PL/SQL, MDX

MS Office: MS Word, PowerPoint, Excel, MS Access

Professional Experience:

Ryan Specialty Group of Technology Oct 2015 – Present

MSBI Developer (SSRS)

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

Calculating Gross Premium, PD values, TIV values, BI Values in Risk Tab of each insurer

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

Conduct or coordinate tests to ensure that intelligence is consistent with defined needs.

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 2011– 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 2010 – June 2011

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 2009 - Jan 2010

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