PROFESSIONAL SUMMARY:

Highly motivated software developer professional with over 7 years of experience in providing software, business intelligence, database and data warehousing solutions.

DATABASE AND BI FORTE:

SDLC: Agile, Scrum, Waterfall, and Spiral

Programming technologies: C#/.Net, ASP.NET, MVC, SOAP, REST, WCF, WebAPI, IIS, Postman, Fiddler

Front - end: HTML, JavaScript, Angular

Databases: MS-SQL Server 2005, 2008R2, 2012, 2014, 2016, IBM Netezza T-SQL Programming, Dynamic SQL, Netezza-SQL

Data Modeling: ER-win, MS Visio

Business Intelligence Tools: Power BI, Tableau

Collaboration Tools: TFS and SharePoint

Microsoft Azure: Cloud Services (PaaS & IaaS), PowerShell, Azure SQL Database (PaaS), Azure Storages (Blob, Tables, Queues), Backup/Recovery

Source Control: Team Foundation Server (TFS)

Integration Services: SSIS

Reporting Services: SSRS, Report Builder

PROFESSIONAL EXPERIENCE:

Confidential

SQL/.Net Developer

Responsibilities:

• Collaboration with team in defining and documenting software requirements based on business requirements from the business meetings.
• Documenting description of requirements and writing Agile stories and tasks in TFS.
• Development of endpoints in .NET web application framework based on Service-oriented Architecture (SOA). The endpoints were used for various purposes such as Posting claim and/or encounter submissions or to Get member eligibility.
• Design and development of a C#/.Net app to assign the most suitable PCP to a list of members based on various factors such as age, location, gender etc, auto-assign and re-assign whenever provider/member properties change.
• Provide SOAP and REST Web service development utilizing Microsoft WCF and WebAPI.
• Utilize WebAPI connections to communicate with remote servers for syncing pharmacy data between Confidential databases and Meditrac (3rd party software).
• Development and debugging using various .Net tools such as linq, asynchronous programming, attributes, breakpoints, C# Interactive, Immediate window, events, delegates, lambda expressions, partial classes, extension methods, Generics, etc.
• Debugging and upgrading existing software as directed after Go Live (including testing Web APIs using Postman and Fiddler).
• Debagging endpoints with Google Chrome's developer tools and identifying failing endpoints, checking JSON requests and responses and tracking the logged errors.
• Design and development of DAL and BLL layers in a three-tier architecture for the re-assignment project.
• Assisted in changing Mashups UI in Angular.
• Design and development of .Net Data Frameworks and Models in Provider Network project.
• Creating IIS applications and publishing web applications to IIS servers.
• Utilizing Dynamic SQL, User-Defined Table Types, Temp tables, CTEs, Error handling, etc. in stored procedures.
• Utilizing SQL indexes, partitions, execution plans, etc to improve performance of database objects.
• Using VSTFS in a large SOA team for various actions (e.g. check in, check out, merge, resolve conflicts etc.)
• Developed SSIS 2016 packages to interact with Web Services to look up pharmacy and provider data (name, address etc.)

Tools: Visual Studio 2014/2016, SQL Server 2014/2016, IIS, Postman, Fiddler, Google Chrome's developer tools, TFS, SSIS 2016, JAMS, SharePoint, ASP.NET, HTML, JavaScript, Angular, JSON, XML

Confidential

SQL/Backend Developer

Responsibilities:

