SUMMARY

• 15+ years of SQL Server development experience (Versions 6.5/7.0/2000/2003/ 2005/2008/2012 ), Oracle 10,11G,12, DB2, MySql, Hadoop, BigData, NoSQL, Posgress SQL, Cassandra, Azure, AWS, SalesForce
• 8+ years of Experience in Qlikview/Qliksense(Nprinting) / Tableau,Dashboard Development & Admin / Report Designing /Microsoft Prism Library for WPF and Silverlight / Administration.
• Has experience in Business Intelligence (BI) tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) MS Power BI, Visual Studio.
• Worked with Data Sources & Data Source views
• Defined Dimensions and their properties
• Built multiple Data warehouses
• Defined and deployed Cubes
• Worked with OLAP
• Worked with Hierarchies and Calculations
• Worked with Attributes and attribute relationships
• Defined Actions, perspectives and translations
• Worked with MDX Scripts
• Experience in Advanced SQL, SQL Broker Services, SQL Functions and PL/SQL.
• Dynamics CRM, JSON, JIRA
• Has good experience in .NET programming as well.(C#, ASP.NET, IIS, SQL, XML, JQuery)
• Worked with Oracle Development, ETL and Production support, Stored Procedure, T - SQL coding, PL/SQL, Performance Tuning, Physical and logical Database Design.
• Experience with SharePoint 2007 BDC, Web Services, Report Server and excellent experience with SOAP Application interacting with XML
• QA automated Tools: Selenium, Watir, Testcomplete, Appium, TestStudio, Cucumber
• Industries: Healthcare, Banking/Finances, Retail, Manufacturing, Mining, Education, Federal, Marketing

TECHNICAL SKILLS

Operating Systems: Win 10/8/7/XP// 2000/NT/2003, 2008,2010 server, Red Hat Linux, Solaris, UNIX

RDBMS: MS SQL SERVER 2017/2014/2012/2008 R 2/2005/2003/2000/7.0/6.5 , MS Access, Oracle 8i/9i/10g/11g/12, MySQL. Sybase (SQL Anywhere/SAP),MariaDB Dbase, DB2, MongoDB and FoxPro

Database & Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Oracle BI suite.TFS

Cloud Platforms: AWS, SQL Azure, SalesForce, DynamoDB, Oracle Fusion, Health Level Seven (HL7), Azure Cloud Services (PaaS & IaaS), Storage, Web Apps, Active Directory, Application Insights, Logic Apps, Data Factory, Service Bus

Storage: Azure Storage,Azure Blob Storage, Azure Backup, Azure Storage Disks- Premium, Azure Files, Azure Data Lake Storage Gen 1,AWS S3 Cloud Storage, AWS EBS, AWS Storage gateway, NETApp/EMC Storage Technologies, SAN

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS),Informatica, Datastage, Import Export Data, Bulk Copy Program (BCP), SOAP, Oracle.

Reporting Tools: Crystal Reports XI/X, MS SQL Server Reporting Services (SSRS), MS Power BI, Qlikview, Qliksense, Panorama, Business Objects, DigitalFuel, Tableau

Data Modeling: MS Visio, UML,ERWIN

PROFESSIONAL EXPERIENCE

Confidential

BI Developer/.Net/SQL Server

Responsibilities:

• Developed and automated ETL Packages to pull data from ERP Systems To Oracle and SQL Server using the IMP and BCP utilities
• Created report subscriptions and distribution list in reporting Services
• Data-warehouse Enterprise development in Oracle & SQL Server
• Queries performance tuning..
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Solution Architecture based upon Microsoft Azure PaaS Services
• Designed solution for various system components using Microsoft Azure
• Created Web API methods for three adapters to pull data from various systems like Database, BizTalk and SAP
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Configured & Setup Azure Hybrid Connection to pull data from SAP Systems
• Performed Peer’s Code Review to avoid any code quality issues.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Designed and developed Dynamics-AAA (Access, Authorize & Audit) Portal which provides secure access to Azure resources and assigns custom roles.
• Designed and developed Customer Lookup tool which is helping customer in expediting Azure outage assessment and end-customer communication workflow.
• Migrated the Azure CXP Tools to HTTPS based authentication using SSL encryption.
• Improved application performance using Azure Search and SQL query optimization.
• Built multiple Data Lakes on how the data will be received, validated, transformed and then published Architect & implement medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks, NoSQL DB) Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL datawarehouse environment Implement ad-hoc analysis solutions using Azure Data Lake Analytics/Store, HDInsight Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools) worked on Azure suite: Azure SQL Database, Azure Data Lake(ADLS), Azure Data Factory(ADF) V2, Azure SQL Data Warehouse, Azure Service Bus, Azure key Vault, Azure Analysis Service(AAS), Azure Blob Storage, Azure Search, Azure App Service,Azure data Platform Services. managing Azure Data Lakes (ADLS) and Data Lake Analytics and an understanding of how to integrate with other Azure Services. Knowledge of USQL and how it can be used for data transformation as part of a cloud data integration strategy Migration of on premise data (Oracle/ SQL Server/ DB2/ MongoDB) to Azure Data Lake Store(ADLS) using Azure Data Factory(ADF V1/V2).
• Lead the efforts to organize design and architecture sessions with the clients
• Data visualization and KPIs with Tableau/Qlik
• Prism architectural design on large applications and interaction with back-end systems & services
• SalesForce Data Integration from Cloud to SQL Server
• Data transfer and ETL automation using .Net Scripting tool and dynamic library
• Salesforce Apex Application development and Services automation.
• WebServices and SOAP development for mobile portal applications
• Developed plugins and custom workflow activities consuming MS Dynamics CRM web services and using CRM SDK APIs
• Create different types of charts for QlikSense Dashboard Analysis
• Implementing set analysis in Qliksense
• Provide input on proposing, evaluating and selecting appropriate design alternatives which meet client requirements and are consistent with client’s current standards and processes
• Creating and maintain technical design documentation
• Extracting, transforming and loading data from multiple sources into QlikSense applications.
• Implementing Azure SQL Database Virtual Network Service Endpoints and Rules
• Azure Automation and tasks scheduling
• Design Azure runbook to iterate through databases using Powershell Workflow engine and other
• Picking the right AWS services for the application
• Leveraging AWS SDKs to interact with AWS services from your application
• Writing codes to optimizes performance of AWS services used by various applications
• AWS Code-level application security (IAM roles, credentials, encryption, etc.)
• Developing and maintaining applications written for Amazon Simple Storage Service, Amazon DynamoDB, Amazon Simple Queue Service, Amazon Simple Notification Service, Amazon Simple Workflow Service, AWS Elastic Beanstalk, and AWS CloudFormation.
• Developing AWS RESTful API interfaces
• Consumed and exposed Dynamics CRM APIs for custom web front-end development and external service integration
• Prism architectural design on large applications and interaction with back-end systems & services
• Used CRM web service and developed a custom service using Windows Communication Foundation to provide extended functionalities to the common methods of CRM
• Identified, documented and communicated CRM configuration and development best practices to the upper management
• Lead the efforts to organize design and architecture sessions with the clients
• Reporting services development and deployment on webserver (2005 & 2008)
• SSIS Package development and configuration for dynamic deployment
• SSRS data driven subscription for report distribution and automation
• Database Backup/Restore Automation
• SQL Server agent job management
• Source codes repository management using Team Foundation Server (TFS)
• SSAS Cubes Development and improvement data source views, named queries, dimensions and deploying of analysis services projects.
• Implementation of Automation into Oracle and Microsoft Analysis Services processes
• Convert existing manual Excel and Access datasets/reports into Analysis Services solutions
• Reviewing and assessing the integration of Teradata and Analysis Services

Confidential

Business Intelligence Consultant/.Net/MS Power BI

Responsibilities:

