SUMMARY

• Around 7 years of experience with database management, SQL development, Software implementation.
• Good Experience working with BI tools SSRS, SSIS, SSAS, DTS.
• Worked with SSRS/Crystal Report XIR2 for creating complicated reports including sub - reports, parameter based reports, graphical reports, formula based, drill down reports, analysis reports.
• Around 4 years of experience in Health care industry.
• Good know of CorePoint and EDI and worked on implementing interfaces using this technology.
• Good knowledge of RDBMS and experience with MS SQL Server 2008/2005/2000 , Oracle, MS Access
• Created effective ETL strategies to Extract, Clean and Deliver Data to it destinations like Dimensions and facts tables on different schemas such as a star or a snow flake schema, and defined the tables that take precedence in this process
• Developed stored procedure, views, triggers and adding/changing tables for data load and transformation, and data extraction and also to fetch the data for the reports from different database like MS SQL Server/Oracle/DB2.
• Good experience in Dimensional modeling using Star Schema/Snowflake modeling concepts and Kimball strategies.
• Experience in using tools like SQL Profiler, Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, Basic programming in C#, C, C++

Database tools: SQL Server 2012/2008/2005 , Oracle 9i/10g/11g, DB2, MS-AccessInternet Technology Basic knowledge of ASP.Net, VB.Net, XML

Applications and Tools: Tier, Microsoft Tools - SQL Server Management Studio, SQL Server Integration(SSIS) Services, SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS),Crystal Reports, Visual Studio 2005/2008,Visual studio Teamsystem, SharePoint Server(MOSS 2007), MS Office, Mat lab, HSpice, NS2, 8085 Simulator, 8031 Debugger, Cadence PKS, HSPICE, MAGIC, Gemini, and IRSIM

Data Modeling Tool: Visio2007

Operating Systems: Windows95/98/2000/XP/Vista, UNIX

PROFESSIONAL EXPERIENCE

Software Engineer /Report Developer

Confidential, Illinois

Responsibilities:

• Involved in designing and implementing the billing system for various clients
• Good knowledge of CorePoint and EDI.
• Implemented various Lab and Pharmacy interfaces using CorePoint and EDI.
• Worked on various data migration projects to migrate the client legacy data to new system using SSIS packages and stored procedures.
• Developed customized stored procedure to handle different needs of the organization using TIER and to create the dataset for complex billing and clinical reports.
• Good experience in gathering the business requirements from clients
• Worked on writing the TDD after gathering the requirements from the client.
• Good experience in handling the Technical support issues in critical cases
• Worked on maintaining the good documentation so that can be used for future
• Worked with product development team to develop new logic and customization for the product to enhance the product features.
• Developed complex billing and clinical reports using Crystal Report and SSRS 2005/2008
• Designed and implemented the security model for the SSRS and Report builder users
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS

SSRS/SQL Developer

Confidential, Los Angeles

Responsibilities:

• Installed and configured SSRS 2008 and report builder 2.0
• Designed and implemented the security model for the SSRS and Report builder users
• Developed Complex SSRS involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs).
• Design, deployment, and maintenance of various SSRS in SQL Server 2008
• Created stored procedures, views, functions that are used by Reports to fetch the data from database
• Build asp.net web application using C# which show the dealers Ads Upgrades to the user,

SSRS/SQL Developer

Confidential

Responsibilities:

• Developed Complex SSRS/CRYSTAL REPORTS involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs).
• Design, deployment, and maintenance of various SSRS/CRYSTAL REPORTS in SQL Server 2005/2008
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS/CRYSTAL REPORTS.
• Added the different types of the charts according to business requirement to enhance the functionality of reports using Crystal Reports/SSRS
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Develop Multidimensional cubes and MDX queries using SSAS for Analysis Services & Reporting Services to set the goals, status and trend of the project.
• Used Team Foundation Server in Visual Studio in order to track and edit bugs been tracked.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.

Confidential

Software Developer

Responsibilities:

• Involved in creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Generated T-SQL scripts for application development.
• Involved in testing the Performance of the database
• Developed SQL script to immigrate data from Excel sheet to sql server 7