Post Job Free

Resume

Sign in

Sql Server Data

Location:
Atlanta, GA
Posted:
November 10, 2017

Contact this candidate

Resume:

VINOD SINGH NEGI

Lead Consultant

ac28n0@r.postjobfree.com

678-***-****

SUMMARY:N

Having 14+ years’ experience in .Net framework (2.0/3.5/4.5) technology such as ASP.Net, C#,VB.Net,, WCF, Web service- REST, SOAP and WSDL, MVC framework 4/5, WPF, Component-based Scalable Logical Architecture (CSLA framework), MVVM Frame work, Prism, Rx, MS SQL server all version including 2012, MSBI-SSAS (SQL Server Analysis Service), SSIS (SQL Server Integration Service), SSRS (SQL Server Reporting Service), Master Data Services (MDS), Informatica-MDM,MS Access, Sybase, Oracle, Excel, Classic ASP, BI Semantic Model (BISM) 2012 which includes Tabular Model, Multi-dimensional Model, MDX, PowerPivot, DAX, PowerView, PerformancePoint SharePoint, Tableau, Yellow fin,MicroStrategy,Excel MS Access VBA Coding, SunGard Investran Hedge Fund domain,C,C++,Java SDK, Java SWT, PyCharm, Python, Django, Pyramid analytics, Microsoft Dynamics CRM, Salesforce CRM, Investran CRM, Big Data, Grunt, Bower, Node.js, backbone.js, Marionette.js, MVC, Web API, WCF services, Control models, DHTML,JavaScript, DOM, CSS,jQuery/AJAX,TCP/IP, LDAP, HTTP, PDF, FTP, SSH, File net,MQSeries, DTD,Active Directory,XSL,XML, Zurb Foundation.

TECHNICAL SKILLS:

Operating System : Windows NT, 95/98/2000/Me/2003/XP, DOS, Linux, UNIX.

Packages : M S Word, M S Excel, MS Access, MS PowerPoint, MS Paint. VBA Coding, Visual source safe, Enterprises library 3.0.

Front End : Visual Basic 6.0 with Crystal Reports and Active X, Visual C++ 6.0 with SDK and MFC,

