OBJECTIVE:

An Accomplished Software Professional with over 10 years of experience in delivering applications, seeking a challenging and rewarding career in software industry.

SUMMARY OF SKILLS:

• Over 10 years of experience in I.T in the areas of web development, Business Intelligence and Reporting, Data Warehousing, coding, analysis, data modeling, performance tuning, database design and development, testing, software implementation, project management.
• Worked on all phases of software life cycle including analysis, design, and development, worked as Business analyst on many projects.
• Eight - year background in diverse facets of .NET development, encompassing analysis, design, development, and execution of business applications.
• In-depth knowledge of various platforms, software systems, and servers.
• Extensive programming experience using Classic ASP, ASP.NET 2.0, 3.0, 4.0, 4.5, HTML, and XML.
• Excellent communication skills with strong background working directly with coworkers and clientele to identify business objectives and establish requirements.
• Experience in Essbase development, administration, web analysis.
• Experience in Actuate 7,8,9,11SP3, BIRT, Tableau, Oracle 12c, 11g, 10g, 9i, SQL Server 2000/2005/2014 .
• Provided technical guidance/supervision on many projects, supervised developers from agencies working on various projects.
• Effective time management, tracking and reporting skills.
• Ability to quickly learn and apply new technologies.
• Ability to work independently as well as part of a team.
• Excellent communication, analytical, problem solving skills.

IT TECHNICAL SKILLS:

Reporting/BI: Tableau, Essbase, Web Analysis, Actuate e. Report Designer Professional 8-sp1Tools 9-sp3, 11-sp3, Telerik, (iReport), Actuate Information objects, BIRT

Databases: Oracle 8i/9i/10g,11g, 12C, Microsoft Access, SQL Server 2005/2014, MYSQL

Languages: C/C++,C#, Java, JSP, HTML, DHTML, AJAX JavaScript, XML, XSLT, ASP, PSP, VB

Application: JBOSS 4.0, IBM Web Sphere 5.0/4.0, WebLogicServers Apache Tomcat 4.0/3.x, IIS, Actuate iServer

Technologies: .NET 1.1/2.0/3.0,3.5,4.0,4.5, Classic ASP, Macros, J2EE, XML Technologies, Angular JS, JQuery

Operating Windows: Server 2003/2012, UNIX,DOS, Linux

IDE’s: Microsoft Visual Studio 2008, 2010, 2013, SQL Server Management Studio, Eclipse, Toad 7.6/8.5, SQL Query Analyzer, PL/SQL Developer

Others: Struts 2.0/1.0, Spring, iBatis, Hibernate 2.0, Apache ANT, log4j, JDK1.4-1.7, OpenAdaptor

EXPERIENCE IN DETAIL:

Senior IT Analyst

Confidential, Southfield, MI

Responsibilities:

• Performed detailed analysis of various quality management systems available in the market by comparing features of each system and provided guideline to the business for making selection of the best system in the market that can meet business as well as technical requirements.
• Worked as project manager/business analyst for implementation of Cebos quality management system in all the plants globally including North America, Europe and Asia.
• Conducted discovery workshops, UAT sessions with the vendor and corporate team as well as end users from the plants.
• Coordinated with ERP technical teams (QAD, SAP, legacy systems) for creating interfaces with QMS system using Boomi.
• Designed and implemented the data migration process for each rollout.
• Conducted meetings for resolving technical issues discovered by the users.
• Participated in various sessions for the system and helped business team in resolving most of the technical issues in house.
• Developed operational reports, dashboards, scorecards, and ad hoc reporting requests.
• Worked as project manager/supervisor for upgrading the custom developed in house web application.
• Supervised third party developers during the whole project providing technical guidance on the tools and technologies used in the project.
• Gathered business requirements and translated into technical specifications for developers.
• Coordinated for resolution for any technical issues discovered during user testing.
• Setup the application in test and production environments.
• Upgraded various in house web applications from .Net 1.1 to 3.5 and 4.5
• Replaced deprecated API’s and SQL functions with the latest ones.
• Migrated all the applications from Windows server 2003 to Windows server 2012 R2
• Made any programming changes needed for the upgraded server.
• Collect requirements from business and convert into technical specifications, create mockups, develop and implement software solutions including enhancements and new software development, work with the users throughout the complete Software Development Life Cycle using Agile approach.
• Supported various functions within the organization mainly, Engineering, Quality, Design, Commercial and Human Resources.
• Responsible for technical design, technical development, and technical deployment of applications.
• Played key roles in large projects. Senior Developer, Mentor, Technical Leader, Technical Project Manager.
• Participated and provided leadership in all phases of a project from discovery and planning through implementation and delivery.
• Investigated, debugged and fixed application problems reported by quality assurance.
• Support various in house web applications using Classic ASP,C#/ASP.Net, VS 2008/2010/2013 , SQL Server 2005/2014, Oracle PL/SQL, PSP.
• Made several enhancements, created new applications using C#.ASP.Net, VB, VB.Net
• Create SQL Server databases, tables, views, stored procedures, functions, triggers and database backups using SQL Server Management Studio.
• Wrote/updated Oracle queries, stored procedures and views for various Web applications written using PSP.
• Updated / Migrated Actuate iServer/portal and Actuate reports from version 9sp3 to 11SP3.
• Worked as Integration specialist, used OpenAdaptor for integration between various systems like AS400, Oracle, SQL Server and Progress.
• Responsible for Actuate iServer/portal administration/maintenance, monitoring the operation and performance of the system, troubleshoot issues related to actuate reports.
• Responsible for supporting ASP/VB based System which uses screen scraps to download the pdf files and extracts data to our SQL Server database.
• Responsible for Essbase administration with web analysis as the reporting framework.
• Create/update Essbase cubes and web analysis reports
• Responsible for IIS administration, setup and code deployment.

