SUMMARY

• Over 6 years of experience in diverse facets of IT, Financial, Healthcare and Chemical environments with primary skills on SQL and C# programming, encompassing analysis, design, development, implementing and testing client/server application using Microsoft Visual Studio, Microsoft SQL Server and BI suite.
• In - depth knowledge of T-SQL, C#, SSIS, SSRS, OLAP, BI suite, Reporting and Analytics.
• Expert in object oriented design and development in both backend and frontend using Microsoft SQL and.NET technologies.
• Strong experience in SQL Server database development and efficient data manipulation including complex T-SQL programming, creating complex Stored Procedures, Views, Functions, Indexes, Triggers, Tables, User Defined Data Types, and other SQL joins and statements.
• Proficient in CSS, JavaScript, jQuery, HTML, XML, and Ajax.
• Excellent in ETL implementation using SSIS control flow containers: For Loop, For Each Loop and Sequence, and using Script Task, Conditional Split, Derived Column, Data Conversion, Merge, OLEDB/ADONET Task, Lookup, Execute SQL, and File System in SSIS.
• Good ETL skills, Data modeling, Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity processes for the purposes of loading decision support applications utilizing advanced knowledge of DTS packages, C#, and Transact SQL, design and support/enhancement/maintenance.
• Expert in migrating big data from Oracle to MS SQL Server and importing data from Excel and Flat File to populate in web-based applications by creating methods in C# and using SSIS.
• Expert in creating reports according to business requirements and application platforms using SSRS in designing stylish report layout, parameterized, performance, custom reports and ad-hoc reports.
• Involved in DBA activities such as backups, restores, replication etc.
• Extensive use of DTS in SQL Server, Performance Tuning & Application Design, Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Stored Procedures, Functions and Cursors and Triggers etc.
• Extensive experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP, Bulk Insert, ActiveX.
• Strong Communication skills, quick-learning ability, very methodical and well organized with excellent bottom-line for work, motivated problem solver with strong analytical skills.

TECHNICAL SKILLS

Operating Systems/Relational Databases: Windows NT/98/2000 Server/XP/2003 Server/Vista/7/8, LinuxMS SQL Server 2005/2008/2012 , Oracle 11g, MS Access, Teradata

Programming Languages: SQL, PL/SQL, T-SQL C#, ASP.NET, CSS, JavaScript, jQuery, Ajax, HTML, XML

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS)

Database Tools: SQL Agent, Query Analyzer, SQL Profiler, TOAD

Version Tools: Team Foundation Server

PROFESSIONAL EXPERIENCE

SQL BI Developer

Confidential, San Antonio, TX

Responsibilities:

• Work closely with business people to review business and functional requirements and perform analysis of requirements and design regarding input, output, and processing needs.
• Design and develop windows forms and console applications in C#.
• Design and develop websites on ASP.NET framework through Agile/Scrum development methodologies.
• Create ASP.NET web forms, web user controls, and class libraries for business and data access logic using C# and ASP.NET.
• Develop web pages using ASP.NET and Telerik controls and develop CSS for user interface uniformity throughout the application.
• Write Javascript and jQuery for client side processing.
• Design and develop database objects like tables, stored procedures, views, user defined functions, defaults, constraints, and indexes in SQL to interact with the frontend application and handle complex business rules.
• Write T-SQL statements for retrieval of data and involve in performance tuning of T-SQL queries and stored procedures.
• Design SSIS packages to transfer data crossing different platforms and automate updating tables.
• Perform ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Design reporting database for existing applications and create SSIS packages to synchronize the data between application server and reporting server.
• Re-write SAS code into SQL and create SSIS packages and SSRS reports to automate the tasks.
• Code and create reporting for the business in response to their ad hoc requests and migrate applications in SSRS and upload in to as well.
• Re-write and convert Access and Crystal reports into SSRS reporting; configure and deploy different reports in the servers.
• Create and implement SSRS reports to support web-based applications.
• Deployed application on test and production server.
• Perform application testing, troubleshooting, and fixing bugs and errors.
• Provide performance/code review and optimization.
• Provide root cause analysis in production and support for a variety of SSIS jobs, SSRS reports, and desktop and web applications.
• Participate in server migration and production move.
• Confer with users to gain understanding of needed changes or modifications of existing application and work on enhancement to the existing applications.

