SUMMARY

• Highly motivated SQL Server Developer with 6 + years of IT Experience in Database and Business Intelligence Technologies, Reporting Services, Stored Procedure/TSQL coding, Performance and Tuning, Physical and logical Database Design
• Proficient in MS SQL Server suite of products like SSRS and SSIS of MS SQL Server 2005/2008/2012
• Expertise in report generation (automating, managing and security of reports) using SQL Server Reporting Services (SSRS). Created, designed and deployed Tabular, Matrix, Chart, Drill - down and Ad-Hoc reports on report server.
• Excellent skills in High Level Design of and implementing ETL packages using SSIS 2008/2005/2012 for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Merge, Lookup and Union all.
• Good Hands on experience in Data Warehouse Design and analysis of various approaches for maintaining different dimensions and facts in the process of building a data warehouse application.
• Experience in writing Complex Stored Procedures, Indexed Views, DDL/DML Triggers and User defined Functions for data consistency and manipulation.
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas
• Experienced in formatting the SQL Server Reports and in creating configuration files, error handling, and logging in SSIS and in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Hands on experience in Performance Tuning, Query Optimization, Client/Server Connectivity. Good interpersonal Skills result oriented, hardworking with quest and zeal to learn new technologies.
• Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation.
• Understanding of .Net Framework using C# for Web development
• Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools
• Good Understanding of AX and its Layered Architecture
• Excellent knowledge and skills in Dynamics AX Developments
• Good Knowledge on SSRS Reports, Workflows, Frameworks, AIF, EP etc.,
• Skillful in using MS Dynamics Ax 2012 Add on tools.
• Working knowledge on SQL Database Server, very good in data migration using DIXF, good working knowledge on AIF and custom services

TECHNICAL SKILLS

Databases: SQL Server, Teradata, Oracle, DB2, Access

Business Intelligence Tools: SAS, MS SQL Server Management Studio (SSRS, SSIS, SSAS), Tableau, SQL Server Agent, MS Import/Export Wizard, Visual Studio,Power BI

Front End Tools: MS VISIO, MS Project, MS Office Suite (Word, Excel, Powerpoint), TOAD, JIRA, HP Quality Centre, MS Outlook, MS Visio, XML Reader

Document Management: Sharepoint, Documentum, Ultra Edit, Visual Source Surface

Defect Management: HP/ Mercury Quality Center, Test Director, Sharepoint

Methodologies: Kimball/Inmon Data Modeling, Star/Snow flake Schema, Waterfall, Agile Methodology

Scripting Language: SQL, PLSQL, TSQL, XML, C#, VB, ASP .NET, HTML

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

BI Application Developer / SSRS Developer

Responsibilities:

• Gather business requirements, Interact with prospective clients to gather their analytical requirements
• Create Technical Specification requirements (use cases, interface specifications) by translating business requirements
• Develop SSRS Reports based on data being migrated to Eagle Performance Data Mart
• Design Reports Using SQL Server Reporting Services (SSRS) and identify the database tables for defining the queries and datasets for report generation
• Writing complex PL SQL and SQL queries used by SSRS Reports
• Created a C# script code to track the number of id's passing from the Source to destination server
• Creating ad-hoc, matrix, drill through, drilldown and sub- reports based on the requirements
• Created Data Quality Audit Reports to assist the Performance Team with their daily workflow
• Participating in daily meeting and providing status on the reports and SharePoint deployment
• Fixing defects raised by testing team and discuss the scope of the report
• Designing the layouts of the new SSRS reports and discussing it in the meetings with Technical Lead and other team members
• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy.
• Created outbound Performance Attribution date interface from Eagle Performance Data Mart for Narrative Science to support their ability to create commentary for 36 Confidential Funds
• Created Performance Attribution Extracts for a selected group of funds in specific format based on Star Schema Data warehouse for client Narrative Science
• Installation and Configuration of the Microsoft Dynamics Ax2012
• Hands-on experience in migration from MS Dynamics Ax
• Advanced AX development areas such as AIF, SSRS Reports, EP and Workflows.
• Involved in developing logical and physical model of database using Erwin
• Creating and managing schema objects such as tables, views and indexes and Maintaining Referential Integrity
• Developing SSIS Packages to extract data from Eagle Performance Data Mart and Flat Files and load to BI Platform
• Writing Views on top of Star Schema Tables in order to meet End User Requirements
• Creating SSIS Packages to fetch data from BI Platform and to create zip folders of the data files according to each unique Portfolio Id
• Setting up the connection for Production Servers and UAT Servers on SharePoint 2013 in order to deploy all reports on the landing page

