Experience

Pragmatic IT Solutions

• Software Development
• 1 - 100 Employee

• BI Developer

  • Mar 2011 - Present

   Developed New and Extending OLAP Cubes, Dimensions and data source view. Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX. Developed facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests. Involved in creating calculated members, named set, KPI’S for the SSAS cubes. Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system. Created Time Dimensions on OLAP Cubes using SSAS. Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, developing reports using MDX and SQL. Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries. Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report). Generated several drill down and drill through reports using SSRS. Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS).



Pragmatic IT Solutions

• Software Development
• 1 - 100 Employee

• MSSQL Developer

  • Aug 2009 - Jan 2011

   Gathered requirements to identify and create database objects such as tables, views, triggers and indexes. Involved in Normalization of the database and bringing it to 3NF. Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity. Created Views to enforce security and data customization. Created Non-Clustered indexes to improve query performance and query optimization. Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases. Created Stored Procedures for commonly used complex queries involving join and union of multiple tables. Developed user requested reports using Excel.



Pragmatic IT Solutions

• Software Development
• 1 - 100 Employee

• System Admin

  • Mar 2008 - Apr 2009

   Installing and Updating Operating Systems. Allowing and denying sharing permissions between PC’S. Issuing & maintaining IP address for machines. Remote installations. PC assembling and dissembling. Trouble shooting, administration and support of Windows XP. Managing and ensuring appropriate level of antivirus protection.  Installing and Updating Operating Systems. Allowing and denying sharing permissions between PC’S. Issuing & maintaining IP address for machines. Remote installations. PC assembling and dissembling. Trouble shooting, administration and support of Windows XP. Managing and ensuring appropriate level of antivirus protection.