SUMMARY:

• Over 11 years of experience in Information Technology as Database Architect /Modeler/ Developer having hands on experience in Database Administration, Data Modeler, Java, BI Specialist (Cognos, SAS & BI publisher), ETL tool datastage, Salesforce and eBusiness suites (CRM, AR & AP).
• Proficient in database full project lifecycle including architectural designs, data modeling, code development, ETL process, application tuning, testing, and code reviews. Experienced in Data modeling using ER diagram, Dimensional data modeling, Conceptual/Logical/Physical Modeling using 3NormalForm (3NF), Star Schema modeling, Snowflake modeling using tools like CA Erwin, Sybase Power Designer for both forward and reverse engineering.
• Certified Oracle DBA having experience in installing, patching, upgrading, backup/recovery using RMAN, handling Oracle internal errors, performance tuning, security setup, space management, table partition and UNIX administration.
• 15+ years of experience in creation and management of Schema Objects - Tables, Views, Sequence, Synonym, Indexes, Triggers, Database-links, Collections & Objects, Functions, Procedures, package, Oracle Streams etc. Strong knowledge in Oracle Cursor Management and exception handling.
• Experience working in Pharmaceutical, Retail, Financial and Banking domains
• Designed, Developed very large data warehouse (VLDB) solutions for reporting and decision-making needs. Designed and developed several process oriented applications for handling ETL, Process and Reporting for the data warehouse.
• Expertise in coordinating with Business Leaders and Project Managers to assure the solutions are complying with business strategies and Software Product and Project plans.
• Experience in Planning, Organizing, Controlling Projects and Managing Team, Stakeholders, Risk, Issues, Tasks, Quality and Change Control.
• Managed both onsite and offshore development teams. Instrumental in team building, training and mentoring team members.
• Supervising internal staff and contractors to deliver key corporate initiatives.
• Served as a Defect Prevention Champion, Internal Quality Assurant and Configuration Manager for various projects.
• Familiarity of various domains viz. Finance (Investment Banking and Brokerage), Compliance, Telecom, Supply Chain Management, Manufacturing and Retail.
• 2+ years of experience in JavaScript, HTML, gwt, smartgwt, spring, Hibernate, maven, BIRT, and eclipse
• 5+ years of experience in core banking development, merger & migration.
• 10+ years of experience in designed and deployment of UNIX Shell Scripts using K Shell.
• 2+ year of experience in Oracle eBusiness suites such as Customer Data Hub, TCA customer data model, CRM, Finance AP/AR module, BI publisher.
• 2+ years of experience in IBM WebSphere Datastage EE 8.0/7.5 (Datastage Manager, Datastage Designer, DataStage Director, Datastage Administrator, Parallel Orchestrate)
• 2+ year of experience in working in Cloud Management Salesforces.
• 4+ year of experience in Cognos (Framework Manager, Data Manager, Report Studio, Analysis Studio and Query Studio).
• Excellent communication skills and leadership qualities with analytical problem-solving abilities including playing a vital role in coordinating multiple business meetings and following up on open items.

TECHNICAL SKILLS:

Tools\Operating System: DataStage EE 8.0/7.5 (Datastage Manager, \AIX, HP-UNIX 11/10x, Sun Solaris Datastage Designer, DataStage Director, \10/9/8/2.6/2.5, Red Hat Linux 4x/3x/2.1, Datastage Administrator, Parallel Orchestrate), \Windows Vista/XP/NT/2k/ME/98/95

Databases\Web: Oracle 12c/11g/10g/9i, SQL Server 2005, \JavaScript, XML, HTML, gwt, smartgwt, 2008, DB2Teradata, MS Access\spring, HibernateLanguages\Networking Tools: SQL, PL/SQL, Shell Script, Java\FTP, TCP/IP

Servers\Applications: Application Servers (WAS, Tomcat), Web \MS Office, MS Word, Excel, Visio, PowerPointServers (IIS, IHS)

Other Tools: Modeling (Erwin 4.0), Toad, QTP

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

