Sql Server Manager

Satish Garre 207-***-****

MarkLogic Consultant ***********@*****.***

Summary

• Over Seven years of IT experience in various industry verticals including Business

Analysis/Modeling, Design, Application Development, Implementation, Documentation, Testing

and Deployment of enterprise applications.

• Around One year of experience with XQuery (XSLT, XML) for interaction with MarkLogic content

server.

• Installing, Configuring and Migrating to latest releases of MarkLogic.

• Responsible for implementing and deploying MarkLogic Projects

• Around Three years of experience with technical and functional knowledge on various modules

and components of Maximo (5.2/6.2/7.1).

• Installed and configure Maximo server on both Weblogic and Websphere on various

environments and also involved in maintenance of Maximo severs.

• Involved in administration tasks like creation of Maximo settings (system, organization and site

level) and security settings.

• Working experience on Maximo modules like Assets, Work order Management, Preventive

maintenance, Inventory management, Service requests etc.

• Experience in working with application designer to create new custom application,

Customization, Create custom Attributes, Objects and Applications, Modify existing Screens and

fields, Modify .ear files.

• Performing Database configurations in Maximo 6.2 and running configdb.bat utility to apply the

database changes to the database

• Developed custom MBO's and extended MBO sets as per the business rules.

• Experience in integrating Maximo with ERP systems like SAP and Oracle using Maximo

enterprise adapter (MEA).

• Good Knowledge of Maximo EAM, TSRM, CCMDB, TAMIT File structure and respective Tables.

• Created Custom reports according to the business requirements using Actuate, BIRT and

Modified existing Maximo reports according to the required specifications.

• Experienced in work flow processes, Work Views, Communication Templates, and general

Maximo Systems Application tasks, roles and responsibilities

• Expertise in Servlets, JSP, Struts and EJB in Server side programming.

• Vast experience in software development life cycle and software testing methodologies.

• Functional experience with SAP, PEOPLESOFT, SQL Server 2000/2005, Oracle 8i/9i/10g.

• Knowledge of Front end technologies like Java, Visual Basic, HTML, XML enables to understand

the application as a whole.

• Experience in developing projects with onsite/offsite coordination.

• Experience in Working on Unit Testing and Integration Testing for each custom developed

interface and did end to end testing for the entire applications.

• Used version control Systems like Rational, Clear Case, Cross Vista.

• Experience in SQL Server, developing T-SQL queries, stored procedures, and triggers using MS

SQL Server 2000, MS SQL Server 2005 and Oracle.

• Effective in working independently and collaboratively in teams.

Certifications

Satish Garre 207-***-****

MarkLogic Consultant ***********@*****.***

Skillset

EAM Maximo EAM 7.1/6.x/5.2/4.0

Database Oracle, MS-SQL Server, MS Access, MarkLogic.

Languages JAVA, JScript, C, C++, HTML, PL/SQL, T-SQL, VB Script

Application Servers Oracle Webogic, IBM Websphere, Apache Tomcat, IIS

Applications Microsoft Office 2007/2003/XP/2000, Adobe Professional

Operating Systems Windows Vista/XP/NT/2K/98, UNIX

Actuate, BIRT, Eclipse(IDE), XML, XPath, XQuery,SQL Loader, Mercury Test

Other Tools

Director, SAP BI, Business Objects, DataStage,

Professional Summary

CQ.Com (Congressional Quarterly), DC Mar ’09 - Current

MarkLogic Consultant

Environment: MarkLogic 3.6 / 4.1, Application Builder, Java 1.5, Eclipse, J2EE, Weblogic, Solaris,

Oracle, XQuery, XPath, XML.

Responsibilities:

Installation and maintenance of MarkLogic Server.

Creating and Configuring HTTP Servers, XDBC Servers, WebDAV Servers for external applications

to interact with MarkLogic Database.

Configured Audit settings to track Events.

Interacted and worked with MarkLogic PS teams in the Implementation.

Creating, Merging and Indexing of Databases.

Loaded documents into forests (database) using different options based on the Dataset volumes

(Document – load, Loaders, from backups).

Developed XQuery Scripts for customized Search and interacting with content.

Granting privileges / permissions to various users and Groups.

Experienced in writing XQuery using XQuery Functions’ as well as MarkLogic functions ( Library

and search )

Very well experienced in XML Standards.

Developed systems to auto send e-mails, send out reports.

• Wrote test scripts and related documentation for the applications and transitioned the support

activities

Also involved in testing of the objects developed along with other modules before Go-Live.

Exxon Mobil, TX Apr ’07 – Mar ‘09

Maximo/Java Consultant

Environment: Maximo 4.1/6.x, JSP, SQR, Actuate Reports, XML, HTML, Java Script, VB-Script, Oracle,

IIS, Web Sphere, MS Access.

Responsibilities:

• Performed a Maximo 4.1 to Maximo 6.2 Upgrade and assisted in installation and configuration of

MXES 6.2 with Websphere.

Satish Garre 207-***-****

MarkLogic Consultant ***********@*****.***

• Used custom written migration scripts to perform software upgrade by moving data from Maximo

4 to MXES.

