Sql Server Engineer

MANOJKUMAR PELLURU

EMAIL: **********.*******@*****.***

MOBILE: +91-958*******

PROFESSIONAL SUMMARY:

HAVING 5+ YEARS OF EXPERIENCE IN WINDOWS APPLICATIONS IN .NET TECHNOLOGIES.

●

WORK EXPERIENCE OF SQL SERVER 2000/2005 AND SQUIRREL SQL CLIENT.

●

GOOD SKILLS IN OBJECT ORIENTED PROGRAMMING.

●

EXCELLENT TEAM PLAYER AND ALSO SELF-LEARNER.

●

STRONG TECHNICAL SKILLS COMBINED WITH CLEAR COMMUNICATION.

●

STRONG

● EXPOSURE TO SOFTWARE DEVELOPMENT METHODOLOGY AND APPLICATION INTEGRATION

ASPECTS.

DEDICATED, CONSCIENTIOUS INDIVIDUAL WITH STRONG SENSE OF RESPONSIBILITY, WORK FLEXIBLY AND

●

QUICKLY ADAPT TO CHANGING ENVIRONMENTS PROFESSIONALLY AND PERSONALLY.

WORK EXPERIENCE:

WORKED SOFTWARE ENGINEER GENPACT SQL STAR

● AS A FOR ON THE PAYROLL OF

INTERNATIONAL LIMITED, HYDERABAD FROM DEC 2010 TO JAN 2014.

WORKED SOFTWARE ENGINEER FORTECH SOFT INDIA PVT.LTD, HYDERABAD JULY

● AS A AT FROM

2008 TO NOV 2010.

EDUCATIONAL QUALIFICATION:

• B.TECH (INFORMATION TECHNOLOGY) FROM NARAYANA ENGINEERING COLLEGE

AFFILIATED TO JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY, HYDERABAD (2004-2008).

• INTERMEDIATE (MATHS, PHYSICS, CHEMISTRY) FROM 2002-2004

• SSC FROM THE BOARD OF SECONDARY EDUCATION FROM 2001-2002

TECHNICAL SKILLS:

LANGUAGES: ASP.NET, C#, HTML

INTERNET TECHNOLOGIES: JAVASCRIPT.IIS SERVICES

DATABASE: MS-SQL SERVER 2000/2005, SSIS,SSRS,SQUIRREL SQL CLIENT.

TOOLS: VISUAL STUDIO.

OPERATING SYSTEM: WINDOWS (98/2000/NT/XP/2003)

PROJECTS #

TITLE : IMPLEMENTATION OF OCR TECHNOLOGY FOR GLOBAL

CLIENTS.

ORGANIZATION: GENPACT, HYDERABAD

TEAM STRENGTH: 6 MEMBERS

MANAGER: GANESH, AVINASH

TECHNOLOGY: OCR/ICR TECHNOLOGY,C#,.NET 2.0, DOKUSTAR FRAMEWORK MSSQL

AND

2005

CLIENT(S):

MASONITE

DELPHI

HUNTSMAN

HOSPIRA

E-BAY

JDI

NOVARTIS

ECOLAB

RENAULT

3M

DESCRIPTION:

OPTICAL CHARACTER RECOGNITION (OCR):

CR IS AN EXTRACTION ENGINE WHICH EXTRACTS THE HAND WRITTEN/MACHINE PRINTED CHARACTERS FROM SCANNED

O

IMAGE (INVOICE) USING DOKUSTAR FRAMEWORK. THE EXTRACTED OUTPUT DATA WILL BE CONVERTED INTO XML,

EXCEL OR PLAIN TEXT

.

KEY FEATURES:

• INDIVIDUAL OCR SQL

SERVER ALLOCATED FOR TOOL APPLICATION AND SERVER DATABASE FOR THE

DIFFERENT GLOBAL CLIENTS FOR THEIR BUSINESS NEEDS.

• THE OPERATION TEAM DOES THE EYE BALL CHECK WITH EXTRACTED DATA OF INVOICES, MODIFIES THE DATA

VALIDATION TOOL.

IF WRONGLY EXTRACTED WITH THE HELP OF

• MAPPING AND SHARES THE OUTPUT VALIDATED DATA WITH ERP SYSTEM (SAVVION AND SAP).

• VARIOUS SCHEDULED TASKS FOR VARIOUS OPERATIONS.

RESPONSIBILITIES INCLUDE:

• MONITOR AND MAINTAINS THE OCR APPLICATION SERVERS ON DAILY BASIS.

• MAINTENANCE AND MONITORING OF DIFFERENT CLIENTS DATABASES

• ANALYZING THE REQUIREMENTS, DESIGN, BUILD, AND DEPLOY AS PER SDLC PROCESS.

• PRODUCTION SUPPORT.

• CREATION AND MIGRATION OF DATABASES.

• CREATION AND CONFIGURATION OF SCHEDULE TASKS IN THE SERVERS FOR THE RESPECTIVE CLIENTS.

• TROUBLE-SHOOTING APPLICATION

ON CUSTOMER RAISED BASED ISSUES AND PROVIDING THE ROOT CAUSE

ANALYSIS TO THE CUSTOMER.

• FIXING THE APPLICATION ISSUES INTERNALLY,IF IT IS NOT RESOLVED THEN ESCALATING TO APPLICATION

VENDOR.

• ACTS ACCORDINGLY TO THE CUSTOMER ESCALATIONS AND THEIR QUERIES.

• GENERATING VARIOUS HISTORICAL REPORTS AND SHARES THE REPORTS TO VARIOUS CLIENTS ON WEEKLY AND

MONTHLY BASIS.

:

GRID SMART

ROLE : TEAM MEMBER

DURATION : AUG 2009– NOV 2010

TECHNOLOGIES : C#. NET, ASP. NET, ADO.NET, SQLSERVER2005, SSRS.

ORGANIZATION: FORTECH SOFT INDIA PVT LTD

DESCRIPTION:

THIS PROJECT IS OF THREE RELEASES:

1. INFORMATION PUBLISHING.

2. MARKET DATA COLLECTION.

3. PRODUCTS SERVICES AND SUPPORTS.

RELEASE 1:

RID SMART IS A PORTAL WHICH PROVIDES THE INTERACTION BETWEEN THE CUSTOMERS AND THE ORGANIZATION

G .

HE SERVICES PROVIDED IN THIS PORTAL ARE ONLINE DEMOS, CONTENT POSTING AND EXTERNAL USEFUL LINKS.

T

HERE ARE 4 TYPES OF USERS IN THIS PORTAL. FIRST USER IS THE SYSTEM ADMIN WHO TAKES CARE OF ENTIRE

T

PORTAL. SECOND USER IS THE USER ADMIN WHO APPROVES THE USERS (UPON USER REGISTRATION) AND GIVES

PRIVILEGES. THIRD USER IS THE CONTENT ADMIN WHO APPROVES THE CONTENT POSTED BY THE END USERS

THE

IS RESPONSIBLE TO PROVIDE THE USEFUL EXTERNAL LINKS AND THE CONTENT USEFUL TO THE END USERS

.

AND

OURTH USER IS THE END USER WHO USES THE PORTAL

F .

THERE ARE TWO TYPES OF END USERS. FIRST ONE IS THE USER WHO HAS REGISTERED.

USER HAS NO PERMISSION TO ENTER INTO VIDEO’S CATEGORIES. SECOND ONE IS THE SUBSCRIBED

USER. USER HAS PRIVILEGES TO ENTER INTO ONLINE DEMOS, CONTENT ETC ACCORDING THE PERIOD

AND AMOUNT USER HAS SUBSCRIBED.

RESPONSIBILITIES:

● INVOLVED IN CREATING THE WEB PARTS.

● INVOLVED IN DESIGNING THE MASTER PAGES AND INTERNAL PAGES IN MS VISUAL STUDIO.

● INVOLVED IN CREATING A USER INTERFACE TO THE SYSTEM ADMIN, USER ADMIN TO APPROVE

OR DENY THE REGISTERED USERS.

● INVOLVED IN CREATING AN INTERFACE, TO ADD THE USERS TO THE GROUPS AND GIVING

PRIVILEGES TO THE GROUPS AND USERS.

● INVOLVED IN CODING, INTEGRATION AND UNIT TESTING.

● ANALYZE THE SOURCE MAP DOCUMENTS AND CREATING PACKAGES TO MOVE THE DATA FROM

SOURCE TO DESTINATION.

● IMPLEMENTED PERFORMANCE TUNING AT VARIOUS LEVELS.

● CREATED SIMPLE AND COMPLEX REPORTS BY CUSTOMIZING LOOK AND FEEL BY USING VARIOUS