Senior Database Architect/Administrator

Responsibilities:

• NC state budget is two year's budgets in which the first year is Long Session Budget. In it I created the Base budget by using batch process written in oracle PL/SQL and provide web portal access to the User for Budget Preparation and to create Cognos reports for Publishing the State Budget.
• And in the Second year is the Short session. Here we converted the General Assembly money report into certification and provided web portal access to add new recommended changes for creating a report to Publish the State's Budget.
• Also, regularly I provided Support for the day to day NC IBIS activities and the nightly batch process, to support the IBIS application.
• Interact with Budget analyst and other interfaces users such as cash management, treasurer, state controller & other agencies about all the current issues and about their enhancements.
• Regularly monitoring database activities such as RMAN backup, schema export, UNIX space monitoring, releasing UNIX space by manually cleaning old backup & resolving DBA related issues.
• Enhancement in IBIS web portal by using GWT, smartgwt, spring, hibernates, maven and eclipse. Also, write JUnit test cases that run in QA to provide Archive information.
• As a process improvement, create a new report in Cognos report studio that helps budget analyst in month/quarter close out.
• Providing budgetary and Allotment information to Vanguard Planning and its forecasting tool.
• Overviewing the process that migrates Sale force (SFDC) to Microsoft strategy for Military Veteran affairs.
• Provide support to NC grant system and take new enhancement in existing oracle store procedure and portal changes in Java script and report changes in BIRT.

Environment: Oracle 12c/11g, PL/SQL, SQL, Cognos, gwt, smartgwt, HTML, JavaScript, maven, BIRT, eclipse

Lead Cognos Report Developer

Confidential, Mount Laurel, NJ

Responsibilities:

• Involved in Requirement gathering from Business Users.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Design & development of the reports using Cognos 8 Report Studio, Analysis Studio reports
• Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Extensively worked with Stored Procedure Query Subjects in FM and Reports.
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
• Design and Developed the Framework Manager models and Published into server.
• Developed Report Studio and Analysis Studio Reports in Cognos 8 portal
• Co-facilitate client workshops and training, typically small to medium group of clients.
• Coordinating with Development Team tasks& Deliverables and working on high priority issues.
• Migrated Crystal web portal application using Cognos 8 BI Java SDK
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Involved into move to Deployment to UAT and Production.
• Worked with users and business analysts to define reporting requirements for various services and processes using Cognos BI 10.1 (Cognos connection, Query Studio, Business Insight Advanced, Business Insight and Report studio)
• Used several reporting packages to produce and automate defined reports
• Developed standard report templates using Report Studio and Business Insight Advanced
• Developed List reports, Charts, Drill Through reports, Master Detail reports using Report Studio and Business Insight Advanced
• Created calculations, filters and prompts in Report Studio reports
• Distributed and scheduled reports based on frequency (Daily, monthly etc.) in Cognos 10.1
• Responsible for creating ad- hoc reports for business users
• Developed Master Detail reports and list reports using report studio
• Unit testing of reports done through querying from different database tables as per the requirement
• Created different joins and unions in reports using report studio.

Environment: Cognos 10.1, 8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio), Cognos TM1 9.5.1, SAP R4, SAP HRMS, SQL Server 2005, Oracle 9i, DB2 Cognos Access Manger, Windows 2003 Server.

Confidential, Bridgewater, NJ

Cognos Report Developer

Responsibilities:

