SUMMARY

• 8 Years of IT Experience in Database Design, Development and Support of Microsoft SQL Server 2008/2005/2000 in Development, Test and Production Environments with various business.
• 5+ Years of experience in Data warehouse development with Integration Services and Report Development.
• Extensive experience in developing complex Stored Procedures, Functions, Views, Cursors, Joins and Sub queries with T - SQL.
• Extensive experience with SQL Server and T-SQL inconstructingTables, Triggers (DDL/DML), Indexes, constraints (keys) with their integrity, user profiles, relational database models.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
• Hands on experience in migrating DTS packages to Integration Services Packages.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert.
• Proficient in developing SSIS Packages using SSIS designer in Business Intelligence Development Studio (BIDS) for integrating data from heterogeneous sources (MS Excel, Oracle, Flat Files etc.).
• Well-versed in usage of SSIS Control Flow items and SSIS Data Flow items.
• Experience in error and event handling, precedence constraints, break point and logging.
• Experience in developing Custom Reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQLServer Reporting Services (SSRS).
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Used technologies provided by the .NET framework including ASP.NET, ADO.NET, Web Services using SOAP and data manipulation using XML.
• Experience in designing the crystal reports.
• Experienced in sorting the data, defining data source and subtotals for the reports.
• Expertise in Developing and Extending SSAS Cubes, Partitioning, Data Mining Models, Deploying and Processing SSAS objects, writing MDX queries.
• Extensively Worked with multidimensional expressions (MDX) to add calculated members and other dynamically calculated values to the Analysis Services cubes (SSAS Cubes).
• Excellent skills in Data Modeling using Erwin, Star Schema, Snowflake Schemas and Dimension Tables.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS), BULK Insert and Log shipping.
• Experience in performance tuning and query optimization usingtools likeSQL Server.
• Expert in Database Normalization, designing and creating Indexes, planning and implementing Server Security and authentication, Develop Queries and T-SQL Scripts in MS SQL 2008/2005/2000 .
• Good knowledge of Software Development Life Cycle (SDLC).
• Good knowledge in understanding Agile, Scrum Process in software development.
• Experience with all the phases of Software Development Life Cycle (SDLC) and Quality procedures while executing projects.
• Shown strong analytical, administration, leadership qualities and problem-solving skills in delivering the projects within the client’s time frame by meeting their standards.
• Experience in Creating Roles and Assigning Permissions to the users.
• Excellent logical and analytical skills to solve complex problems.

TECHNICAL SKILLS

Databases: MS SQL Server 2008R 2/ 2008/2005/2000 /7.0, ORACLE, MS Access, teradata V2R6/V2R5, DB2

Database Tools: MS SQL Server 2000/2005/2008 , MS-Access, performance point server, SQL Server Integration Services, Data Transformation Services, SQL Server Analysis Services, OLAP(Online Analytical Processing, Multi-dimensional Cubes and Business Intelligence & Development Studio

Development skills: T-SQL,SSIS/SSRS/SSAS, ProClarity, BO XI, Micro Strategy

Languages: T-SQL, HTML, XML, ASP.NET, ADO.NET, Java Script, C, C++ and MDX, VB.net, VB Script

ETL Tools: DTS, SSIS(SQL Server Integration Services)

Reporting Packages: SSRS 2000/2005/2008 , Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel.

Tools: /Methodologies MS Visio,Erwin, MS Project, SQL Profiler, SQL Loader, Front page, Microsoft Share Point Server 2007, Performance Point Server.

PROFESSIONAL EXPERIENCE

Confidential, MA

Business Intelligence & Analytics Analyst

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes.
• Created SSIS packages to transfer data from Oracle to SQL server using different SSIS components and used configuration files and variables for production deployment.
• Performed Database consistency checks with DBCC,Defrag,Indextuning and monitored error logs
• Created SSIS packages in SQL SERVER 2012 and modified existing SSIS packages to parameterized
• Developed SSIS Packages to Consolidate date from various data Sources and also Data loads from various types of sources files Heterogeneous Source
• Planned, Configured, Installed, Maintained SQL Server in environment of Multi-node Cluster with Multi-instances.
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, troubleshooting process issues and errors.
• Used HiveQL to get data from hive and SSIS to load it to current RDBMS
• Performed Database Refreshtasks from production to Development and Staging Servers
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups.
• Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTPdatabases to staging area and finally transfer into data marts and performed action in XML.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.
• Made Packages Parameterized using Configuration Manager and Implemented Logging in SSIS.
• Created SQL Server Reports using SSRS 2005.
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Created Maintenance Plans and setup log files to monitor jobs.
• Designed various reports using different reporting features such as group by, drilldowns, drill through etc.
• Created Ad Hoc reports by building models in Report Builder using SQL 2005 Model Designer and Report Builder.
• Created weekly and monthly reports as per requirement using SSRS.
• Scheduled Reports to be delivered to User on demand Basis in SSRS report Manager.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Deployed and uploaded SSRS reports to SharePoint Server for the end users to look at them.

Environment: MS SQLServer /2005/2000, Windows Enterprise Server 2003/2008, SQL Server Analysis Services (SSAS), Reporting Services (SSRS 2005), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), ETL, MDX

