We provide IT Staff Augmentation Services!

Sr. Sql/msbi Developer Resume

3.00/5 (Submit Your Rating)

Los Angeles, CA

PROFESSIONAL SUMMARY:

  • 10+ years of IT experience working in SQL environment including development System Analysis, Design, Implementation, Data Warehouse, Performance Tuning, Administration and Support of MS SQL Server in Production, QA and Development Environments.
  • Experience installing, configuring, managing, backup, recovery, monitoring and troubleshooting SQL Server.
  • Experience in Performance Tuning and Query Optimization.
  • Experience in Mirroring, Log Shipping, Database Partitioning, Replication and Clustering.
  • Experience in creating Tables, Procedures, Functions, Views and other database objects using SQL and PL/SQL.
  • Excellent experience of managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and reporting tools.
  • Experience in writing Complex T - SQL Queries, Sub queries, Co-related sub queries, Dynamic SQL queries.
  • Experience in converting MS Access queries to SQL Server queries.
  • Extensive Experience in tuning the performance of Stored Procedures and long running queries.
  • Experience in Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
  • Hands on experience in Writing & Debugging Stored Procedures and Triggers, Troubleshooting Database issues and expertise in Production migration of new releases and Enhancements.
  • Extensive experience in Installation, Configuration & Maintenance of Oracle 11g/12c and expert in designing DQ Scorecards and metrics with experience in SQL Loader.
  • Expert in VBA code and applications and created reports using SSRS with MS SharePoint.
  • Experience in Database Backup, Recovery and Disaster Recovery Procedures.
  • Experience in coordinating the work with offshore team.
  • Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.
  • Experience in creating different Power BI Reports across multiple visualizations.
  • Experience in developing Custom Calculated Measures using DAX in Power BI to satisfy business needs.
  • Proficient in Designing Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
  • Experience in installing and configuring Enterprise gateway and Personal gateway in Power BI.
  • Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
  • Experience in design of ETL packages for integrating data from heterogeneous sources like (Excel, Oracle, Flat file, CSV) by using multiple transformations provided by SSIS.
  • Proficient in usage of SSIS Control Flow items (For Each Loop, For Loop & Sequence container, execute package, execute SQL tasks, Script task, send mail task) and transformations (Conditional Split, Data Conversion lookup, Derived Column, Aggregate, Multicast).
  • Hands on experience on ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
  • Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
  • Deployed SSIS packages to different environments.
  • Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and object levels as part of setting up reporting infrastructure.
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports.
  • Experience in using SQL server reporting Services (SSRS) and creating various reports such as Parameterized, Cascading, Tabular, Matrix, Chart and Drill down reports.
  • Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
  • Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services.
  • Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
  • Experience in creating and managing SSAS Tabular models, creating Dimension Tables and Fact Tables.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, Profiler, Export & Import (DTS)

Programming Languages: C#.Net, VB.Net, SQL, T-SQL, PL/SQL, HTML, XML, Bootstrap, JQuery

MS: SQL Server 2000/2005/2008/2012/2014/2016, MS Access 2007 &2010, Oracle 7.x to 11g/12c

Web Technologies: Java Script, ASP.NET, HTML, DHTML, XML.

ETL Tools: Windows NT, 2000 Advanced Server/ Enterprise Server 2003/, Win XP Prof/Standard, Win 98, HP UNIX 10.x, Solaris 8.x and UNIX. MS SQL Server Integration Services (SSIS), Informatica

Reporting Tools: MS SQL Server Reporting Services, SSRS, Crystal Reports, Power BI Desktop, Tableau, PS Query, BEX Analyzer, Web -Application Designer, Report Writer, Cognos 7.0.

DB Design Tools: ERWIN

Office Suite / Tools: MS SharePoint2010/2013, MS Office (Word, Excel, Power Point, Access) 2007/2010

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Sr. SQL/MSBI Developer

