SUMMARY:

• Overall 7+ years of experience in Software development, Support and Database development, with focus on MS SQL Server products and Microstrategy and Guidewire Suite (Policy center, billing center and claim center). Responsibilities have included working as a Database Developer, Data Modeler, BI Developer and Data Analyst. Industry experience in HealthCare, Insurance and Manufacturing. Extensive experience in development of Business Intelligence and Database development on several BI tools such as SQL Server, MSBI Suite(SSIS/SSRS/SSAS), Power BI, Microstrategy and Crystal Reports. Possesses strong ability to perform root cause analysis and troubleshoot complex issues. Also experienced in ETL testing and functional Testing.
• Over 7 years of experience in the IT industry with in - depth knowledge of System analysis, requirement gathering and database modeling
• Efficient in analysis, design and development; specialized in business applications & Business Intelligence by utilizing packages like SSIS, SSRS, SSAS, Power BI and Microstrategy
• Strong RDBMS concepts with extensive experience in Microsoft SQL Server 2000/2005/2008/2012 ) technologies and Oracle
• Good understanding of Software Testing tools like QTP, HPQC and test partner as well.
• Strong leadership and communication skills.
• Over 7 years of industry experience as a Data Analyst, Data modeler, Business Intelligence Analyst
• Industry experience across various domains such as Insurance, Manufacturing and HealthCare
• Experience in creating tabular report, matrix reports and cubes
• Extensive experience in building Dimensional Modelling and Data warehousing solutions on several databases and reporting systems.
• Extensive experience in using T-SQL.
• Experience in creating and maintaining Data Marts, Data warehousing, Operational Data Store (ODS), Database Design, Entity-Relationship Modeling and Dimension Modeling.
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, Relational Database Models and Data Integrity in observing Business Rules.
• Install and upgrade databases and related products to current versions.
• Experience in integrating versatile data sources like Oracle, SQL Server, Flat Files (csv, fixed width) & XML Files.
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Experienced in creating complex reports in Micro Strategy Desktop using features like Templates, Filters, Prompts, Consolidations and Custom Groups
• Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports and Chart reports using SSRS and Power BI
• Hands on experience in reverse engineering the databases using Erwin Data modeler.
• Quick learner and enthusiastic to understand concepts and technologies new to current domain.
• A well-organized, goal-oriented, highly motivated and effective team member with excellent analytical and problem solving Skill.

TECHNICAL SKILLS:

Technologies: SQL Server BI Suite ( SSIS, SSRS, SSAS), Power BIMicrostrategy ( Architect, Objects, Reports,Administration)SQL Server database, OracleCrystal reports, Guidewire Suite(policy/billing/claim)

Languages: Strong foundation in C, C++, Java; basic familiarity with C# andXML

Software/Systems: Windows 2000, Windows 2003, Windows XP, Windows Vista,Windows 7/8, Red Hat Linux

PROFESSIONAL EXPERIENCE:

Confidential

Sr.BI Developer/Data Modeler

Responsibilities:

• Created SSIS packages to extract data from legacy systems and transform and load into SQL server staging database.
• Followed agile methodology in migrating data from old VMS system to Guidewire policy center and billing center.
• Designed and maintained SQL server database objects(tables, views, stored procedures, jobs etc)
• Created 996 views in staging database for 996 tables in target database and wrote all the complex transformation logic in these views.
• Interacted with mapping team members to make sure the mapping document for both policy center and billing center are up to date
• Conducted Knowledge Transfer sessions between mapping team, ETL team and Testing team members.
• Created and maintained SSIS jobs for loading data from staging database to target database.
• Created various unit test cases for various subject areas entities and documented test results and test queries.
• Created sprint deliverables for various policy and billing center entities that are developed in each sprint.
• Performed data reconciliation reports from source to destination database tables.
• Identified various data issues in old VMS system and reported them to vms team members to correct those issues. Once those issue fixed, then reloaded them back into database.

Environment: SQL Server 2012 BI, Visual Studio 2013 BI Suite (SSIS/SSRS/SSAS), Power BI, Guidewire Insurance Suite (Policy center, Billing center, Claim center), Github

Confidential

BI Developer/Data Modeler

Responsibilities:

