Lead BI Application Developer
Humana Inc
- Current
- Understand Problem Statement and Formulate viable solution for various internal cross functional teams
- Analyzing large sets of structured and unstructured data to identify patterns and trends
- Develop and maintain Dashboards in QlikView and Qlik Sense for multiple cross functional teams
- Maintains NPrinting TEST/Production Servers
- Successfully used NPrinting in multiple projects
- Developed script to capture Excel files from S3 Bucket to Data base
- Applying advanced querying and data manipulation algorithms using SQL, QlikView and Qlik Sense to claims and geographical data and deploying functional BI dashboards
- Involves in data modelling and create Entity Relational ship (ER) diagrams (physical and logical) using Erwin data modeler tool for Advisor and Marketing domains
- Revises current systems and procedures to correct deficiencies and maintain more effective data handling, conversion, and input/output requirements
- Developed and maintained scripts for various tasks in SQL Server Integration Services (SSIS) packages
- Developed and modified stored procedures to load data from Source system landing into staging Database
- Designed and developed SQL Server Integration Services (SSIS) packages to move data-to-Data Vault Domains from Source Database
- Developed Weekly, Monthly and Quarterly scripts to fetch only latest records from extracted Data
- Good at writing MDX queries to access cubes data in SSAS
- Created SQL datasets for Power BI and Ad-hoc Reports
- Expertise in creating Qlik Apps
- Strong experience in Performance optimization
- Expertise in QlikView and Qlik Sense Extensions
- Expertise in Qlik APIs and building custom solutions
- Rewrote code from Informatica to SQL Server Integration Services to migrate data
- Fine-tuned existing queries to improve performance utilizing SQL Profiler and Execution Plans
- Co-ordinated with team and customer for QA, UAT and Production movement after post development
- Attended regular status meetings with team, performed code reviews and mentored team members
- Deployed development work through CI/CD pipeline
- Good hands-on experience on Workday data and building visualizations
- Worked with AWS team to implement Lambda scripting to automate files from folders to Database
- Migrate BMT (Business Management Tool) from Apptio reporting Technology to Qlik Sense
- Created API Queries to fetch data from Apptio report, Service Now
- Extensively worked with Qlik Sense functions, objects, Set Analysis, Variables to generate distinct kinds of charts
- Also generated QVD files by writing scripts in QlikSense applications
- Good hands-on experience in SQL queries to validate API and DB data
- Worked as SQL/Java Developer and establish strong relationships with end users and technical resources throughout established projects
- Work closely with development team to provide support for database objects (stored procedures/triggers/views) and performing code review
- SQL Server Developer will work closely with Application Developers to ensure proper design and implementation of database systems
- Database administration including performance monitoring, access management and storage management
- Create, develop, and maintain SQL processes for channel performance data warehousing
- Actively working with development manager and onsite team to deliver solutions
- Generate daily/weekly/monthly sellout report on daily basis
- Worked independently in building Self-service template for users
- So that it can reload data sources per user requirement without any need for load script
- Support Business Strategy and planning team technically and operationally
- Working with migration team in migrating Qlik to Power BI
- Responsible for creating SQL datasets for Power BI and Ad-hoc Reports
- Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI and SSAS
- Used DAX (Data Analysis Expressions) functions for creation of calculations and measures in Tabular Models.
