Professional Summary:

Over 7 Years of extensive IT experience in design, development and analysis of Microsoft SQL Server 2000 /2005/2008/2008R2/2012 and Successfully worked as a SQL Server Business Intelligence tools BIDS developer with SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS implementing technical sills along with interpersonal skills as per business needs.

Hands on experience in installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2008/2005/2000.

Hands on experience in all phases of SDLC Software Development Life Cycle involving Requirement analysis, Software design, development, implementation, testing and maintenance.

Experienced in extracting, transforming and loading the data using SSIS in SQL Server 2005/2008/R2and Data Transformation Services in SQL Server 2000.

Expert in data migration from OLEDB/EXCEL/FLAT file to SQL Server 2000/2005/2008/R2 and other destinations using SSIS.

Extensive experience with different phases of project project initiation, project requirement and specification gathering, designing system, coding, testing, and debugging new and existing client-server based applications .

Expertise in Relational and Dimensional Data Modeling, RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Warehouses. Experience in design and implementation of On-Line Transaction Processing OLTP and On-Line Analytical Processing OLAP .

Expert in using Complex Stored Procedures, User Defined Functions UDFs , Triggers, Common Table Expressions CTEs , Table Variables, Views, Indexes and T-SQL queries DDL and DML .

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key Foreign Key Constraints.

Experienced in SSIS SQL Server Integration Services SSRS SQL Server Reporting Services and SSAS SQL Server Analysis Services .

Experienced in implementing ETL Extract Transform and Load Packages using Data Transformation Services DTS and SSIS SQL Server Integration Services 2005/ 2008/2008R2.

Strong experience in developing SSRS Reports, Developed Standard Reports, Sub Reports, Cross Tab Reports, Drill down Reports, Drill through Reports, Used various Charts and graphs like Bar Chart, Line graphs, Pie Charts.

Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services, Experience in XML scripts, Dimensional Modeling, working with XML Documents.

• Extensively involved in T-SQL performance tuning to enhance the performance of the complex queries for Reports, Packages and other business logic.

Skilled in Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.

Experience in creating complex SSAS cubes with multiple fact measures groups, KPIs, dimension usage, calculated members, perspectives and hierarchies based on the OLAP reporting needs.

Good knowledge in query optimization performance tuning, using SQL Server Profiler, Execution Plan and Performance Monitors. Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.

Possess excellent management skills of outstanding decision making with excellent verbal and written communication skills, supervised in preparing and assisting formal walkthroughs and presentations of system designs for business analysts, stakeholders and clients.

Technical Skills:

Databases : SQL Server 2000/2005/2008, MS Access 2000, MS Excel,

Oracle 9i/10g, Mainframes, DB2

Programming Languages : T-SQL, PL/SQL, C, C , HTML, XML, JavaScript, C , ASP.Net

Operating Systems : Windows 98/2000/2003/XP/NT/Vista/2008, Windows 2000

Advanced Server, Windows 2003 Enterprise Server, UNIX.

IDE BI Tools : SQL Server BI Development Studio BIDS , SharePoint, MS

Visual Studio 2012/2008/2005, Power Pivot.

Version Control : Team Foundation Server TFS , Visual SourceSafe VSS ,

Subversion.

ETL Tools : SSIS, Data Stage, DTS

Data modeling Tools : Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose

Design Methodology : Unified Modeling Language 1.1 using Rational Rose.

Packages : Microsoft Office 2007/2003/2000

Professional Experience:

Confidential

Programmer Analyst- SQL Server

Responsibilities:

• Develops relationships with the business to better understand business requirements.
• Participates in developing application scope and objectives and preparing functional and/or technical specifications.
• Generated multiple Enterprise reports SSRS/Crystal/Impromptu from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports and AD Hoc Reports using SQL Server 2005/2008 R2 Reports Services SSRS .
• 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 to minimize the report execution time and to limit the no of records required and designed complex SSRS reports, Excel templates and integrated automation methods as appropriate.
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement. Delivering reports to Microsoft Share point, Strong Experience using Report Manger and report viewer and also worked on creating Report SSRS Subscriptions in order to Schedule the report and provide to Business.
• Proficient in usage of SSIS Control Flow items For Loop, Execute package/SQL tasks, Script task, and send mail task and migrated data using SSIS, DTS wizard Data Transformation Services tool through Data Flow items Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot . Wrote SQL scripts using Script task to insert/update and delete data in SQL database, in creating configuration packages using C Scripting.
• Designed developed the various SSIS packages for the daily, Hourly, Weekly Monthly Loads. Worked on the Tidal Scheduler Cisco Tidal Enterprise Scheduler TES in implementing and running the SSIS jobs smoothly.
• Ensures unit test is completed and meets the test plan requirements, system testing is completed and system is implemented according to plan and Communicate status of assignments with team leaders.

Environment: MS SQL Server 2008R2/2012, Microsoft Access, SQL Server Integration Services SSIS , C , Business Intelligence Development Studio BIDS , SQL Server Analysis Services SSAS , SQL Server Reporting Services SSRS , T-SQL, PL/SQL, MDX/DMX, MS Visio, Microsoft Access, Microsoft Project, Microsoft Outlook, Windows 2003/XP, XML, IIS.

Confidential

SQL Server/ ETL Developer.

Responsibilities:

• Created the dimensional relational models for various databases for monitoring tools, created database, SSIS standards of development, configuration deployment of the Packages.
• 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.
• Deployed SSIS packages by creating configuration files making packages dynamic by creating variables.
• Great Expertise in Creating and managing event handlers, Package Configurations, Logging, Checkpoints, Package Securities and User Defined Variables for SSIS Packages.
• Experienced in extracting, transforming and loading the data using SSIS in SQL Server 2012/2008/R2 and Data Transformation Services.
• Worked in creating Table Partitioning on a Database by creating Files, File Groups, Partition Functions and Schemes.
• 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.
• 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.
• Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Created SSIS Packages to migrate slowly changing dimensions.
• Deployed the SSIS package on various servers using package configuration from test server to production servers.
• Performed Bulk data migration using DTS and SSIS from flat files.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Worked on error handling using try and catch blocks and performance tuning using counters in SSIS.
• Created SSAS Tabular Cubes using DAX query language. Hands on deploying partitioning using Tabular Modeling using Analysis Services.

Environment: MS SQL Server 2005/2008R2/2012, DB2, Teradata, Microsoft Access, SQL Server Integration Services SSIS , C , Business Intelligence Development Studio BIDS , SQL Server Analysis Services SSAS , SQL Server Reporting Services SSRS , T-SQL, PL/SQL, MDX/DMX, MS Visio, Microsoft Access, Microsoft Project, Microsoft Outlook, Windows 2003/XP, XML, IIS.

Confidential

SQL Server/ ETL Developer

Responsibilities:

• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2008 RDBMS using different Data Definition and Data Manipulation languages DML/DDL implementing constraints and triggers for data integrity in development database for Warehouse system.
• Wrote complex T-SQL batches with Common Table Expressions CTE's for recursive operations.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance using SQL Server Profiler, Execution Plan and Performance Monitors.
• Experience in Report Builder in SSRS 2005 and 2008.
• Created Crystal reports in visual studio 8.0
• Involved in Object Oriented Design UML, activity diagrams, Use cases and Object Modeling .
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Designed models using Framework Manager and deployed packages to the Report Net Servers. Created pages in the reports to display depend on Prompt values.
• Handful of Experience in MS Access 2003.
• Experience in Performance Point Server 2007 and ProClarity.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.

Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.

Environment: Windows 2003 Server, MS SQL Server 2005/2008 R2, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Service Broker, MS Excel 2010, Crystal Reports, Business Objects.

Confidential

SQL Server BI Developer

Responsibilities:

• Involved in Installation and Configuration of MS SQL Server 2008R2.
• Created Views to maintain security of customer data.
• Created Indexes to get the high level performance.
• Set SQL Server configurations for SSIS packages and configured logging including windows event log and XML logging.
• Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleaned and validated data from XML file into database using XML source.
• Deployed the packages on staging and production.
• Reduced the repetition of the particular group in the Excel sheet using the Vertical Sub-Pages and Horizontal Sub-Pages Layout features using Data Defractor Tool.
• Used Data Defractor tool to normalize semi-structured Spreadsheets, fed it into the SSIS pipeline in the form of normalized output of factual data and contextual metadata.
• Created and Scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, complex joins, column conversions, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Created ETL packages using Heterogeneous data sources SQL Server, ORACLE, Flat Files, Excel source files, XML files etc. and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events On Warning, On Pre and Post Execution, On Task Failed etc.
• Performed Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created Stepped and Block reports using SSRS.
• Created Ad-hoc reports and cascading reports for historical data using SSRS.
• Created Partition table for very large database for good performance.
• Created partition function, schema and file groups for fact tables.
• Involved in the post deployment maintenance of canned reports and cubes.
• Involved in the design, development and maintenance of different cubes using SSAS

Environment: MS SQL Server 2008/2005, TFS, Query Analyzer, Windows 2003, SSAS, Excel, Oracle10g.

Confidential

Responsibilities:

• Used SSIS to unite data from existing system and performed transformations on MS SQL 2005.
• Used various transformation components in the data flow task to implement business logic.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Deployed SSIS packages and Reports to Production Servers and Migrated data using ETL Tool in SSIS.
• Used SSIS for data population from different sources and create packages for data conversions and load data into flat flies or excel files.
• Conversion of DTS packages SQL Server 2000 into SSIS packages SQL Server 2005.
• Created ETL package for data conversion using various transformations tasks.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Created logins, roles, and groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Worked on administration tasks such as data loading, batch jobs, configuring, data uploading, backup recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups transaction logs.
• Experience in Data Analysis, Normalization, Data warehousing, Data Cleansing, Data Modeling, Data Mapping, Erwin 3.0 in OLTP OLAP environments
• Experience in building star schema and snowflake schema depending on the business data requirement. Rebuilding Indexes and Tables as part of performance tuning exercise.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Performance tuning in cube by creating storage modes MOLAP, ROLAP and HOLAP , aggregations, and usage based optimization, besides providing security by providing perspectives.
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached and Adhoc reports using SSRS.
• Created complex variables, multiple breaks, sorts in the reports.
• Created Tabular and Matrix reports using SSRS.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS 2005, SSRS 2005,.NET Framework, C , ASP.NET, ADO.NET, Erwin, XML, T-SQL, SQL Server 2000, SQL Server 2005, VisualStudio.NET IDE, Windows 2000/2003 Advance Server, ASP, XML, T-SQL, MS Excel, MS Access, Visual Studio 05.

Confidential

Responsibilities:

• Setting up new MS SQL Server instances and databases.
• Going through the clients' requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Capacity planning of MS SQL Servers. Implemented and maintained database security.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Troubleshoot and minimize production down issues.
• Have written several stored procedures and Triggers as per the client requirements.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Designed new job process, new database maintenance plans and DTS packages.
• Created scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2000, Transact-SQL, Enterprise Manager, Query Analyzer, Oracle 8i, DTS Designer, SQL Profiler, Index Tuning Wizard and MS-ACCESS 2000.

Confidential

Database Developer, Application Developer

Responsibility:

• Written various stored procedures for the purpose of application development.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Administrator tasks like managing users, roles, and profiles.
• Performed database backups operating system, flat file backups export/import .
• Used snapshot replication for creating multiple instances of a database for distributing the workload.
• Designed the forms created reports using form builder report builder in Developer 2000.
• Developed standards and guidelines to maintain develop and administer the SQL Server database and handled corrupt databases and diagnosed and repaired them.
• Maintained the physical Databases by monitoring Performance, space utilization and physical integrity.
• Worked as the DBA to prepare a disaster recovery plan for their database in a scenario wherein the master database file is lost / corrupted.

Environment:

SQL Server 7.0/2000, Windows NT/2000, IIS Server, Query Analyzer, MS Exchange Server, .NET, Report builder, Access Reports-SQL, UML, DTS