SUMMARY:

• Over 7 years of experience in data modeling, data design, database programming, testing & administration of SQL Server 2012/ 2008/2005/2000 /7 for OLTP/OLAP/ETL environments.
• Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, data architecture design etc.
• Writing T - SQL queries (DDL and DML). Creating SQL Scripts for data loads and Upgrades for data migrations and data validations.
• Implementing all kinds of SQL Server Constraints (Primary, Foreign, Unique, Check etc)
• Generating Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using Stored Procedures, Triggers, User-defined Functions and Views, Cursors.
• Tuning the performance of Stored Procedures and large T-SQL Queries using Clustered Indexes, Efficient coding standards, Indexing Tuning Wizard, SQLProfiler, DMV’s,DMF’ and other Tuning utilities.
• Performing Normalization and Relational Database Management Systems.
• Experience with Dotnet development with ASP.NET, C#, and VB.NET using Dotnet framework 2.0/3.5
• Strong Object Oriented programming skills using Visual Basic, C/C++, HTML, .Net, VBScript, ASP.Net and other languages.ETL (SSIS)
• 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.
• 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.
• Involved in usage of various SSIS components like Forloop, Foreachloop, FuzzyLookup, Variables, Error Handling etc
• Experience in Writing Complex SSIS Process across heterogeneous sources like Oracle, SQL, DB2,FlatFile, Excel
• Scheduling and Monitoring ETL Processes using DTSExec utilities and batch files
• Conversion of DTS packages to SSIS and Interfacing Legacy components within SSIS for complex transformations and logicAnalysis & Reporting(SSAS, SSRS 2008/2005/2000 )
• Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2008/2005/2000
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008/2005/2000 ) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Involved in Data Modeling using Erwin, Star and Snowflake Schemas.
• Developing OLAP cubes using SSAS 2005 and calculates the metrics that 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 moving dimensions etc and created various user roles.Administration
• Creating and Managing users, roles and assigning necessary permissions.
• Involvement in Backing up databases and refreshing Data across environments.
• Excellent communication and interpersonal skills in handling multiple tasks, able take initiative to handle responsibilities independently as well as a member of team.
• Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQL Server Management Studio, SQL Server Analysis Services, SQL Server Reporting Services etc.
• StrongInterpersonalandcommunication skills, ability to work in a team as well as independently.

TECHNICAL SKILLS:

Programming languages: T-SQL, PL/SQL, MDX, C, Visual Basic 6.0, VB Script, C#.NET,VB.NET, ASP.NET

Web Technologies: CSS, HTML/XHTML JavaScript, XML, IIS (4.0/5.0/6.0)

RDBMS: Microsoft SQL Server 2008/2005/2000 /7.0, Oracle, MS-Access 97/2000/2003 , DB2

Tools: /Utilities: SQL Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Visual SourceSafe 6.0, Visual Studio .Net, Microsoft Management Console, DTS, SSIS, BIDS, Crystal reports9.0

Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Informatica

Database Design Tools: MS Visio, Erwin

Version Control: Visual Source Safe 6.0/2005, TFS

Operating Systems: Windows 2003/2000 Advanced Server, NT & Windows 9x

PROFESSIONAL EXPERIENCE:

Confidential, Bothell, WA

BI Developer

Responsibilities:

• Involved in design and architecture of the entire project flow and integration with third party tools. Interfaced with Business in understanding the present functionality of Sim card Provisioning system and defining the phases in which the development would be done.
• Monitor and tuned indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server.
• Created sophisticated SQL Server database to responsively handle complex queries (triggers, stored procedures, views, functions) for .NET data access components for front end screens.
• Troubleshoot SQL Server performance issues for internal and external customers.
• Creates technical specifications, test plans and test data to support ETL processes.
• Experienced in cleansing data for data consistency whether the data source is a single system or multiple disparate sources and created a logging mechanism in SSIS packages.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
• Worked on SSRS to generate hierarchical reports and drill down reports and tested using Management Studio in SQL server 2005.
• Creted different dashboards for the Business which involves the Metrics related to Provisioning Process Times,Delays, requirement by using SSRS 2008.
• Created Different types of SSRS Subscriptions based on the requirement from Business.
• Supported and deployed the code across Test, Developmentand Production Environments.
• Supported the Production ticketing system and resolved the tickets as per the user specification
• Involved in troubleshooting the different SSRS report Data gaps and Performance. Help to identify the different approaches to resolve the Data issues.

Environment: T-SQL, MS SQL Server 2008 R2/2012, SVN, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2010/2012, VSTF (Visual Studio Team Foundation Server), XML, Erwin.

