VIKAS KUMAR SINGH

Portico Conversion: This is a data migration project

• Trained 3 junior developers on best practices in data warehousing techniques to facilitate team growth and knowledge sharing.
• Did code refactoring and performance tuning.
• Obtain CSV files from source and move data to target SQL server and CSV file
• Push data to mainframe using JCL jobs
• Create Excel based reports and provide them to client
• Technology used: SSIS, SQL, Mainframe

CARE: Is a web application based on JQuery UI

• Role: (Module Owner)
• Supported application developers with troubleshooting assistance related to SQL queries and stored procedures.
• Optimized storage capacity utilization by implementing effective partitioning strategies for large datasets.
• Application has module that is used for reporting
• SSRS web service feature is used to retrieve and manage reports
• Basically, we have created custom report manager
• Technology used: SSRS, SSIS, SQL, C#, .NET, JQuery, JqGrid, LinkQ, PowerBI

BIClinical(product): A flexible, SaaS-based and rules-driven platform for healthcare business intelligence (BI) and integrated clinical, financial, operational and regulatory reporting

• Developed reusable components for exploitation in coding and documentation.
• Creating SSRS map report, and consuming WCF web service for data, dynamically creating KPIs in SSAS cube and Share Point Scorecard using .net code (C#), SharePoint web part creation with SSRS reportviewer embedded in it, creating and integrating PowerBI reports with SharePoint.
• Technology used: SSRS, SSIS, SSAS, Powerview, PowerBI SharePoint, Excel, D3 chart C#, .NET

Globearc: A fund of fund trading and management system that provides for the management of investments in hedge funds

• Platform that supports all business functions for research and investing in hedge funds
• Create SSRS reports using SQL and MDX queries
• SSRS reports were deployed on the report server
• User can access these reports through UI.
• Worked on integrating third party tools with reports such as Aspose Cell for PPT export and Dundas charts to display comprehensive charts
• Technology used: SSRS, SSIS, SSAS, Report server, SQL 2008 R2, C#, .NET

Citco Data Migration: A SSIS package (SQl server Integration services) solution which reads data from several sources such as FTP, SQL server etc. and transform it according to the requirement and store it to cube

• Created packages for ETL process to extract data from different sources like FTP, Database Server and transforming as per Citco Business Requirement and loading clean data into cube
• Technology used: SSIS, SSAS, C#, .NET Role

Hedgeindex: A web site to represent the liquid, investable hedge fund universe

• It reflects the performance of managed accounts and other regulated fund structures sourced from across a range of platforms
• Using Factory Pattern as architecture
• Creating ASPX web pages using ASP.net, C# as backend code and data base related changes.
• Technology used: C#, .NET, Asp.NET, third party tools like Dundas charts and AM charts