We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

5.00/5 (Submit Your Rating)

Summary:

  • A broadly talented individual with executive leadership qualities, eager to provide a significant contribution in software management, architecture and development with over Twelve 12 years of experience in Information Technology involving software analysis, design, development, testing, re-engineering, management, support and application development
  • Architect, design and Re-Engineered and automated many business process using BPM tools such as OpenText Metastorm, Microsoft work flows.
  • Strong Experience in OpenText Metastorm BPM Development
  • Successfully Implemented/ Integrated many 3rd party CRM, AMS, SAP BI and BPM tools for different clients.
  • The ability to interface with all levels of IT, including software development, quality assurance, IT support, business groups, and management working towards a common goal
  • Strong business interpretation client/server technology skills
  • Strong Crystal Reports, SQL, Oracle, SAP Business Objects and SSRS
  • Architected, Designed, developed, restored, backed-up and maintained database and database objects using SQL Server
  • Over 7 years Managed, mentored and Trained 2 to 12 developer on site and off site India
  • Assist business units in designing technical specification documents for internal or external database projects by providing a mock-up of a relational database model in sync with the business needs to a vendor.
  • Project planning including Scope definition, Effort estimation, Schedule estimation, preparing
  • Successfully Implemented/ Integrated many 3rd party CRM, AMS, SAP BI and BPM tools for different clients.
  • Strong Experience in APTIFY AMS/CRM Development/Configuration
  • Experience in developing, deploying and integrating Salesforce.com CRM solutions
  • Strong Experience in Creating Reports using SAP Business Objects and Crystal Reports XI
  • Hands-on experience on software product development lifecycle and production rollover
  • Experience in configuration management tools such as VSS and TFS
  • QA all SQL coding and data base design before applications are implemented into the production environment
  • Analyze, plan, design and implement new database structures in an efficient and timely manner to support the business needs of the company while maintaining the standards of a well-structured and normalized relational database model.
  • Promote and Influence the adoption of technology strategies and solutions with IS and Business stakeholders.
  • Architect is accountable for functional technical strategy through implementation Create Strategy, Business Benefits, Blueprints, Roadmap, Design Patterns, Best Practices, SLA s, Support procedures
  • Utilized extensively SQL, Oracle, SAP Business Objects, Crystal Reports, Microsoft Development, BPM, AMS, Raiser's Edge, CRM and ETL tools in development and design
  • Guided and mentored end users, executive management and team in the nuances of Business intelligence and how SAP Business Objects is utilized in a BI environment
  • Developed high quality documentation, including design specifications, requirements documents, and best practices, training materials, report standards, Test scripts, gap analysis and designs.
  • Experience on software reporting tools, e.g., SAP Business Objects, Oracle Reports, etc.

Technical Skills:

  • Languages: J2EE, Java 1.2 NetBeans 3.5 , Visual Basic 6.0, VB.NET 3.5, ASP.NET, ASP 3.0, Cold fusion, and C
  • Applications: Interwoven, Adobe PhotoShop 6.5, MS Office and FrontPage 2003, Toad for Oracle, Visio pro 2003, Dream Weaver, Visual Interdev 6.0, 6.0, I cube, TIMSS, and Aptify
  • BPM Tools: OpenText Metastorm 7.5, OpenText Metastorm V9.1 R2, Aptify 4.5, Oracle, BPM, OpenText Live link, Savvion
  • Document Management tools: Interwoven, Microsoft Share point
  • Project Management: Microsoft Project, Agile, Scrum, waterfall, RTC
  • Testing Tools: Test director, TFS, RTC
  • Script Languages: Java Scripts, Jscript, JSS, VB Scripts, XML, DHTML, CSS and HTML
  • Databases: Hadoop/BigData, SQL Server 2008, SQL Server 2005, SQL Server 2000, Oracle 11g, 10g, MYSQL, Oracle, SAP-BW, HR, CRM, AMS, Access 2003, Excel 2003 and IBM- DB2,
  • Data Modeling Tools: Erwin, Visio, Rational Rose, SOA, BPM
  • OS: Windows 7, Vista, Windows 2003, XP, Windows 2000, Windows NT, AS400 and UNIX
  • BI/Reporting Tools: Brio, Crystal Reports 8, 9, XI, R2 and crystal xcelsius, MicroStrategy, SAP Business Objects 6.5, SAP Business Objects XI, Brio, SQL Reporting Services/SSRS and Cognos
  • Version control: VSS/ visual source safe and TFS/ Team foundation serve

Professional Experience:

Projects:

Confidential

