Sql Server Data
Resume:
Bhanu
*****.*****@*****.***
Professional Summary
Over 8 years of strong IT experience with demonstrated success in the Database development, design, Administration and deployment of large-scale enterprise applications.
Expert in MS SQL Server 2014/2012/2008 suite of products like SSIS, SSRS and SSAS.
Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization and Data Modeling.
Extensive knowledge in T-SQL queries (DDL and DML) for developing complex Stored Procedures, Batch Scripts, Triggers, Tables, Views, Relational Database models and Data integrity, and SQL joins.
Extensive knowledge of addressing Performance Issues and involved in Index tuning, Data Profiling and optimized queries using query execution plan.
Excellent in working on SSIS, SSAS, SSRS, OLAP, OLTP, Reporting and Analytics, Data Cleansing, Data Scrubbing, Data Migration and writing T-SQL.
Expertise in developing SQL Server SSIS packages to import and transform data between databases and external data sources.
Experience working with REST API sources in SSIS
Retrieving data from a Power Pivot workbook that contains the data behind PivotTables and PivotCharts
Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Experience in Extraction &Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, AS400, and DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS utilities.
Experience in Performance Tuning for SSIS packages by using Row Transformations, Block and Unblock Transformations.
Experience in creating jobs, alerts and scheduling DTS/SSIS packages in SQL Server Agent on daily/weekly/monthly basis.
Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
Experience in developing Crystal Reports, Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder.
Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
Experience in Integrating SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS).
Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
Expert in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
Experience in creating MDX query in SSAS cube for various calculated members, KPI, Actions, Aggregation, Perspectives and various actions such as drill through, reporting etc.
Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
Created Dashboard pages in Performance Point Server that use different types of web parts and excel services for reports.
Experience in database administration and development activities such as Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services, and Database Security.
Expert in gathering business requirements and converting them into technical requirements
Implement/code reporting and database solutions using client standard coding and design standards which include MSSQL queries and stored procedures Implement and test solution architecture
Maintain and Monitoring of Various SSRS reports, SQL code, store procedures and Solving Tickets on Daily Basis for Production Issues.
Experience in providing 24 x 7 production support.
Excellent communication skills, organizing skills, highly punctual and an excellent listener.
Proven experience in project and team leading with minimal defect delivery. Equally comfortable working independently as well as in a team environment
Ability to work in a team and as an individual with minimal supervision.
EDUCATION:
Bachelors in Computer Science, JNTU, Hyderabad, India
TECHNICAL SKILLS:
Programming Skills: T-SQL, C, HTML, XML, JavaScript, ASP.NET, VB, C#
Databases: Microsoft SQL 2014/2012/2008, MySQL, SYBASE, MS ACCESS
BI and ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),Pervasive Data Integrator, Adept SQL diff, Oracle SQL, Microsoft Visual Studio2010/2012, Cognos 10.2
Reporting Tools: Microsoft SQL SERVER 2005/2008/2012, Reporting Services (SSRS), Report Builder 2.0, Report Builder 3.0, Crystal reports 10, ProClarity, Tableau
Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables
Operating Systems: Microsoft Windows, UNIX, LINUX.
Tools and Utilities: Business Intelligence Development Studio (BIDS), Visual Studio 2013/2008, Share Point 2013, Team Foundation Server (TFS), Microsoft Word, Excel and PowerPoint.
Version Control Tools: VSS
PROFESSIONAL EXPERIENCE:
Client: Quidel Corp, San Diego, CA Oct 2016 – Present
SSIS/ETL Developer
Quidel Corporation is a California-based manufacturer of diagnostic healthcare solutions. This Project involved three stages of ETL development: Inbound, Internal and Outbound, to automate manual process of Salesforce account setup, manual distributor feed, ERP LN reports, merged accounts, contracts, denial reports and others.
Responsibilities:
Designed ETL SSIS packages for loading data files provided by the external vendor into our datawarehouse, generating reports for Sales Operations, supporting internal data warehouse applications, and generating Outbound files.
Automated the entire process of running the reports from Infor ERP LN and validating against existing data for new accounts and inserting them in Salesforce.
Developed complex SQL queries, Joins, Functions, CTEs, and Stored Procedures to generate reports.
Implemented SSIS packages to call Salesforce API to load data using Task Factory.
Implemented Standardizing Addresses for the legacy data in SalesForce by calling Smarty Streets API through REST API.
Responsibilities involve ETL development, unit tests, business validations, integration tests, defect resolution and production support.
The development technologies involved working with Microsoft SQL Server 2014, SQL Server Integration Services (SSIS), Task Factory Extension, Visual Studio 2012, Salesforce, MS Excel and TFS.
Worked closely with Business Analysts, data architects for business requirements, design standards, validations, and UAT tests.
Hands on experience in designing PowerShell code for SSIS Project deployments in SQL Server SSISDB, Pivot tables, VLOOKUP validations in Excel
Had a chance to optimize legacy system SSIS packages, SQL code using SQL execution plan, Indexing, Update Stats and documented ETL packages going through development process to assist other teams for future development purposes.
Environment: SQL Server 2014, SSIS, T-SQL, SSMS, C#, Excel 2013, TFS, Visual Studio 2013, Salesforce, info ERR LN, Cognos
Client: Broadridge Financial Solutions, Jersey City, NJ Feb 2015 – Oct 2016
SQL BI Developer
Broadridge engaged with a large client, North America based financial institution (online broker/dealer) back office conversion. The project is multiyear project involving application development and product changes on both Broadridge side and client side.
Responsibilities:
Part of a large technical team, responsible for development of database objects (schema changes, stored procedures implementation) and SSIS packages.
Understood Brokerage business knowledge and financial products.
Responsible of analyzing the existing data elements (Client specific schema) and mapping to Broadridge specific data elements.
Worked in Agile based environment involved to work closely with web, Mid-tier, BSA and QA to understand business requirements.
Responsibilities involve Requirement analysis, Design and prototyping, developing unit tests, bug fixes, maintenance and production support.
Responsible for adhering to our Programming, documentation and process standards.
The development technologies involved Microsoft SQL Server 2014, Microsoft SQL Server Integration Services (SSIS), Microsoft Visual Studio 2013, Microsoft Office, XML, Scripting (Visual Basic, C#), and Team Foundation Server (TFS).
Wrote complex SQL queries using joins, stored procedures, User Defined Functions, Views, Indexes XML Queues,
Wrote complex script tasks in C#, VB script for generating xml message to place into the queue.
Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all, For Loop, Foreach Loop, lookup, Derived Column and others.
Used various transforms in SSIS to load data from flat files and Excel files to the SQL databases.
Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.
Conducted ETL Design and prepared ETL design documents/technical specifications- Identify transformation rules using Talend.
Extracted the data from different Data Sources and transformed the data as per the user criteria and used the data in the SSAS cubes for the analysis.
Created reports to retrieve data using Stored Procedures that accept parameters.
Generated Sub-Reports, Drill down reports, Drill through reports, Parameterized reports using SSRS and created various types of reports like chart, tabled, matrix and linked reports and maintained accurate and complete documentation for all packages.
Created code reviews for DB objects in code collaborator and get them debugged before they check-in into TFS and QA roll out.
Handling tickets for Database deployments into QA, QFinal and Production Environments
Worked on various QA and Production Defects.
Handled multiple tasks, in-depth knowledge in agile environments and worked hard to produce best results.
Environment: SQL Server 2014/2012/2008, SSIS, T-SQL, SSMS, C# scripting, BIDS, Excel 2010, SharePoint 2013, TFS, Visual Studio 2013/2008, Code Collaborator Client, Rally, ServiceNow.
Client: PIER1 IMPORTS. - Fort Worth, TX Jan 2014 – Feb 2015
SQL BI Developer
Pier 1 Imports, the leading home furnishings specialty retailer, provides link between the suppliers and customers. The project involved developing and testing SSIS Packages to deal with high volume processing output loading data from different systems into master data warehouse and providing data to various teams. Also worked on creating Reports using Microsoft SQL Server environment for loss prevention and auditing teams for fraud prevention and balancing sales.
Responsibilities:
Performed Server installation and configuration using SQL Server 2012.
Created Packages that Transfers Databases from One SQL Server instance to Another Instance and Scheduled the SSIS package for migration of data from old system to MS SQL 2012.
Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous sources.
Used various transforms in SSIS to load data from flat files and Excel files to the SQL databases.
Developed and maintained critical applications for sales auditing team by balancing sales and settlements of credit amounts with the bank on a day to day basis.
Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts and SSRS reports.
Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
Worked on multidimensional data modeling.
Participated in Databases Architecture and data modeling design.
Reviewed and developed data models and database designs with development teams
Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2012.
Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.
Planned Backup strategy based on projects requirements.
Responsible for database backup and Restore, Creating Roles, Granting access.
Worked on call support to resolve issues whenever needed.
Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)
Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel, & Windows 2003 server, Business Intelligent technologies like SSIS, SSRS.
Client: Argus, NYC, NY Feb2013 – Jan 2014
MS SQL Server Developer
Argus Group is a leading provider of independent commercial real estate consulting and advisory services, software and data solutions. Operates five interrelated Business Units, bringing together years of experience and a broad range of expertise into one comprehensive platform
Responsibilities:
Migrated the existing database from SQL Server 2008 to SQL Server 2012 and worked on improving the performance of the system.
Reports are also created for the banking process on the daily and weekly basis. These reports were reviewed by Directors and Analysts to calculate different categories like banking calculation. It also involved in creating new database from different scatter database.
Gathered requirements and acquired application knowledge from Business Managers.
Collect functional and application data requirements from customers.
Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form the existing diversified data sources.
Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
Created drill down and sub reports from reporting services (SSRS) that can be browsed on web.
Worked on relationships and hierarchies between attributes and measure groups and defined granularity with in a measure group and drill through actions in SSAS.
Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
Developed reports using SSRS 2008 mainly parameterized reports.
Developed report specifications, created and modified reports using SSRS 2008, deployed, and maintained of various SSRS Reports in SQL Server 20012.
Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard.
Worked on error handling a module consisting of data from bank, transactions, and currencies, countries, master and static.
Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
Actively involved in Normalization & De-normalization of database.
Planned a complete backup on the database and restored database from disaster recovery.
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.
Worked on designing ETL packages using SQL Server 2012.
Used “SQL Profiler T-SQL Duration” template for tracking execution time of T-SQL Statements.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.
Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
Environment: SQL Server 2012/2008/2005, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), Crystal Reports, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Index Analyzer DTS, MS SQL SERVER, T-SQL, MDX, Windows 95/NT/2000/2003, XML, MS Excel and MS Access, Visual Team Foundation Server, Crystal Reports, TOAD, visual studio 2008, Visual studio 2012, Talend.
Client: Humana, Lexington, KY Jan 2012 – Feb 2013
SQL BI (SSIS/SSRS/SSAS) Developer
Humana is a Health insurance provider concentrates on the Medical, Dental, Vison pharmacy, and Medicare. Humana is standing as one of the most trusted insurance company in the United States offering the plans covering the needs of the customers.
Responsibilities:
Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan in SSMS
Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005/2008/2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services
Experience in developing the Drill down, Drill through, Parameterized reports using SSRS
Experience in creating stored procedures, triggers, Views, cursors, CTE’s, T-SQL scripts, schemas, permissions and performance issues with client/server database design
Defined Check constraints, Business Rules, Indexes, and Views
Identified and worked with Parameters for parameterized reports in SSRS 2005/2008
Experience in creating and managing stored procedures, indexes, views, UDF’s, Database Constrains, to meet business requirements and policies.
Good Knowledge in Designing and Building the Dimensions and cubes with star schema and writing MDX queries using SQL Server Analysis Services (SSAS)
Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts
Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes
Experience in writing the SQL Statements, PL SQL, SQL* plus Commands for modifying and retrieving the data.
Client: Minacs Marketing Solutions, Flemington Hills, MI Nov 2010 - Jan 2012
SQL Server, SSIS/ SSRS Developer
Minacs marketing is a premier Channel direct marketing and specialist incomplete marketing optimization and enablement solutions provider to the notable array of client includes world largest automakers and industry manufacturers
Responsibilities:
Create User Defined Functions, Stored Procedures, and Triggers
Performed data conversions from Flat files into a normalized database structure.
Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
Managed up gradation of DTS packages to SSIS packages
Created triggers, views, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective
Experience in developing the Cubes using SQL server analysis services (SSAS), with star schema and snow flake schemas
Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
Knowledge in the IBM Congo’s tool for the changes in the packages and reports using the Framework Manager and Report Studio
Experience in collecting the user requirements and documenting by creating the use case and flow activity diagrams
Responsible for creating constraints, Indexes, and Views
Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary
Identified and worked with Parameters for parameterized reports in SSRS
Used Database Maintenance Wizard to make necessary changes and to keep the performance of the server at acceptable levels
Configured Server for sending automatic mails to when a DTS process fails or succeeds
Transformed data from various data sources using DTS packages
Experience in creating the OLAP multidimensional cubes and writing MDX expressions using SQL Server Analysis Services
Created Crystal Reports on daily, weekly and monthly basis for manager’s review
Responsible for MS SQL Server 2000 in Production, Test, Development and Replication &Cluster Server Environments
Environment: SQL Server 2000, Windows 2000 Advance Server, Windows 2003 Server, XML, T-SQL, MS Excel, MS Access,VB.NET 3.0 and DTS, CRYSTAL Reports, SSIS, SSRS, SSAS, MS SQL.
Client: Larsen & Toubro Ltd Hyderabad, India Aug 2008– Sep 2010
SQL Server Developer/DBA Trainee
Larsen & Toubro Limited (L&T) is a technology-driven engineering and construction organization, and one of the largest companies in India's private sector. It has additional interests in manufacturing, services and Information Technology. L&T has an international presence, with a global spread of offices.
Responsibilities:
Involved in installation, configuration and administration of SQL server 2005 and 2008 on Servers.
Install, configure, administer and secure Sybase 12.X and 15.X databases using UNIX/LINUX operating systems.
Applied patches and service packs to keep the database at current patch level.
Successfully resolving SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, SSIS, backup/restore, database corruption, security, and contribute to continuous improvement.
Learned to Implement database standards, naming convention for the database objects and maintain database security.
Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined data types and functions.
Responsible for installation and configuration of Oracle 9i and 10g database servers on a UNIX platform.
Implemented trigger and stored procedures and enforced business rules via checks and constraints.
Involved in data conversions and data loads from various databases and file structures.
Monitor failed and long running MS SQL Server jobs.
Environment: SQL Server 2008/2005, UNIX/ LINUX, DTS, T-SQL, Crystal reports7.
Contact this candidate