SUMMARY

• Over 8+ years of in - depth experience in database design, development, administration and maintenance of SQL Server 2016/2014/2012/2008/2008 R2 large scale databases.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Extensive experience in Microsoft stack of BI solutions - SSRS, SSAS, and SSIS with MS SQL 2016/2014/2012/2008/2005.
• Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
• Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
• Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL & MS SQL Server.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Data conversion, Lookup, Merge Join, Sort, Derived Column, and script task for cleaning bad data, validating data.
• Used change data capture (CDC) control task that makes efficient data loading (incremental load after initial loading of data).
• Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Designed and Build the Dimensions and cubes with starihl schema using SQL Server Analysis Services (SSAS).
• Knowledge in migrating DTS packages, reporgmts and analysis services projects from SQL Server 2000/2008/2012 to SQL Server 2005/2008/2012/2014/2016.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Launching the report builder for adhoc reports.
• Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Analyzing and validating Source Data vs Target data using PL/SQL, SQL, and Excel
• Performed DBA tasks using Enterprise Manager and Query Analyzer.
• Accomplished in creating packages, scheduling Jobs and sending Alerts using SQL Mail.
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.
• Good operating knowledge in third party tools such as NetBackup, Lite Speed Pervasive ETL, SQL Assistant ERWIN, Red-Gate and Spotlight
• Worked closely with development and Technical Support team to resolve quality issues.
• An excellent team player& technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project
• 24x7 Production Database on Call Support.

TECHNICAL SKILLS

RDMS: SQL Server 2005/ 2008/2008 R 2/ 2012/2014/2016 , DB2, Oracle 9i/8i, Oracle 11g

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS),Visula Studio, Informatics cloud, Informatica Power Center 9.6, Workato, Mulesoft Any Point Platform

Reporting Tools: SQL Server Reporting Services, MS Excel, Crystal Reports, Tableau Desktop10.0, Tableau Server

Programming Languages: T-SQL, PL-SQL, C#,VB.Net

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS

Operating Systems: Windows Server 2012/2008, Windows XP, Windows Vista

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash, Microsoft .NET, Team Foundation Server, Visual Studio 2008,Salesforce

Methodologies: AGILE, SCRUM, Waterfall, Extreme Programming, LEAN Manufacturing, Software Development Life-Cycle

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Senior SQL Server BI/ETL Developer

Responsibilities:

• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.
• Performed .Net solutions using C# to intergrate flat and excel files to OLTP databases and provide regular debugging support
• Suport the backend SQL datatbases for different third party applications and resolve the issues in timely manner in collaboration with vendors
• Developed SSIS Packages using Scritpt Task, SFTP task, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to OLTP and OLAP databases .
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.
• Made use of SQL joins, sub queries, tracing and performance tuning for better running of DTS packages.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Made Master Child package using variables and Execute package task in SSIS.
• Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements
• Wrote C# and VB.NET code for Script task to perform functions that are not available in the built-in tasks and transformations that SSIS provides.
• Deployed, Tested and Scheduled SSIS packages.
• Extracted data from heterogeneous sources and transferred to OLAP using SSIS 2012.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task and various transformations
• Integrated SSIS packages with the windows batch to trigger the package.
• Migrated projects from CVS to TFS (Team Foundation Server)
• Technical competency and hands-on experience in most of the following domains: FEA (Cosmos, Abaqus) and C/C++ (Visual Studio, CVI)
• Developed rich data analytics pipeline in Cosmos, that correlated multiple data points from devices and provided a collective aggregated view of device information.
• Expertise with varied technologies like Insights reporting framework, JavaScript, Webservices, Cosmos/Scope etc. to work in Data Quality Framework effort
• Designed and deployed Azure cloud solutions that meet product needs for scalability, reliability, and performance.
• Managed Salesforce to Active Directory integration using Workato and Mulesoft Anypoint Platform
• Expert in Implement deploy and configure Azure websites, configure diagnostics, monitoring and analytics on Azure Platform along with scale and resilience for Azure Web sites.

Environment: SQL Server 2008/ R2/2012/2014, BIDS, Visual Studio 2010/2017,T-SQL,MS Access, MS- Excel, SSIS,SSRS,SSAS, Windows Server 2008R2, Team Foundation Server(TFS), Microsoft Azure,Microsoft Dynamics 365, KingswaySoft

