SUMMARY

• Around 6.4 years of professional experience in system analysis, design, development and testing in various projects executed in Client/Server and Data warehouse environments using Microsoft SQLServer 2008 R2/2005/2000
• Experienced in SQL Server Business intelligence tools like Integration Services (SSIS 2005/2008), Reporting Services (SSRS2005/2008) and T - SQL as a back end developer in financial, health care, insurance, retail and Energy Domains.
• Strong knowledge in database design features including ER Diagrams, normalization, tables, views, indexes, constraints, keys, data dictionaries, and data integrity.
• Extensive experience in developing complex Stored Procedures, Functions, Triggers, Views, Joins and Sub queries with T-SQL.
• Experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.
• Experience in design and development of mappings, workflows, schedules in Informatica Power Center Suite.
• Excellent work experience with Integration Services (SSIS 2008/2005), Reporting Services (SSRS 2008/2005) and Analysis Services (SSAS).
• Hands on experience in migrating DTS packages to Integration Services Packages (SSIS).
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Expertise in Troubleshooting, Installation, Configuration and Deployment of Reporting Services using SSRS (2005/2008).
• Experience in developing Custom Reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services.
• Experience in gathering information from the system, analyzes program and time requirements, and prepares documentation to change existing programs
• Expert in designing stylish report layout and developing stored procedures for generating SSRS reports.
• Excellent knowledge in performance tuning and query optimization using SQL Profiler, Execution Plans, DMVs, DMF’s & Performance Monitor.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Excellent Communication Skills and Analytical skills.

TECHNICAL SKILLS

Operating Systems: Windows Vista/ XP/ 2003/ 2000/ NT 4.0/ 9x, MS-DOS

Databases: SQL Server 2008/2005/2000/7.0 , MS Access, ORACLE (11g/10g/9i).

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services, (SSIS), SQL Server Analytical Services (SSAS), Informatica Power Center 8x/9x

Reporting Tools: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Visual Studio Net, Microsoft Management Console, DTS, SSIS, Business Intelligence Development Studio (BIDS), TOAD, Erwin 4.0.

Programming Languages: T-SQL, SQL, PL/SQL, MDX, Visual Basic 6.0, VB Script, Shell Scripting, VB .NET, C#, JAVA.

Web Servers: Apache Tomcat

Tools: and Utilities: Eclipse IDE, Microsoft FrontPage, MS-Office, TOAD,SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, OH

SQL Server Developer/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in design, development & supporting database requests for multiple applications.
• Gathered requirements, translate functional specs into technical documents and implement them across various environments.
• Involved in database design by analyzing business requirements in both Relational &Dimensional modeling using ERWIN &Database diagrams
• Developed complex joins, stored procedures, functions and triggers with T-SQL
• Responsible for optimizing stored procedures and long-running queries using indexes, DMVs DMFs and execution plans.
• Developed SSIS Packages to migrate data from Oracle, Access, flat files and Excel to SQL server 2008 R2.
• Performed ETL operations using SSIS to validate, extract, transform and load data from heterogeneous data sources to data marts and the EDW Warehouse
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived columns, development and deployment of packages across various environments
• Used Foreach loop container to loop through a set of enumerated items such files in a directory or rows in a table.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS 2008/2005).
• Formatted Reports using Global Variables, Expressions, cascade parameters, Functions for the reports.
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS 2008/2005.
• Created dashboards consisting of grids, charts and reports in Performance Point Server
• Worked along with business users and other stakeholders to understand business processes, and translates them into functional and non-functional specifications for BI solutions Involved in designing, building &, testing of SSIS with Star-Schema.
• Implemented the calculations to aggregate physical measures.
• Migrated DTS packages to SSIS using package migration wizard.
• Involved in Code reviews, Code promotion and change control

Environment: MS SQL Server 2012/2008R2, SSIS, SSRS, SSAS, Windows XP, T-SQL, VB.NET, XML, HTML, VBscript, MS Access, Visual Studio 2005/2008, BIDS

Confidential

SQL/BI Developer

Responsibilities:

• As a core team member in Database design team, actively involved in the database creation using the Normalization techniques.
• Created the Stored procedure and Triggers for all database requests and validations
• Expert in transforming complex business logic into Database design and maintaining it by using T-SQL, Stored Procedures, User Defined Functions, Views, TSQL Scripting.
• Involved in enhancements and support changes made on stored procedures or triggers in the production.
• Migrated data from Legacy systems into SQL Server using (SSIS 2008) from various data sources involving Teradata, Oracle & Flatfiles
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Deployed and supported SSIS packages for data Importing, Cleansing and Parsing etc.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SQL Server Reporting services (SSRS).
• Involved in designing sub reports and linked reports depending on the user requirement and in order to limit the number of Data Sources.
• Developed Complex SSRS Reports involving Sub Reports using new SSRS 2008 r2 features like (Tablix Reports, Charts and Graphs).
• Generated various kinds of reports using Graphs and Images.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SSRS.
• Integrated the reports to SharePoint Server (MOSS 2007)
• Converted Crystal reports to SSRS reports and troubleshoot for any issues
• Created the automated processes to support DBA activities such as jobs & process monitoring using SSIS packages.
• Involved in supporting code migration of SQL Server 2005 data base into SQL Server 2008.
• Developed stored procedures to generate expected liability sheet, penal interest, overdue interest etc.
• Increased performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Adhere to coding standards, Audit reviews and change control across all environments

