PROFFESSIONAL SUMMARY:

• Over 5 years of IT experience with a strong background in Data warehousing projects design, development and implementation with SQL Server in a high transaction and multi - server production environment.
• 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.
• Expert in creating T-SQL objects, working with DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• 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.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• 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.
• Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal and written communication skills.

TECHNICAL SKILLS:

Languages: C, C#, SQL, T-SQL, SQL Server Tools

Packages: SQL Server Management Studio, Enterprise Manager, Configuration Manager, Query Analyzer, SQL Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent.

Reporting Tools: SSRS, Crystal Reports ETL Tools SQL Server Integration Services (SSIS), SQL Server DTS.

Databases: SQL Server, MS Access, Oracle 11g/9i, DB2

Data Modeling Methodologies: Kimball Star Schema, Snowflake schema. Data Warehousing BI Business Intelligence Studio.

Operating Systems: Windows Server Windows.

PROFESSIONAL EXPERIENCE:

SQL Developer

Confidential, Atlanta, GA

Responsibilities:

• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Created SSIS packages to extract data from different sources to consolidate and merge into one single source.
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-Threading Concepts with Synchronous and Asynchronous transactions.
• Created SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Created different types of SSRS reports like linked reports, tabular reports, charts, sub-reports, drill-down and various parameter-based reports like drop down, Multi-Valued, Multi-select.
• Developed custom ad-hoc reports by using Report Builder, SQL Server Reporting Services (SSRS).
• Created Dashboards using Performance Point Dashboard designer, added different dashboard items like Scorecards, KPI's and Filters.
• Designed, deployed, and maintained complex canned reports using SQL Server 2012 Reporting Services (SSRS)
• Created various Performance Point filters like List, Tree and Multi-Select Tree using different filter
• Created subscriptions to provide a Daily/Monthly/Quarterly basis reports.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS.
• Created usage-based aggregations in cube to minimize time for query retrieval from client tool.
• Managed and troubleshoot report server related issues.
• Created logging, custom logging and error handling packages.

Environment: MS SQL Server 2012/2014, Windows Server, SQL Server Management Studio, Enterprise Manager, Microsoft Project, Profiler, ERWIN, SSRS, SSIS, MS Excel, Visual Studio

SQL Developer

Confidential, Richmond, VA

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.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• 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.
• 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.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Generated Sub-Reports, Cross-tab, Conditional, drill down reports, Drill through reports and Parameterized reports using SSRS.
• 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
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

Environment: T-SQL, MS SQL Server 2012, SQL Server Reporting Services, SQL Server Integration Services, SQL Server DTS, SQL Server Management Studio, Business Intelligence Studio, Query Analyzer, SQL Profiler, Performance Monitor, MS Visio, Windows, ERwin.

SQL Developer

Confidential, New York, NY

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 2008 to SQL Server 2012 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: T-SQL, MS SQL Server 2008, Crystal Reports, SQL Server Integration Services, SQL Server Analysis Services, SQL Server Management Studio, SQL Profiler, Performance Monitor, SQL Server Agent, MS Visio, Windows, Erwin

Jr. SQL Developer

Confidential

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T- SQL in SQL Server 2005.
• Responsible for development of standard reports Using Crystal Reports for the Vendor Sell buyback database and was the key report developer and Product support for the project Validated change requests and made appropriate recommendations.
• Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: T-SQL, SQL Server 2005, SQL Server DTS, Crystal Reports, MS-Office, MS-Excel.