SUMMARY

• 12+ years of IT experience in Software Analysis, Development, Implementation of business applications for Financial, Pharmaceutical, Auto and Telecom verticals.
• Extensively (5+ years) in investment banking and wealth management.
• 3 years of Java/J2EE development experience.
• Worked with very large DW.
• Extremely driven, proactively engaged clients and project stakeholders for constant feedback in whole life cycle of Enterprise Data Warehousing, BI and ETL. From understanding client's complex systems, architecting appropriate solutions, applying best practices, creating remarkable solutions, driving development, getting involved in deployment, and ensuring the highest quality code, testing, and usage experience for the end client.
• Over 9 Years Extensive hands on experience in installing and developing OLTP/OLAP/Data Warehousing and Reporting using Cognos tools: Cognos Impromptu, Cognos Powerplay, Cognos Transformer, Access Manager, Impromptu Web reports (IWR), Visualizer, Cognos Metrics Manager, Cognos Report Net1.1(Framework Manager Cognos Connection Report Studio Query Studio), Cognos 8/10 and Cognos TM1 9.x/10.x Suite.
• 9 years of ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 7.x/8.x Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.
• Hands on experience in writing, testing and implementation of the T - SQL, PL/SQL triggers, MDX, stored procedures, functions, packages.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

TECHNICAL SKILLS

Programming languages: Java/J2EE,JavaScript, VB, Perl, PHP, Python, XML, Erlang

Operating Systems: Windows 9x/NT/2000/XP, UNIX, Linux, Solaris, DOS, Mac OS

Database Applications: Oracle, MS SQL, MS Access, DB2, Sybase, MySQL, PostgreSQL, Teradata

Application Software: MS .NET, Macromedia Flash, Dreamweaver, Fireworks, Freehand, Adobe Photoshop, Confidential, Reuters, SAP, JD Edwards

Web Framework: Django (Python), Symfony (PHP)

BI/ETL Software: Informatica 7.x/8.x, Cognos 7.x/8.x/10.x, Cognos TM1 9.x/10.x

Others: Hadoop, RabbitMQ

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

BI Cognos Lead Developer/ Architect

Responsibilities:

• Provided oversight, architecture, design recommendations, project planning and management and leading both Confidential Self Service and Confidential Mobile BI initiative.
• Working with project stakeholders and providing updates on project schedules and evaluating alternative solutions.
• Supported the architecture and development of analytics solutions leveraging IBM Cognos TM1 and integrated TM1 against a standard Business Intelligence (BI) suite (Cognos 8/10).
• Translated user requirements into design and development of complex Framework Manager Models, Cognos/Qlikview reports, active reports, and dashboards.
• Validated reports including variance of prior data from a reliable source data.
• Peer review reports created by other developers and provide feedback.
• Migrated Cognos bit Reports/Models, cubes, portal customization and Cognos SDK to Cognos 10 and conducted end user trainings.
• Architected, designed and developed new reports, report distribution and enchanced Cognos SDK. Created multidimensional cubes, automated cube build process and designed and developed cube to maximize performance.
• Mainly performed ETL design (Informatica/Hadoop), development, administration, source to target mappings, data warehouse transformations, on call support, trouble shooting and documentation.
• Wrote T-SQL, PL/SQL stored procedures
• Worked with very large DW.

Environment: Cognos TM1 10.x, Qlikview, Cognos 8.x/10.x(Reports Studio, Active Reports, Query Studio, Metrics Studio, Analysis Studio, Framework Manager, Virtual View Manager, Transformer, Go Office, Cognos Business Insight), Erwin 7, Informatica PowerCenter 8.6, Greenplum, Oracle 10g, Unix, Hadoop

Confidential, NY

BI Cognos Lead Developer/ Architect

Responsibilities:

