Objectives

I know what it takes to elevate your company to the next level. My Excel, VBA coding, TIBCO, and SQL skills have helped me accomplish the completion of important projects for the different companies I have worked for. In addition, "Data" has been my passion as an Excel/VBA/TIBCO/SQL Developer professional since I started my career. I assure you that your company will be glad to allow me to form part of their professional team.

Executive summary

• Twoyears of experience as SQL Developer with extensive experience of analytical techniques.
• Experience in writing SQL queries and optimizing the queries in SQL Server 2008.
• Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraints.
• Performed data analysis and data profiling using SQL on various sources systems including SQL Server 2008.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform data manipulations.
• An excellent team player & technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.
• Excellent written, communication and Interpersonal skills.
• Around 2 years experience in Enterprise Application Integration (EAI) usingTIBCOSuite of products.
• Experience in usingTIBCOBusiness Connect and iProcess suite and some design experience.
• Expertise in XML - XML, DTDs, XML Schema and XSLTs.
• Extensive Experience inTIBCOBusiness Works 5.x,TIBCORuntime Agent 5.x,TIBCORendezvous 7.x,TIBCOEMS 6.0,TIBCOAdministrator5.x.

Education

• Bachelor of Science in Computer Science
• Associates of Science in Engineering Science

experience

SQL Developer | Confidential
September 2011 - June 2012

• Using SQL to query DatabasesPerforming various validations and mapping activities
• Designed and configured many TIBCO Business Works (BW) processes and sub-processes as part of the overall design/development phase.
• Configured various EMS queues, topics, bridges and routes using TIBCO EMS Administrator tool.
• Worked on TIBCO File Adapter to File Reader reads data from file and publishes messages record by record and File Writer subscribes message and write into the file as specified format.
• Developed TIBCO Business processes and Workflow process.
• Build a common utility frame work to handle all the exceptions in a Business process.
• Using Excel and VBA in the development of robust and flexible reporting systems.
• Retrieved data from data warehouse and generated a series of meaningful business reports using SSRS.
• Validated and tested reports, then published the reports to the report server.
• Performed and conducted complex custom analytics as needed by clients.
• Designed and developed specific databases for collection, tracking and reporting of data.
• Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.
• Conducted research to collect and assemble data for databases - Was responsible for design/development of relational databases for collecting data
• Built data input and designed data collection screens - Managed database design and maintenance, administration and security for the company.
• Discussed intelligence and information requirements with internal and external personnel.
• Data output - Made data chart presentations, coded variables from original data, conducted statistical analysis as and when required and provided summaries of analysis.

SQL Developer | Confidential
September 2009 - May 2011

• Write complex SQL queries for validating the data against different kinds of reports.
• Worked with Excel Pivot tables.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Excel and SQL.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

skills

EAI Tools: TIBCO RunTime Agent 5.x, Business Works 5.x, TIBC BusinessConnect, TIB EMS 6.0, TIBCOAdministrator5.x, TIBCO Rendezvous 7.x, TIBCO iProcess 10.x, TIBCO Hawk4.x, File Adapter 6.0, Tibco ADB Adapter 5.2
Messaging Technologies: TIB EMS 6.0
Development Environment: TIBCO Designer 5.x
Programming Languages SQL, PL/SQL, VBScript, JavaScript, XML, HTML, XHTML & CSS
Databases Oracle 11g/10g/9i, MS SQL Server 2008
Tools Excel(Expert)(Macros, complex formulas)
Operating System Windows Vista/XP/2000/98/95, Dos
Tools & Software MS Office, Visual Basic, TIBCO, Oracle E-Business Suite(Basic Knowledge), TOAD, SSRS, SSIS, SSAS, Visual Studio

Programming Languages

SQL, PL/SQL, VBScript, JavaScript, XML, HTML, XHTML & CSS

Databases

Oracle 11g/10g/9i, MS SQL Server 2008

Tools

Excel(Expert)(Macros, complex formulas)

Operating System

Windows Vista/XP/2000/98/95, Dos

Tools & Software

MS Office, Visual Basic, TIBCO, Oracle E-Business Suite(Basic Knowledge), TOAD, SSRS, SSIS, SSAS, Visual Studio

Accomplishment(s)

• Professional Studies Division CouncilatMiddlesexCountyCollege(College Agenda Development)
• Computer programming and Repairing Technician Diploma
• A.S. Engineering Science
• B.S. Computer Science
• Sales and Marketing Diploma

Language(s)

• English/Speaking, WritingandReading
• Spanish/Speaking, Writingand Reading
• French/Speaking, Writingand Reading