Confidential, WV

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development and deployment.
• Responsible for writing T-SQL (DDL/DML) Queries, Stored Procedures, Views, Functions and Triggers, complex PL/SQL packages.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams that require the file.
• Used Date functions, String functions and Database functions to manipulate and format source data.
• Developed packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Built Web service using WSDL to pull data from different data sources to SSRS reports
• Developed and consumed services using WCF services models
• Have used Service Oriented Architecture (SOA) to develop web services.
• Have worked on WCF to consume web Services.
• Used Web Services to implement a common method for multiple modules.
• Used technologies provided by the .NET framework including ASP.NET, ADO.NET, Web Services using SOAP and data manipulation using XML.
• Experienced with SSIS in creating, loading, and modifying new packages or existing packages and add or configure components, making changes in object by using Control Flow Tools and Data Flow Tools and then validating them.
• Used Batch Files to Import Data from other Data Base.
• Carry out creation of SDLC documentation for existing applications.
• Created packages in SSIS with error handling and worked with different methods of logging.
• Created ETL SSIS packages both design and code to process data to target databases.
• Responsible for Import and export of data between the environments and Data Cleansing.
• Responsible for migration of databases from old SQL server versions to SQL Server 2008.
• Developed Slowly Changing Dimensions (SCD) Packages using SSIS (ETL) to perform the Incremental / Historical load logic data from Source to Staging Environment and into the Enterprise Data Ware House.
• Performed Data profilingtasks in SSIS Packages using the Data Profiler and standardizing the data appropriately for the database.
• Experience in managing Alerts, Creating Jobs, and Operators through SQL Server Agent.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the front end.
• Developed various drill down, parameterized reports using Crystal Reports and SSRS 2008.
• Created calculated measures for business calculations using complex MDX scripts.
• Implemented hierarchies on Cubes, wrote MDX for creating calculated measures.
• Responsible for creating OLAP cubes for deep through analysis using SSAS 2008.
• Worked on Side by Side migration of multiple SQL 2005 instances to SQL 2008.
• Worked on data compressions and backup compressions.

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, SQL Server Management Studio(SSMS), SQL Server Business Intelligence Studio(BIDS), SQL Server Profiler, XML, SSIS, SSAS, SSRS,ASP.NET, ADO.NET, ProClarity, Crystal Reports 10, Windows 2000/NT.

Confidential, OH

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development and deployment.
• Responsible for writing T-SQL (DDL/DML) Queries, Stored Procedures, Views, Functions and T riggers, complex PL/SQL packages.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams that require the file.
• Used Date functions, String functions and Database functions to manipulate and format source data.
• Developed packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Experienced with SSIS in creating, loading, and modifying new packages or existing packages and add or configure components, making changes in object by using Control Flow Tools and Data Flow Tools and then validating them.
• Used Batch Files to Import Data from other Data Base.
• Carry out creation of SDLC documentation for existing applications.
• Created packages in SSIS with error handling and worked with different methods of logging.
• Created ETL SSIS packages both design and code to process data to target databases.
• Responsible for Import and export of data between the environments and Data Cleansing.
• Responsible for migration of databases from old SQL server versions to SQL Server 2008.
• Developed Slowly Changing Dimensions (SCD) Packages using SSIS (ETL) to perform the Incremental / Historical load logic data from Source to Staging Environment and into the Enterprise Data Ware House.
• Performed Data profilingtasks in SSIS Packages using the Data Profiler and standardizing the data appropriately for the database.
• Experience in managing Alerts, Creating Jobs, and Operators through SQL Server Agent.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
• Developed complex Stored Procedures to generate various Drill-through reports,parameterized reports, sub-reports and linked reports using SSRS and integrated into the front end.
• Developed various drill down, parameterized reports using Crystal Reports and SSRS 2008.
• Created calculated measures for business calculations using complex MDX scripts.
• Implemented hierarchies on Cubes, wrote MDX for creating calculated measures.
• Responsible for creating OLAP cubes for deep through analysis using SSAS 2008.
• Worked on Side by Side migration of multiple SQL 2005 instances to SQL 2008.
• Worked on data compressions and backup compressions.

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, SQL Server Management Studio(SSMS), SQL Server Business Intelligence Studio(BIDS), SQL Server Profiler, XML, SSIS, SSAS, SSRS, ProClarity, Crystal Reports 10, Windows 2000/NT.