Confidential, Issaquah, WA

SQL Server BI Developer

Responsibilities:

• Involved in interacting with the business users to gather the requirements and document the functional Specifications for each release and also involved in Design discussions of the data warehouse.
• Created Database objects by forward engineer the Physical model by using the ERWIN tool and involved in creating the Data models using ERWIN.
• Implemented the Data vault Methodology for Enterprise Data source for better Normalization and also to maintain History as much as possible.
• Coded extensively with CTE’s, Complex Stored Procedure, Functions, Triggers, Memory variables, Table Variables, functions.
• Involved in Performance tune the Queries by using the Execution plans and Profiler to figure out the issue and solved by creating Indexes and update the stats.
• Created Informatica Workflows to as ETL Tool(SSIS) to load the Data Vault Tables and created the work flow dependencies as per the requirement and document the dependencies.
• DevelopedCube using SQL Analysis Services (SSAS)and Experience in Developing and Extending OLAPCubes, Dimensions and data source views.
• Extensively involved in theSSAS storageandpartitions, andaggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Creted a dashboard for the Business which involves the Metrics as per the requirement by using SSRS 2008 and Used Different Reports like Line, bar charts, Heat maps.
• Created Report Email Subscription using Data Driven and Time Driven ReportSubscriptions.
• Deployed reports across Test, Development and Production Environments
• Involved in Creating User Security and Roles In Reporting Services at both Parent Level and Report Level.
• Involved in Trouble Shooting Complex Reports.

Environment: T-SQL, MS SQL Server 2008 R2/2012, METaL, Octopus, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2010/2012, VSTF (Visual Studio Team Foundation Server), XML, Erwin.

Confidential, Cleveland, OH

SQL Server BI Developer

Responsibilities:

• Design and Create Database tables include Stage, Temp, Slowly changing Dimension Tables with Type1, Type2 and Hybrid Type and Fact tables based on the file layouts and creating Relationships between tables and constraints.
• Create SSIS packages for loading the Daily files to the Database tables using Different Transformations like FtpTask, FileSystem Task; Execute a System Process, Slowllychanging Dimension, and Script task.
• Set up the package Configurations, SSIS Standard error handling by using the Event Handlers, Logging by Sql server option and also Checkpoints and Worked with Transactions in the SSIS packages.
• Created Complex stored Procedure to load the data from stage table to Base tables includes Slowly Changing dimension tables, Fact tables by Using Complex Views, Temp Tables and Cursors.
• Involved in Performance tuning of the Stored Procedure by using DTA to figure Out the Indexes Needed and created the cluster indexes, Non cluster indexes by going through the execution plans and Updating the statistics.
• Created Complex Views and complex functions to expose the particular columns as per the client requirement.
• Created ERD’s, Dataflow Diagrams based on the subject area by using ERWIN and VISIO software by Reverse Engineer the Database tables.
• Maintained of Daily Load that is trouble shooting the Error data in the Data files make changes to the SSIS package according to the accommodate that change in the data.
• Designed Data Mart by using the Different Dimensions like Role play Dimensions, Degerative Dimensions, Linked Dimensions and also Fact tables.
• Experienced With creating the Different Hierarchies like Balanced, Unbalanced Hierarchies and worked with Attribute relationships to increase the performance.
• Built SSAS Cube with Star Schema with different Measure Groups and created Partitions for Fact tables and Complex Calculations and aggregates.
• Experienced with MDX queries to generate SSRS reports using Named Sets, Calculated Members, and Different Functions like NON EMPTY, ParallePriod and Aggregate functions.
• Created SSRS Reports for different Calculations and aggregates like Drill down Reports, Drill through Reports, Matrix Reports.
• Experienced With creating SSRS reports for file Auditing Process to get the Missing Files from the Daily Loads and also For Campaign Aggregates.
• Installed and Configure the SSRS Reporting Services for both Development and Production Servers and Involved in the Maintained Of SSRS Server. Worked with Subscription of the Reports to the FTP Site.
• Experienced with Uploading the SSRS Reports to the SharePoint Server.
• Experienced Using the Visual Source Safe for version Controlling and involved in creating the unit cases, Test Plans based on the loads.

Environment: SQL Server 2008 R2, T-SQL, Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), DTA, Share Point Server, ER/Studio, Query Analyzer, SQL Profiler, VISIO, ERWIN, Windows OS.

Confidential, Richmond VA

BI Developer(SSIS,SSAS,SSRS)

Responsibilities:

• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers. Extract data from different heterogeneous sources and map to destination.
• Set up the DTS packages for the exchange of data between different data sources.
• Worked with package configurations in XML file and also in the SQL server.
• Experienced in increase performance of the SSIS packages by understanding asynchronous Transformations and Synchronous Transformations.
• Implemented the error handling in the SSIS packages by using the Event Handlers in SSIS packages and also using custom coding.
• Experience in working with the designing data marts and created the test plans, technical specifications and test data to support the ETL process.
• Defined and processed the Fact table & Dimensions. Made Partitions in the measure groups to increase the performance.
• Built MDX queries using named sets and different functions for Analysis Services & Reporting Services.
• Experience built the cubes with different dimensions and measures. Worked with Linked dimensions, fact dimensions.
• Updated the multi-dimensional cube data using SSIS- Import/Export wizard.
• Built and designed Star, Snowflake schemas and dimensional data models.
• Designed/implemented the information access and delivery effort for the data warehouse.
• Installed and administered Microsoft SQL Server Reporting Services, created schedule reports and send the reports via email.
• Created Different reports like Sub reports and Drill Down reports, Drill Trough reports, Parameterized Reports.
• Created different dashboards for the business and integrated into share point site.
• Created the Score Cards based on Key performance Indicators (KPI’s).
• Involved in uploading the reports to Performance point server for the end users.
• Created ad-hoc reports for the end users and created the report models for different users.
• Monitored the performance of SQL Server using SQL Server Profiler.
• Created different Procedures using Temporary Tables, Different kind of cursors, Table variables. Created the functions and triggers to track the changes in the tables.
• Interacted with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Experienced in setting up SQL Server and database configuration parameters.

Environment: SQL Server 2000/2005/2008 , T-SQL, Data Transformation Services (DTS), Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), ER/Studio, Query Analyzer, Business Objects, SQL Profiler, Enterprise Manager

Confidential, Atlanta, GA

SQL Server BI Developer

Responsibilities:

• Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs
• Designed packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, Derived Columns with Multiple Data Flow tasks
• Used differentControl Flow Tasks and Data flow Taskfor Creating SSIS Packages. Used different types ofTransformationsfor Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
• Created Packages using Complex Store Procedures and TSQL queries
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and file files
• Developed Complex Packages to load data into Stage, ODS and Data Ware House systems
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third party tools like Control m
• Deployed Packages on both File System and SQL Server MSDB Using bat files, dtexec Utility and Import - Export Wizard
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids
• Configured, Installed, Administered Reporting Services 2005/2008
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports
• Designed Large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters
• Developed reports using complex TSQL queries, User Defined Functions, store procedures and Views
• CreatedETL packages with different data sources(SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations usingSSIS/DTS packages
• DevelopedCubes using SQL Analysis Services (SSAS)and Experience in Developing and Extending OLAPCubes, Dimensions and data source views.
• Extensively involved in theSSAS storageandpartitions, andaggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions
• Deployed reports across Test, Development and Production Environments
• Involved in Creating User Security and Roles In Reporting Services at both Parent Level and Report Level
• Involved in Trouble Shooting Complex Reports
• Created Large Number of Report Models for users to create their own reports.
• Involved in code reviews, change control and auditing procedures

Environment: T-SQL, PL/SQL, MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports, Oracle9i, VBScript.

Confidential

SQL Developer

Responsibilities:

• Managed high-availability SQL Server environment supporting financial, business intelligence and CRM systems with load-balancing across multiple data centers.
• Managed for business continuity and disaster preparedness in all database systems in multiple sites for storm coverage.
• Assisted clients with physical database modeling, data archiving strategies, data purges and disaster recovery planning.
• Implemented transactional replication to enhance the failover capabilities increased over all database manageability and improved performance.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Conducting root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, hardware bottlenecks or network latency.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system using diagnostic manager from Idea.
• Performance tuning, and optimization of procedures and queries.
• Responsible for the creation and maintenance of entity relationship diagrams, Meta data repository and comprehensive system documentation including everything from environment configuration information through standards, policies and procedures.
• Responsible for change control management documentation.
• Suggested and Implemented Third-party backup solution from Idea which reduced backup and recovery time to 50% while saving huge disk space.
• Interacted with higher management for reporting root cause analysis and suggested best practices to reduce the down time.
• 24x7 Production support.

Environment: T-SQL, SQL Server 2000, OLAP Services, Crystal Reports 9.0, Windows 2000 Server, MS Access 2000, Oracle, VB.net 2003, Erwin Data Modeler