PROFESSIONAL SUMMARY:

• Over 8+ years of IT experience in the use and development, design, support and migrate of Microsoft SQL Server 2005/2008r2 database. Development using Microsoft SQL Server MSSQL Server 2000/2005/2008/2012/2014 and SQL server BI suite of products SSIS, SSRS, and SSAS in various domains like Health Care and Insurance as SQL Developer and MSBI Developer.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Expertise in system analysis, design, development, testing and implementation of projects (SDLC).
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2012.
• Experience with SQL Server and T - SQL in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, Relational Database Models and Data Integrity in observing Business Rules.
• Efficient in creating joins and sub-queries for complex queries involving multiple tables.
• Well versed in Normalization/DE Normalization techniques for optimum performance in relational and dimensional database environments.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS,Bulk Insert and BCP.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups,Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
• Extensively used SSIS packages to Import data from sources like Flat Files, Excel, HTML and Raw Files.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Worked with improving the performance on SQL, TSQL and SSRS procedures and provided therecommendation on server related tuning issues.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports usingGlobal variables, Expressions, and Functions, Sorting the data, Defining Data sources andSubtotals for the reports using SSRS 2008 R2.
• Experience in Visual Studio Team Foundation Server, SVN repository, Visio.
• Extensive Knowledge in Creating Relationships, Measures, Partitions, Calculations using DAX and KPIs in SSAS Tabular model.
• Experience in using Power BI tool for developing dashboards, interactive reports, and compelling visualizations
• Good experience in installation and upgrades of/to SQL server 2000/2005 and its service packs, database migrations, backup, recovery and maintenance of SQL Server 2005 databases in Cluster environment.
• Extensive knowledge in SQL Server 2012 Developer Skills including writing user defined functions, views and query writing.
• 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).
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2008/2008 R2/2014/2012 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor
• Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP). Worked with Data mining and slowly changing dimensions.
• Expertise in writing complex Stored Procedures, Indexed Views and Triggers for data Consistency and manipulation.
• Expertise in writing and tuning Transact-SQL (T-SQL) (DDL/DML) Queries.
• Good Knowledge of Normalization/De-Normalization, Normal Form and Data Modeling.
• Proficient in SQL Server technologies such Replication, Index, Functions and Store Procedures.
• Experience in creating Indexes, Views, complex Triggers, effective Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and data consistency.
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Optimization and Performance Tuning.
• Strong experience in using Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS with MS SQL Server 2000/2005.
• Expertise in creating Packages using SSIS for integration services.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Worked with data extraction using SSIS and Data Warehouse staging, and loading.
• Hands on experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experienced in defining Query for generating drill down reports in SSRS 2005.
• Expert in designing report layout.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Expert in Experienced in sorting the data, defining subtotals for the reports.
• Proficient in using global variables, expressions and functions for the reports.
• Experience in Reporting Services (SSRS) 2008/2012.
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc. and created various user roles.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Experience in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio.

Languages: C, C++, T-SQL, Visual Basic, XML

Operating Systems: Windows Server 2003, Windows 2000 advanced Server, Windows NT/95/XP, and UNIX.

Databases: MS SQL Server 2012/2008/2005/2000, MS Access 97/2000

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).

Reporting Tools: SSRS, SSAS, Power BI, Tableau

Data Modeling: Visio 2007

Application Packages: MS Outlook

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

SQL BI Developer

Responsibilities:

• Worked on Full life cycle development (SDLC) of the project involving in all stages of development.
• Worked in Agile Methodology to efficiently deliver the project on time.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for SSRS report.
• Also, worked for the existing Enterprise Data Warehouse facts and created dimensions via SSIS Packages.
• Understand Enrollment processing in the organization, to include Claim processing system and Data warehousing.
• Maintained the Version, Labeled Versions and Backups of the source using Team Foundation server (TFS).
• Developed complex Stored Procedures and views to generate various Drill through reports, parameterized reports and linked reports using SSRS.
• Analyzed and designed business processes as per the business requirements with SSRS reports.
• According to release doc developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created different PowerPivot reports as per the Confidential requirement.
• Using Power BI tool have developed some reports which has great visualization and analyze data with greater speed, efficiency.
• Worked as a part of scrum team, in an agile methodology with sprint cycles, daily stand ups and story implementation. large cross functional project and support teams.
• Serve as a point of contact for the Confidential 's stakeholders and provided customer support in addition to team building with on and off shore agile teams.
• Experience collaborating and working with various IT teams and businesses.
• Create story board of back log items inagileand develop item according to business needs.
• By using Power BI have created some dashboards according to the requirement
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Reviewed Business requirements and prepared the dashboards as per the requirements
• Extracted data from different sources connecting them and used the same to create dashboard.
• Modified the existing dashboard as per the user requirements.
• Used Tableau Desktop for creating different interactive views and dashboards.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Understood complete claims processing cycle from the payer/provider perspective.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIStransformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and DerivedColumn.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data.
• Converted existing DTS packages to SSIS Packages
• Created reports with high complexity reports from the normalized structure
• Gained working knowledge in Data modeling, creating star and snowflake schemas in SSAS.
• Developed complex calculated members, Named Sets using MDX expressions for OLAP reportingrequirements.
• Created KPI Objects in line with Requirement Docs in SSAS.
• Created reports and Data access from MDX, OLAP and cubes.
• Published Power BI Reports from Power BI Desktop to Power BI Service.
• Created multiple kinds of Power BI Reports, Dashboards and Visualizations.
• Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Power BI Service and available in Web clients and Mobile Apps.
• Planned a complete backup on the staging database for back logging purpose and disaster recovery.
• Utilized Power BI for Office 365 to amplify data visualizations with collaboration and data management Power BI Service using star schema.
• Employed bar charts, bubble charts, and Power map to answer business questions with Power BI.
• Mapped millions of records over Bing maps from Excel data model and discovered actionable insights for strategic planning utilizing Power BI (Power Map).

