SUMMARY:

• Over 6 years of experience in database development and IT Solutions that include experience in design, development and implementation of complex data delivery systems using MS SQL Server technology
• Experience in MS SQL Server RC0/2012with OLTP and Business Intelligence delivery using SQL Server Integration Services and SQL Server Reporting Services.
• Hands - on experience with Erwin Data Model Tool and strong knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts and also star/snowflake Schemas implementation.
• Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
• Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
• Hands on experience in using MDX in creating and customization of cubes using SSAS.
• Experience in working with SSAS in creating cubes, Data source view, dimensions and deploying.
• Strong experience with ETL tool in Mapping, Transformations, Expressions, lookups and Aggregations.
• Excellent in High Level Design of ETL DTS Packages& 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.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Skillful in Creating, Managing, Delivering SQL Server Reports using SSRS 2005/2008.
• Experience in Migration of SSRS reports from SQL 2005 to SQL 2008.
• Adept in designing Stylish Report layout and having Proficiency with drill down reports in SSRS 2008/2005.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008.
• Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
• Experience in writing sub reports and parameterized Queries for generating reports in SSRS 2008/ 2012 RC0/2012.
• Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQL Server Management Studio, SQL Server Integration/Analysis/ Reporting Services etc.
• As a key player in the team with strong interpersonal and communication skills, explored and contributed the technical expertise as and when needed by the team.

TECHNICAL SKILLS:

Languages: T-SQL, SQL, PL/SQL, XML, MDX.

RDBMS: SQL Server 2012/ 2012 rc 0/2008/2005/2000, Oracle: 10g/9i/8i, Sybase Server, IBM DB2 UDB 8.2/8.0, MS Visual Source Safe 2005, and MS Access 2003

Database Design Tools and Data Modeling: MS Visio, ERWIN, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization

DWH / BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio. Master Data services (MDS)

Tools: and Utilities: SQL Server Management Studio, SQL Server Profiler, Import & Export Wizard, Visual Studio, Visual Source Safe, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x and Windows 7/8/10

PROFESSIONAL EXPERIENCE:

Confidential, Winston-Salem, NC

SQL Server Developer (SSIS|SSRS)

Responsibilities:

• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
• Migrated DTS packages using DTS editor wizard in SSIS, validated and tested all packages on development server
• Maintained SSIS packages additional to other SSIS packages that are already there.
• Prepared alerts for successful or unsuccessful completion of Scheduled Jobs.
• Created SSIS packages with which data sources such as Flat files,Teradata,DB2, Excel files, and PDF files Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service
• Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drilldowns, drill through etc.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created different Parameterized Reports like standard parameter reports, cascading parameter reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Created Automate reports, Ad-hoc reports and etc. based on the requirement.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• In our project team followed Agile software methodology

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MDM(Master Data Management)Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Crystal Reports, Business Objects.

Confidential, Oakbrook, IL

SQL Server MDM Developer|SSIS|SSRS

Responsibilities:

• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server. Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Developed ETL Packages using different DB partioning strategies.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS. Developed, monitored and deployed SSIS packages. Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS) 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, navigation reports etc.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks) Created reports based on database usage and perform capacity planning. Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard. Performed DTS for data transfer from Oracle, Terawatt, FTP, MS Excel and text file to SQL Server 2012 RC0.
• Created DTS packages to transfer objects from development server to production. Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Worked on large data warehouse servers and developed the different reports for the analysis from those servers.
• Extensively involved in the Data Sources storage from different type of sources, Data Model design by the Visio, developed ETL packages in SSIS, Data inserted in to MDM through MDS (Master Data Services), and developing reports using Reporting services.

Environment: MS SQL Server 2012 rc0, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MDM(Master Data Management)Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential, Englewood, CO

SQL Server Developer|SSIS|SSRS

Responsibilities:

• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server. Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Developed SSIS packages and monitored Scheduled Jobs of SSIS packages.
• 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, navigation reports etc.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks) Created reports based on database usage and perform capacity planning. Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard. Performed DTS for data transfer from Oracle, Terawatt, FTP, MS Excel and text file to SQL Server 2000.
• Created DTS packages to transfer objects from development server to production. Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential, San Francisco, CA

SQL Server |SSIS|SSRS|SSAS

Responsibilities:

• Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data about the table layout, so as to meet the company specifications.
• Data Transformation Activities using DTS Import/ Export for transferring data between different databases like oracle. Design new DTS packages as per needs, Resolve the problems.
• Defined meta data standards for the Data Warehouse
• Partioning data in OLAP
• Define Hierarchy Relationships between Attributes in OLAP
• Knowledge on several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS)
• Cube designing using SSAS and creating ad-hoc reports.
• Written stored procedures for automatic scripting to backup transaction logs, log file, maintain archive of objects and so on.
• Created Stored Procedures, Views, and Functions in T- SQL for data retrieval
• Ensured constraints and writing triggers to apply business rules. Designing, creating, maintaining, optimizing SQL databases, backing up and restoring user databases.
• Generated various Reports using SSRS (SQL Server Reporting Services).
• Extensively used Business Intelligence Development Studio and Visual Studio(VS 2005)
• Created database triggers for data security.
• Created Indexes to speed up the queries

Environment: SQL Server 2005/2000, Visual Studio, SSAS, SSIS, SSRS, MDX.

Confidential, Rochester, NY

SQL Server Developer|SSIS|SSRS

Responsibilities:

• Primary role was developing to reports using SSRS requirements.
• Design and Implementation of Data Mart for reporting purposes.
• Developed several Tables, Stored Procedures, functions and views to load data from the OLTP database.
• Created DTS/SSIS packages for Uploading of Various different format of files (Excel, Access, dbf) and databases to MS SQL using Data Transformation Services (DTS) and Integration Services (SSIS).
• Created packages for new data feed process from third party client for new Shopping Mall feature in the application.
• Working with Business Analyst and Business end users to understand the report requirements.
• Performance Tuning on queries to improve the query time for faster reports.
• Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting).
• Developed Stored Procedures and Views to be used to supply the Data to the Reports. Complex formulas were used to show derived fields and to format the data based on specific conditions.
• Responsible for installing Business Objects Enterprise on production systems and setting up external and internal user’s access and security settings to published reports.
• Maintenance and provide support to the users for the deployed reports

Environment: SQL SERVER 2005, SSIS, SSRS, SSAS, Business Objects, MS Access, Windows XP

Confidential

SQL Developer.

Responsibilities:

• Installed SQL Server Management tools using SQLServer Setup Program & Tested the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQLServer which covers Database Integrity Checks, Updated Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Configured Different RAID Levels (Redundant Array of Independent Disks).
• Designed DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database.
• Data migration (import & export - BCP) from Text to SQL Server.
• Clustered Server and Load Balancing to maintain the Redundancy of Servers.
• Configured IIS Server for the XML programming which was a new level of SQL 2000.
• Configured Exchange Server for sending automatic mails to the respective people when a job failed or succeed.
• Configured Commerce Server for capturing the Web Log details of the User.
• Moved the entire phase from the Staging to the Production.
• Created Triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Designed Different kinds of Transactions for the application.
• Maintained SQL Script for creation of Database Objects.
• Documented business rules, functional and technical designers, test cases and user guides.
• Conducting for users.

Environment: Microsoft SQL Server 2000/7.0, Microsoft Windows 2000 Server, Microsoft Visual Basic, Micro Soft Access 97/2000, Windows Forms, Micro Soft Office, Crystal Report.