SUMMARY

• Over 7+ years of strong experience in the IT industry as a MS SQL Server Developer include experience in design, development, implementation and administration of database systems using MS - SQL Server 2014/2012/2008 R2/2008 for both OLTP & Data Warehousing Systems applications with various business domains like Financial, pharmaceutical and manufacturing.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance
• Experience in Performance Tuning and Query Optimization.
• Expert in maintaining Error logging using Exceptional Handling in T-SQL and SSIS.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installation.
• Expertise in creating visualizations and reports using Power BI.
• Expertise on creating multiple kinds of Power BI Reports and Dashboards
• Good knowledge of System Development Life Cycle (SDLC).
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Worked Extensively on ETL process using SSIS package.
• Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Expert in using tools like Data Transformation Services (DTS) and SSIS.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools MS access and Microsoft Visio.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Developing reports on SSAS & SSRS on SQL Server 2014/2012/2008 R2/2008 Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2014/2012/2008 R2/2008
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.

TECHNICAL SKILLS

Databases: SQL Server 2014/2 R2/2005, Oracle 8i/9i/10g/11g, MYSQL

Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Power BI, Data Transformation Services (DTS), Power View, ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio(BIDS), SQL CMD.

Languages: T-SQL, C, C++, PL/SQL, C# 4.0, Shell Scripting, UML, XML, XMLA

OLAP: SQL Server Reporting Services (SSRS), SSAS, SSIS, OLAP, Power BI

Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems: Windows Server 2000/2003/2008/2012 , MS DOS, Unix, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Houston, Texas

SQL BI Developer

Responsibilities:

• Identify, analyze, and interpret trends or patterns in complex data sets
• Filter and clean data, and review computer reports, printouts, and performance indicators to locate and correct code problems.
• Hands on experience in creating dimensional modeling with facts and dimensions.
• Hands on experience working in agile environment.
• Hands on experience working in Team Foundation Server.
• Created (SQL) stored procedures to transform xml data sent from the client and store parsed in permanent tables for easy reporting.
• Created an interactive dashboard using Power BI to analyze the patient’s financial, operational and clinical information.
• Created many ad-hoc reports using Power BI and SSRS to cater the client’s requirement.
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Hands on experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Used ETL SSIS to develop packages for extracting, cleaning, transforming and loading data into data warehouse.
• Transformed data from one server to other servers using tools SQL Server Integration Services(SSIS)
• Involved in the Migration of Databases from SQL Server 2012 databases to Amazon Redshift.
• Created triggers to validate business rules for data validation.
• Used bulk Insert to load flat files for faster data loads and improve performance.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Created and tuned clustered and non-clustered indexes that were used for faster reporting.
• Created multiple parameterized stored procedures which were used by the reports to get the data.

Environment: SQL Server 2012/2014, SSIS, Report Builder 2014, SSAS, SQL Server Development Tool, Microsoft Management Studio, Visual Studio 2012, DTS, TSQL, Power BI, Tableau

Confidential, Fort Worth, TX

BI Developer

Responsibilities:

• Created Functions, Triggers, Stored Procedures, Databases, and views
• Written new stored procedures and modified the existing ones and tuned them to increase the performance
• Extensive use of T-SQL queries throughout the project
• UsedJoins,correlated and non-correlated sub-queriesfor complex business queries involving multiple tables from different databases.
• Participate in the database design and normalizationprocess and system development life cycle (SDLC)
• Created Reports (SSRS) and Report Models (.SMDL)usingReport Builder 3.0 and BusinessIntelligence Development Studio based on the Business requirements.
• Created parameterized,drill down, sub reports, embedded reportswith images using stored procedures and using Business Intelligence Studio.
• CreateCharts and Matrix and KPI Indicatorsfor various Business Units.
• CreatedTrend Reportsfor Sales Department with Bar and Line Graph Charts.
• Responsible for Reporting ServicesSecurity and Administration.
• Created Reports for Production Event Logs and Data Import Utility for monitoring the errors and Warnings in the application.
• Configured Email delivery for Subscriptions Reports
• CreatedStandard and Data Driven Subscriptionsfor different reports for different departments.
• Published Reports and Report Modelson remote server using Report manager and Business Intelligence Studio
• Extracted the data from Flat Files, Excel Files Transformed (Implemented required Business Logic) and loaded into the target Data warehouse using SSIS.
• UsingSSIS built high performance data integration solutions, including extraction, transformation and loading (ETL) packages for data warehousing.
• Extracted the data from Flat Files, Excel Files Transformed (Implemented required Business Logic) and loaded into the target Data warehouse using SSIS.
• Designed and developed Packages using Lookup, Merge, Merge Join, Conditional Split,Script Component,Aggregate and Export Column.
• Involved in implementingSSIS package security, Package Configurations, protecting packages, executing, monitoring and managing them.
• Enhanced and deployed theSSISPackages from development server to production server.
• Scheduled SSIS Packagesfor generating reports dynamically.
• Use SSIS Packages for Data Extractions from Third Party Vendors.
• Installed and Configured Reporting Services2012 for local and for Remote Reports Servers Administration.
• Managed and administered report using Report Managerby creating Caching and Snapshots
• Troubleshoot and monitoring reporting services by using Profiler and other tools.
• Monitored and maintained the Report Server Database.
• Creating atechnical documentationfor the installation and configuration of Report Server and all the reports.
• Generated and maintained test data and databases for the testing environment.
• Writing migration scripts and taking care of efficiency

