SUMMARY

• A Microsoft Certified professional with around 8+ years of experience in data/dimensional modeling, database design, database programming, ETL development, administration and testing of SQL server 7/2000/2005/2008/2012 and implementation of data warehousing solutions.Database/ Design, Development
• Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, data architecture design etc.
• Analysing the Source System Data Model. Very Good Experience in Designing the Logical and Physical Data Models.
• Writing heavy stored procedures, Audit triggers, Views, Creating SQLScripts for data loads and Upgrades for data migrations and data validations.
• Tuning the performance of Stored Procedures and large T - SQL Queries using Clustered Indexes, Efficient coding standards.
• Proficient in PerfTuning/Query optimization using Indexes using SQL Profiler, Index Tuning Wizard,Database Tuning Advisor(DTA),DMV’s, DMF and reading Execution plansETL Development (SSIS)
• Data migrating (using ETL tools like DTS, BULK INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.BI Reporting (SSRS 2000/2005, SSAS/ProClarity/PerformancePoint Server/Cognos)
• Involved in handling Enterprise wide reporting needs using SQL Reporting Services,Crystal Reports and integrated them to Proclarity,Sharepoint Portal
• Developing OLAP cubes using SSAS 2005 and calculate the metrics dat were revealed in the functional analysis.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Expertise skills in calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005) using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Developed cubes using Partitions, KPI’s, and Perspectives, slow changing dimensions etc and created various user roles.
• Installation and Configuration of Performance Point Server and Proclarity, Implementation of Dashboards,Views, Cubes,KPIs and scorecards using the tools
• Experience in .NET/C#/VB.Net development environment

PROFESSIONAL EXPERIENCE

Confidential, Addison, TX

SSRS Developer/ SQL /Tableau Developer

Responsibilities:

• Work with Business User in Understanding the Rules and do the Data Conditioning
• Created database objects such as Tables, Views, Stored Procedures, Triggers, Indexes and functions.
• Implemented complex business logic with Store procedures, User Defined Functions, Views and wrote T-SQL batches with CTE (Common Table Expressions) for recursive operations.
• Involved in modifying the Existing Data ware house and add new Data Points for Data Analysis
• Implementation of MDM/MDS for Vendor Management
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Designed number of SSIS packages for data transfer between flat files, XML, Sales Force, Oracle, MYSQL and SQL Server using different transformations like Lookup, Derived Column, Merge Join, Fuzzy Lookup, Script Component and etc
• Created SSIS Templates for developing SSIS Packages, Implemented SQLServer configurations and error handling in SSIS Packages.
• Involved in deploying SSIS Packages to production from different environments and scheduling and administrating SSIS Packages, wrote best practices for deploying SSIS Package to Production.
• Involved in gathering requirements for EDW and designed the work flow diagrams and wrote the best practices and naming standards.
• Involved in designing ODS and EDW databases.
• Involved in testing the SQL Scripts for report development, Tableau reports,
• Designed the Dimensions and facts using Star Schema
• Created materialized views as per business requirements and wrote number of stored procedure and dynamic SQL.
• Involved in implementation of Master Data Services through Data Quality Services, Designed the SSIS packages move the data between MDS and EDW.
• Built compelling, interactive dashboards in Tableau dat answer key business questions
• Designed SSIS Packages to cleanse, remove duplicates and matching data through Data Quality Services.
• Created SSAS Cubes with multiple dimensions, measures and hierarchies based on OLAP reporting needs.
• Worked on Cube partitions and Aggregations according to the requirements.
• Worked on KPI’s and actions.
• Creating Back Up Strategies and implementing Disaster Recovery

Environment: MS SQL Server 2005/2008 R2/ SQL Server 2012, SQL server Reporting Services 2008, SQL Integration Services 2008,SQL server Analysis Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Confidential, Dallas, TX

BI Developer/ SSRS Developer

Responsibilities:

• Designing solution for Consolidating Different data sources
• Created SSIS package to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file and XML in order to create and maintain a centralized database.
• Applying strategies for data acquisition, ODS implementation, and archive Process
• Designed and built relational databases.
• Worked in pulling data and deal with heterogeneous sources and optimize the data extraction and conversion process using SSIS.
• Created MDS/MDM for master data and also implement Data Cleansing and Data Quality.
• Experience in creating Adhoc reporting universes usingBusiness Objects Universe Designer.
• Experience in building and retrieving data usingUniverses, Personal data files,and creating complexad-hoc Reportsusing theBusiness Objectssuiteapplications.
• Implement Logging to track and create ETL dash boards to monitor the ETL Process
• Error Handling and Auditing implemented in SSIS to track down the data discrepancies
• Experience working with Share Point 2010 lists in using them as interface for users
• ExcellentT-SQL Programming skills in creating, executing, debugging, problem analysis & troubleshooting stored procedures, functions, triggers, and creating solutions.
• Involved in Performance tuning of databases and halp user in efficient reporting
• Developed high level design of ETL Package in MS SQL Server 2008 for integrating data from heterogeneous sources such as Excel, CSV, Oracle, flat file and Text Format Data.
• Built reports using SSRS and halped develop efficient reporting solutions and setting up subscriptions as needed for SSRS
• Optimize SSIS Packages to fine tune the data loads and reduce the data load time and come up with Best Strategies in the data load process
• Fine tuning SSAS cubes for performance improvement and creating proper partitions and designing aggregations to enhance the performance of reports
• Used Cubes for reporting and Qlikview as OLAP tool for reporting
• Involved in dimensional modeling by Identifying the fact and dimension tables based on the user & reporting requirements.
• Implementing Partitioning and Back up Strategy and security policies