• Provided oversight, recommendations, project planning and management and leading both on-shore and offshore team regards Brio Migration Project.
• Working with project stakeholders and providing updates on project schedules and evaluating alternative solutions.
• Translated user requirements into design and development of complex Framework Manager Models, reports, active reports, and dashboards.
• Migrated Brio Reports to Cognos (10.x and TM1 10.x) Environment.
• Worked with Business users and Offshore team to resolve issues, development, QA, UAT and production support.
• Wrote Cube Rules, MDX, appropriate Feeders and fine tune Feeders for better performance. Created temporary Views, Subsets using Turbo Integrator. Scheduled chores for data updates and other business logics.
• Supported the Development of a Report Template Library.
• Validated reports including variance of prior data from a reliable source data.
• Peer review reports created by other developers and provide feedback.
• Migrated Cognos 8 Reports/Models, cubes, portal customization and Cognos SDK to Cognos 10 and conducted end user trainings.
• Architected, designed and developed new reports, report distribution and enchanced Cognos SDK. Created multidimensional cubes, automated cube build process and designed and developed cube to maximize performance.
• Mainly performed ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, trouble shooting and documentation.
• Wrote T-SQL, PL/SQL stored procedures
• Worked with very large DW over 10TB

Environment: Cognos TM1 10.x, Cognos 8.x/10.x(Reports Studio, Active Reports, Query Studio, Metrics Studio, Analysis Studio, Framework Manager, Virtual View Manager, Transformer, Go Office, Cognos Business Insight), Erwin 7, Informatica PowerCenter 8.6, Teradata, SQL Server 2008, Brio, Oracle 10g, Unix

Confidential, Bridgewater, NJ

BI Cognos Lead Developer/ Architect

Responsibilities:

• Provided oversight, recommendations, project planning and management and leading ATT Cognos/Mobile Project.
• Working with project stakeholders and providing updates on project schedules and evaluating alternative solutions.
• Translated user requirements into design and development of complex Framework Manager Models, reports, active reports, and dashboards.
• Manage IBM Cognos PMR relationships, user administration, events, etl loads, recovery and performance monitoring.
• Created Active reports which are highly interactive and stand alone Dashboard style reports which end user can open in a standard browser window.
• Developed Dashboards for various Business groups using Cognos Active Reports
• Made the dashboards available on mobile devices for principals/senior executives.
• Wrote Cube Rules, appropriate Feeders and fine tune Feeders for better performance. Created temporary Views, Subsets using Turbo Integrator. Scheduled chores for data updates and other business logics.
• Supported the Development of a Report Template Library.
• Validated reports including variance of prior data from a reliable source data..
• Peer review reports created by other developers and provide feedback.
• Migrated Cognos 8 Reports/Models, cubes, MDX, portal customization and Cognos SDK to Cognos 10 and conducted end user trainings.
• Architected, designed and developed new reports, report distribution and enchanced Cognos SDK. Created multidimensional cubes, automated cube build process and designed and developed cube to maximize performance.
• Mainly performed ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, trouble shooting and documentation.
• Wrote T-SQL, PL/SQL stored procedures
• Worked with very large DW over 20TB

Environment: Cognos TM1 10.x, Cognos 8.x/10.x(Reports Studio, Active Reports, Query Studio, Metrics Studio, Analysis Studio, Framework Manager, Virtual View Manager, Transformer, Go Office, Cognos Business Insight), Erwin 7, Informatica PowerCenter 8.6, Teradata, SQL Server 2008, MS SSIS, Oracle 10g, Unix

Confidential, NY

BI/ETL Architect/Senior Developer

Responsibilities:

• Participated in meetings with the end-users to understand and collect Business Intelligence (BI) report and Web content needs.
• Supported the architecture and development of analytics solutions leveraging IBM Cognos TM1 and integrated TM1 against a standard Business Intelligence (BI) suite (Cognos 8/10).
• Documented requirements, gather consensus, and resolve any ambiguities and/or conflicts.
• Prepared conceptual, logical and physical design documents.
• Collaborated with other groups to design and develop new enterprise reporting solutions.
• Translated user requirements into complex Framework Manager Models, reports, active reports, and dashboards.
• Wrote Cube Rules, MDX, appropriate Feeders and fine tune Feeders for better performance. Created temporary Views, Subsets using Turbo Integrator. Scheduled chores for data updates and other business logics.
• Created Active reports which are highly interactive and stand alone Dashboard style reports which end user can open in a standard browser window.
• Developed Dashboards for various Business groups using Cognos Active Reports
• Made the dashboards available on mobile devices for principals/senior executives.
• Supported the Development of a Report Template Library.
• Validated reports including variance of prior data from a reliable source data..
• Peer review reports created by other developers and provide feedback.
• Migrated Cognos 8 Reports/Models, cubes, portal customization and Cognos SDK to Cognos 10 and conducted end user trainings.
• Architected, designed and developed new reports, report distribution and enhanced Cognos SDK. Created multidimensional cubes, automated cube build process and designed and developed cube to maximize performance.
• Performed installation, configuration, account management, access control, maintained Cognos reporting security and Cognos administrative functions in Unix environment.
• Installed/configured Cognos products in windows workstations.
• Mainly performed ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, trouble shooting and documentation.
• Wrote T-SQL, PL/SQL stored procedures