Environment: / Tools: .Net1.1/2.0, 3.5, 4.0,4.5, VB, ADO.net, Visual Studio 2003/2005/2008/2013 , SQL Server 2000/2005/2014 , IIS 7/8.5, Windows 2003/2012 Server, Actuate 8SP1, 9sp1, 9sp3, 11SP3, Actuate iServer, iPortal, Oracle 9i/10g/11g/12c, PL/SQL Developer, SSIS, Toad, PSP, J2EE, javascript, Essbase 11.1.1.3, Web Analysis, Telerik, Tableau

Actuate Administrator/Sr. Software Developer

Confidential, Plymouth, MI

Responsibilities:

• Responsible for Actuate iServer/portal administration/maintenance, monitoring the operation and performance of the system, troubleshoot issues related to actuate reports.
• Worked on migration of actuate reports for various applications from LEAR to Confidential environment.
• Setup, installed actuate environment for Actuate reports for various applications.
• Updated / Migrated Actuate iServer/portal and Actuate reports from version 8sp1 to 9sp3.
• Worked on migration of various .Net / ASP applications like Quality Tracking System, GM Contract Review System, Change Control Tracking Management System, Global Design Reporting System, Quality Alert System, I.A.C Portal from LEAR to Confidential .
• Create SQL Server databases, tables, views, stored procedures and database backups using SQL Server Management Studio
• Wrote/updated Oracle queries, stored procedures, views for various Web applications written using PSP.
• Supported various web applications written in plain old asp, VB, macros and .Net 1.1, 2.0.

Environment: / Tools: SQL Server 2000/2005, Windows 2003 Server, Actuate 8SP1, 9sp1, 9sp3, Actuate iServer, iPortal, Oracle 9i/10g, PL/SQL Developer, Toad, PSP, Classic ASP, VB, javascript, VB Script.

Software Engineer

Confidential, Florida

Responsibilities:

• Created Internal and external design documents for the reports.
• Designed, developed and updated several complex reports using Actuate 7, 8, 8sp1, 9.
• Design the new reporting framework for the ServicePath named ReportsExplorer that involves heavy customization of the Active Portal using struts, jsp, custom tags, ajax (dwr library), spring and ibatis.
• Implemented lightweight, MVC-based servlets and JSPs.
• Used DAO and multi-tier design patterns to seamlessly replace custom data store implementation Spring/ibatis at backend.
• Wrote sql queries and stored procedures for testing the data integrity of the system.
• Researched, designed and implemented a performance improvement of the system on both the front end and backend.
• Improved the reports performance by tuning the queries and finding solutions beyond tuning queries and table indexing.
• Updated / Migrated reports from version 7 to 8sp1.

Environment: / Tools used: JBoss 4.0, JSP, Struts, Spring framework, JDBC, iBatis, Actuate 7, 8SP1, 9, Actuate iServer, Oracle 9i, PL/SQL Developer, Toad Sun Solaris 9, Windows XP

Software Developer

Confidential

Responsibilities:

• Involved heavily in discussions with business users, analysts and managers and defining and developing design documents and technical specifications.
• Created Internal design documents for the Actuate reports.
• Designed, developed, maintained and migrated several complex reports using Actuate 5,6, 7, 8 and Oracle 9i for company’s Corporate Business Intelligence Reporting System to support management for strategic decision making.
• Designed and developed Actuate Information Objects providing business users the functionality to generate their own queries.
• Wrote stored procedures for the ETL process transferring data from production database to the Reporting Repository.
• Complex reports were developed by utilizing several Actuate features, such as, Actuate Programming, Page Level Security, and Drill down Reports (report bursting), Sequential Reports, Query Analyzer, Templates, and Libraries etc.
• Improved performance of several reports by tuning the queries and modifying the design and logic in the reports.
• Developed e-Spreadsheet Reports.
• Implement the page level security on the report by maintaining the ACL
• Used the Actuate Features like Single Input Filter, Memory Data Sorter, Dynamic Frames and Browser Scripting Controls.
• Developed reports like master detail, Cross-Tab, Sequential and Parallel.
• Design and wrote the technical and design specifications for the reports
• Established naming conventions, coding standards and best practices to make the development and maintenance of the systems fast and easy.

Environment: / Tools: Actuate 6, 7, 8, Oracle 8i, 9i, Toad 7.5, PL/SQL Developer, SQL