We provide IT Staff Augmentation Services!

Lead Developer Resume Profile

PROFESSIONAL SUMMARY

  • Eight years of IT experience in object oriented Analysis, Design, System Analysis, Development of Informatica mappings, sessions, workflows, mapplets and Hyperion Interactive Reports using java scripts, XML.
  • Strong technical skills including data analysis and analyzing bugs and Interacting with Developers and team members in fixing the Errors.
  • Strong understanding and expertise in understanding of interactive object model and hands-on expertise in building dashboards using java scripts, XML.
  • Developing reports using Hyperion SQR and building cubes using Hyperion Essbase.
  • Development of reports and dashboard using OBIEE and BI Publisher reports.
  • Ability to create enterprise reports and dashboards.
  • Ability to develop and maintain the OBIEE repository
  • Excellent knowledge and experience of Informatica ETL Staging and Data mining
  • Excellent programming skills using PL/SQL, java scripts, C, C .
  • Demonstrated ability to meet deadlines while providing complete and accurate work product.
  • Requirements gathering, analysis and effort estimation and helping project manager in developing project plans for project schedule and maintenance.
  • Ability to communicate effectively both orally and in writing with team members and supervisors, presenting to project team and clients.
  • Proficiency in leading and mentoring individuals to maximize the level of productivity while forming cohesive team environments, performing review of all offshore deliverable and artifacts-Code review, Technical Design Review, Unit Test cases and Results
  • Proven ability to work efficiently both as independent, and as a team player and be highly motivated

TECHNICAL SKILLS

  • Informatica Design, Development of Mappings, Mapplets and Workflows for Informatica for data ware housing and data mining activities
  • OBIE: Analysis, Design and Development of Reports using OBIEE and BI Publisher reports for a HR , Marketing , Sales for Decision support systems
  • Hyperion IR: Analysis, Design and development of Hyperion Interactive Reports for decision support systems. Version 8 and 9
  • Languages: Java, PL/SQL, C and C
  • Web Technologies: HTML, XML, Java Script
  • Operating Systems: UNIX, Windows XP/NT/2000
  • Databases: SQL Server 2000, MS Access, Oracle 8.x, Oracle 9i/10g, Teradata

PROFESSIONAL EXPERIENCE

Confidential

Role Technology Lead

Role: Onshore Technical lead

Description: Marketing Track Reporting initiative involves extracting data from various sources into a common data repository, performing various data transformations based of set of business rules, and loading data into a database to make available for reporting to generate reports for various decision support systems in OBIEE.

Responsibilities:

  • Design and implementation of business intelligence reports ranging from simple reporting to advanced Ad hoc reporting with provision of exporting results in Word, PDF, Excel, Text file formats using OBIEE and Informatica for staging.
  • Performed ETL procedure to load data from different sources into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor.
  • Create and maintain reporting documentation and specifications.

Confidential

Role: Onshore Technical lead

Description: HR Reporting initiative involves extracting data from various sources into a common data repository, performing various data transformations based of set of business rules, and loading data into a database to make available for reporting to generate reports for various decision support systems. Mainly deals with data from learning management systems, HR data and staffing data.

Responsibilities:

  • Design and implementation of business intelligence reports ranging from simple reporting to advanced Ad hoc reporting with provision of exporting results in Word, PDF, Excel, Text file formats using OBIEE and Informatica for staging.
  • Performed ETL procedure to load data from different sources into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor.
  • Manage OBIEE repository and end to end migration.
  • Create and maintain reporting documentation and specifications.

Confidential

Role: Onshore Technical lead

Description: ADIM Initiative involves extracting data from various sources into a common data repository, performing various data transformations based of set of business rules, and loading data into a database to make available for reporting to generate reports for various decision support systems using Hyperion IR.

Responsibilities:

  • Design and implementation of business intelligence reports ranging from simple reporting to advanced Ad hoc reporting with provision of exporting results in Word, PDF, Excel, Text file formats using both
  • Hyperion IR and OBIEE Reporting.
  • Manage issues related to reporting requirements and implementation.
  • Create and maintain reporting documentation and specifications and coordinating with Business Analysts to clarify the Business requirements for building Interactive GUI based reports for decision support systems for the bank.
  • Maintenance activity for existing reports.
  • Training end users in the use of Hyperion Interactive Reporting and mentoring team

Confidential

Role: Lead Developer Offshore

Description: SARA project was based on monitoring of Account level activities for tracing suspicious activity if any. It involved cleaning data and loading data from various sources into a staging area, and applying specific set of rules to each record to trace any suspicious activities and generating reports using Hyperion IR for the same.

Responsibilities:

  • Requirement Analysis, Application Design, Creation of Technical Design and Documentation
  • Configuration, performance tuning, installation of Informatica, integration of various data sources like Oracle, Teradata, MS SQL Server, XML, Flat files into the staging area and Design ETL processes that span multiple projects.
  • Data Mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor.
  • Tuning Informatica Mappings to identify and remove processing bottlenecks.
  • Environment: Informatica Powercenter 8.1, SQL Server, Flat Files, UNIX Shell scripting.

Confidential

Role: Lead Developer Offshore

Description: CREMIS project was designed to handle the applicant's data for the real estate and mortgage system. The project dealt with data coming in on a daily basis, being subjected to business rules and then loaded into the target database. The source data was in the form of Mainframe files and the database is Teradata. The project involved loading Data for slowly changing dimensions.

Responsibilities:

  • Requirement Analysis, Application Design, Creation of Technical Design and Documentation
  • Configuration, performance tuning, installation of Informatica, in integration of various data sources like Oracle, Teradata, MS SQL Server, XML, Flat files into the staging area and Design ETL processes that span multiple projects.
  • ETL procedure to load data from different sources into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor.
  • Tuning Informatica mappings to identify and remove processing bottlenecks.
  • Develop Complex Informatica Mappings, Mapplets and Reusable Transformations using multiple sources, transformations and targets from different sources to facilitate one time, Daily, Weekly, Monthly and Yearly Loading of Data.
  • Provide production support by monitoring the processes running daily.

Confidential

Role: Lead Developer Offshore

Description: In Service By Others initiative the unprocessed data was present on UNIX box and Mainframe and we have to move it DWH after required transformations as per the end user's requirement and maintain History for the same..

Responsibilities:

  • I was Involved in the detailed analysis, design, documentation, development of the Informatica mappings testing.
  • involved in Analysis and coding for the enhancements in existing process as per change in requirement.
  • Development of Test Scripts for testing.
  • Involved in fine-tuning the Informatica Code mapping and sessions , Stored Procedures, SQL to obtain optimal performance and throughput.
  • Monitoring the environments and suggesting improvements for stability performance tuning.

Hire Now