Data Analyst Developer
Resume:
Vijaya Anirudhran
Address: ***** ******* *******
Frisco, TX 75035
Cell : 248-***-****
Email : ************@*****.***
Professional Profile
BI Analyst
Demonstrated achiever with more than 10+ years of experience in Business Intelligence using WebFocus,DB2, Oracle, SQL, MS Access & Excel. strong analytical and problem-solving skills, the ability to provide data analysis and documentation, work independently and to prioritize and meet deadlines, effective verbal communication and writing skills, and very strong programming and database skills. Experience with Information Builder’s WebFocus reporting tools, WebFocus server, WebFocus Maintain, Report Caster and Developer Studio environment is a definite plus.
My development work is driven by business value, usability and maintainability with a specialization in user interface and creating application. I also have experience in training, supervision and technical support.
My top achievements include
1.Reports design and development for a community college
2.Reports design and development for a Distributor/Warehouse
3.Systems administration of the Webfocus BI Environment including Reportcaster, Dashboard/Portal
4.Vendor engagement to solve issues
5.Customer interactions to obtain requirements and fulfill customer needs for BI reporting
6.Healthcare Data Analyst –Created Reports, dashboards and fixing and maintaining existing dashboards and reports.
Strengths
●SQL Development
●Analyzing business data to gain insights
●Business Intelligence
●Reports development
●Systems Administration
Skills
●Oracle, MSSQL, DB2 Development
●BI Reports Design and development
●Webfocus environment administration
●BI dashboards and portal development
●Javascript, Focus Script, PL/SQL, SQL.
Vijaya Anirudhran
Work Experience
Federal Deposit Insurance Corporation - FDIC (Nfinity LLC) – Dallas, Texas (August-2019 - Present)
Role: Financial Reporting Analyst
●Created Webfocus reports (8.105) –The report contains date logic - it will pull data one month previous and 2-month previous data. Also added dynamic heading, dynamic title.
●Created launch fexes, created containers and added fexes to the HTML page and included menu items.
●Added code to get Top 5 selection in the Graph.
●Added code to show X-axis label all the 12months in the graph.
●Run Reportcaster schedules manually Every month around 100 schedules upon month end close - Monthly, Weekly and OnDemand.
●Testing Environment: WebFocus 8207
● Created a Portal in WF 8207,Created reports with Drilldown capabilities and created charts will give the results depend on user selection on the filters.
BlueCross BlueShield of Michigan-Detroit, Michigan (July-2017 - May-2019)
Role: HealthCare Data Analyst
Some of my recent key Activities:
●Created Webfocus UM (Utilization management) Dynamic Dashboard using Webfocus Version 8.201 BI Portal- Created Reports, Split Charts, 3 Periods of time Frame and drill down capabilities. The Dashboard has all about Commercial and Medicare, HMO, PPO and gives the user selection option filter by Region, State, Customer and Segment.
●Maintaining the other existing dashboards and fixing maintaining existing reports.
●Implemented reportcaster bursting futures in the existing reports and automatically update the ReportLibrary and send email options in excel and FTP to Share Drive.
●Provider Organization report created for all the Health providers.
Technologies Used
●MS SQL : T-SQL based queries and stored procedures for generating Fact and Dimension Tables.
●WebFocus Reports: Creation and generation of reports, interactive dashboards to help derive business insights.
●Jira- Agile methodology projects- 3 weeks Sprint. Creating project and finishing task by follow agile method.
●Tableau Reports- Created reports and charts in Tableau Visualization.
●R and Python- we are currently moving to R, Python, Hue, and Hive for Cloud based data analytics and Reporting.
●AWS(Amazon Web Services): Deploying Data to AWS based cloud database and connected to R and PYTHON using Tableau.
Lipari Foods - Warren, MI 48089 (April-2016 - June-2017)
Role: System Admin and BI developer
Some of my recent key Activities:
●Created Webfocus user Dashboard using Webfocus Version 8.105 BI Portal- Created this Webfocus User Activity dashboard- It has three pages. This first page on the dashboard provide user login information who currently login into the server. The second page gives the reports users access from the server and last the page of the dashboard is Reportcaster daily automated distribution list to the users.
●Also maintaining the other sales dashboards and fixing maintaining existing reports.
●We have currently maintaining thousands of Reportcaster schedule running and creating new schedules upon new requests.
●Creating new Reports upon Users Requests.
●Created Excel Metadata and created synonym for the requested users reports.
●Created synonym upon users needed.
●Upgraded latest server with IBI support on the server.
Major Achievements
●Design and building dashboards and reports
●System administration
Technologies Used
●DB2 SQL: SQL based queries and stored procedures for generating Fact and Dimension Tables.
●WebFocus Reports: Creation and generation of reports, interactive dashboards to help derive business insights. .
●Tableau Reports- Created reports and charts in Tableau Visualization to showcase POC
●AS 400: Interacted with DB2 on AS 400 to get to the database for Fact and Dimension tables
Henry Ford Community College - Dearborn, Michigan (Enertron LLC) ( April - 2004 – April -2010 )
Role: System Admin and BI developer
Some of my recent key Activities:
Develop new programs and support existing programs using IBI WebFocus Developer Studio with a SQL or Oracle database backend.
●Created Student Enrollment Report, Financial Reports & Class Roster Reports for Faculty using IBI WebFocus Developer Studio with Oracle database backend.
●Created Metadata (Synonyms) based on Oracle & SQL Tables.
●Created web-based application using WebFocus Maintain tool, the application allow the user to create, update, and delete the student information in the databases (SQL & Oracle).
●Scheduling and distributing reports to faculty via email through WebFocus Report Caster.
●Installed WebFocus server version (7.6.2) and installing patches, upgrades and migration.
●Assist in maintaining and monitoring WebFocus groups, domains, and security.
●Maintain a good working knowledge of IBI WebFocus Developer Studio and Maintain applications to assist users and team members when necessary.
●Provide timely and effective front line systems support to our customer base.
●Meet with users to determine their needs and to identify solutions to their problems.
●Approach problems objectively and present findings, conclusions and recommendations clearly.
●Create and maintain user and technical documentation for new or modified programs
●Prioritize work requests based on need and time deadlines.
●Ability to work in a self-directed work environment and the ability to work in a team environment
●Strong analytical and problem solving skills for design, creation and testing of programs
●Strong communication skills to interact with team members, support personnel, and provide technical guidance and expertise to customers and management
●Assist in training staff, co-op students, and team members on WebFocus Developer Studio and WebFocus Maintain.
●Reports development
●Integration with the school’s Emergency Alert System
Database Administration and Development
Major Achievements
●Reports design and development
●System administration of Webfocus environment
Technologies Used
●Oracle PL/SQL, SQL: SQL based queries and stored procedures for generating Fact and Dimension Tables.
●WebFocus Reports: Creation and generation of reports, interactive dashboards to help derive business insights.
Education
●Associate in Computers and information Systems, Henry Ford Community College – Dearborn, Michigan USA
●Bachelor of Arts – English Major, Vellalar College, India
●Certificate in java programming – NIIT, India
Technical Expertise
●Javascript
●Focus Code
●Webfocus – Dashboard, ReportCaster, Portal
●Oracle Database – 11G, 12C
●MSSQL -2012
●Microsoft Access and Excel
●Tableau BI
●Software Development Lifecycle (Development, Testing, Debugging, Release management)
Contact this candidate