SUMMARY

• Over 8 years of experience Microsoft DynamicsAX, MicrosoftSQL Server and other related technologies in implementation, upgrade, support, data migration & integration projects. in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/2005/2008/2008 R2/2012.
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading . 7+ years of experience in Analysis, Design, Development and Testing of Client-Server and Web-based n-tier Architecture for windows and web applications using Microsoft .NET Technologies.
• Good Exposure to entire Software Development Life Cycle (SDLC), documentation of software products with Agile Scrum methodology and also experienced in working with waterfall model.
• Extensive experience inMicrosoftDynamicsAxDesign patterns, Tables, Extended Data Types, Views, Forms, Classes, System Queries, Strong Technical experience withMicrosoftAX, X++, Morph X.
• Expertise in MSDynamicsAXtechnical skills with ability to translate functional requirements into technical solutions.
• Implemented, deployed and supportedAXsolutions for customers with 1000+AXusers with multiple subsidiary companies and complex intercompany transactions.
• Hands on experience in AX4.0/AX2009/AX2012&AX 2012 R3 versions.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#,ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting

Databases: MS SQL Server Denali,2014,2012,2008R2,2008,2005,2000

DWH / BI Tools: MicrosoftDynamicsAX2012 R3/ 2009/ 4.0, Morph X, Visual Studio 2013, SQL, SSRS reporting,AX Integrated Data Management Tool (IDMF), Life Cycle Services (LCS),AXData Import/Export Framework (DMF), Performance tools -AXCode Profiler,AX2012 Trace Parser, SQL query profiler, VSS, Team Foundation Server.

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, ProClarity, Microsoft Office(MS), Excel Power Pivot, Excel Data Explorer, Tableau, Power Bi, Cubes(tabular).

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

Microsoft Dynamics AX Developer

Responsibilities:

• Full cycle development inMicrosoftDynamicsAX2012. Installation and Configuration of theMicrosoftDynamicsAX2012.
• Imported opening balances into MSDynamicsAX2012 Application by using X++ scripts and Data Migration Framework.
• Data migrated 12 months wise from other ERP to MSDynamicsAX2012 for new COA and dimensions.
• Created Roles, Duties and privileges in MS Dynamics AX security.
• Created different type of reports including: A Cross-tab, Conditional, Sub report, Drill-down and Parameter prompts, Linked reports and deployed and scheduled Reports in Report Manager using SSRSto generate all daily, weekly, monthly and quarterly Reports including current status
• Interact with Development Teams and Managers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Designed and monitored software performance tests on new and existing programs for the purposes of correcting errors, isolating areas for improvement, and debugging using MSDynamicsAX Debugger.
• Used various Data Flow Transformations like Lookup, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• Responsible for creating SQL datasets forPowerBIand Ad-hoc Reports.
• Install and configuredAxclient in user's machine. Prepared Migration steps from Production to Test usingAX2012 Data Transfer Tool.Deployed and shared the reports with rules and permissions defined on the report manager for data driven subscriptions.

Environment: MS SQL Server 2014/2012, Power BI, SQL Server Integration Services, SQL Server Reporting Services, MicrosoftDynamicsAX2012 R2, R3, SSRS, BOM, X++, SSIS, Application Object Tree (AOT), AIF, DAX Batch Frame works.

Confidential, Atlanta, Georgia

Microsoft Dynamics AX Developer

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views in SQL Server 2000, 2005, 2008.
• Worked onAX& SQL Performance tuning activities using SQL tracer, Profiler, data tuning tools. Implemented IDMF to perform data archive on production SQL database.
• Building new process using X++, SSRS report development, data migration & Integrations with SAP and otherMicrosoftSCM applications using AIF.
• Assess howDynamicsAXtechnologies and methods to ensure architecture meet the needs of the business unit.
• Extensively worked on Microsoft Dynamic AX2012 security design and development.
• Configured Enterprise portal in Ms Dynamics AX Extensively worked on MS Dynamics AXmodules like Manufacturing Modules, Supply Chain Modules, Financial Modules (AP, AR, GL, and FA) and AOT objects.
• Analyze large data sets and patterns using TSQL,PowerBI, advanced Excel models likePower Pivot andPowerQuery to identify opportunities and risks in current operations and define solutions in daily business
• Day to day report server administration Gather requirements across the departments Documentation of requirements

Environment: SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, Web based environment, Morph X environment of X++,MicrosoftDynamicsAX 5.0-2009/6.0-2012 R2, Windows Server 2008.

Confidential, Charlotte, North Carolina

SQL/MSBI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: Windows2003 Advanced Server, ASP.Net, MS SQL Server 2005/2008/2012 /2014 , TSQL, Pl/SQL, Visual Studio 2008,Oracle 11g, SharePoint 2007/2010, SSRS, SSIS, OBIEE.

Confidential, Dallas, TX

Microsoft Dynamics AX Developer

Responsibilities:

• Migrated and resolved conversion errors for Performance Point Server reports to Share point 2010 Business Intelligence platform.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Involved in monitoring onsite and offshore RetailAXdevelopment and Test team.
• Functional Expert inDynamicsAXRetail Essentials, 2012 R3. Expert in setting upAXRetail Store configuration.
• Expert with configuringDynamicsAXPOS withAXdatabaseFunctional.
• Expert inDynamicsAXFull Retail, 2012 R3, considered as SMEThis release is for both domestic and International customers with Multi-currency and Multi-language capabilities similar to R2.
• Involved in triage team to assign bugs to the developers to fix and testers to testReviewed new functional and technical requirements based on the feedback of R2 customers in Retail domain.UsingMicrosoftSure Step methodology.
• Expert inDynamicsRetailAXPOS functionality Monitoring the support of RMS migration toAX2012 for the existing customers to help them switch toDynamicsAX2012 R2Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.

Environment: MS SQL Server 2005/2008/2012 , MicrosoftDynamicsAX2012 R2, R3, SSRS, BOM, X++, SSIS, Application Object Tree (AOT), AIF, DAX Batch Frame works. TSQL, PL/SQL 11g, Visual Studio 2008,2012, SharePoint 2007/2010, SSRS, SSIS.

Confidential

Microsoft Dynamics AX Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.. Installation and Configuration of theMicrosoftDynamicsAX2009.
• Preparation of entity design document and fixing the scope of the functionality.
• Performed extensive development and programming with X++ throughout full life cycle development ofDynamicsAX2009.
• Designing of new forms, tables, reports, jobs and other AOT objects suiting the technical requirements.Created various elements from the AOT (Application Object Tree) like Tables, Extended Data
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to thelocal DB Server using SSIS.
• Enhanced anddeployed the SSIS packagesfrom development server to production server andscheduled jobs.

Environment: MS SQL Server 2008R2, Microsoft Dynamics AX 2009, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, T-SQL

Confidential 

SQL Server Developer

Responsibilities:

• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T - SQL code and SQL joins for applications.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.

Environment: MS SQL Server 2008R2/2008, T-SQL, MS Access, MS Excel,& Windows 2003 server, PL/SQL, Business Intelligent technologies like SSIS, SSRS, SSAS.