PROFESSIONAL SUMMARY

• 7 plus years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence BI database applications and various segments of SDLC, using MS SQL Server 2008/2005/2000 DTS/SSIS, Reporting Analysis Services.
• Extensive SQL Development experience in Cruise line, Financial Banking environments with a strong understanding of data analytics.
• Extensive knowledge in tuning T-SQL DDL and DML queries to improve the database performance and availability.
• Hands on experience with Tableau.
• Proficient in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation, data consistency and complex business logic using Batch Files.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio and Erwin 7.0.
• Skilled in SQL 2005 Business Intelligence tools, Data Warehousing and ETL processes strategies using SQL Server Analysis and Integration Services.
• Extensive experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Experience in writing MDX queries creating and customizing Cubes using SQL Server Analysis Services SSAS 2005/2008.
• Familiar with Data Warehousing designs in Star and Snow flake Schemas.
• Extensive experience in report writing using SQL Server Reporting Services like Table report, Matrix report, Chart Report, Pie charts column report.
• Excellent in rendering reports, managing subscriptions, creating reports with report builder, report snapshot and report cache.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Define and develop Report Structure with data definition, report layout and report definition language.
• Experience in deploying reports to SharePoint Servers.
• Experience in using SQL Server Integration Services SSIS to build Data Integration and Workflow Solutions, Extract, Transform and Load ETL solutions for Data warehousing applications.
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
• Expertise in building and migration of various DTS packages.
• Experience in using Windiff for comparing files and highlighting disparity.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Expertise in database optimization using tools like Index Tuning Wizard, SQL profiler, File groups, DBCC utilities and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in creation of Database authentication modes, configuring permissions and assigning roles to users.
• Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and also Log Shipping, Mirroring Replication to restore Database backup.
• Connected remote SQL Servers as Remote and Linked Servers to run distributed queries between SQL servers and other data sources like Excel using ODBC, OLE DB Drivers.
• Good knowledge of Computer Science theory strong in modern programming languages.
• A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skill.
• Excellent Verbal Written Communication skills and strong in Documentation.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS:

• Software/Databases: MS SQL Server 2005 / 2000/7.0, MS SQL Server Reporting Services 2008/2005/2000 SSRS , MS SQL Server Analysis Services 2005 SSAS , MS SQL Server Integration Services 2005 SSIS ,Tableau, Data Transformation Services DTS , Oracle 9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio SSMS , MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, Web Services, SQL Profiler, Bulk Copy Program BCP .
• Programming Languages: T-SQL, PL/SQL,C , ASP .NET, VB .NET,MDX queries.
• RDBMS/DBMS: MS-SQL Server 2008/2005/2000/7.0, Oracle 8i/9i/10g, MS Access.
• Operating Systems: Windows 98/2000/2003/XP/NT/Vista, Windows 2000Advanced Server, Windows 2003 Enterprise Server.
• Version Control: Team Foundation Server TFS ,Visual SourceSafe VSS .
• Web Servers: IIS 6.0, SharePoint server.
• IDE BI Tools: SQL Server BI Development Studio BIDS , MS Visual Studio 2008/2005.
• Data modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose
• Version Control TFS, MS Visual Source Safe VSS 6.0, Rational Clear Case
• Design Methodology Unified Modeling Language 1.1 using Rational Rose.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server BI Developer

Responsibilities:

• Designed Tableau semantic layer for Data warehouse Proof of Concept POC dashboards for DARCY data warehouse project.
• Used Tableau Desktop to analyze and obtain insights into large Giving statistics Revenue data sets .
• Involved in creating visually compelling and actionable interactive reports and dashboards using Tableau.
• Worked closely with business users in DARCY in finalizing the business data required for Tableau dashboards.
• Involved in T-SQL coding, Scripts , Stored Procedures and functions on a day-to-day basis.
• Work independently on owning IT support tasks related to Tableau specifically and overall BI initiatives and projects including but not limited to providing LOEs for new BI initiatives.
• Involved in the initial design of Proof of concept POC SSAS Cubes.
• Created both automated and manual reports using SSRS.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Configured report builder and trained business users so that they could create reports from the report models I created.
• Deployed and configured reports in Report Server.
• Created standard Data driven report subscriptions. Created report snapshots and cache for better performance.
• Migrate BERT reports to SSRS reports.
• Used SSIS packages to transfer data between OLTP system and OLAP warehouse.
• Develop maintain SSIS packages for various jobs.
• Developed ETL Packages using SQL Server 2008 Integration Services to migrate data from Oracle data source into a SQL Server 2008 database.
• Involved in developer testing of SSIS packages and SSRS reports.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in code reviews meetings and designing sessions and get mentored from the tech leads.

