Sql Server Data

Anil J

*****.*****@*****.***

718-***-**** ext **3

Professional Summary:

Eight years of extensive experience in Database concepts as BI Developer and Database Analyst in MS SQL Server 2008/2005/2000 in Production and Development environments.

Vast experience in handling large amount of data through TSQL programming, SSIS packages, SSRS Reporting for financial sectors.

Expertise in Database Programming using Stored Procedures, Materialized Views and appropriate User Defined Functions.

Broad experience in Query Optimization and Performance Tuning.

In-depth knowledge in Data warehousing, Design, tables and relationships, SQL query writing.

Experienced in handling the projects by liaising with the Client and the various team members on various sites efficiently.

Experience in SDLC methodologies & Agile/Waterfall project methodologies in Analysis, Design, Development, Testing and Implementation of client-server based applications.

Good Business requirement gathering skills, technical documenting skills and mentoring.

Hands on Experience on handling SSAS, database backups and database restore.

Have good interpersonal communications, ability to work collaboratively and commitment to achieving corporate goals.

Technical Skills:

Languages

T-SQL, C, C++, Visual Basic.NET, ASP .NET, HTML, VBA Script

Data Application Software

SQL Server 2000/2005/2008 R2/2012, MS Access (2000/2003) and UML.

Database Modeling

ER-Diagrams, Dimensional Diagrams, Star and Snowflake Schemas.

DB Utilities

SQL Server Management Utilities, Query Analyzer.

GUI

DTS Import/Export, SQL Server Integration Services.

BI Tools

SSIS/SSRS/SSAS, SSBI Development Studio, Crystal Reports.

Reporting Tools

MS Access, Excel, and MS SQL Server Reporting Services2000/2005/2008 R2/2012, SSIS, SSAS and Share Point.

Operating Systems

Windows 7/Vista/XP/NT/2000/2003/2008.

Version control tools

Visual Source Safe (VSS), Subversion (SVN), Team Foundation Server (TFS)

Others

ER-Win, MS Office.

Professional Experience:

Client: BHP Billiton, Houston, TX Dec 2013-Present

Role: Sr. MSBI Developer (SSIS/SSRS/SSAS Developer)

Description:

BHP Billiton was created in 2001 through the merger of the Australian Broken Hill Proprietary Company Limited (BHP) and the Anglo–Dutch Billiton The result is a dual-listed company. The Australia-registered BHP Billiton Limited, which has equal financial share in the company, has a primary listing on the Australian Securities Exchange and is the largest company in Australia measured by market capitalization. The UK-registered BHP Billiton Plc has a primary listing on the London Stock Exchange and is a constituent of the FTSE 100 Index.

Responsibilities:

●Understanding the business requirements.

●Extracted the data from the different sources and stored the data into the intermediate Staging Database using the SSIS ETL tool.

●Transformed Complex business requirements into ETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, and Lookup.

●Maintained all the SQL documents which included installation and data conversion Procedure documents.

●Experienced on Tableau Admin activities, Multidimensional database and writing SQL queries

●Performed relational data modeling (Logical & Physical) & dimension data modeling. Explored No SQL Databases such as MangoDB & DynamoDB (AWS), TALEND.

●Microsoft SQL Server Analysis Services (SSAS) and MDX for data warehouse and data mart solutions in Financial, Retail, Healthcare, and Insurance.

●Provided ongoing Qlikview implementation and support.

●Architect and execute Business Intelligence solutions for top level managements, research associates, quality team, physicians and other organization level BI users

●Migrated all the reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0 after testing the version on Sand Box.

●Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2012.

●Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.

● Extracted data from various sources like SQL Server 2012, Oracle 11g, IBM DB2, Flat files, XML and Web services from Client servers and through FTP.

●Managed SQL Server environments, by configuring a facet in one instance of SQL Server, copy the state of the facet to a file, and then import that file into another instance of SQL Server as a policy

●Created highly formatted reports to visually represent data using Crystal Xcelsius.

●Support MSFT enterprise product strategies by Showcasing latest RTM & SPs versions.

●Experience in creating Multidimensional cubes using SSAS and designing DW schemas

●Extracted and transformed data from various sources such as Pervasive database, SQL server, Excel, Access and flat files using SSIS into destination tables as per the business requirements.

●Experience with Performance Tuning for Oracle RDBMS using Explain Plan

●Testing software was written using .NET 3.5, Visual Studio 2008, ASP.NET, C#, ADO, and SQL Server 2008.

