SUMMARY

• Over 8+ years of IT industry experience wif Microsoft SQL Server 2000/ 2005/2008/2008 R2/2012, SSIS/SSRS/SSAS, and OLAP as SQL Developer.
• Strong technical noledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience wif different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Very Good Understanding and Experience in SQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services(SSRS)
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience in Data Modeling, Normalization and building Referential Integrity Constraints, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2005/2008/2008 R2/2012 for both OLTP & Business Intelligence applications.
• SQL Server RDBMS database development including T-SQL programming.
• SQL Server OLAP database development including KPIs, Data mining, working wif changing dimensions.
• ETL implementation using SQL Server Integration Services (SSIS).
• Thorough understanding of Kimball’s’ theory, KPIs, SQL Architecture.
• Experience working on Data Aggregation and Storage design of cubes in SSAS.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes
• Good Knowledge and understanding on the SharePoint Server.
• Extensive experience of designing and developing software applications wif the .NET Framework 1.0/1.1/2.0/3.0/3.5 using C#, ASP.NET and VB.NET
• Experience in using Performance Point Server.
• Expert in designing Enterprise reports using SQL Server Reporting Services 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.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS and ability to export reports and query results to Excel or PDF
• Architecture and design experience specific to EPM solution implementation.
• Expertise in using TFS to open bugs, create tasks and user stories, initiate change requests
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.

TECHNICAL SKILLS

Database: SQL Server 2000, 2005, 2008, 2008 R2, 2012 Oracle

Operating Systems: Windows XP/2000/2003.

Programming Languages: VB.Net 2012, C# 2012, T-SQL, ASP.Net, ADO.NetMS Excel, .Net Framework 3.5 - 4.5,XML, XSLT, VBScript, JavaScript, Visual SourceSafe, HTML5, CSS3,IIS7

BI Suite: SSAS, SSIS, SSRS, PPS 2007/2010

ETL TOOLS: DTS, SSIS

Database Tools: SQL Profiler, Database Engine Tuning Advisor, SSMS.

VC Tools: Visual Source Safe, TFS, SVN.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

SQL Server SSRS/SSIS Developer

Responsibilities:

• Wrote complex SQL statements using joins, sub queries and correlated sub queries.
• Involved in creation of data modeling techniques.
• Analyzed complex queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings
• Designed and developedmonthly, quarterly and yearly reports at branch and bank level.
• Coordinated wif DBA in creating and managing tables, indexes, triggers.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Involved in converting DTS to SSIS and development and implementation of SSIS on an enterprise level.

Environment: SQL Server 2000/2005, T-SQL, Windows Server 2003, SQL Profiler, SQL Server Reporting services, Visio.

Confidential, Dallas, TX

SQL BI Developer SSIS/SSRS

Responsibilities:

• Perform all SDLC phases related to extract, transform, and load (ETL) processes usingSQL Server Integration Services (SSIS) andSQLServer stored procedures wifin MSSQLServer 2008 environments
• Participate in on-call support rotation for nightly ETL batch cycles
• Worked on WCF, MVC, IIS, and Automated unit testing.
• Assist in the definition of the database requirements; analyze existing models and reports looking for opportunities to improve their efficiency; and resolve technical problems
• Develop optimizedSQLServer stored procedures, functions, and database views
• Translate business requirements intoBIapplication designs and solutions
• Worked on COSMOS Workgroup Feed Import. The Automated feed will update tables from COSMOS Data.
• Performance monitoring, tuning and capacity planning
• Develop ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Worked on Tabular solutions, which uses relational modeling constructs such as tables and relationships for modeling data.
• Worked on CIS Solaris 10 Benchmark v4.0, and CCS for Reporting and Analysis components.
• Has written Reports, Sub Reports, drill down reports using various features like Charts, graphs, filters, parameters, indicators, gauges, spark lines.
• Worked on Microsoft Light Switch, and Microsoft Silverlight
• Worked on VB.NET, C#, ASP.NET, ADO.NET, Entity Framework, and LINQ.
• Created stored procedures to use as datasets for the Report Design.
• Written scripts using C # programming to customize the reports in SSRS environment.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Worked on .Net framework 4.0 and Asp.net as a programming part.
• Maintained and implemented technical specification and documentation.
• Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver Reports

Environment: MS SQL Server Management Studio 2008, Visual studio 2010, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

Confidential, Philadelphia, PA

SQL Server Developer/ ETL Developer

Responsibilities:

• Involved in database design, and create schemas, tables, views and indexes.
• Backend database development in MS SQL Server, writing complex ad-hoc queries, stored procedures, views, triggers, cursors, UDFs.
• Performed Database code Migration from SQL Server in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.
• Experience in SQL joins, sub queries, tracing, and performance tuning.
• Extensive use of triggers to implement business logic and for auditing changes to critical tables in the database.
• Involved in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding datamarts.
• Experience wif SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting wif Active-X and VB.NET in SSIS.
• Experience in SSIS script task, look up transformations and data flow tasks using T-SQL and Visual Basic (VB) scripts.
• Experience in generating reports using linked reports, sub reports, and filters in SQL server reporting services.

Environment: MS SQL Server 2000/2008, T-SQL, Windows XP 2000, MS Visio, MS Projects.

Confidential, Charlotte, NC

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked on the file import framework process for the various flat files structures to get data imported into our database.
• Created the Stored Procedures, tables, Views depending upon the project requirement.
• Experience in monitoring SQL Server Performance tuning in SQL Server 2008R2/2012 using SQL Profiler, Query Analyzer.
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table. Generated ASP.net objects from tables and presented these DOM objects which are capable for easy communication, to the Business applications.
• Created the deployment scripts after the development is done for every project.
• Automated the SSIS Packages using the SQL Server Agent Jobs.
• Troubleshooted the SSIS/SQL job Agent whenever necessary.
• Constructed cubes based on data volumes mostly adhering to Star Schema.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2012 Analysis Services.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Used custom .NET assemblies for Script Task in SSIS
• Hands on noledge of TFS and Bug Tracking and Reporting through TFS bug tracking tool.
• Imported the various files provide by the clients into the relational database systems.
• Used the BCP to load the large volumes of data from files into tables.
• Worked wif Business Analysts and Users to understand the requirement.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and 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.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Documentation for all kinds of reports andSSISpackages.
• Used Visual Source Safe as Version Control Tool.

Environment: SQL Server 2012, SQL Server Business Intelligence Development Studio 2012, SSIS, SSAS, SSRS, T-SQL, EXCEL, Performance Point Server, T-SQL, C#, Visual Source Safe, SQL prompt.

Confidential, San Francisco, CA

MS SQL Server Developer/SSRS/SSIS

Responsibilities:

• Migrated Data from MS SQL 2005 to MS SQL 2008.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Created packages to migrate data from different data sources to Data warehouse.
• Created packages for database maintenance.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
• Created SQL Server Reports using SSRS 2005 for the clients.
• Created parameterized reports for the brokers and clients.
• Deployed the developed reports and upgraded the system.
• Deployment of the developed reports on to the server for the end users.
• Supported 24/7 for the production system for post deployment Reports on the server.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.

Environment: Windows 7/XP, MS SQL Server 2008/2005, SQL Server Reporting services, SQL Server Integration Services.