SUMMARY

• Around 8 years of experience as MS - SQL Server Developer, involved in Administration, Design, Development and Support of MS-SQL Server 2000/2005/2008 R2/2012 for both OLTP and OLAP Systems.
• Designing, testing and implementation of high availability solutions for databases for large, medium and small customers.
• Extensive experience with SQL Server and T-SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Efficient in creating joins and sub-queries for complex queries involving multiple tables.
• Well versed in Normalization/Demoralization techniques for optimum performance in relational and dimensional database environments.
• Experienced in developing logical and physical data models using data modeling tools such as Erwin and ER/Studio.
• Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler.
• Expertise in Database Administration operations like Upgrade,Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Efficient in optimization and Performance Tuning, Data Import/Export, Troubleshooting, Database Objects, Authorization Objects Creation. Suggest/test improvements: indexing/table structure, query code.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Built Efficient SSIS packages for processing facts and Dimension tables with complex transforms.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development and Implementation.
• Good knowledge on Cosmos Scope.
• Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.
• Created drill down, drill through, Cascading, Conditional, Table, Matrix, Chart, linked reports using MS SQL Server Reporting Services (SSRS) as well as managed the subscription of the reports.
• Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data Connection.
• Experience in Cube designing in Business Intelligence Development Studio (BIDS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Experience in Designing, Building the Dimensions, cubes with star schema, snowflakes schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server Analysis Services.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Business Intelligence Tools: Microsoft BI (SSAS, SSRS), SSAS Tabular, Self-service BI (Power Pivot, Power View, Power Map, Power Query), Cognos 8.x (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection, Transformer), Netezza 6.0.

ETL Tools: SSIS, Informatica Power Center 7.x, Data Stage 7.5, Power Query

Database Systems: MS-SQL Server 2000/2005/2008 /R2/2012, Oracle 10g/11g, DB2MS Access

Database Management Tools: SQL Query Analyzer, SQL Profiler, DTA, SQL Server Activity Monitor, SQL Server Logs

Programming Languages: T-SQL, PL/SQL, .Net, MDX, DAX, PostgreSQL, HTML

Operating Systems: Windows 98/ME/2000/NT/XP/2003/7, MS DOS, Linux, IIS 5, 6

Project Management/ Database Design: Microsoft Project/Office 2007, 2010, 2013, Microsoft Visio, Erwin

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Worked with Business Analysts and Users for gathering requirements and implemented logical Design into Physical Design.
• Wrote the complex queries using joins, Sub-queries, common table expressions (CTE) in T-SQL.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Created and Modified tables, Views, Indexes, User Defined Functions and Stored Procedures.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File and vice versa.
• Implemented the concepts of Incremental Data Load, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Used complex transactions and Validations to make sure the data is correctly loaded into the warehouse.
• Used Configuration files to deploy and install a package from one environment to another.
• Used SSIS features like event handlers, property expressions, package configurations, transaction option and protection levels in the packages.
• Created Charts, Tabular and Matrix reports using SSRS, with Drill Down and Dill Through features.
• Deployed Reports, created Report schedules and subscriptions. Managing and securing reports using SSRS Report Manager.
• Created cubes and dimensions and defined the Referenced Relationships with the measure groups and fact tables.
• Implemented calculations to aggregate physical measures and responsible for identifying KPIs in SSAS.
• SSAS storage and partitions, aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL.
• Created jobs and scheduled jobs using SQL Server Agent.
• Integrated Database Maintenance jobs to perform Full, Differential and transaction log Backups and scheduled them with SQL Server agent job scheduler.

Environment: MS SQL Server 2008/2012, T-SQL, MDX, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ETL, Business Intelligence Development Studio (BIDS), MS Excel, VB Script, Oracle 10g/9i, XML, SharePoint Servers, Team Foundation Server (TFS).

Confidential, Bentonville, AR

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created and modified various Stored Procedures used in the application using T-SQL.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL Server).
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.
• Developed yearly and quarterly company expense reports.
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV, Generate reports with parameters, sub reports, cross tabs, charts using SSRS.
• Highly involved in creating, structuring, formatting using Report Designer andReport Builder.
• Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• Designed Cubes with star schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.
• Involved in dimensional modeling with Star &Snowflake schemas and created the Data Source Views Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Create and edit alerts on Reports, as per User request.
• Worked with users and helped Build a Tabular Data Model and published it to Share Point.
• Worked withMDXto query cube's data.
• Involved inTabular Data warehouseandDAXoperations for SSAS 2012 and 2008 OLAP databases.
• Developed core functionality with the .NET Framework using VB.NET, ASP.NET, ADO.NET.
• Used Team Foundation Server (TFS) for managing the code.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Tuning SQL query for better performance using SQL Profiler.
• Actively supported business users for change requests.