●Created parameter driven reports in Access and Excel running thru Access VBA front-end.

●Experience in multiple visualization tools such as Microsoft Power BI (Power Pivot, Power Map, Power View, Power Query) and Tableau 8.0/8.3.

●Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 2008R2.

●Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.

●Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.

●Experience in implementing MDM (Master Data Management) using SQL Server 2012

●Used SSIS, DMExpress to import data from two different sources (Teradata, Oracle) to a single destination like SQL Server 2008.

●Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.

●Experienced in implementation of strong referential integrity and auditing with the use of triggers.

●Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS Sql server 2012.

●Developed fact tables, dimensional tables, cubes for OLAP warehouse using Analysis Services

●Extensive experience with accessing data from database including its functionality and structure: ORACLE, Teradata, MS SQL and MS Access.

●Deployed the SSIS Packages to the MSDB as well as File System based on the requirements

●Involved in the development of custom SQL, T-SQL, custom stored procedures, functions and triggers.

●Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQL Server Agent job and windows Scheduler.

●Experience in Dimensional modeling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.

● Included in the Hadoop POC as well as the Parallel Data Warehouse selection process.

●Created copies of operational Databases using the Import/Export Wizard.

●Developed Cross-Tabbed and Sub-Reports in SSRS2008R2.

●Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2012.

●Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.

●Created complex SSIS packages using various transformations.

●ETL process was documented for future references.

Environment: Microsoft SQL Server 2008R2/2012, SQL Server Reporting Services (SSRS), Management studio, Hadoop, XML, Qlikview,MS Access VBA, SQL Server Integration Services (SSIS), Windows Server XP.

Client: SWBC SAN ANTONIO, Texas. Oct 2011-Nov 2013

Role: MS SQL BI DEVELOPER (SSIS/SSRS/SSAS Developer)/ETL Developer

Description:

Southwest Business Corporation (SWBC) is a diversified financial services company providing a wide range of insurance, mortgage, and investment services to financial institutions, businesses, and individuals. Headquartered in San Antonio, Texas, SWBC employs nearly 2,000 people nationwide and is licensed to do business in all 50 U.S. states. SWBC is privately held by co-founders Chairman Charlie Amato and President Gary Dudley. Although privately held, a public accounting firm audits the company's operations and financials on an annual basis.

Responsibilities:

●Actively interacted with end users, team lead, and business analysts to fully understand the requirements.

●Developing database and data feed solutions; administering databases and database servers.

●Attended weekly meeting with the stakeholders to update the work according to the requirements.

●Participating in the build and deployment cycle.

●Contributing in all phases of development projects while providing support to existing clients.

●Designed and maintained Qlikview applications.

●Created/developed/maintained the stored procedures, triggers to interpret complex business rules.

●Automated formatting of rows and columns using VBA.

●Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.

●Performed Data modeling organizing the data and provide proper structure to database by implementing constraints to tables.

●Extensively involved in debugging and tuning of T-SQL queries, SSIS packages and SSRS reports.

● Experienced in Xcelsius for creating dashboards including What-if presentation, Alerts, Drill Down, Filtered Rows and Dynamic visibility

●Designed DDL and DML for MS SQL Server 2000

●Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally loaded into the Database.

●Implemented full text indexes for property address searches.

●Involved in database backup and restore mechanisms.

●Created SSRS report templates for ease of report development.

●Created daily, weekly, monthly, quarterly, semi-annual and annual SSRS reports for Military commanders.

●Moving system and users database files (data and log files) to proper SAN drives as per MSFT recommendation.

●Used TFS to Check in and check out SSIS packages, SSRS Reports and database code (Version Control).

●Documented all the coding standards and procedures.

Environment: SQL Server 2008R2/2012,VBA, Microsoft Business Intelligence Development Studio, T-SQL, SSIS, SSRS, SQL Profiler.

Client: NGS, INDIANAPOLIS Oct 2009-Aug 2011

Role: SQL Server Developer

Description:

Headquartered in Indianapolis, Indiana, National Government Services is a leading provider of federal health solutions. We employ approximately 2,700 associates in 17 locations across the country. As a Medicare contractor since 1966, our associates proudly serve more than 30 million Medicare beneficiaries. In the arena of government health care, we are pioneers of technology, advanced solutions and methodologies that significantly improve operational performance for our clients. With a specific focus on large-scale systems integration, infrastructure services, application development and hosting, our Information Technology team is nationally recognized for delivering secure and reliable solutions for federal agencies.

