Highly motivated Business Intelligence Developer with 11+ years of experience in Report Design, Implementation, ETL, Migration, Enhancement with TST and Production environment support for various business application across different domains like Banking, Telecom and Healthcare.
- Cognos BI Report Studio, Analysis Studio and Query Studio, Workspace Advance, Active Reports, Cognos Connection
- DMR/RMR Modeling with Framework Manager
- Cube Modeling with Powerplay Transformer
- TM1 cube, TI Process, Rules, Dimension
- IBM Datstage 8.1
- Microstrategy 8.0
- Client - server configuration between Cognos transformer on Unix and Windows
- Cognos 10 BI Server installation/configuration on windows and Unix
- Business Object XIR2
- Knowledge on Tableau Desktop, Tableau Prep, Tableau Server
- Migration from Cognos 8.4 to Cognos 10.2.1, Cognos 10.2.2.
- Dynamic cube with Cognos cube designer.
- Cognos security through LDAP, Cognos Connection Roles and in Framework manager at object and Package level.
- Report scheduling and administration
- SQL, PL/SQL
- GitHub, Jira, HP QC, SVN
Senior BI Developer
Confidential, New Jersey
- SVN, Jira, Github, Cognos BI, TM1 Architect, Oracle 11g, Toad, HP QC
- Work closely with business users gathering requirment and prepare technical design documents
- Efforts estimation of design, development, testing and deployment of BI reports/cubes
- Development of Daily/MTD/YTD Trading BI reporting solution in Investment Banking using Cognos BI with FM
- Advanced Turbo Integrator scripting
- Rules to apply business rules to a cube
- Participate in peer code reviews
- Responsible for reports and database performance analysis and tuning.
- Provide post implementation level 3 technical support
- Managing offshore and on-site Developement/Support with mentoring new developers
Senior BI Engineer
- SVN, Jira, Cognos BI, Powerplay Transformer, TM1 Perspective, Oracle 11g, Toad, HP QC, Unix
- Debug, monitor and troubleshoot Cognos BI & TM1 Applications solution.
- Collecting Enhancement requirement, preparing tech spec and development of Cognos BI Report and cubes
- Development of Cube views based security on Cube with respect to business requirement
- Worked extensively on creating Models using Framework Manager and publishing package
- Rules application in Cognos TM1 perspective
- BI Dashboards Reports in Report Studio using MDX model from Cube
- Level 3 Support for 14 different Sales Mgmt BI Application
- Migration of Legacy Cognos 10.2.1 IQD based cube model to Cognos 10.2.2 FM Package Based model
- Estimation of migration of 14 Sales Mgmt application from Cognos 8 to Cognos 10.2.2
Senior Software Engineer
- SVN, MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Architect, IBM Datastage 7.5, Oracle 10g, Toad, Unix
- Requirement gathering at onsite with client community on first 3 months. Preparation of tech spec document approval for further design/development
- Daily supervision of each production incidents and delivery in production following version mgmt Tortoise SVN policy.
- Supervision of each documentation followed by client for each production delivery in different tools like gedeon, PVCS PC
- Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite
- Created different Project Sources for different environments like production, testing and development.
- ETL process design in Datastage
- DW Technical knowledge sharing with other technology skilled team to prepare multi skilled resource environment
ETL Datastage Developer
- IBM Datastage 8.1, Sybase ASE, unix Shell Script
- Agile methodology
- Migration from Legacy mainframe to new Data mart using IBM datastage ETL
- Creation of unit test cases and documents.
- Testing newly developed & Enhanced ETL jobs on daily bases
- Unix scripting to run all the module jobs.
BO Report Developer
- Analyzing of the existing crystal reports developed in crystal reports 9 and Finding comparative functionalities in BO
- Creation of documents/Reports for comparative features and work around for different feature available in BO and any alternative solution for road blocks
- Created Sub Reports, Sorting, Group, Suppress, Variable, Drill and Charting.
- Designed Standard List Reports, Cross-tab Reports, Charts, Master-Detail and Drill through Reports
- Test the report at query level as well as report level in client environment using SQL query profiler
Cognos Report Developer
- Migration of 47 Cognos macro report from Cognos 7.2 to Cognos 8.3 with different 11 BI based application
- Existing Cognos Series 7 macro reports study and analysis
- Provide some ad-hoc report using Query studio
- R&D on Cognos Macro and provide support to develop macro using Cognos SDK and Java scripting during migration to support Cognos C7 macro
- Creation of report views with saved prompts and schedule according to the business requirement
- Created PowerPlay Reports by using Analysis Studio