Environment: MSSQL Server 2008 R2/2005, C#.Net, XML, SSIS, SSRS, Windows Server 2008.

Confidential

Informatica Power Center 8.6 MS SSRS/MS SSAS/SQL Server Developer

Responsibilities:

• Used to gather requirements from Business User documentation.
• Wrote T-SQL procedures, triggers and user defined functions in loading data into different Database tables.
• Communicated within the team, across other teams including, application development, DBAs, QA, and product/project management, to effectively follow through on the tasks
• Created various Views in the Database for easy access of data by other developers.
• Wrote complex Stored Procedures using T-SQL used for developing various BI Reports.
• Defined various Dundas Charts for the SSRS 2005/2008 reports.
• Performed unit testing on Reports, and monitored the performance of the Reports.
• Imported and Exported data between various Databases.
• Involved in designing of Star Schema for Data Warehouse.
• Evaluated existing Oracle 11g systems and PL/SQL code, recommend changes to meet both performance demand and functional requirements, perform tuning and implement changes, Defined DataSources and DataSource Views for Cube building.
• Responsible for defining Fact tables and Dimension tables used in Cube building.
• Defined relationships between Dimensions and Measure groups.
• Wrote MDX queries to retrieve the data from Data Warehouse Cubes to perform analysis and Reporting.
• Reviewed Cube with End user and changing the Cube and documentation according to their Requirements.
• Determined the needs of the users and explaining the options that best satisfy them while translating those needs into a functional application into technical solution.
• Deployed cubes to the required environments.
• Documented Project material.

Confidential

MS SQL Server Developer

Responsibilities:

• Extensive T-SQL Development for evolving business requirements, enhancement to existing procedures. Creating Databases, Tables, Views. Writing complex stored procedures, Triggers, Functions
• Performed backup/restore, created database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning, scheduling for database module with project managers.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Involved in Performance tuning, query-inventory, analysis and optimization.
• Created and managed database users, login Ids and security.
• Performed Data transfer (Import & Export) using DTS packages.
• Responsible for performing complete back-up and restoration, database maintenance Service pack updates on server and client.
• Created reports using SSRS and hosting it in the web for the users.

Confidential

Database Developer/DBA

Responsibilities:

• Database Maintenance of SQL Server on Windows 2000 advanced server.
• Created groups, roles, users and assigning access privileges to users.
• Coordinated with back-end programmers in writing stored procedures, implemented referential integrity by using triggers, performance and tuning.
• Worked in Data profiling & data analysis in a DW environment on MS SQL Server.
• Improved the runs of mapping using Performance Tuning of ETL processes in large scale data warehouse environment.
• Created source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts.
• Performed ETL Processes and reports using Microsoft SQL Server Suite( SSIS, SSRS, SSAS) and other data integration tools like Informatica.
• Maintained design related artifacts i.e. datamodels, Mapping documents, architecture diagrams, data flow diagrams.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations Suggested backup strategies.
• Managing the SQL Servers in Clustered Environment.
• Recovered the database during the event of crash on several occasions. The Recovery was done to Point-in-time and incomplete stage.
• Extraction, transformation and Loading of Data using DTS Packages.
• Exported and imported data from text files and Excel to SQL Server database using BULK insert and BCP utility.
• Performing query plans and making sure each and every query is using appropriate indexes.
• Checked Performance Tuning, Indexing, Query Optimization.

Environment: PL\SQL, Data Warehousing, SQL server 2000, SQL server 2005, SAS, SSIS, SSAS, Oracle 11g

Confidential

SQL Server Developer

Responsibilities:

• Installation of MS SQL server on multiple environments and loading transactions into the existing tables of databases and datawarehouses, defining entity, attributes relationships using constraints.
• Involved in database programming in writing stored procedures, triggers and indexes very frequently.
• Created stored procedures, tables, triggers, indexes and views using Detail design specifications
• Fine tuned queries, assigned proper Indexes for better performance
• Assisting the development team in fixing the defects
• Participating in the knowledge transfer process and share the knowledge with the client team
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes
• Coordinating with other product lines and Software Quality Assurance team.
• Building utility programs for data extraction, transformation, and importing/exporting with SQL Server DB.
• Implemented database consistency and security by creating groups, roles, users, and triggers on views

Environment: MS SQL 2008, Windows 2000/XP, SQL Query Analyzer, Informatica Power Center 8.6, and Enterprise Manager, Oracle 9i & Windows XP platform.