Confidential, Irving, TX

SQL Developer/ SSRS Developer

Responsibilities:

• Created the Data warehouse Architecture, Data Model and setting up the Best Practices
• Built the Source to Mapping document based on Subject areas for ETL Data Integration initiative
• Creating the Star Schema from analyzing the underlying requirements of the
• Worked on building/modeling the Enterprise Data Model
• Dimensional Data Modeling adhering to Ralph Kimball Methodology
• Built cubes usingSSASfor Incident and Request Systems
• Creating End to End Solution for bringing the data from multiple source systems into Data Ware house
• Built Cubes on Data warehouse
• Created Dashboards using Performance Point server
• Working on implementing dynamic partitions in SSAS
• Creating Custom Based and Ad Hoc Reports using MDX as Script
• Fine tuning existing SSIS
• Fine tuning SSAS cubes for performance improvement and creating proper partitions and designing aggregations to enhance the performance of reports
• Used Usage Based Optimization in SSAS for creating the best aggregations
• Created Several Types of reports using SSRS like Parameterized, Drill Down and Drill Through Reports

Environment: SQL Server 2012/ 2008/2005/2000, SSIS, SSRS, MS-Access, DB2/UDB, ERwin7.1, VB Script, WIN2000/XP.

Confidential, Alpharetta, GA

MS SQL Server Developer/ SSRS Developer

Responsibilities:

• Created the Dataware House Architecture, Data Model and setting up the Best Practices
• Built the Source to Mapping document based on Subject areas for ETL Data Integration initiative
• Creating the Star Schema from analyzing the underlying requirements of the data ware house
• Created the Design Documents and Pop Specifications for the Process.
• Gathered the Business Requirements for automating the reconciliation of numbers for every quarter
• Created Logical and Physical Data Models for ODS
• Developed Data Flow Diagrams
• Created ODS(Operational Data Store) for consolidating the data from various data sources like Under Writing Work Station, Claims Work Station and IRIS by using SSIS as ETL tool
• Implemented best practices for Data load into ODS
• Worked with Upper Senior Management as to Analyze and Come up withKPI Based Requirements
• Followed the Agile methodology to develop fine tune and deliver with Constant Partner Ship from Business user
• Very Good Experience inPerformance Point Serverwhich Involves monitoring Analytics and Planning Components
• Creating Dashboards, Scorecards,Reports,KPIS and Publishing them ViaMOSS
• Responsible for maintaining cubes usingSSASand populate thecubeswith the data.
• Created view from the cubes built usingSSASinProclarity.

Environment: MS SQL Server 2005/2008 R2/ SQL Server 2012, SQL server Reporting Services 2008, SQL Integration Services 2008,SQL server Analysis Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN

Confidential, Dallas, TX

SSRS/SSIS/SSAS Developer

Responsibilities:

• Worked on designing the requirements and followed the Agile methodology to develop fine tune and deliver with Constant Partner Ship from Business users
• Worked with Upper Senior Management as to Analyze and Come up with KPI Based Requirements
• Very Good Experience in Performance Point Server which Involves monitoring Analytics and Planning Components
• Creating Dashboards, Scorecards, Reports,KPIS and Publishing them Via MOSS
• Created view from the cubes built using SSAS in Proclarity.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Created different Data Layouts for the Business users depending on the requirement and providing them different Drill Down capabilities using Proclarity.
• Worked in Creating partitions and Designing various storage modes to increase the performance of a cube using SSAS.
• Very Good Experience Working with Score Cards
• Creating Various Dash Boards depending on the requirement for the Business Users
• Involved in design of Star Schema
• Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis Services-SSAS.
• Using XML/XPath/XQuery to retrieve XML
• Using Xpath to navigate through XML Nodes for Analysis
• Involved in writing MDX queries.
• Implemented Several Time Based Calculations in SSAS cubes using MDX
• Performing problem resolution and root cause analysis along with recommending and implementing preventive techniques for Production Environment.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Created packages in both DTS and SSIS.
• Developed custom reports using SSRS/SQL Server BI studio.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Experience in building star schema and snowflake schema depending on the business data requirement.
• Implemented Replication And Log Shipping
• Scheduling Jobs and Alerting using SQL Server Agent
• Created datasets for reports using T-SQL and stored procedures
• Responsible for Query optimization and Performance tuning.
• Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications
• Performing query plans and making sure each and every query is using appropriate useful indexes.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.

Environment: MS SQL SERVER 2008 R2, SQL Server 2012, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008,SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.