Environment: Windows 2000/2003 Server, SQL Server 2000/2005/2008/2008 R2, SSIS, Report Builder 3.0, SSAS, Business Intelligence Tool, Microsoft Management Studio, Visual Studio, DTS, TSQL

Confidential

Project Engineer

Responsibilities:

• Was part of the triage team who managed all production incidents and involved necessary resources required to handle the triage to fix the issue.
• Organized weekly technical meeting with all stakeholders.
• Successfully managed multiple projects simultaneously and context switched based on priorities.
• Created PL SQL stored procedures to backup database(s) in production.
• Automated production to development refreshes, for development team to access production data.
• Worked with development team and restored production database in development for dev team to access production database.
• Created and reviewed DDL, user accounts, stored procedures, triggers etc. in production.
• Integrated various web services using Rest from Best Buy Dotcom applications to other third party integration teams like LDAP, Layer 7 systems, MQ, banking systems, Inventory, OMS etc.
• Worked on complex UNIX bash shell scripts used for deploying it in the database servers.
• Executing and managing weekly database deployments in production servers.
• Worked closely with other DBAs, Data architects and other developers to troubleshoot and fix complex production problems.
• Was recognized by clients and end users for building a positive team environment that increased productivity.
• Worked as a DBA for a critical application that used Liquibase tool for Database Deployment.
• Managed production deployments of main applications that face customer directly.
• Created several queues and channels in Production environment, which helps to get the pricing feed, inventory feed and order details from other applications. The tool being used WebSphere MQ.
• Wrote complex UNIX shell scripts used for building the code and deploying it in the application servers.

Confidential

Jr. SQL BI Developer

Responsibilities:

• Gathering required data, data analysis and documentation of the plan.
• Prepared high-level design specification documents for all the Transformations used in the project.
• Created database objects like tables, synonyms, sequences, views.
• Developed various data exception reports and submitted to the client for data clean up
• Created materialized views, partitions, tables, views and indexes.
• Created Entity relationship diagrams, Functional relationship diagrams, and data flow diagrams and enforced all referential integrity constraints.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Applied Normalization rules in designing the database.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Involved in Performance tuning and optimization of SQL statements.
• Rebuilding the indexes at regular intervals for better performance.
• Created and modified the procedures, functions and packages to support data Transformation.
• Developed DTS packages to migrate data from flat-files, spreadsheets to databases.
• Used SSIS 2005 to copy data from text file to SQL Server.
• Migrated DTS Packages to SSIS 2005.

Environment: MS SQL Server 2005/2000, Visual Studio 2005 and DTS, Windows 2003/XP, T-SQL.

Confidential

Web Developer

Responsibilities:

• Involved in the Analysis, System study and designing of the project.
• Developed front-end screens with HTML, CSS and JavaScript, JQuery.
• Extensively did client side validations using JavaScript and developed the required Servlets.
• Coordinated with onsite team and client in understanding the business process and requirement understanding.
• Provide support to develop Web based application including online customer service for company.
• Developed User Interface in time with high quality manner ensuring a consistent look and feel.
• Understand the client requirement and communicate with back end developers.
• Participated in daily meeting for enhancing the features for the portal.

Environment: Photoshop, HTML, CSS, JavaScript, Jquery, Ajax