PROFESSIONAL SUMMARY:

• Over all 7+ years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2012/2008/2005/2000.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• Experience in creating visualizations using Tableau Desktop/Server 9/8.x/7.x/6.x
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• 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:

Operating Systems: Windows NT/98/2000/XP/2003 Server, Unix, Linux, Sun Solaris

Languages: T-SQL, CSS, HTML, ASP.NET, C#, .NET Framework, C

Data Warehouse Tools: SSIS, SSRS, SSMS, Business Intelligence Development Studio, DTS, Enterprise Manager, SQL Profiler

Databases: MS Access, MS SQL Server 2000/2005/2008/2012, Oracle 8i/9i/10g

Tools: /Utility: Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler

Reporting Tools: Excel, SQL Server Reporting Services 2012,2008,2005

Other Tools: MS Office, Visio, MS Excel, MS-Project 2000

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

SQL Server BI Developer (SSIS/SSRS)

Roles and Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Create Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, Tableau Desktop 9.x, MS Visual Source Safe and Windows Server 2003.

Confidential, NYC, NY

SQL Server BI Developer (SSIS/SSRS)

Roles and Responsibilities:

• Design/Build Extract Transform Load procedures in SQL Server Integration Services.
• Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.
• Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed user defined financial reports to provide on demand financial data analysis using SSRS
• Performed data conversions from flat files into a normalized database structure
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Involved in design, programming, deploy and Unit Testing of requested Reports.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users using Tableau.

Environment: SQL Server 2008 Enterprise Edition, SSIS 2008, SSRS 2008,.NET Framework, C#, ASP.NET,CSS,T-SQL, VisualStudio.NET IDE, XML, MS Excel, Tableau Desktop 8.x, MS Access, Visual Studio 2008.

Confidential, Arnold, MO

SQL Server BI Developer (SSIS/SSRS)

Roles and Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• To keep track of data manipulations using Audit functionalities.
• Generated custom and parameterized reports using SSRS.
• Created reports that call sub reports in SSRS.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Responsible for creating datasets using T-SQL and stored procedures.
• Created several packages in SSIS.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Used various transformation tasks to create ETL packages for data conversion.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.
• Performed Query optimization & Performance Tuning.
• Optimized queries using SQL Profiler and Database engine tuning advisor.

Environment: SQL Server 2008 Enterprise Edition, SQL Server Agent, SSIS 2008, SSRS 2008, C#,T-SQL, Windows 2000/2003 Server, XML, MS Excel, MS Access.

Confidential

SQL Server BI Developer (SSIS/SSRS)

Roles and Responsibilities:

• Involved in documenting the code for understandability.
• Participated in creating reports that deliver data based on stored procedures.
• Experience in creating snapshots of static reports and configure subscription.
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.
• Involved in developing triggers to audit schema changes at the database level.
• Created sub-reports to present more detailed information about the summary.
• Designed and implemented stored procedures and triggers for automating tasks.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Data from various sources like flat files, to SQL Server database Using SSIS Package.
• Used Lookups Transformation to get the data from reference data sets
• Scheduling the SSIS packages and Jobs
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Making a Report as per user requirement using MS Reporting Services 2005/2008.
• Created SSIS Packages to migrate slowly changing dimensions.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Worked on improving the performance of the system.
• Created permanent tables, temporary tables and table variables.
• Used Query Analyzer to optimize SQL queries.

Environment: SQL Server 2005/2008,SQL Server Integration Services(SSIS),SQL Server Reporting Services(SSRS), C#,VBScript, ASP.NET,T-SQL, MS Excel 2003, MS SQL Query Analyzer, SQL Profiler.

Confidential

SQL Server Developer

Roles and Responsibilities:

• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2005 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from Text to SQL Server.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2005/2000, DTS,T-SQL, VSS, VBScript, XHTML, XML, Windows 2000/2003 Server.