SUMMARY

• Over 6 years of IT Professional experience in Development, Client Analysis, Database Design and Presentation using SQL Server 2000/ 2005/2008/2008 R2/ 2012.
• Strong knowledge of Data Warehouse methodologies, including Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact and Dimension, Tables, worked with high volume databases with partitioned data.
• Strong technical knowledge inMS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Experience in using Business Intelligence tools(SSIS,SSAS,SSRS) in MS SQL Server
• Extensive experience with T - SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, Indexes, User Defined functions, User Profiles, Data Dictionaries and Data Integrity.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008R 2/2008/2005.
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Expert at Creation and maintenance of Databases, creating Roles and managing user permissions, security and resolving deadlocks.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs, Drill Down, Drill Through, Cascading, Parameterize reports using SSRS in Business intelligence development studio (BIDS).
• Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
• In depth experience in Business Intelligence Technologies and Database with Extensive Knowledge in ETL Process and Reporting Services using SQL server 2008/2005, SSIS and SSRS
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server
• Experience in Performance Tuning and Query Optimization.
• Experienced in using ETL tools in (SSIS) MS SQL 2008,MS SQL 2005 and DTS in MS SQL 2000
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Data Loading Experience in SQL Server using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Experience with logical and physical data modeling and database design usingErwin.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitorfor monitoring and tuning MS SQL Server performance.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS

• SQL Server 2000/2005/2008/2008- R2/2012
• SQL Server Management Studio (SSMS)
• SQL Server Business Intelligence Development Studio(BIDS)
• SQL Server Analysis Services (SSAS)
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• Oracle 8i/9i/10g/11g
• MySQL
• C#
• Java
• J2EE
• T-SQL
• HTML
• DHTML
• ASP.NET
• VB.NET
• XML
• MS Visual Studio
• DTS
• SQL Profiler
• ERWIN
• MS Visio .

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Involved in planning, design, analysis, implementation and maintenance of SQL server database.
• Analyze technical and functional design documentations to develop SSIS packages and SQL
• Server Stored Procedures, to transform and load extract legacy data based on business rules and Field level mapping.
• Involved in designing ER diagrams and mapped the data into database objects.
• Executed data conversion ETL packages and generated the appropriate execution reports.
• Developed stored procedures, views, and other objects required to transform, translate, retain aggregate data for complex data conversion requirement
• Involved in transferring data from various data sources such as MS Excel, XML, Flat files, and CSV files into SQL server 2012.
• Defined different types of relationships between dimensions and measure groups and specified the properties of these relationships, such as referenced relationship, fact relationship and many-to-many relationship.
• Designed many (SSIS) SQL server integration packages for migrating data using various complex transformations such as derived column, lookup, and merge join.
• Scheduled the system and user database backups and restored them whenever necessary.
• Monitored SQL Server and tuned poor performing SQL scripts.
• In the SSIS packages used various control flow tasks such as for each loop, sequential container and bulk insert and execute SQL tasks.
• Extracted data from XML files and used various transformation techniques to cleanse the Data as per business requirement.
• Designed and maintained various types of reports using SSRS SQL server reporting services.
• Designed and implemented parameterized, drilldown and cascading reports using SSRS
• Involved in deploying reports to report manager and trouble shooting for any errors occurred in Deploying.
• Designed partitions in Cubes on time for improvement in performance using SSAS.
• Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements.

Environment: Microsoft SQL Server 2008R2, MS Windows Server, SQL Server Analysis Service (SSAS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), Visual Studio, T-SQL, XML, IIS, ERWIN.

Confidential, Albany,NY

SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Created logical and physical data models for new requirements after discussion with technical team and application users as per agile methodology.
• Wrote T-SQL, designed and modified database objects such as tables, views, triggers, indexes, Stored Procedures, defaults, function to meet the business and audit specifications.
• Created SSIS packages to extract data from OLTP to OLAP data warehouse databases, and Scheduled Jobs to call the packages.
• Highly skilled in configuring and creating SSIS solutions for ETL and Data Migration services, and in managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Extracted data from various data source including OLE DB, Excel, flat files and XML using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge.
• Designed and implemented facts, dimensions and OLAP cubes using dimensional data modeling in SQL Server 2008 that maintained data.
• Defined measure groups and further tuned dimensions attributes for a cube, created and deployed cubes to an instance of analysis services on the development server.
• Modified dimensions in the cube, created hierarchy and relationships among attributes, wrote SQL expressions to define named calculation.
• Defined different types of relationships between dimensions and measure groups and specified the properties of these relationships, such as referenced relationship, fact relationship and many-to-many relationship.
• Wrote MDX queries to define calculations including calculated members, named sets. Created Key Performance Indicators (KPIs) to evaluate the business.
• Created perspectives to reduce the apparent complexity.
• Created report based on those developed cubes and Designed and maintained view and stored procedure to retrieve data from data warehouse to create corresponding data set for the Reporting Services (SSRS).
• Experience in generating reports like tabular, chart, matrix, parameterized and drill through reports using SSRS and deployed the same through report manager.
• Built advanced reports using query parameters, report parameters, user access restrictions, filters and interactive sorts.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Environment: MS SQL Server 2005/2008/2008 R2, SSRS, SSAS, SSIS, SQL Server Management Studio (SSMS), Windows Server 2008, DTS, T-SQL, .Net, Report Builder, Crystal Reports, XML, HTML, SharePoint, excel, SQL Server Agent, SQL Profiler, Database Engine Tuning Advisor, Query Analyzer.

Confidential, San Antonio, TX

SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Designed and developed ER diagrams (Physical and Logical using MS Visio) and mapping the data into database objects.
• Scheduled the reports to run on a daily and weekly basis in Report Manager and then provided them to the analysts to review in Excel Spread Sheet
• Expertise in developing advanced reports with functions, formulae, parameterized reports, sub reports, summary reports, cross tabs, ranking and conditional formatting.
• Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Involved in creating various scripts to load the data to and from production servers to the development servers.
• Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services, SQL Profiler, Query Analyzer, MS Office

Confidential

SQL Server SSRS/SSIS Developer

Responsibilities:

• Participated with business analysts in order to gather requirements for design and implementation of database. Performed basic DBA activities like Backup and Restore.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).
• Responsible for designing, creating and deploying the reports into the production server.
• Created parameterized reports and ad-hoc reports using Report builder.
• Worked on existing OLTP system and created facts, dimensions, data models, star schema representation for the data mart of OLTP and OLAP databases.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Responsible for migration of packages from SQL Server 2005 to SQL Server 2008 using SSIS.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Created complexstore procedure to copy Database Objects from remote server to local machine and vice versa.

Environment: MS SQL Server 2000/2005/2008 Enterprise Edition, Windows 2003 Enterprise Edition, Windows Server, SQL Server Reporting Services (SSRS),SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Oracle 9i, Red Gate, DB2, MS Performance Point Server, Visio 2003.

Confidential

SQL Server Developer

Responsibilities:

• Involved in gathering requirements from the clients.
• Configured SQL Server's Optimal Settings (Locking & Memory) according to the usage of its tables, # of users and hardware.
• Created DTS packages for the data cleansing/transfer and transformation.
• Created and scheduled Jobs using SQL Server Agent. And created alerts for Error reporting.
• Worked with SQL Server in moving the data to Corporate Repository by DTS packages.
• Created stored procedures, triggers, indexes, rules, integrity constraints, cursors, views and ad hoc queries for the business logic.
• Captured the parameter settings that are active when the transactional timings are gathered.
• Wrote Triggers to insert, update and captured the data
• Monitoring the database applications

Environment: MS SQL Server 2000/2005, DTS, MS Access, Microsoft Visio, Crystal Reports, SQL Profiler, Database Engine Tuning Advisor.