SUMMARY

• 7 years of IT experience as a MS SQL Server BI Developer specialized in database design, development and administration in SQL Server 2005/2008/2008 R2/2012 and worked in different domains like Healthcare, Financial, Banking, Retail, Investments, Insurance etc.
• Strong experience in Transact - SQL.
• Experience in writing complex queries involving Multiple Table Inner and Outer Joins, Temporary Tables, and Table Variables.
• Experience in writing complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Involved in optimizing code and improving batch efficiency with databases including re-indexing, updating statistics and recompiling stored procedures.
• Data migration using SSIS Services across different databases like DB2, Oracle, MS access & flat files.
• Good experience in Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Database Tuning Advisor, upgrading from DTS SQL Server 2005 to SSIS SQL Server 2008 packages.
• Experience in SSIS/DTS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• 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.
• SQL Server Analysis Services (SSAS) 2005/2008/2008 r2/2012 design and build experience that covers the following advanced features required ensuring high-performing, scalable solutions: multi-tier infrastructures, partitioning, aggregations, proactive caching, actions, and role and data-level security.
• Extensively worked with multidimensional expressions (MDX) to add calculated members and other dynamically calculated values to the Analysis Services cubes (SSAS Cubes).
• Hands on experience in analyzing existing Data-Warehouse and multidimensional structures, for identifying opportunities for redesigning to meet changing business needs.
• Experience in working of UAT environment to production.
• Experience in transforming the design of Relational Databases (OLTP) to the Data Warehouse (OLAP).
• 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.
• Strong analytical skills and ability to create and maintain a database environment to support business requirements.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008/2008 R2/2012

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Business Intelligence Development Studio (BIDS).

Reporting Tools: SQL Server Reporting Services (SSRS)

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), BCP, SQL Server Analysis Services (SSAS)

Languages: C, C#, T-SQL, VB.NET

Web Technologies: Web Services, XML, HTML

Operating System: Windows NT/2000/2003/XP, Vista, Server 2005,2008,2008R2,2012

Applications: MS-Office suite, MS Visual Studio 2005/2008/2010

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

SQL BI Developer

Responsibilities:

• Maintain data infrastructure and develop scripts for regular processes.
• Analyze data analysis requests obtained from management to determine operational problems and define data modeling requirements, validation of content, and problem solving parameters.
• Conducted complex analysis using advanced SQL to identify customers who are involved in Anti Money Laundering for Auto Finance.
• Conducted complex data analysis to identify customer’s details for OFAC (Office of Foreign assets control) and generate monthly report.
• Developed scripts for CIP Scrub to identify invalid PII information.
• Developed scripts for several other events that includes backdated rate change, bankruptcy, repossession and reinstatement, Dpay, Carpay, address matching etc.
• Developed, monitored and deployed SSIS packages.
• Designed SSIS packages to replicate the data from DB2, flat files and excel documents to the Staging Area in SQL Server 2008R2.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Developed SSIS Packages using lookup values & implementing rules provided by Business in the mapping document.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Developed daily/monthly jobs using CRON scheduler in UNIX for business risk office events.
• Completed Tableau and Python training provided by Confidential .

Environment: T-SQL, SAS, Teradata, UNIX

Confidential, Fort Worth, TX

SQL Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Developed several stored procedures and database objects as per business needs.
• Developed Logical and physical data model using ERWin and mapped the data into database objects.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses.
• Resolve and troubleshoot complex issues.
• Participated in all phases of SDLC starting from analysis to delivery of the application development projects and also supported enhancements and maintenance of existing applications.
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
• Worked with Tableau team to provide business users the data required for metrics and analysis.

Environment: T-SQL, MS SQL Server 2012, ERWin.

Confidential, Atlanta, GA

SQL BI Developer

Responsibilities:

• Automatic Restart of SSIS packages after Failover or Failure
• Created the Load packages for loading the CSV files and flat files from DB2 into SQL Server using SSIS 2008R2.
• Used SQL Server Destination in Data flow to improve a great performance changes in Replications.
• Used various Data Flow Transformations, like Lookup, Derived Column, Data Conversion, Union All, Multicast and Copy Column while developing the packages.
• Developed SSIS Packages using lookup values & implementing rules provided by Business in the mapping document.
• Scheduled Packages using SQL Server Agent Jobs. Monitoring nightly jobs.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Created package configuration in XML and used them to deploy packages into SQL server.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output.
• Identifying the mapping issues and discussing them with business analysts in team.
• Used VB.Net code in SSIS script task for sending dynamic email attachments with customized logging information.
• Monitoring Scheduled Agent Jobs and ETL process.
• Created reports using Reporting Services (SSRS) and developed Custom Report and different types of Tabular Reports, Matrix Reports, drilldown reports, and parameterized reports in multiple formats using multi - dimensional objects.
• Created different Parameterized reports and Subscribed through Data Driven Subscription.

Environment: T-SQL, PL/SQL, MS SQL Server 2008R2/2008, 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.

Confidential, Rockville, MD

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 2008r2.Developed Query for generating drill down reports in SSRS 2008r2.
• Designed and implemented stylish report layouts. Identified and worked with Parameters for parameterized reports in SSRS 2008r2.
• 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 Project Server 2010.
• Developed, monitored and deployed SSIS packages.
• Upgraded Analysis Service 2005 to SSAS 2008r2. Identified and Defined Key Performance Indicators (KPIs) in SSAS 2008r2.
• Developed complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code as per business requirements.
• 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 2008r2, Windows Server 2005/2008, DTS, SSIS, SSRS, SSAS, T-SQL, ERwin 4.0,MS Access, XML, MS Excel, Visual Studio 2008.

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 2008 to SQL Server 2008r2. 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 2008r2.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Developed Query for generating drill down and drill through reports in SSRS 2008r2.
• 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 2008r2 Enterprise Edition, MS SQL Server Reporting Services 2008r2, Erwin 4.1, Windows Server 2008, MS Access 2010

Confidential, Columbia, MD

SSIS /SSRS Developer

Responsibilities:

• Designed SSIS packages to import the data from DB2, flat files, excel documents and CVS files to the Staging Area in SQL server 2008r2
• 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 & to SQL Server Databases using SSIS, and used configuration files and Environment variables for production deployment
• Developed drill down and drill through reports from multi dimensional objects like star schema and snow flake schema using SSRS and performance point server.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Designed and developed various types of Reports using SSRS and rendered them in front end applications like Excel and .net.
• Analyzed database performance with SQL Profiler and Optimized indexes to improve query performance.
• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008 and 2008r2.
• Scheduled Packages using SQL Server Agent Jobs.
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2008r2 Reporting Services (SSRS) and Crystal reports.

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

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 2008r2.Developed Query for generating drill down reports in SSRS 2008r2.
• Designed and implemented stylish report layouts. Identified and worked with Parameters for parameterized reports in SSRS 2008r2.
• 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 Project Server 2010.
• Developed, monitored and deployed SSIS packages.
• Upgraded Analysis Service 2005 to SSAS 2008r2. Identified and Defined Key Performance Indicators (KPIs) in SSAS 2008r2.
• 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 2008r2, Windows Server 2005/2008, DTS, SSIS, SSRS, SSAS, T-SQL, ERwin 4.0,MS Access, XML, MS Excel, Visual Studio 2008.