Solution Architect/Agile Scram

  • Strategic Architectural direction/influence the development team to design and Re-Engineering the current small business and consumer card system in to 1 platform using Savvion BPM in an Agile Scrum project methodology consist of multiple releases and each release with multiple 2 week sprints. Permit to Build, Permit to operate, SSO, OSA, TI requirements, Core software and Hardware platform guidance. Tracking Architectural importance in the Agile Project development, including of direction for the services to be IFW modeled, OSA3 header. EIB routing directions, Preparing SAD, Archducal road map, conceptual and system integration diagrams. Organizing and Participation in JAD tracking Architectural significant requirement and so on.
  • Promote and Influence the adoption of technology strategies and solutions with IS and Business stakeholders.
  • Providing design guidance and solution governance for Card Services technology initiatives.
  • Ensure that entire solutions Application, Data, Network, Hardware, etc meet the business needs and risk tolerance criteria of the enterprise permit to Build and Permit to Operate
  • Architect is accountable for functional technical strategy through implementation
  • Create Strategy, Business Benefits, Blueprints, Roadmap, Design Patterns, Best Practices, SLA s, Support procedures
  • Proactively identify opportunities through internal and external networks, for IS to deliver innovative solutions to customer issues/challenges and situations where leading edge technological innovations can be deployed to business advantage.
  • Influence adoption from IS community on strategy, capability, design patterns, best practices and implementation
  • Confidential
  • Solution Architect/Agile scrum
  • Architect, design and Re-Engineering the current Solutions from Metastorm version 7.5 to 9.2 and to redesign the current classic ASP application to a BPM using Metastorm 9.1.3 using SQL Server 2008 as back end. System and BPM work flow to improve and redesign in new platform to be flexible enough to accommodate the custom business rules of the client and followed Agile BPM development team under an accelerated 2-week release cycle.
  • Confidential
  • BPM Solution Architect
  • Architect, design and Re-Engineered of the High profile internal application the Rx Credit using OpenText Metastorm BPM Version 9 R3 and consolidating data from more than few date sources such SAP HR, Viva, as in to one Customer data Spherion DB Using Oracle as back end DB for OpenText Metastorm
  • Integrated SSO with OpenText Metastorm
  • Fully automated the override file process based on alignment dates
  • Automated email schedule with custom subject, body to different roles based schedule type, such as daily, weekly and one time schedule
  • Called SSIS package with in OpenText Metastorm create and upload file to specific location
  • Successfully overcome with many deployment issues related to OpenText Metastorm as well Oracle calls.
  • Integrated with external .net forms
  • Created many complicated process flows and efficiently used different code objects using ework code, C , jscript and so on, many SAP Business Objects is been created and used in throughout the process.
  • JMS Initiative: SharePoint integration with OpenText Metastorm v9. Lots of custom approaches have taken to meet client requirement. Custom Grid to control to do list, watch list and update priorities.

Confidential

Solution Architect/ Project Manager/ Technical PM:

Played a lead role in implementation of 3rd party AMS Association Management system software-APTIFY. Managed, mentored and trained on-site and Off-site team of developers. Customized the application and created many event based process flows BPM and wizard, Entities, Entity plug-in and dlls using .net coding to accomplish the IRA's business and functional requirements. Key contributor of data conversion process from legacy system TIMSS to APTIFY.

Project Manager Responsibilities:

  • Facilitated many project meetings to ensure the creation of the project plans and schedules.
  • Defined requirements and set the tracking plan for the project.
  • Set the deadline schedule and planned the follow-up meetings.
  • According to the Business Plan, obtained approval and delegated the technical responsibilities to the development team.
  • Provided follow-up reports on the status of the development process.
  • Organized briefing meetings before the production phase and the future status updates on continuous activity.

Solutions Architect Responsibilities:

  • Support and Administration of all in-house MS SQL Servers 2000 and 2005 including server installs, maintenance and upgrades, account creation, security role and permission management, backup/restore operations, activity and error log analysis, SSIS, SQL jobs and alerts scheduling and management, database performance tuning, replication, log shipping data and database integrity checks.
  • Administer Salesforce.com SFA setup, which involves, modifying roles and profiles, creating/modifying dashboards/reports and managing users. Design and configure user screens.
  • MS SQL Programming in the design, creation and testing of various database objects such as: tables, views, indexes, triggers, functions and stored procedures.
  • Create and Maintain catalogs/universes, reports using Cognos, Crystal XI, SQL Reporting services and SAP Business Objects.
  • Created work flow, custom forms to automate email blast request using Microsoft outlook.
  • Gather data, Schedule and Maintain bulk email blast in third party software called Magnet mail
  • Data conversion from legacy system TIMSS to APTIFY, Customization of application APTIFY
  • Customized TFS team foundation server for bug tracking and code versioning - Serve as TFS admin
  • Provide support for Sitefinity.

Confidential

BPM Solution Architect

  • Created many BPM OpenText Metastorm workflows Gathered requirement, Designed and captured many internal business logics for the HR Approver module.
  • Gather requirements, design and develop functional workflow using OpenText Metastorm BPM and Implemented with SAP HR- module.
  • Created many admin Forms to maintain - look ups, roles and email logics and so on.
  • Created client and server side scripting using Jscript.Net, Jscript and VB script in conjunction with Inline SQL
  • Created library files, Forms and Form Segments and made it available to use across many workflow processes.
  • Created IQ documentation for implementation and development guide
  • Created many reports using SQL server 2005

Confidential

