Over 8 years of experience as MS-SQL Server Developer, involved in Design, Development and Support of 2005/2008/2012 for both OLTP and OLAP Systems.
*Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS in different fields like Banking, Sales, Insurance and Health.
*Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
Databases Tools SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Integration Services, SQL Server Analysis Service (SSAS) SQL Server Integration Service (SSIS)
Reporting Tools SQL Server Reporting Services (2012/2008/2005), Microsoft Access 2013 , MS Excel, Microsoft-Access, Excel.
Database MS SQL Server 2014/2012/2008/2005/2000, MS Access,Oracle 11g/10g/9i/8iProgramming T-SQL, PL-SQL, C
ETL Tools Data Transformation Services (DTS) - Export/Import
Other Tools MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.
Web Technologies HTML, DHTML, XML, XSLOperating Systems Windows 2008, 2003R2, 2003, 2000 Advanced Server, Windows XP, Windows Vista, Windows 7.
Sr. SQL Developer June 2014 to CurrentKewill Inc － Inwood, NY
Experience in integration of data sources like SQL Server, Oracle, DB2 and Flat Files.
Extensive experience in creating SSIS Packages for integrating data using OLE DB connection from different sources like Excel, CSV, Oracle, flat file, and Text Format Data by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation Services (DTS) and SSIS with MS SQL 2008/2012.w Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
Building and writing MDX Queries, Calculated Members, and KPI's using Microsoft SQL Server 2008/2012 Analysis Services Business Intelligence (SSAS, SSRS).
Involved in migration of DTS Packages (2008) to SSIS (2012) and troubleshoot migration issues.
Expert in generating drill down Reports in SSRS 2008/2012.
Experience in providing Logging, Error handling using Event Handlers, Pre, and post for SSIS Packages.
Deployed reports across Test, Development and production environments.
Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
Experiences in SQL Server Analysis Services OLAP Cubes, and Data Mining.
Performed Data Mining activities on central repository for various application and dashboard functionalities.
Actively involved in the analysis of Cubes and added the Key Performance Indicators (KPI) to the created cubes.
Experience with Implementation and maintenance of Business Intelligence tools for analysts and executive dashboards.
Created Scorecards/Dashboard Pages in Performance Point Server (PPS).
Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
Data Analyst April 2013 to May 2014Medco/Express Scripts － San Francisco, CA
Express Scripts helps in making the use of prescription drugs safer and more affordable.
Providing best in class pharmacy benefit management services and industry leading home delivery and specialty pharmacy services for our diverse client base.
Responsibilities Performed GAP analysis for new functionality requirements as well as prioritized them based on actual business needs.
Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
Used SSIS tasks such as Conditional Split, Derived Column, lookup which were used for data validation during Staging, before loading the data into the Data warehouse.
Developed and deployed data transfer packages to the various destinations using SSIS.
Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
Responsible for creating reports based on the requirements using SSRS 2008.
Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
Defined the report layout and identified Datasets for the report generation.
Using SSRS generated Cross-tab, Conditional, Drill-down and Sub reports.
Designed report templates, bar graphs and pie charts based on the patient data.
Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
Used TFS to store/revert back to different versions of design in case of a system crash.
Environment: Visual Studio 2005, SQL Server 2005/2008, SQL Server Business Intelligence Development Studio (BIDS), SSIS, SSRS, SSMS, TSQL, EXCEL, Enterprise Manager, Advanced Query Tool, Windows server 2008, MS Project, MS Visio.
SQL BI Developer July 2012 to March 2013Castlight Health － San Francisco, CA
Castlight Health Group is one of the nation's leading managed health care companies offers a spectrum of products and services.
CastLight Health was founded in 2008, this company had a simple but long-time reaching dream: to transform healthcare in the United States.
Castlight Healthcare enables employers to deliver first class benefits to people for better taking healthcare decisions.
Through its family of subsidiaries and divisions, it serves approximately 30 million individuals nationwide.
The project was about to design and develop the data model and to increase performance by writing different kinds of queries.
Responsibilities: T - SQL Developer skills including stored procedures, Indexes, views, User Defined Functions, Triggers and Distributed Transactions.
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 audit information of the packages and their execution results are loaded in to the audit table.
Implemented slowly changing dimensions in SSIS packages.
Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform.
Automated execution process of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and SMTP.
Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
Created data sources, connection strings and defined the datasets for report generation.
Designed and written the queries in the query builder for retrieving the data.
Used report items like tables, sub report and charts to develop reports in SSRS.
Worked with various delivery mechanisms of reports including Email /PDF/Schedules Managed and troubleshoot report server related issues.
Created dimensions with the cube wizard and generated named calculations /queries.
Involved in defining referenced relationships with measure group and fact tables.
Defined Granularity with in a measure group and drill through actions.
Implemented the calculations to aggregate physical measures.
Environment: SQL Server 2012, SQL Server 2008R2, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Business Intelligence Development Studio, T-SQL, DTS, SQL Profiler, OLAP, OLTP, MS-Excel.
MSBI Developer September 2011 to June 2012Active Cubes Inc － Rochester, NY
Involved in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
Worked with SSIS for transferring and reviewing data from heterogeneous sources like (Oracle, Excel, CSV, flat file, XML, Text Format Data).
Prepared technical design/specifications for data Extraction, Transformation and Loading.
Used SSIS and T-SQL, PL/SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
Prepared the complete data mapping for all the migrated jobs using SSIS Involved in building and maintaining SSIS Packages to import and export the data from various data sources (Oracle, Excel etc.) using BIDS based on the design data models.
Used ETL (SSIS) to develop jobs for extracting, transforming and loading data into data warehouse.
Created and Managed OLAP Cubes using SSAS.
Worked closely with reporting team for deploying Tableau reports and publishing them on the Tableau and Share point server.
Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes Participated actively in client meetings daily and produced detailed level design document for the customer portals.
Created parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Adhoc reports using SSRS2008 R2.
Created SSIS packages for File Transfer from one location to the other using FTP task.
Generated SSRS Reports using Global Variables, Expressions and Functions for the reports.
Extensively used joins and sub-queries for complex queries involving multiple tables from different databases.
Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
Performance tuning and optimization of stored procedures.
Environment: MS SQL Server 2008R2/2012, SSIS, SSRS, SSAS, PL/SQL, Oracle 11g, VSS, Microsoft Visual Studio 2010, SQL Server Management Studio, T-SQL, TFS, Toad, Unix, HTML, XML.
SQL Developer/ DBA March 2007 to August 2011American Law Institute － Philadelphia, PA
Administration, Maintenance of multiple SQL Server instances into Prod-Stage-DEV environment.
Design, Setup, Implementation, upgrade and migration of SQL Server 2005 /2008 to SQL Server 2012 databases.
Setup of jobs and alerts for Backup Restore (VLDB), integrity checks, database shrinking, transaction log growth monitoring and routine database maintenance processes Performance and Tuning of SQL Server using Index tuning, profiler, PerfMon, DTA, DMVs and DMFs Query optimization using Show Execution Plan, SQL profiler and Query analyzer.
Development of Indexes, stored procedures, views, functions and triggers using T-SQL.
Setup, monitoring and maintenance of SQL Server data Replication Design/Development and Maintenance of multi-dimensional cube using SSAS.
Installation, configuration and maintenance of security of SSRS 2005.
Documentation of coding standards, Technical specifications, policies and procedures Provide troubleshooting, Training and support to users Environment: SQL Server 2005 (32-64 bit), SQL Server 2008, Windows Server 2008, VMWARE, .NET, SharePoint, BizTalk, Quest Diagnostic tools, Red-gate, SSIS, SSRS, ER/Studio.
Bachelor of Engineering : Computer Science, 2009JNTU － Hyderbad, A.P, INDIA
.NET, Adobe Photoshop, ad, Backup, benefits, billing, BizTalk, BI, Business Intelligence, C, charts, client, clients, Data Conversion, data transfer, Data Mining, DTS, data validation, data warehouse, Data Warehouses, Databases, Database, delivery, dimensions, Documentation, DHTML, Email, ERWIN, ETL, XML, features, Flash, FTP, functional, graphs, HTML, DB2, layout, Logging, Logistics, meetings, Microsoft Access, MS Access, Microsoft-Access, MS Excel, MS-Excel, EXCEL, Mail, Microsoft Office Suite, MS Office Suite, Power Point, MS Project, SharePoint, Share point, Windows 7, Windows, 2000, Windows XP, Microsoft Word, migration, Enterprise, OLAP, OLE, Operating Systems, optimization, Oracle, DB, Developer, PL-SQL, PL/SQL, PDF, policies, processes, coding, Programming, Express, Quest, reporting, servers, Scripts, Shell scripting, SMTP, Software Developers, MS SQL Server, MS SQL, Microsoft SQL Server, SQL, SQL Server, supply chain, Tableau, Tables, Toad, T - SQL, T-SQL, TSQL, transportation, troubleshoot, troubleshooting, Unix, upgrade, Visio, Vista, Microsoft Visual Studio, Visual Studio, Windows Server, written, XSL