Sql Server Data
Resume:
Ravi Kanth
***************@*****.***
SUMMARY:
• Over 7 years of IT experience in Database Design, Development, Implementation and Administration in SQL Server 2008/2005/2000 and providing ETL/Business Intelligence solutions using Microsoft components.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005 and 2008.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including Performance Point Server 2007 (PPS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Microsoft Office SharePoint Server (MOSS) in SQL Server 2005.
• Experience in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other tasks using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in creating dash boards and dash board elements using SQL server analysis services.
• Strong understanding of RDBMS concepts and Data Modeling Concepts.
• Data modeling experience using Dimensional Data Modeling and Relational Data Modeling, SQL Tuning, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling, Oracle Designer & Visio.
• Experience with handling moderate to large tables/databases, Query performance tuning, Distributed Transaction, Distributed Queries/Linked Servers.
• Experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data management, data dictionaries, and data integrity.
• Experience with production, development, and test databases including access controlling, performance monitoring and tuning, capacity planning.
• Extensive experience in ETL design/development using MS DTS and SSIS including data extraction and transformation between multiple data sources (Oracle, MS Access, and MS Excel).
• Hands on experience in creating the MDX cubes and dimensions.(SSAS)
• Experience in Creating and Deployment and Administration of SSIS and SSRS packages.
• Experienced in report generation using XML, Crystal Reports, SQL Server Reporting Services (SSRS) and Excel spreadsheet.
• Experience in generating drill down Reports, handling parameterized Reports in SSRS 2005.
• Good knowledge on creating score cards and dashboards using MS Office Performance Point Server 2007(MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services
• Experience in designing and developing reports using different tools such as Visual Studio and Report Builder.
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN.
• Experience in data migration from Oracle/Access/Excel Sheets/Flat Files to SQL Server 2005/2000/7.0
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SSAS and Essbase Hyperion.
• Experience in SQL database design, architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams that require the file.
• SQL Server 2005 OLAP Database Development including KPIs, Data mining, working with changing dimensions.
• Experience with Power shell language in writing complex T-SQL Scripts.
• Experienced in creating Jobs, Alerts using SQL Mail Agent. Well versed in various high availability solutions like clustering, mirroring, log shipping.
• Excellent backend skills in creating SQL Data Objects.
• Experiences in devising Disaster recovery strategies and effectively testing them. Experience in managing security, creating security policies and rules.
• Experience of Bulk Insert, BCP utilities and scripts for data transforming and loading.
• Experience in deploying SQL Server Analysis Services Projects using MS SQL Server 2005.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience of designing strategies to maintain audit tables, load balance, exception handling and high data volumes Experience with software development life cycle (SDLC) and project management methodologies.
TECHNICAL SKILLS:
Languages SQL, T-SQL , PL/SQL,.Net(C#,ASP,VB)
SQL Server Tools Management Studio, Business Intelligence Development Studio,
Enterprise Manager, Query Analyzer, Profiler, Performance Monitor,
Database Tuning Wizard
Databases SQL Server 2008R2/2008/2005/2000, MS Access, oracle 8i/9i/10g
Operating Systems Windows Server 2008/2003/2000, UNIX, Linux
ETL SSIS, BCP, Import/Export Wizard, BI Studio
Data Modeling Erwin Data modeler, ER Studio, Access
Web Technologies/ Tools HTML, DHTML, XML, Visual Studio, MS Front page
OLAP Tools SSAS, MS Excel
Reporting Tools Visual Studio , Report Builder , SSRS, Crystal Reports
Web Servers IIS, APACHE Tomcat
PROFESSIONAL EXPERIENCE:
IMS Health, Aug 2011- Till date
Manchester, NH
SQL BI Consultant (SSIS/ODS).
IMS Health is a global company that provides information, services and technology for the healthcare industry. IMS Health provides analytics, on-shore and off-shore commercial services, and business intelligence platforms to its healthcare clients in more than 100 countries. IMS also uses their own data to produce syndicated reports such as market forecasts. These predict how a market in a specific country or specific therapy area will change over time. This works through the production of baseline projections of sales and the application of different future events to this baseline to produce a forecast.
• Creating the packages and loading up into the ODS Server.
• Used Active-X scripting in SSIS for transformation of data into staging tables and performed multitask data pump in SSIS/ETL.
• Designed and implemented complex SSIS package to extract data from multiple data sources for analyzer
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SSIS.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data Migration with SQL server 2005 Integration services (SSIS).
• Developed SSIS templates which can be used to develop SSIS packages such a way that they can be dynamically deployed into develops, test and production environments.
• Created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Worked Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, active script task, Message Queue Task, XML task.
• Involved in Disaster recovery, database maintenance plan and Implemented replication.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Involved in Performance tuning and Query Optimization.
• Designed high level ETL Architecture for overall data transfer from the Source Server to the Enterprise Services Warehouse.
• Developed export module which can directly export data to xml and text file and also integrated with E-mail, so they can get E-mail notifications.
• Transformations of data such as adding derived column and sorting of data.
• Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Executed the specified pass-through Open Query on the specified linked server.
• Worked on SQL Profiler and Estimated Query plan to optimize the performance of SQL queries and stored procedures.
• Extracted data from multidimensional cube and designed parameterized reports using SQL Server Reporting Service.
• Proficiently created drill down reports, linked reports, drill through reports and sub reports using SSRS.
• Proficiently created and manage roles and security of reports and scheduled the Subscription of Reports using SSRS.
• Experience in writing MDX Scripting, MDX Queries, calculated Members and Named Set and XML for Analysis (XMLA) which can be used to perform administrative tasks in SSAS.
• Evaluating Source systems, standardizing received data formats, understanding business/data transformation rules, business structure and hierarchy relationships.
• Hands on experience in tuning, mappings, and resolving performance bottlenecks.
• Imported and Exported data from homogeneous and heterogeneous sources using SQL Server tools such as SQL Server Integration Services.
• Used RANK and PARTITION features in SQL Server 2005.
Environment:
MS SQL Server 2000/2005/2008, SSIS/SSAS/SSRS, ODS, MS Access, Windows NT , Windows XP/2003/2000/98, ERWIN 7.0 , MS VISIO, MS SQL , SQL Profiler, SQL Query Analyzer, MS SQL Server Integration Services 2008/2005, DTS, ASP.NET, MS Visio 2003, MS Office 97/2003/2007.
GlaxoSmithKline
Boston Jan 2011-July 2011
SQL BI Consultant (SSIS/SSRS)
One of the few pharmaceutical companies researching both medicines and vaccines for the World Health Organization’s three priority diseases – HIV/AIDS, tuberculosis and malaria, and are very proud to have developed some of the leading global medicines in these fields.
Forward thinking enables firm to successfully pioneer and deliver new and innovative medicines for a world that is waiting. Recognize the value in seeking collaborations with like-minded companies, whose own similar promise to the world can only strengthen with the right collaborator and committed to finding talent, ideas and new medicines beyond the walls of our internal Research and Development (R&D) community.
Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS
Implemented SQL Server SSIS packages for ETL methodologies
Installed, configured and maintained SQL Server Integration Services (SSIS).
Migrated DTS packages to SSIS Packages
Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB etc to Access etc
Migrated Data from SQL server 2005 to SQL Server 2008 using SSIS.
Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
Deployed reports in to Report Manager.
Created Ad-Hoc reports using Report Builder.
Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
Developed reports using SSRS and published as PDF, Excel, and CSV formats.
Experience with the Share point 2007 to upload the SSRS reports to Web portal.
Developed complex stored procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
Implemented SQL Server OLAP services (SSAS) for building the data cubes.
Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
Create prototype SQL Server 2005 Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM)
Working on Analysis services (SSAS 2005) to create multidimensional cubes to slice and dice the data.
Created the star schema for OLAP reporting data archiving and data marts
Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
Responsible for database design, including optimizing the database schema and coding database procedures/queries.
Environment: SQL Server 2005, SSIS, SSRS,SSAS, Query Analyzer, Index Tuning Wizard-SQL MS Access, MS Excel, ERWIN, T-SQL, PL/SQL, MDX, DB2 , VS2008/2005, XML, HTML,
Aetna,
Hartford, CT, Feb 2010 –Jan 2011
SQL BI Consultant (SSAS/SSIS)
Responsibilities:
Involved in installation and configuration of SQL Server 2005 and SQL Server 2008 with latest Service Packs
Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
Created various database objects such as tables, indexes and views based on the requirements.
Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
Developed the packages with monitoring features and logging so that information of the packages and their execution results are loaded into the designed error table.
Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB and Flat Files.
Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries, Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
Created and worked with drill down reports and identified the report parameters.
Used various report items like tables, sub report and charts to develop the reports in SSRS.
Deployed and generated reports on to the server using the Reporting Services Report Manager.
Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules And integrated reports in MOSS 2007 using web parts
Involved in setting up Performance Point Server and creating dashboards and scorecards in the PPS.
Performed daily maintenance operations on the Informatica Servers (Production, QA and Development) like monitoring the size, monitoring the log files and cleaning the logs that are older than a particular period using shell commands and scripts.
Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, Normalizer and Union to develop robust mappings using the Informatica Designer.
Environment: MS SQL Server 2008/2005, VS2008/2005, SSRS 2008/2005, SSAS, SSIS, Business Intelligence Development Studio (BIDS), T-SQL, PL/SQL, MDX, Microsoft Office SharePoint Server (MOSS ) 2007, Performance Point Server 2007. Informatica Power Center 8.6
Bank of America, NJ Nov 2008 – Jan 2010
Sr SQL BI Developer
Bank of America Corporation (NYSE: BAC) is a financial services company, the largest bank holding company in the United States, by assets, and the second largest bank by market capitalization. Bank of America serves clients in more than 150 countries and has a relationship with 99% of the U.S. Fortune 500 companies and 83% of the Fortune Global 500. The company is a member of the Federal Deposit Insurance Corporation (FDIC) and a component of both the S&P 500 Index and the Dow Jones Industrial Average.
As of 2010, Bank of America is the 5th largest company in the United States by total revenue, as well as the second largest non-oil company in the U.S. (after Wal-Mart). In 2010, Forbes listed Bank of America as the 3rd "best" large company in the world.
.
Responsibilities:
Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SSIS.
Involved in business requirement gathering and created functional/technical specification documents.
Developed physical data models and created DDL scripts to create database schema and database objects.
Designed data models using Erwin and Created new tables, written stored procedures, triggers for Application Developers and some user defined functions.
Created SQL scripts for tuning and scheduling.
Involved in performing data conversions from flat files into a normalized database structure.
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.
Provided disaster recovery procedures and policies for backup and recovery of Databases.
Performance Tuning in SQL Server 2000 using SQL Profiler and Data Loading.
Very extensively used SSIS Import/Export Wizard, for performing the ETL operations.
Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
Extensively worked on designing reports using SQL Server Reporting Services (SSRS). Developed Reports, Sub Reports, Data driven subscriptions, drill down reports using various features like Charts, graphs, filters etc.
Defined report layouts for formatting the report design as per the need.
Wrote queries for drill down reports to get the dataset required to build the report.
Identified and included report parameters for parameterized report.
Formatted the reports using Global variables and expressions.
Deployed generated reports onto the Report Server to access it through browser.
Maintained data integrity by performing validation checks.
Optimized queries, tuned and monitored server performance
Installing SQL Server Client side utilities and tools for all the front-end developers/programmers.
Involved in performance tuning to optimize SQL queries using query analyzer.
Environment: T-SQL, PL/SQL, MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports, Oracle 9i,
US Bank, Minneapolis, MN Jan’07 - Nov‘08
Sr SQL Developer (ETL)
Description: U.S Bank Product suite of cash management online services. This application helps entire organization to manage its financial position more efficiently by giving new levels of flexibility, control, speed and ease of use. The objective of the project concentrated on the reports they need. It was imperative for them that information be available on their workstations so that they can serve their clients efficiently
Involved in gathering requirements from Business Users, Analysts by scheduling meeting at regular basis.
Followed the four step procedure for building data warehouse solution which comprised of Analyzing Business Processes, Identifying the Grain, then identify Dimensions and Facts.
Created SQL Server Reports using SSRS 2005.Identified the data source and defined them to build the data source views.
Involved in debugging Reports and deploying Reports.
Created Tabular Reports, Cross Tab Reports and Sub Reports.
Scheduled the Reports to run automatically.
Extract Transform Load (ETL) development using SQL Server 2005,
Used data modeling tool Erwin for creating Logical, Physical data models and DDL’s.
Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
Enhancing and deploying the SSIS Packages from development server to production server.
Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
Used ANSI dynamic SQL for writing to the standard ANSI pre compilers using macro command lines.
Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
Used Performance Point Server to create interactive reports with an ability to drill down into details.
Experience in Performance Point Server powerful visualization tools, including the Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data.
Used Performance Point Server to identify KPI ‘S, build score boards, reports and dash boards
Created SSIS packages to migrate data from Oracle DB to SQL Server 2005.
Design, build, administer and production support of the BO reporting environment
Vendor Management i.e. to work with Business Objects customer support team to report & resolve issues/limitations/bugs in the off the shelf BO software.
Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
Developed complex T-SQL code for the application.
Environment: MS SQL Server 2005, ANSI SQL, SSAS, SSIS, BO XI, Informatica, MS SQL Server Reporting Services 2005 (SSRS), DDL, Erwin, SharePoint Moss Server,, ETL, Erwin, XML, HTML.
Inteq Software Pvt Ltd,
India May 2003 – Sept 2006
SQL Developer
Inteq offers a wide range of services in the area of application development. Inteq has the expertise and experience to identify the need, design and build the solutions right from scratch to finish such that it is tailor-made to the specific requirements of the customer.
Inteq provides a full life cycle support that starts right from the requirements gathering phase including business process re-engineering and progresses to the analysis of the requirements, technology and architecture determination, design, project planning, implementation, testing, deployment, post deployment support and finally maintenance .
Responsibilities:
Installation of SQL Server 2000 on Windows environment.
Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
Created Database Maintenance Plan for the Performance of SQL Server this includes Database Integrity
Checks, Update Statistics and Re-indexing.
Configured and managed merge replication database articles.
Developed DTS packages to transfer data from heterogeneous data sources and different files like Flat Files, Spread Sheets to SQL Server.
Data migration (import & export - BCP) from Text files to SQL Server 2000/7.0.
Created Triggers to enforce data and referential integrity.
Designed and developed Stored Procedures, functions and DTS packages and error handling using T-SQL for SQL Server 2000.
Created stored procedures/Packages using Pl/SQL programming according to the business requirements.
Performed Query Optimization by extensive use of Index implementation and Index Tuning Wizard.
Responsible for Oracle/SQL Databases and Application performance tuning, physical/logical design and optimization and availability.
Implemented and maintained industry standards in database management.
Monitored SQL server performance using SQL profiler, Index tuning advisor for query tuning, stored procs.
Maintained the database consistency with DBCC commands at regular intervals.
Environment: SQL Server 2000/7.0, Oracle 8i, Ms-Access, Windows 2000, Linux, C++, T-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, BCP, OSQL, DTS.
Contact this candidate