We provide IT Staff Augmentation Services!

Bi Development And Support Lead Resume

Irvine Ca, UsA

Key Skills:

  • Proficient in Informatica 8 BI Suite (Power Center Designer, WorkFlow Manager, WorkFlow Monitor, Repository Manager, Administration Console)
  • Proficient in database Administration, DB Performance Tuning, Management.
  • Proficient in Cognos 8 BI Suite (Report Studio, Analysis Studio, Query Studio, Metric Studio, Event Studio, Framework Manager)
  • An effective communicator & team leader with strong analytical, problem solving aptitude. Possess a flexible & detail oriented attitude.
  • Highly motivated and results driven, thrives on challenges and committed to quality

Presently working with JNJ as Data warehouse lead (Informatica, SQL Server, Cognos)

Worked through all the phases of a product / project life cycle with a proven track record of leadership in building team, processes, procedures and service excellence in highly competitive business verticals in the IT field for areas like Business Intelligence environment starting from Informatica Integration service, Database, Datacenter Migrations, Database migration, Disaster recovery, implementation, Project Transitions, Service Delivery, IT Infrastructure Management, Security Process Consulting, budgets and forecasting, application support and People Management with strong leadership and organizational qualities.

Total year of Experience: 11 years 6 months

Summary:

  • Experience in Informatica development, administration
  • Experience in Informatica Upgrade from 7.1 to 8.1 and 8.6
  • Experience in Cognos Reporting and Analytics, administration
  • Experience in Cognos 8.2 to 8.4 upgrade
  • Experience in Data Center Consolidation project
  • Up gradation of SQL 2000 to SQL 2005 and SQL 2008 and Patch set administration.
  • Developer support and analysis of complex application design.
  • Performance Analysis, Tuning (SQL query/ Memory/ Database/OS)
  • Experience in System Design/Development and Support for web technology using ASP 2.0, VB .NET, XML, XSLT, HTML, JavaScript, VBScript
  • Experience in ETL tools like DTS, SSIS
  • Experience in EAI tool like BizTalk 2000, TIBCO, Oracle SOA-BPEL
  • Experience of Report developments using PL/SQL
  • Experienced in Unix, Windows and Mainframe development environment
  • Experience with multiple configuration management systems like: Visual SourceSafe, Rational Clearcase, PVCS
  • Process improvement initiative experience- IPMS ( Tata Consultancy tool)
  • Experienced in multiple areas of ITIL like: Change and Release Management process, Configuration Management, Incident Management, Service Continuity and Disaster Recovery planning, Security planning for SOX compliance.
  • Experience in SQL Server database administration specializing in production, UAT and development Environment.

Confidential- Irvine, CA, USA

BI Development and Support Lead

Responsibilities:

  • Leading the project for ETL production framework in Informatica- followed SDLC methodology.
  • Design and develop offshore-onsite support and delivery centre for BI technology ( SQL Server Administration, Informatica and Cognos)
  • Design of ETL system in DTS, SSIS & Informatica and complex stored procedure for COGNOS report
  • Design and implementation of multi-tiered application for sales promotional project. Responsibilities include requirement gathering, system architecture design, ETL development, data modeling, data integration/migration, custom reporting.
  • Enterprise level backup & recovery strategies
  • Implemented Quest LiteSpeed backups to network drives
  • Performed Data Center Consolidation project
  • Job automation & Alert notification
  • Informatica administrative tasks such as Installation, Configuration, Up gradation, hot fix apply, Workflow scheduling, Repository backup
  • Responsible for disaster recovery planning for SQL Servers
  • SQL Server administrative tasks such as Installation, Configuration, Physical/Logical database design, Database Creation, Up gradation, Cloning, Patching, Proactive Performance tuning and monitoring, Trouble shooting, Backup and recovery, Partitioning, Replication.
  • Involved in the Global Shared Service Model implementation for J&J companies
  • Accountable for multiple project deliverables from assessment through SOW, Cost budget control, planning and scheduling, team management
  • Manage a large team to support various Informatica jobs, database administration activities like daily job monitoring, database backup and restore, database tuning, Maintenance plan development, data refresh on development and Staging environment & production change management and release.
  • Design and implementation of an Incident Management application. Responsibilities include users Requirement analysis, evaluation of market standard tools, and architectural design of the application, database modeling, and coordination with development team, QA validation plan and implementation.
Confidential– Olympia, Washington , DBA & Integration Architect

Courts running in the state of Washington are currently using JIS application built in Legacy systems to manage the life cycle of Cases filed. There are near about 230 courts currently running in the state. Current case management system stores the case related data and data of persons involved directly or indirectly with the cases in the IBM DB2 Legacy System. The current system uses a common database to store person data related to cases filed in all the courts throughout the state. Administrative Office of Courts (AOC) is maintaining the current case management application.

