SUMMARY

• 8+ years of experience in design, development, coding and testing of business and commercial applications in MSSQL Server 2012/2008R2/2008/2005, MS Access, and Windows 2000/2003/2008.
• Extensively worked on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.
• Excellent knowledge of entire Software Development Life Cycle(SDLC) methodologies like waterfall model and Agile methodology
• Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.
• Experience inOLTP/OLAPenvironment andData Warehouse.
• Strong knowledge on Oracle Architecture and Database Management.
• Extensive experience in SQL Server Analysis Services OLAP Cubes, and Data Mining.
• Work experience on MS SQL Server 2012/2008R2/2005/2000, Oracle, VB 6, crystal reports 6.
• Experience indesigning, developing and deployingBusiness Intelligence solutions usingSSIS,SSRS
• Designed and developedmatrix and tabular reportswithdrill down, drill throughusingSSRS.
• Experience inwritingComplexSQLQueriesinvolving multiple tablesinnerandouter joins.
• Worked as MS SQL Server Developer on enterprise and performance critical applications.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in MS SQL Server.
• Involved in migration of legacy data by creating various SSIS packages
• 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 developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill - down, Drill-through And Cascading reports using SSRS.
• Proficient in Database performance optimization, debugging and tuning using teh Query Analyzer, SQL Profiler and SQL Server Debugger.
• Expert in generating drill down reports in SSRS 2008.
• Experience in Handling Heterogeneous data sources and databases Oracle, Teradata, and csv and XML files using SSIS.
• Enhancing teh Reports visually by adding teh visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of teh Database using Erwin tool.
• Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables.
• Developed interactive web-based reports and forms with VB.NET and ASP.NET and ADO.NET and html.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Exceptional Computer Science background with programming skills in VB as a Junior Programmer.
• Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.
• Experience in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.
• Experience in tuning teh reports that includes modifying, Testing teh required TSQL and MDX queries using DMV's and creating teh necessary environment for Deployment.
• Proficient with automated testing tools - Win Runner, Load Runner and QTP for testing Client / Server and Web based applications
• Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
• Self-Motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Ability to work excellently as an individual and also as part of a team with minimum amount of supervision.

TECHNICAL SKILLS

Databases: MS SQL server 2000/2005/2008/2012, Oracle, Teradata, MS Access, Netezza

Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, Data Transformation Services

Languages: Transact- SQL, SQL,HTML, XHTML, C, XML

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports, Business Objects.

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler.

Data Modeling Tools: Erwin tool, Microsoft Visio 2000/2003

Operating Systems: Windows server 2003, Windows 2000 advanced server/professional, Windows NT, Windows XP professional /standard, Windows 7 and UNIX.

Other Tools: Microsoft Visual Source Safe, TFS, Microsoft Office, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SQL Server SSRS/SSIS Developer

Responsibilities:

• Interact with teh system analyst & business users to gather business requirements, system specification and enhancement.
• Created SSIS packages to pull data from text files, XML files, SQL server and excel and exported to excel spreadsheets, flat files and vice versa.
• Published migrated data using SSIS, DTS Wizard (data transformation services) tool through data flow tasks, look up transformations and script tasks.
• Extensively worked on mappings, incremental data loading, and SSIS transformations that include: lookup, filters, aggregators, scripts, multicasts, derived (not limited).
• Intensively used SSIS Import/Export Wizard, for performing teh ETL operations.
• Scheduled teh created SSIS /DTS packages using SQL server agent.
• Worked on error handling using try and catch blocks and performance tuning using counters in SSIS.
• Created complex stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Created complex SSIS Package using Script Task, For Each Loop, Derived Columns, Fuzzy Lookup, Condition Split, Sort, Union All, Execute SQL Task, Data Flow Task and File System Task.
• Used various data transformations like Conditional Split, Script Component, Derived Column, Sort, Merge Join and Data Conversion etc.
• Involved in extracting teh data using SSIS from OLTP to OLAP.
• Worked on teh Audit Logs that capture teh audit details before and after teh package execution using Variables and Parameters.
• Created SQL server reports using SSRS 2005/2008 for manager, customer support and that can deliver at client’s station.
• Designed different type of SSRS reports: Tabular, matrix (cross tab), conditional, list items, charts and sub reports.
• Created cascading (collapsed) parameters to a report, and added report parameters that can be used in user-defined function.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Designed printable, interacted reports (drill-down and sorting functionality).
• Created and designed reports based on query parameters and report parameters.
• Involved in creating cubes and dimensions for teh new data warehouse using SQL server analysis services (SSAS).
• Took part in creation of star schema and snowflake dimensional schema in MS analysis services (SSAS).
• Supported in creating KPI, calculation members and measure groups, and MDX queries.
• Worked with preparing teh documentation for analysis, Technical Specification documents, Functional Specification documents, mapping documents etc., for various migrations and up gradation projects.

