SUMMARY

• 17+ years of IT experience
• 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, T - 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.
• 5 years Azure data lake, Azure Synapse, Azure data factory, Data Store, AWS
• 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, T-SQL, SQL Server Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Oracle BI suite.TFS

Cloud Platforms: AWS, SQL Azure, Azure Synapse, Databricks, Pyspark, 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

Programming and Markup Languages: C#, VB.Net, C, C++, AJAX, JavaScript, ADO.Net, ASP.Net, Java,Python, MDX, HTML, VBA, XML, XLST, BizTalk,Prism API, SharePoint, Android and DELPHI

PROFESSIONAL EXPERIENCE

Confidential, Alexandria VA

Azure Cloud Engineer/ Architect

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
• Created Solution Architecture based upon Microsoft Azure PaaS Services
• Designed solution for various system components using Microsoft Azure
• Data-warehouse Enterprise development in Oracle & SQL Server
• Queries performance tuning..
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Web API methods for three adapters to pull data from various systems like Database, BizTalk and SAP
• Load data into Azure Synapse Analytics by using Azure Data Factory
• Load data from Azure Data Lake Storage for Synapse SQL Data Warehouse environment
• 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.
• Developed Salesforce.com workflow, rules and triggers using Apex for updating Users based on Location records
• 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 Synapse, 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
• Azure API Management, Security, Cloud-to-Cloud Integration (Public, Private)
• 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
• MDX queries coding and tuning
• Adhere to HL7 standards to develop application interfaces to exchange patient data (Healthcare)

Confidential, Springfield IL

AWS/Azure Cloud Engineer

Responsibilities:

• Worked as a Azure cloud architect and for migration activities for data transfer/migration, storage and analytics. Responsible for ensuring that a quality, integrated software solution is delivered in a timely mannerat budget, and to our client's satisfaction. Azure Compute services, Storage services, Networking, Data Protection services, Governance, Control and Security services, Azure Monitoring, Integration, Cost Management services, Azure databases, Azure Synapse, Azure containers, DevOps, developer tools, migration, synapse, AI/ML, data lakes data factory, ADLS, ADFS, data pipelines, Analysis services, event Hubs, log analytics.
• Developed plugins and custom workflow activities consuming MS Dynamics CRM web services and using CRM SDK APIs
• Loaded data from Azure Data Lake Storage for Synapse SQL Data Warehouse environment
• 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
• Ingesting, Transforming and Transferring data into Azure Data Lake, Azure Synapse
• Picking the right AWS services for the application
• Worked with various Salesforce.com objects like Accounts, Contacts, Leads, Campaigns, Cases, Solutions, Forecasts, Reports, and Dashboards
• Managed AzureDataLakes (ADLS) andDataLake Analytics and an understanding of how to integrate with other Azure Services.
• 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.
• Integrated customer and commerce activities with Salesforce web services
• 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, North Carolina

Data Architect/Lead

Responsibilities:

• C# codes review for Consolidation Reporting Enterprise Stress Testing (CREST) Application
• System documentation
• SQL Performance tuning and Database Administration
• Worked on Azure data lake, Azure Synapse, data factory and experience working with structured/semi-structured/unstructured data into data lake. Azure virtual server, access control, synapse, data lakes, data store, pipelines, data migration, data conversion.
• 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, VA

Data Architect

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

Confidential

Senior Database/ Software Developer

Responsibilities:

• Responsible for implementation of MS SQL Server 2005 And SQL 2008 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
• Responsible for installation and Configuration of SQL/Oracle Server 2005 and 2008 database and configuration of Report Manager.
• Responsible for performing T-SQL / PL-SQL tuning and optimizing queries for reports, as well as Cubes and Data analysis.
• Responsible for downloading data from third party sources and then importing into database through SSIS and by writing scripts.
• Developed Database Backup Scripts and automated this process.
• Extract Transform Load (ETL) development using SQL Server 2005 Integration Services (SSIS).
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Programming in Microsoft VS.Net for certain global classes and knowledge base.
• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).
• Develop cubes using Qlikview 9 and Panorama BI.
• Created various complex reports like Form, Tabular, Drill Down, Drill Thru, Matrix and chart reports according to user specifications using SSRS. Created SSIS packages for ETL Process.
• Deployed the reports on SharePoint 2007 portal.
• Create and executed MDX Queries to extend the SQL Analysis Services (SSAS) OALP Cubes
• Created Indexes on tables for new database to faster retrieval for the Reports.
• Generated the various kinds of reports using List, Graphs and Images using SSRS
• Converted all existing DTS package old system to new system by adding extra SSIS task
• Views and Index Views are created to reduce database complexities for the Reports.
• Used Crystal Reports to generate ad-hoc reports.
• Involved in creating cubes in Business Intelligence Development Studio (BIDS), deploying them on the server and processing the OLAP cubes to generate aggregate data for faster querying.
• Used HEDIS to monitor and manage the performance measures of Health plans.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring in execution. Integrated Excel with SQL Server using VBA.
• DB2 9.5 replication/federation/data load/migration
• DB2 and Dbase index design, MQT, MDC and Partitioning
• Generated multidimensional reports from SSAS Cube.
• Created MDX Queries to retrieves results from the SSAS OLAP Cube.
• Involved in developing and modifying VB and XML reports for exporting the reports to web application. Used Web Services access the data from different environments.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet
• Implemented database versioning control using Visual Source Safe (VSS) for schemas and stored procedures changes.

