SUMMARY

• Software Professional with total 8 years of IT experience which includes 5 years of experience as SQL developer 3 years in SSRS and 2 years in SSIS.
• Currently working on client requirement Analysis, Physical, Logical design, development (using normalization and SQL Server Enterprise manager), Resource Planning
• Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000 , SSIS, DTS, and SSRS 2005/2008
• Developing in house tools in VBScript interacting with SQL Database
• Using SOAP for Web services results
• Expert in MDM development working past 2 years in MDM development
• Expert in Retail domain and re - insurance domain
• Certified Agile / SCRUM Team member
• Excellent Business Intelligence skills using SSIS and SSRS, DW concepts
• Extensive experience in creating and modifying SSRS complex reports including data manipulation, generating metrics/graphs, drill down and drill through reports
• Extensive experience in developing T-SQL scripts using system defined functions, Joins, Sub- queries
• Aggregate functions, date and string manipulation functions, writing parameterized stored procedures, applying loops and conditional flows, etc.
• Extensive knowledge and experience with SQL query performance tuning
• Expert in Database maintenance
• Good knowledge of VB Scripting
• Good knowledge of Web Services using SOAP UI
• Strong database connectivity skills SQL Server 2012, SQL Server 2008 R2
• Good knowledge of Oracle. Excellent skills in writing Business requirements document (BRD), Use Case Specifications
• Functional Requirement Specifications (FRD), Systems Design Specification, Workflow and Diagram skills
• Expert in MDM on Retail business critical scenarios
• Shown Flexibility, quick learner, proactive attitude and an amazing team player
• Highly efficient in Complex, Agile, Dynamic, Onshore-Offshore project environment
• Basic knowledge of UNIX commands
• Good knowledge of Excel advanced formulas and macros
• Good Knowledge in the complete Software Development Life Cycle (SDLC) including requirements definition, design, testing implementation of major systems

TECHNICAL SKILLS

Software Methodology: AGILE, SAFE Agile, Waterfall

Technologies: Data Warehousing, SSRS, SQL Server, VBScript, Microsoft Excel, Macros, VBA, Oracle

MSBI Tools: SQL Server Reporting Services

Operating Systems: Windows 7/XP/95/98/2000, Windows Server 2003

Database: SQL Server 2008R2, 2005, 2000, DB2, Oracle 9i, 10g

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

SQL Developer

Responsibilities:

• Highly dynamic environment with sprint teams using agile methodology
• Working on the SQL Server 2012 for the data migration involving SSIS packages Managing multiple databases in both SQL Server 2008 and 2012
• Working on SQL Server 2012 and SQL Server 2008 R2
• Creating T-SQL complex queries, stored procedures, triggers, views, tables
• Performance tuning of various SQL queries and SP
• Manage the data present in the database. Developing tables, stored procedures, views, triggers, indexes
• Performance tuning of the T-SQL queries
• Developing SSRS reports depending upon the requirements. Reports include parameterized, drill down, drill through, cascading parameterized reports
• Develop SQL Server 2008 R2 databases and maintain them for the better working of various applications
• Interacting with the Offshore Team members about the project status

Confidential, Temper, FL

SQL and SSRS Developer

Responsibilities:

• Developed SQL stored procedure, Triggers and queries
• Involved in direct interaction with client and understand requirements well. Analyse the requirement and provide with the suitable solution
• Manage more than 15 databases for the claims of various clients
• Develop the process to get the data into the required SQL Server database
• Manage the database by creating tables, Store procedures, view, triggers and functions
• Developing complex stored procedures and queries to manage database
• Worked on T-SQL, stored procedures, views, performance tuning
• Created functional and technical documents of requirements and developed packages

Confidential, Chicago, IL

BI developer

Responsibilities:

• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS
• Writing complex SQL queries to verify results
• To analyze the data and provide suitable solution to it
• Creating stored procedures and tables and views as per the requirements and complex SQL queries
• Involved in the production support team for planning cycle after production implementation.
• Strong ability in developing advancedSQLqueries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted

Confidential

SQL Developer

Responsibilities:

• Debugging and customizing the product level stored procedures
• Developing the reports for the production metrics involving different plants
• Involved in direct interaction with client and understand requirements well. Analyze the requirement and provide with the suitable solution
• To capture data from SQL Server it included complex SPs (stored procedures), views, functions, indexes, triggers and complex queries using joins
• Performed testing of reports, SPs and data validation so that report meets all requirement and standards

Confidential

Progress Front end developer and Progress Database Admin

Responsibilities:

• Customized the tool for Client’s need
• Integration with SAP ERP to receive work orders in XML format
• Processed in JIT/S and storing the details in Progress Database
• Work in highly dynamic environment with changing requirement
• Writing complex SQL queries to verify results
• Facilitated user acceptance testing with business users and utilizing my strong domain expertise

Confidential

Data Warehouse SQL Server 2005, SQL Server 2003

Responsibilities:

• Merging and organizing of client data into a single format
• Cleaning of Client Data through SQL queries
• Writing SQL queries to verify cleansing results
• Data Modelling and Data Load using SQL Server
• Writing Complex SQL Procedures, Triggers and Packages for implementing complex business rules
• SSRS involved complex drill down and drill through reports which involved charts and graphs for the better understanding of end user