SUMMARY:

• Around 5 years of IT experience as a SQL Server Developer that includes Database Design and Development of MS SQL Server 2016/2012/2008 .
• Exposed to all phases of software development life cycle SDLC including in - depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures.
• Experience in Data Modeling, Databas e Design, SQL Scripting, Development and Implementation of Client-Server & Business Intelligence (SSIS, SSAS, and SSRS) applications.
• Expertise in scripting T-SQL queries, complex stored procedures, Views, user defined functions (UDF), Database triggers.
• Proficient in debugging Stored Procedures and Triggers in SQL Server and PL/SQL.
• Experience in Performance Tuning, Monitoring and Optimization of T-SQL blocks in both Development and Production environment for SQL server database.
• Strong knowledge in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML).
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• ETL processes include migrating data from a DB2 database to SQL Server. Implemented high availability on the various servers using replication/mirroring.
• Expert knowledge in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Expert in creating SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Good experience in writing DAX, MDX queries while creating and customizing Cubes using SQL server Analysis Services (SSAS).
• Experience in Developing and extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Strong experience in creating and deploying parameterized reports using Power BI and writing custom DAX functions.
• Created analytical reports and visualizations with Microsoft Excel 2013Power BI tools (Power View, Power pivot and Mapping) for exploratory analysis for data analysts
• Expert in designing complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Expert in generating Drilldown reports, Parameterized reports, Linked reports, Ad-Hoc reports, Sub reports and filters, charts in SSRS 2016/2012/2008 .
• Extensive knowledge of designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS- Excel spreadsheets.
• Worked with team in developing interfaces using C#.NET.
• Experience in working with source control tools such as TFS, SVN, GIT and version control tools like Redgate tool suite, Apex Source control tool.
• Knowledge on Active Directory Administration and good understanding of Change Control process
• Worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema and Entity relationship diagrams from business requirements.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Good SQL Server Administration skills including, Backups, database maintenance, user authorizations, Database creation, Tables, indexes.

TECHNICAL SKILLS:

Languages: SQL, Transact SQL, PL/SQL, Embedded SQL, C, C++ Java, C#.NET, VB.NET, HTML 4.0, DHTML, XML

Databases: SQL Server 2012/2008 R 2/2008/2005/2000, SharePoint, Oracle 9i/8.x, DB2, MS Access

Reporting Tools: Power BI, SQL Server 2016/2012/2008 R2/2005 Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools: SSIS, SQL Server 2000 DTS, Import Export Data, Bulk Copy Program (BCP)

MS Office: 2010/2007/2003/2000, MS Project Adobe Professional.

Operating Systems: Windows (updated to 2012), MAC OSX Tiger/Leopard, Unix, Linux (Ubuntu updated to 12.04)

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2008 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential, Littleton, CO

Software Developer II

Responsibilities:

• Participated in all phases of SDLC process with development team. Discussed performance related improvements/amendments.
• Actively participated in requirement gathering and analyzing data sources. Assisted in creation/review of Business, Functional requirement Documents for business systems, experience in database design process and data modeling process.
• Created complex Stored Procedures, Views, Triggers, Functions, Indexes, SQL joins and other T-SQL code to implement business rules. Implemented different types of constraints on tables for consistency.
• Performed optimization and performance tuning on multiple legacy stored procedures to improve the performance.
• Formulated and documented ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations and expressions.
• Created several SSIS packages for extracting data from data bases like SQL, DB2 and load those data into tables in SQL server.
• Used various transformations such as Lookups, Multicasts, Pivots, Derived Columns, Merge joins, Conditional splits etc. when data transformations process was done.
• Involved in end to end SSIS life cycle in creating SSIS packages, build, deploy and execute the packages in both the environments (development, Test and production).
• Responsible for migration and testing of several SSIS packages from SQL 2008R2 to SQL 2012.
• Acted promptly on job failures notifications to rectify the issues to enable proper data flow. Handled Client/vendor relations by maintaining proper communication about the status of data/job failures.
• Designed complex reports like dynamically driven parameterized reports, reports with sub reports, drill through reports using SSRS 2012.
• Developed several Linked, Snapshot, Cache and Ad hoc SSRS reports for various internal departments.
• Analyzed Key SSRS reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
• Generated SSRS Reports using Global Variables, report expressions (including simple VB codes) and Functions.
• Created custom dashboard and report sharing using Power BI with claim lag and network summary report for the sales team to analyze trends.
• Shared reports in Power BI service to entire Organization in Office 365.
• Created several visualizations and featured dashboards using Power BI for Underwriting Team for Fully funded group reports.
• Played the dual role of Analyst and Developer gathering requirements from VP, analyzing the data and developing SSIS packages and Power BI/ SSRS reports.
• Worked on Cube structure optimization for MDX query performance in Analysis Services 2012 (SSAS) for Healthcare Cost, Financial Summary and in-Network and out-Network packages.
• Documented and uploaded the standard design and development techniques of SSIS packages and SSRS reports development procedure in the share point.
• Provided 24 X 7 support based on the schedule provided.