Environment: Cognos TM1 9.x/10.x, Cognos 8.x/10.x(Reports Studio, Active Reports, Query Studio, Metrics Studio, Analysis Studio, Framework Manager, Virtual View Manager, Transformer, Go Office, Cognos Business Insight), Erwin 7, Informatica PowerCenter 8.6, Teradata, SQL Server 2008, MS SSIS, Oracle 10g, Unix

Confidential, NY

BI/ETL Architect/Senior Developer

Responsibilities:

• Designed, developed and upgraded many financial, billing, sales reports on Cognos 8/10 and Cognos TM1. Delivered Framework Manager models and reporting for corporate finance, sales and billing departments.
• Provided direction and architectural leadership for the creation of innovative TM1 solutions in support of theClient SPSS Financial Performance Management Platform; including, defining source and Client data architecture and input interface requirements to enable theClient to feed the needed data into the Cognos TM1 and BI reporting infrastructure.
• Wrote Cube Rules, appropriate Feeders and fine tune Feeders for better performance. Created temporary Views, Subsets using Turbo Integrator. Scheduled chores for data updates and other business logics.
• Assisting in TM1 data model design, strategic direction, and overall management of information.
• Performance tuned Cognos Reports, models, and Cognos server instances for optimal performance.
• Migrated Cognos 8 Reports/Models, cubes, portal customization and Cognos SDK to Cognos 10 and conducted end user trainings.
• Created Active reports which are highly interactive and stand alone Dashboard style reports which end user can open in a standard browser window.
• Developed Adaptive Dashboards for various Business groups using Cognos Active Reports
• Made the dashboards available on mobile devices for senior executives.
• Architected, designed and developed new reports, active reports, report distribution and enchanced Cognos SDK. Created multidimensional cubes, automated cube build process and designed and developed cube to maximize performance.
• Developed Cognos EP models, eList and peformed Table only publish.
• Performed installation, configuration, account management, access control, maintained Cognos reporting security and Cognos administrative functions in Unix environment.
• Installed/configured Cognos products in windows workstations.
• Mainly performed ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, trouble shooting and documentation.
• Wrote T-SQL, PL/SQL stored procedures

Environment: Cognos TM1 9.x, Cognos 8.x/10.x(Reports Studio, Active Reports, Query Studio, Metrics Studio, Analysis Studio, Framework Manager, Virtual View Manager, Transformer, Go Office, Cognos Business Insight), Erwin 7, Informatica PowerCenter 8.6, SQL Server 2008, MS SSIS, Oracle 10g,Teradata, Unix

Confidential, NY

BI/ETL Lead

Responsibilities:

• Designed, developed Business Intelligence Enterprise reporting, OLAP, dimensional modeling, and data warehouse development, implementation, and maintenance using Kimball methodology. Cognos 8 to deliver Framework Manager models and reporting for corporate governance, risk, equity and performance team.
• Developed Cognos TM 1 analytical cubes and integrated with BI reports.
• Wrote Cube Rules, appropriate Feeders and fine tune Feeders for better performance. Created temporary Views, Subsets using Turbo Integrator. Scheduled chores for data updates and other business logics.
• Managed 4 developers and worked with off-shore team in full development life cycle.
• Used Erwin for data modeling and Framework Manager in Cognos 8 to model metadata from different sources for use in Report and Query Studio.
• Architected, designed and developed new reports, report distribution and enhanced Cognos SDK. Created multidimensional cubes, automated cube build process and designed and developed cube to maximize performance.
• Performed installation, configuration, account management, access control, maintained Cognos reporting security and Cognos administrative functions in Unix environment.
• Installed/configured Cognos products in windows workstations.
• Mainly performed ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, trouble shooting and documentation.
• Designed and developed mappings in Informatica to load staging area and DW. Enchanced current mappings, mapplets, and worklets.
• Wrote T-SQL, PL/SQL stored procedures