Environment: MS SQL Server 2008, T-SQL, Tableau, SSIS, Tortoise SVN, SSRS, MS Excel, Visio, Erwin, SSAS, Windows 2008 server

Confidential

Associate Database L2/SQL Server Developer

Responsibilities:

• Extracted required mapping fields from different sources schema, CDW to Bridgetrack.
• Performed all Conversion goals and objectives which include identifying data for processing sales, and validating of data for migrating to Bridgetrack system.
• Analyzed and performed Data mapping which involves identify source data field, identify target entities and their lookup table id's, and translation rules. Evaluation of data groups and data critically and developed automated conversion process.
• Developed and modified many Scalar Valued Functions, Stored Procedures for parsing data required for mapping in Bridgetrack. Tweaked low performance functions.
• Developed Store Procedure and Staging table for data push from Bridgetrack.
• Preformed QA Testing for all the Store Procedures to validate results.
• Developed SSIS Packages not only for particular table's fields and required data types for lookup tables in Staging but also for data Warehouse requirements of CDW.
• Increased query performance by 20 , which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Created and scheduled SSIS packages for running feeds from various departments and multiple servers and resources to Development Servers.
• Created SSIS Packages by using advanced tools i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting .
• Created Packages by testing and Cleaning the Standardized Data by using tools in Data Flow Transformations Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more for existing/new packages and huge CSV file import to Bridgetrack from different data sources and other ongoing tasks for mapping.
• Developed and modified the existing reports from basic Chart and tabular to parameterized reports including Single/Multi/Boolean valued parameters and linked reports based on new business logic.
• Created SQL server configurations for SSIS packages and XML Windows event logs.
• Used sub reports functionality for complex report calculations.
• Created parameterized reports passing parameter through report screen.
• Rendered reports in different formats like .pdf, excel etc to be executed automatically on weekly or monthly basis and managed subscriptions.
• Documented all database objects, procedures, views, functions packages for future references.
• Performed all QA testing and match results for different environments.
• Documented all old and migrated Store Procedures and scripts for future references.

Environment:

Windows XP/2003 Enterprise edition, MS SQL Server 2005/2008, Excel 2003, Visual Studio 2005, TFS, VBScript, Database Engine Tuning Advisor, Profiler SQL Server Management Studio 05, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, SSIS, SSRS.

Confidential

SQL Server Application Developer

Responsibilities:

• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created both automated and manual reports using SSRS SQL Server Reporting Services .
• Configured report builder and trained business users so that they could create reports from the report models I created.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Created numerous reports from prototype Analysis Services Cube using SQL Server 2008 Reporting Services.
• Deployed and configured reports in Report Server.
• Created standard Data driven report subscriptions. Created report snapshots and cache for better performance.
• Migrated Actuate PIC reports to SSRS reports.
• Used SSIS packages to transfer data between OLTP system and OLAP warehouse.
• Analyzed and tuned Database Growth and Space Requirement as data was growing at a rate of 11 GB/day.
• Created, Tested and deployed SSIS Packages for data migration into Facts and dimension tables in the data mart from the source data warehouse tables.
• Developed ETL Packages using SQL Server 2008 Integration Services to migrate data from Oracle data source into a SQL Server 2008 database.
• Involved in code reviews meetings and designing sessions and get mentored from the tech leads.
• Created modified a number of existing stored procedures based on the changes made to some existing tables.
• Loaded the data into data warehouse in form of Dimensions and Fact tables.
• Involved in developer testing of SSIS packages and reports.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard

Environment: MS SQL Server 2008, T-SQL, SSIS packages, TFS, SSRS, MS Excel, Visio, Erwin, SQL Server Analysis Services, Windows 2008 server

Confidential

SQL Server Developer SSIS, SSRS

Responsibilities:

• Created standard Data driven report subscriptions. Created report snapshots and cache for better performance.
• Involved in Installing SQL Server 2005 and creating users and Groups.
• Involved in code reviews meetings and designing sessions and get mentored from the tech leads.
• Created modified a number of existing stored procedures based on the changes made to some existing tables.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created both automated and manual reports using SSRS SQL Server Reporting Services .
• Configured report builder and trained business users so that they could create reports from the report models I created.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Created reports from prototype Analysis Services Cube using SQL Server 2005 Reporting Services.
• Deployed and configured reports in SharePoint Server.
• Developed ETL Packages using SQL Server 2005 Integration Services to migrate data from Oracle data source into a SQL Server 2005 database.
• Created SSIS Packages by using advanced tools i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting .
• Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.

Environment: MS SQL Server 2005, T-SQL, SSIS packages, VSS, SSRS, MS Excel, Visio, Erwin, SQL Server Analysis Services, Windows 2003 server