SUMMARY:

• 7+ Years of experience as a Microsoft SQL Server Developer specialized in database design, development and administration in OLAP, OLTP environment in SQL Server 2000/2005/2008/2012 and worked in different domains like Financial, Banking, Investments, Insurance, Telecommunications and Health Care.
• Expertise in executing complex queries using stored procedures, Triggers, Cursors, User Defined Functions using T - SQL.
• Experienced in implementing various logic using objects like Tables, Joins, Views, Roles and Constraints using Data Definition Language (DDL), Data Manipulation Language (DML), Data control language (DCL) and Transactional Control Language (TCL).
• Hands on experience in Data Modeling (Conceptual, Logical and Physical Design of Databases), Normalization, De-Normalization and building Referential Integrity Constraints.
• Experience in installing, upgrading and configuring MS SQL Server 2005/2008/2012.
• Expert in client requirement Analysis, Physical, Logical design, development, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2012/2008/2005 DTS, SSIS, SSAS and SSRS 2005/2008/2012.
• Familiar with performance tuning and query optimisation applying tools like SQL Server Profiler, Performance dashboard, Database Tuning Advisor and Index Tuning Wizard.
• Good Understanding and experience of SQL Server 2005 novel concepts like Data partitioning, Sliding window implementation, Snapshot Isolation, Online Indexing, Try-Cache Blocks, Dedicated Admin Connection (DAC), Data Base Snapshot, Common Table Expression (CTE), DDL Triggers, Dynamic Management Views (DMV) & Dynamic Management Functions (DMF).
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Sound knowledge of software development life cycle (SDLC) with solid experience along with object oriented analysis and design methodologies
• Expertise in using Visual source safe (VSS), Team Foundation Server (TFS), Subversion as a tool for source control, data collection, reporting and Confidential tracking.
• Experience in working of UAT environment to production.
• Extensive experience in designing, retrieving and deploying SSIS (Integration services) packages.
• With Reporting Services (SSRS), experienced in creating tabular, matrix, ad hoc reports based on predefined models and interactive reports from relational, multidimensional or XML data sources and publishing reports, scheduling report processing, or accessing reports on-demand.
• UseSharePoint2010 Insights to design organizational-wide dashboards with scorecards, indicators, and analytical charts.
• Proficient in SSAS (Analysis services) functions like calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles within a cube.
• Experience in working with conjunction with Tableau Software which provides a visual analysis solution that lets you explore your data with questions.
• SQL Server Analysis Services (SSAS) 2005/2008/2012 design and build experience that covers the following advanced features required to ensure high-performing, scalable solutions: multi-tier infrastructures, partitioning, aggregations, proactive caching, actions, and role and data-level security.
• Ensure standardization of systems implementation, support techniques, and adherence to formal processes, change control, best practices, and total quality practices in all activities.
• Well acquainted with high availability solutions like Database mirroring, Fail over clustering, Log Shipping, Replication, Scalable shared Databases.
• Strong written and verbal communications. Interested in a challenging technical track career in an application development environment.
• Exceptional ability to quickly master new technologies and capable of working in-group as well as independently
• Strong analytical skills and ability to create and maintain a database environment to support business requirements.

TECHNICAL SKILLS

RDBMS/ Database: SQL Server 2000/2005/2008/2012 Oracle 8i/9i, MS-Access 2007

Reporting tools: Crystal Reporting 10.0, SQL Server (SSIS, SSAS, SSRS), SharePoint

Data Modeling: Microsoft Visio 2007, Erwin 4.0/3.5,Informatica

Languages: C#, C++, T-SQL, PL/SQL

Scripting Languages: VBScript, JavaScript, UNIX shell scripting

Markup Languages: HTML, DHTML, XML, XSL, and XSLT

GUI: Visual Studio.Net, Visual Studio 9.0/2008

Component Technologies: COM / DCOM and MTS.

Web Design Tools: Dream Weaver CS3, FrontPage 2002, Outlook Express, Adobe Flash

Server Technologies: IIS

Scripting Languages: Shell scripting, Perl Scripting, Java Scripting

Operating Systems: MS-DOS, Windows 2008/XP/NT/Vista, UNIX

PROFESSIONAL EXPERIENCES:

Confidential, Omaha, NE

SSIS / SSRS / SSAS Developer

Responsibilities:

• Wrote complex Stored Procedures and triggers to capture updated and deleted data from OLTP systems.
• Worked with auditor’s team for reconciliation of payments and found out the discrepancies in veteran affairs.
• Worked on new SQL 2012 features like contained databases, column store indexes, T-SQL functions, spatial features, data visualization etc.,
• Migration of data from SQL SERVER 2008 R2 to SQL SERVER 2012 .Upgrading the previous versions of SQL SERVER.
• Worked with writing macros in Power Pivot and Power View for Excel which supports an interactive data-driven modeling experience where users can bring in new data sources or extend their model fluidly.
• Assisted in complete Life Cycle including Design and Development and created SSIS Packages to import and export data from Excel Spreadsheets, Text file and CSV files and created SSIS packages which includes data staging like importing, Cleansing, Parsing, scrubbing by using SSIS tools.
• Used C# code to write complex packages for loading and transforming data.
• Created a database design for new OLTP database where user application is connected to it and helped in managing transactional volume for operations.
• Applied various Data flow and Control flow transformations to meet the business needs.
• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the scheduled jobs.
• Worked on large TB databases and improved their performance by devising a plan by archiving the data to archived databases using SSIS packages.
• Designed and deployed Reports with Drop down menu option and Linked reports.
• Created Sub Reports, Parameterized and Drill down Reports.
• Built and deployed SQL Server Reporting Services Reports - in an IntegratedSharePoint environment.
• Formatted the reports using the Global variables and expressions.
• Created Data Model (logical/Physical) for Data Warehouse and Data Mart to manage current and future needs.
• Built Analysis Services cubes to manage multidimensional structures of aggregated data.
• Used Analysis Services predictive analytics feature to create calculations/algorithms in order to perform ad-hoc query analysis.
• Implemented DATA MINING MODELS by using algorithms like Microsoft Clustering, Decision Tree analysis.
• Involved in implementation of strong referential integrity and auditing by the use of triggers and defined check constraints, rules, indexes and views based on business requirements.
• Used Execution Plan, SQL Profiler and Database engine tuning advisor to optimize queries and enhance the performance of Databases.
• Scheduled Backup and Restore Strategies on development and production servers.
• Working on the ETL processes so that it cannot cause hurdles to the reports.
• Implemented the Transactional Replication with Queued update method.
• Worked as database administrator maintained SQL Server security roles and grant and deny permissions to groups of users, greatly reducing the security workload.
• Ensuring and proactively monitoring availability and performance of the SQL Server databases, basic performance tuning; analyzing data and back end application logic and back-up and recovery of SQL Server databases ensuring minimum downtime and 100% recoverability.

Environment: MS SQL Server 2008R2/2012, T-SQL, DTS, SQL Server Data Tools, SQL Server Query Analyzer, SQL Server BIDS, SSIS, SSAS, SSRS, MS- Visual Studio 2008, XML.

Confidential, Columbia, MD

SSIS /SSRS Developer

Responsibilities:

• Developed and Optimized database structures, stored procedures, Triggers and Functions for the application.
• Used the Microsoft BI Stack tools like some of the components Excel, Power Pivot for Excel, Data Mining and Visio.
• Used the Microsoft BI stack tools like Share Point Server, and BI tools like integration services, reporting services and analysis services.
• Participating in all phases of software development lifecycle: requirements analysis, technical design, implementation, acceptance testing, and warranty support.
• Created queries and manipulated the data
• Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2008.
• Created various SSIS/DTS Packages as per business requirements. Modified existing packages to incorporate changes and to improve performance.
• Database Developer for Development, Test and Production servers with MS SQL Server 2008 on Windows XP/Vista.
• Installed, configured, administered and secured SQL Server 2008 on Server and Clients.
• Data migration is done by cleansing the data
• Using SQL SERVER created complex Queries for Data Migration and Transformation.
• Involved in Querying (SQL queries) and updating records and validate Database records as expected.
• Working extensively on the data warehouse and analyzing for cleansing the data.
• Used Performance Point Server to provide users with rich dashboard filters to dynamically filter all the report views displayed on the dashboard.
• Set naming conventions for objects based on SQL standards.
• Proactively identifying and resolving application performance issues.
• Communicating with both technical and non-technical staff to support analysis, design, testing, and troubleshooting of Confidential issues.

Environment: MS SQL Server 2008, T-SQL, DTS, Data Profiler, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server Management studio, Microsoft SharePoint, Microsoft Visio, XML.

Confidential, Sacramento, CA

SQL Server/ BI Developer

Responsibilities:

• Participating in all phases of software development lifecycle (SDLC): requirements analysis, technical design, implementation, acceptance testing, and warranty support.
• Database Developer for Development, Test and Production servers with MS SQL Server 2005 on Windows XP/Vista.
• Installed, configured, administered and secured SQL Server 2005 on Server and Clients.
• Migrated data’s from SQL 2000 to 2005 and solved related issues. Created complex SSIS Packages for Data Migration and Transformation.
• Experience in MS SQL Server upgrades from 7.0 MS SQL Server 2000 and from 2000 to MS SQL server 2005.
• Migrating DTS packages to SSIS Packages. Set naming conventions for objects based on SQL standards.
• Representing the development team in all triage meetings to hash out major issues concerning application development and testing. Developing unit-tested high quality code. Proactively identifying and resolving application performance issues.
• Communicating with both technical and non-technical staff to support analysis, design, testing, and troubleshooting of Confidential issues.
• Involving in requirements gathering, application design in web and windows forms, System Design and Code Development, Data Design recommendations, and technical writing. Working on additional projects and tasks as they are assigned.
• Improving the efficiency and effectiveness of the state's Unemployment Insurance (UI) program, the Employment Development Department (EDD) initiated the UI Modernization (UIMOD) Confidential with the Confidential management service provided by the Office of System Integration (OSI).
• Experience in SSIS for constructing packages; and the Integration Services service for running and managing packages.
• Using SSRS, performed Ad hoc reporting with the Report Builder application, managing the Reporting Services environment, securing Reporting Services, on-demand report delivery, mastering the Report Viewer controls, subscribed report delivery and Extending Reporting Services Performance and scalability.
• Expert in SSAS for designing Dimensions, Measure groups and measure, interacting with cubes, managing Partitions and Database Processing.

Environment: MS SQL Server 2008/2005/2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server BIDS, SSIS, SSAS, SSRS, MS- Visual Studio 2008

Confidential, Boston, MA

SQL Server Developer/ SSIS / SSAS / SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation for the public data collected.
• Created Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created Views to reduce database complexities for different kinds of users like per page users, per month users, county users.
• Created and integrated User Defined Functions and Stored Procedures for reporting purpose.
• Created high quality reports, dashboards and analytics to meet the needs of various business clients such asOperations, Sales, Customer Service, Finance, and Executives.
• Created Sub-Reports, Drilldown-Reports for the clients.
• Scheduled Summary Reports, Parameterized Reports and Ad Hoc reports for viewing purposes by the managers for the analysis purpose.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Used conditional formatting to change the behavior of the report depending upon the requirement.
• Created T-SQL Triggers and Stored Procedures to retrieve updated and deleted data from different servers from different locations.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery for the data.

Environment: SQL Server 2005/2008, MS Analysis Service SSAS Developer 2008, SSRS, MS Confidential, MS Access 2007 & Windows 2K platform, Microsoft Team Foundation Server.

Confidential, Madison, WI

SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Developed and Optimized database structures, stored procedures, Triggers and Functions for the application.
• Handled the migration of SQL Server 2000 to SQL Server 2005. Responsible for DTS to SSIS Migrations, designing and maintaining SSIS packages.
• Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2005
• Responsible for developing, monitoring and deploying SSIS packages.
• Responsible for analyzing/gathering the user requirements to generate reports using SSRS 2005.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Developed Query for generating drill down and drill through reports in SSRS 2005.
• Formatted SSRS reports using Global Variables, Expressions and Functions for the reports.
• Configured Report Model for developing ad-hoc reports by the end-users.
• Uploaded reports on to the report manager and organized them into folders.
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
• Involved in creating SQL server Analysis Projects using MS SQL Server 2005.
• Created SSRS reports from Analysis Services using MDX and DMX Queries.
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for constant availability.
• Used Database Maintenance Wizard to make necessary changes and to keep the performance of the server at acceptable levels.

Environment: MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services 2005, Erwin 4.1, Windows Server 2003, MS Access 2007

Confidential, Dallas, TX

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created database objects like tables, views, indexes etc. Developed direct connection between Access and SQL databases.
• Created Application Roles and security using ADP. Identified the Data Source and defined them to build the Data Source Views
• Created SQL Server Reports using SSRS 2005.Developed Query for generating drill down reports in SSRS 2005.
• Designed and implemented stylish report layouts. Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Generated professional charts and diagrams Using Microsoft Confidential Server 2007.
• Developed, monitored and deployed SSIS packages.
• Upgraded Analysis Service 2000 to SSAS 2005. Identified and Defined Key Performance Indicators (KPIs) in SSAS 2005.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables. Designed and applied entity and attributes description and definition for the models.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

Environment: - MS SQL Server 2005, Windows Server 2003/2000, DTS, SSIS, SSRS, SSAS, T-SQL, ERwin 4.0,MS Access, XML, MS Excel, Visual Studio 2005.

Confidential

SQL Server Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Performance tuning to optimize SQL queries using query analyzer and DMV.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in Confidential planning, scheduling for database module with Confidential managers.
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Developed, monitored and deployed SSIS packages.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Provided via the phone, application support. Developed and tested Windows command files andSQLServerqueries for Production database monitoring in 24/7 support.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.

Environment: Microsoft Windows Cluster Server 2003, Windows 2000/2003/Server, MS SQL 2000/2005, C#, XML, Crystal report