Tools: & Technologies: SQLServer2016, SQL Server BI Development Studio (BIDS) 2012/14, Oracle 9i/10g, Tableau, Clear Case, Clear quest, SQL Lite Speed, Visual SourceSafe, T-SQL, Autosys, MS Access, Windows XP/2007 Server,, Autosys

Confidential, Tampa, FL

Senior SQL Server BI/ETL Developer

Responsibilities:

• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Extensive SQL Programming to analyze and validate Source Data vs Target data.
• Conducted test case peer reviews to ensure test cases accurately capture functionality identified in user acceptance criteria
• Created test data using existing Enrollment and Claims applications
• Generated Excel output of Data Validation results with Expected and Actual results
• Involved in enhancing and deploying the SSIS Packages from development server to production server.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2016.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard
• Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Responsible for creating logical and physical model using ERWIN.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Environment: SQL Server 2005/2008/ R2/2012/2014, BIDS, Visual Studio 2010/2013,T-SQL,Oracle,Autosys, MS Access, MS- Excel, SSIS,SSRS,SSAS, Windows Server 2008R2, TFS, Microsoft Azure, Workato, Mulesoft Anypoint Platform

Tools: & Technologies: SQLServer2016, SQL Server BI Development Studio (BIDS) 2012/14, Oracle 9i/10g, Tableau, Cerner Millennium, Soarian Financial, Salesforce, Clear Case, Clear quest, SQLLite, Speed, Visual SourceSafe, T-SQL, Autosys, MS Access, Windows XP/2007 Server.

Confidential, Atlanta, GA

SQL Server DWH/BI Developer/Data analyst

Responsibilities:

• Involved in Agile methodology by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems, completed work through Sprints.
• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
• Interacted with Business team to collect data for the conceptual design of the system.
• Coordinated with business users to understand business needs and expectations.
• Involved in requirement gathering, feasibility studies and organizing the software requirements.
• Involved in analysis and review of software and business requirement documents.
• Involved in defining the source to target data mappings, business rules and data definitions that are used as source by ETL developers.
• Created data profiling reports with valid values, data quality, Null ratio, Column Value Distribution, Column Statistics etc. and validating them with data present in Source systems.
• Revisiting created Data Mapping documents in case of any Mappings or Transformation logic changes.
• Helped Data Architect by providing the artifacts that are needed to consider while designing the EDW.
• Conducted sessions and worked alongside with the Business analysts to create technical specifications and mappings for Business Data Glossary and reports.
• Involving in analysis of Report design requirements and actively participated and interacted with Business Analyst to understand the Business requirements.
• Generating Corporate Reports for Management Committee using SQL Server Reporting Services (SSRS) and Excel.
• Created tables using T-SQL queries to store the data and also creating database objects like functions, stored procedure, Clustered and Non-clustered Indexes using MS SQL Server.
• Experience in Data Analysis and Data Profiling using SQL and Excel on large volume of data sets like Teradata, Oracle, Flat files, SQL Server.
• Experience in creating data profiling reports with valid values, data quality, Null ratio, Column Value Distribution, Column Statistics etc. and comparing them with source Data Profiling Results.

Environment: SQL Server 2008, T-SQL, SQL Server Management Studio, Visio, Excel Reports, Outlook, Service Center

Confidential, Nashville, TN

SQL Server /BI Developer

Responsibilities:

• Involved in Agile methodology by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems, completed work through Sprints.
• Responsible for creating logical and physical model using ERWIN.
• Built a package to transfer data between OLTP and DW databases.
• Created Views to reduce database complexities for the end users.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.
• Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created a table to save dirty records.
• Performed SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Set up Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Generated Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.

Environment: SQL Server 2008, T-SQL, SQL Server Management Studio,Visual Studio, Visio, Excel Reports, Outlook, Service Center

Tools: & Technologies: SQL Server 2008R2, BIDS 2008R2, Integration Services 2008R2, Oracle 9i, Visual SourceSafe, TSQL, Autosys, Rational Clear Case, Clear quest, MS Access, Windows XP/2003 Server.