SUMMARY:

• About 7 years of experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and Business Intelligence Suite.
• Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server 2012/2008.
• Expert in writing T - SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Experience in Microsoft stack of BI solutions - SSRS, SSIS with MS SQL 2012/2008.
• Experience in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
• Experience in Extracting, Transforming and Loading (ETL) data from various sources to several destinations using BCP utility, DTS and SSIS.
• Experience in Enhancing and Deploying the SSIS Packages from Development Server to Production Server using Execute Package Utility.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort, Data conversion, Pivot and un-pivot and Derived Column for cleaning bad data, validating the data.
• Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Experienced in developing GUI applications in .NET with SQL server, MS access and Oracle as backend.
• Experienced in database server performance tuning and optimization of Complex SQL queries.
• Experience in Change Management process in creating, updating, closing the Change Request and Problem tickets using ticketing system tool called BMC Remedy.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Experience in performing DBA tasks using Enterprise Manager and Query Analyzer.
• Experience in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.
• Experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.
• Experience in Software Development Life Cycle (SDLC) specifically waterfall and Agile methodology
• Expertise in designing Database Models using MS Visio.
• Ability and willingness to learn new technology and deliver results in a timely manner.
• A well-organized, goal-oriented, highly motivated effective team member.

TECHNICAL SKILLS:

SQL Server Tools: SSMS, BIDS, Enterprise Manager, DTS, Profiler, Upgrade Advisor, Visual Studio TFS(Team Foundation Server)

ETL & Reporting Tools: SSIS, SSRS, SSAS, Business Objects, Hyperion, Qlikview

Databases: MS-SQL Server 2012/2008/2005 , MS Access 97/2000, Oracle, DB2, MySQL

Programming Languages: Net framework, ASP.NET, C, C++, C#, XML, PHP, HTML, Java Script and VB Script, MS Visio, T-SQL, PL/SQL

Operating System: Windows 95/98,NT,Windows XP/2003/2000,Unix,MS-DOS

Web technologies: HTML, XML, VBScript, JavaScript, ASP, C#, ASP.NET, VB.NET, SharePoint

Tools: JIRA,TOAD, Bug Tracker.net, Tidal, Red Gate, BMC Remedy, Autosys

PROFESSIONAL EXPERIENCE:

MS SQL Server/BI Developer

Confidential, San Antonio, TX

Responsibilities:

• Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
• Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources.
• Developed, monitored and deployed SSIS packages. 
• Worked in transferring the data using SQL  Server Integration Services packages
• Extensively used SSIS Import/Export Wizard for performing the ETL operations.
• Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages.
• Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
• Expertise in creating Property Expressions, Script Tasks for SSIS packages.
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• Involved in Performance Tuning of Code using execution plan and SQL  profiler. Added Indexes to improve performance on tables.
• Writing queries to generate reports for analysis of data using SQL  Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008/2012.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Worked in SDLC (Systems Development Life Cycle) for developing systems/Software.
• Worked on Tech Design Document for projects.
• Use of SharePoint 2010 and TFS for version controlling, storing and report the same by creating Tasks in TFS.
• Created JIL scripts for creation of Autosys jobs.
• Involved in development and scheduled jobs using Autosys  for automation.
• Maintain (Add/Delete/Modify) Jobs based on business requirement using Autosys . 

Environment: MS SQL  Server 2012/2008 R2, MS  SQL Server Integration Services 2005/2008, MS SQL  Server Reporting Services 2005/2008, Windows Server 2003, Sharepoint 2012/2010, ASP.NET, Query Analyzer, VB.Net, C#, Visual Studio, HTML, Java Script, System Monitor/Performance Monitor, Event Viewer, Autosys , SQL  Clustering, Source Control Management System, Index Tuning Wizard, SDLC, Data Warehousing, Data Transformation Services (DTS).

MS SQL Server/BI Developer

Confidential, Medford, MA

Responsibilities:

• Developed SSIS Package using MS SQL Server Integration Services in such a way it loads last 4 days’ data from oracle into SQL Server database to store consistent and durable data 
• Built new SSIS Packages incrementally loading data dynamically on to SQL Server destination tables from different OLEDB, Flat File, .TXT and Excel files 
• Deployed SSIS packages by creating configuration files making packages dynamic by creating variables 
• Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages, extensively worked on mappings, incremental data loading, and SSIS transformations 
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE) 
• Granted permissions to logins, groups to particular database or to a server depending on the requirement. 
• Regularly monitored database sizes and disk space. 
• Arranged meetings with the developers and other DBA's to discuss the current and new policies which can be established. 
• Monitored SQL server performance using profiler to look for dead locks, blockings and captured long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing through Profiler. 
• Created indexes to speed the execution of data retrieval queries, rebuilding them if necessary and often checked for any outdated statistics 
• Configured and maintained MySQL database servers.
• Scheduled the backups for Databases and performed restoration operations when needed. 
• Used log shipping for synchronization of databases and documented every change. 
• Created the dimensional & relational models for various databases for monitoring tools, created database, SSIS standards of development, configuration & deployment of the Packages 
• Designed & developed the various SSIS packages for the daily, Hourly, Weekly & Monthly Loads 
• Worked on error handling using try and catch blocks and performance tuning using counters in SSIS 
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute sql flow task, data flow task to extract data from different databases and flat files 
• Designed different type of reports tabular, matrix (cross tab), conditional, list items, charts formerly in cognos reports and SAP BO 
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance 
• On the required reports, identified various data sources and established the connections using SSIS and constructed data source view 

