SUMMARY

• Over 7+ years of Experience in IT domain focused on Microsoft SQL Server 2000/ 2005/20, SSIS/SSRS/SSAS, OLTP and OLAP.
• Hands on experience in installing, configuring, managing, monitoring SQL Server 2014/2012/2008/2005/2000
• In - depth noledge ofT-SQL(DDL, DML, DSL, andSQLCMD),MDXandXQUERY (XML).
• Extensive experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS)
• Involved in Database Design, Data Modeling (Relational and Dimensional) using Erwin and Microsoft Visio for logical and physical data models
• Strong SQL development skills including writing Stored Procedures, Triggers, Views, Constraints, Indexes, Views, Cursors, Triggers, CTE, Temp Tables, Transaction, Error handling and User Defined Functions.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Handled ETL process development, implementation and support for Terabyte+ data warehouse environments
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services ( SSIS ), DTS, Bulk Insert utilities
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Worked to establish connectivity between ASP.Net applications by using ODBC.
• Experience in using Audit functions and extensively used Exception Handling for catching and reporting errors
• Extensive experience in creating enterprise reports using SSRS 2005/20 using Report Manager, Report Builder, and BIDS
• Created many Drill Through, Drill Down, Parameterized reports using SSRS.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs
• Excellent noledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models for developing SSAS Cubes using MDX
• Experience in designing, building and deploying Cubes with Star Schema and Snowflake Schema using SQL Server Analysis Services (SSAS 2005/2008/2012 ).
• Experience in Cube Optimization Techniques such as Cube Partitioning, Aggregation Wizard, Defining Hierarchies.
• Expert in calculating measures and dimension members using MDX, mathematical formulas, and user-defined functions
• Have hands on experience in Performance Tuning and Query Optimization. Worked on identifying and resolving blocking and deadlocks
• Experience in migrating MS SQL Server 2000 and from 2000 to MS SQL server 2005 and from to .Worked with different types of Replication Models like Transaction, Snapshot, and Merge.
• Experience in Black Box, White Box and Gray Box Testing Techniques. Proficient in Functional & non-Functional Testing which includes Unit, Functionality, Negative, Regression, Integration, System testing experience working with environment using agile development.
• Strong debugging skills and the ability to solve complex problems.
• Good team player with strong analytical skills.
• Hands on experience in installing, configuring, managing, monitoring SQL Server 2014/2012/2008/2005/2000

TECHNICAL SKILLS

Languages: SQL, Transact SQL, PL/SQL, Embedded SQL, C, Java, J2EE, VBScript, .Net, JavaScript, ASP, Visual Basic 6.0/5.0/4.0, HTML 4.0, DHTML,XML

Databases: SQL Server 2014/2012/2008 R 2/2005/2000/7.0, Oracle 9i/8.x, DB2 MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9,BO

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Other Software: MS Office- 2013/2010/2007/2003/2000, Adobe Professional, C#, .Net.

Operating Systems: Windows / 98/2000/2003/ XP/Vista/7/8, Unix

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server Query Editor, Solution Explorer, Analysis Manager, Reporting Server

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, New York

SQL/BI Developer/ Data Analyst

Responsibilities:

• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2005/2008.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• CreatedSSISpackages for File Transfer from one location to the other using FTP task Involved in Database design & Data modeling various databases.
• Extensively used SSIS transformations such as Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Worked with clients to understand the requirements and meet their requirements.
• Analyze different business requirements and provide time estimate for Analysis, Design, Coding, and Implementation.
• Worked on rebuilding ETL system in Informatica environment. Created technical documentation for migration
• Analyze different business requirements and provide time estimate for Analysis, Design, Coding, and Implementation Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Documentation of all the processes involved in maintaining the database for future reference.
• Scheduled SSIS packages as jobs either daily, monthly, yearly or ad-hoc.
• Responsible for maintaining and supporting production databases.
• Worked with BAs, DBAs and other Developers to understand the existing system.
• Make analysis and development plan accordingly
• Actively participated in User Acceptance Testing, and debugging of the system.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Worked with offshore team ensure deliverables in timely manner. Schedule meeting to resolve client issues.
• Worked on multiple projects and multiple deadlines at the same time.