Responsibilities:

  • Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
  • Involved in identifying the project stakeholder goals and defining project scope.
  • Identified business objectives and the corresponding business requirements.
  • Created database maintenance plans for monitoring database integrity and performance.
  • Optimized Indexes for better performance by analyzing their Query Plans.
  • Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
  • Developed User Defined Functions for giving Scores and views for the application.
  • Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
  • Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
  • Maintained Batch logging, Error logging tables and handled errors using Event handlers.
  • Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
  • Created Customized reports using Power BI.
  • Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
  • Designed SSIS Packages to extract, transfer, load ( ETL) existing data into SQL Server from different environments for the SSAS cubes.
  • Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Created Roles for SSAS Tabular Model provide additional Security at the row-level by using row-level filters Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Created applications and utilities using PL/SQL.
  • Designed Perspectives and Hierarchies in SSAS Tabular model.
  • Deployed Power Pivot model to SQL server Analysis services tabular instance.
  • Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
  • Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
  • Formatted the reports using the Global variables and expressions.
  • Developed Power BI Reports and Dashboards from multiple data sources using data blending.
  • Developed Custom Calculated Measures using DAX in Power BI to satisfy business needs.
  • Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
  • Installed and configured Enterprise gateway and Personal gateway in Power BI.
  • Implemented Row Level Security by defining various constraints for User Roles.
  • Reviewed and fine-tuned stored procedures and triggers before production migration.
  • Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.
  • Develop ETL audit process and controls to ensure data quality is compliant with defined standards and thresholds.

Environment: MS SQL Server 2016, T- SQL, PowerPivot, MS Excel 2016/2014, SSIS, SSRS, SSAS, Power BI, SQL Server Business Intelligence Development Studio, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, TFS, VSS, Erwin 8.0/MS Visio 2010, Tortoise, SVN.

Confidential, San Diego, CA

Sr. SQL/MSBI Developer

Responsibilities:

  • Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
  • Involved in identifying the project stakeholder goals and defining project scope.
  • Identified business objectives and the corresponding business requirements.
  • Created database maintenance plans for monitoring database integrity and performance.
  • Optimized Indexes for better performance by analyzing their Query Plans.
  • Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
  • Developed User Defined Functions for giving Scores and views for the application.
  • Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
  • Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
  • Maintained Batch logging, Error logging tables and handled errors using Event handlers.
  • Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
  • Created Customized reports using Power BI.
  • Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
  • Designed SSIS Packages to extract, transfer, load ( ETL) existing data into SQL Server from different environments for the SSAS cubes.
  • Involved in SSIS packages Up-gradation from .
  • Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Created Roles for SSAS Tabular Model provide additional Security at the row-level by using row-level filters Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Created applications and utilities using PL/SQL.
  • Designed Perspectives and Hierarchies in SSAS Tabular model.
  • Deployed Power Pivot model to SQL server Analysis services tabular instance.
  • Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
  • Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
  • Formatted the reports using the Global variables and expressions.
  • Reviewed and fine-tuned stored procedures and triggers before production migration.
  • Developed Power BI Reports and Dashboards from multiple data sources using data blending.
  • Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
  • Installed and configured Enterprise gateway and Personal gateway in Power BI.
  • Developed Custom Calculated Measures using DAX in Power BI to satisfy business needs.
  • Implemented Row Level Security by defining various constraints for User Roles.
  • Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.
  • Develop ETL audit process and controls to ensure data quality is compliant with defined standards and thresholds.

Environment: MS SQL Server 2016, T- SQL, PowerPivot, MS Excel 2016/2014, SSIS, SSRS, SSAS, Power BI, SQL Server Business Intelligence Development Studio, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, TFS, VSS, Erwin 8.0/MS Visio 2010, Tortoise, SVN.

Confidential, Culver City, CA

Sr. SQL/MSBI Developer

