SUMMARY

• 7 years of experience as a software Engineer/Analyst in all phases of System development Life Cycle (SDLC) from investigation of initial requirements through analysis, design, programming, testing documentation and implementation.
• 6+ years of experience with focus on Database design and Development using different tools of ER diagram, Normalization techniques.
• Very good experience in Developing database objects like tables, views, indexed views, synonyms, stored procedures, user defined functions and writing dynamic SQL, T - SQL.
• Creating Clustered and Non-Clustered indexes on tables for faster query retrieval.
• Using OSQL, sqlcmd, dtutil, dtexec utility.
• Working on snow-flake and star schemas.
• Creating DTS and SSIS Packages. Control flow items and data flow tasks.
• Using property expressions, variables and script tasks to customize data processing.
• Creating package configuration files.
• Importing and exporting packages to SQL Server and file system.
• Moving packages and configuration files across different environments.
• Creating audits/logging for SSIS packages on task level and package level.
• Configuring error handling, notifications, restart ability (checkpoints and user defined logic)
• Creating YTD, MTD and WTD sales and inventory reports on store level.
• Reports with Drill mode using tables, crosses tabs and charts.
• Developing report models to give users flexibility to create dashboards of their own choice.
• Building reports on SSAS cubes and importing KPI’s.
• Configuring data driven subscriptions for executive summary reports.
• Creating reports that can be viewed in mobile devices (iPhone).
• Building financial, inventory and merchandise cubes.
• Creating partitions for faster processing of cubes and to achieve better performance.
• Designing aggregations both manually and Usage based aggregations.
• Creating attribute relations and attribute hierarchies in cube.
• Writing MDX queries for query retrieval from cubes.
• Creating calculated members, named sets, actions and KPIs to implement business logic.
• Creating sub cubes and perspectives. Also configuring security roles and groups.
• Understanding query flow using execution plan and tuning the query to use appropriate Scan/Seek (Index Seek, Index Scan and Table Scan).
• Using SQL server hints, DMVs and DBCC commands whenever necessary.
• Configuring user roles and groups.
• Setting up recovery models. Backup and restoring databases.
• Setting up and maintaining database mail accounts and profiles.
• Deploying SSIS Packages, SSRS reports and SSAS cubes on production server.
• Configuring and installing SQL Server 2005/2008R2, Visual Studio and Team Suite (TFS).
• Very good communication skills and experience in client interaction while providing technical support and knowledge transfer.

TECHNICAL SKILLS

Operating System: Windows NT/98/2000/XP/2003 server

Languages: C++, Visual Basic 6.0. VB.Net, T-SQL, PL/SQL, Visual Studio 2003/2005

Tools: DTS, SSIS,SSRS,SSAS

DATABASE: MS Access, MS SQL Server 7.0/2000/2005 , Oracle8i/9i

Tools: /Utility: Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, BCP, SQL Profiler

Software: MS Office, Visio, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services 2005

PROFESSIONAL EXPERIENCE

Confidential, Ft Myers, FL

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed System Standards, System Architecture, Scenarios, detailed Screen Specifications and documented Logical and physical Data Model.
• Developed tables, Views, Stored Procedures, Cursors and Triggers using SQL Server Management Studio.
• Involved in daily incremental loads into Staging and ODS areas, trouble shooting process issues and errors.
• Created several Staging Databases.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Used various Control Flow tasks in SSIS like For Each loop Containers, Sequence container etc and data flow tasks like derived column, lookup, Fuzzy Lookups, conditional splits etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user groups.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated Packages from DTS to SSIS by using advanced features in SSIS.
• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created package configuration files to make packages dynamic across multiple environments.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Performed Sorting, formatting, and Grouping to custom reports in (SSRS).
• Created SSRS subscriptions and data driven subscriptions.
• Published Reports to the report server virtual directory.
• Created analysis Services Database to hold Sales, Inventory and Finance cubes.
• Created named sets, calculated member and designed scope in SSAS.
• Implemented cell level security in the cube by writing MDX expressions.
• Designed cube aggregations and Usage based aggregations for fast query retrieval
• Created partitions for large measure groups in SSAS.
• Created Actions, Drill through and Reporting Actions in Cube.
• Created SSRS reports on Sales cube by writing MDX.
• Identified and resolved the query performance using SQL Profiler.
• Fine-tuned existing reports by running execution plan on queries and identifying tables that need indexes.
• Rebuild/Reorganized indexes where ever necessary.
• Involved in DBA activities like database backup, restore.
• Day-day SQL activities.

Environment: Confidential SQL Server 2008R2, SQL profiler, SSIS 2008R2, SSRS 2008R2, SSAS 2008R2, Visual Studio 2008, Confidential Office share point 2007, windows 2003/XP/vista,.NET Framework, C#, VB, ASP.NET, ADO.NET.

Confidential, NY

SQL Developer/DBA

Responsibilities:

• Gathered requirement and designed technical document to implement the application.
• Designed and developed data model in SQL Server using Visio.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs).
• Involved in daily loads (FULL & INCREMENTAL) into Staging and DW areas, trouble shooting process issues and errors.
• Created property expressions for several tasks like For Each loop Containers, Sequence container etc and data flow tasks like derived column, lookup, Fuzzy Lookups etc.
• Implemented error handling and notifications in SSIS
• Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Created Ad Hoc reports by building models in Report Builder using SQL 2005 Model Designer and Report Builder.
• Designed various reports using different reporting features such as group by, drilldowns, drill through etc.
• Created parameters (multi value, hidden, default etc...) for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.
• Created new reports from the scratch for new requirements and modified some of the existing reports using SSRS.
• Provided documentation of reports and the development process in order to support the system
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint
• Created Sales, inventory and finance cubes in SSAS and designed dashboards on cubes to give users valuable information about business.
• Created partitions, aggregations on measure groups in SSAS for better performance.
• Configured cell level security in SSAS by creating roles and writing MDX expressions in SSAS.
• Created calculated members, named sets and scopes to implement business logic in SSAS cube.
• Created and debugged data connections, data sources and Data Source Views.
• Fine-tuned SSRS reports, SSIS packages and store procedures that take long time for execution.

Environment: Confidential SQL Server 2008R2, SQL profiler, SSIS 2008R2, SSRS 2008R2, SSAS 2008R2, Visual Studio 2008, Confidential Office share point 2007, windows 2003/XP/vista,.NET Framework, C#, VB, ASP.NET, ADO.NET.

Confidential, Seattle, WA

Responsibilities:

• Involved in analysis, design, development, and enhancement of the application that applies business rules on the revenue data on weekly basis.
• Responsible for creating views out of business rules.
• Created stored procedure to create views dynamically.
• Created stored procedure that executes business rules on the revenue data.
• Created jobs that extract Ad Centre and Ad Expert data, apply business rules, make it available to xCat to run payouts and archive the data once the process is complete.
• Created SSIS package to get data from share point, Cubes.
• Implemented pre-validation and post-validation for the data imports.
• Created pivots for the business to validate the rules.
• Created archival jobs to archive last # iterations of data.
• Involved in creating windows installer to install the application in SIT/UAT/Production environments. (Data base objects, jobs, packages etc were installed on target server by this application)
• Created work flow items in version control system (Visual Studio TFS) to assign work to team.
• Created mail notifications to notify success and error notifications using Sp send dbmail.
• Created, deployed and processed Cubes in SSAS.
• Created custom Named Sets and calculated members in SSAS.
• Configured drill through and reporting actions in SSAS.
• Created KPI’s in SSAS and imported into PPS.
• Created dimensions in the performance point server.
• Imported data into Performance point server from sql database through csv files.
• Tuned the performance by making use of clustered and non-clustered indexes.
• Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Scheduling Jobs and Alerting using SQL Server Agent
• Performing query plans and making sure each and every query is using appropriate indexes.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Created UTP document and performed unit test processing.
• Created dashboard to verify the data import and the rules execution at one go.
• Created auditing/Logging.
• Involved in writing MDX queries to retrieve data from cubes using SSIS.

Environment: SQL Server 2005 Enterprise Edition,.NET Framework, XML, T-SQL, SSIS 2005,SSRS, SSAS,VisualStudio.NET IDE, Windows 2003 Advance Server, ASP, MS Excel, MS Access. Visual Studio 2005

Confidential, Memphis, TN

SQL Server / SSRS

Responsibilities:

• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Designed, coded, tested and implementeduser interfaces, procedures and functionsfor new and existing softwareapplication requirements.
• Worked with technology features in SQL Server such as Partitioning, File Groups, Replication, Materialized Views, Options available in executing database statistics
• Install, tune, maintain and monitor SQL Serverfor the Production environment
• Created SSIS package to get data from different sources, consolidate and merge into one single destination.
• Created variety of reports for business to provide them with critical information about business status.
• Created stored procedures for datasets in SSRS reports to run calculations at database level.
• Created expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.
• Materialized views, dimensions and stored outlines for optimal performance.
• Actively involved in Normalization & De-normalization of database.
• Created complex variables, multiple breaks, sorts in the reports.
• Created generic Measure class for generic measures, and created separate class for conditional objects.
• Involved in System testing.
• Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.
• Used Database Engine Tuning Advisor and SQL Profiler to optimize queries and enhance the performance of database servers

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

Confidential, Houston, TX

SQL/SSIS/SSRS

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of end User Requirements
• Used TSQL to create various stored procedures.
• Created new tables, wrote stored procedures and some user defined functions for Application Developers
• Performed data conversions from flat files into a normalized database structure.
• Created Triggers, Check Constraint and Primary/Foreign Key to enforce data and referential integrity.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Worked on SSIS Packages, SSIS Import/Export for transferring data between SQL Server.
• Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files.
• Performed tuning of SQL queries and stored procedures using SQL Profiler.
• Involved in generating summary reports using SSRS.
• Created YTD, MTD sales reports.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS, SSRS, MS .NET Frame Work, ASP.NET, C#, Access 2000 & Windows 2K platform ADO.NET, MS Project, MS

Confidential

Responsibilities:

• Created new tables, stored procedures for Application Developers and some user defined functions.
• Performed data conversions from flat files into a normalized database structure.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Created DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Development of T-SQL Stored Procedures for moving and maintaining synchronization of data between legacy system and newly developed application.
• Expertise in using variables, property expressions, script tasks in SSIS Integrated Database Maintenance jobs to perform full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Documented and maintained history of changes for future reference.
• Tuned the batch programs and online transactions to alleviate performance problems.
• Developed & executed several Optimized queries in SQL.
• Assigned Index tuning scripts to run at regular intervals.
• Performance monitoring and tuning MS SQL Server.
• Assisted the Application team in data modeling and T-SQL coding.

Environment: SQL Server 2000/2005, SSRS, SSIS, T-SQL, Script, JavaScript, ASP, Confidential Office, Windows 2003/XP.