SUMMARY

• Highly motivated SQL server Developer with 7 Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2012/2008/2005, SSIS, SSAS and SSRS.
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2008/2005/2000 .
• Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000, DTS, SSIS, SSAS and SSRS 2005/2008.
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T - SQL Scripts and Batches.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Worked Extensively on ETL process using SSIS package.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Good understanding of Auto, Financial and Retail domains.

TECHNICAL SKILLS

.NET Technologies: ASP.NET 1.1/2.0/3.5, ADO.NET, LINQ, C#.NET, WCF, WPF, SilverlightWeb Services, Web Parts, .Net Framework 1.1/2.0/3.0/3.5/4.0

Programming skills: C, C++, C#, Java, Python, PL/SQL.

Web Technologies: HTML, CSS, XML, JavaScript, Ajax, JQuery, SOAP.

Databases: SQL Server 2005/08, MSSQL.

Development Tools: Visual Studio.NET 2005/08/10/12, SSIS,SSAS,SSRS

Web Servers: IIS 5.0/6.0/7.0, Apache, Tomcat.

Source Control: Team Foundation Service (TFS).

Reporting Tools: SAP Crystal Reports, SQL Server Reporting Services.

Modeling Tools: ERWIN, SSAS

Operating Systems: Server 2003/2008/2012, Windows 97/XP/Vista/7/8, UNIX/LINUX.

PROFESSIONAL EXPERIENCE

Confidential - VA

SR. SQL, SSIS, SSRS Developer

Responsibilities:

• Create Entity Relationship (ER) Diagrams to the proposed database
• Create database objects such as tables,views, stored procedures, Triggers etc.
• Develop reports in SQL Server Reporting Services.
• Design, Develop and Deploy SSIS Packages.
• Monitor industry trends and identify emerging technologies that should be adopted.
• Develop and maintain BI strategy.
• Monitor business use and performance of the BI and provide feedback to BI architects, developers, metadata manager, and database administrators.
• Develop, manage, schedule and document BI operations and tasks, including extraction, movement, loading, archival, security, backup and aggregate table creation.
• Create newSSISpackage to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• DevelopedSSISTemplates which can be used to developSSISPackages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Generated reports usingSSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Responsible for creating the reports basing on the requirements usingSSRS 2008.
• UsedExecution Plan,SQL Server Profilerto trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Wrote queries fordrill down reportsto get the dataset required to build the report. Identified and included report parameters for parameterized report. Formatted the reports usingGlobal variablesand expressions. Deployed generated reports onto theReport Serverto access it through browser.

Environment: MS SQL Server 2012, SQL Server Analysis Services, SQL Server Reporting Services 2008, Windows XP

Confidential - Auburn Hills, MI

SR. MS SQL/SSIS/SSRS Developer

Responsibilities:

• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Environment: SSIS, SSRS, MS SQL Server 2012/2008, C#, Visual studio 2008, MS Access, MS Excel, MS Office Access 2007.

Confidential - Frederick, MD

SR. MSBI Developer

Responsibilities:

• Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
• Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.
• Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
• Participated in requirement gathering, cube design, application design, SSAS development, training operational users.
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Creating complex cubes for seeing business data from different perspectives by slicing and dicing the data.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Designing and building data load procedures using MS SQL Server.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Configured product meta-data tables to support client data reporting needs.
• Incremental and full database recovery with experience of complex recovery scenarios.
• Performance: Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries.

Environment: MS SQL Server 2008/05, SQL Server Integration Services (SSIS), SSRS, SSAS, T-SQL, OLAP Services, MDX, Share point 2007, ASP.NET, C#.NET, XML, Microsoft Source safe, Clear Quest, Windows 2003.

Confidential - CleaveLand OH

ASP.NET and SQL developer

Responsibilities:

• Optimized existing schemas through normalization and de-normalization techniques.
• Created web application with ASP.net web forms and custom user controls.
• Implemented custom grid control for lazy loading of paginated grids.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, cross tabs and charts.
• Migrated homogeneous databases from SQL Server 2000 to SQL Server 2005.
• Created packages using SQL Server Integration Services (SSIS) from various database into different file systems.
• Involved in the installation and of the Reporting Services and its components.
• Configured and maintain Report Manager and Report Server for SQL Server Reporting Services (SSRS).
• User N-tier architecture to plug reports to presentation layer using Report viewer control.
• Created a Windows Communication Foundation (WCF) service to call into the data access tier.
• Created Tabular and Matrix Reports using Report Wizard and Report Designer and identifying datasets, data regions and Report Items accordingly.
• Developed complex expressions to calculate, group, filter, and format the contents of a report.
• Created parameterized reports using Stored Procedures and Query report parameters and cascading parameters.
• Created complex reports and enabled drill down functionality and applied the required formatting.
• Developed Sub Reports and Master Reports accessible by bookmarks.
• Managed and scheduled Reports Subscription as well as added new users and assigning appropriate roles.
• Created various Report Models based on the business requirement.
• Created Ad-hoc reports based on the requirement.
• Tested, debugged and troubleshot reports.
• Deployed and published reports to the Report Server.
• Implemented high performance OLAP solutions for data mining (SSAS).
• Developed Cubes using SQL Server Analytical Services (SSAS) for better Business Analysis.
• Involved in cube designing using SSAS 2005 and involved in the cube optimizations, named set calculated measures, aggregations, partitions and Time dimensions.
• Created develop complex SQL queries using various joins, sub queries and stored procedures.
• Bi Weekly build deployment as project implements Agile methodology.

Environment: Windows XP, MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Integration Services 2005, T-SQL.

Confidential

MS SQL Server and ASP.NET Developer (SSRS/SSIS)

Responsibilities:

• Designed and developed database solutions based on functional requirements.
• Web module development and deployment using ASP.net MVC3.0 with jquery.
• Implemented theme library with CSS classes and skins.
• Made integration with file server from web code to write attachments on a file server.
• Implemented database solutions that met expected quality standards.
• Monitored project status to meet milestones and resolve issues that might impact on quality or the ability to deliver to timescales or estimates.
• Implemented session tracking and auto save page data using times.
• Implemented single signon with parent frame application.
• Produced technical design documents for the schema and stored procedure specifications.
• Troubleshoot production, real-time performance and concurrency issues.
• Deliver work on time and to specification, with minimal supervision.
• Created Stored Procedures, User Defined Functions, Views and TSQL Scripting for complex business logic.
• Created Stored Procedures which generated the necessary fact and dimension tables and functions that allowed performing necessary calculations depending upon the requirements.
• Responsible for migration of data from SQL Server 2005 to SQL 2008.
• Migrated heterogeneous databases to MS SQL Server 2008.
• Designed and created different ETL packages using SSIS from Oracle source to SQL server as destination.
• Created SSIS Packages to export and import data from Text files, CSV files and Excel Spreadsheets.
• Designed and implemented SSIS packages for data integration.
• Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them.
• User N-tier architecture to plug reports to presentation layer using Report viewer control.
• Extensively worked on Cross tabbed and Matrix reports using SSRS.
• Designed and implemented indexing to optimize transactional and reporting performance.
• Implemented data integration processes to handle XML file generation or processing.
• Created XML schemas to validate data feeds.
• Used XPATH and XQUERY for XML parsing.
• Coordinated with web development team in .Net framework programming solutions.
• Integrated ASP.Net Web Pages to the SQL Server 2008 Back End.

Environment: Windows XP, MS SQL Server 2005/2008, MS SQL Server Reporting Services 2008, MS SQL Integration Services 2008, T-SQL, .NET, VSTS