Environment: MS SQL Server 2012/2008, DB2, Teradata, Microsoft Access, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SSRS, SSAS, T-SQL,MySQL, PL/SQL, MDX/DMX, TFS, MS Visio, Agile Scrum Methodology, Microsoft Access, Microsoft Project, XML, IIS

MS SQL Server/BI Developer

Confidential, Orrville, OH 

Responsibilities:

• Migrated data from Heterogeneous data sources (Excel, Flat file, CSV file) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints. 
• Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to load underlying data in to the tables from Text files, Excel file and CSV file. 
• Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop) 
• Created SQL Server Reports using SSRS 2012. 
• Developed Master Child Package by using Execute Package Task and Parent Package Variable Configuration. 
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure 
• Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement. 
• Created Views and Synonym to reduce complexity of end user Responsibility for gathering/refining requirements from the customer for developing reports. 
• Identified the Data Source and defining them to build the Data Source Views. 
• Developed Query for generating drill down reports in SSRS 2012.
• Designed and implemented stylish report layouts. 
• Generated Reports using Global Variables, Expressions and Functions for the reports. 
• Identified and worked with Parameters for parameterized reports in SSRS 2012. 
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible. 
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques. 
• Schedule the packages to keep extracting the data from OLTP at specific time intervals. 
• Responsible for rebuilding the indexes and tables as part of performance tuning. 
• Monitored performance and optimize SQL queries for maximum efficiency. 
• Used SQL Server Agent for scheduling jobs and alerts. 
• Configuration and Deployment of all reports across various SDLC environments. 
• Deployed the packages to production using XML package configuration.

Environment: SQL Server 2008 R2/2008, SSRS 2012, SSIS  2012, DB2, Oracle 9i/10g, Visual Studio 2012, XML, XSLT, MS Office and Visual source safe.

MS SQL Server/BI/SSIS Developer

Confidential, Conshohocken, PA

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Actively Participated in developing logical models and implementing requirements on SQL Server 2008.
• Worked extensively with complex T-SQL queries, stored procedures.
• Created SSIS packages to load the data into the staging and the main tables along with archiving of the data into the history tables maintaining the back up of data
• Scheduled SSIS packages to run every morning in tidal jobs.
• Created different types of SSRS Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting using SSRS.
• Generated monthly reports using SSRS for different Line of Businesses depending on the requirement
• Experience in developing applications using .NET framework 3.5/4.0, VB.Net, Win Forms, Web Services and Entity Framework
• Identified the Data Source and defined them to build the Data Source Views.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Performed tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Extensively worked on design, plan and implementation of automating the current process.
• Worked on multiple projects simultaneously.
• Involved in testing, bug fixing and documentation for the project.

Environment: SQL Server 2008R2/2008, SQL BI Suite (SSAS, SSIS, SSRS), Toad, SQL Profiler, DB2, .Net framework 3.5/4.0, MS Office, Visual Studio, Tidal, Business Objects.

MS SQL Server Developer

Confidential, Akron, OH

Responsibilities:  

• Collected business requirements from users and translated them as technical specs and design docs for development. 
• Worked as a developer  in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL  joins for applications. 
• Extensively used T-SQL   in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity. 
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance. 
• Extensively used SSIS to move data from text files to SQL Server . 
• Views using T-SQL   in Development and Production environment for SQL Server  2008. 
• Created Quality Assurance stats reports using SSRS 
• Created SSIS packages for new projects utilizing Business Intelligence Development. 
• Writing complex Stored Procedures to meet the business requirements. 
• Using SQL  Profiler to estimate the Slow Running queries and performance tuning purpose. 
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters). 
• Created data sources, connection strings and defined the datasets for generating the report. 
• Worked on all types of report types like tables, charts, sub reports etc. 
• Created Linked reports, Ad-hoc reports etc based on the requirement. Linked reports are created in the Report Server  to reduce the repetition the reports. 
• Developed, monitored and deployed SSIS packages. 
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. 
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS. 
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages through Active Batch Job Scheduler. 
• Created subscriptions to provide a daily basis reports. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time. 

Environment: MS SQL Server 2008, Windows 2003, Excel, TSQL, Microsoft Visual Studio 2008, SQL Reporting Services, SQL integration services.

SQL Developer Consultant

Confidential

Responsibilities:  

• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS) and bulk copy.
• Requirement gathering - Solution design. 
• Involved in the migration from SQL server 2000 to 2005. 
• Actively involved in Normalization of database. 
• Designed DDL and DML for MS SQL S erver 2005. 
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions. 
• Created Triggers to enforce data and referential integrity. 
• Actively designed the database to fasten certain daily jobs, stored procedures. 
• Optimize query performance by creating indexes. 
• Involved in writing SQL batch scripts. 
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL Queries and Stored Procedures. 
• Involved in merging existing databases and designed new data models to meet the requirements. 
• Perform daily database backup & restoration and monitor the performance of Database Server. 
• Use DDL and DML for writing triggers, stored procedures, and data manipulation. 
• Installed and Configured SQL Server 2005 on development server for designing and testing. 

Environment: SQL Server 2005, Windows XP/2000/98/95.