SUMMARY

• Over 6 Years of experience in IT industry as SQL Developer and BI Developer in Analysis, Design and Business Intelligence projects in Insurance, Financial & Banking, Telecom, Health care domains.
• Good knowledge in the installation and configuration of SQL Server 2008R2/2005.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools, data marts and OLAP technologies.
• Extensive experience in MS SQL Server 2008 R2/2005/2000 working with business intelligence SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services) and SSRS (SQL Server Reporting Services).
• Experience in Creating highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, For Each Loop, Multi Cast, Fuzzy Grouping, Script Components.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS Packages.
• Experience in scheduling Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Transformed database objects from one server to others server using SSIS.
• Migrated XML scripts into SQL server 2008 forming sequenced tables.
• Experience in using Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Experienced in creating Data Driven, Drill Through, Drill Down, parameterized, Tabular and matrix reports.
• Expert in defining Multidimensional Queries (MDX) for generating drill down and parameterized reports in SSRS.
• Experienced in creating charts, graphs using SQL Server 2008/2005 Reporting Services (SSRS).
• Experience in SQL Server Analysis Services and participated in creation of Dimensions, Cubes and Partitions on Cubes, Develop KPIs and Calculations for various Measures.
• Experienced in designing, building and deploying multidimensional cubes using SSAS
• Create and analyzed cube data to generate reports using SSAS for the management to make business decisions.
• Hands on experience in creating OLAP cubes using SQL Server 2005 analysis services (SSAS).
• Experience in SQL Server development with good T - SQL skills with use of database objects, stored procedures, functions.
• Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Experience in Adding/modifying Users, Groups, folders and rights using Report server and Team Foundation Developer.
• Efficient in up gradation and migration from SQL Server 2000 to SQL Server 2005/2008/R2.
• Worked with the team in building the daily dollar, summary, funnel genie, objective and adjustments reports.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Databases: SQL Server 2008/2005/2000 , MS - Access, Oracle,Teradata,DB2

SQL Server Tools: MS SQL Server 2008/2005/2000 , MS-Access, SQL Server Integration Services, Data Transformation Services, SQL Server Analysis Services, OLAP(Online Analytical Processing, Multi-dimensional Cubes and Business Intelligence & Development Studio, Crystal Reports, MS Vision, Erwin

Programming Languages: T-SQL, C#, ASP.Net, Visual Basic 6.0, C, C++.

Operating Systems: Windows 95/98/2000/2003/ XP-Pro, Windows NT, Windows XP/7, UNIX.

Web Technologies and Software: CSS, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

SSIS/SSRS/SSAS developer

Responsibilities:

• Performing source system analysis and development of ETL jobs to migrate data from the Source to the Target Data warehouse and documented source to target mapping.
• In SSIS worked on a workflow which links together modular data-flows as a series of operations in order to achieve a desired result.
• Created different objects like Stored Procedures, User defined functions, Indexes.
• Designed packages using Transformations such as Execute SQL Task, Sequence container, For Each Loop Container, Lookup, OLE DB Command and Derived Column.
• Migrated thedatafromSQLServer2005toSQLServer2008R2..
• Developed, monitored and deployed SSIS packages for data warehouse solution.
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Migrated data from various data sources using SSIS Transformations like Aggregate, Lookup, Conditional-split, Merge Join and Sort.
• Copy, move and delete files using File Transfer Protocol Task.
• Configured Send Mail Task for sending automatic emails when a SSIS package is failed or succeed.
• Start Team is the Team Foundation Server which we used to load all the developed staging packages and persistence packages, QA packages, prod packages, configurations files.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Created Reports in SSRS with different type of properties like Chart controls, Interactive sorting, SQL parameters etc.
• Created Cross-Tab and Sub-Report for the insurance policies using SSRS 2008.
• Created Report Layouts using SSRS 2008.
• Identified and worked with Parameters using complex expressions for parameterized reports and managed report subscription in SSRS 2005, SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Extracted data from cubes to create complex reports according to end user requirements.
• Designed various Cubes as per the requirements for various clients using SSAS.
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• Created Partitions and aggregated cube for better performance.
• Processed cube to perform incremental updates.

Environment: SQL Server 2008R2/2005, SSIS, SSRS, XML, MS Excel, .Net, Visual Studio, C#.

Confidential, San Francisco, CA

BI developer

Responsibilities:

• Extensively involved in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project using SQL Server Integration services.
• Used Joins, sub-queries, Stored Procedures and Indexes for complex queries involving multiple tables from different databases.
• Involved in writing T-SQL Queries to Insert/Update data into the tables.
• Used various SSIS tasks such as Conditional Split, Derived Column and Slowly Changing Transformation which were used for Data validation checks during Staging.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Bulk Insert task, Data flow task, File system task, Send mail task, Active script task, Xml task and also used Import/Export Tool.
• Generated various Report models on Views and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Scheduled reports daily, weekly, monthly for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Created standard and data driven Subscriptions, used report manager for securities.
• Created Report Snapshots to improve the performance of SSRS.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
• Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to the Document Library of SharePoint.

Environment: MS SQL Server 2008R2/2005, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).

