SUMMARY:

• Having 13 years experience in SQL server all version including 2012,2014, 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, Pyramid analytics, BO, OBIEE, SAS

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, Capital Market, NY

Sr. Consultant

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
• Worked on Sensitivity Reconcilation, ETL the data from various datasource like Oracle and Netezza
• 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.
• Implemented SSIS- DQS performance improvement techniques.
• Developed Tableau BI application, Reports and Dashboard with server side functionalities
• Worked on Data modelling, SSAS - multidimensional and SSAS-Tabular.
• Implemented BI Semantic Model (BISM) which includes Tabular Model, Multi-dimensional Model, MDX, PowerPivot, DAX, PowerView, PerformancePoint SharePoint
• Worked on SSRS, Tableau dashboard and reporting.
• Worked extensively on BI tools like OBIEE, BO, SAS and Microstrategy.

Confidential - Capital Market, NY

Sr. Consultant

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
• Identified risks/issues with the solution design and contribute to the overall solution architecture of BI/DW development work; In addition worked on daily monitoring/data integration/ETL process during mission critical times and guide and helped with problem resolution.
• Implemented the Data model in power pivot, SSAS Multi Dimensional and Tablular model for client’s dataware house project.
• Worked on Data Quality Services( DQS) to clean databases.
• Worked extensively on BI tools like OBIEE, BO, SAS and Microstrategy.
• Worked on Fuzzy Matching and knowledge about data domain in SSIS-DQS.
• Implemented SSIS- DQS performance improvement techniques.
• Developed Tableau BI application, Reports and Dashboard with server side functionalities
• Developed the complete Tableau Architecture, direct from data source, Blended datasource, creating star schema, deploying the tableau dashboard and report on tableau server, implementing the security and providing roles to users.
• Good understadingof Tableau REST & JavaScript API, Tableau Mobile
• Implemented the Tableau user group and security configuration and server security setup
• Worked on ITIL, JIRA, Service Now, Remedy ticket management system.
• 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, Prespective and other features of SSAS OLAP enivonment that meet the requirements of business.
• Working on preparing SSRS reports using SQL Server BI Development Studio and implement on website. Prepared the Datasource,Dataset, dashboard and reports in SSRS with better transparency and reporting, as well as customizable interfaces for flexible delivery of information to internal and external shareholders
• Designing database, stored procedures, views and function using MS SQL Server Management Studio 2012.
• 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.
• Developed data warehousing application in Qlikview.
• Migrated the Qlikview model into SSAS model with Power-pivot and SSRS reports.
• Understand data visualization and should have an understanding of the tools to represent reports based on KPI and graphic representation
• Direct quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and UAT)
• Extensive experience with Object Oriented Programming and a solid working knowledge of .NET Framework(3.0/3.5/4.0/4.5), ASP.Net Web Forms, Win Forms, XML, HTML5, CSS, Angular.js, ADO.NET, T-SQL, ODBC, JQuery, JSON, Web API and JavaScript, LINQ, Entity Frame Work,, IIS, SOAP, XML, DOM, XSL, XSLT,.NET REMOTING, HTML 5, CSS3, Java Script, VB Script, Visual Studio.Net 2012/2010/2008, AJAX, XML,TFS 2012.
• 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.
• Developed DataModel,Report,dashboard in Yellowfin and deployed on client server.
• Proficient in Implementing WCF services and consuming using different protocols and implementing features like Security, Debugging and Performance.
• Create written communication materials that effectively summarize findings and support recommendations
• 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.
• Worked extensively with HTML, XML, JSON interfaces.
• Use versioning source safe -SVN Tortoise and GIT.
• Writing the DAX and MDX Queries.
• Worked on sharpoint and iintegarated it with Power BI Reports and project plan.

Confidential, New York

Sr. Software Consultant

Responsibilities:

• 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.
• Deploy the Tableau reports and dashboard, create security group and configure the security configuration.
• Written SSAS MDX Queries integrated with Pyramid analysis.
• Use Enterprise Library, SVN Tortoise/TFS 2013/GIT.
• Worked on Version control tool GIT and GIT Hub.
• 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 worked on BigData Hadoop, MangoDB-NoSQL.
• Install, configure and maintain SQL server databases
• Perform database,cube backups and refreshes.
• Writing the DAX and MDX Queries
• Worked extensively on BI tools like OBIEE, BO, SAS and Microstrategy.
• 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.
• Worked on Data Quality Services( DQS) for cleanse, Standarize and Validate databases.
• Worked on knowledge management of data domain in SSIS-DQS.
• Worked on IBM Tivoli Scheduler and SFTP protocol.
• 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).
• 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.
• Experience with .Net Framework 4.5 (ASP.Net,C#,VB.Net), Web Service, WCF,WPF, 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

Confidential, NY

Software consultant

Responsibilities:

• Worked as SQL Server 2012 Sr. Developer for Confidential a Hedge Fund domain company.
• Mentor and develop software application in SQL Server 2012 and MSBI (SSIS, SSAS- Tabular Model, multidimensional model, SSRS 2008/2012).
• Developed and deployed ETL SSIS packages on server and performed pre and post release validation.
• 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
• ASP.Net,C# with database directly.
• Worked on BI tools like OBIEE, BO, SAS and Microstrategy.
• 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.
• Worked as DBA,taking daily database backup,restore, performance optimization of database,deployment the release with pre and post deployment check, communicate with client and fixing the production bugs.
• 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.
• Worked on technologies such as Microsoft Azure (Hosted Services, Blob, Tables and Queues), SQL Azure,Servce Bus
• Maintained services hosted in Windows Azure.
• 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
• 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.
• Implemented the project using Java SDK, Java SWT, HTML, XML, JSON interfaces
• 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.

Confidential, Texas

Lead 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,
• 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.
• 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-Tabular Model/ Multidimensional Model,SSRS 2005/2008/2012)
• Developed and maintained scripts in Perl
• Worked on PowerPivot,PowerView,Tableau.
• 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.
• 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.
• Worked on sharpoint portal, created the various task and list into it, integrated it with Powerpivot and project plan.
• Worked on IBM Tivoli Scheduler and SFTP,FTP envinonment/protocol.

Confidential, TX

Technical Project Manager

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.
• Worked on IBM Tivoli Scheduler and SFTP,FTP envinonment/protocol.
• Easily recognizes system deficiencies and implements effective solutions.
• Communicates and enforces coding standards
• Understand and worked on BigData Hadoop, MangoDB-NoSQL.
• 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.
• 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.
• 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#, VB.Net, WCF and SQL Server 2008.
• Created and Modified the Reports using the SSRS with help of MDX queries.
• 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 11iQuery 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.
• 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.
• Worked on development and deployment of SSAS Tabular model and SSAS Multidimensional model.

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 2008R2/2012.
• 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
• Good understanding of banking, financial and insurance sector.