Data Analyst

Sireesh V

E-Mail: *******@**********.***

Phone: 248-***-****

Professional Summary:

Innovative and resourceful professional with around 16+ years of IT experience in Software Development Life Cycle with strong communication, interpersonal and organizational skills

Industry experience includes Health Insurance, Finance, Health Care, Web Portal Development, Retail and Manufacturing

Current position is with Health Insurance and working on Data Quality Issues

Worked with Advance Team as a Data SME, planning for upcoming sprints, performing data analysis, getting requirements, preparing the Business Requirement Documents, providing them to Development team

Skills include analysis, design, testing, and deployment of systems with exceptional abilities in support and maintenance

Worked on various technologies/plat forms such as ASP, MS Access, MS Excel, VBA, SQL Server, Impala/HUE, Business Objects, Tableau, Crystal Reports, Visual Basic, SharePoint and Oracle

Strong experience in Business and Data Analysis, Data Profiling, Data Migration and Metadata Management Service

Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities

Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way

Analysis and review of Software and Business Requirement Documents

Written Several VBA macro programs in both MS Excel and MS Access platforms as part of data analysis

Designed and developed application for fetching data, perform Analytical processing, perform several complex calculations and presenting the data in custom format using VBA

Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL

Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams

Developed and Performed execution of Test Scripts manually to verify the expected results

Excellent communicator focused on customer service

Ability to understand current business processes and implement efficient business process.

Strong background in creating support documentation

TECHNICAL SKILLS:

Operating Systems : Windows 95/98/NT/2000/XP/7/8/10, UNIX and MS-DOS

Programming : Java, C++, C and COBOL

Database : MS –Access 2013/2010/2007/2003, SQL Server 2000/2005/2008/2014,

Oracle 11G

GUI : Visual Basic 6.0, VBA

Internet Tools : ASP, HTML and Java Script

Web Servers : IIS, JWS and PWS

Methodologies : OOA/OOD

Others : SharePoint 2010, Microsoft Office Tools (Excel 2013/2010/2007/2003/97)

Business Intelligence: Alation, Tableau, Business Objects 6.5/XI/XIR2/XI 3.1, Micro Strategy 9.30, SSIS, Impala/HUE Environment

Security Tools : HP Fortify Suite, Web Inspect 9.30/10.0/10.1/10.2

Blue Cross Blue Shield of Michigan, Detroit, MI Oct 2019 – Till Date

Sr. Data/Business Analyst

BCBS is a nonprofit mutual insurance company founded in 1939, it is the largest health insurer in Michigan, serving 4.5 million people in Michigan and 1.6 million more in other states, The largest network of doctors and hospitals in Michigan. BCBS is an independent licensee of the Blue Cross and Blue Shield Association.

Responsibilities:

Working with Data Quality Team to work on fixing the data issues that were identified

Create and supply a data set appropriate to the user’s targeted analysis to allow the user to perform a self-analysis.

Identifying the root cause for the Data Quality Issue, re constructing the same scenario, if an issue is identified Work with team Leader for documenting the reason and proposed solution

Creating a Process Implementation plan for the proposed solution

Involved in comparing datasets from Production Vs Test Environments, data from Multiple Sources

Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.

Writing Custom SQL Queries in HUE Environment on Impala Editor

Creating Test Cases for data validation on two different environments

Researching the Provided Source to Target Documents, Understanding the underlying logic and creating a Write Up for the Data Quality Issues raised.

Environment: Excel 2013, Oracle 11G, Alation, Windows 10, Informatica

Fannie Mae, Herndon, VA Jun 2016 – Sep 2019

Sr. Data/Business Analyst

Fannie Mae is a leader in providing housing finance for homebuyers and renters in the United States., their main goal is to make sure that homeowners, homebuyers and renters across the country have access to affordable financing opportunities. They provide their customers with products and tools they need to enable mortgage lending in the 21st century. They provide technology and risk tools to help their customers advance their businesses.

Responsibilities:

Involved in Run existing and Develop New End User Computing tools, later worked on migrating these tools to a higher environment

Worked as a member of Advance Team as Data Subject Matter Expert

Involved in migrating several End User Computing tools to .Net Environment

Involved in comparing datasets from Production Vs Test Environments, data from Multiple Sources

Highly involved in creating complex SQL queries

Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issue