Environment: Microsoft Visual Studio 2010, Telerik, Team Foundation Server 2010, SQL Server 2005/2008R2/2012, Oracle 11g, Teradata, SQL Server Integration Services (SSIS) 2008/2012, Microsoft SQL Reporting Services(SSRS) 2008/2012, Crystal, Access, SAS 9.3

SQL / BI Developer

Confidential, Washington D.C

Responsibilities:

• Performed an upgrade from SQL Server 2005 to SQL Server 2012.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user .
• Participated in logical design of database incorporating business logic and user requirements.
• Created and developed stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validated data during transferring, and archived data files for different DBMS.
• Created packages using DTS and SSIS for data extraction from Flat Files, Excel Files to SQL Server using ETL Tool and C#.
• Developed parameterized, drill down, and drill through reports, and implemented various reporting features such as Chart Control, interactive sorting, expressions and writing custom functions.
• Used SSRS subscriptions to schedule automatic delivery of SSRS reports.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Generated database monitoring and data validation reports in SSRS.
• Involved in Report writing according to business requirement using SSRS and Crystal Reports.
• Designed Cubes, Star Schema and Data models for Data Warehousing Applications.
• Developed reports where the data extracted from SSAS cubes in SSRS.
• Used Report Manager to create folder structures, modify data sources, controlling access to Report Services resources.
• Optimized query performance by creating indexes.
• Moved static data from various text files to SQL Server 2012 database using BCP Import and Export, Bulk Insert.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Provided support to the application developers on the application databases.
• Configured and Deployed different reports in the Servers using SQL Server 2012 Reporting Services.

Environment: MS SQL Server 2005/2012, Enterprise Manager, Management Studio, Integration Services, Reporting Services, SSRS, DTS, Data Modeling, Analysis Services, T-SQL, DB2, ETL, SQL Profiler, SQL Server Agent, Data Ware Housing, BCP, and Microsoft Visual Studio

SQL Server Developer

Confidential, San Antonio, TX

Responsibilities:

• Gathered functional requirements and business requirements and wrote technical specifications for building the Global Enterprise Data warehouse.
• Worked closely with developers, end users in designing and creating the Global Enterprise Data warehouse by using OLAP.
• Created database objects like tables, views, stored procedures, indexes etc.
• Wrote various Stored Procedures for the purpose of application development.
• Created SSIS Packages to import and export data from Excel spreadsheets and flat files.
• Created packages and scheduled jobs to perform filtering operations and import data on weekly basis.
• Transformed data from various data sources using OLEDB and ADONET connection and file manager by creating SSIS packages for different tasks.
• Responsible for database creation, database tuning, performance planning and database administration.
• Performed some DBA Tasks which included checking the job fails and troubleshooting the issues.
• Worked as IT Production support technician helping the end users in solving production problems.
• Involved in planning and administration of data migration and performance tuning to achieve cost efficiency and effectiveness of the system.
• Worked directly with the Business Team to resolve issues, perform special requests such as reports, and communicate changes to application.
• Prepared the detailed project layout, analyzed existing technology involved, and documented work performed.

Environment: SQL Server 2005 Enterprise Edition, SQL Server Integration Services (SSIS)

SQL Server Developer

Confidential, Chandler, AZ

Responsibilities:

• Installed SQL Server on Development and Production Servers, set up databases, users, roles and permissions.
• Responsible for technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Created Indexes to get the high level performance.
• Performed ETL operations to support data loads and transformations using SSIS.
• Involved in migration from Oracle to SQL Server 2005 using SSMA and SSIS.
• Developed Cubes using SQL Analysis Services (SSAS) and generated reports from the cubes by connecting to Analysis server from SSRS.
• Experienced in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration ofSharePointwithSSRS.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Maintained databases, performed software installations and upgrades, and monitored Database Performance.
• Implemented automated backup and database maintenance/cleanup jobs.
• Managed Logins, Users, Roles and User permissions.
• Ran Trace from the Profiler to trouble shoot database and ran DBCC consistency checks for other database maintenance aspects.
• Designed numerous ad-hoc and custom reports using SSRS.
• Created and scheduled jobs for various tasks and was also responsible for maintaining jobs.

Environment: SQL Server 2000/2005/2008 , Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), MS SQL Analysis Services(SSAS)