SUMMARY

• 7+ years of solid development experience with Microsoft technologies, especially SQL Server and Oracle.
• 5+ years of experience in SSAS, SSIS, SSRS development
• Solid background in relational database design, table design, query/view design, stored procedures, form design, report design, T - SQL, user friendly interfaces.
• Solid troubleshooting and problem solving skills in SQL Server development
• Excellent skills in writing PL/SQL Stored Procedures, Triggers, Packages, Constraints and Fine-Tuning them.
• Strong understanding of SDLC Methodologies such as AGILE methodology.
• Experience with Full Software Development Life Cycle (SDLC).
• Extensively worked with Stored Procedures, Functions and Triggers, Data Mining and Performance tuning using Oracle 9i /11g & SQL Server
• Creating Databases and database objects, creating and managing users and roles.
• Working experience in data modeling and implementing tables, views, stored procedures, functions, and triggers using T-SQL and PL/SQL. Extensive knowledge of writing complex queries using SQL.

TECHNICAL SKILLS

• BI - Data Warehouse
• SSIS
• SSRS
• SSAS
• SQL/PL SQL
• Oracle
• MS Access 2010 and 2007
• Unix / Shell Script
• VBA(Visual Basic for Applications) Programming
• SQL Server ver. 2008/2005 - Database Development
• T-SQL
• Stored Procedures
• Views
• Data Management in Microsoft EXCEL using Macros
• C#
• ASP.Net
• Performance tuning
• Sharepoint
• Business Objects reporting
• Crystal Reports
• XML
• Database Development
• Programming
• Object Oriented Design
• Functionality Testing
• Application Design Life Cycle
• Fit Gap Analysis
• Project Scope Analysis
• Data Migration
• Data Modeling and Data normalization

PROFESSIONAL EXPERIENCE

Confidential, East Lansing, MI

Senior Reports Developer

Responsibilities:

• Analyze the functional & technical requirements and of the project.
• Create new tables, views, materialized views, Packages and functions per the requirements.
• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Analyzed the source data and handled efficiently by modifying the data types.
• Involved in the database design for better understanding the relations, associations and dependencies within the database.
• Evaluated report effectiveness by tuning query data.
• Performed SQL tuning using Explain Plan, Hints and indexes.
• Used excel sheet, flat files, CSV files to generated adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Created query parameters, calculations, conditions and filters in Report Designer.
• Developing parameter page and conditional variables using Report Designer.
• Designed the advance reports, analysis reports and Dashboards as per the client’s requirements.
• Updated Excel files and implemented event handling tasks.
• Maintain SVN repository, deploy code base to QA, UAT, dry-run environments as requested.

Confidential, Chicago, IL

Senior Reports Developer

Responsibilities:

• SQL Server is my primary responsibility creating Stored Procedures and tuning SQL for maximum performance. Create data warehouse tables for data reporting. Create SSIS packages for data migration from various data sources. Also created SSAS analysis cubes for financial analysis. Developed Dundas Dashboards based on analytical models and represented the data in graphs and charts to management. Developed Power View reports and published to Sharepoint. Worked with C# code and developed web parts to present the Power View reports thru Sharepoint.
• Created and optimized stored procedures. Troubleshoot pre-existing stored procedures. Create and deploy tables, views, stored procedures, triggers, functions. Make changes on all database schemas with DDL scripts. Work with cross functional teams to architect database designs for financial reporting. Recommend best practice designs for SQL Server.
• Added indexes where appropriate for optimized queries, defrag and rebuild indexes if needed. Used T-SQL for schema changes, analytics, BI, data modeling, data cleansing.
• Analysis of the requirements for creating Canned Reports using Report Studio.
• Developing Standard Reports, List, Crosstab, Charts, Drill-through Reports, Master Detail Reports, using Report Studio
• Developed and designed Daily, Weekly, Monthly, Quarterly & Annual reports using Report Studio
• Performance tuning and Optimizing
• Evaluated report effectiveness by tuning query data.
• Created query prompts, calculations, conditions and filters in Report Studio.
• Developing prompt pages and conditional variables using Report Studio.
• Developing Dashboards using Business Insight
• Working directly with business partners, developing effectively-balanced design solutions for implementation by a larger Agile development track

Confidential, Chicago, IL

Reports Developer

Responsibilities:

• Created SSRS reports for Claims Reporting. Also created numerous SSRS reports and published to SharePoint for business user’s review. Developed reports like Paid, Unpaid, Denied and Overpaid for Audit Compliance department.
• Used DDL, indexing, stored procedures and tuned queries to improve SSRS performance. Interacted with users for requirements gathering. Participated in design meetings and code reviews. Worked with VBA and Excel Macros for MS Access Reporting.
• Maintained and supported existing software application.
• Performance tuning and PL/ SQL tuning.
• Strong experience with batch processes and complex packages, bulk binding and partitioning.
• Optimization of existing PL/SQL Code.
• Identified and resolved complex application issues and bugs.
• Reviewed and/or wrote code to enhance and/or extend application.
• Provided subject matter expertise in reviewing, researching and resolving business problems presented in requirements specifications.
• Tested new installations and/or software prior to release to minimize failures and impact to business and end users.
• Provided subject matter expertise and business analysis in addressing complex projects and issues.
• Served as a mentor to junior staff.

Confidential, Atlanta, GA

Application Developer

Responsibilities:

• Based upon the functional gatherings, I determined the dimensions and facts that the system would require and designed the data warehouse architecture to reflect the required grain. I used SSIS to extract the data from several source systems and flat files, perform transformations and populate the data warehouse.
• The OLAP cubes were created with SSAS and I created calculated members utilizing MDX to calculate the metrics that were revealed in the functional analysis of the subject matter experts and the system participants.
• Implemented Oracle Modules on Accounts Receivables.
• Created function and technical specification documentation.
• Responsible for configuration of Oracle
• Receivables in development and test environment.
• Tested the application, wrote test case scenarios and did bug fixes.
• Worked in other E-Business Suite, such as, Oracle Bills of material, Payroll, HRMS.
• Involved in configuring up approval levels in Oracle applications
• The reporting was created with SSRS and utilized the cube and MDX to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.