Sql Server Data

Mounika Ankam

Email: *******@*******.***

Ph #: 248-***-****

Professional Summary:

Over 6 years of strong Reporting and ETL Developer experience in Health care, Logistics, Insurance and cable domains with expertise in Tableau Reporting, MS SQL Server 2012/2008 products like SSRS, SSAS, SSIS tools.

Excellent working skills in MS SQL Server with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).

Efficient in data extraction, transformation and loading (ETL) between homogenous and heterogeneous systems, creating and fine-tuning ETL workflows using DTS and SSIS of MS SQL Server 2000 and MS SQL Server 2008 R2/2005.

Strong experience in SQL Server development, System Analysis, Design, Development & Support of MS SQL Server 2014,2012,2008R2, 2008,2005 and 2000.

Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.

Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation Services (DTS) SSIS with MS SQL 2005/2008is

Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Cursors Indexes, Triggers, Rules, user defined data types, functions and data integrity.

Experienced in all phases of project life cycle starting from business requirement gathering, analysis, design, implementation, testing, and production. Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.

Expertise in designing Data Flow task, Work Flow task and designed various SSIS Transformations like OLEDB Command, Conditional Split, Aggregate, Multicast and Derived Column

Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.

Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.

In depth knowledge in Tableau advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines.

Experience in integration of various data sources like SQL Server, DB2 and Flat Files.

Expert in creating various types of reports like complex drill down reports& drill through reports, Matrix reports, sub reports and charts using SSRS based on Relational and OLAP database.

Experience in MS SQL Server installation, configuration, performance tuning, error handling, query optimization, backup/recovery.

Mastered the ability to design and deploy rich Graphic visualizations Parameters using Tableau.

Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.

Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.

Experience in MS SQL Server installation, configuration, performance tuning, error handling, query optimization, backup/recovery.

Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

Experienced in all phases of project life cycle starting from business requirement gathering, analysis, design, implementation, testing, and production. Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.

Expertise in designing Data Flow task, Work Flow task and designed various SSIS Transformations like OLEDB Command, Conditional Split, Aggregate, Multicast and Derived Column.

Excellent T-SQL Programming skills.

Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages

Experienced using in FTP and SFTP servers to upload files.

Collected business requirements from users and translated them as technical specs and design docs for development.

Excellent analytical, communication and inter-personnel skills with exceptional ability to learn new concepts.

A good team player, problem solver, and quick learner with analytical Skills. Ability to perform at high level to meet deadlines, adaptable to ever changing priorities.

Technical Skills:

RDBMS

MS SQL Server 2014/2012/2008R2/2008/2005/2000, MS Access.

Database Design Tools and Data Modeling

MS Visio, UML, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization.

DWH / BI Tools

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau, SQL Server Analysis services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio.

Tools and Utilities

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, DTS, Business Intelligence Development Studio (BIDS).

Operating Systems

Windows XP/Vista/7/8, Windows Server 2003/2008 and MS-DOS

Professional Experience:

Client: Fidelity Investments, Boston, MA Apr 15 – Till Date

FMR LLC (Fidelity Management and Research) or Fidelity Investments is an American multinational financial services corporation. It is the second largest mutual fund and financial services group in the world. Founded in 1946, the company has since served North American investors. Fidelity Ventures was its venture capital arm, which has since been shut down, with many of the employees moving on to create Volition Capital. Fidelity International Limited (FIL), was an affiliate founded in 1969, serving international markets and the rest of the world; FIL was spun off as an independent business in 1980, and has since been rebranded as 'Fidelity Worldwide Investment.

Role: Sr. SQL Server SSIS/SSRS Developer

Responsibilities:

Collected business requirements from users and translated them as technical specs and design docs for development.

Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.

Deploy rich Graphic visualizations using Tableau.

Converted existing BO 5x reports into tableau dashboards

Developed Tableau data visualization using Pareto’s, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.

Developed dashboard reports to populate data using SSRS.

Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements. Created pages in the reports to display depend on Prompt values.

Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.

Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.

Bulk data migration using SSIS from flat files and xml.

Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Involved in accounting code module to populate general ledger code by writing complex T-SQL queries, stored procedures.

Developed, monitored and deployed SSIS packages.

Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

Created different Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.

Worked on all types of report types like tables, matrix, charts, sub reports etc.

Created Linked reports, Ad-hoc reports and etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.

Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.

Environment: MS SQL Server 2012, Tableau, DTS, SSIS, SSRS, T-SQL, MS Access and Windows 2008 Server.

Client: UPS, Alpharetta, GA. Feb 14 – Mar 15

