SUMMARY

• Data and Business Intelligence Analyst with more than 8 years of experience supporting data driven systems for transportation, healthcare, industrial and technology organizations.
• Specializes in collecting, analyzing and maintaining business and healthcare data to generate information and reports.
• In - depth knowledge of various Software Development Lifecycle (SDLC) methodologies such as Waterfall, Agile and Scrum.
• Excellent at data modeling, data cleansing, and data profiling.
• 3+ years as MS SQL Server/Business Intelligence developer in designing and developing T-SQL queries, ETL packages, and business reports using SQL Server Reporting Services (SSRS)
• 3+ years as Data Warehouse developer in designing and developing SQL queries, ETL packages, and business reports.
• Expert in creating databases and various SQL server objects like schemas, tables, indexes, indexed view as per the specifications and requirements to meet the business functionality.
• Designed SSIS Packages to extract data from various data sources such as SQL Server, Access database, Excel spreadsheet, xml files and flat files into SQL Server database for further Data Analysis and Reporting.
• Sound knowledge of performance tuning and query optimization.
• Experience creating dashboard for healthcare billing and claim, and managed care monitoring as well as to monitor areas for improvements (AFI), and performance indicators (KPI).
• Excellent at designing and deploying ad-hoc reports and visualizations using various tools such as SSRS, IBM Cognos report, MS Excel, Power Pivot, Crystal report, Tableau desktop, SharePoint.
• An excellent team member with an ability to perform individually and in a team, great interpersonal relationship, good communication skills, hardworking and high level of motivation.
• Proven history of utilizing strong analytical skills, attention to detail, and hard work ethics to turn complex requirements into working systems.

TECHNICAL SKILLS

Languages: Java, JavaScript, C/C++/C#, XML, HTML, VBA, SQL, TSQL, PL/SQL, MDX

Databases: Oracle 10g/11g/12c, Microsoft SQL Server 2008/2012, MS-Access

BI Tools and others: MS BI (SSRS/SSIS/SSAS), MS-Excel, Cognos Report, Tableau, SharePoint, Crystal Report, PowerBI, UML2.5

PROFESSIONAL EXPERIENCE

Business Intelligence Developer

Confidential, IL

Responsibilities:

• Analyzed internal business partner’s requirements and performed data modeling for inventory utilization and productivity systems.
• Managed integration support issues including analysis, mapping, testing, implementation and documentation.
• Designed and developed ETL solutions for equipment and inventory data import into TMT base tables.
• Created reports and scorecards to understand productivity performance by monitoring load efficiency and on-time delivery.
• Utilized analysis results to manage optimal inventory utilization during unexpected demand peaks.

Environment: TMW TMT system, SQL Server (DTS and SSIS), Oracle, SQL, MS Excel, MS PowerPoint, SharePoint 2013, SSRS, XML, SQL

Business Intelligence Analyst

Confidential, Lansing MI

Responsibilities:

• Functioned in a pivotal role in the development and deployment of Enterprise Data Warehouse EDW, Data Marts, and Data Cubes for various modules towards achieving a Value Based Healthcare System.
• Led the integration of data from EHR system and Billing and Claims to facilitate faster submission times and higher first-pass approval percentages.
• Analyzed the performance improvement, with the switch of ICD-10, in clinical processes, cost-effectiveness and outcomes of care and presented the findings in reports.
• Developed analysis reports supporting Billing and Claims processes.
• Utilized Data Warehouse concepts to prepare moderate to complex SQL queries for analysis reports.
• Captured and monitored Slow Changing Dimensions.
• Developed SSIS package using different transformations like Data Conversion, Aggregate, Sort, Union, Merge and applied package configuration and automated deployment.
• Developed visually appealing dashboards to continuously monitor Quality of Care and price paid for it within the context of both internal and external performance benchmarks, and to identify areas most in need of improvement.
• Prepared Dashboards to pin point, monitor and present Key Performance Indicators (KPI’s) of Billing System.
• Performed troubleshooting data issues and reporting issues.
• Learned to foster relationships with internal and external clients to provide solutions which enabled the business units improve operational efficiencies.

Environment: Agile (SCRUM), MS-Excel, MS Visio, HTML, XML, CSS, SQL Server, MSBI, SQL, T-SQL, MS Project, MS PowerPoint, Tableau, Cognos Report, SVN, IBM Rational DOORS

Confidential

LIMS/Database Support Engineer

Responsibilities:

• Played a crucial role and accomplished migration of current LIMS database at three refinery locations from Oracle to SQL Server 2012.
• Organized business requirements into conceptual, logical and physical (OLAP) data warehouse model in STAR SCHEMA.
• Participated in a team to design, develop, test, integrate and support new ETL processes following adherence to industry standards and best practices.
• Developed ETL solutions for Quality Control warehouse implementing several SSIS transforms and data flows.
• Recommended architectural improvements, design solutions and integration solutions.
• Conceptualized the design and built data mart as per the requirements of Operational Planning, Quality Assurance, Process Control and other critical manufacturing units.
• Analyzed Quality Giveaway (QGA) results in product export, prepared custom analysis reports supporting business decisions for product quality certificates, corrosion monitoring, and environmental emission and assisted in reducing losses approximately by US $20 m.
• Utilized PowerPivot models and PowerPivot reports to conduct trend analysis, and published reports onto SharePoint Dashboard.
• Written and managed various technical documents, and overviewed training and mentoring sessions with lab technicians to demonstrate operations of new system.
• Imparted technical assistance to the team on various MS BI stack technologies.

Environment: LIMS, Java, SQL, T-SQL, Oracle10g, SQL Server 2012, MS-Access, MS-Excel, Crystal Reports, MS-Project, SSRS, SSIS, SSAS, Visual Studio, SharePoint 2010

Confidential

.NET Developer

Responsibilities:

• Worked responsibly and actively in a team to design, develop and implement pharmacy database in .NET.
• Coordinated in writing database scripts, stored procedures, triggers, views and functions.
• Developed several cascading style sheets (CSS) for User Interfaces, used HTML, JavaScript and XML for designing controls and web forms using C# and ASP.NET.
• Used ADO.NET objects to connect and update records of underlying SQL Server database.
• Prepared and customized SQL Server Reports and MS Excel reports to monitor drug movement, inventory levels, physician’s prescribing trends etc.
• Involved in all phases such as Analysis, Design, Coding, Testing and Deployment.
• Prepared detail documentation to aid future reference for each module.

Environment: Visual Studio 2005, C#, MVC, ASP.NET 2.0, MS-Access, MS-Excel, JavaScript, HTML, XML, SQL Server 2005

Confidential

Database Engineer

Responsibilities:

• Designed and normalized database from scratch for new Human Resource application.
• Was responsible for collecting user’s requirements and in corporate them into database.
• Developed complex queries, forms, and built macros in VBA to evaluate quarterly employee performance, importing new set targets, trainings and project accomplishments within each department.
• Was responsible for importing/exporting data from pre-existing text files, excel spreadsheets and other databases for monthly reports and management overview reports.
• Administered database modifications, wrote test plans, trained users to test and use new and enhanced system.
• Assisted in configuration, installation and day- to-day maintenance and troubleshooting of new application.

Environment: MS Word, MS Excel, MS Access, VBA, Oracle