• Transformed complex business requirements into functional requirements.
• Created documents to support SSIS deployment process in UAT and production environment.
• Designed and developed multitude of dimension tables, look up tables, ETL tables in an Enterprise Data Warehouse.
• Wrote queries Triggers, CTEs, functions, stored procedures and dynamic T-SQL code in SQL Server 2016 and Netezza-SQL.
• Wrote C# code in support of ETL process and improved performance utilizing StringBuilder class for creating text files and XML files.
• Utilized ADO.NET extensively to access the database.
• Involved in the development of SOAP based XML Web Services such as Management forms in the business logic components of the system.
• Extracted data from XML files with complex schema and wrote C# code to create XML files with SSIS.
• Improved performance of SSIS packages embedding efficient SQL queries and avoiding asynchronous transformations.
• Developed SSIS 2016 packages to interact with Web Services to look up customer data (name, address etc.)
• Developed triggers to manage historical and current data in tables within SQL Server.
• Improved performance of tables by making right decisions about distribution columns, grooming and checking zone maps of the tables in a 64-SPU IBM-Netezza system.
• Created SSIS packages to perform ETL utilizing transformations such as derived column, look up, fuzzy look up etc.
• Assisted in deployment of ASP.NET application and maintenance of IIS Server.
• Creating various stored procedures and using sql connections in C#/.Net to populate datatables and datasets.
• Configured SSIS packages with parameters (project and package) to pass values during runtime.
• Performed unit testing of the packages in development environment to avoid bugs.
• Deployed SSIS packages to development and integration environment utilizing project deployment model.
• Cleansed and profiled data from different sources before loading into data warehouse.
• Wrote a console application to convert Journal files into columnar data and load into the Enterprise Data Warehouse.
• Validated the ETL data load process using TSQL scripts for post load operations.
• Configured and scheduled SSIS packages to execute after hours with SQL Job Agent.
• Designed various plans and scheduled tasks in ActiveBatch7 and Activebatch9.
• Wrote Batch Code to move FTP files between remote servers with ActiveBatch9.
• Used Team Foundation Server (TFS) as a version control tool for SSIS packages.
• Created Gift Card report based on partner and store in Tableau.
• Created tableau report for fuel discounts for AdvantEdge program members.
• Configured Azure virtual machines, and virtual networks.
• Modified SQL database objects on Azure connecting from Management Studio
• Migrated data to MS Azure cloud platform from on-premises data servers utilizing BLOB/file cloud storage.

Tools: Visual Studio, SQL Server 2014/2016, ASP.NET, SOAP, C#, IIS, MS Azure, SSIS 2016, IBM Netezza, Aginity, ActiveBatch 7/9, Tableau, WinSCP, SharePoint, TFS, WinMerge

Confidential

SQL Developer

Responsibilities:

• Transformed and documented business requirements into functional requirements.
• Designed the logical model with database relationships; implemented to SQL Server with ER-Win.
• Created complex stored procedures, embedded into data profiling SSIS packages.
• Audited database changes such as creating, altering, dropping of database objects with triggers.
• Evaluated and modified existing stored procedures to improve performance.
• Implemented error handling options in procedures and scripts with ‘try-catch blocks’, throw, and ‘raiserror’ functions.
• Analyzed frequently executed queries and designed covering indexes to avoid bookmarks, keys, and RID lookups.
• Modified the existing data mart (OLAP system) to support business and policy changes.
• Developed complex mappings with SSIS to transform and load data from a multitude of sources into the OLAP destination.
• Assisted in design, development and testing of .NET applications using .NET framework.
• Developed C# components from SSIS perspective to connect BI applications to database components.
• Deployed SSIS packages to multiple environments with the project deployment utility.
• Debugged SSIS packages in the production environment with loggings and break points.
• Created OLAP structures in SSAS 2012; modified dimensions and measures.
• Designed parameterized reports with parameters in SSRS.
• Generated test cases to test reports in development and integration environments.
• Designed and developed dashboards with Tableau and Power BI.
• Scheduled reports deliveries in multiple rendering formats with data-driven subscriptions.
• Monitored changes in SSIS packages, reports, cubes, and database objects with Team Foundation Server (TFS).

Tools: Visual Studio 2012, SQL Server 2012, T-SQL, SSMS, MS Excel, Erwin, ASP.NET, SSIS, SSAS, SSRS, SharePoint, Tableau, Power BI, Power View, TFS, DTA, SQL Profiler

Confidential

SQL Developer

Responsibilities:

• Created a document to ensure deployment method standardization across development teams.
• Implemented procedures with multiple temp objects such as temp tables, CTEs, and table variables.
• Transferred data between SQL Server and flat files with BCP utilities and bulk inserts.
• Collaborated with DBAs to generate scripts to retrieve frequently used tables.
• Implemented clustered and non-clustered indexes on multiple tables, based on usage.
• Improved the efficiency of queries by analyzing execution plans.
• Designed packages to include transformations such as slowly changing dimensions, look ups, and derived columns.
• Wrote C# code in script tasks and components to implement complex data retrieval operations.
• Implemented incremental loads with checksum and timestamp techniques.
• Retrieved data dynamically from multiple Excel files with ‘for-each-loop’ containers.
• Altered the package properties such as delay validations, transactions, and max concurrent executables.
• Created reports with parameters, cascaded parameters, drill-down, and drill-through functionalities.
• Deployed reports to the reporting server in SharePoint integrated and native modes.
• Created score cards with executive summary dashboards with MS Office Performance Point Server 2010.
• Developed solutions with Power View for reporting and dashboard implementation on web pages.
• Optimized embedded queries and stored procedures which generate reports.
• Managed multiple versions of code and distributed code with Team Foundation Server.

Tools: Microsoft SQL Server 2008R2, BIDS, SSMS, T-SQL, SSIS, SSRS, SSAS, ER-Win, Power Pivot, SharePoint, TFS, DTA

Confidential

BI Developer

Responsibilities:

• Prepared Power Point presentations regarding project status and future expectations.
• Scheduled the delivery of multiple reports utilizing standard and data-driven subscriptions.
• Supported the application team with the creation of views, procedures, and functions.
• Retrieved hierarchical data from databases with recursive CTEs.
• Created scripts and procedures with set based operations and row by row operations.
• Identified tables requiring indexes to improve data retrieval; created indexes.
• Designed SSIS packages to transfer data between servers with bulk insert tasks.
• Created SSIS packages with a master-child architecture to ensure a flexible execution process.
• Configured SSIS package properties during deployment such as server, database, and file location.
• Designed standard templates with logging and error handling options to improve development efficiency.
• Created cube objects such as KPIs, perspectives, and calculated members.
• Generated reports from relational databases, the relational data warehouse, and OLAP cubes.
• Created and deployed report models to generate ad-hoc reports.
• Optimized report performance with cache and snapshot options.

Tools: MS SQL Server, BIDS, SSIS, SSRS, Erwin, SQL Profiler, SQL Debugger, SharePoint, Power Pivot, TFS, Excel, Windows Server

Confidential

ETL/SSRS Developer

Responsibilities:

• Generated T-SQL scripts to create database objects and relationships.
• Documented changes to stored procedures and functions.
• Automated data entry through a front-end application with stored procedures.
• Wrote complex queries with dynamic SQL, joins, and sub queries.
• Analyzed the existing OLTP to locate and determine dimensions and facts for the OLAP database.
• Retrieved data from multiple sources such as Oracle and flat files with SSIS packages.
• Implemented logins, transactions, and configurations into ETL packages.
• Optimized ETL packages at control flow and data flow levels.
• Designed parameter-driven reports with multiple parameters utilizing SSRS 2008.
• Exported reports in multiple rendering formats.
• Delivered reports with data driven and standard subscriptions.
• Scheduled jobs for database backups and restores with SQL Server Job Agent.

Tools: SQL Server 2008 Enterprise Edition, SSIS, SSAS, SSRS, Query Analyzer, T-SQL, Excel, Visio, DTA, SQL Profiler

Confidential

SQL/SSRS Developer

Responsibilities:

• Normalized existing ER diagrams to improve data quality.
• Created multiple check constraints to maintain data integrity.
• Scripted complex queries, stored procedures, and UDFs to support the OLTP database.
• Implemented indexes on tables and views to optimize query performance.
• Scheduled SQL jobs and alerts for SSIS packages and procedures.
• Created drill-down reports, enabling user access to summary and detailed data.
• Reduced report lag with optimizations to embedded data sets.

Tools: SQL Server 2008/05, SSIS, SSRS, SSMS, T-SQL, Windows Server, SQL Profiler, DTA