Responsibilities:

  • Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
  • Involved in identifying the project stakeholder goals and defining project scope.
  • Managed customer expectations for project outcomes to ensure full understanding of risks, trade-offs and scope alterations.
  • Identified business objectives and the corresponding business requirements.
  • Created Business Use Cases and corresponding Atomic Use Cases.
  • Created database maintenance plans for monitoring database integrity and performance.
  • Optimized Indexes for better performance by analyzing their Query Plans.
  • Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
  • Developed User Defined Functions for giving Scores and views for the application.
  • Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
  • Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
  • Maintained Batch logging, Error logging tables and handled errors using Event handlers.
  • Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
  • Created Customized reports using Power BI.
  • Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
  • Designed SSIS Packages to extract, transfer, load ( ETL) existing data into SQL Server from different environments for the SSAS cubes.
  • Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Created Roles for SSAS Tabular Model provide additional Security at the row-level by using row-level filters Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Created applications and utilities using PL/SQL.
  • Designed Perspectives and Hierarchies in SSAS Tabular model.
  • Writing complex DAX functions in Power Pivot.
  • Used various sources to pull data into Power Pivot model.
  • Deployed Power Pivot model to SQL server Analysis services tabular instance.
  • Developed Power BI Reports and Dashboards from multiple data sources using data blending.
  • Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
  • Developed Custom Calculated Measures using DAX in Power BI to satisfy business needs.
  • Installed and configured Enterprise gateway and Personal gateway in Power BI.
  • Implemented Row Level Security by defining various constraints for User Roles.
  • Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
  • Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
  • Formatted the reports using the Global variables and expressions.
  • Reviewed and fine-tuned stored procedures and triggers before production migration.
  • Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.
  • Develop ETL audit process and controls to ensure data quality is compliant with defined standards and thresholds.

Environment: MS SQL Server 2016, T- SQL, PowerPivot, MS Excel 2016/2014, SSIS, SSRS, SSAS, Power BI, SQL Server Business Intelligence Development Studio, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, TFS, VSS, Erwin 8.0/MS Visio 2010, Tortoise, SVN.

Confidential, Richmond, VA

Sr. SQL/MSBI Developer

Responsibilities:

  • Identified business objectives and the corresponding business requirements.
  • Created Business Use Cases and corresponding Atomic Use Cases.
  • Rebuilding the indexes at regular intervals for better performance.
  • Involved in Capacity Planning for databases.
  • Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
  • Developed User Defined Functions for giving Scores and views for the application.
  • Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
  • Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
  • Maintained Batch logging, Error logging tables and handled errors using Event handlers.
  • Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
  • Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
  • Designed SSIS to create ETL Packages to extract, transfer, load ( ETL) existing data into SQL Server, Data warehouse databases from different environments for the SSAS cubes.
  • Involved in SSIS packages Up-gradation from .
  • Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Created Roles for SSAS Tabular Model provide additional Security at the row-level by using row-level filters Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Developed Power BI Reports and Dashboards from multiple data sources using data blending.
  • Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
  • Installed and configured Enterprise gateway and Personal gateway in Power BI.
  • Developed Custom Calculated Measures using DAX in Power BI to satisfy business needs.
  • Implemented Row Level Security by defining various constraints for User Roles.
  • Designed Perspectives and Hierarchies in SSAS Tabular model.
  • Writing complex DAX functions in Power Pivot.
  • Used various sources to pull data into Power Pivot model.
  • Deployed Power Pivot model to SQL server Analysis services tabular instance.
  • Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
  • Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
  • Formatted the reports using the Global variables and expressions.
  • Reviewed and fine-tuned stored procedures and triggers before production migration.
  • Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.
  • Develop ETL audit process and controls to ensure data quality is compliant with defined standards and thresholds.

Environment: MS SQL Server 2012, T- SQL, PowerPivot, MS Excel 2007/2003, SSIS, SSRS, SSAS, Power BI, SQL Server Business Intelligence Development Studio, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, TFS, VSS, Erwin 8.0/MS Visio 2010, Tortoise, SVN.

Confidential, Folsom, CA

Sr. SQL Server Developer /BI Developer

Responsibilities:

  • Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
  • Involved in database Schema design and development.
  • Migrated Database from SQL Server .
  • Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
  • Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
  • Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
  • Executed stored procedures using BATCH files.
  • Developed stored procedures and functions for designing various reports.
  • Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
  • Used Batch Files to Import Data from other Data Base.
  • Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to Data warehouse databases, data mart databases.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
  • Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
  • Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
  • Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
  • Created SSIS packages to retrieve data from Legacy sources and to retrieve PII user data from the Flat files on monthly and weekly basis.
  • Expert in SSIS Deploying and Scheduling
  • Identified and Defined Key Performance Indicators in SSAS 2005/2008.
  • Process SSAS cubes to store data to OLAP databases
  • Integrate SQL Server 2005 reporting services with Microsoft SharePoint Portal Server to deliver automatically generated reports to the Share Point portal.
  • Defined report layouts for formatting the report design as per the need.
  • Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Created reports and Dash boards using Microsoft Performance Point service.
  • Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
  • In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.
  • Administrated the created Reports by assigning permission to the valid user for executing the reports.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2012/2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2010, MS Excel, C#.NET, ProClarity Analysis.

