Sql Server Data
Resume:
Harsha S
SQL BI Developer
Phone: 216-***-****
Email: *********.*****@*****.***
TECHNICAL SUMMARY
Over 8 years of IT experience in Data Warehousing, Data Transformation Services (DTS). and development in Microsoft SQL Server Suite of Products.
Expert in working with the Business Intelligence Development Studio (BIDS), which includes SQL server Integrated Services (SSIS), SQL Server Analytical Services (SSAS) and SQL Server Reporting Services (SSRS).
Good hands-on working experience with using all kinds of SQL Server Constraints (tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
Proficient in OLTP, OLAP and Data Warehousing Design concepts.
Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, Top N, parameterized reports, Cascade Parameterized, Reports Summary, Sub reports and formatting them.
Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users.
Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data
Connection.
Developed reports using global variables, expressions and functions using SSRS.
Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
Involve in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and Analysis Services cubes.
Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
Experience in Dimensional Modeling, ER Modeling, Relational, Multi-Dimensional (Star), Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
Involved in complete SDLC, which includes requirement gathering, analysis, design, development and Implementation.
Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler.
Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL.
Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.
Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.
Experience in Technical and Functional side of the Team Foundation Server Components (Source Control, Work Items, TFS Builds, Reporting, SharePoint)
Produce standard monthly reports using Tableau.
Developing highly interactive business intelligence solutions using Qlik Sense software.
Experience in creating XML files and XSD schema files.
Excellent knowledge on Object Oriented Analysis and Design concepts.
Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
EDUCATION
Bachelor of Technology in Computer Science.
TECHNICAL SKILL SET
Data Warehousing/BI Tools
SQL Server Business Intelligence Development – SSIS, SSAS, SSRS, DTS, Performance Point Server, Self-service BI (Power Pivot, Power View, Power Map, Power Query)
RDBMS/DBMS
MS SQL SERVER 2014/12/08/05, ORACLE 9i/10g, MS Access
Database tools
Management Studio, Enterprise manager, Query Analyzer, DTS, BCP, OSQL, Performance Monitor, Client Configuration Utility, Server Configuration Utility, SQL Agent, SQL main
t-utility, SQL Mail, SQL Trace, Visio, SQL Server Agent
Web Technologies
HTML, DHTML, XML, XSLT, XMLA, IIS, Apache.
Programming Languages
C#.net, VB.net, Java, JavaScript, VBScript
Protocols / Middleware
TCP/IP, HTTP, FTP, UDP/IP, DOM, ODBC
Operating Systems
Windows 10/08/07, Ubuntu, Unix
Reporting Tools
SQL Server Reporting Services, MS Excel, Oracle Report Builder
PROFESSIONAL EXPERIENCE
Inovalon, Bowie, MD May 2015– Till Date
SQL/SSIS/SSRS/SSAS Developer
Responsibilities:
Collected business requirements from users and translated them as Business Requirement Document.
Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
Used BCP command line utility to replicate a database.
Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers & maintaining Referential Integrity.
Used Recompile and with option query hints to avoid parameter sniffing problems.
Improved query performance by adding covered indexes, adding file groups.
Worked on designing, creating and deploying SSIS packages for transferring data from flat files, Excel, Oracle, XML and heterogeneous data to and from SQL Server.
Implemented Event Handlers and Error Handling in SSIS packages, notified process results to various user communities and scheduled the SSIS jobs using SQL server agent.
Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
Successfully migrated SSIS packages from development to test to Production environments using SSIS Package Configuration files and deployment wizard.
Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
Automate monthly excel reports into Tableau Workbooks and Dashboards.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Created standard Reports and Chart Reports, Cross Tab Reports and Drill Through reports.
Generated Reports using Global Variables, Expressions and Functions for the reports.
Created Stepped and Blocked reports using SSRS.
Responsible for scheduling the subscription reports with the subscription report wizard.
Generated reports using the Reporting Services analyzed using Server analysis (SSAS).
Responsible for maintaining cubes using SSAS and populate the cubes with the data.
Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing SSAS Cubes.
Setup various Team Projects into different Team Project Collections in TFS 2010.
Analyzing and creating database structures for QlikView application.
Evaluated and lead the conversion to using Team Foundation Server for integrated source control, builds, testing, and deployment and lead upgrades of TFS.
Environment: SQL Server 2008 R2/2012 Enterprise Edition, SSIS, SSRS, SharePoint, PL/SQL, C#, Visual Studio 2010 & 2013, MS Visio 2007, Team Foundation Server (TFS).
Marlette Funding, Wilmington, DE Feb 2014 - Apr 2015
SQL/SSIS/SSRS/SSAS Developer
Responsibilities:
Participated in gathering User Requirements and System Specifications.
Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Implemented the concept of Incremental Data Load and Slowly Changing Dimension (SCD) Type 2 for dimension packages to move data from staging to dimension tables in SSIS.
Implemented Package Configurations, Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
Created Drill-through, Drill-down, Chart Reports, Cross Tab Reports and Sub-Report using RDL.
Design, deployment, and maintenance of various SSRS Reports in SQL Server.
Designed and implemented Parameterized and cascading parameterized reports using SSRS.
Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
Created OLAP Dimensions, Measures and Cubes using SSAS.
Created components, tools, techniques, methods and procedures used in an on OLAP
environment for accessing and translating data into understandable and usable business information using SSAS.
Migrated and recreated existing dimensions and cubes using star schema on 2008 server to achieve the efficiency of SSAS.
Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
Designed ETL processes to feed QlikView applications.
Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
Environment: MS SQL Server 2008R2/2012, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), MS EXCEL, SQL Server Profiler, Team Foundation Server (TFS).
Humana Healthcare, Louisville, KY Nov 2012 – Jan 2014
SQL /SSIS/SSRS/SSAS Developer
Responsibilities:
Worked as a developer in creating complex Stored Procedures, Triggers, Functions.
Developed Triggers to raise events on executing insert, delete and update stored procedures.
Optimized existing stored procedures to achieve improved performance.
Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.
Developed logical and physical data models using data modeling tools such as Erwin and ER/Studio.
Conducted data migration processes in the SQL Server environment using SQL Server Integration Services.
Developed XML tags to structure data and improve the data migration process.
Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 9i/10g.
Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
Worked on SSIS performance tuning using counters, Error handling, Event handling, re-running of failed SSIS packages using Checkpoints.
Worked with Transactional and Snap-shot Fact-Tables.
Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, and Parameterized Reports in SSRS.
Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server Analysis Services (SSAS).
Expert in using tools like MS SQL Profiler, Database Engine Tuning Wizard, Windows Performance Monitor and tuning SQL Server performance.
Environment: SQL Server 2008, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), VB, MS Access, Visual Studio, T-SQL, Windows XP.
PepsiCo, White Plains, NY Jan 2012 – Oct 2012
SQL /SSIS/SSRS Developer
Responsibilities:
Participated in the requirements elicitation and technical specification processes.
Developed stored procedures, triggers, cursors, views, audit tables in SQL Server.
Designed Entity-Relationship diagrams and thus the database schema.
Performed job scheduling in the SQL Server Environment.
Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc.
Used various Control flow tasks like For Loop, Execute package/SQL tasks, Script task, send mail task and different data flow tasks/transformation.
Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
Deployed and scheduled reports using SSRS to generate all daily, weekly and monthly reports.
Responsible for ongoing maintenance and change management to existing reports and Optimize report performance in SSRS-2008.
Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
Environment: SQL Server 2005/2008 Enterprise Edition, SQL, SSRS, SSIS, MS SharePoint, MS Access, Windows 2003 platform, VB.NET, ERWIN, SQL Server Management Studio, Visual Studio.
CMC Ltd, Hyderabad, India Oct 2010 - Dec 2011
SQL/SSIS Developer
Responsibilities:
Created Business Requirements, Design, Functional Specifications and Flowcharts.
Install, tune, maintain, Configure and monitor SQL Server for the Production environment.
Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
Designed, coded, tested and implemented user interfaces, procedures and functions for new and existing software application requirements.
Created SSIS package to get data from different sources, consolidate and merge into one single source.
Implemented Extraction, Transformation and Load (ETL), Import, Export activities by SSIS package.
Experience in enhancing and deploying the SSIS Packages from development server to production server.
Worked Extensively on ETL process using SSIS packages.
Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.
Performed DBA tasks like Backup, Restoration of tables and Stored Procedures and Refreshing Databases on weekly basis.
Environment: SQL Server 2008, BIDS, SSIS, SSRS, Crystal Reports, Visual Studio, T-SQL, Windows XP.
GrapeSoft, Hyderabad, India Aug 2008 – Sep 2010
Jr. Web/SQL Developer
Responsibilities:
Involved in the life-cycle of the project, i.e., requirements gathering, design, development, testing and maintenance of the database.
Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server.
Conducted data import and export operations using the DTS wizard.
Developed SQL Server objects such as tables, materialized views, clustered and non-clustered indexes, stored procedures, cursors, triggers and constraints.
Performed query optimization and tuning, debugging and maintenance of stored procedures.
Provided database security by using role base authorization on accessing data.
Used System tables and stored procedures to retrieve metadata.
Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
Backup and restore databases.
Administered the database using SQL Server Enterprise Manager.
Monitored SQL Server jobs, and developed queries to perform database operations.
Developed user friendly GUI using HTML and ASP.NET 1.0/1.1 to display and access data.
Provided back-end support for functional testing and performance testing.
Implemented database programming by using the ADO.NET object Model.
Environment: SQL Server 2000/2005, T-SQL, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Visual Source Safe, SQL Server Management Studio (SSMS).
Contact this candidate