Confidential, Chicago, IL

Database Analyst/SSRS Developer

Responsibilities:

• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS). Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS
• Wrote complex SQL Queries used by SSRS Reports
• Implemented Query Optimization techniques in performance tuning. Created various weekly and monthly reports using Table, Matrix and List controls in SQL report Services. Created technical documentation to future reference
• Gathered requirements from the Business Users for SSRS Reports
• Scheduled work sessions to help non-technical team members to understand the SQL queries used to create SSRS Reports and to run various SSIS Packages used by team
• Fixed defects raised by testing team and discuss the scope of the report
• Developed stored procedures, functions and database triggers. Maintained referential integrity and implemented complex business logic.
• Developed and deployed SSIS packages to bring data from Oracle to SQL Server.
• Performance tuning of the existing packages
• Scheduled package run with help of SQL Server Agent tool.
• Worked on Integrations with web services to update currency exchange rates and postal codes in AX.
• Extensively worked on AX database restore and re-setting the configuration after the restore.
• Changed the packages according to the new requirements so that they can fetch data from new tables under new databases
• Managed the daily, weekly and monthly packages for the team
• Worked on complex stored procedures and performance tuning the procedures which are slow
• Creating documents that helps business team to understand various SSIS Packages which they use and creating worksheets that they can use for running the packages on monthly basis

Confidential, Chicago, IL

BI Developer/ SSRS Developer

Responsibilities:

• Converted Crystal Reports to SSRS 2008 format.
• Fixed the bugs in already existing reports.
• Developed Tabular Reports, Matrix Reports, Drill Down Reports and Charts using SQL Server Reporting Services (SSRS)
• Generated Reports using Global Variables, Expressions and Functions for the reports Deployed the generated reports on the Production Server.
• Created Cross-Tab, Drill-down and Sub-Report for the loan policies using SSRS
• Wrote Requirement Documents for the newly created reports and existing crystal reports.
• Gathered requirements from Business Users in order to convert pre-existing Crystal Reports.
• Developed ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2008 SSRS Generated reports from existing SQL Stored Procedures.
• Interacted with QA Team for the converted reports.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008
• Involved in training the other team members for Reporting Services.
• Produced, maintained, and monitored corporate dashboard reports which gather data from multiple servers for executives and external parties throughout the organization for multiple departments.

Confidential, Chicago, IL

BI Developer/QA Analyst (Back End Testing)

Responsibilities:

• Wrote Test Cases in SQL/Oracle to test the migration of data from Legacy data warehouse to Payment Net 4 Oracle database.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2005 Facilitated implementation of automated scripts.
• Participated in cross functional discussions to review the impact of application changes from both internal and external interfaces on the quality of their applications.
• Troubleshoot and resolved the issues occurred in the new datawarehouse feeds.
• Tested data using Beyond Compare tool. Checked for discrepancies in data migrated to PaymentNet4.
• Worked with Offshore team to help them with better understanding of functional requirement document and execution of Test Cases.
• Executed Test cases and was involved in analyzing, retesting and logging the defects on HP Quality Centre.
• Created Test Sets on Quality Centre and Wrote description of each Test Case in order to make them easy to understand for other team members.
• Supported monthly releases as QA Lead. Assigned work to Onshore and Offshore Team and supported team for test execution.
• Transferred data from various sources like MS Excel, MS Access, SQL Server using SSIS and then created reports using this data using SSRS
• Involved in table and index partitioning for performance improvement and manageability and identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers

Confidential, Scranton, PA

BI Developer

Responsibilities:

• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, SQL Server using SSIS and then created reports using this data using SSRS.Created new and converted several Crystal reports into detailed SSRS reports. Debugged reports for the business end users.
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and also helped the front end application developers with their queries.
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers.
• Involved in documentation for all kinds of reports, DTS and SSIS packages.
• Developed trend indicating reports which monitor changes in different categories and record historical analysis and displays them in a single dashboard.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.