SQL DEVELOPER
Resume:
Sahithi
***********@*****.***
SUMMARY:
•With 7+ years of IT Professional experience in SQL Development, Client Analysis, Database Design, and Presentation using SQL Server 2014/2012/2008/R2/2005. Experience in various industries includes Financial Services, HealthCare, Insurance, Retail and pharmaceutical.
•Extensive experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL.
•Experience with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Implementation and Testing.
•Good Knowledge in MS SQL Server suite of products like SSRS, SSIS and SSAS.
•Expertise with DDL and DML statements, RDBMS, data dictionaries and normal forms.
•Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transform Services (DTS), Bulk Insert, BCP and XML.
•Experience in SQL Server DTS and SSIS (Integration Services) package design, development, and deployment using SQL 2008 advanced features in Control flow, data flow, Error Handling and event handling.
•Experience in end-user reporting definition, development and platform support using SQL Server Reporting Services (SSRS) and Performance Point.
•Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
•Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
•Extensive experience in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
•Expert in using generating Visual Studio 2008/2005/2000 Client Side Report, Tabular Reports, Matrix Reports, Drill down Reports, Parameterized Reports, Ad-hoc Reports, and Stylish Reports using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
•Strong working knowledge of Data Visualization in SSRS.
•Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
•Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension Table, Attributes, Hierarchy, Fact Table, Look up Table.
•Involved in developing OLAP dimensions, cubes, measures and calculated members with SQL Server Analysis Services 2005/2008.
•Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
•Good knowledge of Data Vault Modeling.
•Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
•Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
•Possess good communication skills.
SKILL SET:
OPERATING SYSTEMS:
Windows Server 2008/2012/2014/2016, Windows 8/10
DATABASES:
MS SQL Server 2008R2/2012/2014/2016
TOOLS:
SSIS, SSAS, SSRS, DTA, TFS, Rally, Share point, Erwin, Power BI, Beyond Compare, MS stack.
LANGUAGES:
T-SQL, PL/SQL, MDX query, Erwin.
PROFESSIONAL EXPERIENCE
Intralot, atlanta, Georgia Jan 2020 – Till Date
SQL Server Developer
Responsibilities:
•Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle DB, and SQL).
•Worked on VB.Net (Windows App) and C#.Net (Web Application) for developing the utilities such as Server Manager, Patient Merger, Visit Re open, Open Door and Hide Visit.
•Extracted and Transformed data into Staging Servers named as P Staging Server for historical data and T Staging Server for load increment.
•Responsible for creating SSIS packages for data migration from Project Server (SQL Server 2005) to Plan View application (Oracle).
•Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
•Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.
•Responsible for SSAS Tabular model cube development as well.
•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.
•Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
•Developed the classes using C#, which incorporate N-tier architecture and database connectivity.
•Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
•Knowledge in performance troubleshooting and tuning Hadoop clusters.
•Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
•Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
•Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization
•Design and develop dynamic advanced T-SQL, PL/SQL, MDX query, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints, SSIS packages, SSAS Cubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications.
•Created and modified various Stored Procedures used in the application using T-SQL.
•Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
•Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
•Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
•Designed and built OLAP cubes to meet reporting needs.
•Created Project Expense Statements in all Data Marts and other Financial Reports using SSRS.
Environment: MS SQL Server 2012/2014, Visual Studio 2012/2013, SSIS, SSAS, SSRS, Agile Scrum, Web Services, T-SQL, SQL Analyzer and Enterprise Manager and SQL Agent, XML, VMware, MS Excel, Team Foundation Server (TFS) 2013.
Matrix Medical Network, Scottsdale, AZ Feb 2017 – Dec 2019
SQL Server Developer
Responsibilities:
•Developed PL/SQL triggers and procedures, functions, packages to provide backend security and data consistency.
•Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube
•Designed SQL Server Integration Services (SSIS) packages to post CMH pool data in XML file format for evaluation to TAC URL, then TAC system validates the request and sends the response back to CMH synchronously.
•Involved in documenting user requirements, technical specifications and Reporting manuals.
•Developing functional, technical documents advanced coding and bug fixation.
•Developed back-end PL/SQL packages, UNIX shell scripts for data migration and batch processing.
•Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.
•Created indexes on the tables for faster retrieval of the data to enhance database performance.
•Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
•Extensively worked on SSAS Tabular model and multi-dimensional cube development and SSIS packages designing.
•Partitioned the fact tables and materialized views to enhance the performance.
•Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
•Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
•Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
•Database design/de-normalization (Tables/Schema, Views, Stored Procedures, Views)
•Providing data reports from various required applications.
•Developed classes in Business Layer and in Data Access Layer in C#.
•Used .NET provider Data Reader Source Task to Read from RDBMS sources.
•Wrote custom tasks using C# within SSIS to enhance processing of both Excel and flat-files into SQL Server.
•Performance tuning/optimization with SCOM, Idera, SQL Profiler traces, Perform monitor, SQL DB Tuning Wizard, Execution Plans, VmWare and Windows server tools.
•Provides R&D for new SQL Technology and tools ( SQL 2014, Solarwinds, Veeam Backup, SSIS, SSRS, SAN storage for SQL VmWare & Physical Servers, Writing T- SQL queries
•Recommending SQL Operations and Development best practices implementing both
•Installing/configuring, implementing and supporting SSIS, SSRS
•Writing SSIS packages, jobs & supporting them where requested
•SharePoint DBA support, migration and support for servers (Operations, Design and Performance and generating reports. Recommending best practices and assisting in the implementation.
•SQL Documentation (Operational, DBA Guide, Performance SSIS best practices, SharePoint best practices
Environment: Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports, TOAD.
Thinklabs Technology – Hyderabad Dec 2015 – Dec 2016
SQL Server Developer
Responsibilities:
•Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
•Designed and implemented SSIS packages to migrate data from heterogeneous data sources to staging database and load the data to data warehouse or data marts.
•Excellent report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder
•Created T-SQL queries, complex Stored Procedures, User-defined Functions, designing and implementing of Database Triggers (DDL, DML), Views and designing and implementing Indexes.
•Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.
•Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
•Worked with subject matter experts (SME's) and project team to identify, define, collate, document and communicate the data migration requirements
•Strong Experience in Azure based Power BI to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and share dashboards based on reports in power BI desktop
•Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
•Designed User Interface using ASP.NET, C #. Written Business Layer in C and wrote web service Interfaces using C#. NET, ADO.NET.
•Development of Survey based platform using ASP.Net, C#.
•Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
•Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
•Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
•Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.
•Provisioned VMs with SQL Server on cloud utilizing Microsoft Azure and setting up communication with the help of endpoints.
•Migrated enterprise database to Microsoft Azure with Redgate and azure data factory.
•Helped to develop backup and recovery strategy for databases on virtualization platform utilizing Microsoft Azure.
Environments: Windows server 2003, IIS 6.0, MS SQL Server-2014/2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel.
Posidex Technologies Pvt Ltd - Hyderabad, Jan 2013 – Nov 2015
SQL Developer
Responsibilities:
•Participated in the walk through the existing application code to understand the business process flow.
•Created stored procedures to extract the data from source table, transformed as per the business logic and loaded into the target table.
•Created stored functions to perform calculations on the raw data and accessed through procedures while processing the data as per the business logic.
•Used bulk collects and FORALL programming feature to process the data with effective performance.
•Created complex views and performance tuned them which were the sources to the downstream applications.
•Extensively used sequences, indexes in the procedures according to the requirement
•Created different types of table partitions for better performance
•Created and used explicit cursor in the function and procedure
•Worked with Development team to create necessary and update company's software
•Developed, Analyzing, and writing PL/SQL scripts
•Used advanced features in the function and procedure such as ref cursors and built-in package
•Wrote complex SQL statements using multi-table joins
•Involved in fine-tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.
•Created different types of constraints on different tables
•Involved basic administrative activities such as monitoring OEM, granting/revoke privileges to user & role
•Handle PL/SQL Exception in the function and procedure
•Extensive used different types of Loop, CASE and IF statements in the PL/SQL block
Environment: Oracle 10g, Oracle SQL Developer, SQL and PL/SQL, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports, TOAD.
Contact this candidate