OBJECTIVE
- To obtain a challenging position that allows to work as BI Consultant where I can utilize my diverse experience of Business Intelligence Application Development and Reporting
SUMMARY
- More than 14 years of IT industry experience in analysis, design, testing, development and Implementation of Data Warehouse, BI applications
- Around 5 years of Automobile Industry Experience.
- Over 10 years of experience in Banking domain
- Over 10+ years of experience in designing, development and deployment of Data Warehousing and Business Intelligence applications using Power BI, COGNOS 8/10, Tableau SAP BW/BI
- Extensive experience working as Power BI Developer and Analyst in Enterprise Environment.
- Design, Developing and publishing rich and intuitively interactive Power BI reports
- Extensive experience working in an Agile development environment
- Participated in designing and development of software using agile development practices
- Expert in creating different Visualizations using Bars, lines, pipe etc charts
- Worked in United Kingdom for 2 years, U.S over 1 year and Canada for the last 7 years
- Development Lead and Certified Senior Cognos Consultant, Developer with Requirement Analysis, Design, Development, Testing, Performance tuning and Support expertise
- Working knowledge on Management and Administration of AWS Services CLI, EC2, VPC, S3, ELB Glacier, IAM, Built a VPC, established the site - to- site VPN connection between Data Center and AWS .
- Experience in design and development of ETL (Extract, transform, load) processes, and validating data sources.
- Knowledge and experience on Active Directory Federation Service
- Working knowledge in Automating, Configuring and deploying instances on AWS, Data centers, also familiar with EC2, Cloud watch, Cloud Formation and managing security groups on AWS.
- Enabling role-based security in the reports; restricting access to information
- Experience in SAP BW and Hana Studio including Extraction and Modeling of creating views, Composite Provider, ODS, Infocube, Master data etc. Open ODS View and ADSO
- BI (Reporting and Analysis) Tools: Business Explorer (BEx) Query Designer, Web Application Designer, BEx Analyzer, Web Analyzer, BEx Report Designer
- Experience in HANA, creation of Attribute views, Analytical views, calculation views along with import and exporting models
- Reporting and OLAP solutions with Cognos 10, Cognos 8 BI Suite Cognos Series 7
- Expertise in developing web based applications using ASP.Net, VB.Net, C#, ASP, JavaScript, VBScript, XML and HTML, Cascading Style Sheets (CSS)
- Strong Object Oriented Programming development experience
- Well Versed with Star & Snow Flake Schemas
- Strong verbal and written communication skills that make me valuable for gathering client business requirements and leading development team
- Executive-level reporting, analysis, and presentation experience
- Well-organized, self-motivated, adaptable, quick learner, independent and good team player.
- Confidential Certified Developer - Cognos 10 BI Metadata Models
PROFESSIONAL EXPERIENCE
Report Applications: Crystal Reports 9
OLAP Tools: Cognos 7.3/8.3, Cognos 10.2, transformer, Cognos ReportNet1.1, TM1
Cloud Platform: Amazon Web Services (AWS), Azure; Synapse
Internet Tool: Front Page 2000
Script Language : Java Script, VB Script, HTML, DHTML, XML, CSS
Markup Languages: HTML, XML, Python
Database Applications: SQL Server 7.0/2000, Oracle 8i, PL/SQL, DB2, Netezza, MS-Access
Business Intelligence: SAP Business Objects BI Platform 4.2, Informatica7.1 SAP Lumira, WEBI, HANA 2.3
Operating Systems: MS-Windows 95/98/NT/2000/XP, UNIX
Source Control systems: Clear Case, Clear Quest, VSS
Other Tools: Visio, Manage now, Service Now, HP ALM
PROFESSIONAL EXPERIENCE
Confidential
BI Tech Lead, Consultant
Responsibilities:
- Worked as Lead developer at Confidential for Confidential
- As part of International banking team, developed dash board, reports in power bi
- Migrated some of the reports from Cognos to Power BI
- Creating Dashboards, reports and moving them to PRD env.
- Worked with Power BI service, Report Server
- Designed best and optimized model based on available env.
- Developed direct query and import query reports
- Involved in UAT with Costa Rica, Panama teams
- Involved in moving data from Enterprise data lake (EDL), Synapse to Postgres for Reporting tables
- Worked with Power BI service, custom visualizations,
Confidential
BI Tech Lead/Developer
Responsibilities:
- Worked as Lead Consultant at IS Dept of Confidential Canada Inc.
- Migrated some of the self-service and adhoc reports to Power BI and in Cognos
- Extensively worked on reports development using Agile process
- Used SCRUM for Agile development and participated in team lead activities
- Created Dax Queries to generate meaningful reports
- Designed and implemented multiple dashboards using Power BI - Report server, service
- Used data blending feature to generate some of the reports in Cognos
- Developed Power BI Visuals including Tree map, Funnel, Line Chart
- Worked on DAX Functions and usages
- Developed chart, grid, table reports in Cognos for one of the requirements.
- Involved in migration of some of the reports to SAP BOBJ environment
- Implemented security features of Cognos like row level, object level and report level to make the data secure.
- Created complex reports using reporter module in Desktop/Web Intelligence functionalities like Slice and Dice, Drill Down, Functions, Cross Tabs, Master/Detail, and Formula
- Support in running monthly jobs, Developed Relational/Dimensional data models
- Interact with various departments to resolve their daily reporting issues in Power BI
- Effort estimations, support user acceptance test of Power BI Reports
- Change ticket implementation, code promotion, Incident, JIRA Ticket management
- Identifying defects and logging them in HP ALM, Track and follow up on defects till closure
Confidential
BI Tech Lead, Consultant
Responsibilities:
- Worked as Technical Lead, Developer for migration of Cognos 7 suite Reports to Cognos 8, and new development
- Followed Agile methodology while developing new reports
- Developed data visualization using cross map, scatter plots
- Developed complex Reports using Functions, calculations
- Developed marketing reports in Cognos
- Used Excel data source for developing Power BI Reports
- Created SQL data model, data loading and tuning
- Involved in various card product launch projects
- Gathered requirements from source system and identified the data and reporting requirements
- Involved in data modelling, STAR schema, dimensional model
- Designed transformer models (dimension map, facts (regular/calculated))
- Imported metadata into Framework manager and created the necessary relationships between the objects and designed business model
- Developed metadata model using Framework Manager to upgrade Cognos 7 reports to Cognos 8/10
- Validated and upgraded reports using Life Cycle Manager and Report Upgrade