SUMMARY

• Over 6 (Six) years of strong SQL Server Developer and Business Intelligence experience in Finance, Banking, Retail, Insurance domains with expertise in MS SQL Server 2012/2008R 2/2008/2005/2000 and Business Intelligence including SSIS, SSAS, and SSRS.
• 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.
• Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server 2012/2008R2/2008/2005 and Access databases. Some experience with Oracle and MYSQL Databases.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, Indexes, User Defined Functions, Relational Database models, Data integrity and SQL joins.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008R 2/2008/2005.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2008R 2/2008/2005.
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.
• Expert in designing complex reports like Drill-Down reports, Drill-Through Reports, Parameterized Reports, Sub Reports, Ad-hoc reports and Dashboard Reports using SSRS based on client requirement.
• Expertise in developing and extending MS SQL Server Analysis Services 2008/2005 (SSAS) cubes, data mining models, deploying and processing SSAS objects, and writing MDX queries.
• Experienced with advanced attributes and dimension properties design, designing relationships between dimensions and measure groups, designing calculations, KPIs, actions, perspectives and generating report model based on cubes (SSAS).
• Experienced in sorting the data, defining data source and subtotals for the reports.
• Using Data Mining Wizard and Designer to Design, Manipulate models.
• Experience in Implementing Database Mirroring in SQL server 2005
• Experience in Data Migration using ODBC Data source .
• Experience in implementing different types of Replication models like Transactional, Snapshot and Merge
• Experience with Database Backup and Restore
• Documented disaster recovery plans and participated in disaster recovery drills
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Worked on administration tasks such as Data loading/unloading, Batch Jobs, Backup & Recovery, User and Application Table Management, upgrades, creating Databases/File groups/Files/Transaction logs.
• Strong leadership, communication, problem-solving and multi-tasking abilities.
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

TECHNICAL SKILLS

• MS SQL Server 2005/2008/2008 R2
• SQL Server Business Intelligence Development Studio (BIDS)
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• SQL Server Agent
• SQL Server Profiler
• Database Engine Tuning Advisor
• Report Builder3.0
• SQL Server DTS
• Data Stage
• Crystal Reports
• Oracle9i
• Microsoft Products MS SharePoint
• MS Word
• MS Excel
• MS Access
• MS Project
• MS Power Point
• T-SQL
• PL-SQL
• MDX
• XML
• Html
• .Net
• MS Visio 2003

PROFESSIONAL EXPERIENCE

Confidential, Fairfax, VA

SQL Server BI Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Utilized documentation prepared by Business Analyst to complete projects.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Created SSIS package to load data from Flat File (2GB -- 4GB) to Flat File and Flat File to SQL Server 2008R2 using Lookup, Fuzzy Lookup, Derived Columns and Condition Split, .
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Extracted data from Oracle and migrated into SQL Server 2008R2 using SSIS.
• Creating and managing scheme objects such as tables, views, clusters, Indexes, Procedures, triggers and maintained Referential Integrity.
• 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.
• Design various E-R diagrams for different modules by using Visio.
• Migration is also done using Bulk Insert and dynamically created queries in the job steps.
• Implemented automated jobs for Database Backup on a weekly and monthly basis.
• Implemented complex conceptual database design and database architect into SQL Server 2005/2008R2 using various constraints and triggers.
• Played a major role in production support of SSIS jobs.
• Using Visio 5.0 design different kind of Data Models for various kind of databases as per the requirement.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts, Table.
• Created ad-hoc reports using SQL server 2008 R2 Reporting Services (SSRS).
• Deployed 2008 R2 Reporting Services (SSRS) RDL files to Reports server.

Environment: MS SQL Server, SSIS, SSRS, SSAS, BIDS, SSMS, Oracle 11g, MS Office, Outlook

Confidential, Philadelphia, PA

SQL Server BI Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements, Data Migration from SQL Server 2005 to SQL Server 2008 and provided documentation
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area, then used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, and finally transfer into data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Created SQL server configurationsfor SSISpackages and experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages.
• Created complex stored procedures, efficient triggers, and required functions, creating indexes, and indexed views for improving performance.
• Responsible for creating reports based on the business requirements using SSRS 2008
• Identified the database tables for defining queries to generate reports for analysis of data using SSRS in Report Builder.
• Created various reports including Cross-tab, Conditional, Drill-down, Sub reports, parameterized reports and also created number of complex formulae in sub report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data also scheduled monthly/weekly/daily reports to run automatically.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and created Report templates, bar graphs and pie charts based on the financial data also scheduled monthly/weekly/daily reports to run automatically.
• Scheduled JAD Sessions and involved in gathering the report specifications by interacting with the business users.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2008(SSRS), SQL Server Integration Services 2008(SSIS), VSS, Microsoft Visual Studio, SSMS, ASP.NET, MS Excel, T-SQL, C#.

Confidential, New York, NY

SQL Server BI Developer (SSRS/SSIS)

Responsibilities:

• Generated database SQL scripts and deployed databases including installation and configuration.
• Design and Build Extract Transform Load procedures in SQL Server 2005 to import/export data feeds to/from data warehouse.
• Worked with SSIS to import, export and transform the data between the linked servers.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.
• Designed and developed Packages using Lookup, Merge, Merge Join, Conditional Split, Aggregate and Export Column.
• Created Drill-through, Drill-down, Cross Tab and Sub-Report using SQL Server Reporting Services (SSRS).
• Generated the weekly, monthly, and quarterly report by using SQL Server Reporting Services (SSRS).
• Migrated data from SQL Server to MySQL by using an ODBC Data source.
• Worked on Stored Procedures and Database Triggers and business analytical functions.
• Tuned the database to perform efficiently by managing databases using the option grow or shrink database files and monitor the size of transaction log.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Used Microsoft Source Safe for version control and configuration management.

Environment: SQL Server 2005/2000, SQL Server Management Studio, T-SQL, DTS, SSIS, ETL Tools, Visual Source Safe, SQL Profiler, Query Analyzer, Microsoft Source Safe.

Confidential, NYC, NY

SQL Server SSRS 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.
• 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: SQL Server 2005, SSRS, SSIS, SQL Server Management Studio (SSMS), Windows Server, DTS, T-SQL, Report Builder, SharePoint, Server Agent, Profiler, Database Engine Tuning Advisor, Query Analyzer.

Confidential, Framingham, MA

SQL Server 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: SQL Server, SQL Server Reporting Services, SQL Profiler, Query Analyzer, MS Office, Windows