BPM Solution Architect

  • Architect, design and development of the High profile internal application for the clinical trial process using OpenText Metastorm BPM and integrating with their SAP System and Gem clinical trial Data base other internal system via web service calls.
  • Gather requirements, design and develop functional workflow using OpenText Metastorm BPM.
  • Created External pages using ASP.net and called in those pages in OpenText Metastorm.
  • Created client and server side scripting using Jscript.Net, Jscript and VB script in conjunction with Inline SQL
  • Created library files to use across many workflow processes.
  • Established ECl connection from OpenText Metastorm to communicate with customer .net application.

Confidential

BPM Solution Architect/SQL Developer

  • Created New Business Intake/work flow Process, which supports the ability to capture Conflict, Client and Matter Information, obtain necessary level of approvals and create the resulting Master File records within the Elite Enterprise Database.
  • Gather requirements, design and develop functional workflow using OpenText Metastorm BPM
  • Created External pages using ASP.net and called in those pages using OpenText Metastorm.
  • Created, optimized and altered Stored Procedures/TSQL to accomplish the specific Business/functional requirements.
  • Made calls against SQL 2005 using Inline SQL,
  • Profoundly used Jscript and Java Script in conjunction with Inline SQL

Confidential

SAP Business Object Architect

  • Team lead for SAP Business Objects environment: Implementation, Migration and development, responsible for managing SAP Business Objects operations.
  • Gather requirements, design and develop functional prototypes of reports using Crystal XI, SQL Reporting Services against Oracle, Domino, SQL-server 2005 databases
  • Publish, maintain and schedule reports in SAP Business Object XI for Legal IT group
  • Installed and configured SAP Business Object XI for Crystal XI
  • Created Cubes using, SAP Business Object XI and generated reports
  • Created and maintained user account, security functional groups and admin reports for the Interwoven EDGE
  • Created Stored Procs using SQL programming, Oracle packages to accomplish the specific report requirements
  • Created XML file feeds to interwoven using SQL 2005
  • Created Universes, Business Views and dynamic cascading parameters in SAP Business Objects
  • Ability to translate user specifications into reports
  • Created Repository and security domain with user groups and security implementation
  • Installed and configured environment for development, testing and production
  • Migrated Reports from Access, excel and other reporting systems to SAP Business Objects and Crystal Reports.
  • Trained team members and client users on the development and nuances of Business intelligence tools
  • Established BO strategy, standards, best practices, and templates as well as mentoring Team members

Confidential

Lead Software Engineer

  • Developer of TestNet Intranet site, a centralized departmental reporting portal and repository for senior management
  • Re-designed with ASP .NET and SQL Server backend
  • Worked with a team of developers tasked with adding new functionality to help successfully implement a global enterprise level IT project impacting internal and external customers
  • Gathered, designed, prepared specifications, and developed re-usable .inc files using ASP, ASP. Net, Java script and VB script
  • Designed responsibilities included logical and physical design along with network infrastructure, security, and data integration
  • Wrote SQL queries, stored procedures, and library files to create add, edit and delete forms from tables using .inc files in .net platform
  • Created Custom web based reporting software using ASP and ASP. Net

Confidential

Programmer/Database Analyst

  • Designed and developed a data driven user-friendly application for automation of flyer in production and circulation
  • Read the data through ODBC connection from DB2 database to the front-end and SQL database
  • This was a client/server application that maintained essential information
  • Identified, designed, prepared specifications, and developed re-usable frameworks using VB.Net
  • Designed responsibilities include logical and physical design along with network infrastructure, security, and data integration
  • Discussed and refined the user requirements
  • Designed, developed, restored, backed-up and maintained database and database objects using SQL Server
  • Created different security levels to the user limitations
  • Created inline and stored SQL queries both in the front-end and in the database.
  • Created Repots using SAP Business Objects, Crystal Report 9.0, SQL and Brio
  • Developed and maintained an intranet application using MYSQL and PHP scripts
  • Involved in understanding the schema design to consequently facilitate the loading of fact and dimension tables for the data warehouse
  • Created report against CRM DB for circulation department

Confidential

Part-time Product Analyst E-Serv

  • Analyzed and documented product requirements and features
  • Prototyped and created mock up screens
  • Created test plan and test cases for each feature
  • Enhanced application for the use of parallelism

Confidential

  • Designed and developed an application to calibrate the capacity and determine the cost of an arbitrary network
  • Created design specifications and many Java objects
  • Created user interface for specifying different network properties

Confidential

  • Designed and developed a Book Store Management System which is a Client/Server application to maintain essential order and sales information
  • This application includes Order Processing, Customer Tracking and Order and Sales Projections
  • Created customer, order entry, order processing and many validation screens
  • Created and maintained database and database objects
  • Generated many order and sales projection screens

Confidential

  • Isolation and analysis of agricultural waste compounds using LC-MS and GC-MSD software
  • Prepared and isolated samples using a variety of analytical techniques such as solid-phase extraction, liquid-liquid partition and rotary evaporation etc. and analyzed them are using analytical instruments such as HPLC and Spectrophotometer etc.
  • Experienced in using SOP, EPA and QAU guidelines and followed GLP's for method validation

We'd love your feedback!