Environment: MS-SQL Server 2016/2014/2012, MS-SQL Server Integration Services SSIS, MS-SQL Server Reporting Services SSRS, Power BI, Windows Server 2012, VB.NET, MS-SQL Server Analysis Services SSAS, T- SQL, DAX, MDX, Team Foundation Server (2013)

Confidential - Austin, TX

SQL BI Developer

Responsibilities:

• Created complex Views, Stored Procedures, Triggers, Functions, Indexes, Tables, SQL joins and other T-SQL code to implement business rules for Izenda reports, Tableau reports and SSRS reports. Implemented different types of constraints on tables for consistency.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created several SSIS packages for extracting data from data bases like SQL, DB2 and load those data into tables in SQL server to create final Roster report.
• Designed DDL and DML for MS SQL Server 2008R2/2012.
• Created Variables, Expressions for Connection String, Project Parameters, Package Configuration, Parent package variables. Worked on Project level deployment in TFS 2013.
• Used VB script in script components for data transformations and Used ASP.NET Globalization for the application to work for multiple cultures.
• Extensive experience in working with .NET and SQL CLR programming.
• Documented design and development work for creating views, stored procedures or SSIS packages pertaining to Izenda or Tableau reports deployment, uploaded reports into SharePoint site.
• Worked on various mingle tasks for different sprints contributing for hyper loop process and Bullet train.
• Created different SQL jobs and maintained those jobs in the production.
• Worked on the cube deployment and star schema deployment to different data bases.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Worked on deploying the code and unit testing in different team environments.
• Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Develop staging tables and created indexes in the destination table to make the ETL process faster than expected.
• Created Data marts for Staging and Production databases for Operational Data Stores (ODS).
• Worked on Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Deploy the packages in production server and schedule the packages according to the requirements.
• Worked on Integration of HLC reports with Tableau.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• With the help of visualizations in Power BI, created various visualization like Pie charts, bar graphs, Tree maps etc., that will helpful easily to understand the data
• Wrote MDX queries and KPI’s using SQL server 2008/2012 SSAS.
• Created org Hierarchy for the process of authorization and authentication for accessing Tableau reports by end user.

Environment: MS-SQL Server 2012/2008R2/2012/2014, MS-SQL Server Reporting Services, MS-SQL Server Integration Services, Windows Server 2012, VB.NET,ASP.NET,MS-SQL Server Analysis Services, T- SQL, MDX, Source Safe, Team Foundation Server (2012), Team Foundation Server (2013)

Confidential

Database/SQL Developer

Responsibilities:

