Description
Professional Summary: * About 7 years of strong experience working in agile methodologies of Software Development Life Cycle (SDLC) including design, development, implementation, testing, deployment, and support maintenance. * Strong Knowledge in database design & development, database programming, business process analysis, and application development and Data Modeling skills using MS Visio and ERWIN. * Proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, views, user functions, user profiles, relational database models and data integrity, SQL joins, Table Normalization, Data Import/Export Troubleshooting and query writing. * Data modeling experience focusing on high-activity Normalized transaction systems (OLTP), highly usable Deformalized Reporting Systems (OLAP) as well as staging areas and data marts, Data modeling using Star schema and Snow Flake schema data models. * Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment. * Experience in the development, monitoring and deployment of SSIS packages. Created packages using Import/Export Wizard. Designed Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool. * Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008. * Used the ETL Framework to schedule jobs. Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team. * Strong record of achievements in ERP application design and building architectural standards, technical support, configuration and testing, troubleshooting, and customer service and support of business systems. * Extensive experience in using SQL Server Management Studio and Microsoft office tools such as Advanced Excel (lookups, functions, Pivot Tables & charts), MS Word, MS PowerPoint and MS Visio.
Accomplishments
Highlights:
Keywords
