Sql Server Data

Mounika Email: acq3un@r.postjobfree.com

SQL / MSBI Developer Phone#: 703-***-****

Summary

Over 7 years of strong experience in the Database Design, development and deployment of large-scale enterprise applications.

Extensive experience and in depth working knowledge in various SQL Server tools and IDE to work with Database, reporting and business intelligence based applications like SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio and Query Analyzer.

Expert in Data Warehouse development starting from inception to implementation and ongoing support, and strong understanding of BI application design and development principles.

Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.

Excellent knowledge in RDBMS concepts and constructs along with Object creation such as Database, Tables, Normalization, User Defined Functions, SPROC, Views, Cursors and Triggers.

Hands on Experience in writing complex stored procedures, Indexed Views and also creating and Updating tables for Data consistency and Data manipulation by executing DBCC commands.

Experience in creating SSIS packages, DTS Migration and Metadata Management. Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.

Automated manual process with SSIS packages for import, export and bulk insert data with transformations from various data sources.

Experience in designing report layouts and developing Custom Reports and different types of Tabular/Matrix/Adhoc/Sub/drill down/drill through Reports and Charts in multiple formats using SSRS 2008/2005.

Experienced in writing Parameterized queries for generating Tabular reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SQL Server Reporting Services (SSRS) 2005/2008.

Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc. and created various user roles.

Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.

Good exposure or knowledge working on C#, VB.NET framework.

Extensive knowledge of addressing Performance Issues and query tuning, Index tuning, Data Profiling and other database related activities.

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down,Drill-through And Cascading reports using SSRS.

Experience in developing User reports and Management reports using MS SQL Server Reporting Services.

Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.

Expertise in Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.

Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

Extensive experience in using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)

Experience in Database Backup, Recovery and Disaster Recovery Procedures.

Sophisticated experience in creating new data models, data flows and data dictionaries.

Expertise in Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.

Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities.

Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, Tableau Server and Reports, and MS Excel spreadsheets and Power Pivot.

Created Scorecard/Dashboard pages in Performance point server (PPS).

Defined group level security standards for Tableau.

Used Tableau to visually analyze data and create concise and actionable dashboards.

Comprehensive knowledge on essential data warehousing concepts such as dimensional modeling, star and snowflake schemas, Data marts, front end/Back end architecture, security and Report distribution.

Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.

Experience in managing offshore and onsite resources. Excellent multi-tasking and inter personnel skills with efficient planning in prioritizing of projects.

Flexible, enthusiastic and project oriented with excellent communication and leadership skills to develop creative solution for challenging client needs.

Technical Skills

RDBMS : MSSQL Server 2012, 2008, 2005, MS ACCESS 2007, 2003, 2000.

Database Utilities : Enterprise Manager, SQL Server Management Studio, BI Development, Studio, Visual Studio, Configuration Manager, SQL Server Profiler SQL Query Analyzer, SQL Refractor, SQL Server Agent.

ETL Tools : Data Transformation Services (DTS), SSIS, Pervasive Data Integrator, Import/ export wizard, Bulk Insert, BCP.

BI Tools : SSRS, SSAS, Crystal Reports, BIRT, Tableau 7/8.

Office Tools : MS Word, MS Excel, MS PowerPoint, MS Outlook.

Management Tools : SharePoint, Team Foundation Suite (TFS), Microsoft Office Communicator.

Languages : MS SQL, PL/SQL, T-SQL, MDX, C/C++, Java, VB, VBA, HTML, XML.

Web Technologies : HTML, DHTML, XML.

Architecture : Relational DBMS, Client-Server Architecture, OLAP, ROLAP, MOLAP and OLTP

O/S : Windows 2008/2003/2000/NT Servers, XP, Vista, UNIX.

Professional Experience

Intradiem Inc, Alpharetta, GA Dec 13 – Till Date

MS SQL/BI Developer

Description:

Intradiem call center performs management software Intraday Automation, improves call center productivity through increased agent efficiency and decreased idle time. Over 300,000 contact centers use Intradiem to improve performance. Intraday Automation collects real-time data from the existing systems and instantly triggers workforce adjustments based on rules that you create, dramatically improving service delivery at a lower cost.

Responsibilities:

Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

DDL Scripts for generating Tables, Views, Functions.

Analyzed and designed software and database solutions.

Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.

Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).

Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.

Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.

Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.

Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Configured Reporting Services in SQL Server 2008.

Created different Power Pivot reports as per the client requirement.

Worked on a web-based dynamic product registration and tracking system linked through ODBC to corporate DBMS.

Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.

Created checks and constraints to maintain data integrity.

Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.

Resolved significant PPS connection string issues with import process.

Used Tableau to visually analyze data and create concise and actionable dashboards.

Created visually compelling and actionable interactive reports and dashboards.

Created backup scripts to take periodic backups for the content on Tableau server.

Provided DBA assistance in SharePoint 2007 to SharePoint 2010 conversion.