Responsibilities:

  • Design web-services for exposing COBOL programs by SOA framework.
  • Design BPEL process
  • Design XSL transformations
  • Troubleshooting Performance issues as reported by Clients
  • Configuring, Managing and resolving issues in Standby databases.
  • Oracle installation, migration and Oracle upgrade services for all 9i to 10g.
  • Setting up offshore development environment
  • Setting up Windows DB2 and SQL 2005 database
  • Backup and Restoration of dev and stage databases
  • Design and construction of DTS package for extraction of data from SQL database and load to SQL 2005 database
  • Design and construction procedures and cursors in DB2 and SQL server.
  • Auditing of the client databases.
  • Performance tuning (Explain plan, SQL Tracing and STATSPACK).
  • Defining standards for Database documentation, creating documentation of the database environment
  • Establishing and providing schema definitions, as well as table space, table, constraint, trigger, package, procedure, and index naming Conventions.
  • Remote monitoring of Database using various Monitoring tools like HP Open View and other tools.
  • Managed all aspects of product development including gathering system and reporting requirements, defining project scope, scheduling programming tasks, defining milestones, setting up development environments, enforcing coding standards, writing test cases, and delivering finished product on time and on budget
  • Coordination with Onsite team.
  • Reporting to project Manager about all the statuses

Confidential– Torrance, CA, USA Integration Architect

Confidentia lhas a core product called Confidential, which interfaces with different discrete systems for contract acquisition. A contract is an application for an automotive loan. The applicants can be an individuals or business. An application is entered through delivery channels like OCA, Dealer Daily and RouteOne. The data enters into ALS COM via a VB Interface application as an XML. Analysts in TFS branch offices open it up for decision in ALSCOM. The applications can be declined, countered or approved. Then they get uploaded to Host (Lease/Retail Mainframe). In the Host they get discounted (rate of loan repayment is finalized) and booked. Then the approved applications get funded. OSCAR also has VB Applications interfacing with TFS Data warehouse and Credit Scoring (based on Bureau reports of individual Applicants), TFS Lexus Database, OFSC etc.

Responsibilities:

  • Setup and Configuration of Cluster BizTalk server with SQL 2000 server
  • Design disaster recovery environment for production BizTalk server
  • Installing and upgrading the SQL Server and application tools
  • Design, develop the database structure, Store Procedure as necessary for Business need
  • Worked on business requests for various decision making analysis
  • Implemented the record retention policy while archival of the data- to keep 135 days data
  • Performance tuning of the queries, manage procedures and triggers
  • Damage Control Operations if and when the system malfunctions
  • Support production database backup and log shipping jobs.
  • Manage service pack, security pack updates in dev, stage and production
  • Manage SiteScope alert set up and Microsoft MOM
  • Coordination with Offshore and Onsite
  • Prepared and conducted training through technical documentation preparation.
Confidential,USA ETL Programmer ETL – Development and testing of the INO project using Informatica. The summary bill invoices for ACP and Presto business units of Alcoa are handled using the INO project. The INO transforms XML data received from the XML gateway, to the EDI file that is fed to Gentran for further processing. The output schema was generated using Specbuilder, and ETL Designer was used to map the XML data to the EDI layout. A Trading Partner lookup file was used to map the Interchange ID and qualifier of the TP, based on the Customer ID received from Oracle (XML Gateway). Responsibilities:
  • Analysis, Design and development, SCM (S/W Configuration Management)
  • Coordinated with different support groups.
  • Worked on change controls raised.
  • Damage Control Operations if and when the system malfunctions
  • Job automation & Alert notification using OEM, shell/Perl scripting, Oracle DBMS Job scheduling, UNIX CRON, Shell scripting & Oracle Alerts
  • Reporting database setup using Oracle Logical Standby and Basic replication
  • All reporting activity
  • Coordination with Offshore and Onsite

Confidential,(UK)

Module Leader & Programmer Involved in analysis of the existing Origination application designing & constructions of different projects to identify the conversion/enhancement strategy and testing. As a Team Member and Developer the following responsibilities have been taken care:

Responsibilities:

  • Daily job monitoring, bug fixing, enhancement request handling, HLD/LLD design document preparation, coding, testing.
  • Develop SQL procedures, design Trigger, Cursors
  • Performance tuning of the queries
  • Preparation of Test Specifications.
  • Modification and development of Omnis program, designing the screens using Omnis Classic.
  • Unit Testing.
  • Ticket management

Confidential,USA Module Leader & Programmer

In a typical 3-Tier scenario, most of Business Logic is contained in the Middle Tier but in Global Office system, the Business Logic has been incorporated in the Data Layer in form of Oracle Stored Procedures. It has been observed that most of the transactions in Global Office system (e.g. Add Client, Update Assignee, etc) require hits to multiple tables and this implies an increased network traffic, which ultimately slows down the system. Thus in order to prevent multiple hits to the Database from the Middle Tier, XML parsing for database operation has been moved to the Data Layer. Further, the PL/SQL procedures has been designed in such a manner that for Multiple Row Insert/Update, the relevant rows are first inserted into PL/SQL tables and once the processing is over, the DML statements are issued.

Responsibilities:

  • Develop PL/SQL package for the module
  • Design the new module using XML as data source and XSLT parser
  • Preparing design document
  • Web page design and Coding in ASP
  • Enhancement request handling, HLD/LLD design document preparation, coding, testing.
Confidential, Turkey Module Leader & Programmer Responsibilities:
  • Requirement Analysis
  • System Study
  • Preparing design document
  • Coding in VC++
  • Requirement study and designing the database
  • Data extract and load from SYBASE to Oracle
  • Lead the Team for data transfer by File generation from CFA, RSO, PLANT, and HO module for respective locations

Hire Now