Confidential, CA

Microsoft SSIS/SSRS Consultant

Responsibilities:

• CreatedSSISpackages to clean and load data to data warehouse.
• CreatedSSISPackages using Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Worked with XML configuration files and variables for deploying SSIS packages into various environments.
• Implemented slowly changing dimensions according to the requirements and tuned transformations for better performance.
• Defined schemas and created SSIS packages in SQL Server 2008 for the migration process.
• Developed Reports Using SSRS on statistical data during migration of data.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports usingSSRSto generate all daily, weekly, monthly and quarterly Reports including current status.
• Created report models and deployed on report server.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Created report snapshots and cache for better performance.

Environment: SQL Server 2008/2005, Windows 2003 Server, IIS 6.0, SSRS, SSIS, MS Visual Studio,.Net, XML

Confidential, Long Beach, CA

SQL Server/BI Developer

Responsibilities:

• Involved in gathering Business Requirements and System Specifications from users.
• Involved in reverse and forward loading the schema of a database using Erwin.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules.
• Implemented various ETL Jobs and Tasks to support the incremental, historical data loads and transformations using SSIS.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count Transformations.
• Created and used variables and expressions and wrote scripts in script component task.
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Responsible for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services (SSAS).
• Defined appropriate measure groups and KPIs & deployed cubes
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.

Environment: SQL Server 2005, Query Analyzer, T-SQL, Excel, Windows 2000/XP, ProClarity, SharePoint services, Erwin.

Confidential, Chicago, IL

SQL Server/SSIS /SSRS Developer

Responsibilities:

• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Involved in rebuilding views to reduce apparent database complexity for end user and preventing exposure of underlying tables and filtering the bad data accordingly.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Designed complex SSIS packages using appropriate control and data flow elements with SSIS standards like event handling, error handling, logging and working with package configuration files.
• Maintained all records of project status and followed changes as per control procedures.
• Optimized Schema, Performance and Capacity Planning of various Data transformation process.
• Worked on Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS), BCP (Bulk Copy Program) and FTP task in SSIS.
• Performed the tasks of data conversions, lookups, adding derived columns, sending E-mails is done using various tasks in SSIS for the data cleansing and auditing.
• Created reports for users in different departments in the organization using web-enabled services in SSRS.
• Used Report Designer to extract information from one or more files and successfully deployed on various sources like XML, Web browser and PDF.
• Scheduled jobs, Alerts using SQL Server Agent.
• Created Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Designed and developed Various Tabular and Matrix reports using SSRS.

Environment: SQL Server 2005, SSIS 2005, T-SQL, Excel, SSRS 2005, SSIS Tools, Windows 2000/XP, SSAS, Microsoft Visual Studio, VB Scripts.

Confidential

SQL Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Installed and maintained MS SQL Server 2000.
• Analyzed long running queries and tuned the same to optimize application and system performance..

Environment: MS SQLServer2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.