SUMMARY:

• About 4 years of experience in project life cycles, including systems analysis, programming, relational database design, system maintenance, data migration, quality assurance, and customer support.
• Extensive knowledge in T - SQL queries (DDL and DML).
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Experienced in creating Tables, Views, Indexes and other SQL joins and query writing.
• Transformed data from various data sources using OLE DB / MS AS connection by creating various DTS packages.
• Created Reports with complex formulas and to query the database for Business Intelligence.
• Good understanding in Oracle 9i/10g Database.
• Responsible for developing drilldown reports using SQL.
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
• Aware of Logical Data Modeling, Data warehouse design concepts, Dimensional Modeling using Star, Snowflake, Normalized and De-normalized Schemas with respect to query and analysis requirements.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, and Report delivery.
• Very strong background in a disciplined software development life cycle (SDLC) process
• Expertise in designing Data Flow task and Work Flow task on SSIS.
• Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources.
• Experience in Creation and deployment of cubes on SSAS.
• Experience in developing User reports and management reports using MS SQL Server Reporting Services (SSRS).
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi site development

PROFESSIONAL EXPERIENCE:

Confidential, Port Washington, NY

SQL developer/BI developer (SSIS/SSRS)

Responsibilities:

• Experience in Extracting, Transforming and Loading (ETL) data from Flat file, excel (spread sheet), MS SQL and oracle to MS SQL Server database by using SSIS services, BCP utility.
• SQL Server 2005 RDBMS database development using T-SQL programming queries, stored procedures, views.
• ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Sound Experience in creating static Dimensions and dynamic Dimensions.
• Experience in Error handling on Control flow task by using Send email task to particular developer and Users. On data flow task putting default dimensions in measures and have them to load on enterprise data warehouse.
• Used different transformation controls like Look up, Conditional split, data conversion, unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.
• Taking weekly database backup and schedules job using SQL Agent.
• Create joins and sub-queries for complex queries involving multiple tables.
• Upgraded the development environment to SQL Server 2008
• Designed data warehouse (logical and physical) using star schema to store information in Data warehouse.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, MS EXCEL

Confidential

SSIS/SSRS Developer

Responsibilities:

• Created SSIS packages to retrieve data from Legacy sources, retrieve user data from the delimited flat files and excel files on quarterly and monthly basis also Transferred Files Using FTP Task.
• Used various SSIS transformations for Data Cleansing to remove unnecessary columns, eliminated
• Redundant and inconsistent data.
• Deployed SSIS packages and Scheduled Jobs.
• Used the Integration services for the purpose of Transforming data from the cubes and storing the data in to the SQL Server data base tables.
• Have experience in writing .NET script in SSIS script task transformation.
• Writing stored procedures, checking the code for efficiency using T-SQL.
• Creation of user Databases and installation of MS SQL Server 2005.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed and Unit Tested various kinds of reports such as Dashboards, Charts, Drilldown, Drill Through, Crosstab, Sub-Reports, Linked Reports, Cascaded Parameter reports with stylish report layouts.
• Developed database objects such as Stored Procedures, User Defined Functions, Tables, Triggers, and Indexes using T-SQL.
• Worked on building the mockup reports using SSRS and Excel for prototype.
• Create reports in SQL server using SSRS as per the requirements provided by the Front End users.
• Used MS Excel for exporting the reports (Pivot Reports) so that they can be slice and dice as per the requirement by the client.
• Testing the Stored Procedures performance and its path of execution by using SQL Profile.

Environment: MS SQL Server 2005, Windows 2003/2007 server, SQL Server Configuration Manager, SQL Server Integration Services 2005 (SSIS), SQL Server Reporting Services 2005 (SSRS), SQL Profiler, SQL Server Management Studio (SSMS)

Confidential, New York, NY

SSRS Developer

Responsibilities:

• Developed reports based on multiple data sources, datasets.
• Developed several tabular reports, matrix reports, lists, sub reports.
• Developed reports in BIDS that includes row-level data, groupings, subtotals, formulas, custom functions, expressions and report parameters.
• Responsible for the design and deployment of the report using SSRS and MS Excel and Access.
• Created Ad Hoc reports by building models in report builder using SQL 2005 model designer and report builder.
• Designed report layouts that suits for the business rules
• Identified and defined the Datasets for report generation
• Developed queries for drill down reports
• Developed reusable reports by passing Parameters based on business needs
• Formatted the reports using Global variables and expressions
• Deployed the generated reports on to the Report Server
• Configured merge replication and Active/Active clustering
• Defined attribute properties in a Parent Child Dimensions
• Developed reports using attributes hierarchies with hiding and disabling
• Maintained data integrity by performing validation checks
• Optimized queries, tuned, and monitored server performance, written T- SQL queries for Data retrieval
• Fine-tuned the database objects and server to ensure efficient data retrieval

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2000, TSQL

Confidential, New York, NY

MS SQL Developer Intern

Responsibilities:

• Developed database objects such as Stored Procedures, User Defined Functions, Tables, Triggers, and Indexes using T-SQL
• Developed stored procedures to achieve specific data needs.
• Created SQL tables with referential integrity and developed queries using SQL.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.
• Involved in documenting the entire technical process.
• Supported technical teams involved with MS SQL issues and operations.
• Involved in the maintenance of the database

Environment: MS SQL 2005, T-SQL