Environment: SQL Server 2012/2008/2008 R2 Enterprise Edition, Netezza, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share point Server, XML, MS Visual Source Safe.

Confidential, Dublin, Ohio

Sr SQL Developer/ MSBI developer

Responsibilities:

• Designed SSIS Packages to handle data migration (ETL Processes) from transaction system
• Created teh Staging tables, successfully migrated old data from legacy system into SQL Server using SSIS Packages.
• Used Sequence Container in Control Flow for linking all dimension tables.
• Extensively used SSIS transformations such as Slow Changing Dimension, Lookup, Conditional split, Sort, Merge Join, Aggregate, and Execute SQL task etc.
• Generated reports using SSRS. Identified teh Data Source and defined them to build teh Data Source Views.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Scheduled teh monthly/weekly/daily reports to run automatically. Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send teh reports via email.
• Responsible for scheduling teh subscription reports with teh subscription report wizard. Deployed teh generated reports directly on teh client’s workstation.
• Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Performed activities like creation and indexing of teh tables.
• Created Views and Indexed Views to reduce database complexities for teh reports.
• Enhancing and deploying teh SSIS Packages from development server to production server.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS) 2005, SQL Server Reporting Services (SSRS) 2005, T-SQL, MS Office, Windows Vista

Confidential, TX

SQL Developer/MSBI Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand teh requirements of teh system.
• ScheduledComplex Stored Proceduresusing SQL Server Agent.
• Monitored and modified Performance using execution plans and Index tuning
• Involved in project planning, also schedule for database module with project managers.
• Responsible for writingT-SQLcode for creatingcursor and handling data validations
• Designed and Developed Database Objects like Tables,Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for teh project.
• Developed, tested and implementedReferential Integrity rulesand regulations through constraints, triggers and views, partitioned views.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Created SSIS Packages user data from teh Flat files on monthly and weekly basis.
• Created Database objects - views, and functions and developing procedures for implementing application functionality at teh database side for performance improvement.
• Defined constraints, rules and defaults and developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Created views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Assisted and supported issues related to teh queries and database systems.
• Involved in rebuilding teh indexes at regular intervals for better performance.
• Designed SSIS packages to load data from different sources Text files, Excel to staging and staging to Data warehouse.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
• Created datasets, data source and involved in deploying teh reports in to teh report server.
• Created SSIS packages using script task by C#.
• Created reports using SQL Server 2005(SSRS) and integrated into teh web front end.
• Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for teh analysis of Performance.
• Created Drill reports which give all teh details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Reporting services).
• Worked on Performance tuning, and optimization of procedures and queries.
• Created ad-hoc queries from SQL Server databases for custom reporting needs. Worked on querying data and creating on-demand reports using Report Builder in SSRS.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Environment: SQL Server 2005, T-SQL, SSIS, SSRS, VB.NET, ADO.NET, Microsoft Excel, Microsoft PowerPoint.

Confidential, St. Louis, MO

SQL Server Developer

Responsibilities:

• Developed Complex Stored Procedures, Views and Temporary Tables as per teh requirement.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS packages.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD’s), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and Un Pivot as per teh client requirement.
• Implemented Logging and Event Handlers on SSIS packages for trouble shooting.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on teh requirements using SSRS 2012.
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand teh Business requirements.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Rendering teh reports to PDF formats as per teh requirement and printing all teh reports in a batch process for monthly Statements.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Designed and developed databases using Oracle, MS SQL server.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within teh report.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Designed, Build teh Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005 (SSAS)
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Used Service Oriented Architectural approach for developing Information Systems and later on used it for databases.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Checked teh configuration and performance of teh existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc.) to avoid and optimize by following teh Normalization standards to maintain data consistency and by performing data validation.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server- 2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, Oracle, C#.NET, ProClarity Analysis.

Confidential

SQL Developer

Responsibilities:

• Gatheird requirements to identify and create database objects such as tables, views, triggers and indexes.
• Involved in Normalization of teh database and bringing it to 3NF.
• Involved in creating teh constraints, rules, defaults and triggers to maintain teh data and referential integrity.
• Created ER diagrams using Visio.
• Created Views to enforce security and data customization.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in teh performance tuning and optimization of T-SQL queries.
• Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Developed user requested reports using Crystal Reports and Excel.
• Created Drill down and Drill through reports using Crystal Reports.

Environment: MS SQL Server 2005, Windows NT platform, Visual Basic 6.0, Crystal Reports.