Environment: SQL Server 2010/2012/2014/2016 Developer Edition, SSIS, T-SQL, SSRS, SSAS, TFS,XML, Power Pivot, Power BI, CDC, Pivot Chart, Excel.

Confidential, Troy, MI

SQL BI Developer

Responsibilities:

• Worked on enterprise solutions development with rapid SDLC Agile Methodologies, SCRUM.
• Experience in designing, creating and deploying SSIS packages for transferring data from different source.
• Created several SSIS Packages to pull data from OLTP RAW and create a highly de-normalized data mart out of it.
• Experience in creating Change data capture records insert, update, and delete activity that is applied to a SQL Server table.
• Created several SSRS reports out of the new system.
• Worked in integrating TFS with Visual Studio 2005 & 2008
• Restricted data for users using Row level security and User filters.
• Created reports according to the requirement document provided by the Confidential .
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Triggers, Stored Procedure, Constraints and Roles.
• Used various transformations in SSIS to load data from flat files, Web Service, XML files and DB objects to the SQL databases.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and
• Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Highly responsible for development and management ofSSAS, SSRS and SSIS projects.
• Building KPI reports for the cubes and optimizing the reports.
• Designed, developed and tested various Power BI visualizations for dashboard and ad-hoc reporting solutions by conn Power BI SME responsible for the design, development and production support of interactive data visualizations used across the company.
• Involved in partitioning of cubes to increase the performance of cubes (SSAS).
• Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, etc.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using Power BI
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Rendered the reports to PDF formats as per the requirement and printing all the reports in a batch process for monthly Statements.
• Created incremental refreshes for data sources on Tableau server.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Defined and created procedures to install Tableau desktop in silent mode.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Creating users, groups, projects, Data connections, settings as a Tableau administrator.
• Created parameterized Reports using Charts, Cross-Tab and Sub-report types.
• Worked on SQL *Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and Confidential requirements.

Environment: SQL Server 2010/2012/2014/2016 Developer Edition, SSIS, T-SQL, SSRS, SSAS, TFS, XML, Power Pivot, Tableau, Power BI, CDC, Pivot Chart, Excel.

Confidential, Bentonville, AR

MS SQL BI Developer

Responsibilities:

• Written T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries andStored Procedures.
• Used agile methodology for the development.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables,Views and other T-SQL code and SQL joins for applications.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Serverdatabases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Involved in loading data from various file formats (Flat file, Excel) using Oracle loader and SQL* Loader.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Termextraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generateunderlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Accessand CSV files to data warehouse.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Have created star and snowflake schemas in SSAS
• Developed calculated members and MDX expressions for specific OLAP reporting requirements.
• Optimized and Aggregated cubes with 40% performance for better performance. Processed cube toperform incremental updates.
• Created reports by dragging data from cube and wrote MDX scripts in SSRS.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau
• GeneratedKPI for customer satisfaction survey results
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlightthe value of analytics
• In Confidential application, have issued DAX queries in Power View.
• Made use of DAX to access data directly from a tabular database, by creating them in other clientapplications.
• Worked on deploying and scheduling Reports using SSRS as well as triggers to generate all daily, weekly,monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of thefinal Report.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning

Environment: MS SQL Server 2008 R2, SQL Server Reporting Services 2008 R2, SQL Server IntegrationServices 2008 R2, Tableau, SQL Server Analysis Services 2008 R2, CDC, TFS, MS Visio 2007, Windows 7/ Vistaand T-SQL

Confidential, Victorville, CA

SQL Server DBA

Responsibilities:

• Installed, configured, upgraded, maintained data replication with SQL DB.
• Created and developed the stored procedures, triggers to handle complex business rules, Historical dataand audit analysis.
• Conducted database management, performance measurement and tuning for new and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Worked with agile development teams to get stories developed and tested.
• Created and administered multiple development, training and production databases.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases
• Able to assess risks and impediments efficiently and determine effective courses of action, resulting in successful implementations and a continuously developing enterprise agile practice.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL clustering, quality assurance including database consistency check.
• Worked with development teams in the design of physical databases and in modification.
• Responsible for database security of the operational and developmental application system databases.
• Expertise in dealing with the data on Property and Causality insurances.

Environment: MS SQL Server 2000, T-SQL, SQL Server Enterprise Manager, SQL Profiler, Excel, Data Import, DBMS, C.

Confidential

SQL BI Developer / DBA

Responsibilities:

• Involved in complete Software Development Life Cycle ( SDLC ) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
• Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• Used various Transformations in SSIS Data Flow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries .
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Involved in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. ( Table , chart and matrix report ).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Created database tables using SQL Server 2005 and used Stored Procedures, Triggers and Cursors for all views of the Registration from and Search Engine Module.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Used server controls, data grid and data list to display information to the user.
• Participated in various Clients meeting with the team and the Project Manager to discuss improvements/amendments in the development of the application.

Environment: MS-SQL Server 2008, Visual Studio 2008, SSRS, SSIS, SSAS.

Confidential

SQL Developer

Responsibilities:

• Created tables, views, indexes based on the requirements
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T- SQL in development and production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster index, Non-Cluster index) tables.

Environment: MS SQL Server 2000, T-SQL, SQL Server Enterprise Manager, SQL Profiler, Excel, Data Import, DBMS, C, MS Visio