Worked with Business Analysts, Developers and customers to resolve and escalate project issues.

Gathered the business system requirements and act as a SME for the system and business and created status reports.

Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: MS SQL Server 2012/2008/2005, SSRS, SSIS, SSAS, Windows2003 Advanced Server, ASP.Net, TSQL, Visual Studio 2008, Oracle, SSRS, SSIS, Erwin.

California correctional health care services, Sacramento, CA Aug 12 – Nov 13

SQL BI Developer

Description: California correctional health care services basically provides health services in many aspects. It is improving the quality of, and access to, health care for California's 125,000 adult inmates in 34 state prisons. My responsibility was implementation and maintenance of databases, Application Development, Generating reports and Analyzing data.

Responsibilities:

Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).

Created partition table for very large database for good performance.

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS

Deployed SSIS packages and Reports to Production Servers.

Involved in creation of Data warehouse Cubes in SQL Server Analysis Service (SSAS).

Migrated data using ETL Tool in SSIS.

Maintained system monitoring jobs and provided high availability support.

Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).

Participated Databases Architecture and data modeling design.

Performing DBA functions, installing, configuring and supporting database systems.

Developed various operational, drill-through and drill-down reports using SSRS.

Reported all events and requirements through established reporting mechanisms in SSRS.

Reviewed and developed data models and database designs with development teams

Wrote store procedures for some job automations.

Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.

Designed and developed OLAP using MS SQL Server Analysis Services (SSAS).

Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2005.

Configured replication servers and transactional replication between production & standby server for disaster recovery.

Created calculated measures and dimension members using multi-dimensional expression (MDX).

Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.

Environment: MS SQL Server 2005, SSRS, SSIS, SSAS, ProClarity, C#, ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Orange County Public Schools, Orlando, FL Nov 11 – July 12

SSIS, SSRS and MS SQL Developer

Description: Orange County Public Schools is the public school district for Orange County, Florida. The Information Communications and Technology Services (ICTS) Department addresses the organization’s need to transform data from their many source systems into valuable information that can be shared seamlessly across the enterprise, creating a single version of the truth, “SVT”.

Responsibilities:

Understanding the report design Requirements and Constraints.

Creating Database objects – Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.

Performing query plans and making sure each and every query is using appropriate useful Indexes

Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity

Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.

Rebuilding Indexes and Tables as part of performance tuning exercise.

Deployed the created SSIS packages in Development and Testing environments.

Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Effectively worked in Tableau version based environment and used deployment groups to migrate the objects.

Develop the mappings using needed Transformations in Tableau according to technical specifications.

Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Created Drill-down, Parameterized and Sub-Reports using RDL.

Promoted RDLs to Reporting Service Server (SSRS).

Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.

Designed and developed Data mart using SSAS.

Build Cubes on Enterprise Date Warehouse (EDW).

Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.

Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Axis Bank, Hyderabad, India Sep 09 – Oct 11

SQL Server Developer

Description: This project was for the Automobile Finance division of a leading bank. The department in the company provides customers with loan solutions to pay for and manage the cost of automobile. Customer-centric data base was build to analyze transactions across finance, marketing, risk, collections, and consumer relations was developed.

Responsibilities:

Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system.

Developed SQL Server Stored Procedures, Tuned SQL Queries(using Indexes) .

Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.

Implemented Exceptional Handling.

Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.

Creating and automating the regular Jobs.

Tuned and Optimized SQL Queries using Execution Plan and Profiler.

Rebuilding Indexes and Tables as part of Performance Tuning Exercise.

Involved in performing database Backup and Recovery.

Worked on Documentation using MS word.

Environment: Windows 2000 Server, SQL Server 2005, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.

CMC LTD, Hyderabad, India June 07 – Aug 09

MS SQL Server Developer

Description: CMC Limited is a leading systems engineering and integration company in India, offering application design, development, testing services and asset-based solutions in various segments through turnkey projects.

Responsibilities:

Created ER diagrams either Logical/Physical using Erwin.

Assisted in database design, creation of ER diagrams, phasing from development to QA and to production environment.

Created user based databases and installed MS SQL Server 2005.

Worked in Project planning, Designing & Implementation.

Involved in creating tables, views, stored procedures, triggers, and cursors and other SQL joins and statements for applications.

Wrote the stored procedures, checking the code for efficiency with routine backups and restoration. Data transfers between various servers using BCP.

Defined and created indexes for query optimization and revising scripts for optimal performance.

Used data transformation services (DTS) to populate data from various data sources using the concept of OLE DB.

Installed SQL Server service packs based on the errors and flaws that are found in the application.

Tested the stored procedures performance and its path of execution by using SQL profiler.

Recovered the backups of SQL Server production databases in test server environment.

Environment: MS SQL Server 2005, Windows 2000 Advanced Server, VB 6.0, and XML.

Education

Bachelor of Technology in Computer Science Engineering, JNTUH, India.

Contact this candidate