Environment: MS SQL Server 2005/2008, SQL Reporting Services (SSRS), Oracle, SQL Integration Services (SSIS), MS SQL Server 2008, Web Services, XML, Java, Windows Server 2003, ADO.Net, C# .Net, MDX, Visual Source Safe (VSS), MS Access, ETL,Vb.Net, ASP.Net, SharePoint, CA Erwin Data Modeler 7.2 and SSAS, Qlikview.

Confidential

Senior SQL Server/Oracle Developer & BI Consultant

Responsibilities:

• Qlikview configuration on IIS webserver Access point, (Create local account on QVS machine, with local and QV admin rights - open ports 4747 & 4730 - Import Raw Data from Flat file to QV Tables - Asymmetric keys Management - Reports and Dashboard Management )
• Qlikview Solutions Development for Laboratory and HealthCare:
• Physician and Patient Analysis and Targeting (Analyze patient demographics and target your marketing efforts with insight into volumes of data that show market uptake potential for the therapies you offer - Track KPIs for the transition care process and identify readmission issues to make continuous improvements)
• Product and Portfolio Management (Drug portfolio analysis - Assessment and planning of new product development and acquisition - Company valuations and what-if? scenarios - Comparative and gap analysis - Business assessment and discovery, commercialization potentials - Intellectual property & patents analysis )
• Clinical Trial Management (Share-cross functional visibility with regulatory and drug safety organizations - Assess performance for trial sites and principal investigators (PI) - Manage multiple trials simultaneously and compare results across all of them - Streamline product approvals and accelerate clinical development Increase the speed and depth of analysis for large studies with very high data volumes - Identify the best trial sites and PI’s for your trials - Focus on projects that deliver highest value and best fit with corporate strategy - Reduce trial)
• Financial Management: Costing and Profitability (Better track asset depreciation, as well as expenses around travel and entertainment, legal and contractor services, telephony and mobile, etc.)
• Supply Chain and Supplier Relationship Management (Reduce operational costs and streamline processes - Measure and assess sourcing and supplier performance - Improve forecasting and planning for production & inventory - Provide multi-division and tiered analysis)
• Contract and Revenue Cycle Management (Negotiate better contracts with managed care organizations - Transform sales operations - Reduce operational costs and streamline processes - Manage better billing and collections for accounts receivable and track and uncover delinquencies)
• Manufacturing Intelligence and Optimization (Identify staffing and supply gaps, measure and trend production and capacity, and improve performance - Better monitor and schedule calibrations, cleanings, and in-house equipment audits)
• Created many complex Stored Procedures, Views, Indexes, Roles, and maintained database users.
• Weighbridge Application Development in C# for Raw Material Dispatch
• Developed different Scripts for the Data analysts for verification of reports.
• Integrated SAP ERP System with MS SQL via XML.
• Implemented MS SQL Server 2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
• Enhance the old Excel Reports to new SQL Server Reports fit new business requirement, and implemented them into SQL Server 2005 using SSRS.
• Participated in the migration of ODS from SQL Server 2000 to SQL Server 2005 and in converting DTS packages to SISS package.
• Responsible for performing T-SQL tuning and optimizing queries for reports, which take longer time in execution with SQL Server 2005.
• Involved in the troubleshooting of Database performance issues and implementing necessary DB changes. Designed and developed database application using VBA.
• Created and executed MDX Queries to extend the SQL Analysis Services (SSAS) OALP Cubes
• Created SSIS Packages to extract data from the DTR file format using ActiveX Script Task.
• Built efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports
• Generated various kinds of reports using List, Graphs, and Images using SSRS.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert.
• Modified the current database by removing unwanted columns and also adding proper constraints, rules and defaults to tables
• Created Indexes on tables for new database to faster retrieval for the Reports.
• Generated DTS packages to schedule migration for old system data to a new system and verify by making different reports on new system
• Converted all existing DTS package old system to new system by adding extra SSIS task
• Views and Index Views are created to reduce database complexities for the Reports.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring in execution
• Involved in building an extensive OLAP data warehouse on (SSAS) SQL Analysis services (Cubes, stars schema)
• Responsible for System Development Life Cycle (SDLC).

Environment: Microsoft SQL Server 2005, SQL 2003, SQL Reporting Services (SSRS), SQL Integration Services (SSIS), ASP.Net, SQL Analysis Services (SSAS), ETL,Qlikview, QSybase, C# .Net, SharePoint, ADO.Net, MS Access, Windows Server 2003, MDX, VBA, UML, AJAX