• Designed relational data base in SQL server for Line Management section. Applied data integrity rules, defined relationships between foreign and primary keys in the tables.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. Implemented different types of constraints on tables for consistency.
• Generated Reports using Global Variables, report expressions (including simple VB codes) and Functions. Designed complex reports like dynamically driven parameterized reports, reports with sub reports, drill through reports using SQL reporting services 2008.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created different Parameterized Reports (SSRS 2008/2012) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Created several SSIS packages for extracting data from data bases like SQL, DB2 and load those data into tables in SQL server
• Used various transformations such as Lookups, Multicasts, Pivots, Derived Columns, Merge joins, Conditional splits etc. when data transformations process was done.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support.
• Look up transformation was used to check whether data is already in the source table before inserting. SQL task was used to truncate or delete tables before loading data.
• Added SQL Server Providers for logging to capture information about a package at run time, making it easier to troubleshoot package performance and failure. Performed package, container, and task level logging.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008 (SSAS)
• Worked on deployment of ROLAP using binding as well as deployment of ETL objects to target schema.
• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 8.0.
• Created Variables, Expressions for Connection String, Project Parameters, Package Configuration, Parent package variables. Worked on Project level deployment in TFS 2012.
• Created various SSIS configuration settings including SQL Server and XML configuration files. Implemented Check Points to restart execution of failed packages only from the point of failure instead of re-running the whole package from the start.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Generated SSRS report form SSAS OLAP Cube.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Documented design and development work for report deployment, uploaded reports into SharePoint site, created new pages and folders and maintained reports in SharePoint site.
• Improved the performance of queries by introducing clustered and non-clustered indexes on tables in the data base. Use SQL profiler to identify long running queries.
• Created different SQL jobs and maintained those jobs in the production.
• Used Ralph Kimball’s Data Modeling concept when designing an OLAP cube for Line Management section. Created dimension and fact tables. Created SSIS packages and stored procedures to load those dimension and facts tables.
• Worked on star schema and snowflakes deployment process coordinating with the DBA’s
• Partitioned the cube for current year and previous years in order to improve the performance.
• Created MDX queries to create custom pivot reports and calculated members in the cube.

Environment: MS-SQL Server 2012/2008R2/2012, MS-SQL Server Reporting Services, MS-SQL Server Integration Services, Windows Server 2012, VB.NET,ASP.NET,MS-SQL Server Analysis Services, T- SQL, MDX, Source Safe, Team Foundation Server (2012)

Confidential

SQL Developer/BI Report Developer

Responsibilities:

• Developed Business Process Flows and created ER diagram using ERwin for social media management software for the development team to understand the system.
• Designed a relational database using Erwin data modeling tool. Created logical and physical data models. Defined the relationships between primary and foreign keys in tables. Generated the data base script using Erwin.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Integrated Database maintenance jobs to perform full, differential & transaction log backups and scheduled them with the SQL Server agent job scheduler. Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into destination databases for further Data Analysis and Reporting.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Created rollback and committed transactions in SQL queries, used collections, inserted various kinds of constraints and indexes to enhance the queries.
• Improved the performance of queries by introducing clustered and non-clustered indexes on tables in the data base. Use SQL profiler to identify long running queries.
• Write complex SQL queries and create stored procedures for retrieval of the data and analysis of the data. Created complex Triggers, Functions, Indexes, Tables, Views, SQL Joins and T-SQL code to implement business rules.
• Identified key dimensions and key measures. Built dimensional model and assign hierarchy, attribute relationship to the various dimensions and measures defined using SSAS.
• Written SQL queries, MDX queries and developed Social Media reputation reports like dynamically driven cascade parameterized reports, reports with sub reports, drill through reports using SQL reporting services 2008/2008R2. Create scorecards, KPIs and dashboards, analytical charts and reports.
• Use different features like grouping, sorting, and reports parameters to build sophisticated reports. Built Ad hoc reports and added drill through functionality using report builder, and created tabular, matrix, graphical reports from SQL/OLAP data sources using SQL Server 2005/2008/2008 R2 Reporting Services.

Environment: MS-SQL Server 2005/2008/2008 R2, MS-SQL Server Reporting Services, MS-SQL Server Integration Services, MS-SQL Server Analysis Services, TFS 2008,T- SQL, MDX, SharePoint Server, MS Access, MS Excel, Visio, Windows XP Professional, MS Access, MS Excel, Visio, Oracle Server.