Description :

1. Gathered requirements and performed analysis to support the implementation of BI solutions.
2. Developed dynamic ETL processes using SSIS to integrate data from multiple sources.
3. Created and maintained complex SQL queries and stored procedures for data manipulation.
4. Designed and generated analytical reports using SSRS and Tableau for business intelligence.
5. Troubleshot and optimized SSIS packages, enhancing performance and reliability.
6. Modeled databases and developed data architectures to support reporting needs.
7. Collaborated with cross-functional teams to standardize BI practices and improve data quality.

Experience

5-7 Years

Level

Executive

Education

B.Sc. IT

Description :

1. Collaborated with stakeholders to gather and document business requirements, translating them into technical specifications for database design.
2. Designed and developed database objects, including tables, stored procedures, and functions, ensuring optimal performance and security.
3. Created and maintained indexes to enhance query performance and reduce execution times for critical business reports.
4. Implemented error handling in T-SQL scripts, ensuring robust and reliable data processing.
5. Executed data migration projects, successfully transferring data from Oracle to SQL Server and optimizing ETL workflows.
6. Developed and maintained data models, ensuring alignment with business strategies and objectives.
7. Utilized advanced T-SQL techniques to streamline data retrieval and enhance reporting capabilities.

Experience

7-10 Years

Level

Management

Education

B.S. in CS

Description :

1. Planned and designed data architectures based on business requirements, ensuring comprehensive documentation.
2. Created data mapping documents, DDL scripts, and maintained data dictionaries for clarity and consistency.
3. Developed complex SQL scripts and queries for comprehensive data analysis and extraction.
4. Executed T-SQL scripts, dynamic SQL, and developed stored procedures, functions, and triggers.
5. Engineered efficient ETL processes using SSIS to transition data from sources to the data warehouse.
6. Created SSIS packages for data extraction from OLTP systems, transforming data for OLAP use.
7. Established alerts for monitoring the success or failure of scheduled jobs to ensure reliability.

Experience

10+ Years

Level

Consultant

Education

B.Sc. CS

Description :

1. Collaborated with stakeholders to gather and analyze business requirements for ETL processes and data warehousing needs.
2. Developed and managed SSIS packages for data extraction, transformation, and loading from multiple sources into SQL Server.
3. Conducted thorough SQL programming to create and optimize stored procedures, functions, and triggers to enhance data manipulation.
4. Documented technical specifications and maintained comprehensive documentation for all ETL processes and data models.
5. Participated in the complete Software Development Life Cycle (SDLC), ensuring alignment of technical solutions with business objectives.
6. Performed data quality checks and validations to ensure accuracy and integrity of data within the data warehouse.
7. Provided support and troubleshooting for existing SQL Server applications, ensuring high availability and performance.

Experience

0-2 Years

Level

Entry Level

Education

B.S. CS

Description :

1. Designed and implemented complex database objects, including Tables, Views, and User Defined Functions, to support business applications.
2. Developed ETL processes using SSIS, efficiently loading data from various sources while ensuring data integrity and accuracy.
3. Created and optimized stored procedures for data retrieval and manipulation, significantly improving query performance.
4. Utilized SQL Profiler and execution plans for query optimization, reducing execution time for critical reports by 25%.
5. Managed data migration projects, ensuring seamless integration of new systems with existing databases.
6. Collaborated with cross-functional teams to gather requirements and translate them into technical specifications for BI solutions.
7. Conducted training sessions for end-users on utilizing BI tools and interpreting data reports for informed decision-making.

Experience

7-10 Years

Level

Senior

Education

MSIS

Description :

1. Monitor and troubleshoot performance issues in SQL databases.
2. Implement data security measures to protect sensitive information.
3. Created efficient SQL stored procedures and functions adhering to best practices for data integrity and performance.
4. Conduct data analysis to identify trends and insights for decision-making.
5. Documented database architecture and processes, maintaining up-to-date specifications for system maintenance.
6. Executed complex T-SQL queries for data validation and testing, ensuring accuracy in reporting.
7. Provided mentorship to junior developers, sharing best practices in SSIS and SSRS development.

Experience

5-7 Years

Level

Executive

Education

B.S. in CS

Description :

1. Administered a high-availability SQL Server environment, optimizing performance for financial and CRM applications across multiple locations.
2. Engineered automated maintenance tasks, improving database reliability and performance through regular backups and integrity checks.
3. Developed and managed complex schema objects, ensuring alignment with user specifications and business requirements.
4. Utilize SQL Server Reporting Services (SSRS) for report generation.
5. Created and deployed SSIS packages for seamless data integration from diverse sources, enhancing application data loading processes.
6. Collaborated in the design of reports based on stored procedures, ensuring data delivery meets stakeholder needs.
7. Established report subscriptions, automating regular data distribution and enhancing user accessibility to critical information.

Experience

7-10 Years

Level

Executive

Education

B.Sc. CS

Description :

1. Generated comprehensive reports in accordance with design specifications, ensuring data accuracy and accessibility through effective documentation.
2. Collaborated on the enhancement of Financial and Marketing Reports, delivering actionable insights to management.
3. Employed SSRS to create a variety of reports, including standard and complex formats, facilitating data analysis through features like Drill Down and Drill Through.
4. Developed stored procedures for Fact tables in the data mart, enabling multi-dimensional analysis with SSAS.
5. Integrated ASP.NET web applications with SSRS to pass report variables seamlessly.
6. Designed datasets in SSRS to efficiently call stored procedures, optimizing parameter handling.
7. Maintained SQL Server environments, ensuring optimal performance and reliability.

Experience

5-7 Years

Level

Executive

Education

B.S. in CS

Description :

