SUMMARY

• Over 7+ years of IT experience with a strong background in Data warehousing projects design, development and implementation with SQL Server 2008/2005/2000 in a high transaction and multi - server production environment. Self- learning ability and Leadership Quality.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Expert in Extraction, Transforming and Loading (ETL) data using SSIS/DTS; creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Experience in writing Distributed Queries between SQL Servers.
• Handled huge financial data, expert level query optimization and performance tuning experience
• Experience in creating Jobs, Alerts, setting up SQL server mail agent for SSIS packages.
• Expertise skill in Migrating/Re-writing DTS packages to SSIS packages using Upgrade Advisor/Package Migration Wizard.
• Expertise in generating reports using Crystal Reports, SQL Server Reporting Services, and Microsoft Access & Excel spreadsheet.
• Experience in creating various reports like drill down, sub reports, parameterized, multi-valued reports through Report model creation.
• Experience in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.
• Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the enterprise.

TECHNICAL SKILLS

Languages: C, C++, T-SQL

Databases & Business Intelligence Tools: MS SQL Server 2012/2008/2005/2000 , SQL Server Management Studio (SSMS), MS SQL Server Integration Services (SSIS) 2012/2008/2005/2000 , MS Access

Web Technologies: XML Web Services, Microsoft Office SharePoint Server (MOSS) 2007, .NET

Reporting Tools: SQL Server Reporting services (SSRS) 2012/2008/2005/2000 , Tableau 7.0/8.0/8.1 server and desktop, Spotfire, Qlikview, Logi XML, Crystal Reports

Web Server Technologies: Data Modeling Tool, ETL, Microsoft Visio

Operating System: Windows 2008, Windows 2000/2003 Server, data center, Windows NT, Windows 95/98/2000 XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Jersey city, NJ

SQLBI/SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed and coded application components in an Agile environment utilizing a test driven development approach.
• Created and maintained project tasks and schedules.
• Provided programming estimates, identified potential problems and recommended alternative solutions.
• Worked in close cooperation with project managers and other functional team members to form a team effort in development.
• Collaborated with other members of the product development team.
• Participated in Daily Scrum Meetings and Sprint Retrospective and sprint planning for on time delivery of Business Needs.
• Responsible and active in the analysis, design, implementation and deployment of full software development life-cycle (SDLC) of the project.
• Defined the search criteria and pulled out the record of the customer from the database. Make the required changes to the record and save the updated information back to the database.
• Developed user defined functions based on requirements.
• Involved in data mappings.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Used SSIS transformations such as, For-Each Loop Container, Sequence Container, Expressions, Execute SQL task and Providing Error Handling.
• Involved in handling the changes in compiling scripts according to the database changes
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization
• Engaged in new development as well as support maintenance or enhancement of existing applications. Projects will entail complex business requirements and processes.
• Responsible for detailed analysis and design using Microsoft Technologies for services that will support internal and external clients facilitate and deliver on business needs for functional and business mapping.
• Worked extensively in migrating data from various sources such as Excel, Oracle, MS Access, MySQL, OLE DB, and flat files to different destinations using SSIS.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created OLAP cubes using SSAS to use in business intelligence development.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.

Environment: Microsoft Visual Studio, Team Foundation Server (TFS),Code Collaborator, MS SQL Server 2008 R2, SSRS, T-SQL, SSIS.

Confidential, Albany, NY

SQLBI/SSIS/SSRS Developer

Responsibilities:

• Planned, defined and designed data based on business requirement and provided documentation for all kinds of reports, DTS and SSIS packages for further reference.
• Developed SSIS Packages using Look Up Values & implementing rules provided by business in the mapping document.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Generated parameterized reports, sub reports, Drill down reports, Drill through reports using SSRS 2008 and 2008 R2.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS 2008 R2.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports which retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: MS SQL Server 2008 R2, SSRS, T-SQL, SSIS, Team Foundation Server (TFS)

Confidential, Des Moines, Iowa

SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Designed Staging Database using SSAS Wizard.
• Involved in requirements gathering, analysis, design, development, change management, deployment.
• Installed and Configured SQL Server 2008 successfully.
• Involved in ER diagrams (Physical and Logical) and mapping the data into database objects.
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
• Involved in upgrading from SQL Server 2008 to SQL Server 2008 R2.
• Utilized SSRS reporting services to generate different types of reports from the database.
• Created OLAP cubes using SSAS to use in business intelligence development.
• Performed Data Analysis for automating various Customers and Order Reports utilizing SQL Reporting Services.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Created KPI Objects in line with Requirement Docs in SSAS.
• Optimized and Aggregated cubes with 40% performance for better performance.
• Processed cube to perform incremental updates.
• Created reports by dragging data from cube and wrote MDX scripts in SSRS.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Designed and deployed report with Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.
• Worked on deploying and scheduling Reports using SSRS as well as triggers to generate all daily, weekly, monthly and quarterly Reports including current status.

Environment: MS SQL Server 2008 R2, SQL Server Reporting Services 2008 R2, SQL Server Integration Services 2008 R2, SQL Server Analysis Services 2008 R2, MS Visio 2007, Windows 7/ Vista and T-SQL.

Confidential, Dublin, OH

MS SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created and modified stored procedures, triggers, views, partition function and schema for table partitioning.
• Designed packages for Extracting, Transforming and Loading (ETL) data from Excel, Flat file and any OLE DB data source to MS SQL Server by using BCP utility and SSIS services.
• Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task, Package Execution task to achieve business needs.
• Monitored and Optimized SSIS package performance to reach the expected timeframe for data loading.
• Used various transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived Column, Slowly Changing Dimension for performing different functionalities of the packages.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using SSRS 2008.
• Created tabular, matrix, chart, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.

Environment: MS SQL Server 2008 R2, SSRS, T-SQL, SSIS.

Confidential, Glen Allen, VA

MS SQL Developer/SSIS/SSRS/SSAS Developer

Responsibilities:

• Planned, Defined and Designed database based on business requirement and provided documentation.
• Coordinated with DBA in creating and managing tables, indexes, triggers, database links and privileges.
• Gathered data and documented it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2005 to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: SQL Server 2008, BIDS, SSRS, SSIS, SSAS, Crystal Reports.