PROFESSIONAL SUMMARY:

• 5 years of professional experience in the IT industry as a MS SQL/BI Developer.
• Highly proficient in the use of T - SQL for developing and debugging complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Worked as a Business Analyst for collecting and analyzing business requirements
• Proven ability in Performance Tuning, Query Optimization and running Database.
• Very Strong in MS SQL Server 2005/2008, 2012 SSRS, SSAS, SSIS packages.
• Worked on data modeling techniques to design the database architecture.
• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions. Expertise with DDL and DML statements, RDBMS, data dictionaries and normal forms.
• Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction log
• Experience in query optimization (SQL tuning) using SQL Profiler, Database Tuning Advisor (DTA), Index tuning wizard and Performance monitor for performance tuning.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS)
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both Relational databases and OLAP cubes.
• Expert in designing and generating reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, matrix, dynamic reports and other features of reporting service.
• Good understanding of Microsoft Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Hands on experience in developing Custom Reports 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).
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, and Linked reports, Snapshot, Cached using SSRS.
• Expert in writing MDX/DAX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experienced in working with Star Schema modeling to develop ROLAP/MOLAP Cubes using SQL Server 2005/2008/2012 Analysis Services.
• Experience in Cube designing in Business Intelligence Development Studio using SSAS.
• Strong experience in defining d relationships in SSAS.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Have good knowledge on Erwin data modeler for analyzing and designing the database.
• Good knowledge of Microsoft access database, Computer Science theory & strong in modern programming languages.
• Have knowledge on Kimball/Inmon methodologies.
• Knowledge on other reporting software’s like MS Excel, MS Access, PowerPoint, and VBA.
• Manage multiple tasks and responsibilities in high-pressure environments.
• Track record of taking projects to successful completion.
• Excellent analytical, problem solving skills and a team worker with a strong customer focus.

TECHNICAL SKILLS:

Database Technologies: SQL Server 2012\2008R2\2008\2005\2000, Oracle 11g/10g/9i

Languages: SQL, T-SQL, PL\SQL, JAVA, C, C++, VB6.0, FOXPRO, SAS

SQL Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Configuration Manager, Database Engine Tuning Advisor, SQL Red Gate Tool.

Oracle Tools: ANSI SQL, Oracle PL/SQL, SQL*Plus, TOAD, ISQL*Plus, SQL*Loader, Oracle procedure Builder

Development Tools: Developer 11g/10g/9i/6i/2000 Release 1 & 2, Reports 10g/9i/6i, Forms 6i/9i/10g

Reporting Tools: Tableau 7/8,Informatica, Jasper Server 1.3/ 4.5, Crystal Reports, Oracle Reports

Scripting Languages: Java Script, UNIX Scripting

Web Technologies: HTML, XML, ASP.NET, C#

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Database Developer

Responsibilities:

• Analyzed the existing tool and participated in meetings with the product owners to gather business requirements and design goals of data warehouse.
• Developed the Legacy and BORS (Back office Recruiter Space) databases, writing complex stored procedures, T-SQL queries
• Worked on creating Entity relation diagrams (ERD) to design the databases. Also, created various database objects like tables, views, UDF’s.
• Involved in database tuning and query optimization techniques to maintain the performance of databases.
• Working on improvising and maintaining the Direct Search/CV database that stores all the information of latest CV updates of candidates.
• Working on profile agents and job agents to send emails to recruiters or candidates, using Selligent Tool. We store the data of actively searching candidates and Job Listings.
• Involved in developing ETL packages using SSIS using multiple data flow tasks and providing project/package level connections
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse/Target Database from heterogeneous sources by properly analyzing and mapping the data.
• Development and deployment of the SSIS 2008R2 packages to maintain update and migrate the data into SSIS 2012 application databases.
• Created packages in SSIS with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created SQL server Agent jobs to schedule the automatic run of SSIS packages to load the databases.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed Various Operational Drill-through and Drill-down reports using SSRS
• Create Parameterized SSRS Reports and Power Pivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database
• Developed different kind of reports like Sub reports, Charts, Matrix reports, Linked reports.
• Created various clustered Indexes, non-clustered Indexes and optimization of queries on tables to improve the performance of the execution
• Wrote stored procedures in SSIS packages and SQL scripts and SSRS reports.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future .
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Participated in Databases Architecture and data modeling design.
• Reviewed and developed data models and database designs with development teams
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Inspected the reports and fixed bugs in stored procedures and tuned Reporting Services to the T-SQL.
• Worked on call support to resolve issues whenever needed.
• Worked on Agile Methodology and Microsoft Team Foundation Server (TFS) and have experience in using Tortoise SVN to keep track of all different versions of source files.
• Used Vulcan/Jira for raising tickets, that keeps track of all the work, done by individuals and gives information about the sprint work by all teams.
• Used Eureka for documentation to easily learn about all the teams in the company and their progress.
• Took in Tableau, Power BI and QlikView to learn additional business processes.

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, PL SQL, MS Access, MS Excel, & Windows 2003 server, Business Intelligence technologies like SSIS, SSRS, Oracle SQL Developer.