Confidential

Senior SQL Server/Oracle & Software Developer

Responsibilities:

• Qlikview development Training to Local employees (in South Africa).
• Created schema modification scripts to implement the logical design into SQL Server 2005
• Participated in the migration of ODS from SQL Server 2000 to SQL Server 2005 and in converting DTS packages to SISS package.
• Involved in the troubleshooting of Database performance issues and implementing necessary DB changes.
• Responsible for developing reporting stored procedures and ad hoc reports using Crystal Reports, as well as creating Test Cases, Test Plans and Release Notes.
• .Net Point of Sale development From Dbase and integration with SQL Server 2000, 2005.
• Wrote the embedded code using VB.Net for SQL Server Reporting Services (SSRS)
• Used MS SQL Server reporting services (SSRS) to use daily report basis with client-server application.
• Created various complex reports like Form, Tabular, Drill Down, Drill Thru, Matrix and chart reports according to user specifications using SSRS
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Create and executed MDX Queries to extend the SQL Analysis Services (SSAS) OALP Cubes
• Developed, tested and implemented robust Disaster Recovery Plan.
• Planning and scheduling backup strategy to ensure reliable backup.
• Developed DTS packages to load policy feeds onto ODS.
• Supported system wide replication tasks including monitoring and alerting. Provided problem resolution.
• Import Data from MS-Access Database and XML to SQL Server Database.
• Involved in building an extensive OLAP data warehouse on SQL Analysis services (Cubes, stars schema)

Environment: SQL Server 2000, SQL 2003, SQL Server 2005, AJAX, Qlikview, Management Studio, .Net 2.0 (ADO.Net, VB.Net), VBA, SSIS, SSRS, OLAP, MDX, MS Access, Dabase, XML, Java, FoxPro Crystal Report 10, Windows 2000/NT

Confidential

SQL Server Consultant

Responsibilities:

• Actively participated in gathering Business Requirements and System Development Life Cycle (SDLC).
• Interaction between Hardware Data and SQL Server Database 2000
• Converted complex business logic into SQL Stored Procedures and user-defined functions to achieve functionality required by business analysts and UI team.
• Actively involved in developing logical design of database, incorporating new business requirements, and implemented the new design into SQL Server 2000.
• Automated content loading via using portable DTS packages for repeated data loading for Quality assurance team replacing complex SQL scripts.
• Developed DTS packages to load onto ODS.
• Generated reports of transactions and services provided using SQL Server Reporting Services (SSRS).
• Wrote complex T-SQL statements to ensure data consistency by filtering corrupt data and implemented various constrains and triggers to preserve data integrity.
• Created indexed generic views to facilitate easy user interface implementation, security, and triggers on them to facilitate consistent data entry into the database.
• Automated mailing batch system using SQL-mail stored procedures.
• Performance testing and optimization of database, benchmarking and SQL Server Best Practice
• Used SQL Analyzer to find the bottlenecks in SQL code.

Environment: Windows server 2000/XP, MS SQL Server 2000, SQL 2003, Management Studio, Crystal Reports, Oracle 9i, MS Office Access 2003, Visual Studio.NET 2.0

Confidential

SQL Server / Oracle Developer

Responsibilities:

• Created Database objects including Tables, Triggers, Views, Stored Procedures, Data Modeling, Indexes and Rule.
• Set Database access privileges for different Users and User Groups.
• Performed optimization of SQL queries in SQL Server/Oracle/MySQL.
• Imported Data from MS-Access Database and XML to SQL Server Database.
• Maintained clustered and non-clustered Indexes.
• Created jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Created DTS Packages in SQL Server Database. Performed OCR Application Development.
• Monitored SQL Server activity through profiler.
• Developed backup & restore scripts for SQL Server as needed.
• Designed and implemented database maintenance plan
• Responsible for performance optimization and normalization of database, tuning and optimizing queries and indexes, Job, Scheduling, batch, alert and E-mail notification setting, and monitoring SQL Server log files.

Environment: SQL Server 2000, MS-Access,FoxPro, MySQL, XML, TSQL, Stored Procedures, Triggers, Views, Crystal Reports and Visual SourceSafe.

Confidential, SA

Database Developer and DBA

Responsibilities:

• Created Database objects including Tables, Triggers and Views.
• Set database access privileges for different users and user groups.
• Involved in programming module screens like Employee, Work Assignment etc.
• Monitored SQL Server activity through profiler. Query tuned and optimization through T SQL.
• Designed and implemented database maintenance plan.
• Provided performance optimization and normalization of database
• Designed database schema validation tool using stored procedures,
• Migrated data from Dbase, Text file to SQL Server through DTS
• Job, Scheduling, batch, alert and E-mail notification setting.
• Tuned and optimized queries and indexes.

Environment: Windows 2000 Advanced Server, SQL Server 2000, MySQL, Linux