Post Job Free

Resume

Sign in

Sql Server Management

Location:
India
Posted:
July 27, 2015

Contact this candidate

Resume:

Subhendu Maji

*C/*, S.P. Apartment

** ******* ****, **********, *******

West Bengal, India, PIN - 700028

Mobile # +91-983*******

+91-727*******

Email: acqybv@r.postjobfree.com

Objective

Seeking for an overseas opportunity in the field of Software Development to take challenging and creative projects.

Summary

Approx. 8 years of experience in IT industry.

Having experience of the complete SDLC (Software Development Life Cycle) involving Design, Development, Unit Testing, Implementation and Maintenance of software systems.

Having experience in Team Leading and preparation of RPFs, project estimation, resource loading, client demonstration.

Having business domain exposure including Life Science, Healthcare, Realty, Marketing Resource Management, and Campaign Management.

Having interest and skill at learning new technology/concepts quickly, working well under pressure, and communicating ideas clearly and effectively.

Ability to work well in both a team environment and individual environment.

Having knowledge of CMMI Level-5 standards and processes.

Skillsets

Concepts : OOPs, .NET Framework, SQL, WCF, Windows Application, ADO.NET, GDI+, LINQ, SSIS, Reporting, Stored Procedure, JSON, Facebook Graph API, ItextSharp API

Languages : C#, T-SQL, ORACLE SQL, XML, ASP.NET, JavaScript, HTML

Tools : Visual Studio 2012, BIDS, Crystal Report, Aprimo 9.0 Marketing Resource Management, Microsoft SQL Server Management Studio, IIS7

Databases : Microsoft SQL Server, Oracle

Version and Source Control : Visual Studio Team Foundation Server

Career History

Cognizant Technology Solutions

Consultant-CRM

4th Jan 2010 - Till

Xerox CMS Aprimo

a) Client Xerox, UK

b) Duration Nov 2014 – Till

c) Environment Aprimo MRM, C#, .NET Framework 3.5, SQL Server 2008.

d) Role Techno Functional Analyst

e) Responsibilities

Leading a team of four associates, daily client interaction for the assignments and analysis.

Responsible for building plan for delivery and splitting task to team members.

Building demo/presentation for proposed solutions approach for new projects.

Developed an SSIS package for data transfer in between Aprimo and a third party application.

Configured Aprimo workflow for multiple projects.

Developed adhoc reports.

f) Description: Xerox uses the Aprimo marketing resource management tool to provide job and resource management visibility across the document supply chain for printing and direct mail. Aprimo MRM leverages multiple workflow for the different client of Xerox. Xerox client send their content for printing, Xerox raises PO and sends work order to supplier.

GSK Aprimo Enhancement and Report Development

a) Client GSK, USA

b) Duration Sep 2013 – Oct 2014

c) Environment WCF, C#, .NET Framework 3.5, SQL Server 2008.Crystal Report, ItextSharp API, Aprimo MRM.

d) Role Techno Functional Analyst

e) Responsibilities

End-to-End development, hosting of a Windows Service using ItextSharp API, C# and XML to automate the US FDA 2253 form filling process.

Integrated FDA 2253 service with a WCF service to manage the data.

Developed Crystal Reports using running total method, cross table, sub-reports.

Developed MS SQL Server T-SQL views for Crystal Report dataset.

Managed daily project updates and calls with business.

Requirement analysis and designing for the Crystal Reports and the FDA 2253 accelerator.

Unit Testing

f) Description: GSK NA uses a MRM solution named Aprimo. This application is used by GSK NA to streamline and automate best practice production and compliance processes across all marketing activities. GSK NA submits the FDA(Food & Drug Administration, US) 2253 form for promotional training materials they wants to use the FDA 2253 accelerator to automate the process of filling up the FDA 2253 form. GSK wanted to have adhoc basis Crystal Report to plan the forecasting and budgeting for their funding accounts and to gauge the effectiveness of workflow, to understand relevant effort done by users, time spent on review etc.

AstraZeneca Atlas Aprimo Support

a) Client AstraZeneca, USA

b) Duration Sep-2010 to Sep - 2013

c) Environment C#, WCF 3.5, .NET Framework 3.5, Oracle 10g, XML, Aprimo v8.7

d) Role Techno Functional Analyst

e) Responsibilities

Team Leading and client interaction.

Estimation, Analysis, Design.

Developed high end SOA and Flat File based connectors to third party system using WCF, C#.

Developed an automation tool “BulkAssetExtractor” using C#.NET, which extracts multiple files at single time from a file store.

Developed a connector for Facebook with Aprimo for lead generation.

Preparation of POC for several modules.

Workflow configuration, Universe Implementation, Design Data Import Scheduler.

Developed ad-hoc reports using MS SQL Server T-SQL views.

Estimation of Change Request

Test case preparation and Review

Defect fixing and testing

f) Description: AstraZeneca is facing difficulty in managing its marketing needs like planning, budgeting, managing assets, execution of campaign etc. It has currently a very large number of applications, some of which are legacy, that are working together for driving the entire business. However these applications are heterogeneous in nature. The propose solution involves implementation of Aprimo MCM and MRM modules like workflow management, Digital Asset Management, Campaign management, segmentation, Universe Management. This new marketing management module also required integration with third party system like SAP, ezBuy etc. in such a way that the entire business process is simplified and flexible to changes in future.

TRGger Lending System

a) Client Title Resource Group, USA

b) Duration Jan-2010 to Sep-2010

c) Environment C#, ASP.NET 3.5, JavaScript, SQL Server 2008

d) Role Techno Functional Analyst

e) Responsibilities

Estimation, Analysis, Design.

Code build using ASP.NET, C#, Java Script, WCF and Dundas Chart.

Data handling (Stored Proc/SQL) using Microsoft SQL Server.

Technical Documentation, Unit Test and Defect fixing.

Performance Review

Quality control collaterals.

f) Description TRGger system is developed to systematically manage all the Closing Agents, Abstractors and Surveyors and to automate the process of assigning Vendor to orders received from different lender companies for Titling and Closing. Using this system the user can create a vendor profile and also is able to edit their information. The system will also behave as an integrator between Iclosing Application of TRG and Lender Applications of PHH and Settlement Advantage.Com

Digital Avenues Pvt. Ltd.

Software Engineer

1st Jul 2009 – 31st Dec 2009

Augme Mobile

a) Client Augme Mobile, USA

b) Duration Jul-2009 to Dec-2009

c) Environment C#, MS SQL Server 2008, Crystal Report, Dundas Chart

d) Role Techno Functional Analyst

e) Responsibilities

Estimation, Analysis, Design for the reports and charts.

Developed the mobile user interface Netbiscuit and C#.

Developed the reports using Crystal Report running total method for the sales performance.

Developed the user interface for pie chart, bar chart, multidimensional bar chart using C# and Dundas Chart API.

Data handling (Stored Proc/SQL) using Microsoft SQL Server.

Technical Documentation, Unit Test and Defect fixing.

Performance Review

Quality control collaterals.

f) Description Augme Mobile offers comprehensive mobile marketing platform that provides marketers, brands and advertising agencies the ability to create, deliver, manage and track interactive marketing campaigns targeting mobile consumers through traditional print advertising channels. Augme Mobile solves the "mobile marketing puzzle" of wireless carriers and fragmented technology through an integrated solution that delivers interactive marketing content through traditional media channels to the mobile consumer on-demand.

Assyst International Pvt. Ltd.

Software Engineer

1st Oct 2008 – 17th June 2009

Aquifas

a) Client Aquifas, USA

b) Duration Oct-2008 to June-2009

c) Environment C#, GDI+, Binary Serialization.

d) Role Jr. Tech Lead

e) Responsibilities

Estimation, Analysis, Design for the different modules for the simulation tool.

Windows Application programming using C#, GDI+, Binary Serialization.

Built an custom file extension (.aqf) using Binary formatter.

Technical Documentation, Unit Test and Defect fixing.

Performance Review

f) Description Aquifas is Dynamic Simulation Software for Wastewater Management. This includes design and operations of activated sludge filter and membrane bioreactor. Aquifas is Whole Plant Design and Operations Simulator specifically geared to operators and engineers. It provides a graphical user interface to Aquifas series of models. This makes it easier for operators and engineers to customize and run plant simulations.

MEC Technologies (I) Pvt. Ltd.

Sr. Software Associate

7th April 2008 – 30th Sept 2008

Tabor Research

a) Client Tabor Research, USA

b) Duration Apr-2008 to Sep-2008

c) Environment C#, ASP.NET 2.0, SQL Server 2005.

d) Role Jr. Tech Lead

e) Responsibilities

Estimation, Analysis and Design for the survey module.

Developed the user interface using ASP.NET and C# for the survey.

Developed T-SQL Stored Proc for the data fetching for various reports for the survey.

Developed T-SQL views for the adhoc reports to analyse the performance review of the survey.

Technical Documentation, Unit Test and Defect fixing.

Performance Review

f) Description Tabor Research is a market intelligence, research and consulting advisory practice focused on suppliers, users and policy makers across the High Productivity Computing ecosystem. This system has been formed to provide deep insight and perspective around the dynamics of the current and emerging HPC market segment, including trends and influences affecting customer behavior, and technology adoption. Differentiating itself from other advisory practices, Tabor Research leverages the company's impressive database developed from 20 years of HPC publications experience.

Gatec Solutions Pvt. Ltd.

Software Developer

1st June 2007 – 31st March 2008

GoldMagenta

a) Client DB Enterprise, Kolkata, India

b) Duration Jun-2007 to Apr-2008

c) Environment C#, ASP.NET 2.0, SQL Server 2005.

d) Role Team Member

e) Responsibilities

Estimation, Analysis, Design.

Developed the user interface for reservation module using ASP.NET, C#, Web Service.

Data handling (Stored Proc/SQL) using Microsoft SQL Server.

Technical Documentation, Unit Test and Defect fixing.

f) Description GoldMagenta is an e-commerce application. Users are able to book several of services provided by the company. I’ve developed the hotel booking part using ASP.NET. Created a web service using which it can be accessed by other system.

Education

Completed Masters of Computer Application from University of Kalyani in the year of 2007 scoring 73%.

Personal Details

Nationality

Indian

Passport Number

J4849165

Marital Status

Married

Work Permit

India

DOB

30th April 1983



Contact this candidate