SUMMARY

• Over 9+ years of IT experience in database design and development in Microsoft SQL Server Suite of Products.
• Expert in working with the Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS.
• Experience in SQL Server DTS and SSIS(Integration Service) package design, constructing &deployment.
• Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating Indexes, Develop Queries and Confidential - SQL Scripts MS SQL.
• Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.
• Experience with Confidential -SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity
• Experienced in writing complex Confidential -SQL queries using Inner, Outer and Cross Joins.
• Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Extensive experience in Writing Transact SQL ( Confidential -SQL) Queries, Dynamic-queries and implementing SQL Server Indexing.
• Having strong experience in scheduling all the Confidential -SQL jobs to run Confidential particular times.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Integrity using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique).
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience Confidential Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users.
• Developed reports using global variables, expressions and functions using SSRS.
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema.
• Proficient in buildingCubes,definingReferenced Relationshipsand creating Hierarchies in SSAS.
• Expertise in creatingCell Level Securityin cubes usingSSAS.
• Installed and configured Visual Studio for developing and testing environments.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports using Cognos.
• Strong experience in creating complex reports that use cascaded parameters.
• Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in Confidential -SQL.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfalland Agile.
• Excellent communication, analytical and inter personal skills and ability to quickly learn new concepts.
• Ability to work individually as well as in a team, quick learner, self-motivated, out of box thinker with excellent communication and interpersonal skills.

TECHNICAL SKILLS

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

ETL Tools: SSIS, Informatica Power Center 7.x, Ascential Data Stage 7.5, SAP - Business Warehouse, Power Query

Database Systems: MS-SQL Server 2000/2005/2008/2008 R2/2012, 2014, Oracle 9i,10g/11g, DB2,MS Access

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

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

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

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

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

Sr. SQL/SSIS/SSRS Developer

Responsibilities:

• WritingT-SQLscripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Implemented Complex business logic with User-Defined-Functions,Indexed Viewsand also created User Defined Data type,Clustered & Non-clustered Indexes.
• Created Business-Crucialstored proceduresandfunctionsto support efficient data storage and manipulation.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS.
• Used some data conversion tasks inSSISto load the data from flat file to SQL Server database.
• Created packages inSSISwith error handling and Worked with different methods of logging inSSIS.
• Performed database transfers and queries tune-up, integrity verification,data cleansing, analysis and interpretation. Developed, monitored and deployedSSISpackages.
• CreatedETLSSISpackages both design and code to process data to Confidential databases. Created document for Self-Service Deployment and Execution process forSSISpackages.
• Create and edit alerts on Reports, as per User request.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• 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.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• CreatedSSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Designed different type of reports tabular, matrix (cross tab), conditional, list items, charts formerly in Cognos 10.1.
• Highly involved in creating, structuring, formatting using Report Designer andReport Builder.
• Provided critical Production support when needed.
• Worked withMDXto query cube's data.
• Maintainingjobsfor data messaging from development server to test server for generating daily reports for financial and marketing team.
• Expert in automating process bycreating jobs and error reportingusing Alerts,SQL Mail Agent, FTP and SMTP.
• MS SQL Server Configuration,Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Used SQL Queries Confidential the custom SQL level to pull the data in Tableau desktop.
• Performed performance tuning of the dashboard in Tableau desktop.
• Published the developed dashboards into production and ensured the data was up to date byscheduling extract refreshes.

Environment: SQL Server 2014, 2012, 2008 R2,SSIS,SSRS, MS 2003, SharePoint, PL/SQL, C#, Cognos, Tableau, Business Intelligence Development Studio (BIDS), Visual Studio 2008 & 2005, MS Visio 2007.

Confidential, Plano, TX

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2000, and SQL 2005).
• Created Configurations to make package portable and created Event handlers for handling package error.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 asSSISPackages.
• 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.
• Created and modified various Stored Procedures used in the application using Confidential -SQL.
• Designed Cubes with star schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• 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.
• Moved packages on the Cognos framework manger and created new models and published packages on to report studio.
• Created list reports & cross tab reports using Cognos 10.1.
• Developed yearly and quarterly company expense reports.
• Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.
• Tuning SQL query for better performance using SQL Profiler.
• Actively supported business users for change requests.

Environment: SQL Server 2008/2012, Enterprise Edition, SQL, Enterprise manager, Cognos 10.1, SSRS 2008, SSIS 2005, Spotlight, MS SharePoint, MS Access 2000 & Windows 2003/2000 platform, VB.NET,ASP.NET.

Confidential, Anthem, CA

Sr. SQL Server BI/ETL Developer

Responsibilities:

• Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# and VB code as required
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Experienced in slowly changing dimension in SSIS packages.
• Performed incremental data load packages in SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Identified and Defined Fact relationships in SSAS.
• Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential, Minneapolis, MN

SQL Server/SSIS Developer

Responsibilities:

• Managed Enterprise and Distributed Data Warehouses in Developmental and Production Environments using SQL 2005/2008.
• Build and maintain complex SQL queries using Confidential -SQL for data analysis, data mining and data manipulation.
• Organize analytical data; ensure data quality and aggregate data for strategic reporting and performance optimization on database solutions.
• Created/designed reports using SQL Server Reporting Services according to user requirements.
• Responsible for writing SQL queries, Procedures, Functions and Database triggers.
• Good Experience in Tuning and Optimization of Confidential - SQL stored procedures.
• Optimizing the current ETL process, identifying and eliminating bottle necks and decreasing data latency.
• Created synchronized mechanism for data management in SQL Server. Set the job dependencies of SQL jobs using MSDB objects.
• Deployed and Scheduled the Reports in Report Manager.
• Extensively used the SSIS package to write the data from the flat files into tables.
• Extensively used Explain Plan, SQL Optimizers, Partitioning Tables and Gather Statistics to analyze and improve the performance of the Queries.
• Designed, developed and modified Cognosreports using Cognos Report Studio and Query Studio.
• Different database triggers were created and stored in the database and fired off when contents of database were changed.
• Involved in Performance Repository Project, where we collect data and generate report to Proactively Monitor the Servers and try to avoid any kind of Server and database related outages.
• Develop documentation of database architecture, system processes and procedures. Create, review and produce migration scripts of database objects from development to production environments.

Environment: MS SQL Server 2008/2005/2000 , MS SQL SSRS, SSIS, SSAS, Confidential -SQL, PL/SQL, Windows 2003 Server.

Confidential

SQL Server/SSIS Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML
• User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2000 to SQL Server 2005.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Developed a High level dashboard using SSRS 2005.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules usingT-SQL.
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end application
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions

Environment: SQLServer 2005/2000, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.