Sql Server Data
Resume:
Anjali
*******.****@*****.***
PROFESSIONAL SUMMARY
•Over 3+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008/2005 in Development, Test and Production Environments on various business domains like Financial, Insurance and manufacturing.
•Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2014/2012/2008 R2.
•Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). Experience in report writing using SQL Server Reporting Services (SSRS)
•Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
•Developing reports on SSRS on SQL Server.
•Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
•Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
•Great ability to create and manage various database objects like tables, views.
•Experience in creating Ad-hoc Reports, Subscription Reports by using Report Builder in SSRS.
•Implemented Dynamic Grouping, Sorting & Page Breaking using SSRS Parameters.
•Worked Extensively on ETL process using SSIS package.
•Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like MS access and flat files.
•Experience in using T-SQL in SQL Server 2014/2012 and 2008 platforms.
•Experience in Performance Tuning and Query Optimization.
•Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
•Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
•Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
•Experience in creating packages to transfer data between MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
•Expertise in creating/modifying Tables, Views, Stored Procedures, User Defined Functions (UDFs), Common Table Expressions (CTEs), Joins, Indexes, Triggers and Cursors scripting in T-SQL.
Technical Skills:
ETL Tools
BIDS/SSDT, SSIS, SSRS.
Database
SQL Server 2014/2012/2008R2/2005, Oracle, My SQL.
Database Modeling
ER-Diagrams, Dimensional Diagrams, Star and Snowflake Schemas.
Reporting Tools
MS Access, Excel, MS SQL Server, Reporting Services 2014/2012/2008R2.
Languages
T-SQL, C, C#.NET.
Web Development
HTML, XML, Microsoft.NET framework, Visual Studio.
Operating Systems
Windows 10/8/7, and LINUX
Others
MS Office, MS Excel, MS Project, MS PowerPoint.
Education Details:
Executive Master’s in Information Technology, University of Cumberland’s,KY.
Master’s in Computer Science, NPU, CA
Bachelor’s in Computer science, JNTU-H, India.
Professional Experience:
Citi Bank, Dallas, TX Jan 2017 -Present
Jr. SQL Server BI Developer.
Responsibilities:
Responsible for gathering and defining user report requirements and developing appropriate interfaces for the reporting infrastructure environment to meet customer business needs, based on business processes and data entities between various systems.
Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
Developed, monitored and deployed many SSIS packages
Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.
Developed appropriate layout and designs for required reports using the SSRS and Stored procedures to retrieve data from the SQL Server using appropriate SQL language (T-SQL) to provide optimal performance.
Worked on server Migration of databases, Permissions, Logins, SQL jobs, SSIS Packages, from one server to another server and preparing the corresponding document for other environments.
Created Tabular reports, Matrix reports, List reports and Sub reports using SSRS.
Designed and developed the reports according to the requirements using Tableau and Power Map.
Used Conditional Formatting to change the behavior of the report depending on the requirement.
Developed various Custom Code functions using VB Script.
Deployed the SSRS Reports to the report server and maintained them.
Migrated and Converted over 200 Crystal Reports to SQL Server Reporting Services (SSRS).
Environment: SQL Server 2012/2014, SQL BI Suite (SSIS, SSRS), Microsoft Visual studio, Crystal Reports, T-SQL, XML, TFS (Team Foundation Server), MS Access 2003 & Windows Server 2003, VB Script, Power Bi, Tableau.
MSBI Developer Feb 2016 to July 2016
WI-FI Alliance, Santa Clara, CA.
Responsibilities:
Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.
Created SSIS packages to extract, transform and load data from multiple input sources such as flat files, xml and excel sheets into data mart.
Created master/child package model for improved maintenance and performance.
Implemented package configurations such as XML files and SQL server tables for package deployment.
Support Batch and online processes involving development, enhancement and support of T-SL procedures, views, triggers and query tuning.
Performed data transfer between different homogenous/heterogeneous systems (Excel, MS Access and CSV).
Rebuilding Indexes and tables as part of performance tuning exercise.
On call support for any failure of the system.
Scheduled Jobs for packages
Environment: SQL Server 2014, SSIS, SSRS, TFS, SQL Server Agent
Elegant Embedded Solutions, Hyderabad May 2013 – July 2015
Jr. SQL Server BI Developer (SSMS, SSIS, SSRS)
Responsibilities:
Created SSIS packages to extract data from OLTP to OLAP system and created alerts for successful and unsuccessful completion of schedule jobs.
Designed and developed SSIS packages to extract data from different source files – Excel file, Flat file, Access file, CSV file, etc. into SQL Server 2008R2 for further data analysis and reporting.
Implemented various SSIS Transformation tasks such as Conditional Split, Merge, Sort, Lookup, Aggregation, Derived Column, Dimension Processing, Slowly Changing Dimension etc.
Created complex Stored Procedures, Functions, Views, Indexes for increasing performances
Responsible for debug, performance checks and performed index tuning and query optimization
Generated reports to retrieve data using stored procedures that accept parameters
Generated Drill-down, Drill-through, and Parameterized Reports using SSRS
Constructed technical documents for the stored procedure and schema requirements
Environment: MS Visio 2010, SQL Server 2008/2008R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Visual Studio 2008/2010, T-SQL, Team Foundation Server 2010 (TFS).
Contact this candidate