• Understand the PM, Job plans and other maintenance process in the company

• Coordinating with other Projects in analysis and implementation of related changes in our

applications.

• Communicate effectively and directly with customer and management on Project issues and

updates.

• Created user groups, site specific privileges

• Developed screens for the asset, locations module using application designer.

• The inventory data was validated and routed to the storeroom locations within Maximo

• Configured printers via Maximo for printing EM’s at the equipment specific locations

• Migrate/merge data from legacy Maximo systems into central database (SQL server to Oracle 9i).

• Understanding the business logic of the flow of information.

• Designed the Data Model with feedback from the Business.

• Modifying MBOs (MAXIMO business objects) so as to map the additional Oracle database

columns with MBOs.

• Involved in designing the data structures in Oracle 9i, loading legacy data into databases using

Migration scripts, Stored procedures.

• Was complete in charge of developing and implementing the Security groups and users

privileges.

• Created Complex Stored Procedures to implement Business logic.

• Performed integration testing to verify the data transfer between the various modules.

• Verified database information by employing SQL queries for data accuracy and consistency.

• Troubleshoot and fix the day to day Issues related to all the Maximo components like JSP, XML,

Websphere and Database.

Aspen Marketing, FL Feb ’05 – Dec‘06

SQL Server Developer/Analyst

Environment: SQL Server 2000, Query analyzer, DTS, Enterprise manager, XML, VB Script, MS Access,

Erwin.

Responsibilities:

• Created Stored Procedures, Triggers, Views and Functions for the Application. Provided

extensive testing on the Performance of the Stored Procedures.

• Imported various Sources, Targets and Transformations using transact-SQL Server.

• Developed complex T-SQL code for the application conversions.

• Wrote and integrated Stored Procedures to generate the Reports.

• Performed data transfer and database transfer for server relocation, using DTS.

• Used Query Analyzer to optimize SQL Queries.

• Created Alerts and scheduled DTS Packages to generate reports.

• Created and managed schema objects such as tables, views, indexes, procedures, and

triggers and maintained Referential Integrity.

• Scheduled many Jobs using SQL Server Agent. Identified and added the report parameters.

Satish Garre 207-***-****

MarkLogic Consultant ***********@*****.***

• Uploaded reports on to the report manager and organized them in folders.

• Delivered the reports using ‘pulled’ and ‘pushed’ methodologies.

• Defined Check constraints, Business Rules, Indexes, and Views.

• Formatted the reports using the Global variables and expressions.

• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF

and Excel formats using Reporting Services.

• Deployed the generated reports on to the server.

• Create new tables, views, indexes and user defined functions.

• Involved in Data Administration and Database Design. Created Database Objects like Tables,

Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.

• Actively designed the database to fasten certain daily jobs and some stored procedure.

• Optimized query performance by creating indexes.

• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles

& grant privileges to users and roles.

• Fine-tuned the database objects and server to ensure efficient data retrieval.

ITC Infotech Ltd, India Dec ’03 – Feb ‘05

SQL Server Developer

Environment: MS SQLServer2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import &

Export Data, Windows 2000 Server.

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access.

• Tested to optimize the Stored Procedures and Triggers to be used in production.

• Maintained the client relationship by communicating the daily statuses and weekly statuses of the

project.

• Planed, defined and designed data flow processes for data migration to the Data Warehouse

using DTS.

• Created Database Objects – Tables, Indexes, Views, User defined functions, Cursors,

Triggers, Stored Procedure, Constraints and Roles.

• Developed complex T-SQL code for the application.

• Worked in Enterprise Manager for job scheduling and batch queries.

• Installed and maintained MS SQL Server 2000.

• Monitored performance and optimized SQL queries for maximum efficiency.

• Implemented fine tuning of database objects and server to ensure efficient data retrieval.

• Managed and monitored the use of disk space.

• Planned Backup strategy based on projects requirements.

• Maintained the consistency of the client’s Database using DBCC.

Planetsoft Ltd, India Jan ’02 – Dec ‘03

SQL Server Developer

Environment: SQL-Server2000, DTS, T-SQL, Windows 2000 Server.

Satish Garre 207-***-****

MarkLogic Consultant ***********@*****.***

Responsibilities:

• Involved in installation and configuration of SQL server 2000 on Servers.

• Applied patches and service packs to keep the database at current patch level.

• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults,

• User defined data types and functions.

• Implemented database standards and naming convention for the database objects.

• Implement and maintain database security.

• Implemented trigger and stored procedures and enforced business rules via checks and

constraints.

• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

• Going through the clients' requirements and coming up with database design and application

• Architecture.

• Troubleshoot and minimize production down issues.

• Designed new job process, new database maintenance plans, DTS programs and did

• Performance tuning of the existing processes.

• Created Scheduled maintenances and backup procedures to the database as a disaster

recovery

• Method.

• Data conversions and data loads from various databases and file structures.

• Monitor failed and long running MS SQL Server jobs.

• Monitor, tune, and analyze database performance and allocate server resources to achieve

optimum

• Worked on Database performance.

• Maintaining User account administration for Different domains.

Education

Bachelors of Technology, JNTU, India

Contact this candidate