Data Sql Server

Professional Summary

Accomplished professional with over seven years’ experience working with data warehousing and analytics tools. Expertise manipulating, cleansing and processing data, as well as loading, extracting, and validating client data. Manages end-user and third-party relationships. Designs and implements relational and dimensional data models for Finance, Insurance & Healthcare domain. Uses Transformer to design cubes. Develops customized reports and databases. Manages data migration activities and created data warehouse environments. Solid track record working with Cognos 10 AND Tableau 9.0

Now looking forward to join a company where I can learn new BI technologies & enhance my technical leadership skill.

Project Highlights

SRA: Used Tableau to create the HR Dashboard which shows all the HR Metrics related to Employees. Mostly worked on the Tableau Desktop & created different Charts (Line, Bar, Pie) & Key Metrics Indicators .Created various Calculation in order to get the different HR Metrics Data. Performing Joining & creating Data views within Tableau

Ashland: Implemented Cognos report development and framework manager modeling for Valvoline. Developed centralized reporting capability allowing end-users to perform transactional, analytical, and ad hoc analyses of sales and financial data. Executed Cognos security implementation. Utilized MS Access, SQL Server database, and SAP-BW.

Velocity Project: Centralized an insurance broker’s health and property liability business on the Velocity product, allowing for custom reporting functions. Created a dimensional/relation model within Framework Manager. Documented all applicable processes. Used Cognos Connection’s Schedule Management to distribute reports. Installed and configured Cognos Server on Windows. Migrated data from Excel and Access to Oracle. Utilized Cognos 8.4, Oracle, SQL Server 2005, and Toad. Experienced working with Healthcare Insurance industry.

TSC/EOSC Reporting Application: Provided Cognos development service and support functions using a variety of applications across multiple lines of insurance business. Performance-tuned SQL queries. Executed Cognos security implementation. Utilized Framework Manager, Report Studio, Query Studio, Metric Studio, and Analysis Studio.

Claims Business Intelligence and Analytics: Developed the data warehouses’ relational data model in compliance with established requirements. Constructed Framework Packages and Cognos Cubes. Executed complex reports for strategic planning, monitoring, and performance appraisal. Utilized tabular sets, child tabular models, drill-through reports, master detail reports, and conditional prompts. Experienced working with the Health care Insurance data and developing visualization using the data.

Data Migration via Data Stage: Implemented the UWPF-FAB underwriting process solution. Played a critical role in the requirement gathering process. Created query prompts, calculations, conditions and filters, prompt pages, and variables.

Employee Appraisal System Development, 2007 – 2008: Developed a web-enabled employee appraisal system. Prepared a use-case diagram and Software Requirement Specification (SRS) document during requirements gathering. Connected the website with the local database and the Microsoft SQL Server database. Used stored procedure, triggers, view and index to develop the database. Utilized Struts framework, Java Applets, HTML, CSS, XML, XSLT, Java Scripting, and JSP.

Skills Summary

Data Warehousing Tools:

Cognos Crystal Reports Jasper Reporting Tool Toad SSIS Tableau Logi Info

Programming Languages:

SQL PL/SQL CSS HTML XML Java 1.4 C C++ JSP ASP.net

Databases:

Oracle 9i, 10g 11g SQL Server 2005 MS Access MongoDB FireBird Workday

Scripting:

JavaScript VBScript

Experience

SRA International – Software Engineer 01/2015-Present

Collecting, collating and carrying out complex data analysis in support of

Management & customer requests. Also involved in reporting statistical findings to work colleagues and senior managers

Responsible for all the Cognos BI & TM1 Administration/Development activities such as Configuring & installation of Cognos 10.2, deploying reports, managing security using LDAP & Performing Upgrade of Cognos BI & Cognos TM1 from 10.1 to 10.2 on a distributed environment.

Created HR Metrics Dashboards using Tableau 9.0 for HR Department

Responsible for creating Materialized views to bring in data from DELTEK costpoint & Time processing system & creating reports & FM models on top of that.

Responsible for ETL activities using Informatica 9.5. Created Scripts & workflows for Data Migration.

Responsible for doing the Data modelling & Data migration Activities (Cleaning, Loading Transformation)

Extensively using the Cognos Workspace Advanced.

Ad-hoc data investigations, data profiling and data cleansing

ETL and data integration experience with Oracle PL/SQL package creation, SQL

scripting, SQL Server Procedures, and Informatica Power Center 9.5 mappings/workflows

Creating the OLAP Cube & building the reports in Cognos Transformer

Logi Analytics – BI Developer 01/2012 –01/ 2015

Provide critical support and service at a software company that develops Business Intelligence and Analytics tools.

Facilitate the creation of effective data warehousing environments using Oracle, SQL Server, MySQL.

Used data from Mongo DB & Amazon Red shift to develop visualization and Uncover customer report requirements and design solutions that meet their unique needs.

Help clients configure Logi Info Studio and implement security using LDAP, Active Directory, and other application security models.

Identify opportunities for product enhancements based upon customer feedback, and provide insights to the R&D team.

Extensive Experience working with SQL Server Analysis Services (SSAS) to create cubes.

Continuously interacting with the Customers to take their requirement and turning them into technical specs.

Extensive Experience with SSIS in order to do data migration on Microsoft sql server.

Ashland – Cognos Developer 01/2011 – 01/2012

Recommended data structure changes based on business reporting requirements.

Used TOAD to run SQL queries and validate data in the data warehouse and data marts.

Used Cognos Report Studio and Query Studio to develop list reports, cross tab reports, chart reports, conditional formatting, multiple drill-through, and other Cognos 8 & 10 features.

Built and published models and packages, using Framework Manager.

Used Active Reports to develop offline reports for Sales Department.

Cultivated subject matter expertise in dimensional modeling by creating dimensional data structures, and complex hierarchies & relational Modeling using star schemas, snow-flake schema methodologies.

Implemented application security for multiple users across the department. Created reports using the DELTEK Costpoint system for the finance department.

Creating the OLAP Cube & building the reports in Cognos Transformer

L&T Info Tech – Lead Software Developer 11/2007 – 01/2010

Worked extensively on various client projects mentioned above as Lead Cognos BI & TM1 Developer.

Gained expertise in Report Studio, Query Studio & Analysis Studio of Cognos 8 & Cognos 10 environment.

Worked Extensively on Oracle & Sql Server Database to create Complex Sql & PL sql and using Jasper soft to create visualization.

Gained Domain Knowledge in Insurance Industry by Certification INS 21 & INS 22 & Formal Training from AICPCU on INS 23.

Education and Certifications

Bachelor of Science; RGPV University

Oracle Certified Developer

Sun Certified Java Programmer

Domain Certified in Healthcare and Personal Insurance (INS21) and Commercial Insurance (INS 22)

Professional Achievements and Recognitions

Published a whitepaper on the topic of resolving issues using Logi Info Configuration with Oracle Database.

Customer Appreciation award recipient for delivering quality and “First Time Right” components.

Internal Appreciation award recipient for maintaining a high customer satisfaction index level in quality deliverables.

Contact this candidate