• Working with business users and business analyst for requirements gathering and business analysis.
• Created ETL Packages using SSIS for bringing data from various data sources into datawarehouse.
• Managed Email notifications for SSIS packages in SQL Server Job Agent.
• Converted existing crystal reports into SSRS reports.
• Created various AdHoc and static reports using SSRS.
• Created and deployed Data Cubes using SSAS.
• Created star schema models using facts and dimensions tables using SSAS.
• Created dashboards using Dundas Dashboard Designer.
• Managed source code using Team Foundation Server (TFS).
• Created SSIS packages to perform ETL task by retrieving the data from various sources and storing them into data warehouse.
• Created Email notifications for SSIS jobs in SQL Server Agent.
• Responsible for managing SSIS packages, viewing error logs and correcting the errors in SSIS packages and also making sure to re-deploy the packages once they are corrected.
• Created various data visualization charts using Power BI.
• Responsible for creating the Sharepoint central site for our BI team, where we deploy all our SSRS reports, SSAS Cubes and Dashboards.
• Responsible for managing user permissions on SQL Server Database and Sharepoint site.
• Created SSIS package/SSRS reports/SSAS Cubes creation documentation and was also teaching other team members how to create cubes and reports.
• Interacted with Financial team members in getting their requirements to create monthly/ quarterly/yearly financial reports.
• Assisted Database administrator in installing SQL server database on new systems and was responsible for creating/modifying database in absence of our regular DBA.
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Written SQL Scripts to extract data from Database and for Testing Purposes. Environment: SQL Server 2012 BI, Visual Studio 2013 BI Suite(SSIS,SSAS,SSRS), Crystal reports, Power BI, Dundas Dashboard Designer, Sharepoint, Team Foundation Server(TFS).

Confidential

ETL/DW Developer

Responsibilities:

• Created data warehouse for pulling information from different healthcare application systems.
• Created and deployed cubes using SSAS.
• Converted crystal reports to SSRS reports.
• Created lot of PICIS, Med2020 and General Ledger Cubes for Decision Support Analysts for predictive analysis.
• Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Managed source code using Microsoft Team Foundation Server (TFS).
• Working with business users and business analyst for requirements gathering and business analysis.
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Performed Database Performance, monitoring and tuning.
• Written SQL Scripts to extract data from Database and for Testing Purposes.
• Designed Sharepoint central sub site for storing all the reports in one location and providing the end users one stop location for all the reports they need.
• Created modules for end users on how to use SSAS cubes and SSRS Reports.

Environment: SQL Server 2014 BI, Visual Studio 2013 BI Suite (SSIS, SSAS, SSRS), Blue Elm, Meditech, PICIS, Team Foundation Server(TFS)

Confidential

DW/BI Developer

Responsibilities:

• Involved in dimensional modeling of finance reporting warehouse.
• Interacted with clients in requirements gathering, designing functional and technical specifications for reporting needs
• Created and Deployed cubes using SSAS.
• Create and optimize ETL using SSIS for large scale data warehouse by indexing, create both database table partitions and Micro strategy partitions to optimize big tables' performance, create summary tables for additive facts/metrics properly to improve query performance greatly
• Design and build Micro strategy schema objects(Micro strategy architect) for very complicated business requests
• Design Distribution Services for scheduled jobs with dynamic subscriptions, design write-back reports for GUIs to allow users to change some data in data warehouse, design transformation attribute to implement periodical data analysis without creating multiple transformations
• Create Micro strategy reports and dashboards using slice and user-defined aggregate functions, etc. to implement complicated business requirements.
• Used different Micro strategy tools such as Enterprise Manager, Command Manager to audit, analyze and automate the whole BI environment.

Environment: Micro strategy 9.3, SQL Server 2008 R2, Erwin, Visual Studio 2012 BI Suite(SSIS/SSRS/SSAS)

Confidential

DW/BI Developer

Responsibilities:

• Support of L2 & L3 for performance reporting application and database development
• Designed and developed cross tab reports, reports with sub-reports (linked and unlinked) and chart reports. Reports were based on a command object. Wrote several SQL queries to accomplish the task
• Created complex Micro strategy by creating compound metrics and Attributes
• Extensively worked on reports that contained several Static and Dynamic prompts
• Set filters, suppression formulae and used highlighting expert to show the data the users would like to see in a more concise and presentable format.
• Deployed and managed reports with the aid of Microstrategy administration tools
• Extensively worked along with the business users and provided report analysis and design
• Communicated reporting changes, enhancements, and modifications - verbally or through written documentation - to management and other employees so that issues and solutions are understood
• Exported the reports into various formats such as Excel (including data only, Excel export), PDF, text and XML formats

Environment: Micro Strategy 9.0, SQL Server, SSIS, Windows 2000