Environment: MS SQL Server 2014 R2, SQL Server Integration Services, SQL Server Reporting Services, Oracle 9 i/ 10 g/11g; DB2, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2013, Windows XP, C#, ASP.NET, BizTalk Server, JavaScript, XML, Erwin v4.1, MS Office 2013

Confidential, SOMERSET, NJ

SQL/BI Developer

Responsibilities:

• Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front end application.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Configure the SSIS Package for run time Parameters and Configuration file.
• Created store procedures to calculate net return and Gross return of the Funds.
• Performed T-SQL tuning and optimizing queries for Reports, which take longer, time in execution SQL Server 2005.
• Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation.
• Develop the Slowly Changing Transformation to maintain the Historical Data.
• Creating Stored Procedures for SSIS and for Reporting in SSRS.
• Created Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports.
• Maintained scheduling of subscription reports with the subscription report wizard.
• Handling the errors during data moving and Sequencing the task as per requirements. configured monitoring tools like SSM/MOM
• De-normalizing database using Stored Procedures for a single row feed to legacy system.
• Creating dynamic SQL in Stored Procedures to support the dynamic nature of the front-end application.

Environment: SQL Server 2012/2014, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Query Analyzer, MS-Excel, MS Access 2010, SQL profiler, SQL Server Agent.

Confidential, Denver, CO

SQL Developer

Responsibilities:

• Actively interacted with end user to gather business requirement, system specification and enhancement.
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T-SQL
• Involved in writing Transact SQL utilities to generate table insert and update statements.
• Taking care of Database Performance issues by tuning SQL queries and stored procedures by using SQL Profiler, Execution plan in Management studio.
• Maintained the database consistency with DBCC CHECKDB and the DBCC CHECKCATALOG at regular intervals to validate the environment Involved in trouble shooting and fine-tuning of databases.
• Migrated SQL server 2008 databases into SQL server 2012 databases.
• Helped in creating the clustered/non-clustered indexes on right columns of the tables; trace out for any tables dat require for any indexes and determine the type of index on it.
• Constructed SSIS packages to load data from database on different servers.
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures.
• Created checkpoints for packages and used variables for connection purposes.
• Developing and maintaining SSRS reports as per the user requirements.
• Writing complex queries, generating ad-hoc reports as per the user requests.
• Converted data with the Data Conversion transformation and then sorted data to remove duplicates.
• Analyzed the test system to ensure dat it matched the production system.
• Worked in on site/ off site environment; worked closely with a team away from my location.
• Responsible for Creating users, granting /revoking roles and permissions to the users.
• On call 24*7 production support during beyond regular hours/ weekends/ Holidays.
• Restored the database on production server or development servers as per requirements.

Environment: MS SQL Server 2012/2008 R2/2005/2000, Oracle 9i/ 10g, T-SQL, SSIS/SSRS 2005, MS SQL Profiler, Oracle, PL/SQL, SQL Query Analyzer, Visual Studio 2010/2012, Erwin v4.1, MS Office 2010,MS Access.

Confidential, Park Avenue, New York

SQL Server BI Developer

Responsibilities:

• Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
• Fine-tuned Stored Procedures to improve performance dat was achieved by removing unnecessary Cursors and Temporary Tables.
• Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
• Responsible for Design and Normalization of the database tables.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
• Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS).
• Gatheird requirements for the creation of Data Flow processes for the SSIS packages.
• Used various Control Flow Tasks in the development of various complicated packages.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
• Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports and Ad-hoc Reports.
• Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.
• Generated and formatted Reports using Global Variables and Expressions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for Parameterized Reports in SSRS 2005/2008.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.

Environment: SQL Server 2008/2012, T-SQL, Windows Server, Microsoft Visio, Performance Monitor, SQL Server Profiler, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).