REPORT MODELS AND PASS THE PARAMETERS ACCORDING TO BUSINESS USER’S REQUEST.

● INVOLVED IN THE VARIOUS PHASES OF SOFTWARE DEVELOPMENT LIFE CYCLE (‘V’ PROCESS

MODEL).

FOR TRACK - REBATE MANAGEMENT SYSTEM:

ROLE : DEVELOPER

DURATION : NOV 2008 - MAR 2009

TECHNOLOGIES : C#. NET, ASP. NET, ADO.NET, SQL SERVER 2005

ORGANIZATION: FORTECH SOFT INDIA PVT LTD

DESCRIPTION:

FOR TRACK IS A CLIENT-CUSTOMIZABLE WEB-BASED ENTERPRISE SOLUTION DESIGNED FOR

MULTIPLE REBATE PROGRAMS FOR WATER SAVINGS,

EFFICIENTLY MANAGING

ALTERNATIVE ENERGY, CARBON MANAGEMENT AND POWER/ENERGY EFFICIENCY PROGRAMS.

FORTRACK CAN BE EFFECTIVELY USED TO MANAGE THE COMPLETE REBATE LIFECYCLE

CREATING CUSTOM REBATE PROGRAMS, PROCESSING ENROLLMENTS AND APPLICATIONS, GENERATING

INSPECTION ORDERS THRU THE FINAL STEP OF REBATE PAYMENTS. FOR TRACK CAN BE USED BY

ENERGY/WATER UTILITY ORGANIZATIONS, CITIES, MUNICIPALITIES, 3RD PARTY VENDORS,

PARTICIPANTS, REBATE ADMINISTRATORS / PROCESSING AGENCIES & PROGRAM CONTROLLERS.

RESPONSIBILITIES:

● INVOLVED IN DESIGNING THE APPLICATION USING ASP.NET, HTML AND JAVASCRIPT.

● INVOLVED IN DEVELOPING THE APPLICATION USING C#.NET, ASP.NET, HTML AND

JAVASCRIPT, SQL SERVER AS DATABASE.

● INVOLVED IN FUNCTIONAL DISCUSSIONS TO IDENTIFY THE OBJECTIVES REQUIRED.

● IMPLEMENTED INPUT VALIDATION USING THE JAVA SCRIPT.

● DEVELOPED SCRIPTS FOR CLIENT SIDE VALIDATIONS USING JAVA SCRIPT.

● USED ADO.NET FOR CONNECTING TO DATABASE

● ANALYZE THE SOURCE MAP DOCUMENTS AND CREATING PACKAGES TO MOVE THE DATA FROM

SOURCE TO DESTINATION.

● IMPLEMENTED CHECK POINT CONFIGURATION, PACKAGE CONFIGURATION IN PACKAGES FOR

BETTER REUSABILITY.

● ANALYZE THE SPECIFIED DOCUMENTS, BASED ON THAT CREATED CUBES, MEASURE GROUPS

FROM THE DATA SOURCES.

● IMPLEMENTED KPI’S, ACTIONS, CREATED CALCULATED MEMBERS FOR DOING INTERMEDIATE

OPERATIONS ON THE CUBE, AND DID PARTITIONS FOR PARALLEL LOADING OF DATA AND USE

MDX’S FOR FIRING THE QUERIES.

● PROCESS THE FACTS DIMENSIONS AND IMPLEMENTED AGGREGATION ON GRANULARITY BASIS.

● CREATED SIMPLE AND COMPLEX REPORTS BY CUSTOMIZING LOOK AND FEEL BY USING VARIOUS

REPORT MODELS AND PASS THE PARAMETERS ACCORDING TO BUSINESS USER’S REQUEST.

● INVOLVED IN CODING, INTEGRATION AND UNIT TESTING.

PERSONAL DETAILS:

FATHER’S NAME: P.BHASKAR RAO

DATE OF BIRTH: 02-07-1987

PAN NUMBER: BMBPK7209M

LANGUAGES KNOWN: ENGLISH AND TELUGU

HOBBIES: LISTENING MUSIC

DECLARATION:

I HEREBY DECLARE THAT ALL THE INFORMATION PROVIDED BY ME IS TRUE TO THE BEST OF MY

KNOWLEDGE AND BELIEF.

PLACE: HYDERABAD

DATE: P.MANOJ KUMAR

Contact this candidate