• Created Framework Manager models/packages (Relational and Dimensional) using single and multiple databases
• Developed Data Layer, Business layer and Presentation Layer, with appropriately defined relationship and cardinality between query subjects maintaining data integrity in Framework Manager
• Provided Drill - Through from Metric studio to Report Studio Reports
• Developed Drill reports from Report Studio to Analysis Studio Reports and vice versa.
• Developed Report Studio and Analysis Studio Reports in Cognos 8 portal
• coordinating with Development Team tasks& Deliverables and working on high priority issues
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Involved into move to Deployment to UAT and Production.
• Responsible for interfacing with other department teams (i.e. Development, Technical, Customer Service, Training and Quality Management) and/or vendors to support existing and new applications, products and tools.
• Designing and developing ETL strategies using SQL Server Integration Service (SSIS)
• Generated Complex reports in Cognos 10.1.1 report studio including Drill Down reports from DMR modeled Framework model
• Used advanced features like Conditional Formatting in Report Studio in generating multipage Reports
• Provide payroll solutions streamline for payroll process, improve productivity and simplify administration
• Provide training sessions and materials, and knowledge transfer, increase understanding of programming techniques and design principles.
• Created 3 different reports that included report functionality such as prompt pages, cascading prompts, conditional filters etc.
• Worked with List Reports and various formats of report generation e.g., PDF, XML etc.
• Assisted with SQL and procedural SQL in SQL Server and Teradata
• Implemented data warehouse concepts, methodologies and infrastructure including dimensional data modeling, change data capture, data quality, operational data stores, data warehouses, Meta data management, data marts and business intelligence reporting platforms.
• DBMS indexing and partitioning schemes to identify and optimize performance of ETL and BI reporting layers.
• Identify and resolve a wide variety of database problems
• Migration of reports and catalogs from Cognos series 8.4 to Cognos 10.1.1
• Data warehouse design & build experience including star schema and data modeling
• Enterprise data modeling layers including presentation, logical, and physical Mapping Data Elements from various data sources
• Implement security at Package level, Object level, Data level using Framework Manager
• Ensure timely and thorough issue escalation and resolution as well as strict adherence to all project milestones and deadlines
• Develop Framework Manager Models and analyzed those models in analysis studio.
• Created sophisticated Reports and Portal page Dashboard reports by using Report Studio
• Created Dashboards to present critical company data in a single report
• Created list reports & cross tab reports Active reports by using Cognos 10.1.1
• Distributed reports to various agents using Bursting.
• Used IIS(Internet information server) web server for configuration and management
• Migration of reports and catalogs from Cognos series 8.4 to Cognos 10.1.1
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio

Environment: Cognos 8.4/10.1.1BI, Cognos Connection, Cognos office Connection, Report Studio, Business Insight, Business insight Advance Query Studio, Analysis studio, Frame Work Manager, SQL Server, SSIS, XML and Windows XP, Cognos BI Suite 8.4 (Framework Manager, Query Studio, Report Studio, Power Play Studio, Access Manager), Oracle 11g, Toad, SAP BW, Windows

Confidential, Neptune City, NJ

Cognos Engineer

Responsibilities:

• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Involved into move to Deployment to UAT and Production.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Gathered functional requirements from analysts.
• Mentored and trained technical staff to enhance their Cognos BI competency level
• Created user groups and roles using Cognos Administrator
• Published multiple Cognos Framework Manager packages using data level and user level security
• Developing, customizing, and testing reports using the Cognos 8.3 and 8.4 BI tools
• Created Trend line and Combination charts and dash board reports using life science data in Report Studio
• Prepared necessary project related documents for reporting
• Designed customized welcome page using portal tabs in Cognos Connection
• Created complex reports using Cognos BI 8.3/8.4 Report Studio and Ad-hoc web based reports using Cognos 8.3/8.4 BI Query Studio
• Tested and validated the report output against the database to measure performance of reports
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query in Report Studio
• Created Scheduled Jobs by scheduling multiple reports in a job
• Created conditional formatting in Report Studio
• Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.3
• Upgraded reports from 8.3 to 8.4.
• Created Cash Product Dashboard reports to present critical company data in a single report using Cognos 8 metric studios.
• Used some advanced features like Conditional Formatting in Report Studio in generating multi page Reports.
• Used Conditional blocks and conditional variables for generation of reports.
• Manually modified the SQL in Report Studio to tune and/or to write reports.
• Develop Framework Manager models both Relational and Dimensional (DMR modeling)
• Develop models using prompts and filters.