SUMMARY:

• Around 9+ years of experience in SQL Server database development and administration, extensively worked in OLTP, OLAP, Client - Server & Enterprise Data warehouse Environments.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Constraints, CTE, Temp Tables and User defined data types and functions using Confidential -SQL.
• Extensive experience in Requirement Analysis, Work flow analysis, Design, Development & Implementation, Testing & Deployment of complete software development life cycle in field of Desktop Applications, Microsoft web and client/server technologies.
• Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Experience in SQL Server Self Service BI tools like Power view, Power Pivot, Power BI, BISM Tabular models and SQL Server Data tools and provided users with, mentoring and documentation.
• In-depth knowledge on Tableau Desktop, Tableau Online, Tableau Reader and Tableau Server.
• Strong experience in creating dashboards, KPI’s and scorecards using gauges and charts for analysis using SSRS R2 and SharePoint 2010.
• Involved in developing reports from SSAS cubes using client tools like SSRS, Excel and Report Builder.
• Experience in installing, configuring, upgrade/migration and monitoring MS SQL Server installations.
• Strong experience in performance tuning and query optimization using tools like SQL Server Profiler and Database Tuning Advisor.
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, Backup & Restore Procedures, Disaster Recovery and Performance Tuning.
• Experience in dimensional modeling using Star schemaand Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.
• Experience in cloud computing platform like SQL Azure, involved in data migration from SQL on premise environment to cloud computing platform.

TECHNICAL SKILLS:

RDBMS: SQLSERVER 2016/2014/2012/2008 R2/2005/2000, Oracle, MySQL

Database Tools: BIDS, SS Management Studio, Query Analyzer, System Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan Wizard, Data Transformation Services (DTS), MSCS, Database Engine Tuning Advisor, Bulk Insert and BCP, Business Intelligence Development Studio, SQL CMD, SQL Server DBA Dashboard, Data Quality Services(DQS), Master Data Services(MDS).

ETL & Reporting Tools: SSIS, SSRS, SSAS, Excel, Power View, Tableau Desktop, Tableau Online

SQL, Confidential: SQL,ANSI SQL, PL/SQL,C,C++,C#,VB

Operating System: Windows 95/98,NT,Windows XP/2003/2000,Unix,MS-DOS

Web technologies: HTML, XML, VBScript, SharePoint 2010,C#,ASP.NET,VB.NET

Tools: Erwin, Visual Studio 2013/2008/2005 , Visio,Visual Source Safe, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. SQL Developer

Responsibilities:

• Managed existing applications and worked on fixing issues/errors users experience while using applications/ interfaces.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Monitoring, Optimizing and Tuning of queries and other SQL Server database objects.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Updated data in tables based on the user requirement using temp tables and joins.
• Design, develop and test scripts to import data from source systems and test dashboards to meet customer requirements.
• Worked on Customizing ETL logic, designing, Execution plan, SSIS package development, Unit testing, and deployment.
• Responsible for data management and conversion activities such as Data Assessment, Cleansing, Extracting, Migrating and Reconciliation of data using SSIS.
• Created the advanced SSRS Dashboard Reports, tabular, Matrix, Chart reports with advance features using SSRS.
• Involved in production deployment and configuring data sources and scheduling reports using SSRS subscriptions.
• Scheduled, maintained, and supported the distribution and access to reports through SSRS.
• Involved in developing reports from SSAS cubes using client tools like SSRS, Excel and Report Builder.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Handled Tableau admin activities granting access, managing extracts and Installations.

Confidential, Phoenix, AZ

SQL/MSBI Developer

Responsibilities:

• Worked on Cloud migration of Care Radius 3.2, a care management application maintained by EXL.
• Implemented complex business logic with Store Procedures, User Defined Functions, Views and developed Confidential -SQL batches with CTE for recursive operations.
• Modified existing processes developed using Oracle into MS SQL.
• Monitoring, Optimizing and Tuning of queries and other SQL Server database objects.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Updated data in tables based on the user requirement using temp tables and joins.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Created extracts and for third party vendors in the form of CSV, dat, excel and tab delimited files.
• Designed the data mart defining entities, attributes and relationships between them.
• Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS. Involved in error handling, creating package configuration and log details using SSIS logging.
• Used C# and VB.Net scripting when developing SSIS packages.
• Development of reports and tables with sound understanding and familiarity of HIPAA and PHI Federal regulations.
• Created the advanced SSRS Dashboard Reports, tabular, Matrix, Chart reports with advance features using SSRS.
• Involved in production deployment and configuring data sources and scheduling reports using SSRS subscriptions.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.
• Automated SSIS packages using JAMS third party tool.

Confidential, Austin, TX

SQL / MSBI Developer

Responsibilities:

• Worked with HIPAA compliant files for medical, pharmacy, dental and vision enrollment and claims data.
• Created and maintained the data mapping documents.
• Supported and maintained the backend databases supporting the Web application Health Rules Payor.
• Created artifacts including design documents, architecture documents, test plans and test cases.
• Mentoring team members and coordinating with offshore team.
• Design, develop and test scripts to import data from source systems and test dashboards to meet customer requirements.
• Reduced the redundancy of data in the tables by applying the normalization rules and built referential integrity between the tables to reduce the risk of losing the data.
• Worked on Customizing ETL logic, designing, Execution plan, SSIS package development, Unit testing, and deployment.
• Developed simple and complex reports supporting multiple, multi-select and cascading parameters, sub reports and were all linked to other stage reports using hyperlinks for ease of navigation and to give the drill-through feature using SSRS.
• Scheduled, maintained, and supported the distribution and access to reports through SSRS.
• Involved in posting reports to SharePoint and prepared technical documentation & knowledge transfer supporting development activities.
• Created SSAS Cubes with multiple dimensions, measures and hierarchies based on OLAP reporting needs, created hierarchies, named calculations, relationships and designed KPI by using SSAS.
• Involved in creating complex measures including ranking, KPIs, aggregation by DAX in SSAS cubes according to business requirements.
• Involved in building dynamic partitions by using complex DAX function. Optimize the processing of the cube inside the Tabular Model. Write complex process scripts for the cube and use SQL Server Job Agent to automatically refresh data.
• Designed dynamic row level security for entire global procurement team with different level of users utilizing complex DAX functions within SSAS tabular model.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Connected Tableau server to publish dashboard to a central location for portal integration.

Confidential, Long Beach, CA

SSIS ETL Developer/Architect

Responsibilities:

• Participated in customer team meetings and conversations with client personnel to understand business and technical requirements.
• Converted business requirements into technical requirements,Created high level design documents and related artifacts.
• Created Source to Target Mapping Specifications and created data transformation and cleansing rules.
• Involved in the Data modeling, Physical and Logical Design of Database.
• Developed ETL packages using SSIS, provided support for testing, deployment and post deployment.
• Created SSIS ETL Scripts to conduct unit testing and created unit testing results documents
• Participated in all aspects of the Data Migration/ETL development lifecycle using Microsoft BI technology
• Worked with the DBAs and was responsible for the overall ETL design and SSIS programming.
• Established standards and defined processes for Error handling and audit/balance/control process.
• Provided support for QA/UAT and assisted in resolving production issues and Scheduled SSIS packages in QA and Production.

Confidential, Long Beach, CA

Sr. SQL/SSIS/SSRS Developer

Responsibilities:

• Created authorizations based on member enrollment if the member is eligible by analyzing member details with the help of SSIS package.
• Participated in source to target mapping design document, prepared system requirement documents based on data model and source target mapping documents.
• Designed and created SSIS packages to extract, transform and load data from Excel and Text files to SQL Server destination using various complex transformations like conditional split, derived column, and data conversion from the existing QNXTdatabase.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Experience with processing HIPAA compliant EDI files, FTP transactions.
• Understanding of health care terminology Diagnosis,Procedure, CPT& Rev codes.
• Hands-on experience with SQL and Relational DB and SQL Query performance tuning, Autosys job scheduling.
• Upgraded SSIS packages and SSRS reports from 20 .
• Lead the offshore resources by interacting with business and providing requirements to offshore team.
• Developed simple and complex reports supporting multiple, multi-select and cascading parameters, sub reports and were all linked to other stage reports using hyperlinks for ease of navigation and to give the drill-through feature using SSRS.
• Involved in production deployment and configuring data sources and scheduling reports using SSRS subscriptions.
• Development of reports and tables with sound understanding and familiarity of HIPAA and PHI Federal regulations.
• Lead the team in QNXT upgrade activities identified the impacted applications list and communicating with PMO's, supporting QA team and planning for Production deployment.

Confidential, Richardson, TX

Sr. Business Intelligence Analyst(SSIS, SSRS,SSAS)

Responsibilities:

• Responsible for implementing and maintaining ETL using SSIS 2008 & 2012 and integrating them into the data warehouse environment.
• Designed data model and implemented database for large custom MDM solution
• Designed number of SSIS packages for data transfer between flat files, XML, Oracle, MYSQL and SQL Server using different transformations like Lookup, Derived Column, Merge Join, Fuzzy Lookup, Script Component
• Created VB.Net Script for Data Flow and Error Handling using Script component in MS SQL Integration Services.
• Involved in implementation of Master Data Services (MDS) through Data Quality Services (DQS), designed the SSIS packages move the data between MDS and EDW.
• Creating physical data model for MDM, staging, and ETL scenarios for MDM and DW.
• Designed SSIS Packages to cleanse, remove duplicates and matching data through Data Quality Services (DQS).
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Design, Implement and maintain database schema, tables, stored procedures, UDFs, triggers, constraints, Indexes, schemas, functions, views, rules and other database objects.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Handled Tableau admin activities granting access, managing extracts and Installations.

Confidential

SQL Server Developer(SSIS, SSRS, SSAS)

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and designed diagrams logical modeling and converted logical design to physical design.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS. Used SSIS/ETL transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.
• Experienced Confidential data discovery and analysis to model and bring in new data sources into the Data Warehouse and into SSAS/MDX Cubes. Deployed, integrated the reports to SharePoint portal.
• Involved in cube partitioning, refresh strategy and planning and dimensional data modeling in SSAS.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculated the metrics that were revealed in the functional analysis.

Confidential

SQL Server/MSBI Developer

Responsibilities:

• Involved in requirements gathering and design documents for developing the project.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Used SSIS and Confidential -SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Created several data validation and data cleansing packages during extraction and load.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Applied XML configurations, logging and error handling for SSIS packages.
• Developed SQL queries for generating drill down reports in SSRS and Ad hoc reports through report builder.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.

Confidential

SQL Developer

Responsibilities:

• Created enterprise logical and physical data model using ERWIN with a full data dictionary, covering both present and anticipated data utilization.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• The project mainly involved creating new databases, Performance tuning, creating, deploying and scheduling reports.
• Created backups for databases and involved in Performance tuning.
• Responsible for performing complete back-up and restoration, database maintenance Service pack updates on server and client.