PROFESSIONAL SUMMARY:

Having 12+ years’ experience in SQL server all version including 2012, MSBI - SSAS (SQL Server Analysis Service), SSIS (SQL Server Integration Service), SSRS (SQL Server Reporting Service), .net framework (2.0/3.5/4.5) technology such as ASP.net, C# and SQL Server 2008R2, WCF, Web service- REST, SOAP and WSDL, MVC framework 4/5, Component-based Scalable Logical Architecture (CSLA framework), MVVM Frame work, Prism, Rx, 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,Python.

AIM:

To work with a reputed company where I can use my skill set and which has prospects for growth.

TECHNICAL SKILLS:

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

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 MFCInternal 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

RDBMS: SQL Server 2005/2008/2012 , SQL Server Analysis Service (SSAS), SQL Server Integration Service (SSIS), 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 EDI (837,834,999, ETC)

PROFFESIONAL EXPERIENCE:

Confidential, New York

Sr. Software Consultant

Responsibilities:

• Experience with .Net Framework 4.5 (ASP.Net,C#,VB.Net), Web Service, WCF, ADO.Net, AJAX, Design Patterns, Java Script, Web part, Windows communication foundation (WCF), MVC Framework, Component-based Scalable Logical Architecture (CSLA framework),REST Services,.Netlibraries, XML, XSLT, SOAP and Google Material Design etc.
• Exposure to popular JavaScript libraries. (for example - AngularJS, JQuery, React, Backbone.js)
• Worked on ASMX, WCF Web Services andADO.NET . with n-tier archietecure (User Interface, Business Logic Layer, Data Access Layer), along with Service-oriented architecture (SOA).
• Experience with asynchronous programming on the web using RESTful interfaces
• Implement the Data model (power pivot, SSAS Tablular model) for client’s dataware house project.
• Prepared the Datasource, 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.
• Analyzed and Develop the Data Model.
• Developed the Yellowfin reporting system from scratch, create the data view, dimensional model, report, dashboard and storyboard in yellowfin.
• Implemented BI Semantic Model (BISM) which includes Tabular Model, Multi-dimensional Model, MDX, PowerPivot, DAX, PowerView, PerformancePoint SharePoint
• Worked on PowerPivot, PowerView and Crystal report.
• Developed software application for the business unit based on .net framework (4.0/4.5) technology
• Using visual stuidio 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).
• Design, code and test new Windows and web software applications
• Enhance existing systems by analyzing business objectives, preparing an action plan and identifying areas for modification and improvement
• Create technical specifications and test plans
• Proficient in C#, with a good knowledge of its ecosystems and worked on .NET framework 2.0/3.0/3.5/4.0/4.5.
• Strong understanding of object-oriented programming and skilled in writing reusable C# libraries
• Worked on various design and architectural patterns in .Net
• Developed from scratch and enhanced existing systems by analyzing business objectives, preparing an action plan and identifying areas for modification and improvement
• Use Enterprise Library, Visual Source Safe (VSS)/SVN Tortoise/TFS 2013/Git.
• Worked on agile process to develop software. Experience with SCRUM and its variants.
• Work on SQL Server Integration service(SSIS)/ETL/(SQL Server Analysis Services(SSAS) in SQL Server 2012.
• Implemented the Google Material Design.
• Understand and familiar with BigData Hadoop, NoSQL.
• Install, configure and maintain SQL server databases
• Perform database,cube backups and refreshes.
• Writing the DAX and MDX Queries
• Creating Reports based on SQL Server reporting services(SSRS).
• Develop and Deploy the Tableau reports and dashboard.
• Worked on Webfocus - dashboards development and transaction enabled dashboards development
• Worked on Webfocus performance tuning reports and schema objects for optimal performance.
• Design and implementation of low-latency, high-availability, and performant applications in Python.
• Integration of user-facing elements developed by front-end developers with server side logic in python and implement security and data protection
• Expert in Python, with knowledge of at least one Python web frameworkDjango
• Worked on Integration of data storage solutions in phython.

Confidential, New York

Software Consultant

Responsibilities:

• Worked as SQL Server 2012 Sr. Developer for Confidential a Hedge Fund domain company.
• 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
• 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 Sunguard Investran Databae and connected the reporting solution like SSRS, SSIS, ASP.Net,C# with database directly.
• Analyzed and Develop the Data Model and architect the Dataware house.
• Worked on MVC,MVVM architecture, Component-based Scalable Logical Architecture (CSLA framework)
• Worked as investran custom application developer, where I need to work on SQL and C# code to overcome the limitation of investran.
• Implemented data model designs and rules that align data across organization by definition, timing, level of granularity, calculation method and valuation. Data sources are identified based on the stage of the process life cycle. define business rules that will be used to measure data quality and integrity, and worked with Business analyst/Business Users to identify and assign the appropriate data stewards within client’s organization.
• Implemented the Google Material Design.
• 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 WebFocus, created dynamic, fast-paced transaction-intensive environment and developed tools and reports
• Worked in WebFocus involved in all aspects of the report development, including, gathering business requirements, analysis, develop prototypes, data-mart design, reports design & development and production support.
• Worked on client and offshore team on WebFocus and provide the desire output.
• 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 transportation industry.
• Worked with Microsoft Azure and Service Bus for Windows.
• Responsible for providing extensive support to offshore team and debugging of the application.
• 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, SSRS 2008/2012).
• Worked on Oracle database, orace 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, PowerView, PerformancePoint SharePoint
• Worked on PowerPivot, PowerView and crystal report.
• Develop and Deploy the Tableau reports and dashboard.
• Expert in Python, with knowledge of at least one Python web frameworkDjango
• Worked on Integration of data storage solutions in phython.
• Worked with Confidential mainframe sources (Flat files, DB2, Oracle, MySQL) as source and according created the SSIS package.
• Implemented the project using Java SDK, Java SWT.
• Worked extensively on Master Data Services features including hierarchies, granular security, transactions, data versioning, and business rules.
• Perform the Data mapping and create Reconciliation reports.
• Create the automate batch processing scripts
• 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, SOAP and Google Material Design etc.
• Worked on DevExpress Controls and Dundas data visualization components.
• Communicates and enforces coding standards.

