SUMMARY

• Around 8 years of IT experience in Database Design, Data Modeling, Requirements Analysis, Application Development, Testing, Implementation and Deployments using SQL Server, Microsoft BI Tools like SSIS/SSRS (2005/2008/2008 R2)
• Expert in SQL Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), .Net Framework 4.0/3.5/2.0, ASP. NET, C#, AJAX, Visual Source Safe, Team Foundation Server (TFS), collabnet team forge, PVCS, Oracle using TOAD.
• Hands on experience in data Extracting, Transforming, and Loading (ETL) from various sources such as raw file, XML file, Oracle, DB2, MS Excel and Access database to SQL Server.
• Experience in creating Event Handlers, Precedence Constraints for executable such as packages, for each loop, for loop and Sequence Containers.
• Experience in migration of data using Bulk Insert command, SSIS, DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Excellent knowledge of using variables and expressions in packages for updating properties of package elements at run time and control looping within a package control flow.
• Experience in Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like by using multiple transformations provided by SSIS such as Conditional Split, Union All and Bulk Insert.
• Configured SSRS reports in Share point Environment.
• Creating SSRS reports from Cube.
• Experience in creating Power View Reports using Power Pivot Data sources.
• Expert experience in developing SSIS package framework (storage, deployment and management) for solutions across the projects using design best practices.
• Expert in Creating, Configuring and Fine - tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Proficient in developing large scale, fully normalized, and highly complex Relational Databases using SQL Server, Oracle, MS Access that include T-SQL, PL/SQL, Stored Procedures, Triggers, functions, Cursors, Views, Indexes Constraints and Data Modeling.
• Data loading on SQL Server, data migration from MYSQL to SQL server using SSIS.
• Experience in migration of data using Bulk Insert command, SSIS, DTS Packages, Import/Export Wizard and Copy Database Wizard
• Extensive experience in MS SQL Server 2000/2005/2008/2008 R2 and hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008/2008 R2.
• Extensively used Report Wizard, Report Builder for developing and deploying reports using SSRS.
• Experience in developing Custom Reports, Tabular Reports, Matrix Reports, Ad hoc reports and drill down, drill through and chart reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008.
• Expert in Creating,Configuring and Deploying SSRS Reports on the portal for user accessibility.
• Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduling DTS and SSIS Packages.
• Excellent experience in onsite-offshore model interacting with clients and Onsite managers.
• Experience working as individual developer, team player. Excellent communication and interpersonal skills.

TECHNICAL SKILLS

Languages: C#, Visual Basic 6.0, TSQL, PL/SQL. VB.Net, ADO.NET

Databases: SQL Server 2012/2008 R 2/2008/2005/2000 , Oracle 11g/Oracle 9i, MS Access 2000

Development Tools: Visual Studio.NET 2010/2008/2005/2003 , Access 2003/2010, Visual Studio 6.0, Share point 2012, SQL Developer Tool, TOAD, SQL PLUS

Web Servers: IIS 7/6/5

Third Party Tools: Telerik Controls, Aspose

Reporting Tools: SQL Server Reporting Services, Access 2003/2010,Crystal Reports 9.0

Versioning tools: TFS, VSS, Subversion

ETL Tools: SSIS

Operating System: Windows 7/ Vista/XP/ 2008/2003 Server

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL BI Developer

Responsibilities:

• Involved in requirement Analysis, Development, Testing, Deployment.
• Involved in creating design documents: Solution architecture, HLD and LLD
• Conducted performance tuning by using SQL Profiler .
• Used various transformations in SSIS like Data Conversion, Lookup, Fuzzy grouping, Conditional Spilt, Pivoting/Un-Pivoting Transformations with error handling for different modules.
• Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
• Scheduled SSIS packages by creating corresponding job tasks.
• Involving in Creating DW Architecture and design using MS BI.
• Generated Adhoc reports using T-SQL
• Configured SSRS Reports in Share point Environment.
• Created SSRS reports from Cubes.
• Developed, configured and Deployed reports in MS SQL Server environment using SSRS-2008
• Worked on Sub Reports, Data Drill-Down and Data sorting/grouping Report Design in SSRS.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Used dynamic parameters in SSRS to enable/disable parameters based on user selection.
• Participated in User Acceptance Testing for Reports and also trained end users in ad hoc reporting.
• Provide production support by writing data scripts to fix defects and also developed new enhancements as and when required.
• Coordinating with customer, vendor and onsite/offshore folks.
• Involved on Global delivery environment, engaging with teams in an onsite/offshore model

Environment: C#,ASP. Net 4.0,SQL server 2012, XML, Collabnet, MS Visio 2007, SSIS, SSRS,SSAS.

Confidential, Jersey City

Sr. SQL BI Developer

Responsibilities:

• Involved in requirement Analysis, Development, Testing, Deployment.
• Involved in creating design documents: Solution architecture, HLD and LLD
• Conducted performance tuning by using SQL Profiler .
• Worked on importing and cleansing of data from MS Access onto SQL Server 2008R2
• Used various transformations in SSIS like Data Conversion, Lookup, Fuzzy grouping, Conditional Spilt, Pivoting/Un-Pivoting Transformations with error handling for different modules.
• Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
• Scheduled SSIS packages by creating corresponding job tasks.
• Performed system restoration, data back up as per requirement and also scheduled data backup
• Used Copy Database Wizard to copy databases and their objects from one server to another
• Managed server security, created new logins for users for System Integration Testing (SIT), User Acceptance Testing (UAT) and on production environment
• Generated Adhoc reports using T-SQL
• Configured SSRS Reports in Share point Environment.
• Created SSRS reports using Share point Data sources.
• Deployed BI Features in Share point 2012.
• Created Power Pivot data sources for creating Power View Reports.
• Developed, configured and Deployed reports in MS SQL Server environment using SSRS-2008
• Worked on Sub Reports, Data Drill-Down and Data sorting/grouping Report Design in SSRS.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Used dynamic parameters in SSRS to enable/disable parameters based on user selection.
• Participated in User Acceptance Testing for Reports and also trained end users in ad hoc reporting.
• Provide production support by writing data scripts to fix defects and also developed new enhancements as and when required.

Environment: C#,ASP. Net 4.0,SQL server 2012, XML, Collabnet, MS Visio 2007, SSIS, SSRS,Share Point 2012.

Confidential, Florida

Sr. SQL BI Developer

Responsibilities:

• Key player in a team that is responsible for data migration from MYSQL to SQL server database using SSIS.
• Established role based security using Sitemap.
• Configured SSRS reports using Share point.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Configured SSIS Packages in Development and Production Environment.
• Automated emails through SSRS Subscriptions.
• Creating Chart Reports using SSRS.
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear view of the reports.
• Configured SSRS Reports in Share point Environment.
• Created SSRS reports using Share point Data sources.
• Deployed BI Features in Share point 2010.
• Created Power Pivot data sources for creating Power View Reports.
• Used dynamic SQL extensively in stored procedures.
• Create Functions and Views using T-SQL in Development and Production environment for SQL Server 2008/2005.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Created SSIS package to import data into SQL Server from XML files.
• Set up ETL Jobs to run on a nightly basis into the Data marts using SQL Server Agent.
• Maintained and supported reports using SSRS Reports.

Environment: C#. Net 4.0, WCF, XML, Access 2003/2010, SQL Server 2012/2008/2005 , LINQ to SQL, SSRS, SSIS, Share Point 2010

Confidential

Sr. SQL BI Developer

Responsibilities:

• Used ADO .NET Components to connect the database server for data retrieving, querying, storing and manipulation.
• Used ASP.NET Server Controls, Validation Controls, Grid View and User Controls.
• Implemented transaction executions safely by using COMMIT and ROLLBACK commands.
• Creating Drill down, drill through report using SSRS.
• Creating Chart Reports using SSRS.
• Creating Dynamic SSRS reports using .NET application.
• Creating SSIS packages using .NET application.
• Set up ETL Jobs to run on a nightly basis using SQL Server Agent.
• Configured SSRS reports using Share point.
• Used cascading style sheets to provide standard template style on all Web Pages.
• Involved in creation of Test Plan and Test Cases.

Environment: .NET 3.5, SQL Server 2005,ADO.Net, VSS,Windows 2000 Server, SSRS, SSIS

Confidential

SQL BI Developer

Responsibilities:

• Responsible for the designing, development of GUI and the business logic.
• Used ADO .NET Components to connect the database server for data retrieving, querying, storing and manipulation.
• Used ASP.NET Server Controls, Validation Controls, Grid View and User Controls.
• Created Drill down, Drill through report using SSRS.
• Created Dynamic SSRS reports using NET application.
• Used SSRS Subscriptions for Scheduling the Emails.
• Created SSIS packages using various transformations.
• Used cascading style sheets to provide standard template style on all Web Pages.
• Involved in creation of Test Plan and Test Cases.

Environment: .Net 3.5, C#, HTML, CSS, XML, Javascript, SQL Server 2005,ADO.Net, Windows 2000 Server, SSIS, SSRS

Confidential

SQL BI Developer

Responsibilities:

• Used ADO .NET Components to connect the database server for data retrieving, querying, storing and manipulation.
• Implemented transaction executions safely by using COMMIT and ROLLBACK commands.
• Creating Drill down, Drill through report using SSRS.
• Create SSIS packages for getting data from various sources and load into the SQL Server database.

Environment: .Net 2.0, C#, HTML, CSS, XML, Javascript, SQL Server 2005,ADO.Net, Windows 2000 Server, SSIS,SSRS