Environment: Cognos 8.4(Reports Studio, Query Studio, Metrics Studio, Analysis Studio, Framework Manager, Virtual View Manager, Transformer, Go Office), Erwin 7, Informatica PowerCenter 8.6, Salesforce, Sybase 12.5, SQL Server 2008, Oracle 10g, Unix

Confidential, Cleveland, OH

Cognos BI Architect

Responsibilities:

• Mainly worked involved evaluating Cognos 8 BI, setup, installation, configuration (LDAP and AD Security), applying security and performance tuning.
• Optimization techniques such as load balancing and partitioning are employed and provided feedback on the current system.
• Emphasized and carried out best practices to support the reporting activities.
• Ensured that the client's needs are adequately addressed during the implementation.

Confidential, NY

BI/ETL Developer

Responsibilities:

• Extensively worked on understanding the business requirements, designing, developing EDW using Kimball approach and Cognos applications for credit derivative fixed income reporting.
• Used Erwin for data modeling and Framework Manager in Cognos 8 to model metadata from different sources for use in Report and Query Studio.
• Architected/Migrated/Developed new reports like master detail, cross-tab, ad-hoc reports (embedded charts and graphs), balanced score cards and executive dash boards from Actuate 7 reports to Cognos Reports.
• Created dimension maps and multidimensional cubes using Transformer, Cognos TM1.
• Developed Cognos TM 1 analytical cubes and integrated with BI reports.
• Performed installation, configuration, account management, access control, maintained Cognos reporting security and Cognos administrative functions in Unix environment.
• Installed/configured Cognos products in windows workstations.
• Mainly performed ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, trouble shooting and documentation.
• Designed and developed mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expressions, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformation.
• Removed bottlenecks at the source level, transformation level, and target level for optimum usage of sources, transformations and target loads.
• Created reusable components like Mapplets and Worklets to enhance development process.
• Wrote T-SQL, PL/SQL stored procedures and used cursors, performance tuned SQL queries and created temporary objects on tempdb.

Environment: Cognos TM1, Cognos 8.1-8.4(Reports Studio, Query Studio, Metrics Studio, Analysis Studio, Framework Manager, Transformer), TM1, Erwin 7, Informatica PowerCenter 8.6, Sybase 12.5, Oracle 10g, Unix

Confidential, Murray Hill, NJ

BI/ETL Developer

Responsibilities:

• Worked at Confidential ’s client, (Verizon, Chrysler Financial Services, Amylin Pharmaceutical) as a developer on Data Warehouse BI implementation team.
• Responsible for the architecture and programming of server side application integration for client’s various projects using Java/J2EE.
• Installed ReportNet1.1 Cognos Series 7.3 and 7.1 MR2 Version on Multiple Production and Development environments.
• Upgraded Cognos Impromptu Reports and Cubes from 6.0 and 7.0 to 7.1.
• Worked on the Framework Manager to develop the Models and published packages to the ReportNet Server.
• Conversion of existing Impromptu Reports to Report studio Reports.
• Configuring and Maintenance of Cognos Server Administration and Monitoring the daily cube builds and reports.
• Created the catalogs for the users and managing & testing of catalogs with Cognos Impromptu.
• Created the reports/dashboards for sales of the different products for different regions and demands for future forecasting.
• Used Cognos Transformer to build multidimensional cubes and used it in Cognos Power Play to build graphs and charts of sales data.
• Performance tuned power cubes to reduce calc time and partitioned cubes.
• Worked closely with developers to ensure platform defects were correctly identified, fixed and incorporated into future releases.
• Conducted full end-to-end testing of product patches before releasing patches to the client.
• Involved in analysis, design, development, testing and implementation of Informatica transformations and workflows for extracting the data from multiple sources.
• Used debugger to test the mapping and fixed the bugs.
• Executed sessions, both sequential and concurrent for efficient execution of mappings with other tasks like event wait, event raise, email, pre/post SQL.
• Used session partitions, dynamic cache memory and index cache to improve performance.
• Used Perl and Unix scripting to format feeds.
• Designed and performance tuned the SQL queries against data warehouse in Oracle and MS SQL Server 2000/2005. Wrote T-SQL and PL/SQL procedures.