Internal Technologies : Dot Net Frame work 2.0/3.5 (C#, ASP.Net, AJAX, ADO.Net, VB.Net, Web Services) and Java 2.0, HTML, JavaScript, SharePoint

Script : PowerShell Script, Perl script, VBA Script, VB.Net script, RX Extension, React.js, JavaScript, jQuery, Angular.js, node.js, Angular 2.js

RDBMS : SQL Server 2005/2008/2012, SQL Server Analysis Service (SSAS), SQL Server Integration Service (SSIS), ETL-Informatica, SQL Server Reporting Service (SSRS), Oracle, Sybase and MS Access,

Domain :Hedge funds, Credit funds, Banking, Finance and Insurance, technologies, Trading, HR, Transport, Ticket management system, HIPAA (Health Insurance Portability and Accountability Act) EDI (837,834,999, ETC),Investment banking, Federal Audit and reporting, Capital market- Stocks, Bond and Equity, Fixed Income Asset Management,complete SDLC Life Cycle.

Employment History

Employer

Designation

From - To Duration

Duration

Softpath System LLC

Lead Consultant

Feb 2014 to till date

3 years

Chetu Inc.

Technical Project Manager

May 2012 – Jan 2014

1 year 9 month

Syntel Consulting

Sr. Project Lead

June 2011 – May 2012

11 Months

Wipro Technologies

Sr. Software Engineer

Mar 2010 – June 2011

1 year 4 month

IBM

Tech Lead

Feb 2005 – Mar 2010

5 years 1 month

Trinity BPM Pvt Ltd

Associate Analyst

Dec 2003 – Feb 2005

1 year 2 month

PROFFESIONAL EXPERIENCE:

Client: Serta Simmons Bedding, Atlanta GA 01/2017 – Till Date

Lead Consultant

Project description:

I am currently working with client Serta Simmons Bedding,

Where I worked on designing and developing of web interface in Asp.net, Angular.js, VB.Net, WPF with C#, MVC framework, integrated with web services where data source is entriprise data warehouse, it includes all transaction for Order, Invoice, Shipping, Order cancellation, managing the returns products, profitability management.

Developed the various modules like order management, invoice management, shipping management, order cancelation for finish good, return goods modules and vendor management.

Impemented the MVC framework where developed the model, view and controller classes from skretch. Refactoring the existing code and improved the code standardization and sepeation of duty for each entity.we have developed the staging table. Written complex SQL Store procedure and function plus database design.

Responsibilities:

Analyzed the clients business requirements and translating them into the high and low level design and implementation for all end to end BI/Data Warehousing solutions

Developed .Net applications and SQL Server Database in Windows Azure.Developed Azure Web Roles, Web API & Worker Roles (C#) using ASP.Net MVC5.

Worked on Web and Windows application like .NET Framework 4.5, ASP.Net, C#, VB.Net, Web Forms, Win Forms,WPF, XML, HTML5, CSS, Angular 2.js, ADO.NET, JQuery, JSON, Web API and JavaScript, LINQ, Entity Frame Work,, IIS, HTTML 5, CSS3, Java Script, Visual Studio.Net 2015, AJAX, TFS, POWERSHELL, VBScript,RESTful APIs .

Worked on migration of existing VB 6.0 application to C# .Net Application.

Understanding o CSS pre-processing platforms such as SASS and LESS.

Developed new .NET Web and Window applications, Window Services and Win Forms, Angular.js, RESTful APIs,

Troubleshoot, analyze, program, and implement modifications to existing VB.Net Application.

Designed and developed the DevExpress reports and dashboard, along with create a web application in asp.net using the DevExpress controls. Worked on Electronic Data Interchange (EDI) data exchange where developed the system to process the business documents in a standard electronic format between various business partners.

The various EDI exchange documents were purchase order, invoices, shipping notices, return order document and others.

Worked on creating complex business rules in SQL for Order life cycle which includes placing the order, invoicing, shipping the finish good, order return and show profitability reports via data warehouse.

Implemented the multithreading concept in project which includes creating and invoking a Threadm,Synchronization primitives,Thread safety

Worked on Asynchronous programming and Parallel programming using the Task Parellel Libraries

Developed the SQL server 2012 database, develop the database and DataMart in it. Written complex store procedure, functions (UDF), triggers in SQL Server.

Desinged and developed the tables, databases, forms, and reports using the oracle 11g.

Helped design custom data models that integrated with Oracle Applications.

Worked on performance optimization of SQL database, SSAS Cube, SSIS packages and SSRS/Tableau reports.

Worked on exception capturing and auditing the entire system.

Worked on Data modelling, SSAS – multidimensional and SSAS-Tabular.

Worked on Saas/CSS and Angular 1.5 for front end UI design

Worked on GitHub/GitLab for version control

Bank of Montreal (BMO) - Capital Market, NY 06/2016 – 09/2016

Lead Consultant (etrading and equity)

Project Description: Worked on reconciliation of financial equity sensitivities with is based on different product and category, the data source was IBM Netezza and Oracle, the job was to extract, transform and load the information into SQL Server with the help of ETL Tool-SSIS and complex SQL Server stored procedure.

Where we have created the UI in Asp.net, VB.Net,Angular 2.js, Html5, JQuery, JavaScript,C#,VB.Net,React.js, Bower, Saas/CSS,

Integrated it with WCF Services and Web API, in case there is discrepancy in data from different source then update their status as not matching for that business date and send auto mail to client. This web application was accessible by business users, BMO management and clients.

Responsibilities:

Worked as Full Stack lead developer, right from front end to back end coding and database design and deployment.

Developer windows and Web application in .NET Framework 4.5) ASP.Net,C#, VB.Net, Web Forms, Win Forms,WPF, XML, XSL, HTML5, CSS, Angular.js, ADO.NET, JQuery, JSON, Razor, MVC Architectural patterns, Test Driven Development (TDD), Nunit testing.

Worked on UI design using the React.js and Bower.

Designed and developed business applications where the fron end was ASP.NET and page behind coding was in VB.Net and the IDE used is Microsoft Visual Studio. Here we have used the MVC Framework having the Model, View and Controller.

Integrated the DevExpress controls in asp.net web page.

Worked on ASMX, WCF Web Services and ADO.NET. With n-tier architecture (User Interface, Business Logic Layer, Data Access Layer), along with Service-oriented architecture (SOA), MVC frame work, WCF Services, Active Directory.

Unstanding of Zurb Foundation and implemented it in POC projects.

Worked on DTD using th XML and HTML files, design the HTML and loaded data from xml file.

Worked on Messaging Queue (MQSeries) from message processing and processing them in queue fashion.

Analyzed the clients business requirements and translating them into the high and low level design and implementation for all end to end BI/Data Warehousing solutions

Developed complex business reports in Jasper Tool.

Worked on Sensitivity Reconciliation, ETL the data from various data source like Oracle and Netezza

Develop various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports, Workflow Builder, and Application Object Library.

Migrated the production database into Window Azure enviornement.

Deployed the .Net application from UAT to Azure environment.

Used the Oracle database for accounts payable/accounts receivable (AP/AR), general ledger, fixed assets, and cash management, supporting data extraction, filtering, and validation.

Worked on creating the data model using the Oracle database as data source.

Write technical design documents for conversions, extensions, best practices, interfaces, and reports.

Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.

Details understanding of the system and write complex store procedure in SQL Server 2012, Oracle and IBM Netezza.

Worked on exception capturing and auditing the entire system, plus manual and unit testing the application.

Implemented SSIS- DQS performance improvement techniques, worked extensively on Oracle and IBM netezza.

Developed Tableau BI application, Reports and Dashboard with server side functionalities

Worked on Data modelling, SSAS – multidimensional and SSAS-Tabular.

Worked on SSRS, Tableau dashboard and reporting.

Worked on Client-Side Testing – using tools like Jasmine, Cucumber, VB Script and manual testing.

Worked on No SQL Mango-DB.

Worked on Primavera Enterprise Project Portfolio Management tools for effectivity collaboration and successful project delivery.

ROYAL BANK OF CANADA- Capital Market, NY 02/2016 – 05/2016

Lead Consultant (etrading, equity and stock)

Project Description: Worked on equity and fixed income capital market based on different product, category, subcategory, multiple transaction, salespersons. Worked on creating the UI in asp.net, javascript.js, react.js, angular.js, html5 and CSS. Implemented the MVC framework and integrated it with WCF Services and Web APIs.

Create the different roles and provide the permission based on different legal entities. Implemented the component base approach for audit logging, exception handling, data access and security handling.

This web application was accessible by business users, RBC management and clients.

Responsibilities:

Analyzed the client’s business requirements and translating them into the high and low level design and implementation for all end to end BI/Data Warehousing solutions.

Worked as Full Stack lead developer, right from front end to back end coding and database design and deployment.

Developer windows and Web application in .NET Framework 4.5,ASP.Net,C#, VB.Net, Web Forms, Win Forms,WPF, XML, HTML5, CSS, Angular.js, ADO.NET, JQuery, JSON, VBScript, WEB CONTENT ACCESSIBILITY GUIDELINES (WCAG)

Worked on exchange-traded fund (ETF) investment fund traded on Stock,Commodies and bonds. Knoweldge about Trades close to its net asset values over the course of trading day, implemented the code of EFTstack as index such as stock index or bond index.

Worked as Full Stack lead developer, right from front end to back end coding and database design and deployment.

Worked on UI presentation layer with WPF, Java Script, and JQuery using the DevExpress and ASP.Net controls.

Worked on Fixed income and Equities Asset management. Worked on project which includes interest payment, coupon rate in fixed income bonds. It also included the profilio management.

Implemented the Window Forms using the DevExpress controls.

Worked on multithreading and collection in C#.

Created applications using MVC 4.0., MQSeries and DTD

Experience with SOAP, RESTful services and WSDL.

Implemented the Security in EDI Data Exchange transaction which includes the various roles and user management.

Experience in design and development using SOA (Service Oriented Architecture).

Hands on experience in design using Object Oriented Programming Principles like Encapsulation, Inheritance, Polymorphism, Abstraction and Design patterns like MVVM, Abstract factory, Singleton, MVC, MVP, Composite, Command, State and Builder.

Proficient in Implementing WCF services and consuming using different protocols and implementing features like Security, Debugging and Performance, plus manual and unit testing the application.

Experience in using RUP (Rational Unified Processing), Agile Scrum and UML for designing Applications (Activity, Class, Sequence and Collaboration Diagrams)

Highly Knowledgeable in ASP.NET MVC 4.0 in implementing Model, View and Controllers with State Management, Security, Action methods etc.

Developed Tableau Reports and Dashboard where we have used the Big Data as Data source, connected to Big Data and created the graphs and chart based Equality Domain.

Implemented the Microsoft Application building blocks for .Net projects (Data Access, Exception Handling, Caching and Configuration Management Application Blocks).

Implemented the Data model in power pivot, SSAS Multi-Dimensional and Tabular model for client’s data ware house project.

Developed Data ware house SSAS Application which includes creating cubes, Design XMLA Scripts to create partition, processing of the measure groups and Dimensions. Scheduling the SSAS Objects

Develop Cubes, Dimensions, Hierarchies, Calculations, Aggregations, Security Profiles, Mining Models, Perspective and other features of SSAS OLAP environment that meet the requirements of business.

Designing database, stored procedures, views and function using MS SQL Server Management Studio 2012 and Oracle.

Implemented project/release/enhancement processes by developing data integration, data transformation/aggregation and reports using SSAS, SSRS, SSIS, PowerPivot and SharePoint Business Intelligence tools and all subsequent technical documentation

Implemented BI Semantic Model (BISM) which includes Tabular Model, Multi-dimensional Model, MDX, PowerPivot, DAX, Power View, PerformancePoint SharePoint

Use versioning source safe -SVN Tortoise.

Writing the DAX and MDX Queries

Worked on Client-Side Testing – using tools like Jasmine, Cucumber, VB Script, NUnit and Manual testing

MINDSHARE, New York 04/2015 - 01/2016

.Net / SQL Server Developer Consultant

Responsibilities:

Experience with .Net Framework 4.5 (ASP.Net,C#,VB.Net), Web Service, WCF,WPF, ADO.Net, WPF,AJAX, Design Patterns, Java Script, Web part, Windows communication foundation (WCF), MVC Framework, Component-based Scalable Logical Architecture (CSLA framework),REST Services,.Net libraries, XML, XSLT, SOAP, Reactive Extension (RX), Marionette.js, RESTful APIs, Data Streaming, TFS, POWERSHELL, BUILD AUTOMATION, MQSeries, DTD.

Exposure to popular JavaScript libraries. (for example - JQuery, React.js, Backbone.js)

Worked on ASMX, WCF Web Services and ADO.NET. With n-tier architecture (User Interface, Business Logic Layer, Data Access Layer), along with Service-oriented architecture (SOA).

Worked on UI designing with WPF, Java Script, JQuery using the DevExpress and ASP.Net controls, Reactive Extension (RX).Worked on multithreading and collection in C#,FileNet.

Worked on Mobile platoform and developed the Apps using the Visual Studio Tooling for Apache Cordova and integrated with Web API’s.

For versioning control, worked on GitHub/GitLab tool.

Experience with asynchronous programming on the web using RESTful interfaces

Worked on migrating of mainframe database into SQL Server, In addition created the complex stored procedure, trigger and function in SQL Server.

Worked on migrating the mainframe screen into ASP.Net web pages, WEB CONTENT ACCESSIBILITY GUIDELINES (WCAG),WPF windows screen, in addition used the JavaScript, jQuery and angular.js, plus manual and unit testing the application.

Implement the Data model (power pivot, SSAS Tabular model) for client’s data ware house project.

Prepared the Data source, dashboard and reports in Tableau, better transparency and reporting, as well as customizable interfaces for flexible delivery of information to internal and external shareholders.

Developed Data ware house SSAS Application which includes creating cubes, Design XMLA Scripts to create partition, processing of the measure groups and Dimensions. Scheduling the SSAS Objects

Working on preparing SSRS reports using SQL Server BI Development Studio and implement on website.

Designing database, stored procedures, views and function using MS SQL Server Management Studio 2012.

Worked with Primavera Enterprise Project Portfolio Management tools for project management and delivery in phases.

Worked on the project with Database as MongoDB,with includes the client sensitive data.

Implemented BI Semantic Model (BISM) which includes Tabular Model, Multi-dimensional Model, MDX, PowerPivot, DAX, Power View, PerformancePoint SharePoint

Worked on PowerPivot, Power View and Crystal report.

Developed software application for the business unit based on .net framework (4.0/4.5) technology

Using visual studio 2012 and SQL Server 2012.

Designing database in SQL Server 2012 (i.e. create store procedure, trigger, view-queries, Functions, Database design and maintenance, Performance tuning) and IBM Netezza.

Strong understanding of object-oriented programming and skilled in writing reusable C# libraries

Work on SQL Server Integration service (SSIS)/ETL/ (SQL Server Analysis Services (SSAS) in SQL Server 2012.

Understand and familiar with Big Data Hadoop, NoSQL-mongo db.

Install, configure and maintain SQL server databases

Perform database, cube backups and refreshes.

Writing the DAX and MDX Queries

Worked on Angular.js, Node.js and

Worked on Client-Side Testing – using VB Script, NUnit and Manual testing

FORTRESS INVESTMENT GROUP, NY 09/2014 - 03/2015

Lead consultant

Responsibilities:

Worked as SQL Server 2012, Oracle and .Net, C#, TFS, MQSeries, DTD, Test Driven Development (TDD), Nunit testing,POWERSHELL,VBScript, and BUILD AUTOMATION Sr. Developer for Fortress investment group a Hedge Fund domain company.

Worked on Fixed income, Equity Asset Management Domain.

Management the profilio of various Fixed income investor typically retired person who reply on their investment to provide a regular, stable income stream. Fixed income offeres the reliable returns.

Worked on fixed-income security called Bond. Handle the databases on fixed income wherd the bonds are issues by federal govement, local municipalities and major corporation. The diversify the fixed income componets of a profilio. The proflio might include investment grade bongs, treasury, international bonds and high yield bonds.

Worked on project which includes interest payment and coupon rate in fixed income bonds.

Worked on Investran Version 6.3, and tool for Hedge fund and credit funds business, which includes Data Exchange and Insight tools for better transparency and reporting, as well as customizable interfaces for flexible delivery of information to internal and external shareholders

Worked on Investran which I interacted with automated front-, middle- and back-office processes for private equity and hedge funds firms, including general partners, limited partners, service providers, fund of funds and family offices. Handling Investran accounting, relationship management and partnership accounting functionality.

Implemented complex features available in Investran like, Active Templates, Business Events, Look Through reporting and Allocation rules. Worked on Investran modules like CRM, Report Wizard and Accounting.

Worked on creating Custom report in Investran for Private Equity Accounting Solution

Its includes all major Financial Reporting like

oBalance Sheets

oIncome Statement

oFund Performance Reports

oStatement of Operation

Developed the reports using the Investran report wizard.

Created the investran OLEDB connection and integrated the report with SSRS, Tableau, Excel, ASP.Net report controls.

Customized the SunGard Investran Database and connected the reporting solution like SSRS, SSIS, ASP.Net, C#, WPF, react.js, Sitecore 8.0 with database directly.

Analyzed and Develop the Data Model and architect the Data ware house.

Worked on MVC,MVVM architecture, Component-based Scalable Logical Architecture (CSLA framework) RESTful APIs

Worked with Cleint management on Primavera Enterprise Project Portfolio Management tools for project planning.

Worked as investran custom application developer, where I need to work on SQL and C# code to overcome the limitation of investran.

Worked on C# Collection like Generic collections, delegates, and interfaces, generic and non-generic hash-based dictionary types, stacks, queues, lists, arrays, and dictionaries.

Understand the Hedge funds domain and convert the client’s business requirement into technical

Business Requirement gathering, analysis & re-engineering Conceptualize high-level architectural framework (BI Services). Daily client interaction and analysis, design, implementation, testing and deploying the applications.

Acting as a technical lead/ architect for the project.

Working on preparing SSRS reports using SQL Server BI Development Studio and implement on website.

Designing database, stored procedures, views and function using MS SQL Server Management Studio 2012.

Worked on business domains involved for the reports and tools development are Financial Planning & Analysis, Data Quality, Chassis Tracking and Data Asset management in the Hedge Fund industry.

Maintained services hosted in Windows Azure.

Observe server side and Regression testing, Unit testing and provide Support in maintenance.

Mentor and develop software application in SQL Server 2012 and MSBI (SSIS, SSAS, and SSRS 2008/2012).

Worked on Oracle database, oracle packages and store procedure, performance optimization.

Communicates and enforces coding standards

Implemented agile development methodologies and used JIRA software for issue and project tracking.

Implemented BI Semantic Model (BISM) which includes Tabular Model, Multi-dimensional Model, MDX, PowerPivot, DAX, Power View, PerformancePoint SharePoint

Worked on PowerPivot, Power View and crystal report.

Develop and Deploy the Tableau reports and dashboard.

Expert in PyCharm, Python, Django and worked on Python web framework Django

Worked on Integration of data storage solutions in python.

Worked on angular.js and Node.js.

THINK FINANCE, Fort Worth –Texas 02/2014 - 07/2014

Lead Software Consultant

Responsibilities:

Business Requirement gathering, analysis & re-engineering Conceptualize high-level architectural framework (BI Services). Daily client interaction and analysis, design, implementation, testing and deploying the applications.

Performing Advanced cube calculations using MDX,

Worked on VB.Net and C# coding for developing the Windows and Web application.

Worked on fixed income and equity management accounting domain.

ETL design and implementation techniques for Dimensional Data Warehouses, Creating the SSIS Package for ETL, SSAS Processing and Other activities

Provides technical direction for development, design, and systems integration for client engagement from definition phase through implementation.

Applies significant knowledge of industry trends and developments to improve service to our clients.

Mentor and develop software application in .net framework (2.0/3.5/4.5) technology such as ASP.net, C#,react.js,SQL Server 2008R2,C#, WCF, MVC framework 4/5,Yellow Fin and MSBI (SSIS,SSAS,SSRS 2005/2008/2012),C++, TFS, POWERSHELL, BUILD AUTOMATION, MQSeries, DTD,Jasper reports,VBScript, WEB CONTENT ACCESSIBILITY GUIDELINES (WCAG).

Worked with Microsoft Azure and Service Bus for Windows.

Worked on Cross-Platform Mobile Development with Apache Cordova where we have deployed the UI and integrated with Web API’s

Perform the Data mapping and create Reconciliation reports.

Create the automate batch processing scripts

Communicates and enforces coding standards

Worked on Oracle database, oracle packages and store procedure, performance optimization.

Developed and maintained scripts in Perl

Worked on Power BI (PowerPivot,Power View, Power Maps) and Tableau

Worked on UI presentation layer with WPF, Java Script, JQuery using the Devexpress, ASP.Net controls, Angular.js, Node.js, backbone.js, Marionette.js, RESTful APIs, Reactive Extension (RX).

Worked on DevExpress Controls and Dundas data visualization components.

Developed the ASP.Net Web forms with C#, VB.Net coding and WCF Services, where we have consumed the investran services, worked on data streaming.

Developed the reports using the Investran report wizard.

Created the investran OLEDB connection and integrated the report with SSRS, Tableau, Excel, ASP.Net report controls.

Customized the SunGard Investran Database and connected the reporting solution like SSRS, SSIS, ASP.Net, C# with database directly.

In Investran, used the Active Templates, Business Events, Look Through reporting and Allocation rules.

Worked with IBM mainframe sources (Flat files, DB2, Oracle) as source and according created the SSIS package.

Designed and developed applications health monitoring website using ASP.NET, JavaScript, Ajax and Dundas charts.

Developed automated index validation service using C#, PowerShell and SQL Server to maintain data integrity and to eliminate information risk.

Wrote server-side business logic, services and entities using C#.

Involved in developing the WCF, Web services and integrating with different applications.

Engineered end-end SQL Server solution platform for a very large multi-node database size (12.5 TB per node) and successfully completed production implementation.

CHETU INC. Dallas, TX 05/2012 - 02/2014

Technical Project Manager/Project Architect

Responsibilities:

Provides technical direction for development, design, and systems integration for client engagement from definition phase through implementation.

Deveoped the Windows and Web application in VB.Net, integrated with WCF Services, Devoped the WCF Services from starting and later integrated it with windows and Web application.

Worked on migrating of mainframe database into SQL Server, In addition created the complex stored procedure, trigger and function in SQL Server.

Worked on NetBeans and Eclipse editor for developing the Angular.js, Javascript, JQuery and Java code .

worked on migrating the mainframe screen into ASP.Net web pages, WPF windows screen, in addition used the JavaScript, jQuery,VBScript, angular.js, WEB CONTENT ACCESSIBILITY GUIDELINES (WCAG)

Implemented the Windows forms with DevExpress controls and reports controls in MVC Framework.

Worked on entity framework, MVC framework to implement the business logic and database communication.

Worked on Worker compensation domain for state of New York, New Jersey and Utah.

Worked on auto clearing house domain for client ACH Processing.

Applies significant knowledge of industry trends and developments to improve service to our clients.

Reviews work of development team.

Worked on database design and development, writing complex function and procedure in IBM Netezza.

Easily recognizes system deficiencies and implements effective solutions.

Communicates and enforces coding standards

Developed Data ware house SSAS Application which includes creating cubes, measure group, dimension, Design XMLA Scripts to create partition, processing of the measure groups and Dimensions. Scheduling the SSAS Objects.

Created the Data model and Summary layer model for various Project.

Implementation and Deployment of SSAS Cubes.

Mentor and develop software application in .net framework (2.0/3.5/4.5) technology such as ASP.net, C# and SQL Server 2008R2, WCF, MVC framework 4/5, TFS, POWERSHELL, BUILD AUTOMATION plus manual and unit testing the application.

Created and Modified the Reports using the SSRS with help of MDX queries.

Business Requirement gathering, analysis & re-engineering Conceptualize high-level architectural framework (BI Services). Daily client interaction and analysis, design, implementation, testing and deploying the applications.

Performing Advanced cube calculations using MDX,

ETL design and implementation techniques for Dimensional Data Warehouses, Creating the SSIS Package for ETL, SSAS Processing and Other activities

Database Design (Conceptual, logical and physical), Dimensional Data Models and Slowly Changing Dimensions.

Worked on DevExpress Controls and Dundas data visualization components.

Perform the Data mapping and create Reconciliation reports.

Configure SQL Databases in Azure for security and development deployment

Create and access Containers from .NET/C# using Azure SDK 2.8 to access Blog storage for image and video

Create/Manage and install Certificates to allow developers to connect VS2012 to Azure subscription

Developed feature using Azure API to manage Azure workloads from the portal.

Create the automate batch processing scripts

Worked with Tableau, PowerPivot, Power View

Worked on MVVM, Prism, Rx

ETL maps, Metadata, ODS, Staging area design, OLAP / Cubes, Design data marts layer (business semantic) and reporting layer (Reports



Contact this candidate