Confidential, Sacramento, CA

SSRS/SSIS Report Developer

Responsibilities:

  • Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
  • Involved in identifying the project stakeholder goals and defining project scope.
  • Managed customer expectations for project outcomes to ensure full understanding of risks, trade-offs and scope alterations.
  • Created and maintained database objects, complex Stored Procedures, Triggers, Cursors, and Tables, Views and SQL joins and other statements for various applications.
  • Performance tuning of the stored procedures, User defined functions and long running queries.
  • Automated the ETL to import and export data form text/ Excel file, in different format, to SQL Server and vice versa using SSIS.
  • Analyzed and designed business processes as per the business requirements with SSRS reports.
  • Created various dynamic reports using SSRS and Crystal reports.
  • Involved in SSIS packages Up-gradation from .
  • Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS) and used the SSAS as source for generating parameterized reports in SSRS.
  • Used ROLAP tools to access the data in a relational database and generate SQL queries to calculate information at the appropriate level when an end user requests it.
  • Created reports and Data access from MDX and OLAP.
  • Created SSIS Packages to pull data from Online Database Server to Data-warehouse Server.
  • Performed administration tasks of Database Mirroring, database backups and restore servers in SQL Server 2005.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
  • Extract Transform Load (ETL) development using SQL Server 2008, SQL 2008 Integration Services (SSIS).
  • Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and Views to other databases or files with proper mapping.
  • Migrating SQL Server 2008 databases into SQL Server 2012.
  • Applied conditional formatting in SSRS to highlight key areas in the report data.
  • Involved in migration of crystal reports to SSRS 2008.
  • Identified the dimension, fact tables and designed the data warehouse using star schema and created complex reports using IREPORTS tool.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
  • Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
  • Created calculated measures and dimension members using multi-dimensional expression (MDX).
  • Maintained HIPAA guidelines.

Environment: MS SQL Server 2005/2008, OLAP, ROLAP, Visual Studio 2005/2008, Windows 2007, Windows XP, T-SQL, XML, Crystal Reports, SSAS, SSRS, SSIS.

Confidential, CA

Sr SQL Server SSIS Developer

Responsibilities:

  • Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
  • Created various Data Interfaces using SSIS 2012 as per the specifications.
  • Migrated packages from SQL Server 2008 to SQL Server 2012 as SSIS packages.
  • Migrated data from heterogeneous data sources (Data mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
  • Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder and MS SharePoint.
  • Created SQL Server Reports based on the requirements using SSRS 2008.
  • Worked on OLAP Data warehouse, Model, Design, and Implementation.
  • Worked on performance point server to create dashboard and scorecards for business intelligence.
  • Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
  • Created complex reports which involve a greater number of groupings and multi-value parameters
  • Converted MS Access queries to SQL Server queries.
  • Created applications and utilities using PL/SQL.
  • Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
  • Created multiple reports with drop down menu option having complex groupings within the report.
  • Worked on content management and document management using MS SharePoint.
  • Worked on relational DBMS and object-oriented DBMS.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
  • Used VB scripting for version control.
  • Handful experience in working with the new concept of Tablix Data Regions in the Report Layout, created a stack of stepped reports using the Tablix.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2012 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, PL/SQL, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Server, UNIX, Office-2007, MS Excel, C#.NET, ProClarity Analysis, MS SharePoint.

Confidential

MS SQL Developer

Responsibilities:

  • Implemented the database for production and marketing purpose.
  • Designed databases for OLTP applications
  • Created tables, indexes and constraints.
  • Created Triggers, Stored procedures for implementing the business logic.
  • Managed Database files, transaction log and estimated space requirements.
  • Configured and monitored database application.
  • Designed and implemented several complex reports
  • Designed VB forms using the forms and crystal reports were made for business reporting purpose.
  • Created stored procedures for module integrity and application.
  • Wrote database triggers in T-SQL to check the referential integrity of the database
  • Managed ongoing activities like importing and exporting, backup and recovery.
  • Administered of all SQL server database objects, logins, users and permissions in each registered server.

Environment: SQL server 2000, Visual Basic 5.0, Win NT.

We'd love your feedback!