PROFESSIONAL SUMMARY:

• Over 7+ 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.
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2012.
• Experience in SDLC methodologies& Agile/Waterfall project methodologies in Analysis, Design, Development, Testing and Implementation of client - server based applications.
• 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.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP&OLAP.
• 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.
• Expertise in system analysis, design, development, testing and implementation of projects (SDLC).
• Efficient in creating joins and sub-queries for complex queries involving multiple tables.
• 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.
• Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Hands on experience on writing Teradata ETL scripts using BTEQ.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008 R2.
• Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services and MDX technologies of Analysis services.
• 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 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 there commendation on server related tuning issues.
• 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
• 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.
• Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP). Worked with Data mining and slowly changing dimensions.

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, Crystal reports.

Data Modeling: Visio 2007

Application Packages: MS Outlook

PROFESSIONAL EXPERIENCE:

Confidential - Albuquerque, NM

Sr.SQL/MSBI Developer

Responsibilities:

• Deployment of SSIS packages to the conversion server and create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis.
• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development. T-SQL development included queries using joins, sub-queries, Ranking functions, Derived tables, common table expressions (CTEs),stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Work on creating scripts (Cache SQL) in Toad Data Point for data from IDX-GE Systems and Created Data extracts in SSIS.
• Created the ETL (SSIS) packages and ETL procedures scheduled them for Jobs.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using (SSIS).
• Improved the performance of SSIS packages by enabling Parallelism in the Control and Data Flows, usage of synchronous transformations.
• Experience in creating master and child packages, using package configurations (SQL Server)and SSIS logging.
• Involved in Source Data Analysis and Designing Mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Responsible for creation and maintenance of tables, indexes, stored procedures, triggers, and UDF’s
• Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors
• Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer
• Used Fuzzy grouping transformation to consolidate data and submitted data cleansing reports to the client.
• Created custom Logging and Auditing framework incorporated in an SSIS package template that was used in the project' s ETL packages.
• Identifying, and documenting ETL Standards and best practices for the development team.
• Participate in creating data conversion and migration strategy, conversion design and conversion development documents. Participate in Data Modeling Sessions.
• Hosted SSIS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• Used majority of the transformations, tasks, containers present in SSIS which include Fuzzy grouping, Derived Column, Conditional Split, Aggregate, Lookup, Row Count, Merge Join, Union All, Multicast, Sort, Copy column, Data conversion and other transformations during development.
• Used Team Foundation Server 2010 to check in code artifacts and Techno solutions Top Team third party tool for process oriented tasks like assigning tasks, logging & assigning code defects, check in key decisions, documents etc.
• Implemented framework for Reference/Lookup data changes, Automation of Applying Database Change Request scripts to the target DB.
• Developed data reconciliation SQL queries to validate the overall data migration. Prepared data reconciliation reports for conversion team/business. Maintained ETL functional specifications, test plans and data for data conversions. Automated the data reconciliation process to minimize the developer involvement in validating production migrations.
• Documentation of Business Rules, Data Mapping Spreadsheet, Meeting Minutes, Key decisions from the client, SSIS introduction material to the client.
• Worked with Managers to prepare WBS for SSIS/Database development work.
• Implemented free text parser for FTP and web data feed in C# .Net
• Generated Custom ETL scripts using SSIS 2008 and unit test SSIS load processes for performance check.
• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs to provide data for the Development DB,SIT, UAT, Data Reconciliation and validation.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in migration and conversion of Reports from SSRS 2008 to 20012
• Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2005/2008
• Created report models for the ad-hoc reporting of the end users using Report Builder
• Deployed SSRS reports in share point for web based access for multiple end users
• Documented all the migration process documents for future reference
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation.
• Deployment of SSIS packages to the Conversion Server.
• Create and configure SSIS logging to capture log-enabled events that occur at run time.
• Developed staging tables to house the data and developed exception/error handlers to prevent issues with data being written to the new DB within SQL SERVER SSIS.
• Used XML Package configurations to allow users to modify the package without using BIDS.

Environment: MS SQL Server 2010/2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2010/2012, C#, SQL Server Profiler, Oracle 10g, Dashboard, Power BI, SQL Server Management Studio, Team Foundation Server (TFS), McGraw Hill, WAND PM, SQL Server Business Intelligence Development Studio (BIDS), Toad Data Point.

Confidential, Troy, MI

SQL BI Developer

Responsibilities:

• 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.
• Worked on enterprise solutions development with rapid SDLC Agile Methodologies, SCRUM.
• Created several SSIS Packages to pull data from OLTP RAW and create a highly de-normalized data mart out of it.
• Created reports according to the requirement document provided by the client.
• 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..
• 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.
• Create custom Visual Basic and Access VBA code to automate business processes, and in corporate ActiveX Controls (spreadsheet control) to enhance Access GUI.
• 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.
• Highly responsible for development and management of SSAS, 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 con Power BI SME responsible for the design, development and production support of interactive data visualizations used across the company
• 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.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• 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.
• 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 client requirements.

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

Confidential, Bentonville, AR

BI Developer

Responsibilities:

• 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 Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Written T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Used agile methodology for the development.
• 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.
• Developed calculated members and MDX expressions for specific OLAP reporting requirements.
• Optimized and Aggregated cubes with 40% performance for better performance. Processed cube toper form incremental updates.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and 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.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Have created star and snowflake schemas in SSAS
• 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 in Tableau
• Generated KPI for customer satisfaction survey results
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics
• In client 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 client applications.
• Worked on deploying and scheduling Reports using SSRS as well as triggers to generate all daily, weekly, monthly and quarterly Reports including current status.
• 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 Integration Services 2008 R2, Tableau, SQL Server Analysis Services 2008 R2, CDC, TFS, MS Visio 2007, Windows 7/ Vista and T-SQL

Confidential, Downers Grove, IL

SQL /BI Developer

Responsibilities:

• Experience in SSIS script tasks, look up transformations and Data flow tasks using T- SQL, C# and Visual Basic scripts.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.
• Involved in Framework development for ETL Implementation and support for the Analytics and Reporting needs for various customers
• Created SSIS packages for importing the Excel layouts into the database using SSIS.
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Expert in Data Extraction, Transforming and Loading (ETL) using Business Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS)
• Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping.
• Developed packages using various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIsby Using Tableau.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Developed crystal reports using Crystal Reports 10 for detail information to the sales team regarding sales of all stores according to the criteria given, which helped the sales team to take their decisions.
• Improved data load performance by analyzing database design and query plans.
• Modified and Create Joins to Improve the Database and execution speed.
• Using Tableau server versions (7.0 and 8.2) as a front-end BI tool and Microsoft SQL Server 2012 as a back end database designed and developed workbooks, dashboards, global filter page, and complex parameters based calculations.
• Worked with visualization tools such as Tableau in Building the Reports.
• Designed and Developed matrix, tabular and parametric Reports using SSRS 2012.
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
• Strong knowledge of managed claims management process, Knowledge of Medicaid and Medicare Services. CMS, Health Assessment Systems,Hl7 Standards, HIPAA, PPACA (Patient Protection and Affordable Care Act), Compliance issues, HL7 Message Validation, ICD 9, Electronic Health Records, Electronic Medical Records.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Involved in Mock testing, Unit Testing and Integration testing in SSIS, SSAS.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server Analysis Services (SSAS).
• Published detailed guide describing data file content and structure for business partners; created quick reference guide for HIPAA EDI ASC X12 834 transaction set for Medicaid enrollment.
• Involved in Performance Tuning using SQL Server Profiler and SQL server Hints. Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2012.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services ( SSAS ).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services ( SSAS ).
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Used Team Foundation Server (TFS) for source control, and data collection.
• Used C# in Script Tasks (SSIS Packages)

Environment:: SQL Server 2008R2, 2012,SSIS, SSRS, SSAS, Teradata, Visual Source Safe 2012, Erwin 4.0,QlikView,Power BI, MS Excel 2010, C#, Team Foundation Server (TFS), Windows Server 2010, VBA, BTEQ, Maximo, Tableau Crystal Report 10.

Confidential, Atlanta

SSIS /SSRS Developer

Responsibilities:

• 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.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Developed Cubes using SQL Analysis Services (SSAS) and Dimensions using cube wizard and also Generated Named calculations and named queries.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, dataload and transformations.
• Created various database objects such as tables, indexes and views based on the requirement.
• 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/DTS packages.
• Created data sources, connection strings and defined the datasets for generating the report.
• Created and worked with drill down reports and identified the report parameters.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to analysis server from SSRS (2005/2008).
• Extensively involved in SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Migrated Crystal reports to SSRS reports.

Environment: T-SQL, PL/SQL, MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, LDAP, BCP, Visual Source Safe (VSS), Windows XP, Crystal Reports.