Responsibilities:

●Created and maintained the database for all the products.

●Teamed with developers to create the most optimal code and database connectivity to meet client-timing requirements.

●Worked on stored procedures, triggers and also on large number of business analytical functions.

●Add and modify all required tables/databases to support the requests from the system analysts and the systems Integrator and provide daily production support for the operations of databases.

●Created SSIS Packages using SSIS Designer for export heterogeneous data from Excel Spreadsheet to SQL Server 2008R2.

●Experience in writing Excel macro's using VBA and delivering Excel reports to the Business analysts.

●Scheduling the SSIS packages and Jobs.

●Developed applications using ASP.NET, C#, WCF, MVC, LINQ to SQL, ADO.Net Entity Framework and Web API

●Hands-on training in the use, maintenance, and development of databases using MS SQL Server 2000.

●Involved in supporting and maintaining the database servers, performing database installation, configuration, and upgrade.

●Involved in designing, implementing of database backup and restore procedures.

●Responsible for creating summary Reports, Sub Reports, Drill down Report, dynamic grouping.

●Created automated reports using SSRS (SQL Server Reporting Services).

●Monitored server performance, creating user logins and granting security privileges.

●Create alerts, notifications and emails for system errors, insufficient resources, fatal database errors, and hardware errors.

●Migrated stored procedures and databases from one server to another.

Environment: Windows 2003 Server, VBA,MS-SQL Server 2000/2008R2, HTML, XML, and MS Office 2003.

Client: British Gas Limited, London Sep 2008- July 2009

Role: SQL Developer/ETL Developer

Description:

British Gas is the leading Power Supply provider across Great Britain. The project involves handling the accounts system of the customers involving data migration between various systems. Application that synchronises the data transfer between various databases on various servers involving account handling and data transfer to the handheld systems. Handling the data on a account maintenance platform involving data cleansing. Enhancing the reporting system to meet the SLA’s (Service Level Agreements) of the Client and reporting according with daily, weekly, monthly, quarterly and yearly statistics. Process involves validating the data before loading on to the Application Platform, checking various factors of the accounts and migration of the data from flat files to the Application System via ETL imports. Scheduling the processes accordingly for efficient outcome of the functionality.

Responsibilities:

●Involved in analysis, design, development, and enhancement of the data warehousing application.

●Installation and configuration of MS SQL Server.

●Created DTS packages for the data cleansing/transfer and transformation.

●Responsible for design and Normalization of the database tables.

●Modified the current stored procedures to meet current design.

●Created indexed views, and appropriate indexes to cut the complex query time.

●Provided day-to-day administration tasks like space and log management.

●Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS package.

● Assisted with automation of manual processes by writing VBA code and using macros

And formulas to speed processes and maximize accuracy.

●Design and implementation of Replication solution for SQL Server 2008R2.

●Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.

●Performed Performance tune SQL statements, queries, triggers and stored procedures using SQL profiler.

●Created SSIS package to get data from different sources, consolidate and merge into one single source.

●Developed SSIS packages using different types of Error Handling for various events.

●Involved in report creation using SQL Server Reporting Services (SSRS), and Excel spreadsheet as per the client Requirement and for the periodic analysis.

●Created Tabular and Matrix Reports Quarterly, Semi-Annually and annually by using SSRS.

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

Environment: MS SQL Server 2008, VBA,SSIS 2005/2008, Crystal Reports 7/8, MS Excel, and MS Office.

Client: ADP India. Pvt Ltd– India July 2007 -June 2008

Role: Jr.SQL Developer

Description: HR Perspective Makes human resource, payroll and benefits information instantly available to Employees and Managers through a Web -based self-service solution. Eliminates many routine, Time-consuming tasks and streamlines day-to-day HR transactions in key areas such as: Employee Administration, Self Service, Benefits Administration, Compliance, Compensation, Recruitment, Performance & Development, Safety & Health, Succession Planning, Time –off Management and Organization Management.

Responsibilities:

Developing packages, procedures, functions, and triggers for the application.

Performing the tests on the newly coded procedures and documenting the same.

Writing technical documents using the functional specifications.

Writing PL/SQL code using the technical and functional specifications.

Creating SQL objects like tables, types, packages, procedures and functions.

Optimized the queries to improve the performance of the application.

Environment: MS SQL Server 2005, MS Excel, and MS Office.

Contact this candidate