SUMMARY

• Creative and detail focused BI/Database and Reporting Analyst with over 10 years practical, results - oriented experience in Pharmaceutical, Telecommunications, Hospitals, Utility and Insurance industries.
• Demonstrated success analyzing, designing, developing and implementing database solutions which improved business functionality by providing timely and accurate information.
• Experienced of SQL Server 2012/2014, Oracle 11g/12c PL/SQL, MySQL, MS-Access and Firebird.
• Knowledge of Data Analysis, Data Modeling, Normalization, Data warehouse, ETL (SSIS) and report writing using SSRS and Excel.
• Experienced creating SSIS packages, Scripts for data load (Text, Excel, XML) and OLAP cubes using SSAS.
• Detail oriented with strong problem-solving skills, strong work ethic and excellent communication, interpersonal and teamwork skills.

TECHNICAL SKILLS

Languages: TSQL, PL/SQL, MDX, .NET, C#, JavaScript, HTML, XML, XMLA, CSS

Databases: MS SQL Server 2012/2014 and Services (SSIS, SSAS, SSRS), MS-Access, Oracle 11g/12c

Platforms: Windows Server 2012, Linux, IIS 6/7, Apache

Tools: Visual Studio 2015/2017, OBIEE, Metric3D, TFS, MS-Office, Power Pivot, MicroStrategy

PROFESSIONAL EXPERIENCE

Database Developer

Confidential

Responsibilities:

• Completed a Project to upload Insurance Agents (Address, Contract Details, License and Education), Agencies, Districts and Regional Managers details, remotely download from SPTP site in XML format.
• Developed database and staging tables to load XML data using SSIS package and generate reports using SSRS
• Completed Project to mapped insurance Policy details according ACORD (Association for Cooperative Operations Research and Development), developed Database, tables, stored procedures and SSIS package to generate XML files
• Developed new and update existing Tables, Views, Stored Procedures, Traces, SQL Job Agents and Alerts in SQL Server 2012
• Developed Pivot table reports in Excel, ad hoc queries and other tasks as assigned

Tools and technologies: SQL Server 2012, Visual Studio 2015/2017, TFS, SSIS, SSRS, C#, WinSCP, PowerShell

QA - BI - Data Analyst

Confidential

Responsibilities:

• Resolved and troubleshoot data quality and data load issues by developing SSIS packages and views (TSQL & PL/SQL) to upload data extracted from Meditech and HL7 into data warehouse for hospital systems that further load into BI Tool (Metrics3D) for Analysis and Reporting.
• Created 128 indicators for hospital daily DART (Daily Access Report Tool) report for admitted, discharged and transferred patients in the emergency department, migrated from Excel to BI Tool.
• Developed Hospital Porting system implementing Star schema using SSAS in Visual Studio 2015, Developed dimensions, fact tables, OLAP cubes and reports in Excel using SQL Profiler and OLAP Pivot table extension.
• Worked on QA, business analysis, application installations, UAT (User Acceptance Test), Translations (English, French, Urdu) and documentations.
• Created reports, benchmarks and dashboard in BI tools.
• Installed and tested creating cubes using OBIEE and Analytical Work space Manager for Oracle 12c for digital imaging client in USA.

Tools and technologies: Mirth, SQL Server 2012/2014, SSIS, SSAS, Oracle 11g, Firebird, Metric3D, Windows Server 2008, MS-Office, XMLA, TFS (Team Foundation Server).

Database/Reporting Analyst

Confidential

Responsibilities:

• Analyzed and documented business logic of existing application and re-designed and developed new application using MS-Access 2010 to upload billing data into SQL server
• Designed a data-mart for rental customers to store various data feeds received from external sources that can be used to analyze information and produce reports for operational and financial valuation purposes.
• Developed Reporting system in SQL server to generate the projected and actual revenue collected through monthly billing for over 1.4 million water heater customers.

Tools and technologies: SQL Server 2008, SQL Server Management Studio 2005, SSIS, MS-Access 2010, MS Office 2010

Database Analyst

Confidential

Responsibilities:

• Administered SQL Server database, Upload daily/weekly data from various departments received in csv file, Administered SharePoint 2010 site and developed centralized reports using (SSRS).
• Developed Employee search tools in MS-Access 2010 using SQL server tables linked through ODBC connector and provided technical support to team members.
• Effectively analyzed user requirements for reports and queries, worked with team of two system analysts on process improvement of new hiring within the Organization.

Tools and technologies: SQL Server 2008, SQL Server Management Studio 2005, SSIS, PeopleSoft, Taleo, MS-Access 2007/2010, MS Office 2010, SharePoint 2010, Visual Studio 2005

Programmer Analyst

Confidential

Responsibilities:

• Developed customized software and supported relational database applications, to reduce manual data entry and create efficiencies using MS-Access forms and web applications, data migrated MS-Access to MySQL.
• Designed various web portals for medical and retail clients to collect data in real time from centralized database, allowing clients to generate customized reports using Open source software Linux, apache, MySQL, PHP.
• Developed CRM (Customer Relationship Management) portal for Executive and corporate clients

Tools and technologies: MS-Access 2007, MS-Office 2007, Visual Basic 6, Linux (Fedora), Apache, PHP, JavaScript, MySQL, MySQL Workbench, Microsoft MapPoint, Power point