SUMMARY

• 7+ years of IT experience in implementation, design, analysis and administration of Business Intelligence solutions with Microsoft SQL server 2008/2005/2000 in production, development and testing environment.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products like SSIS, SSAS, SSRS including MS solutions like MS EXCEL, Microsoft Office.
• Skilled in data warehousing tools, data mapping, unit testing, migration, conversions, and process documentation.
• Experience in various Extracting, Transforming and Loading (ETL) data flows using SSIS with complex integration of SQL with Oracle, flat file sources, MS Access
• Expert in using the work flow canvas for multiple transformations of data and the use of different features like variables, package configurations, event handlers, error logging and check points to facilitate various complex ETL logics and specifications.
• Expert in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, data cleansing, data scrubbing and data migration.
• Experience in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation and data consistency.
• Worked on deployment of databases, and database objects like stored procedure, functions.
• Expertise in T-SQL DDL/DML, performed most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL scripts and batches.
• Good SQL Server administration skills including, backups, disaster recovery, database maintenance, user authorizations, database creation.
• Experience in dimensional data modeling and Cube development, partition, aggregation and optimization using SSAS.
• Thorough understanding of Kimball/Inman strategies, KPI.
• Experience in reporting skills using SQL Server reporting services (SSRS).
• Created and formatted Cross-Tab, Conditional, Drill-down, OLAP, Sub reports, ad-hoc reports, parameterized reports and custom reports.
• Strong knowledge in RDBMS concepts, data warehousing concepts, OLTP and OLAP.
• Experience in providing SSRS server level, item level Security and Accessibility to various reports in multi-user environment.
• Thorough Knowledge on all phases of software development life cycle SDLC.
• Excellent communication skills, analytical skills, understanding business requirements in various domain.

TECHNICAL SKILLS

Database Tools: MS SQL Server 2008/2005/2000 , Oracle 9i/10g, MS Access

Operating systems: Windows NT/98/2000/XP, Windows 2003 Server

Languages: C, XML, HTML, T-SQL, PL/SQL

ETL Tools: DTS, SSIS (SQL Server Integration Services)

Tools: Enterprise Manager, SSMS (Management Studio), BIDS, PPS (Performance Point Server), DTA, SSAS, SQL Profiler, Visio, Microsoft Office.

Reporting Services: SSRS (SQL Server Reporting Services), Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Renton, WA

SQL Server Reporting Server Developer

Responsibilities:

• Worked with project lead, analyst, and business users to understand business processes, documented project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Participated in design meeting regarding the business requirements.
• Worked in Agile Methodology.
• Created ad-hoc queries and reports for unit team lead as requested and provided on-going analytical support for these requests.
• Created projected production and other Execution Reports. Developed yearly and quarterly Production reports.
• Worked with Tabular reports, Matrix reports, Gauges and Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using sql server reporting services(SSRS).
• Designed and developed report with Running value, interactive sorting as well as conditional formatting.
• Created reports using stored procedures, involved in scheduling, creating snapshot and subscription for the reports.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Created sub-reports to present more detailed information about the summary.
• Documented the report process and presented it accordingly.
• Developed complex stored procedures and triggers to facilitate consistent data entry into the database using T-SQL.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition, SSMS, SSIS, SSRS 2008 R2, BIDS, Microsoft Visual studio, Windows server 2003, IIS

Confidential, Newyork City, NY

Sr.Sql Server Developer

Responsibilities:

• Worked with project lead, analyst, and business users to understand business processes, documented project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Created ad-hoc queries and reports for unit team lead as requested and provided on-going analytical support for these requests.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components
• Created projected income Statements and other Financial Reports. Developed yearly and quarterly insurance expense reports.
• Worked with Tabular reports, Matrix reports, Gauges and Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using sql server reporting services(SSRS).
• Designed and developed report with Running value, interactive sorting as well as conditional formatting.
• Created reports using stored procedures, involved in scheduling, creating snapshot and subscription for the reports.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Created sub-reports to present more detailed information about the summary.
• Developed complex stored procedures and triggers to facilitate consistent data entry into the database using T-SQL.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition, SSMS, SSIS, SSRS, BIDS, Oracle 10g, Microsoft Visual studio, Windows server 2003, IIS

Confidential

SQL BI Developer

Responsibilities:

• Gathering requirements, project analysis and review meetings and progress reporting.
• Worked on development of SSIS packages for various inbound/outbound data, OLAP system as well as large volume Data warehouse.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, FuzzyLook Up, ForEach Loop, Multi Cast, column conversion, FuzzyGrouping, Script Components
• Developed and unit test SSIS load processes for performance check
• Created derived columns on the fact and dimension tables as per the business requirements.
• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Created various complex reports and manage them using SQL Server Reporting Services.
• Created SSRS Report Model Projects in BI studio as well as created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Analyzed old reports which were designed using Crystal Reports and transform those reports into SSRS Reports with proper mapping and error handing.
• Worked with .net Developers for developing custom codes for reporting and excel services as well as for creating SQL Server Objects.
• Wrote complex T-SQL scripts, stored procedures, functions and triggers.
• Worked with the Business Analyst via peer reviews and code inspections to ensure code meets the business and system requirements
• Worked with other developers to ensure the code interdependencies are met and fully tested via a formal system test plan.

Environment: Windows 2003 Adv. Server, SQL 2005 Enterprise Edition, SSRS, SSAS, SSIS, VB.Net, EXCEL, ORACLE 10g

Confidential, Hauppauge, NY

Sr.SQL Server Developer/SSRS/SSIS

Responsibilities:

• Migrating SQL Server 2000 DTS Packages to SSIS Packages for uploading various formats of files and data from the legacy databases and SQL Server 2000 to MS SQL Server 2005
• Data warehouse using SQL Server Integration Services (SSIS).
• Create complex scripts to do chucking and massaging of legacy data in staging area of SSIS package.
• Drop and recreate Index on the DSS system while data migrating.
• Schedule Jobs to run SSIS package in night feed to DSS system for fresh day data.
• Used DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Developed complex stored procedures using T-SQL.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Created pivot table to provide structured to Reports in proper manner like months etc.
• Wrote documentation for the packages and scripts and job created for migrate data.
• Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Planning and scheduling backup strategy to ensure reliable backup.
• Involved in creating Database Maintenance Plan for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Environment: SQL Server 2005/2000 enterprise edition, Oracle 10g, BIDS, SSRS, SSIS, Crystal Reports

Confidential

SQL Developer

Responsibilities:

• Designing and implementing the module based on the business requirements given by the business analysts.
• Generating Script files of the databases when ever changes are made to stored procedures or views or any other database objects and checking the objects in VSS.
• Used Visual Studio. Net to run the scripts in different environments of development databases and to check-in the scripts into VSS.
• Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Managing the use of disk space, memory and connections.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Installing SQL Server service packs based on the errors and flaws that are found in the application.
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers and maintaining Referential Integrity.
• Server and Application fine-tuning and trouble shooting. Monitoring MS SQL Server performance and network issues.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Helping Development Team in deploying and testing the application,which uses SQL Server as a database.
• Database and Transaction log backups and restoration, backup strategies, scheduling the backups.
• Backing up system and user databases and restoring them when necessary.

Environment: MS SQL2000, C, UNIX, T-SQL, DTS, Windows XP, Windows Server 2000, MS-Office 2003 Suite.