Description: UPS offer customized systems for shipping and tracking regardless of what industry in. UPS help to react to changing markets or grow your business. UPS experts at finding smarter ways to work--whether it's discovering potential in a supply chain or customizing business processes to improve critical measures of performance. Customer Solutions team is in the business of discovering innovations and putting them to work. UPS can customize technology specifically for business and create a network where inventory, shipping, accounting, and customer service work in unison -- making business more successful and more satisfying.

Role: Sr. SQL Server BI Developer

Responsibilities:

Evaluating Source systems, standardizing received data formats, understanding business/data transformation rules, business structure and hierarchy relationships, data transformation through mapping development, validation and testing of mappings.

Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.

Experience with creating Worksheets and Dashboard.

Experience with Tableau for Data Acquisition and data visualizations.

Created dashboards for analyzing POS data using Tableau 8.0.

Developed Stored Procedures with complex business logics.

Migrated the DTS packages into SSIS.

Extracted the data from XML to SQL Server.

Created the Staging tables, successfully migrated old data from legacy system into SQL Server using SSIS Packages.

Extracted the data from SQL Server to XML files using SSIS as ETL tool.

Transferred data by adding Derived column Transformation, count of records, merging of data has been done while pulling data from Source to the Target.

Created various Stored Procedures to validate the data from source and update the records and insert them into a newly created table.

Performed T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server, Used Pivot tables to provide structured Reports like monthly, weekly.

Temp Tables are used for reduce the number of rows for joins, to aggregate data from different sources for different reports.

Indexes are created on tables for new database for faster retrieval for the reports.

Created DTS packages and scheduled data migration from old system to new system and verified making different reports on new system.

Extensive experience with SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics.

Created Views and Indexed Views to reduce database complexities for the reports.

Worked on complex data loading from FTP sites (implemented the batch data cleansing and data loading).

Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.

Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.

Environment: Microsoft SQL Server 2012/2008R2 Enterprise Edition, Tableau, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), BIDS.

Client: Molina Healthcare Inc., Long Beach, CA Feb 13 – Jan 14

Role: SQL Server Developer

Responsibilities:

Designed, coded, tested and implemented stored procedures and functions for new and existing software application requirements.

Proficiency in Transact-SQL, stored procedures and writing efficient code in an OLTP and OLAP environment.

Defined and developed data migration strategy between different sources and platforms using DTS and SSIS Platform.

Scheduling Jobs on various stored procedures and packages.

Created new tables, written stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.

Login and User Management: Worked on authentication by Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.

Experienced on Database creation, database tuning, and performance planning, backup planning and database administration.

Worked with SQL Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.

Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.

Involved in performing data conversions from flat files into a normalized database structure.

Developed source to target specifications for Data Transformation Services.

Developed functions, views and triggers for automation

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.

Created DTS package to schedule the jobs for batch processing.

Involved in performance tuning to optimize SQL queries using query analyzer.

Created indexes, Constraints and rules on database objects for optimization.

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2008, Enterprise Manager, UML, MS Project, VS .NET.

Client: Global Telecom, Plano, TX. Mar 12 – Jan 13

Role: MS SQL Server Developer

Responsibilities:

Participated in gathering the business requirements and Database Specifications.

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

Developing T-SQL queries, triggers, functions, cursors and stored procedures.

Responsible for logical and physical design of SQL Server databases.

Alter the schema for the required objects.

Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Created views to restrict access to data in a table for security.

Expert in extracting data using SSIS from OLTP to OLAP.

Performed Bulk data migration using DTS and SSIS from flat files.

Worked extensively on SSIS Packages for extracting the data of the customers from OLTP, transform that data and load it into OLAP.

Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.

Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS).

Conducted unit tests of ETL processes, and reports.

Created and scheduling maintenance jobs in new environment using SQL Server Mailing Agent in SQL Server.

Production Support and maintenance.

Worked with end customers and non- technical staff to resolve incident tickets.

Ensured crucial project deadlines/milestones are met without compromise on Quality of the work Product.

Involved in fixing the acceptance bugs reported, coding based on the enhancements.

Performed complete impact analysis on system software due to suggested modifications/ enhancements and prepared detailed design documents identifying program and database design changes required for successful implementation of change module.

Environment: T-SQL, Business Intelligence MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), SQL Server 2008, MS Office, Windows XP.

Client: Computer Service Corporation Private Limited, Hyderabad, India Jan 10 – Feb 12

Role: SQL Server Developer/Analyst

Responsibilities:

Analyzed the requirements and selected the appropriate fact tables/created fact tables

Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions

Configured SSRS 2005 with MOSS 2007 for directly deploying the report in SharePoint 2007.

Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.

Actively involved in Normalization & De-normalization of database

Materialized views, dimensions and stored outlines for optimal performance

Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems

Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSIS, SSRS), Enterprise manager, XML, VS.NET, MS PowerPoint, MS Project.

Contact this candidate