1. Developed and implemented SSIS packages for seamless data integration from various sources including Excel and SQL Server.
2. Created indexed views and optimized indexes to enhance query performance significantly.
3. Assist in the development of data governance policies and procedures.
4. Applied performance optimization techniques like normalization and indexing to improve batch process efficiency.
5. Designed and built a comprehensive data warehouse to facilitate advanced analytics and reporting.
6. Utilized Script Tasks for file management and variable storage to enhance ETL workflows.
7. Participated in the creation of a robust SSIS model for ETL processes, ensuring data accuracy and integrity.

Experience

2-5 Years

Level

Junior

Education

B.Sc. CS

Description :

1. Participate in data governance initiatives to ensure compliance.
2. Translated functional specifications into technical designs for robust BI solutions.
3. Identified key facts and dimensions for OLAP databases, enhancing data visibility.
4. Created measures and dimensional hierarchies to support complex analytics.
5. Develop and maintain technical documentation for BI solutions.
6. Designed interactive dashboards and reports with drill-down capabilities for end-users.
7. Automated data loading processes from various formats into SQL Server, improving data accessibility.

Experience

7-10 Years

Level

Senior

Education

MSCS

Description :

1. Ensure data quality and integrity through validation and testing.
2. Designed and modeled complex databases, enhancing data integrity and performance.
3. Developed stored procedures, user-defined functions, and triggers using T-SQL for efficient data processing.
4. Created and maintained SSIS packages for ETL processes, transforming data from various sources into a staging database.
5. Utilized control flow and data flow tasks in SSIS to streamline data transformations and integrations.
6. Scheduled and managed ETL jobs using SQL Server Agent, ensuring timely data availability.
7. Prepared comprehensive technical documentation, including High-Level Design and Business Analysis reports.

Experience

10+ Years

Level

Management

Education

M.S. CS

Description :

1. Designed and optimized ETL workflows using SSIS, improving data integration efficiency.
2. Created complex T-SQL queries to analyze and report on business metrics, facilitating data-driven decisions.
3. Managed SQL database security, ensuring compliance with best practices for user access and data protection.
4. Perform data modeling to support BI initiatives and reporting needs.
5. Developed and maintained OLAP cubes in SSAS, enhancing data analysis capabilities.
6. Generated detailed reports in SSRS, utilizing advanced features like dynamic parameters and drill-through actions.
7. Conducted data profiling and validation to ensure accuracy and integrity across various data sources.

Experience

5-7 Years

Level

Executive

Education

B.Sc. CS

Description :

1. Collaborated with users and stakeholders to gather requirements for BI solutions, ensuring alignment with business objectives.
2. Developed and maintained SSRS reports, utilizing T-SQL to create data-driven insights for management.
3. Designed and optimized stored procedures, triggers, and functions to enhance application performance.
4. Collaborate with data engineers to ensure data availability.
5. Created OLAP reports and dashboards using SSRS, enabling real-time data analysis for strategic decision-making.
6. Deployed and managed SSRS reports on Microsoft SharePoint, facilitating easy access for users.
7. Conducted training sessions for team members on BI tools and best practices, fostering a culture of data-driven decision-making.

Experience

2-5 Years

Level

Junior

Education

B.Sc. CS

Description :

1. Gathered business requirements to inform the planning and implementation of data warehousing solutions for enhanced reporting.
2. Ensure timely delivery of BI projects within budget constraints.
3. Developed logical and physical database architectures using Erwin, ensuring optimal design for data storage.
4. Created stored procedures for auditing and triggers for maintaining data consistency across databases.
5. Enhanced query performance by 35% through effective tuning and optimization of indexes using Performance Monitor and Profiler.
6. Evaluated data structures across source and destination databases to ensure data integrity.
7. Engineered complex mappings with SSIS to facilitate data transformation and loading from Oracle to SQL Server.

Experience

2-5 Years

Level

Junior

Education

B.Sc. CS

Description :

1. Led the Extraction, Transformation, and Loading (ETL) of data from multiple sources into a centralized Data Warehouse.
2. Developed complex SSIS packages using various data transformations including conditional splitting and lookup operations.
3. Implemented data validation checks during the staging process to ensure data integrity.
4. Designed and developed STAR Schema dimensional models using ERwin for fact and dimension tables.
5. Executed SSIS packages to migrate data from flat files into SQL Server, generating comprehensive reports using MS SQL Reporting Services.
6. Collaborated with cross-functional teams to gather requirements and optimize BI solutions.
7. Conducted training sessions for end-users on the effective use of BI tools and reporting features.

Experience

7-10 Years

Level

Management

Education

B.Sc. CS

Description :

1. Engineered ETL solutions for the retail sector, improving revenue tracking and analysis.
2. Standardized reporting methods to meet diverse business requirements, enhancing data accessibility.
3. Utilized XML and complex SQL queries to optimize data retrieval in SQL Server.
4. Created and managed schema objects, ensuring data integrity and compliance.
5. Diagnosed and resolved database performance issues, improving application efficiency.
6. Collaborated with business users to analyze source data and refine BI models.
7. Designed and implemented data validation processes to ensure accuracy and consistency.

Experience

5-7 Years

Level

Executive

Education

B.Sc. CS

Description :

1. Developed and maintained comprehensive BI solutions utilizing MS SQL Server, SSIS, and SSRS.
2. Designed ETL processes to ensure efficient data flow from source to destination systems.
3. Executed data migration projects from legacy systems to modern data warehouses.
4. Optimized database performance through indexing and query tuning, resulting in improved application response times.
5. Collaborated with stakeholders to gather requirements and deliver tailored BI reports.
6. Created and documented ETL process flows, ensuring compliance with business requirements.
7. Trained team members on best practices for data management and BI tool usage.

Experience

5-7 Years

Level

Executive

Education

B.Sc. in CS