Confidential, Solon, OH

SQL Server Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Worked as a database developer on databases like MS SQL Server 2008/2005 using T-SQL, stored procedures and views to get data from Data warehouse to Data marts.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Tasketc to generate underlying data for the reports and to export cleaned data from Excel, Text file and MS Access to different data Marts.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Configured Connection Manager Files and CMD files for SSIS packages to dynamically execute on QA Server and Production server.
• Migrated SSIS 2005 packages to SSIS 2008 packages.
• Developed Master Child package using variables and Execute package task in SSIS.
• Deployed, Tested and Scheduled SSIS packages using SQL Agent.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House and for OLTP side.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created report models for ad hoc reports and deployed on report server.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Developed incremental loading using MERGE statement in SQL server 2008.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: MS SQL Server 2005 and 2000, MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services 2000, C#, ASP.NET,VB.NET, OLAP, UML, Erwin DTS/SSIS/BIDS.

Confidential, NY

SQL Server Developer

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes.
• Created SSIS packages to transfer data from Oracle to SQL server using different SSIS components and used configuration files and variables for production deployment.
• Developed SSIS Packages to Consolidate date from various data Sources and also Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs) and converted XL to sql reporting.
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, trouble shooting process issues and errors.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups.
• Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Made Packages Parameterized using Configuration Manager and Implemented Logging in SSIS.
• Created SQL Server Reports using SSRS 2005.
• Designed various reports using different reporting features such as group by, drilldowns, drill through etc.
• Created Ad Hoc reports by building models in Report Builder using SQL 2005 Model Designer and Report Builder.
• Created weekly and monthly reports as per requirement using SSRS.
• Scheduled Reports to be delivered to User on demand Basis in SSRS report Manager.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Deployed and uploaded SSRS reports to SharePoint Server for the end users to look at them.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Helped the users to test the reports created and optimized the performance of the end reports getting data from SQL server Databases and SQL server analysis services.

Environment: MS SQLServer 2008/2005/2000 , SQL Server Analysis Services (SSAS), Reporting Services (SSRS 2005), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), ETL,MDX, Microsoft Office SharePoint Server (MOSS) 2007, Performance Point Server 2007, Microsoft.NET (Asp .NET, C# .Net), Visual Source Safe, Toad, Oracle 10g.

Confidential

SQL Server Developer

Responsibilities:

• Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes.
• Created SSIS packages to transfer data from Oracle to SQL server using different SSIS components and used configuration files and variables for production deployment.
• Developed SSIS Packages to Consolidate date from various data Sources and also Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs) and converted XL to sql reporting.
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, trouble shooting process issues and errors.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups. Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Wrote complex queries, triggers and stored procedures, views and user defined functions.
• Design and implement database logical and Physical Schemas.
• Responsible for database tuning using normalization and application tuning.
• Maintenance of Development, System test, Assemble test and Integration Servers and databases.
• Query tuning, Index Tuning and performance tuning.
• Creation and maintenance of databases, objects.
• Users and user group creation and maintenance.
• Extensively used Enterprise Manager, Query Analyzer, and SQLServer Profiler.
• Created custom and standard reports using Crystal Reports.
• Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals, and alerting.
• Created and modified stored procedures to Create Reports.

Environment: Windows 2000 Server, MS-SQLServer 2000/7.0, Visual Basic6.0, ASP, VB Script, Java Script, IIS, Server Analysis Services (SSAS), Reporting Services (SSRS 2005), Business Intelligence Development Studio (BIDS), Visual Source Safe and Internet Information, Server 4.0, Crystal Reports, Microsoft Access FTP Communication.