Environment: SQL Server 2005/2008, Enterprise Edition, SQL, Enterprise manager, SSRS, SSIS, SSAS, MS SharePoint, MS Access, VB.NET,ASP.NET, Team Foundation Server (TFS).

Confidential, Milwaukee, WI

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Gathering Requirements from the Business Users and developing the work flows.
• Performed Column Mapping, Data Mapping and Maintained Data Models and Data Dictionaries.
• Designed SSIS packages to migrate the data from DB2, flat files, excel documents and CVS files to the Staging Area in SQL Server.
• Expertise in Using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.
• Worked on Huge Data Transfers from and to SQL Server Databases using SSIS, and used Configuration Files and Environment Variables for production deployment.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Involved in retrieving multi-million records for data loads using SSIS and by querying against Heterogeneous Data Sources like SQL Server, Oracle, Text files, Great Plain, and some Legacy systems.
• Employed SSIS Data Profiler Task to profile Target Source Systems and build ETL Solutions, which was helpful in designing the table structures and cleaning data for data consistency.
• Used configuration files and variables to deploy SSIS packages across several Environments (Development/Testing).
• Developed drill down and drill through reports from multi-dimensional objects like Star and Snow Flake Schema using SSRS and performance point server.
• Developed Linked, Drill Down, Drill Through and Sub Reports using SSRS.
• Involved in optimization of queries and refining the performance using Data Purging, Index Optimization, Execution Plans, DMV’s and DMF’s.
• Developed Data Driven Subscription Reports and Ad-Hoc Reports using Report Builder in SSRS.
• Designed Subscriptions and Security for Reports.
• Created calculated measures using MDX implementing business requirement.
• Experienced working on Star and snow flake schemas and used the fact and dimension tables to build the cubes, perform processing and deployed them to SSAS database.
• Designed aggregations and pre-calculations in SSAS.
• Involved in designing Partitions in Cubes to improve performance using SSAS.

Environment: MS SQL Server 2005/2008, SSIS 2005/2008, SSRS 2005/2008, SSAS 2005/2008, Oracle 11g, VB.Net and Visual Studio 2008.

Confidential, Boston, MA

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications. Provided knowledge transfer to the company’s SQL programmers.
• Created several materialized views and UDF’s to be accessed by the new front end applications.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Created SSIS Packages 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 ware house.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Generated reports using SQL Server Reporting Services from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Designed ER diagrams and mapped the data into database objects.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Developed different types of tabular reports, matrix reports (cross tab or pivot) reports, chart and graphs, reports that aggregate data using SQL Server Reporting Services.
• Designed reports with grouping/sorting and parameters (including multi-value parameters) using SQL server reporting services.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: SQL server 2008/2005, BIDS, Reporting services, Integration Services, Windows Server 2003, HealthCare database, Oracle 9i, DB2,TFS.

Confidential

MS SQL Server Developer/DBA

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects likeProcedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server 2005.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist withcoding,designandperformance tuning.
• Managed user access. Created and managed new security accounts.
• Upgrade,Backupandrestoredatabases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created theSSIS PackagethroughETLProcess to vendors in which records were extracts from Flat file and Excel sources and loaded daily Confidential the server.
• Updated the statistics info for both the old and new servers.
• Assisted with various ad-hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2000, T-SQL, DTS Designer, MS-Office, Ms-Excel, VSS

Confidential 

Jr. SQL Developer

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Created documentation as required.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS).
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.

Environment: MS SQL Server 2000/2005, T-SQL, DTS, Visual Source Safe (VSS), SQL Server Management Studio, SQL Profiler.