Involved in writing Business Requirement Documents, getting sign off from end users, providing BRD’s to Development team

Involved in Metrics reporting, data mining, data modeling, business intelligence gathering

Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule

Worked with end users to gain an understanding of information and core data concepts behind their business

Written SQL scripts to test the mappings and to ensure any Change Control in requirements leads to test case update.

Worked in importing and cleansing of data from various sources like Oracle, flat files, SQL Server with high volume data

Developed front end on MS Access which in turn fetches data from Linked tables which are connected to various ODBC sources

Worked with Excel Pivot tables

Identify & record defects with required information for issue to be reproduced by development team.

Responsible for different Data mapping activities from Source systems

Perform data reconciliation between integrated systems.

Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding

Responsible to understand and train others on the enhancements or new features developed

Performing data management projects and fulfilling ad-hoc requests according to user

Environment: SSIS, Microsoft Access 2013, VBA, Excel 2013, SQL Server 2014, Oracle, Tableau, Business Objects, Windows 10

HP Inc., Houston, TX Jul 2015 – May 2016

Sr. Analyst/Developer

The Hewlett-Packard Company (HP) is an American global information technology company headquartered in Palo Alto, California, United States. It develops and provides a wide variety of hardware components as well as software and related services to consumers, small- and medium-sized businesses (SMBs) and large enterprises, including customers in the government, health and education sectors.

Responsibilities:

Gathering the reporting requirements from the Business Users, document them, analyze, design, test and implement the reports.

Analyze and prepare necessary reports for the WIB database

Used excel sheet, flat files, CSV files to generate Tableau adhoc reports

Extensively used SQL queries, Views with several joins

Documented the whole process including the Process definition with flowcharts, User Manual, Possible Future changes, settings

Involved in writing, executing MDX Queries and MDX functions

Involved in developing Dashboards using VBA button to generate reports on press of a button

Gathering business and Technical requirements that would best suit the needs of the technical architectural development process

Queried the databases, wrote test validation scripts and performed the System testing

Worked with the users to do the User Acceptance Testing (UAT)

Designed and implemented report layouts according to reporting standards of the department

Worked with Technical Experts to Improve Report Performance and performed System testing

Environment: Tableau, Microsoft Access 2013, SharePoint 2010, VBA, Excel 2013, SQL Server 2014, Windows 7

Meijer Inc., Grand Rapids, MI Jul 2014 – Jun 2015

Sr. Analyst/Developer

Meijer, Inc. is a regional Supermarket chain founded in 1934, Meijer is credited with pioneering the modern supercenter concept in 1962, With more than 200 stores in Michigan, Illinois, Indiana, Ohio, Kentucky and Wisconsin.

Responsibilities:

Gathering the reporting requirements from the Business Users, document them, analyze, design, test and implement the reports.

Worked Parallel with Business Users for resolving the day to day common issues

Involved in coordination with Tech Lead, DBA's, Developers, QA/QC Analysts during the design phase

Worked with Microstrategy Office to extract report data into the Excel sheets

Redesigned and automated the Assortment Planning tool

Redesigned and automated the process of EndCaps tool, the process to avoid downloading of 24 excel reports into a single press of button

Worked from scratch for the automation of EndCaps planning tool

Extensively used VBA to perform several complex calculations

Created adhoc reports to users in Tableau by connecting various data sources.

Used excel sheet, flat files, CSV files to generated Tableau adhoc reports

Extensively used SQL queries with several joins between the Tabs in the same Excel Sheet

Documented the whole process including the Process definition with flowcharts, User Manual, Possible Future changes, settings

Worked on Pivot Tables with large volume of data using Data Cubes and SSAS

Proficient in writing, executing MDX Queries and MDX functions

Extensively used Index, Match and VLOOKUP functions wherever necessary on large volumes of data

Developed Dashboards using VBA button to generate reports on press of a button

Environment: Microstrategy office 9.3,Tableau, Microsoft Access 2013, SharePoint 2010, VBA, Excel 2013, Power BI, SQL Server 2008, Teradata, Windows 7

General Motors, Detroit, MI Jun 2010 – Jun 2014

Sr. Application Developer/Analyst