• Developed plugins and custom workflow activities consuming MS Dynamics CRM web services and using CRM SDK APIs
• Developed Power BI model used for financial reporting of P & L and Headcount
• Implementing Azure SQL Database Virtual Network Service Endpoints and Rules
• Azure Automation and tasks scheduling with Python
• Design Azure runbook to iterate through databases using Powershell Workflow engine and other
• Picking the right AWS services for the application
• Designed and documented the entire Architecture of Power bi Poc
• Leveraging AWS SDKs to interact with AWS services from your application
• Writing codes to optimizes performance of AWS services used by various applications
• AWS Code-level application security (IAM roles, credentials, encryption, etc.)
• Developing and maintaining applications written for Amazon Simple Storage Service, Amazon DynamoDB, Amazon Simple Queue Service, Amazon Simple Notification Service, Amazon Simple Workflow Service, AWS Elastic Beanstalk, and AWS CloudFormation.
• Developing AWS RESTful API interfaces
• Automated Power Query refresh using power shell script and windows task scheduler.
• Integration Service Package Development calling webservices and updating Databases
• Consumed and exposed Dynamics CRM APIs for custom web front-end development and external service integration
• Prism architectural design on large applications and interaction with back-end systems & services
• Used CRM web service and developed a custom service using Windows Communication Foundation to provide extended functionalities to the common methods of CRM
• Identified, documented and communicated CRM configuration and development best practices to the upper management
• Lead the efforts to organize design and architecture sessions with the clients
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.. .
• Reporting services development and deployment on webserver (2005 & 2008)
• SSIS Package development and configuration for dynamic deployment
• SSRS data driven subscription for report distribution and automation
• Database Backup/Restore Automation
• SQL Server agent job management
• Source codes repository management using Team Foundation Server (TFS)
• SSAS Cubes Development and improvement data source views, named queries, dimensions and deploying of analysis services projects.
• Implementation of Automation into Oracle and Microsoft Analysis Services processes
• Convert existing manual Excel and Access datasets/reports into Analysis Services solutions
• Reviewing and assessing the integration of Teradata and Analysis Services
• MDX queries coding and tuning
• Adhere to HL7 standards to develop application interfaces to exchange patient data (Healthcare)
• MS Power BI/ Qlikview /TableauSolutions and Dashboard Development:
• Financial Management (Produce intra-day flash balance sheet reports, providing business leaders with a clear overview of the institution’s current financial standing on demand, rather than waiting for month-end results)
• Sales and Revenue Analysis (Improve management and performance by providing comparison points and benchmarking against internal peers, industry competitors and operational performance metrics)
• Transaction Monitoring (Spot anomalies at a high level, then drill down and discover a finite level of transactions in order to identify the source, thereby finding the discrepancy or identifying potential fraud)
• IT Management (Collaborate between the IT and Finance departments to investigate existing technology investments, depreciation, and analyze write-off/ sell-off values for retired items)
• Manufacturing Intelligence and Optimization (Refine/extend process improvement methodologies - Integrate production data with other business and compliance data - Contribute to higher levels of customer service and regulatory confidence - Extend operational cost reductions beyond the production floor )
• Healthcare Business Intelligence (Unify clinical automation with business processes - Simplify compliance reporting, patient administration, and transitions to Electronic Medical Records - Improve patient flow models and monitoring metrics - Benchmark and track performance against similar facilities - Institute clinical care optimization methodologies - physician performance management)
• Qlikview and Database Administration

Confidential

C#.Net/Database Developer / Qlikview 10/DB2/Tableau

Responsibilities:

• C# codes review for Consolidation Reporting Enterprise Stress Testing (CREST) Application
• System documentation
• SQL Performance tuning and Database Administration
• Source codes repository management using Team Foundation Server (TFS)
• Data Transformation System between SQL and FoxPro for retail Transactions.
• Use SQL linked Server to actively access DB2 data from finance COBOL framework
• Application Dependency Mapping for Attributes comparison between old and new version of CREST.
• SSAS cubes creation (including DMVs and dimensions). designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP
• Data Analyzing and deploying OLAP.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Prism Library for WPF Installation and Support
• Qlikview / MS Power BI Solutions Development:
• Executive Dashboards and scorecards Development (for top management decisions-making - Gain executive insight into business results and benchmark multiple key performance indicators against forecasts by product, geography, industry, line of business, etc. )
• Risk Management and Regulatory Compliance (Consistent and transparent mitigation of risk)
• Expense Management
• Customer Analysis and Targeting
• Asset Management and Investment Analysis
• Client Servicing
• Financial Management
• Sales and Revenue Analysis
• Transaction Monitoring
• IT Management
• Support QlikView client deployments

Confidential

.Net/Database Developer/QA Tester/ Qlikview

Responsibilities:

• Database Migration from MS Access 2007 to SQL Server 2008 R2 64 bit/ 2012 (and DBA)
• Open Database Connectivity for Linked Tables between Access Front End Application and SQL Server Database.
• Data Modeling, SDLC and requirements analysis
• Linked Server Administration from DB2 to SQL Server using Open queries
• ETL processes development from third party FTP site to Local SQL Database using Integration Services (SSIS) and .Net Scripting in C#, SSAS
• Intranet Time and Goal Tracking Application Development. ASP.net
• Database Administration: User creation and permission, Performance Tuning, Maintenance Plan
• Dynamic Report Development for Tables Definition using Reporting Services (SSRS)
• Qlikview Model development for Application scalability in Dashboard, Scorecards (physician performance management - hospital performance & quality measures - patient satisfaction - supply chain optimization - infection control and monitoring - cardiovascular care length of stay - Identify and reconcile patient requirements regarding medication, emergency plans, patient goals, and much more )
• Qlikview Administration and user Access Management
• Qlikview Extension Objects: Smart Data Entry (Input with Kliqplan -> Webservice -> RDBMS then back in Qlikview ) - Kliqmap - KlipCalc - KliqTable - Smart past from Excel
• Healthcare Datawarehouse development and Maintenance for VA Department of Health (DB2,SQL, ORACLE)
• QA Testing
• DBA: running DBMS in a physical and virtual environment - partition backups, clustering, replication - performance optimization for OLTP and OLAP applications
• Creating Data Tap files in SQL/SSIS 2012 programmatically using T-SQL.
• SSIS 2012 project deployment via Integration Service Catalogs - Use of .NET to extend the power of the stock SSIS 2012 toolkit
• Equity Capital Market - (ECM): reporting on overall marketing, distribution and allocation of new financial issues; initial public offerings, special warrants, and private placements

Confidential

Senior Software / Database/ Qlikview Consultant

Responsibilities:

• SOAP / ETL Application Development in C#.Net interfacing Oracle/SQL and XML files via Neustar Web Service.
• Database Design and Administration (Oracle / SQL Server)
• Service Level Management and Report Automation using “Digital Fuel” Tool.
• .Net webservice for Mobile tracking. (ASP.Net)
• Data Migration from MS Access to Oracle 11g using C# codes and Linked tables.
• Qlikview Solutions Development:
• IT and Logistic Management (Analyze purchasing trends to spot efficiency opportunities, allocate risk across vendors and identify cost outliers)
• Expsense Management (Produce consolidated and interactive on demand analysis quickly and securely while eliminating the reliance on end-of-month static reports)

Environment: C# .Net, MS SQL Server 2005/2008/2012 , ETL, Oracle 11g/12g,SQL Reporting Services (SSRS), SQL Integration Services (SSIS), Qlikview XML, Java, XLST, ASP.NET, Web Services, SOAP, Unix, Digital Fuel, ADO.Net, MDX, Visual Source Safe (VSS), MS Access,Dbase, Vb.Net, AJAX, SharePoint, CA Erwin Data Modeler 7.2 and SSAS, Solaris,.