Confidential, Fort Worth, Texas

Lead Software developer/ Data warehousing Specialist

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,
• 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# and SQL Server 2008R2, WCF, MVC framework 4/5,Yellow Fin and MSBI (SSIS,SSAS,SSRS 2005/2008/2012 )
• Worked with Microsoft Azure and Service Bus for Windows.
• Perform the Data mapping and create Reconciliation reports.
• Create the automate batch processing scripts
• Communicates and enforces coding standards
• Worked on Oracle database, orace packages and store procedure, performance optimization.
• Developed and maintained scripts in Perl
• PowerPivot
• PowerView
• Tableau
• Worked on DevExpress Controls and Dundas data visualization components.
• Developed the ASP.Net Web forms with C# coding and WCF Services, where we have consumed the investran services.
• 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 Sunguard 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 Confidential mainframe sources (Flat files, DB2, Oracle) as source and according created the SSIS package.
• 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.
• 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.

Confidential, Dallas, TX

Technical Project Manager/Project Architect

Responsibilities:

• 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.
• Reviews work of development team.
• 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.
• 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, PowerView
• Worked on MVVM, Prism, Rx
• ETL maps, Metadata, ODS, Staging area design, OLAP / Cubes, Design data marts layer (business semantic) and reporting layer (Reports Hierarchy, drill-downs).
• Design database in SQL Server 2005/2008 and Oracle 11i Query optimization and indexing strategies
• Installation of SQL Server 2008, visual studio 2008/2010, Oracle, BIDS
• Handling a team and motivating them.
• 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.

Confidential

Senior Project Lead

Responsibilities:

• 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 CDS Project.
• Implementation and Deployment of SSAS Cubes.
• Developed software application in .net framework (2.0/3.5) technology such as ASP.net, C# and SQL Server 2005, WCF.
• 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.
• ETL maps, Metadata, ODS, Staging area design, OLAP / Cubes, Design data marts layer (business semantic) and reporting layer (Reports Hierarchy, drill-downs).
• Worked on DB2 database, orace packages and store procedure, performance optimization.
• Design database in SQL Server 2005/2008 and Oracle 11i
• Query optimization and indexing strategies
• Implemented the project using Java SDK, Java SWT.
• Worked with Tableau, PowerPivot, PowerView
• Installation of SQL Server 2008, visual studio 2008/2010, Oracle, BIDS
• Handling a team and motivating them.
• Create dimensional data model and cube in SQL Server Analysis Services (SSAS).
• Implementation of SQL Server Analysis Services (“SSAS”) to enable key performance indicator(“KPIs”), Pivot tables etc for multi-dimensional analytic capability.
• Integration of SSAS with SharePoint portal.
• Involve in preparing various technical design document (technical design document, Functional design and release document) and test cases.
• Technical and functional consulting
• System study, determination and Implementation of GAP points
• Co-ordination with client to in corporate new and existing requirement.
• Writing MDX queries to run reports on SSAS cube.
• Create calculated members, Actions, KPI’s and perspectives in SSAS.
• Implement security in analysis Service object and Data.
• Worked with Tableau, PowerPivot, PowerView
• Perform User acceptance test (UAT) and deployment of SSAS solution.
• Perform the Data mapping and create Reconciliation reports.
• Create the automate batch processing scripts
• Design and develop DB2 database and its store procedure and worked on performance optimization.

Confidential

Tech Lead / Sr. Software Developer

Responsibilities:

• Developed software application in .net framework (2.0/3.5) technology such as ASP.net, C# and SQL Server 2005, WCF.
• Worked in Data ware house project where I have to use create ETL package using the SSIS package.
• 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
• Created and Modified the Reports using the SSRS with help of MDX queries
• Handling a team and motivating them.
• Perform the Data mapping and create Reconciliation reports.
• Create the automate batch processing scripts
• Daily client interaction and analysis, design, implementation, testing and deploying the applications.

Confidential

Lead- Software developer

Responsibilities:

• Developed software application for the business unit based on .net framework (2.0/3.5) technology such as ASP.net, C# and SQL Server 2005.
• Designing database in SQL Server 2005 (i.e. create store procedure, trigger, view-queries, Functions, Database design and maintenance)
• Experience with Web Service, ADO.Net, AJAX, Design Patterns, Java Script, Web part, Windows communication foundation (WCF), XML etc.
• Use Enterprise Library and Visual Source Safe
• Work on DTS / SQL Server Integration service(SSIS)/ETL/(SQL Server Analysis Services(SSAS) in SQL Server 2005
• Install, configure and maintain SQL server databases
• Perform database backups and refreshes
• Creating Reports based on SQL Server reporting services(SSRS)
• Designing database in SQL Server 2005 (i.e. create store procedure, trigger, view-queries, Functions, Database design and maintenance)
• Developed and maintained scripts in Perl
• Creating OLAP (Online Analysis Processing) in SQL server 2005 with SSRS and SSIS.
• Testing application: Creating test case and debug the application, worked on validation of controls.
• Create portal in Sharepoint.
• Document the application as per CMMI Level 5 standards.
• Develop a Client Services application to manage Client Services function within a large enterprise
• Design, development, testing of .NET based applications
• Standalone and web application GUI development experience
• Good communication & Interpersonal skills and the ability to work in a team environment.
• Prepare and send timely and accurate MIS Reports to the Client end & Management.
• Analyze the Report and prepare presentation for top-level management.
• Worked on Avaya 11.0, Avaya 12.0, Avaya R13 to extract different report for different LOB (line of business).
• Good understanding of banking, financial and insurance sector.

Confidential

Associate Analyst

Responsibilities:

• Design and Maintain database in SQL Server 2000
• Write Store Procedure, Functions and triggers.
• Design and generate reports as per company and client requirement.