General Motors and its partners produce vehicles in 30 countries, and the company has leadership positions in the world's largest and fastest-growing automotive markets. GM, its subsidiaries and joint venture entities sell vehicles under the Chevrolet, Cadillac, Baojun, Buick, GMC, Holden, Jiefang, Opel, Vauxhall and Wuling brands.

Responsibilities:

Gathering the requirements and implement the new requirements for the reporting process

Downloading the Scanning results for the 1100 applications daily and run macros to update the SharePoint with the latest scan results using VBA and MS Access Queries

Uploading the same data to Database and produce various trending reports

Generated several Reports out of SharePoint Lists, MS Access Database, Excel Sheets, CSV’s using MS-Access and Excel Macros wherever necessary

Extensively used SharePoint lists to represent the data through out all the regions

Generated several Pivot Tables in Excel by using the SharePoint as back end and using Power BI Pivot Tables and Power Query

Generated Several Reports from Excel and Access Macros and updating the GM management reports

Provide Reports for support, guidance for Security Leads, IT Managers

Involved generating reports using custom built queries from in SQL Server using SQL Server Management Studio.

Providing Ad hoc Reports from various people like IT Owners, Business owners, Suppliers etc.

Global Point of contact for WAS Metrics reporting

Ensure the metrics are accurate and up to date and implement day to day changes like prepare Custom WAS reports on request

Generate pictorial views in the form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard.

Involved in Cross Checking the Calculations from the report with Manual calculations against the database and was involved in development of Test Cases

Preparing Estimated Invoices for Finance Group, reconciling the approved Invoices with Finance group

Supporting the technical needs of SharePoint lists, WAS Metrics

Creating SharePoint Lists, Custom views for the list, adding additional columns, calculated columns and SharePoint administration.

Environment: Microsoft Access 2013, SharePoint 2010, VBA, Excel 2013, Power BI, SQL Server 2008, Windows 2008, HP Fortify Tool Suite, VISIO

RR Donnelly, Downers Grove, IL Sep 2007 – Jun 2010

Sr. Developer

RR Donnelley is the world's premier full-service provider of print and related services, including document-based business process outsourcing. The largest companies in the world and others rely on RR Donnelley's scale, scope and insight through a comprehensive range of web-based tools and innovative technology, variable printing services, market-specific, and customized supply chain solutions. Duties include development of the Database for Aetna Billing & Reporting

Responsibilities:

Built the entire database for the Aetna Reporting from the given project specifications

Developed User Interface in a friendly manner to obtain the reports by a single button press.

Involved in writing several SQL Queries to update the Target Tables according to fulfill the business implementation.

Developed the DB to merge data from SQL Server using Linked Tables and from Excel Sheets, “.CSV” files (from Main Frames).

Developed Access Macros using VBA to upload data from Excel sheets into Respective tables

Developed Excel Macros to modify the data that is received from Custom Point to fit into the Aetna Reporting

Used Link tables from SQL Server for Louise Detail Reporting

Analyzed business requirements and developed custom Access reports and queries for the RRD_D.csv & Louise_D.csv Import files.

Developed several MS Access Reports for the Custom Point

Involved in creation of Pivot Tables and Pivot Charts

Developed set of several complex new reports for new ware house that start operations at Temecula, CA

Worked on adding new warehouse codes and implemented the changes in common reports and thus recalculating all financial reports which are linked with WHS production.

Worked on various invoice reports to implement a new “Binding Charge” for all three ware houses.

Developed several complex reports such as Kit Machine Units, Kit Hand Units and Inkjet Units for all the three warehouses.

Developed Few reports in Business Objects XI 3.1

Environment: Microsoft Access 2007, Business Objects 6.5/XI 3.1, Microsoft Excel 2007, Visual Basic 6.0, Oracle 10g and SQL Server 2005, Windows 2000

EDS, Detroit, MI Sep 2006 – Aug 2007

Sr. Developer

Fulfilling the requirements for Global Lease Financial Management System. This application is for consolidating all the lease financial transactions that occur every month. The process involves collection of data from all the regions and upload into the Global Database for the Monthly Financial Reports.

Responsibilities:

Worked as production Support for all the Regions (GMNA, GMAP, GME & GMLAAM).

Developed PL/SQL Stored Procedures to perform Complex Calculations, Lease Transaction Report, Cash Flow Reports.