Confidential, INDIANAPOLIS

Sr. Business Intelligence Developer

Responsibilities:

• Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse
• Set the business specifications and functional or technical analysis.
• Worked on daily batch loads like Full & Incremental into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Involved in developing ETL packages using SSIS using multiple data flow tasks and providing project/package level connections
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse/Target Database from heterogeneous sources by properly analyzing and mapping the data.
• Have experience to pull the data from Oracle by using Oracle Attunity Connections in SSIS and loading into SQL Server Data warehouse
• Involved in creating calculated members, named set, advanced KPI’s for the SSAS cubes.
• Created several dashboards and scorecards with Key Performance Indicators(KPI) in SQL Server 2005 Analysis Services (SSAS).
• Development and deployment of the SSIS 2008R2 packages to maintain update and migrate the data into SSIS 2012 application databases.
• Created packages in SSIS with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed Various operational Drill-through and Drill-down reports using SSRS
• Create Parameterized SSRS Reports and Power Pivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database
• Developed different kind of reports like Sub reports, Charts, Matrix reports, Linked reports.
• Transform and Load (ETL) data into the data warehouse from heterogeneous sources.
• Created various clustered Indexes, Non clustered Indexes on tables to improve the performance of the execution
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts and SSRS reports.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future .
• Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Worked with Staging Partitions and Usage Based Optimization mechanisms for SSAS OLAP databases.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.
• Wrote MDX/DAX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2008/2008R2/2012.
• Used SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Involved in designing cubes in SSAS environment using Snowflake and Star Schemas.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL server 2008 R2/2012 Analysis Services (SSAS) and SSRS.
• Participated in Databases Architecture and data modeling design.
• Reviewed and developed data models and database designs with development teams
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Developed solutions for programming scenarios using C# .NET.
• Developed and maintained Web Forms using C#.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
• Worked on call support to resolve issues whenever needed.
• Worked on Agile Methodology and Microsoft Team Foundation Server (TFS) and have experience in using Tortoise SVN to keep track of all different versions of source files.
• Took in Power BI and QlikView to learn additional business processes.

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, PL SQL, MS Access, MS Excel, & Windows 2003 server, Business Intelligence technologies like SSIS, SSRS, SSAS, Oracle SQL Developer.

Confidential

SQL Server Developer

Responsibilities:

• Gathered business requirements from business and clients to develop various reports and cubes.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Built SSIS packages with EXCEL and FLAT file source with validations to capture any kind of errors in the source.
• Designed the Database architecture using data modeling techniques
• Created/Updated database objects like tables, views, stored procedures, function, packages,
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Developed table reports, chart reports, line reports, parameterized reports, sub reports using SQL Server Reporting Services 2008.
• Designed reports using Pivot-tables, bar charts, Line-charts and Pie charts on data from cubes and SQL Server in Excel 2007.
• Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using V Lookup and formulas, built PivotTables and Pivot Charts using Power Pivot skill
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Designed and developed packages for data warehouse using Integration Services (SSIS) SQL Server 2008/2008R2.
• Involved in providing ETL support for the production server.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2008R2 as SSIS Packages.
• Involved in creating SSIS jobs to automate the reports generation and cube refresh packages.
• Querying and manipulating multidimensional cube data through MDX Scripting (SSAS).
• Enhanced the functionality of OLAP cube by creating actions and perspectives from huge dataset using SQL Server 2008 Analysis Services.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of T-SQL and MDX/DAX queries.
• Created logical and physical database design, data structures and maintained it by writing stored procedures, user defined functions, views, T-SQL script.
• Optimize the database by creating various clustered, non-clustered indexes and indexed views.

Environment: SQL Server 2008 Enterprise Edition, BIDS, SSAS, SSIS, SSRS, T-SQL, MDX, ETL, VB.Net, ASP.Net, C#, Oracle 9i, Performance Point Server 2007, Erwin 7.2.