SUMMARY:

• Highly motivated and innovative software engineer with 12 years of experience in the Information Technology. Expert in Data Warehousing, ETL, Database Administration, Big Data and Business Intelligence technologies.
• Seeking a challenging Sr. Developer position in ETL, Data warehousing, Big Data and Business Intelligence.

TECHNICAL SKILLS:

ETL, Data Warehousing: Informatica Power Center 9.6, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Confidential /Hadoop HDFS/Salesforce Connectors.

Business Intelligence: Cognos 10.x/8.x Framework Manager, Query Studio, Report Studio, Analysis studio, Metric Studio, Metric Designer, Event Studio, Transformer 8.4 Cognos Conection, Qlikview.

Big Data: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop, Flume, Splunk

Databases: DB2, Oracle 11g, Sql Server, Mysql, Postgres

Database Tools: TOAD, Query Analyzer, Data Studio, Winsql, pgAdmin.

Data Modeling: Erwin, Logical and Physical Data Modeling, Star Schema & Snoke - Flake Schema Modeling.

Programming: Linux Shell Scripting, PL/SQL, Javascript

Tools: BMC Control-M Scheduler, HP Service Manager, UltraEdit, Putty, Winscp, Filezilla.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Lead Developer/Cognos/QlikView Lead Developer

Responsibilities:

• Gathering business requirements and understanding data mart requirements.
• Coordination with data modeler to design the various schemas.
• Extensively worked on data extraction, transformation and loading data from various source and target RDBMS Data stores SQL Server, DB2, Oracle, Postgres, flat files etc.
• Created mappings and Mapplets to load data from source systems into data warehouse.
• Created and Run the Linux/Unix Shell Scripts for all Pre-Post session ETL jobs.
• Extensively worked on debugger to identifying the bottlenecks and fine-tuned the mappings, Workflows and Sessions.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV/QA/PRD environment.
• Providing support to the developed jobs and providing solutions to the open tickets like incident tickets and problem tickets solving business partner problems on the data which we have loaded using ETL process and closing the tickets with proper solution.
• Part of the team researching on data integration on Confidential
• Part of the project involved in bringing the Salesforce data to in house target dataware housing using informatica salesforce connector.
• Using Haddop connector extracted Bank data from the source and loaded into Hadoop HDFS data lake.
• Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data in partitioned tables in the EDW.
• Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics.

Environment: Informatics 9.6 Power Center Client (Repository Manager, Designer, Workflow Manager, Workflow Monitor), SQL Server 2005 & 2008, DB2, Postgrsql(pgadmin), Lotus Notes, Oracle10g&11g, Control+M, Unix scripting, HP Service Manager, Splunk, Hadoop Connector, Hadoop, Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop

Confidential

Salesforce Connector

Responsibilities:

• Extensively used Cognos Framework Manager to build models with query subjects, query items and namespaces.
• Created OLAP Cubes using Transformer and published for faster report response time.
• Created monthly/weekly/daily Cognos Cubes depending on the requirement and using Control-M jobs to refresh the cubes.
• Published packages to the Cognos connection.
• Migrated cognos 7.4 version cubes (used analytically and used in reports), reports and Framework Manager Models to cognos 8.4 version, Migrated 8.4 cognos reports, cubes and FRWM Models to 10.1.1, Migrated From 10.1.1 to 10.2.1 tested the reports, Cubes and FRWM Models on test servers, published to production servers where users started using. Also providing support to the converted cubes.
• Created many management Dashboard out of a cube for better performance which brings many individual reports information and data elements. This Dashboard gives information on how externals and internals have been utilized, allocated and time reported under particular projects.

Environment: Cognos 10.2 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Analysis Studio, Metric Studio, Event Studio, Access Manager)Transformer, SQL Server 2008(SQL Server Management Studio 10.0), HP

Service Manager

Confidential

Responsibilities:

• Extract information from several data sources to create data views that can be filtered by multiple data points. Developed executive dashboards in QlikView delivered through the web, which enable to measure the performance of the business with analytical capabilities
• Dashboards were served to track the summary of the performance and current health of the ICP Program
• Created sub apps, Dashboards, Reprots for this Application providing metrics on risks and issues of all the projects in the ICP Program based on the business user requirements.
• Multiple tier of QVD architecture is implemented depending upon the complexity of the application and the final application reload duration was 4 Hours.
• Task set up are done using QEMC and created architecture for the interdependent applications and execute in proper order.
• Creating scheduled jobs for QVD extracts and report reloads.
• Created and Scheduled Weekly, Monthly QlikView reports to distribute on email

Environment: QlikView11, Web Services, Lotus notes, Primavera, Share Point, DB2, Sql server 2008.

Confidential

Informatica and Cognos Lead Developer

Responsibilities:

• Prepared all the required documents for ETL work and Cognos objects like technical design documents, unit test plan documents.
• Developed complex mappings with big sql override statements, used transformers according to data load requirements and created corresponding workflows.
• Coded Linux shell scripts for the control m to to kick of the workflows and also created many parameter files on the informatica servers.
• Tested the informatica components and linux components in the development environment and then promoted to other test environments for further testing and then deployed to production successfully.
• Created Models and Packages in Framework Manager from Oracle 9i.
• Creating Reports using Report Studio and created adhoc queries using Query Studio.
• Expertise in developing Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of Drill through Reports and Master Detail Reports Using Report Studio.
• Testing and improving Report Performance upon report completion for validation of Calculations & data.

Environment: Informatica 8.6.1, Power Center Client (Repository Manager, Designer, Workflow Manager, Workflow Monitor), SQL Server 2008, DB2, Lotus Notes, Oracle10g&11g, Control+M, Unix scripting, HP Service Manager..Cognos V8.4 (Report Studio, Query studio, Analysis Studio, Cognos Connection, Framework Manager),Analysis Studio, Testing tools(IBM Rational Manual testing tools)

Confidential

ETL and CognosDeveloper

Responsibilities:

• Member of warehouse design team assisted in creating fact and dimension tables based on specifications provided by managers.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Built Models and published Packages to the cognos connection utilizing Framework Manager.
• Expertise in developing Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of Drill through Reports and Master Detail Reports Using Report Studio.

Environment: Informatica 8.1, Power Center Client (Repository Manager, Designer, Workflow Manager, Workflow Monitor), DB2, Lotus Notes, Oracle10g&11g, SQL Server, Control+M, Unix scripting, HP Service Manager.

Confidential

Cognos and ETL Developer

Responsibilities:

• Developed reports like drill through reports, sub reports, list reports using Cognos
• Impromptu.
• Created catalogs from multiple databases with the help of Hot Files (.ims)
• Enhanced the existing reports and created new reports as per the user requirements.
• Customized the reports by adding calculations, conditions and functions.
• Created List Reports, Cross Tab Reports and Drill through reports.
• Created Filters, Conditions and Prompts in Catalog.
• Worked extensively on Oracle database. Troubleshoot for SQL issues/performance issues.
• Created Dimensional Maps, Transformer Models, Power-Cubes and Drill through.
• Automating tasks with Cognos Scheduler using Macros, Cognos Script Editor and Cognos Script Dialog Editor.

Environment: Cognos Impromptu, Cognos Power Play, Cognos Transformer, Cognos Impromptu Web Reports, Cognos Power Play Enterprise Server, Access Manager, Cognos Upfront, SQL *Loader, Oracle8i/9i, Windows NT/2000

Confidential

Senior Developer

Responsibilities:

• Involved in a software development project MTT (Medical Tools Testing) for the Best Medical Center. The purpose of this project is to develop a software system which will be used to test the accuracy of various surgical tools and detect the defects occur due to the prolonged usage.

Environment: CAD / CAM / CAE, RDBMS & GUI: C, C++, Oracle 8i