Developed sever complex reports including Pipeline Report, Lease Transaction Report, Cash Flow Report, Lease Extend / Buyout Report etc

Worked on fine tuning the Queries to fulfill the report requirements.

Worked Parallel with Business Users and Project Leads of Various Regions

Modified the Report Queries every month to fulfill the Business Users Requirements

Modified the relationships by removing unnecessary tables for faster access of data.

Developed complex report that consolidates all regions Lease Transaction Report.

Updated several existing reports to reflect the Forex changes.

Developed Lease Expenses Forecast Report that helps to analyze the future expenses.

Developed several complex financial reports for Global Lease Management System.

Developed a new version of database, with production tables residing on the Server and the all the intermediate tables on the Client PC.

Involved in full documentation of the whole database including the Process definition, monthly report generation, Monthly Report Consolidation for storing them in e-Room Facility.

Environment: Microsoft Access 2003, Business Objects 6.5, Microsoft Excel, Visual Basic 6.0, Oracle 10g and SQL Server 2000, Windows 2000

Valassis Communications, Livonia, MI Apr 2005 – Sep 2006

Sr. Developer

Fulfilling the requirements for OPS (Order Placement System), a Valassis application that initiates the Insertion Order process for newspaper or magazine delivered products. This Application is for the data entry by the Sampling users to enter the data for insertion order process.

Responsibilities:

Responsible for development and integration of many querying and reporting functions for a multitude of system users and clients.

Involved in Business meetings to gather the requirements for the new application.

Analyzed client requirements and developed custom reports and queries.

Involved in developing the ASP application for the users to enter the security roles for different users using SQL Server as back end.

Involved in creation of Pivot Tables and Pivot Charts for data analysis.

Created Daily reports for billing purposes in MS Access.

Created Weekly reports for the social workers for plan their week ahead.

Created special reports for trends in complications.

Converted existing spreadsheet tracking methods to MS Access.

Created customized MS Access modules, forms and reports to accommodate business rules and methods

Created Mailing list reports in MS Access.

Developed GUI screens for user interface for accessing, searching and manipulation of reports

Environment: Microsoft Access 2003, SQL Server 2000 and Oracle, MS Excel, Visual Basic 6.0, Business Objects 6.1B, IIS, ASP, Windows 2000

Smart Cybermatics Ltd, Hyderabad, India Sep 2003 to Mar 2005

Portal Development (Healthciti.com, Indiahunts.com) & Marketing/Sales Monitoring System

Sr. Programmer Analyst

Involved in total conversion of the project from desktop version to Internet Version.

Redesigned the database to create provision for storing the data for multiple users as the old database supports only single user data.

Developed Interfaces in ASP same as that of in Visual Basic Screens.

Used Java Script extensively for all client side validations whenever necessary.

Developed Online Quiz on Health related topics.

Developed Online Health Calculators using Java Script

Developed facility to update day-to-day health related articles without changing the code.

Developed Access Macros to upload data from Excel sheets into Respective tables.

Developed Excel Macros using VB Scripting for automatic generation of Serial Numbers

Developed web based Key Request System as a part of Software Key requests, which monitors how many key requests the user, has placed.

Developed Online Shopping Facility for the software products

Involved in integrating the code for Credit Card payment authorization through 2checkout.com.

Developed the Log creation for the users for whatever the pages they visit once they login to the portal.

Developed the facility for the administrator to Enable/Disable the User profile, extend his validity date, reset the User password, and reset the user’s personal details.

Developed the batch creation facility for prepaid licenses.

Developed web pages in ASP.

Used Java Script extensively for all client side validations whenever necessary.

Involved in Front End Design of Job Seeker & Employer Pages

Developed the facility for employer for posting of Jobs.

Involved in development of Control Panel for Administration of the total portal.

Developed the facility for the Administrator to view/change the users profile

Developed the facility for upgrading the Employer to a higher level or downgrade to a lower level.

Developed the facility for employer for Searching a User who is having a certain skill set.

Developed the facility for Job Seeker for searching of jobs availability

Developed the facility for Administrator for view the Job Seekers & Employers page wise

Responsibilities:

Environment: ASP, MS Access, MS Excel, Visual Basic 6.0, Crystal Reports SQL Server 7, IIS and Windows 2000

Education: Master’s in Computer Applications (B-LEVEL from DOEACC)

Contact this candidate